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

[John Thomas]

> 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'
<snip>

Does anybody have this working?  I am close, but have the following 
troubles.

Quota does not work as expected.  In Web-Cyradm, quota shows "Unable to 
retrieve quota".  When I set the quota in Web-Cyradm, the quota for the 
user does not change (it stays at the "autocreatequota" from imapd.conf).

INBOX is created under Inbox.  I used IMAPSYNC to copy messages from the 
old server.  IMAPSYNC created an INBOX under Inbox and put the old Inbox 
messages in there.  I use TBird 1.5ish for an imap client test.

I am running:
CentOS 5
cyrus-imapd-2.3.8-9
cyrus-sasl-2.1.22-4
postfix-2.3.3-2.el5.centos.mysql_pgsql

#imapd.conf.
postmaster: postmaster
configdirectory: /var/lib/imap
partition-default: /var/spool/imap
#added extra admin in case the quota issue was a permission issue
admins: cyrus cyrus at redacteddomain.com
allowanonymouslogin: no
allowplaintext: yes
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: 128
sieve_maxscripts: 25
unixhierarchysep: yes
tls_cert_file: /etc/cyrus-ssl/server.pem
tls_key_file: /etc/cyrus-ssl/server.pem
tls_ca_file: /etc/cyrus-ssl/server.pem
idlesocket: /var/lib/imap/socket/idle
hashimapspool: true
mailnotifier:  mailto
sievenotifier: mailto
virtdomains: 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: redacted
sasl_sql_hostnames: localhost
sasl_sql_database: mail
sasl_sql_statement: select password from accountuser where username = 
'%u@%r' and imap = 1
servername: redacteddomain.com
hostname: redacteddomain.com


-- 
Sincerely,
John Thomas