amavis TROUBLE in process_request: connect_to_sql

Discussion in 'Installation/Configuration' started by AliMH, Jul 26, 2015.

  1. AliMH

    AliMH New Member

    hey all,
    i searched alot in forum but couldn't find any solution to solve it.
    i installed a fresh debian and ispconfig(nginx) but mails are not working
    here are some logs:
    mail_error.log:
    Code:
    Jul 26 13:21:55 default amavis[21555]: (21555-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 111) line 247.
    Jul 26 13:21:55 default amavis[21734]: (21734-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 111) line 247.
    Jul 26 13:21:55 default amavis[21735]: (21735-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 111) line 247.
    Jul 26 13:26:55 default amavis[21743]: (21743-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 111) line 247.
    Jul 26 13:26:55 default amavis[21745]: (21745-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 111) line 247.
    Jul 26 13:26:55 default amavis[21915]: (21915-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 111) line 247.
    Jul 26 13:26:55 default amavis[21917]: (21917-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 111) line 247.
    mail-warning.log
    Code:
    Jul 26 15:42:34 default postfix/error[8198]: warning: 954DD8717ED: flush service failure
    Jul 26 15:42:34 default postfix/error[8236]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
    Jul 26 15:42:34 default postfix/error[8236]: warning: 902B7871296: flush service failure
    Jul 26 15:44:31 default postfix/proxymap[8277]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'127.0.0.1' (using password: YES)
    Jul 26 15:44:31 default postfix/trivial-rewrite[8278]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "*"
    Jul 26 15:44:31 default postfix/trivial-rewrite[8278]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "*"
    Jul 26 15:44:31 default postfix/error[8279]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'127.0.0.1' (using password: YES)
    Jul 26 15:44:31 default postfix/error[8279]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
    Jul 26 15:44:31 default postfix/error[8279]: warning: B3FD8871ACA: flush service failure
    mail.log
    Code:
    Jul 26 15:47:34 default postfix/error[8421]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
    Jul 26 15:47:34 default postfix/error[8423]: warning: 333CB871263: flush service failure
    Jul 26 15:47:34 default postfix/error[8396]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
    Jul 26 15:47:34 default postfix/error[8421]: warning: 38DE1871898: flush service failure
    Jul 26 15:47:34 default postfix/error[8413]: 3ECAA871A2A: to=<hamzeheslami3273@gmail.com>, relay=none, delay=42561, delays=42559/1.3/0/0.12, dsn=4.4.2, status=deferred (delivery temporarily suspended: lost connection with 127.0.0.1[127.0.0.1] while sending DATA command)
    i got no problem in installation processes but i don't know why mails are not working.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Try to restart mysql.
     
  3. AliMH

    AliMH New Member

    Code:
    root@default / # service mysql restart
    [ ok ] Stopping MySQL database server: mysqld.
    [....] Starting MySQL database server: mysqldNo directory, logging in with HOME=/
    [ .k
    [info] Checking for tables which need an upgrade, are corrupt or were
    not closed cleanly..
    root@default / #
    
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    And is the mail system working now?
     
  5. AliMH

    AliMH New Member

    how can i test it to be sure? i still see new errors in logs
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Login into webmail and send yourself an email.
     
  7. AliMH

    AliMH New Member

    i got this error:
    Code:
    Message not sent. Server replied:
    
        Requested action aborted: error in processing
        451 4.3.5 <localhost.localdomain[127.0.0.1]>: Client host rejected: Server configuration error
     

Share This Page