HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   ISPConfig 3 Priority Support (http://www.howtoforge.com/forums/forumdisplay.php?f=35)
-   -   Changing MYSQL Root password causes postfix errors (http://www.howtoforge.com/forums/showthread.php?t=61620)

lee.veal 26th April 2013 15:30

Changing MYSQL Root password causes postfix errors
 
Hello All,

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[16927]: 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

/usr/local/ispconfig/server/lib/mysql_clientdb.conf



#cat /etc/postfix/mysql-virtual_domains.cf
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

till 26th April 2013 16:13

Quote:

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

/usr/local/ispconfig/server/lib/mysql_clientdb.conf
No, thats the only place. All other services (postfix, dovecot or courier, pure-ftpd and the ispconfig interface and server script) are using the user ispconfig. The mysql root password in mysql_clientdb.conf is only used to create new mysql users and databases from within ispconfig.

Do you get any errors in the mysql log files?

lee.veal 26th April 2013 16:44

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.


MYSQL log:
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


mail.log:
Apr 26 08:39:48 mail2 postfix/smtpd[17378]: 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=<lee@xxxx.net> proto=ESMTP helo=<mail.XXX.com>

---Changed mysql root password back----

Apr 26 08:43:53 mail2 amavis[19709]: (19709-01-4) Passed CLEAN, <lee.veal@XXX.com> -> <lee@xxxx.net>, 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.

till 26th April 2013 17:02

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/*

or

grep 'mysecretrootpassword' /etc/postfix/*

lee.veal 26th April 2013 18:31

Resolved*

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.

Lee:D


All times are GMT +2. The time now is 00:25.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.