postfix error - mariaDB ispconfTable problem

Discussion in 'Installation/Configuration' started by kameleon1er, Jun 25, 2022.

  1. kameleon1er

    kameleon1er Member

    IspConf 3.2 / Debian Buster
    Hi, still have problems with postfix. Yesterday, it was ok, but today not.
    I restart mysql, amavis, postfix, mails pass again, but I find that it's not very stable
    Code:
    amavis.service - LSB: Starts amavisd-new mailfilter
    
       Loaded: loaded (/etc/init.d/amavis; generated)
       Active: failed (Result: start-limit-hit) since Fri 2022-06-24 20:49:43 UTC; 17h ago
         Docs: man:systemd-sysv-generator(8)
      Process: 14908 ExecStart=/etc/init.d/amavis start (code=exited, status=0/SUCCESS)
      Process: 14935 ExecStop=/etc/init.d/amavis stop (code=exited, status=0/SUCCESS)
    
    Jun 24 20:49:43 srv-b.democrasite.com amavis[14924]: No decoder for       .zoo
    Jun 24 20:49:43 srv-b.democrasite.com amavis[14924]: Using primary internal av scanner code for ClamAV-clamd
    Jun 24 20:49:43 srv-b.democrasite.com amavis[14924]: Found secondary av scanner ClamAV-clamscan at /usr/bin/clamscan
    Jun 24 20:49:43 srv-b.democrasite.com systemd[1]: Stopping LSB: Starts amavisd-new mailfilter...
    Jun 24 20:49:43 srv-b.democrasite.com amavis[14935]: Stopping amavisd: amavisd-new.
    Jun 24 20:49:43 srv-b.democrasite.com systemd[1]: amavis.service: Succeeded.
    Jun 24 20:49:43 srv-b.democrasite.com systemd[1]: Stopped LSB: Starts amavisd-new mailfilter.
    Jun 24 20:49:43 srv-b.democrasite.com systemd[1]: amavis.service: Start request repeated too quickly.
    Jun 24 20:49:43 srv-b.democrasite.com systemd[1]: amavis.service: Failed with result 'start-limit-hit'.
    Jun 24 20:49:43 srv-b.democrasite.com systemd[1]: Failed to start LSB: Starts amavisd-new mailfilter.
    Code:
    service amavis status
    ● amavis.service - LSB: Starts amavisd-new mailfilter
       Loaded: loaded (/etc/init.d/amavis; generated)
       Active: active (running) since Sat 2022-06-25 14:21:18 UTC; 3s ago
         Docs: man:systemd-sysv-generator(8)
      Process: 19871 ExecStart=/etc/init.d/amavis start (code=exited, status=0/SUCCESS)
        Tasks: 3 (limit: 4915)
       Memory: 154.6M
       CGroup: /system.slice/amavis.service
               ├─19886 /usr/sbin/amavisd-new (master)
               ├─19887 /usr/sbin/amavisd-new (virgin child)
               └─19888 /usr/sbin/amavisd-new (virgin child)
    
    Jun 25 14:21:18 srv-b.democrasite.com amavis[19886]: No ext program for   .rpm, tried: rpm2cpio.pl, rpm2cpio
    Jun 25 14:21:18 srv-b.democrasite.com amavis[19886]: No ext program for   .rar, tried: unrar-free
    Jun 25 14:21:18 srv-b.democrasite.com amavis[19886]: No ext program for   .zoo, tried: zoo
    Jun 25 14:21:18 srv-b.democrasite.com amavis[19886]: No ext program for   .doc, tried: ripole
    Jun 25 14:21:18 srv-b.democrasite.com amavis[19886]: No decoder for       .F
    Jun 25 14:21:18 srv-b.democrasite.com amavis[19886]: No decoder for       .doc
    Jun 25 14:21:18 srv-b.democrasite.com amavis[19886]: No decoder for       .lz4
    Jun 25 14:21:18 srv-b.democrasite.com amavis[19886]: No decoder for       .zoo
    Jun 25 14:21:18 srv-b.democrasite.com amavis[19886]: Using primary internal av scanner code for ClamAV-clamd
    Jun 25 14:21:18 srv-b.democrasite.com amavis[19886]: Found secondary av scanner ClamAV-clamscan at /usr/bin/clamscan
    Code:
    srv-b dovecot: auth-worker(976): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) - waiting for 1 seconds before retry
    Jun 22 17:58:53 srv-b dovecot: auth-worker(976): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) - waiting for 1 seconds before retry
    Jun 22 17:58:54 srv-b dovecot: auth-worker(976): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) - waiting for 5 seconds before retry
    Jun 22 17:58:54 srv-b dovecot: auth-worker(976): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) - waiting for 5 seconds before retry
    Jun 25 14:11:47 srv-b dovecot: auth-worker(10745): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2) - waiting for 1 seconds before retry
    Jun 25 14:11:47 srv-b dovecot: auth-worker(10745): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2) - waiting for 1 seconds before retry
    Jun 25 14:11:48 srv-b dovecot: auth-worker(10745): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2) - waiting for 5 seconds before retry
    Jun 25 14:11:48 srv-b dovecot: auth-worker(10745): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2) - waiting for 5 seconds before retry
    Jun 25 14:12:32 srv-b dovecot: auth-worker(10745): Error: sql([email protected],212.70.149.66): Password query failed: MySQL server has gone away (idled for 11 secs)
    Jun 25 14:20:59 srv-b dovecot: auth-worker(10745): Error: sql([email protected],91.173.88.232,<DnJTZUbi0XBbrVjo>): Password query failed: MySQL server has gone away (idled for 60 secs)
    
    Code:
    # The MariaDB configuration file
    #
    # The MariaDB/MySQL tools read configuration files in the following order:
    # 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
    # 2. "/etc/mysql/conf.d/*.cnf" to set global options.
    # 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
    # 4. "~/.my.cnf" to set user-specific options.
    #
    # If the same option is defined multiple times, the last one will apply.
    #
    # One can use all long options that the program supports.
    # Run program with --help to get a list of available options and with
    # --print-defaults to see which it would actually understand and use.
    
    #
    # This group is read both both by the client and the server
    # use it for options that affect everything
    #
    [client-server]
    
    # Import all .cnf files from configuration directory
    !includedir /etc/mysql/conf.d/
    !includedir /etc/mysql/mariadb.conf.d/
    
    [mysqld]
    socket=/var/run/mysqld/mysqld.sock
    [client]
    socket=/var/run/mysqld/mysqld.sock
    Code:
    2022-06-25 14:20:15 0 [Note] InnoDB: 10.3.34 started; log sequence number 146108860328; transaction id 104969112
    2022-06-25 14:20:15 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
    2022-06-25 14:20:15 0 [Note] Plugin 'FEEDBACK' is disabled.
    2022-06-25 14:20:15 0 [Note] InnoDB: Buffer pool(s) load completed at 220625 14:20:15
    2022-06-25 14:20:15 0 [Note] Server socket created on IP: '::'.
    2022-06-25 14:20:15 0 [Note] Reading of all Master_info entries succeeded
    2022-06-25 14:20:15 0 [Note] Added new Master_info '' to hash table
    2022-06-25 14:20:15 0 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '10.3.34-MariaDB-0+deb10u1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Debian 10
    2022-06-25 14:20:29 238 [Warning] Aborted connection 238 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets)

     
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    How much RAM do you have?
     
  3. kameleon1er

    kameleon1er Member

    Hi @Th0m ,
     
  4. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

    Look through your MySQL log messages to see what it was failing to start.
     

Share This Page