Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs ruskicar HOWTO-Related Questions 26 20th July 2007 16:28
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs hdtpsi HOWTO-Related Questions 10 24th September 2006 13:52
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs mholownych HOWTO-Related Questions 10 29th May 2006 03:39
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs ebbay Installation/Configuration 9 4th March 2006 11:47
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs Rocky Installation/Configuration 24 9th February 2006 11:08


All times are GMT +2. The time now is 10:57.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.