<html><head><title>Cyrus administration problem</title>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-15">
</head>
<body>
<span style=" font-family:'Verdana'; font-size: 10pt;">Hello ,<br>
<br>
I'm getting a little desperate here so I'm hoping someone can answer these two question for me. I originally asked them as "How to use global admin. & virtual domains?" but no-one responded and I have no answers myself, so please, even if this seems like a stupid question because I am missing the obvious, please let me know!<br>
<br>
In essence, I'm trying to use a global admin. with virtual domains and it doesn't seem to be working. With domain admins. there is no problem.<br>
<br>
From what I can see, part of the documentation says that with virtual hosting that every user must have a domain and another part says when using virtual domains use a user without a domain to create a global domain.<br>
<br>
Could someone please tell/show me what I am missing here in my attempts to make a global admin. work with virtual domains.<br>
<br>
To see what I am experiencing, here's the results of two different ways of using cyradm I have tried:<br>
<br>
------------------------------------------------------------------------<br>
<b>Scenario 1:<br>
</b><br>
>cyradm -u root<br>
cyradm> lm *@seowebsales.com<br>
listmailbox: no connection to server<br>
cyradm> <br>
<br>
Doesn't look up the SQL Database for authentication hence the response "no connection to server".<br>
<br>
------------------------------------------------------------------------<br>
<b>Scenario 2:<br>
</b><br>
>cyradm -u root domain1.com<br>
Password: <br>
IMAP Password: <br>
Login failed: authentication failure at /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/Cyrus/IMAP/Admin.pm line 119<br>
cyradm: cannot authenticate to server with as root<br>
<br>
Here it does try to authenticate however, when watching the MySQL query log it chooses a virtual domain at random from the virtual domains from Apache or my local DNS server. If it happens to use the domain that I want to administrate, then it succeeds instead of fails as it did in the case above.<br>
<br>
------------------------------------------------------------------------<br>
<br>
Other than wanting to know how to get a global admin. working with virtual domains I would really appreciate someone helping me understand this issue of it randomly picking a virtual domain from Apache or my DNS (not sure which) to try and authenticate with.<br>
<br>
Thanks so much to anyone who sheds some light on this!<br>
<br>
Reggie.<br>
<br>
<br>
Here is my imap.conf file:<br>
<br>
# OS OpenSuSE 11.0<br>
# Cyrus IMAPD 2.3.11<br>
# Cyrus-SASL 2.1.22<br>
<br>
#<br>
# Cyrus-SASL options<br>
#<br>
sasl_auxprop_plugin: sql<br>
sasl_log_level: 7<br>
sasl_mech_list: PLAIN LOGIN CRAM-MD5 DIGEST-MD5<br>
sasl_pwcheck_method: auxprop<br>
sasl_sql_hostnames: localhost<br>
sasl_sql_user: cyrus<br>
sasl_sql_passwd: **************<br>
sasl_sql_database: system_mail<br>
sasl_sql_select: SELECT `password` FROM `accounts` WHERE `user`='%u' AND `realm`='%r' AND `virtual` != 0<br>
sasl_sql_insert: INSERT INTO `accounts` (`user`, `realm`, `password`) VALUES ('%u', '%r', '%v')<br>
sasl_sql_update: UPDATE `accounts` SET `user`='%u',`realm`='%r',`password`='%v' WHERE `user`='%u' AND `realm`='%r'<br>
<br>
#<br>
# Cyrus-IMAP Options<br>
#<br>
admins: cyrus root root@domain1.com root@domain2.com root@domain3.com<br>
allowplaintext: 1<br>
altnamespace: 1<br>
anyoneuseracl: 0<br>
auth_mech: unix<br>
configdirectory: /var/lib/imap<br>
defaultdomain: localhost<br>
drachost: localhost<br>
dracinterval: 0<br>
duplicatesuppression: 0<br>
foolstupidclients: 1<br>
hashimapspool: 1<br>
improved_mboxlist_sort: 1<br>
lmtp_downcase_rcpt: 1<br>
lmtp_strict_quota: 1<br>
logtimestamps: 1<br>
partition-default: /var/mail/cyrus<br>
popsubfolders: 1<br>
poptimeout: 10<br>
sendmail: /usr/sbin/sendmail<br>
sievedir: /var/mail/sieve<br>
unixhierarchysep: 1<br>
virtdomains: 1</body>