[Web-cyradm] Added EXPERIMENTAL support for username=emailaddress to SVN

[Lukasz Marciniak]

Hi list,

I've added experimental support to svn version of web-cyradm. My test
configuration was:
cyrus-imapd-2.2.12
cyrus-sasl-2.1.21
postfix-2.2.5

I've changed cyrus admin name in DB from name to name at realm:
UPDATE accountuser SET username='cyrus at mail.dom.prv' WHERE username='cyrus'

######## imapd.conf:
admins: cyrus
virtdomains: yes
unixhierarchysep: yes

sasl_pwcheck_method: auxprop
sasl_mech_list: plain login cram-md5 digest-md5
sasl_auxprop_plugin: sql
sasl_sql_engine: mysql
sasl_sql_user: mail
sasl_sql_passwd: secret
sasl_sql_hostnames: localhost
sasl_sql_database: mail
sasl_sql_statement: select password from accountuser where username =
'%u@%r' and imap = 1

servername: mail.dom.prv
hostname: mail.dom.prv

######## smtpd.conf
pwcheck_method: auxprop
mech_list: plain login cram-md5 digest-md5
auxprop_plugin: sql
sql_engine: mysql
sql_user: mail
sql_passwd: secret
sql_database: mail
sql_statement: select password from accountuser where username = '%u@%r'
and smtpauth = 1

######## main.conf
myhostname = mail.dom.prv
mydomain = dom.prv
mydestination = mysql:/etc/mail/mysql-mydestination.cf
mailbox_transport = cyrus
fallback_transport = cyrus
virtual_maps = mysql:/etc/mail/mysql-virtual.cf

smtpd_sasl_auth_enable = yes
smtpd_sasl_security_options = noanonymous
smtpd_sasl_local_domain =
broken_sasl_auth_clients = yes

smtpd_sender_login_maps = mysql:/etc/mail/mysql-owner.cf

smtpd_recipient_restrictions =
        reject_sender_login_mismatch,
        permit_sasl_authenticated,
        reject_unauth_destination,
        permit

######## master.conf
cyrus     unix  -       n       n       -       -       pipe
  user=cyrus argv=/usr/lib/cyrus/deliver -e -r ${sender} -m ${extension}
${recipient}

######## mysql-* in attachment


Any comments very welcome ;-)

Best regards,
Lukasz
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: mysql-mydestination.cf
Url: http://fix.bitheads.ch/pipermail/web-cyradm/attachments/20060812/d8cee273/mysql-mydestination.ksh
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: mysql-owner.cf
Url: http://fix.bitheads.ch/pipermail/web-cyradm/attachments/20060812/d8cee273/mysql-owner.cc
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: mysql-virtual.cf
Url: http://fix.bitheads.ch/pipermail/web-cyradm/attachments/20060812/d8cee273/mysql-virtual.cc