Voila j'ai installé un serveur virtuel postfix + mysql sur une fedora7 et après une mise à jour les mails ne fonctionnent plus.

voici la configuration de postfix

root@sd2148 virtualwebdesk.com]# postconf -n
command_directory = /usr/sbin
config_directory = /etc/postfix
daemon_directory = /usr/libexec/postfix
debug_peer_level = 2
html_directory = no
inet_interfaces = localhost
mail_owner = postfix
mail_spool_directory = /var/spool/mail/virtual
mailq_path = /usr/bin/mailq.postfix
manpage_directory = /usr/share/man
mydestination = sd2148.sivit.org, localhost, localhost.localdomain
myhostname = sd2148.sivit.org
newaliases_path = /usr/bin/newaliases.postfix
queue_directory = /var/spool/postfix
readme_directory = /usr/share/doc/postfix-2.4.3/README_FILES
sample_directory = /usr/share/doc/postfix-2.4.3/samples
sendmail_path = /usr/sbin/sendmail.postfix
setgid_group = postdrop
smtpd_helo_required = yes
smtpd_recipient_restrictions = permit_mynetworks, reject_unauth_destination
smtpd_sasl_auth_enable = no
smtpd_sasl_path = private/auth
smtpd_sasl_type = dovecot
smtpd_sender_login_maps = mysql:/etc/postfix/mysql/mysql_virtual_sender.cf
unknown_local_recipient_reject_code = 550
virtual_alias_maps = mysql:/etc/postfix/mysql/mysql_virtual_alias_maps.cf
virtual_gid_maps = static:12
virtual_mailbox_base = /var/spool/virtual
virtual_mailbox_domains = mysql:/etc/postfix/mysql/mysql_virtual_domains_maps.cf
virtual_mailbox_limit = 51200000
virtual_mailbox_maps = mysql:/etc/postfix/mysql/mysql_virtual_mailbox_maps.cf
virtual_minimum_uid = 8
virtual_transport = virtual
virtual_uid_maps = static:89

voici les logs /var/log/maillog après un start de postfix :

Jun 6 16:41:25 sd2148 postfix/postfix-script[8463]: stopping the Postfix mail system
Jun 6 16:41:25 sd2148 postfix/master[7741]: terminating on signal 15
Jun 6 16:41:26 sd2148 postfix/postfix-script[8511]: starting the Postfix mail system
Jun 6 16:41:26 sd2148 postfix/master[8512]: daemon started -- version 2.4.5, configuration /etc/postfix
Jun 6 16:41:51 sd2148 pop3d: Connection, ip=[::ffff:90.11.70.9]
Jun 6 16:41:51 sd2148 authdaemond: received auth request, service=pop3, authtype=login
Jun 6 16:41:51 sd2148 authdaemond: authmysql: trying this module
Jun 6 16:41:51 sd2148 authdaemond: SQL query: SELECT username, password, "", 89, 89, '/var/spool/virtual/', maildir, "", username, "" FROM mailbox WHERE username = "fifi@virtualwebdesk.com"
Jun 6 16:41:51 sd2148 authdaemond: password matches successfully
Jun 6 16:41:51 sd2148 authdaemond: authmysql: sysusername=<null>, sysuserid=89, sysgroupid=89, homedir=/var/spool/virtual/, address=fifi@virtualwebdesk.com, fullname=fifi@virtualwebdesk.com, maildir=virtualwebdesk.com/fifi/, quota=<null>, options=<null>
Jun 6 16:41:51 sd2148 authdaemond: authmysql: clearpasswd=<null>, passwd=$1$dbcf99f8$FxTRSX0ir0QQMfntyBmg60
Jun 6 16:41:51 sd2148 authdaemond: Authenticated: sysusername=<null>, sysuserid=89, sysgroupid=89, homedir=/var/spool/virtual/, address=fifi@virtualwebdesk.com, fullname=fifi@virtualwebdesk.com, maildir=virtualwebdesk.com/fifi/, quota=<null>, options=<null>
Jun 6 16:41:51 sd2148 authdaemond: Authenticated: clearpasswd=lepassword, passwd=$1$dbcf99f8$FxTRSX0ir0QQMfntyBmg60
Jun 6 16:41:51 sd2148 pop3d: LOGIN, user=fifi@virtualwebdesk.com, ip=[::ffff:90.11.70.9]
Jun 6 16:41:51 sd2148 pop3d: LOGOUT, user=fifi@virtualwebdesk.com, ip=[::ffff:90.11.70.9], top=0, retr=0, rcvd=12, sent=39, time=0

Tour a l'air de fonctionner mais je ne recoit aucun mail (sauf ceux envoyés en local)

les fichiers de config mysql :

[root@sd2148 mysql]# cat aliases.cfg
user = root
password = .....
dbname = postfixadmin
query = SELECT concat(e2.account, '@', e2.domain) FROM emails as e1, emails as e2
WHERE e1.account = '%u' AND e1.domain = '%d' AND e1.alias > 0 AND e1.alias = e2.id
hosts = 127.0.0.1
[root@sd2148 mysql]# cat domains.cfg
user = root
password = ......
dbname = postfixadmin
query = SELECT domain FROM domains WHERE domain = '%s'
hosts = 127.0.0.1
[root@sd2148 mysql]# cat mboxes.cfg
user = root
password = ......
dbname = postfixadmin
query = SELECT concat(domain, '/', account, '/') FROM emails WHERE account = '%u' AND domain = '%d' AND alias = 0
hosts = 127.0.0.1
[root@sd2148 mysql]# cat mysql_virtual_alias_maps.cf
user = root
password = ......
hosts = 127.0.0.1
dbname = postfixadmin
table = alias
select_field = goto
where_field = address

[root@sd2148 mysql]# cat mysql_virtual_domains_maps.cf
user = root
password = ......
hosts = 127.0.0.1
dbname = postfixadmin
table = domain
select_field = description
where_field = domain

[root@sd2148 mysql]# cat mysql_virtual_mailbox_limit_maps.cf
user = root
password = ......
hosts = 127.0.0.1
dbname = postfixadmin
table = mailbox
select_field = quota
where_field = username

[root@sd2148 mysql]# cat mysql_virtual_mailbox_maps.cf
user = root
password = ......
hosts = 127.0.0.1
dbname = postfixadmin
table = mailbox
select_field = maildir
where_field = username

[root@sd2148 mysql]# cat mysql_virtual_sender.cf
user = root
password = ......
hosts = 127.0.0.1
dbname = postfixadmin
table = mailbox
select_field = username
where_field = username

Je n'y comprend plus rien j'ai vérifier tout les fichiers de conf et de logs je n'ais pas de messages d'erreur sur la réception du courrier (le serveur est POP3)

PS :J'ai essayé en remplacant 127.0.0.1 par localhost : aucun changement

Si qq a une idée merci d'avance

Poste le Saturday 6 June 2009 16:18:35