ZhangHuangbin wrote:- Is mysql running?
- try to send a new testing email, any (new) error in postfix / Dovecot log files?
/var/log/maillog
/var/log/dovecot/*.log
mariadb is running, as was installed with the original iredadmin-pro install
The web interface to the admin panel is working fine and I can see/edit user accounts and server settings, which I believe is all stored in the sql database, so I can only assume that it is all working in that regard.
200923 22:38:19 InnoDB: Initializing buffer pool, size = 128.0M
200923 22:38:19 InnoDB: Completed initialization of buffer pool
200923 22:38:19 InnoDB: highest supported file format is Barracuda.
200923 22:38:28 InnoDB: Waiting for the background threads to start
200923 22:38:29 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 15506855217
200923 22:38:29 [Note] Plugin 'FEEDBACK' is disabled.
200923 22:38:30 [Note] Server socket created on IP: '0.0.0.0'.
200923 22:38:34 [Note] Event Scheduler: Loaded 0 events
200923 22:38:34 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.65-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: active (running) since Thu 2020-09-24 06:03:44 CDT; 25min ago
Process: 1445 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
Process: 1189 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 1444 (mysqld_safe)
Tasks: 23
CGroup: /system.slice/mariadb.service
├─1444 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─1681 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
Sep 24 06:03:02 peggl3.xxxxxxx.com systemd[1]: Starting MariaDB database server...
Sep 24 06:03:11 peggl3.xxxxxxx.com mariadb-prepare-db-dir[1189]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Sep 24 06:03:11 peggl3.xxxxxxx.com mariadb-prepare-db-dir[1189]: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Sep 24 06:03:13 peggl3.xxxxxxx.com mysqld_safe[1444]: 200924 06:03:13 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Sep 24 06:03:14 peggl3.xxxxxxx.com mysqld_safe[1444]: 200924 06:03:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Sep 24 06:03:44 peggl3.xxxxxxx.com systemd[1]: Started MariaDB database server.
Dovecot
dovecot.service - Dovecot IMAP/POP3 email server
Loaded: loaded (/usr/lib/systemd/system/dovecot.service; enabled; vendor preset: disabled)
Active: active (running) since Thu 2020-09-24 06:10:44 CDT; 10min ago
Docs: man:dovecot(1)
http://wiki2.dovecot.org/
Process: 3629 ExecStop=/usr/bin/doveadm stop (code=exited, status=0/SUCCESS)
Process: 3643 ExecStart=/usr/sbin/dovecot (code=exited, status=0/SUCCESS)
Process: 3634 ExecStartPre=/usr/libexec/dovecot/prestartscript (code=exited, status=0/SUCCESS)
Main PID: 3645 (dovecot)
Tasks: 12
CGroup: /system.slice/dovecot.service
├─3645 /usr/sbin/dovecot
├─3648 dovecot/lmtp -L
├─3649 dovecot/anvil
├─3650 dovecot/log
├─3652 dovecot/lmtp -L
├─3653 dovecot/lmtp -L
├─3654 dovecot/lmtp -L
├─3655 dovecot/lmtp -L
├─3656 dovecot/config
├─3659 dovecot/stats
├─4607 dovecot/auth
└─4631 dovecot/ssl-params
Sep 24 06:13:41 peggl3.xxxxxxxx.com dovecot[3650]: imap-login: Login: user=<trent@woodworker.com>, method=PLAIN, rip=xxx.xxx.xxx.59, lip=10.63.33.3, mpid=4058, TLS, session=<CkDjSg2wRMJIt4s7>
Sep 24 06:17:46 peggl3.xxxxxxxx.com dovecot[3650]: pop3-login: Login: user=<carolj@xxxxxxxx.com>, method=PLAIN, rip=xxx.xxx.xxx.42, lip=10.63.33.3, mpid=4383, TLS, session=<NQJ+WQ2wvQky6mEq>
Sep 24 06:17:46 peggl3.xxxxxxxx.com dovecot[3650]: pop3(carolj@xxxxxxxx.com): Disconnected: Logged out top=0/0, retr=0/0, del=0/0, size=0
Sep 24 06:18:01 peggl3.xxxxxxxx.com dovecot[3650]: pop3-login: Login: user=<harryb@xxxxxxxx.com>, method=PLAIN, rip=xxx.xxx.xxx.42, lip=10.63.33.3, mpid=4409, TLS, session=<mqBmWg2wjNky6mEq>
Sep 24 06:18:01 peggl3.xxxxxxxx.com dovecot[3650]: pop3(harryb@xxxxxxxx.com): Disconnected: Logged out top=0/0, retr=0/0, del=0/855, size=72711893
Sep 24 06:18:33 peggl3.xxxxxxxx.com dovecot[3650]: pop3-login: Login: user=<amandaq@xxxxxxxx.com>, method=PLAIN, rip=xxx.xxx.xxx.42, lip=10.63.33.3, mpid=4464, TLS, session=<P99OXA2wm+wy6mEq>
Sep 24 06:18:33 peggl3.xxxxxxxx.com dovecot[3650]: pop3(amandaq@xxxxxxxx.com): Disconnected: Logged out top=0/0, retr=0/0, del=0/68, size=17128131
Sep 24 06:20:10 peggl3.xxxxxxxx.com dovecot[3650]: imap(trent@xxxxxxxx.com): Logged out in=388 out=100298
Dovecot.log
Sep 23 22:56:53 peggl3 dovecot: master: Dovecot v2.2.36.4 (baf9232c1) starting up for pop3, imap, sieve, lmtp (core dumps disabled)
Sep 24 06:03:12 peggl3 dovecot: master: Dovecot v2.2.36.4 (baf9232c1) starting up for pop3, imap, sieve, lmtp (core dumps disabled)
Sep 24 06:03:26 peggl3 dovecot: dict(2083): Error: mysql(127.0.0.1): Connect failed to database (iredadmin): Can't connect to MySQL server on '127.0.0.1' (111) - waiting for 1 seconds before retry
Sep 24 06:03:26 peggl3 dovecot: dict(2083): Error: mysql(127.0.0.1): Connect failed to database (iredadmin): Can't connect to MySQL server on '127.0.0.1' (111) - waiting for 1 seconds before retry
Sep 24 06:03:27 peggl3 dovecot: dict(2083): Error: mysql(127.0.0.1): Connect failed to database (iredadmin): Can't connect to MySQL server on '127.0.0.1' (111) - waiting for 5 seconds before retry
Sep 24 06:03:27 peggl3 dovecot: dict(2083): Error: mysql(127.0.0.1): Connect failed to database (iredadmin): Can't connect to MySQL server on '127.0.0.1' (111) - waiting for 5 seconds before retry
Sep 24 06:03:32 peggl3 dovecot: dict(2083): Error: mysql(127.0.0.1): Connect failed to database (iredadmin): Can't connect to MySQL server on '127.0.0.1' (111) - waiting for 25 seconds before retry
Sep 24 06:03:32 peggl3 dovecot: dict(2083): Error: mysql(127.0.0.1): Connect failed to database (iredadmin): Can't connect to MySQL server on '127.0.0.1' (111) - waiting for 25 seconds before retry
Sep 24 06:10:43 peggl3 dovecot: master: Warning: Killed with signal 15 (by pid=3629 uid=0 code=kill)
Sep 24 06:10:44 peggl3 dovecot: master: Dovecot v2.2.36.4 (baf9232c1) starting up for pop3, imap, sieve, lmtp (core dumps disabled)
postfix.service - Postfix Mail Transport Agent
Loaded: loaded (/usr/lib/systemd/system/postfix.service; enabled; vendor preset: disabled)
Active: active (running) since Thu 2020-09-24 06:03:18 CDT; 15min ago
Process: 1381 ExecStart=/usr/sbin/postfix start (code=exited, status=0/SUCCESS)
Process: 1375 ExecStartPre=/usr/libexec/postfix/chroot-update (code=exited, status=0/SUCCESS)
Process: 1190 ExecStartPre=/usr/libexec/postfix/aliasesdb (code=exited, status=0/SUCCESS)
Main PID: 1946 (master)
Tasks: 5
CGroup: /system.slice/postfix.service
├─1946 /usr/libexec/postfix/master -w
├─1963 pickup -l -t unix -u
├─1964 qmgr -l -t unix -u
├─2153 tlsmgr -l -t unix -u
└─4094 showq -t unix -u
Sep 24 06:16:04 peggl3.xxxxxxxx.com postfix/postscreen[4085]: CONNECT from [xxx.xxx.xxx.114]:44041 to [10.63.33.3]:25
Sep 24 06:16:04 peggl3.xxxxxxxx.com postfix/postscreen[4085]: WHITELISTED [xxx.xxx.xxx.114]:44041
Sep 24 06:16:04 peggl3.xxxxxxxx.com postfix/smtpd[4086]: connect from maild8110372.static.msp.securence.com[xxx.xxx.xxx.114]
Sep 24 06:16:04 peggl3.xxxxxxxx.com postfix/smtpd[4086]: D3E8872404: client=maild8110372.static.msp.securence.com[xxx.xxx.xxx.114]
Sep 24 06:16:04 peggl3.xxxxxxxx.com postfix/cleanup[4093]: D3E8872404: message-id=<64202110.1523330611600946149601.JavaMail.app@rbg32.atlis1>
Sep 24 06:16:05 peggl3.xxxxxxxx.com postfix/qmgr[1964]: D3E8872404: from=<v-cjidian_kgepegcned_gnmkbpbf_gnmkbpbf_a@bounce.em.mscdirect.com>, size=35274, nrcpt=1 (queue active)
Sep 24 06:16:05 peggl3.xxxxxxxx.com postfix/smtpd[4086]: disconnect from maild8110372.static.msp.securence.com[xxx.xxx.xxx.114]
Sep 24 06:16:05 peggl3.xxxxxxxx.com dovecot[4257]: lda(kimberlyb@xxxxxxxx): sieve: from=shopmsc@em.mscdirect.com, envelope_sender=v-cjidian_kgepegcned_gnmkbpbf_gnmkbpbf_a@bounce.em.mscdirect.com, subject=Save on orders ove...
Sep 24 06:16:05 peggl3.xxxxxxxx.com postfix/pipe[4095]: D3E8872404: to=<kimberlyb@xxxxxxxx>, relay=dovecot, delay=0.43, delays=0.28/0/0/0.15, dsn=2.0.0, status=sent (delivered via dovecot service)
Sep 24 06:16:05 peggl3.xxxxxxxx.com postfix/qmgr[1964]: D3E8872404: removed
Amavisd
amavisd.service - Amavis mail content checker
Loaded: loaded (/usr/lib/systemd/system/amavisd.service; enabled; vendor preset: disabled)
Active: active (running) since Thu 2020-09-24 06:03:54 CDT; 28min ago
Docs: http://www.ijs.si/software/amavisd/#doc
Process: 1184 ExecStart=/usr/sbin/amavisd -c /etc/amavisd/amavisd.conf (code=exited, status=0/SUCCESS)
Main PID: 2397 (/usr/sbin/amavi)
Tasks: 5
CGroup: /system.slice/amavisd.service
├─2397 /usr/sbin/amavisd (master)
├─2398 /usr/sbin/amavisd (virgin child)
├─2399 /usr/sbin/amavisd (virgin child)
├─2401 /usr/sbin/amavisd (virgin child)
└─2402 /usr/sbin/amavisd (virgin child)
Sep 24 06:03:02 peggl3.xxxxxxx.com systemd[1]: Starting Amavis mail content checker...
Sep 24 06:03:45 peggl3.xxxxxxx.com amavis[1184]: starting. /usr/sbin/amavisd at peggl3.xxxxxxx.com amavisd-new-2.12.0 (20190725), Unicode aware, LANG="en_US.UTF-8"
Sep 24 06:03:45 peggl3.xxxxxxx.com amavis[1184]: perl=5.016003, user=, EUID: 983 (983); group=, EGID: 976 976 (976 976)
Sep 24 06:03:54 peggl3.xxxxxxx.com systemd[1]: Started Amavis mail content checker.
Sep 24 06:03:54 peggl3.xxxxxxx.com amavis[2397]: Net::Server: Group Not Defined. Defaulting to EGID '976 976'
Sep 24 06:03:54 peggl3.xxxxxxx.com amavis[2397]: Net::Server: User Not Defined. Defaulting to EUID '983'
Sep 24 06:03:54 peggl3.xxxxxxx.com amavis[2397]: No ext program for .lrz, tried: lrzip -q -k -d -o -, lrzcat -q -k
Sep 24 06:03:54 peggl3.xxxxxxx.com amavis[2397]: No decoder for .lrz
I have since follwoed the steps to disable amavisd post on the Ired Forum at https://docs.iredmail.org/completely.di … assin.html
This has not changed anything. After following the steps you first recommended with the amavisd-new -vs- amavisd change, I can no longer send any emails out through the server.
Thunderbird generates the follwoing error now:
Sending of the message failed.
The message could not be sent because the connection to Outgoing server (SMTP) xxx.xxx.xxx.xxx was lost in the middle of the transaction. Try again.
As I stated previously, for some strange reason, at random a email will suddenly make it through to a client.
I am completely baffled at how running a yum update, could cause all this.
Prior to that event, this server had zero issues.
Our entire company has been down for two days and I need a solution.
Is there a way to move all our accounts to a new server?