Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > ISPConfig 3 Priority Support

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 26th April 2013, 16:30
lee.veal lee.veal is offline
Member
 
Join Date: Apr 2013
Posts: 34
Thanks: 6
Thanked 5 Times in 5 Posts
Unhappy 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
Reply With Quote
Sponsored Links
  #2  
Old 26th April 2013, 17:13
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts
Default

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?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
lee.veal (26th April 2013)
  #3  
Old 26th April 2013, 17:44
lee.veal lee.veal is offline
Member
 
Join Date: Apr 2013
Posts: 34
Thanks: 6
Thanked 5 Times in 5 Posts
Smile

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.
Reply With Quote
  #4  
Old 26th April 2013, 18:02
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts
Default

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/*
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
lee.veal (26th April 2013)
  #5  
Old 26th April 2013, 19:31
lee.veal lee.veal is offline
Member
 
Join Date: Apr 2013
Posts: 34
Thanks: 6
Thanked 5 Times in 5 Posts
 
Talking

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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Fail2ban error nokia80 Installation/Configuration 15 21st February 2012 05:49
Problem installing suPHP sojic Installation/Configuration 4 31st May 2010 16:24
Postfix email server problems Access denied 554 554 5.7.1 state 14 AceRimmer Server Operation 4 19th June 2008 15:36
Wrong steps by upgrading ISPC Berry Installation/Configuration 14 14th November 2007 17:27
Add Webmin to the system sushestvo Installation/Configuration 44 21st August 2007 17:52


All times are GMT +2. The time now is 08:56.


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