16 responses

  1. Steffan
    August 14, 2013

    Hi,
    I am the creator of Mail Admin Tool (MAT) and i noticed this guide..
    I would like to ask what have you changed in the index.php file, since you make the readers download an edited copy from your site?
    If any improvements, please send them to me so i can make a V1.2 so other people can benefit of theese improvements

    also, please post a link to http://mat.ssdata.dk and not only the .tar.gz file directly, because the filename will change when i make a v1.2!

  2. rouven
    August 27, 2013

    First of all thanks for that Tutorial.
    There is an Error in the file: create-postfix-mysql-user-database.sql
    => Line 37 should be INSERT instead of NSERT.

    • admin
      August 27, 2013

      Thanks for feedback fixed! :)

  3. admin
    September 5, 2013

    If you get error; Postfix SASL via dovecot fails with: no SASL authentication mechanism

    You probably forgot to install something!

    Try as fix to install following bunch of packages:

    apt-get install –yes mysql-client mysql-server dovecot-common dovecot-imapd dovecot-pop3d postfix libsasl2-2 libsasl2-modules libsasl2-modules-sql sasl2-bin libpam-mysql openssl telnet mailutils

    Cheers :)

  4. André
    September 30, 2013

    Hi,
    first of all: Thank you! ;) Just a few things you should mention:
    – /etc/amavis/conf.d/05-node_id: Change "$myhostname" to your needs. (This is for the "BANNED" mail you recieve.)
    – Outcomment EVERY line in /etc/dovecot/conf.d/auth-system.conf.ext for PAM:
    #passdb {
      #driver = pam
      # [session=yes] [setcred=yes] [failure_show_msg=yes] [max_requests=<n>]
      # [cache_key=<key>] [<service name>]
      #args = dovecot
    #}
    This fixes the slow login, because dovecot would first try PAM before MySQL.
    – The .sql preset for the database is a bit buggy. If I remember correctly, you should first create the database, then grant permissions. I also think there was an error with the "grant all on bla" command.

  5. Ruben
    January 9, 2014

    hello, thank you very much for the tutorial, I was able to configure my server with mysql, postfix and dovecot to perfection.

  6. Brian
    February 11, 2014

    I am not able to get into MAT,

    [Tue Feb 11 12:17:35 2014] [error] [client 10.1.1.46] PHP Warning: mysql_connect(): Access denied for user ‘mailuser’@’localhost’ (using password: YES) in /var/www/mailadmin/includes/class_db.php on line 8, referer: http://xx.xx.xx.xx:81/mailadmin/
    [Tue Feb 11 12:17:35 2014] [error] [client 10.1.1.46] PHP Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in /var/www/mailadmin/includes/class_db.php on line 9, referer: http://xx.xx.xx.xx:81/mailadmin/
    [Tue Feb 11 12:17:35 2014] [error] [client 10.1.1.46] PHP Warning: mysql_real_escape_string(): Access denied for user ‘www-data’@’localhost’ (using password: NO) in /var/www/mailadmin/includes/class_db.php on line 28, referer: http://xx.xx.xx.xx:81/mailadmin/
    [Tue Feb 11 12:17:35 2014] [error] [client 10.1.1.46] PHP Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/mailadmin/includes/class_db.php on line 28, referer: http://xx.xx.xx.xx:81/mailadmin/
    [Tue Feb 11 12:17:35 2014] [error] [client 10.1.1.46] PHP Warning: mysql_real_escape_string(): Access denied for user ‘www-data’@’localhost’ (using password: NO) in /var/www/mailadmin/includes/class_db.php on line 28, referer: http://xx.xx.xx.xx:81/mailadmin/
    [Tue Feb 11 12:17:35 2014] [error] [client 10.1.1.46] PHP Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/mailadmin/includes/class_db.php on line 28, referer: http://xx.xx.xx.xx:81/mailadmin/

    What user should be being used?

  7. Alex Doe
    April 24, 2014

    Hello. Postfix is unable to send mails. It refuses connection.

     

    Apr 24 14:07:34 xxxx postfix/qmgr[31742]: D1C6C714965: from=<info@xxxx>, size=333, nrcpt=1 (queue active)
    Apr 24 14:07:34 xxxx postfix/error[31840]: 22EE4714866: to=<yyyy@gmail.com>, relay=none, delay=443, delays=442/0.01/0/0.27, dsn=4.4.1, status=deferred (delivery temporarily suspended: connect to 127.0.0.1[127.0.0.1]:10024: Connection refused)
    Apr 24 14:07:34 xxxx postfix/error[31841]: 43916714943: to=<yyyy@gmail.com>, relay=none, delay=851, delays=850/0.02/0/0.33, dsn=4.4.1, status=deferred (delivery temporarily suspended: connect to 127.0.0.1[127.0.0.1]:10024: Connection refused)
    Apr 24 14:07:34 xxxx postfix/error[31843]: D1C6C714965: to=<yyyy@gmail.com>, relay=none, delay=78108, delays=78107/0.03/0/0.32, dsn=4.4.1, status=deferred (delivery temporarily suspended: connect to 127.0.0.1[127.0.0.1]:10024: Connection refused)

     

    • admin
      April 24, 2014

      Hi Alex,

      Seems like Amavis problem, do you have amavis running?

      Try running:
      # postconf -e ‘content_filter = amavis:[127.0.0.1]:10024′

      Reload/Restart postfix
      # postfix reload

      And check if amavis is running..
      # netstat -tap | grep amavis

      Regards,

      Georgi

  8. Alex Doe
    April 24, 2014

    Thank you for quick response, indeed amavis was not running. I thought is possible to skip a step with antivirus. Now amavis is running and all is ok.

  9. Boris
    May 19, 2014

    Amazing,dear friend!

    Thanks for the great job.Really many thanks

    Everything working good here.

    Debian Wheezy in my server,with apache2

    A question: how i can "update"the definitions of spamassasin/clamav?

    Greetings

     

     

     

     

     

  10. Dge
    June 21, 2014

    I finally found a procedure that works.
    Really great! \ o /

  11. Alex Doe
    September 15, 2014

    Hello,

    in which case this can be:

    mail.log:
    Sep 14 20:24:33 km34528-07 postfix/master[25503]: daemon started — version 2.9.6, configuration /etc/postfix
    Sep 14 20:24:33 km34528-07 postfix/qmgr[25509]: 7C112770104: from=, size=353, nrcpt=1 (queue active)

    ?

    I mean this: root@info@myhost.com. I defined email in the database as info@myhost.com.

    • Alex Doe
      September 15, 2014

      sorry, parser eated some symbols. My log file contains records with such email: root@info@myhost.com, not info@myhost.com.

    • admin
      September 15, 2014

      Hi maybe, someone is trying some spam attacks against your mail server. Or you have misconfigured somewhere your hostname in configs or during copy pastes. Check all configs you used from my article carefully and see if there is no something wrong.

      Hope this helps,
      Georgi

Leave a Reply

 

 

 

Back to top
mobile desktop