Changing MYSQL Root password causes postfix errors

Discussion in 'ISPConfig 3 Priority Support' started by lee.veal, Apr 26, 2013.

  1. lee.veal

    lee.veal HowtoForge Supporter

    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
     
  2. till

    till Super Moderator

    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?
     
  3. lee.veal

    lee.veal HowtoForge Supporter

    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: <CALoHdz9k4mwcNiuZBq8cv8TqQ82TDewW5ReXKoSM0mNZ4GPimQ@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.
     
  4. till

    till Super Moderator

    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/*
     
  5. lee.veal

    lee.veal HowtoForge Supporter

    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
     

Share This Page