Thursday, 25th April 2024
Comment posted Install postfix on Debian Wheezy Linux / Postfix mail server with Dovecot and MySQL user storage on Debian Wheezy 7 Linux by .
If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!
Tags: Certificates, configured, dkim, dovecot, dummies, e mail, greylisting, Linux, mail server, remote access, roundcube, spam, squirrelmail, step installation guide, storage, struggle, virtual domains, web frontend
This entry was posted on Thursday, April 25th, 2024 at 3:34 pm and is filed under Linux, Postfix, System Administration. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.
If ye then be risen with Christ, seek those things which are above,
where Christ sitteth on the right hand of God.
-- Colossians 3:1
☩ Walking in Light with Christ – Faith, Computing, Diary 2006-2020 Powered by:
Pc Freak Solutions and Comments (RSS).
Verbatim copying and distribution of this entire article is permitted in any medium, provided this notice is preserved.
Copyright (C) 2020 by Georgi Georgiev - Website Privacy Policy
Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.95 Safari/537.36
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!
View CommentView CommentMozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:23.0) Gecko/20100101 Firefox/23.0
First of all thanks for that Tutorial.
View CommentView CommentThere is an Error in the file: create-postfix-mysql-user-database.sql
=> Line 37 should be INSERT instead of NSERT.
Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130626 Firefox/17.0 Iceweasel/17.0.7
Thanks for feedback fixed! 🙂
View CommentView CommentMozilla/5.0 (Windows NT 6.1; rv:19.0) Gecko/20100101 Firefox/19.0
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 🙂
View CommentView CommentMozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.76 Safari/537.36
Hi,
View CommentView Commentfirst 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.
Mozilla/5.0 (Windows NT 6.2; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0
hello, thank you very much for the tutorial, I was able to configure my server with mysql, postfix and dovecot to perfection.
View CommentView CommentMozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Firefox/24.0
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?
View CommentView CommentMozilla/5.0 (Windows NT 6.1; WOW64; rv:28.0) Gecko/20100101 Firefox/28.0
Hello. Postfix is unable to send mails. It refuses connection.
View CommentView CommentMozilla/5.0 (Windows NT 6.1; WOW64; rv:28.0) Gecko/20100101 Firefox/28.0
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
View CommentView CommentMozilla/5.0 (Windows NT 6.1; WOW64; rv:28.0) Gecko/20100101 Firefox/28.0
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.
View CommentView CommentMozilla/5.0 (X11; Linux i686; rv:10.0.12) Gecko/20100101 Firefox/10.0.12 Iceweasel/10.0.12
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
View CommentView CommentMozilla/5.0 (X11; Linux x86_64; rv:30.0) Gecko/20100101 Firefox/30.0
I finally found a procedure that works.
View CommentView CommentReally great! \ o /
Mozilla/5.0 (Windows NT 6.1; WOW64; rv:32.0) Gecko/20100101 Firefox/32.0
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.
View CommentView CommentMozilla/5.0 (Windows NT 6.1; WOW64; rv:32.0) Gecko/20100101 Firefox/32.0
sorry, parser eated some symbols. My log file contains records with such email: root@info@myhost.com, not info@myhost.com.
View CommentView CommentMozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Firefox/31.0
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,
View CommentView CommentGeorgi
Mozilla/5.0 (Windows NT 6.1; WOW64; rv:35.0) Gecko/20100101 Firefox/35.0
Thank you very much for the perfect tutorial, i have one problem, amavis working only on port 10024 only, can you help please.
thank you in advance
View CommentView CommentMozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/40.0.2214.111 Safari/537.36
Hi Alex,
Try to check amavisd log (depending where it is configured usually it should be /var/log/amavis.log) – to configure new logging check out /etc/amavis/conf.d/50-user) also take a look at /var/log/messages there should be some error / warning or hint messages what is going wrong with amavis.
Hope this helps.
Regards,
Georgi
View CommentView Comment