Re: [opensuse] Cyrus-IMAP and MySQL support
Could someone please tell me if the Cyrus-IMAP RPM (cyrus-imapd-2.2.13-24.2.rpm) is built with SQL (particularly MySQL) support? If not, could someone please let me know how to do so :-)
Where do you want to use (my)sql in Cyrus-Imapd?
Hi Andreas Thank you for your reply I want to use MySQL for name/domain/password/maildir lookup maps in combination with Postfix and Cyrus-IMAPd. Do you know how I could find a Cyrus-IMAPd patch to build a MySQL-enabled Cyrus-IMAPd RPM, or what switches throw to custom compile Cyrus-IMAPd? I'm from a Red Hat/Fedora background, and I'm still figuring out openSuSE :-) Regrads, Stuart -- Then you will know the truth, and the truth will set you free. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 17 June 2007 13:14, Stuart Murray-Smith wrote:
Could someone please tell me if the Cyrus-IMAP RPM (cyrus-imapd-2.2.13-24.2.rpm) is built with SQL (particularly MySQL) support? If not, could someone please let me know how to do so :-)
Where do you want to use (my)sql in Cyrus-Imapd?
I want to use MySQL for name/domain/password/maildir lookup maps in combination with Postfix and Cyrus-IMAPd.
Do you know how I could find a Cyrus-IMAPd patch to build a MySQL-enabled Cyrus-IMAPd RPM, or what switches throw to custom compile Cyrus-IMAPd?
I'm from a Red Hat/Fedora background, and I'm still figuring out openSuSE :-)
Cyrus-Imapd does not use (my)sql. For the used Databases you can choose ie. Berkeley-DB or skiplist, but not sql. Authentification Data - Usernames and Passwords are stored and handled with Cyrus-SASL. There is a sql-Plugin for Cyrus-SASL available. The Name of the Package in 10.2 is cyrus-sasl-sqlauxprop. Oh, and Maildir is not the Format of the Mails stored by Cyrus-Imapd. Cyrus-Imapd is something like a Black-Box. Every access to Mails is only via the Network-Protocols LMTP, IMAP, POP3, NNTP. No File-Access, so Postfix should send Mails to Cyrus-Imapd via LMTP. I can't belive, that this is diffrent on other Platforms like RH. -- Andreas -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Thanks again Andreas
Cyrus-Imapd does not use (my)sql. For the used Databases you can choose ie. Berkeley-DB or skiplist, but not sql.
How to choose between BDB or skiplist?
Authentification Data - Usernames and Passwords are stored and handled with Cyrus-SASL. There is a sql-Plugin for Cyrus-SASL available. The Name of the Package in 10.2 is cyrus-sasl-sqlauxprop.
Yes, I've RPMed them all in
Oh, and Maildir is not the Format of the Mails stored by Cyrus-Imapd.
Agreed. It's the other one... I'm just very tired right now :-)
Cyrus-Imapd is something like a Black-Box. Every access to Mails is only via the Network-Protocols LMTP, IMAP, POP3, NNTP. No File-Access, so Postfix should send Mails to Cyrus-Imapd via LMTP.
I can't belive, that this is diffrent on other Platforms like RH.
From my original post I've been trying, without success, to get Web-CyrAdm working on openSuSE 10.2. Web-CyrAdm was originally developed by Luc de Louw on the SuSE platform, and I've seen it succesfully implemented in various RH derivatives using standard
Agreed, while the fundamental MTPs (mail transfer protocols, say :-) shouldn't be any different across the distros, the file structures and services however seem to be significantly so. packages (except for the rebuilding of Postfix with MySQL support). I'm struggling to figure out why I can't get Web-CyrAdm to work on it's original platform. Everything works except for loggind to the Cyrus-IMAP server from either an email client or webmail. Error logged below. You've given me something to think about, thank you for that. I'd appreciate any more insight you may have regarding the following error message: Jun 11 16:26:06 myserver saslauthd[5475]: server_exit : master exited: 5475 Jun 11 16:26:06 myserver saslauthd[5519]: detach_tty : master pid is: 5519 Jun 11 16:26:06 myserver saslauthd[5519]: ipc_init : listening on socket: /var/run/sasl2//mux Jun 11 16:26:17 myserver master[5528]: about to exec /usr/lib/cyrus/bin/pop3d Jun 11 16:26:17 myserver pop3[5528]: DBERROR: reading /var/lib/imap/db/skipstamp, assuming the worst: No such file or directory Jun 11 16:26:17 myserver pop3[5528]: executed Jun 11 16:26:17 myserver pop3[5528]: sql_select option missing Jun 11 16:26:17 myserver pop3[5528]: auxpropfunc error no mechanism available Jun 11 16:26:17 myserver pop3[5528]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql Jun 11 16:26:17 myserver pop3[5528]: skiplist: recovered /var/lib/imap/mailboxes.db (2 records, 724 bytes) in 0 seconds Jun 11 16:26:17 myserver pop3[5528]: accepted connection Regards, Stuart -- Then you will know the truth, and the truth will set you free. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 17 June 2007 18:08, Stuart Murray-Smith wrote:
Cyrus-Imapd does not use (my)sql. For the used Databases you can choose ie. Berkeley-DB or skiplist, but not sql.
How to choose between BDB or skiplist?
$ man imapd.conf ... annotation_db: ... duplicate_db: ... mboxlist_db: ... and so on.
Authentification Data - Usernames and Passwords are stored and handled with Cyrus-SASL. There is a sql-Plugin for Cyrus-SASL available. The Name of the Package in 10.2 is cyrus-sasl-sqlauxprop.
Yes, I've RPMed them all in
Oh, and Maildir is not the Format of the Mails stored by Cyrus-Imapd.
Agreed. It's the other one... I'm just very tired right now :-)
Cyrus-Imapd is something like a Black-Box. Every access to Mails is only via the Network-Protocols LMTP, IMAP, POP3, NNTP. No File-Access, so Postfix should send Mails to Cyrus-Imapd via LMTP.
I can't belive, that this is diffrent on other Platforms like RH.
Agreed, while the fundamental MTPs (mail transfer protocols, say :-) shouldn't be any different across the distros, the file structures and services however seem to be significantly so.
From my original post I've been trying, without success, to get Web-CyrAdm working on openSuSE 10.2. Web-CyrAdm was originally developed by Luc de Louw on the SuSE platform, and I've seen it succesfully implemented in various RH derivatives using standard packages (except for the rebuilding of Postfix with MySQL support). I'm struggling to figure out why I can't get Web-CyrAdm to work on it's original platform. Everything works except for loggind to the Cyrus-IMAP server from either an email client or webmail. Error logged below.
Show your config. At the beginning imapd.conf and cyrus.conf
You've given me something to think about, thank you for that. I'd appreciate any more insight you may have regarding the following error message:
Jun 11 16:26:06 myserver saslauthd[5475]: server_exit : master exited: 5475 Jun 11 16:26:06 myserver saslauthd[5519]: detach_tty : master pid is: 5519 Jun 11 16:26:06 myserver saslauthd[5519]: ipc_init : listening on socket: /var/run/sasl2//mux Jun 11 16:26:17 myserver master[5528]: about to exec /usr/lib/cyrus/bin/pop3d Jun 11 16:26:17 myserver pop3[5528]: DBERROR: reading /var/lib/imap/db/skipstamp, assuming the worst: No such file or directory Jun 11 16:26:17 myserver pop3[5528]: executed Jun 11 16:26:17 myserver pop3[5528]: sql_select option missing Jun 11 16:26:17 myserver pop3[5528]: auxpropfunc error no mechanism available Jun 11 16:26:17 myserver pop3[5528]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql Jun 11 16:26:17 myserver pop3[5528]: skiplist: recovered /var/lib/imap/mailboxes.db (2 records, 724 bytes) in 0 seconds Jun 11 16:26:17 myserver pop3[5528]: accepted connection
Regards,
Stuart
-- Then you will know the truth, and the truth will set you free.
-- Andreas -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 17 June 2007 13:58:53 Andreas Winkelmann wrote:
Cyrus-Imapd does not use (my)sql. For the used Databases you can choose ie. Berkeley-DB or skiplist, but not sql.
What's wrong with LDAP? It is a database which is highly optimised for reading, it seems to be best for authentication It can also be used through PAM. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 17 June 2007 19:16, Anders Johansson wrote:
Cyrus-Imapd does not use (my)sql. For the used Databases you can choose ie. Berkeley-DB or skiplist, but not sql.
What's wrong with LDAP? It is a database which is highly optimised for reading, it seems to be best for authentication
It can also be used through PAM.
Authentification is not handled from Cyrus-Imapd. This is the job of Cyrus-SASL. There is a ldap-Plugin for Cyrus-SASL available. And you can use ldap with saslauthd or saslauthd and pam. -- Andreas -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Tuesday 19 June 2007 06:57:13 Andreas Winkelmann wrote:
On Sunday 17 June 2007 19:16, Anders Johansson wrote:
Cyrus-Imapd does not use (my)sql. For the used Databases you can choose ie. Berkeley-DB or skiplist, but not sql.
What's wrong with LDAP? It is a database which is highly optimised for reading, it seems to be best for authentication
It can also be used through PAM.
Authentification is not handled from Cyrus-Imapd.
I don't believe I said it was
This is the job of Cyrus-SASL. There is a ldap-Plugin for Cyrus-SASL available. And you can use ldap with saslauthd or saslauthd and pam.
Sure, this is the default way the mail server setup is handled in SLES, it integrates nicely with the rest of the system (most things are prepared for LDAP authentication). I really see no need for involving databases which weren't designed for authentication. The only reason I can see is if there already is a user database available, but even then I would strongly advocate migrating it to LDAP -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (3)
-
Anders Johansson
-
Andreas Winkelmann
-
Stuart Murray-Smith