[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 [EMAIL PROTECTED]:
UPDATE accountuser SET username='[EMAIL PROTECTED]' 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 =
'[EMAIL PROTECTED]' 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 = '[EMAIL 
PROTECTED]'
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

# mysql config file for local domain (like sendmails sendmail.cw) lookups on 
postfix
# comments are ok.
#

# the user name and password to log into the mysql server
host = localhost
user = mail
password = secret

# the database name on the servers
dbname = mail

# the table name
table = domain
#
select_field = domain_name
where_field = domain_name


# mysql config file for owner lookups on postfix
# comments are ok.

# the user name and password to log into the mysql server
hosts = localhost
user = mail
password = secret

# the database name on the servers
dbname = mail

# the table name
table = virtual

#
select_field = username
where_field = alias


#
# mysql config file for alias lookups on postfix
# comments are ok.
#

# the user name and password to log into the mysql server
hosts = localhost
user = mail
password = secret

# the database name on the servers
dbname = mail

# the table name
table = virtual

#
select_field = dest
where_field = alias
additional_conditions = and status > '0'

_______________________________________________
This mailing list is hosted and supported
by bit-heads GmbH | http://www.bit-heads.ch

_______________________________________________
Web-cyradm mailing list
Web-cyradm@web-cyradm.org
http://www.web-cyradm.org/mailman/listinfo/web-cyradm