Ubuntu-fr

michoko

Postix + sasl + mysql

Bonjour à tous,
Voila mon probleme j'ai un serveur de mail presque en état mais le probleme vient de l'envoie de mail.
Impossible de me loguer alors que pour la reception tout est ok
Les logs:

Apr 30 20:14:55 link postfix/smtpd[28054]: warning: SASL authentication failure: Password verification failed
Apr 30 20:14:55 link postfix/smtpd[28054]: warning: unknown[192.168.0.254]: SASL PLAIN authentication failed: authentication failure
Apr 30 20:14:55 link postfix/smtpd[28054]: warning: SASL authentication failure: cannot connect to saslauthd server: Permission denied
Apr 30 20:14:55 link postfix/smtpd[28054]: warning: unknown[192.168.0.254]: SASL LOGIN authentication failed: authentication failure

Le fichier /etc/default/saslauthd

START=yes
MECHANISMS="pam"
PARAMS="-r"

Le fichier /etc/postfix/sasl/smtpd.conf

pwcheck_method: saslauthd auxprop
mech_list: login plain
auxprop_plugin: sql
sql_engine: mysql
sql_hostnames: localhost
sql_user: postfix
sql_database: postfix
sql_passwd: *motdepasse*
sql_select: select password from mailbox where username = '%u@%r'

Merci d'avance et si vous voulez plus de détail sur la conf je suis la

michoko

Re : Postix + sasl + mysql

Voila un postconf -n

alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
append_dot_mydomain = no
biff = no
broken_sasl_auth_clients = yes
config_directory = /etc/postfix
inet_interfaces = all
mailbox_command = procmail -a "$EXTENSION"
mailbox_size_limit = 0
mydestination = link, localhost.localdomain, , localhost
myhostname = homedomain.fr
mynetworks = 127.0.0.0/8 , 0.0.0.0
recipient_delimiter = +
relay_domains = mysql:/etc/postfix/mysql_relay_domains_maps.cf
relayhost =
smtp_tls_session_cache_database = btree:${queue_directory}/smtp_scache
smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
smtpd_recipient_restrictions = permit_mynetworks,  permit_sasl_authenticated, reject_non_fqdn_hostname, reject_non_fqdn_sender, reject_non_fqdn_recipient, reject_unauth_destination, reject_unauth_pipelining, reject_invalid_hostname, reject_rbl_client opm.blitzed.org, reject_rbl_client list.dsbl.org, reject_rbl_client bl.spamcop.net, reject_rbl_client sbl-xbl.spamhaus.org
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain = $myhostname
smtpd_sasl_security_options = noanonymous
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_tls_session_cache_database = btree:${queue_directory}/smtpd_scache
smtpd_use_tls = yes
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_gid_maps = static:5000
virtual_mailbox_base = /home/vmail
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_limit = 51200000
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_minimum_uid = 5000
virtual_transport = virtual
virtual_uid_maps = static:5000

matt_rodat

Re : Postix + sasl + mysql

As tu créer comme sur la très bonne doc:
http://doc.ubuntu-fr.org/serveur/postfix_mysql_tls_sasl
le fichier /etc/pam.d/smtp contenant :

auth       required     pam_mysql.so user=postfix passwd=motdepasse host=127.0.0.1 db=postfix table=mailbox usercolumn=username passwdcolumn=password crypt=1
account    sufficient   pam_mysql.so user=postfix passwd=motdepasse host=127.0.0.1 db=postfix table=mailbox usercolumn=username passwdcolumn=password crypt=1

??

dumarjo

Re : Postix + sasl + mysql

Merci pour l'info sur le tuto.

Je voulais savoir qu'est-ce que vous utiliser comme interface d'administration avec postfix ?

j'ai essayer postfixadmin mais je ne suis pas certain de l'aimer

Merci

dumarjo