View Single Post
  #1  
Old 24th September 2006, 22:21
k1piee k1piee is offline
Junior Member
 
Join Date: Sep 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs

hello!

i have a problem whit my mail server. i can't loggin with the users I add to the mysql-database.
I get this error in /var/log/mail.log :

Quote:
Sep 24 22:05:10 server1 courierpop3login: Connection, ip=[::ffff:85.228.206.67]
Sep 24 22:05:34 server1 courierpop3login: LOGIN FAILED, ip=[::ffff:85.228.206.67]
and i get some other errors too:

Quote:
Sep 24 21:46:10 server1 postfix/proxymap[10120]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
Sep 24 21:46:10 server1 postfix/proxymap[10120]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
Sep 24 21:46:10 server1 postfix/trivial-rewrite[10495]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem
Sep 24 21:46:10 server1 postfix/trivial-rewrite[10496]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem
Sep 24 21:46:10 server1 postfix/trivial-rewrite[10497]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem
Sep 24 21:46:11 server1 postfix/smtpd[10119]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Sep 24 21:46:11 server1 postfix/smtpd[10356]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Sep 24 21:46:11 server1 postfix/master[10077]: warning: process /usr/lib/postfix/trivial-rewrite pid 10495 exit status 1
Sep 24 21:46:11 server1 postfix/smtpd[10119]: warning: problem talking to service rewrite: Success
Sep 24 21:46:11 server1 postfix/smtpd[10356]: warning: problem talking to service rewrite: Connection reset by peer
Sep 24 21:46:11 server1 postfix/master[10077]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Sep 24 21:46:11 server1 postfix/smtpd[10357]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Sep 24 21:46:11 server1 postfix/smtpd[10125]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Sep 24 21:46:11 server1 postfix/master[10077]: warning: process /usr/lib/postfix/trivial-rewrite pid 10496 exit status 1
Sep 24 21:46:11 server1 postfix/smtpd[10357]: warning: problem talking to service rewrite: Success
Sep 24 21:46:11 server1 postfix/smtpd[10125]: warning: problem talking to service rewrite: Connection reset by peer
Sep 24 21:46:11 server1 postfix/smtpd[10355]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Sep 24 21:46:11 server1 postfix/smtpd[10442]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Sep 24 21:46:11 server1 postfix/master[10077]: warning: process /usr/lib/postfix/trivial-rewrite pid 10497 exit status 1
Sep 24 21:46:11 server1 postfix/smtpd[10355]: warning: problem talking to service rewrite: Success
Sep 24 21:46:11 server1 postfix/smtpd[10442]: warning: problem talking to service rewrite: Connection reset by peer
Sep 24 21:46:12 server1 postfix/smtpd[10498]: fatal: /etc/postfix/mysql-virtual_email2email.cf: bad string length 0 < 1: table =
Sep 24 21:46:13 server1 postfix/master[10077]: warning: process /usr/lib/postfix/smtpd pid 10498 exit status 1
Sep 24 21:46:13 server1 postfix/master[10077]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
these files are exakt like he describes in the howto!
exept the passwoef!
Quote:
-rw-r----- 1 root postfix 134 2006-09-24 22:02 mysql-virtual_domains.cf
-rw-r----- 1 root postfix 127 2006-09-24 22:03 mysql-virtual_email2email.cf
-rw-r----- 1 root postfix 140 2006-09-24 22:03 mysql-virtual_forwardings.cf
-rw-r----- 1 root postfix 196 2006-09-24 22:03 mysql-virtual_mailboxes.cf
-rw-r----- 1 root postfix 127 2006-09-24 22:04 mysql-virtual_mailbox_limit_maps.cf
-rw-r----- 1 root postfix 136 2006-09-24 22:04 mysql-virtual_transports.cf
and my main.cf :
Quote:
# See /usr/share/postfix/main.cf.dist for a commented, more complete version

smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
biff = no

# appending .domain is the MUA's job.
append_dot_mydomain = no

# Uncomment the next line to generate "delayed mail" warnings
#delay_warning_time = 4h

myhostname = Dad3L.org
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = Dad3L.org, localhost, localhost.localdomain
relayhost =
mynetworks = 127.0.0.0/8
mailbox_command = procmail -a "$EXTENSION"
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
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
content_filter = amavis:[127.0.0.1]:10024
receive_override_options = no_address_mappings
someone who knows what the problem is?
sorry for my bad english!
Reply With Quote
Sponsored Links