Cyrus-imapd virtual domains
Good day, i am using cyrus sasl 2.2.6 with postfix , mysql, pam-mysql, cyrus sasl I would like to ask you how is it possible to store the user's imap folder with the full email address like [EMAIL PROTECTED] and not just test. in my mysql db i have the usernames to be like that. i also set at imapd.conf the virtdomains: userid Any ideas ? thank you in advance --- Cyrus Home Page: http://asg.web.cmu.edu/cyrus Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html
Re: Cyrus-Imapd SERIOUS problem Please HELP
Well thank you very Much Tony. Good point. It did work :D Now i have another problem. I need my passwords to be somehow encrypted in the back end MySql. As far as i know pam-mysql doesnt support CRAM-MD5 encryption, so the only encryption that i could have is the encryption that i can get is the encrypt() function of Mysql ? If you know know some others please inform me. Secondly, cyrus creates the directories using only the username, but i need to be created like [EMAIL PROTECTED]/ The only thing that i tried to do is to use the virtdomains: userid in imapd.conf but again it didnt work. I want all the users to enter their full email address as it is stored in Mysql and moreover cyrus to create their directory using the username i.e [EMAIL PROTECTED]/ Any ideas ? Thank you in advance :) --- Cyrus Home Page: http://asg.web.cmu.edu/cyrus Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html
Cyrus-Imapd SERIOUS problem Please HELP
Well i have set up a postfix mailserver with cyrus sasl for smtp auth , cyrus imapd as the IMAP with Mysql as a back-end. Authentication is being done with pam-mysql I have a strange problem. When you enter a valid username you can login with ANY password, the IMAP responds .. OK User Loged in. i tried Almost ALL the how-to that exist but i couldnt find anything. so my last chance is to post here my config files and tell me IF there is a chance of fix that thing. Sorry for my big log but i am desperate . in order NOT to make a HUGE link i will post the config files in links so you just click the link and you see the config postfix main.cf - www.nightwish.gr/postfix/main.cf cyrus - www.nightwish.gr/postfix/cyrus.conf cyrus-imapd - www.nightwish.gr/postfix/imapd.conf mysql virtual files of postfix www.nightwish.gr/postfix/mysql_virtual_alias_maps.cf www.nightwish.gr/postfix/mysql_virtual_domains_maps.cf www.nightwish.gr/postfix/mysql_virtual_mailbox_maps.cf the files of pam.d www.nightwish.gr/postfix/imap www.nightwish.gr/postfix/smtp and finaly the cyrus-sasl file www.nightwish.gr/postfix/smtpd.conf and finaly see the output from the /var/log/messages Jul 14 21:29:56 verniki imap[38653]: mysql plugin couldnt connect to any host Jul 14 21:29:56 verniki imap[38653]: mysql plugin couldnt connect to any host Jul 14 21:29:56 verniki saslauthd[545]: pam_sm_authenticate called. Jul 14 21:29:56 verniki saslauthd[545]: dbuser changed. Jul 14 21:29:56 verniki saslauthd[545]: dbpasswd changed. Jul 14 21:29:56 verniki saslauthd[545]: host changed. Jul 14 21:29:56 verniki saslauthd[545]: database changed. Jul 14 21:29:56 verniki saslauthd[545]: table changed. Jul 14 21:29:56 verniki saslauthd[545]: usercolumn changed. Jul 14 21:29:56 verniki saslauthd[545]: passwdcolumn changed. Jul 14 21:29:56 verniki saslauthd[545]: crypt changed. Jul 14 21:29:56 verniki saslauthd[545]: sqllog changed. Jul 14 21:29:56 verniki saslauthd[545]: db_connect called. Jul 14 21:29:56 verniki saslauthd[545]: returning 0 . Jul 14 21:29:56 verniki saslauthd[545]: db_checkpasswd called. Jul 14 21:29:56 verniki saslauthd[545]: pam_mysql: where clause = Jul 14 21:29:56 verniki saslauthd[545]: SELECT password FROM mailbox WHERE username='koko' Jul 14 21:29:56 verniki saslauthd[545]: pam_mysql: select returned more than one result Jul 14 21:29:56 verniki saslauthd[545]: returning 9 after db_checkpasswd. Please help :s Thank you in advance --- Cyrus Home Page: http://asg.web.cmu.edu/cyrus Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html