Ispconfig 3 mail not working

Discussion in 'Installation/Configuration' started by ninjao, Oct 2, 2009.

  1. ninjao

    ninjao New Member

    Hi,

    I have a fresh install of ISPconfig 3. I have created mail accounts and set it up like I think it should be... mxtoolbox.com says that im ok..

    however nothing works. No internal mail, no external mail.

    But heres the kicker, when i rebooted the server the mail was sent... wtf?

    My DNS records are:

    A epibrate.com. 87.98.171.221 0
    A mail 87.98.171.221 0
    A www 87.98.171.221 0
    MX epibrate.com. epibrate.com. 10
    NS epibrate.com. r28466.ovh.net. 0
    NS epibrate.com. snds1.ovh.net. 0

    Are those correct?

    Please feel free to ask questions i will be monitoring this thread and will reply very quickly!

    Thanks!
     
  2. falko

    falko Super Moderator ISPConfig Developer

    Any errors in your mail log?
     
  3. ninjao

    ninjao New Member

    Code:
    Oct  3 04:50:01 stock pop3d: Connection, ip=[::ffff:127.0.0.1]
    Oct  3 04:50:01 stock pop3d: Disconnected, ip=[::ffff:127.0.0.1]
    Oct  3 04:50:02 stock imapd: Connection, ip=[::ffff:127.0.0.1]
    Oct  3 04:50:02 stock imapd: Disconnected, ip=[::ffff:127.0.0.1], time=0
    Oct  3 04:50:02 stock postfix/smtpd[23017]: connect from localhost.localdomain[127.0.0.1]
    Oct  3 04:50:02 stock postfix/smtpd[23017]: lost connection after CONNECT from localhost.localdomain[127.0.0.1]
    Oct  3 04:50:02 stock postfix/smtpd[23017]: disconnect from localhost.localdomain[127.0.0.1]
    Oct  3 04:50:48 stock postfix/qmgr[4407]: 85BE6CECF3: from=<www-data@r28466.ovh.net>, size=993, nrcpt=1 (queue active)
    Oct  3 04:50:48 stock postfix/qmgr[4407]: 12A93CECF2: from=<www-data@r28466.ovh.net>, size=794, nrcpt=1 (queue active)
    Oct  3 04:50:48 stock amavis[22388]: (22388-01) (!)connect_to_sql: unable to connect to DSN 'DBI:mysql:database=dbispconfig;host=127.0.0.1;port=3306':Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Oct  3 04:50:48 stock amavis[22388]: (22388-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 86) line 241,<GEN26> line 3.
    Oct  3 04:50:48 stock amavis[22388]: (22388-01) (!)Requesting process rundown after fatal error
    Oct  3 04:50:48 stock amavis[22389]: (22389-01) (!)connect_to_sql: unable to connect to DSN 'DBI:mysql:database=dbispconfig;host=127.0.0.1;port=3306':Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Oct  3 04:50:48 stock amavis[22389]: (22389-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 86) line 241,<GEN26> line 3.
    Oct  3 04:50:48 stock amavis[22389]: (22389-01) (!)Requesting process rundown after fatal error
    Oct  3 04:50:48 stock postfix/smtp[23066]: 85BE6CECF3: to=<email>, relay=127.0.0.1[127.0.0.1]:10024, delay=54995, delays=54994/0.01/0.01/0.49, dsn=4.3.2, status=deferred (host 127.0.0.1[127.0.0.1] said: 421 4.3.2 Service shutting down, closing channel (in reply to RCPT TO command))
    Oct  3 04:50:48 stock postfix/smtp[23067]: 12A93CECF2: to=<epibrate@gmail.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=54993, delays=54992/0.02/0.01/0.75, dsn=4.3.2, status=deferred (host 127.0.0.1[127.0.0.1] said: 421 4.3.2 Service shutting down, closing channel (in reply to RCPT TO command))
    Oct  3 04:55:02 stock imapd: Connection, ip=[::ffff:127.0.0.1]
    Oct  3 04:55:02 stock imapd: Disconnected, ip=[::ffff:127.0.0.1], time=0
    Oct  3 04:55:02 stock pop3d: Connection, ip=[::ffff:127.0.0.1]
    Oct  3 04:55:02 stock pop3d: Disconnected, ip=[::ffff:127.0.0.1]
    Oct  3 04:55:02 stock postfix/smtpd[599]: connect from localhost.localdomain[127.0.0.1]
    Oct  3 04:55:02 stock postfix/smtpd[599]: lost connection after CONNECT from localhost.localdomain[127.0.0.1]
    Oct  3 04:55:02 stock postfix/smtpd[599]: disconnect from localhost.localdomain[127.0.0.1]
    Oct  3 04:55:48 stock postfix/qmgr[4407]: 831D1CED02: from=<support@epibrate.com>, size=737, nrcpt=1 (queue active)
    Oct  3 04:55:48 stock postfix/qmgr[4407]: D9BE8CECFB: from=<www-data@r28466.ovh.net>, size=1000, nrcpt=1 (queue active)
    Oct  3 04:55:48 stock postfix/qmgr[4407]: 6CBF5CECFA: from=<www-data@r28466.ovh.net>, size=801, nrcpt=1 (queue active)
    Oct  3 04:55:48 stock amavis[23070]: (23070-01) (!)connect_to_sql: unable to connect to DSN 'DBI:mysql:database=dbispconfig;host=127.0.0.1;port=3306':Access denied for user 'ispconfig'@'localhost' (using password: YES)
    p.s. du kannst auch in deutsch antworten wenn das leichter für dich ist! :) danke nochmal!
     
    Last edited: May 9, 2010
  4. falko

    falko Super Moderator ISPConfig Developer

    Please check if the MySQL user and password are correct in your amavisd configuration.
     
  5. ninjao

    ninjao New Member

    Hi thanks for the reply,

    I tried to find the config file but was unsuccessful.

    :/# locate amavisd.conf
    /usr/share/doc/amavisd-new/examples/amavisd.conf-default.gz
    /usr/share/doc/amavisd-new/examples/amavisd.conf-sample.gz

    Locate also only seems to find that? Maybe that is the problem.

    Also I never actually defined or setup amavisd... was this done automatically by ISPconfig?

    I don't know if you are familiar with the hosting provider OVH.co.uk but I am using an RPS server of theirs which comes with a pre-installed ISPconfig 3 distribution. So I didnt install any of this stuff myself.

    Any Idea how I might proceed?
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Which Linux distribution do you use?
     
  7. ninjao

    ninjao New Member

    Operating system: Ispconfig 3 (Debian 5.0 Lenny) BETA

    My server provider calls the OS Ispconfig 3... but I assume thats just to make it sound like it's the best choice for hosting providers.
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, under debian the file that falko mentioned is named 50-user and it should be in the directory /etc/amavisd/conf.d/ or similar.

    But the easiest fix should be to download just the latest ispconfig 3.0.1.4 version and run the update.php script as described in the manual update instructions here:

    http://www.howtoforge.com/forums/showthread.php?t=38795

    Then during update choose yes if you were ask to reconfigure the services. This should fix the amavisd configuration too.
     
  9. ninjao

    ninjao New Member

    Ok ive gone with the updater and it updates until it asks for the mysql password.

    I have never set it up except for the mysql database for my website.. but I think this wants the mysql database for root.

    I tried entering my root password to no avail.

    mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

    Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) in /tmp/ispconfig3_install/install/lib/mysql.lib.php on line
    78

    Fatal error: Cannot use string offset as an array in /tmp/ispconfig3_install/install/update.php on line 152
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    To run this, you have to use the root password. You can check it with:

    mysql -h localhost -u root -p

    if you found your root password, then use the update script again.
     

Share This Page