Bonjour,
Je ne sais pas si je poste dans la bonne section.
J'ai configure Postfix et Dovecot selon plusieurs tutoriels pour qu'ils se servent de MySQL.
Dovecot ne peut pas aller mieux, mais Postfix ne fait que renvoyer des erreurs:
main.cf
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11 192.168.0.105 03/07/09 10:21:17 03/07/09 10:21:17 mail Warning postfix/master[10630] "warning: process /usr/lib/postfix/trivial-rewrite pid 10712 exit status 1<\0x0A>" 192.168.0.105 03/07/09 10:21:17 03/07/09 10:21:17 mail Warning postfix/smtpd[10653] "warning: problem talking to service rewrite: Success<\0x0A>" 192.168.0.105 03/07/09 10:21:17 03/07/09 10:21:17 mail Warning postfix/smtpd[10653] "warning: premature end-of-input on private/rewrite socket while reading input attribute name<\0x0A>" 192.168.0.105 03/07/09 10:21:17 03/07/09 10:21:17 mail Warning postfix/master[10630] "warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling<\0x0A>" 192.168.0.105 03/07/09 10:21:17 03/07/09 10:21:17 mail Warning postfix/master[10630] "warning: process /usr/lib/postfix/trivial-rewrite pid 10711 exit status 1<\0x0A>" 192.168.0.105 03/07/09 10:21:17 03/07/09 10:21:17 mail Warning postfix/smtpd[10636] "warning: problem talking to service rewrite: Connection reset by peer<\0x0A>" 192.168.0.105 03/07/09 10:21:17 03/07/09 10:21:17 mail Warning postfix/smtpd[10636] "warning: premature end-of-input on private/rewrite socket while reading input attribute name<\0x0A>" 192.168.0.105 03/07/09 10:21:17 03/07/09 10:21:17 mail Warning postfix/smtpd[10657] "warning: problem talking to service rewrite: Success<\0x0A>" 192.168.0.105 03/07/09 10:21:17 03/07/09 10:21:17 mail Warning postfix/smtpd[10657] "warning: premature end-of-input on private/rewrite socket while reading input attribute name<\0x0A>" 192.168.0.105 03/07/09 10:21:16 03/07/09 10:21:16 mail Warning postfix/proxymap[10637] "warning: connect to mysql server 127.0.0.1:3306: Can't connect to MySQL server on '127.0.0.1' (111)<\0x0A>" 192.168.0.105 03/07/09 10:21:16 03/07/09 10:21:16 mail Critical postfix/trivial-rewrite[10712] "fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem<\0x0A>"
mysql-virtual_domains.cf
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47 readme_directory = /usr/share/doc/postfix-2.3.3/README_FILES html_directory = /usr/share/doc/postfix-2.3.3/html sendmail_path = /usr/sbin/sendmail.postfix setgid_group = postdrop command_directory = /usr/sbin manpage_directory = /usr/share/man daemon_directory = /usr/lib/postfix newaliases_path = /usr/bin/newaliases mailq_path = /usr/bin/mailq mynetworks_style = host unknown_local_recipient_reject_code = 450 smtp-filter_destination_concurrency_limit = 2 lmtp-filter_destination_concurrency_limit = 2 delay_warning_time = 2h mydestination = willisite.com, localhost debug_peer_level = 1 mail_spool_directory = /var/spool/mail disable_vrfy_command = yes maximal_queue_lifetime = 5d message_size_limit = 10240000 allow_untrusted_routing = yes relayhost = smtp.cgocable.ca myhostname = willisite.com mynetworks = 127.0.0.0/8 virtual_alias_domains = virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf virtual_mailbox_base = /home/vmail virtual_uid_maps = static:5000 virtual_gid_maps = static:5000 smtpd_sasl_auth_enable = yes broken_sasl_auth_clients = yes smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination smtpd_use_tls = yes smtpd_tls_cert_file = /etc/postfix/smtpd.cert smtpd_tls_key_file = /etc/postfix/smtpd.key transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf virtual_create_maildirsize = yes virtual_mailbox_extended = yes virtual_mailbox_limit_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf virtual_mailbox_limit_override = yes virtual_maildir_limit_message = "The user you are trying to reach is over quota." virtual_overquota_bounce = yes proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps inet_interfaces = all
L'utilisateur mail_admin et le mdp sont correct et il a les bonne permissions.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5 user = mail_admin password = ***** dbname = mail query = SELECT domain AS virtual FROM domains WHERE domain='%s' hosts = 127.0.0.1:3306
Merci
Partager