hi folks, i got a little problem setting up courier + mysql support. well actually this is working fine, i only want to seperate imap service and pop3 service for specific user (e.g user "a" pop3 and pop3s only, user "b" pop3 and pop3s and imap/imaps support) but i still don't get it running and i'm not sure anymore if this is possible at all.
to give you some kind of hint - here is my authmysqlrc: MYSQL_SERVER localhost MYSQL_USERNAME user MYSQL_PASSWORD psw MYSQL_SOCKET /var/run/mysqld/mysqld.sock MYSQL_PORT 0 MYSQL_OPT 0 MYSQL_DATABASE mail MYSQL_USER_TABLE mailbox MYSQL_CRYPT_PWFIELD m_password MYSQL_UID_FIELD "103" MYSQL_GID_FIELD "103" MYSQL_LOGIN_FIELD m_username MYSQL_HOME_FIELD "/mail/" MYSQL_NAME_FIELD m_realname MYSQL_MAILDIR_FIELD m_maildir MYSQL_WHERE_CLAUSE m_pop3='1' AND m_pop3s='1' OR m_imap='1' AND m_imaps='1' the corresponding fields in the mailbox table: m_email m_username m_password m_realname m_maildir m_quota m_quota_msg m_smtp m_pop3 m_pop3s m_imap m_imaps m_stop m_create_date m_change_date logging in is actually possible, but it seems like courier doesnt't care about the MYSQL_WHERE_CLAUSE at all. i also tried to seperate the services with other MYSQL_WHERE_CLAUSES (e.g.:MYSQL_WHERE_CLAUSE $(service)=1) but with same result. if i login i get the following query string in the mysql.log: SELECT m_username, m_password, "", "103", "103", "/mail/", m_maildir, "", m_realname, "" FROM mailbox WHERE m_username = "user" AND (m_pop3='1' AND m_pop3s='1' OR m_imap='1' AND m_imaps='1') i appreciate any hints, thanks for your advice, kind regards, werner detter _____________________________________________________________________ Der WEB.DE Virenschutz schuetzt Ihr Postfach vor dem Wurm Beagle.A-J! Kostenfrei fuer FreeMail Nutzer. http://f.web.de/?mc=021158 ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
