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
[email protected]
http://www.web-cyradm.org/mailman/listinfo/web-cyradm
