View Single Post
  #10  
Old 16th November 2010, 15:24
jetfix jetfix is offline
Junior Member
 
Join Date: Nov 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Can you please help me Falko? I'm playing around this postfix-game along one month ... and can't get it to work correctly!

I can send and receive emails to the world from real linux accounts ... but can't use squirrelmail or use virtual accounts


/var/log/mail.log says:

Nov 16 08:10:54 mail authdaemond: SQL query: SELECT email, password, "", 5000, 5000, "/home/vmail", CONCAT(SUBSTRING_INDEX(email,'@',1),'/',SUBSTRING_INDEX(email,'@',1),'/'), "", "", "" FROM users WHERE email = 'ghost@mail.helpdesk.in.ua'
Nov 16 08:10:54 mail authdaemond: zero rows returned
Nov 16 08:10:54 mail authdaemond: no password available to compare
Nov 16 08:10:54 mail authdaemond: authmysql: REJECT - try next module



and my configuration files are these:

/etc/postfix/main.cf

smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu)
biff = no
append_dot_mydomain = no
readme_directory = /usr/share/doc/postfix

# TLS parameters
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_use_tls = yes
smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache


myhostname = mail.helpdesk.in.ua
mydomain = helpdesk.in.ua

alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = localhost, localhost.helpdesk.in.ua, helpdesk.in.ua, mail.helpdesk.in.ua
relayhost =
mynetworks = 127.0.0.0/8
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all

tml_directory = /usr/share/doc/postfix/html

virtual_alias_domains =
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_authenable = yes
broken_sasl_auth_clients = yes
smtpd_sasl_authenticated_header = yes
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination

proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $vir$
smtpd_sasl_auth_enable = yes

P.S. I'm not using forwarding or quotas ...



/etc/courier/audaemondrc

authmodulelist="authmysql"
daemons=5
authdaemonvar=/var/run/courier/authdaemon
DEBUG_LOGIN=2



/etc/courier/authmysqlrc

MYSQL_SERVER localhost
MYSQL_USERNAME mail_admin
MYSQL_PASSWORD )))))))))
MYSQL_PORT 0
MYSQL_DATABASE mail
MYSQL_UID_FIELD 5000
MYSQL_GID_FIELD 5000
MYSQL_USER_TABLE users
MYSQL_CRYPT_PWFIELD password
MYSQL_LOGIN_FIELD email
MYSQL_HOME_FIELD "/home/vmail"
MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX(email,'@',1),'/',SUBSTRING_INDEX(email,'@',1),'/')


what else? any ideas? I really don't understand why authdaemond does such a strange SQL query as I posted in the beginning of my reply...


Please help if you will.
Reply With Quote