Changing MYSQL Root password causes postfix errors
I am having a very perplexing issue, When changing the root mysql password, I get the following errors.
Apr 26 08:37:25 mailXXXXX postfix/trivial-rewrite: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|ld_fix): table lookup problem
The postfix service is set to use the ispconfig account not the root account. Is there any other place I need to be change the root password besides
user = ispconfig
password = XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
dbname = dbispconfig
table = mail_domain
select_field = domain
where_field = domain
additional_conditions = and active = 'y' and server_id = 6
hosts = 127.0.0.1
Do you get any errors in the mysql log files?
No , there where no errors in the database log. It happened on both our mail servers. Changing the root mysql password back fixed the issue.
130418 8:28:13 [Note] Plugin 'FEDERATED' is disabled.
130418 8:28:13 InnoDB: Initializing buffer pool, size = 256.0M
130418 8:28:13 InnoDB: Completed initialization of buffer pool
130418 8:28:13 InnoDB: Started; log sequence number 2 4163329206
130418 8:28:13 [Note] Event Scheduler: Loaded 0 events
130418 8:28:13 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.63-0ubuntu0.11.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
130426 8:37:22 [Note] /usr/sbin/mysqld: Normal shutdown
130426 8:37:22 [Note] Event Scheduler: Purging the queue. 0 events
130426 8:37:23 InnoDB: Starting shutdown...
130426 8:37:29 InnoDB: Shutdown completed; log sequence number 2 4163389218
130426 8:37:29 [Note] /usr/sbin/mysqld: Shutdown complete
Apr 26 08:39:48 mail2 postfix/smtpd: 801AA9A1C6: reject: END-OF-MESSAGE from mail.XXX.com[000.000.220.176]: 450 4.7.1 <END-OF-MESSAGE>: End-of-data rejected: Access denied; from=<lee.veal@XXX.com> to=<firstname.lastname@example.org> proto=ESMTP helo=<mail.XXX.com>
---Changed mysql root password back----
Apr 26 08:43:53 mail2 amavis: (19709-01-4) Passed CLEAN, <lee.veal@XXX.com> -> <email@example.com>, Message-ID: <CALoHdz9k4mwcNiuZBq8cv8TqQ82TDewW5ReXKoSM0mNZ4GPi mQ@mail.XXX.com>, mail_id: C9wvACEfpFkO, Hits: -0.097, size: 1729, queued_as: EB6A59BB07, dkim_id=@XXX.com, 5145 ms
Im going to turn up logging on mysql, maybe it will shed some light on the issue. Thank you for confirming the password reset process.
I have no idea at the moment how the root password change can be related to the postfix error. You might want to search with grep if the root user or password is used in one of the postfix files. E.g.:
grep root /etc/postfix/*
grep 'mysecretrootpassword' /etc/postfix/*
turned out to be policyd set to use the root account (scary) I have set it to use the correct user and it is working now. Thank you for your help in resolving this issue.
|All times are GMT +2. The time now is 05:02.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.