[Web-cyradm] Users with the format user@domain.com unable to authenticate.

[Ísak Jón Benjamínsson]

I can send mail to users i create but i cant authenticate them via IMAP

My setup:

web-cyradm Version 0.5.5-Beta1

Censored stuff is inside ""

As you can see from these files i've been experimenting alot....

I started with web-cyradm 0.5.4.1 and then upgraded the mysql tables and used 0.5.5-Betea-1


The web-cyradm frontend works fine and creates the users in mysql and in cyrus.


##### imapd.conf #####
postmaster: postmaster
configdirectory: /var/lib/imap
partition-default: /var/spool/imap
admins: cyrus
allowanonymouslogin: no
allowplaintext: yes
servername: "Censored FQDN hostname"
autocreatequota: 100000
reject8bit: no
quotawarn: 90
timeout: 30
poptimeout: 10
dracinterval: 0
drachost: localhost
#sievedir: /var/lib/imap/sieve
sendmail: /usr/sbin/sendmail
#sieve_maxscriptsize: 32
#sieve_maxscripts: 5
hashimapspool: true
sasl_pwcheck_method: saslauthd
#sasl_pwcheck_method: auxprop
sasl_auxprop_plugin: sql
sasl_mech_list: PLAIN LOGIN
sasl_sql_engine: mysql
sasl_sql_verbose: yes
sasl_log_level: 9
sasl_sql_user: mail
sasl_password_format: plain
sasl_sql_passwd: "Censored password"
sasl_sql_hostnames: 127.0.0.1
sasl_sql_database: mail
sasl_sql_select: SELECT password FROM accountuser WHERE username='%u@%r' OR (username ='%u' AND domain_name = '')
sasl_auto_transition: yes
sasl_sql_statement: select password from accountuser where username='%u@%r' OR (username ='%u' AND domain_name = '')
virtdomains: yes
unixhierarchysep: yes
tls_cert_file: /usr/share/ssl/certs/cyrus-imapd.pem
tls_key_file: /usr/share/ssl/certs/cyrus-imapd.pem
tls_ca_file: /usr/share/ssl/certs/ca-bundle.crt


##### smtpd.conf #####
pwcheck_method: saslauthd
#pwcheck_method: auxprop
auxprop_plugin: sql
mech_list: plain login
saslauthd_version: 2
sql_engine: mysql
sql_verbose: yes
sql_user: mail
sql_passwd: "Censored password"
password_format: plain
sql_hostname: localhost
sql_database: mail
sasl_sql_select: SELECT password FROM accountuser WHERE username='%u@%r' OR (username ='%u' AND domain_name = '')
sasl_sql_statement: select password from accountuser where username='%u@%r' OR (username ='%u' AND domain_name = '')
log_level: 9


##### /etc/pam.d/imap #####
#%PAM-1.0
#auth       required     /lib/security/pam_stack.so service=system-auth
#account    required     /lib/security/pam_stack.so service=system-auth

auth sufficient pam_mysql.so verbose=1 user=mail passwd="Censored password" host=localhost db=mail table=accountuser usercolumn=username passwdcolumn=password crypt=0 logtable=log logmsgcolumn=msg logusercolumn=user loghostcolumn=host logpidcolumn=pid logtimecolumn=time

#auth sufficient pam_unix_auth.so

account required pam_mysql.so verbose=1 user=mail passwd="Censored Password" host=localhost db=mail table=accountuser usercolumn=username passwdcolumn=password crypt=0 logtable=log logmsgcolumn=msg logusercolumn=user loghostcolumn=host logpidcolumn=pid logtimecolumn=time

#account  sufficient       pam_unix_acct.so


Thanks in advance

--
Isak Ben.