Re: [Dovecot] MySQL as a storage only.?

2008-12-23 Thread Timo Sirainen
On Dec 23, 2008, at 4:51 AM, R A wrote: Romer Ventura wrote: Hello, I was wondering is I could use MySQL as storage only..? Meaning that no user information, other than the obvious email address associated with an specific email so that each email can be showed to the right user,

Re: [Dovecot] MySQL as a storage only.?

2008-12-23 Thread Neil
On Tue, Dec 23, 2008 at 2:20 AM, Timo Sirainen t...@iki.fi wrote: On Dec 23, 2008, at 4:51 AM, R A wrote: Especially if you try to implement cloud-like services, where you have the possibility of links temporarily going down between servers, and mail can come in to any point, and be retrieved

Re: [Dovecot] delivers mail to bad directory(prefix) using sieve filters

2008-12-23 Thread Radim Roska
really nobody has similar issue? On Mon, Dec 15, 2008 at 7:29 PM, Radim Roska radim.ro...@gmail.com wrote: Hi, I've installed dovecot debian stable(from backports) version (1.0.15). Its great..i just have problem with sieve filters. I use only web tool for creating filters that works for me

Re: [Dovecot] delivers mail to bad directory(prefix) using sieve filters

2008-12-23 Thread Neil
On Tue, Dec 23, 2008 at 4:53 AM, Radim Roska radim.ro...@gmail.com wrote: really nobody has similar issue? On Mon, Dec 15, 2008 at 7:29 PM, Radim Roska radim.ro...@gmail.com wrote: Hi, I've installed dovecot debian stable(from backports) version (1.0.15). Its great..i just have problem

[Dovecot] 1.1.6 - 1.1.7 regression: dovecot: pipe() failed: Too many open files

2008-12-23 Thread Mark Zealey
Hi all, We updated to 1.1.7 a week or two back from 1.1.6 (both standard atrpms builds). Since doing so, twice now I've seen the imap services accept connections but they hang before the banner is printed (pop seems to be unaffected). I see this in the logs: Dec 23 14:02:15 mail9 dovecot: pipe()

Re: [Dovecot] change sender name in Sieve

2008-12-23 Thread Stephan Bosch
Jakob Grießmann wrote: Hi, thanks a lot for the fast reply! Any other choice to avoid that bug without patching the package? I'm using vanilla Debian/Ubuntu builds here and like to avoid manual compilation... Unfortunately, no. You could ask the Debian package maintainers to apply this trivial

Re: [Dovecot] Password field limitations

2008-12-23 Thread Charles Marcus
On 12/23/2008, Tom Sommer (m...@tomsommer.dk) wrote: What limitations are imposed on the password for IMAP/POP3 users? I've had a customer saying they can't use passwords which contain . or :, and some seem to have problems when the password is 8 characters. If I'm not mistaken, dovecot

[Dovecot] Password field limitations

2008-12-23 Thread Tom Sommer
Hi, I've searched the WIKI for this information but seem unable to find anything about it. What limitations are imposed on the password for IMAP/POP3 users? I've had a customer saying they can't use passwords which contain . or :, and some seem to have problems when the password is 8

Re: [Dovecot] Password field limitations

2008-12-23 Thread Luigi Rosa
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Charles Marcus said the following on 23/12/08 18:06: What limitations are imposed on the password for IMAP/POP3 users? I've had a customer saying they can't use passwords which contain . or :, and some seem to have problems when the password is 8

[Dovecot] Replication (Re: MySQL as a storage only.?)

2008-12-23 Thread Seth Mattinen
Timo Sirainen wrote: I've also planned easy replication support for Dovecot. Also I don't think doing the SQL replication correctly and without losing any data on error conditions is as easy as you think. Multiple master in MySQL is still more of a hack. Also, performance for billion-row

Re: [Dovecot] change sender name in Sieve

2008-12-23 Thread Seth Mattinen
Stephan Bosch wrote: Jakob Grießmann wrote: Hi, thanks a lot for the fast reply! Any other choice to avoid that bug without patching the package? I'm using vanilla Debian/Ubuntu builds here and like to avoid manual compilation... Unfortunately, no. You could ask the Debian package maintainers

Re: [Dovecot] MySQL as a storage only.?

2008-12-23 Thread Jack Stewart
Neil wrote: On Tue, Dec 23, 2008 at 2:20 AM, Timo Sirainen t...@iki.fi wrote: On Dec 23, 2008, at 4:51 AM, R A wrote: Especially if you try to implement cloud-like services, where you have the possibility of links temporarily going down between servers, and mail can come in to any point, and

Re: [Dovecot] MySQL as a storage only.?

2008-12-23 Thread Seth Mattinen
Jack Stewart wrote: Neil wrote: On Tue, Dec 23, 2008 at 2:20 AM, Timo Sirainen t...@iki.fi wrote: On Dec 23, 2008, at 4:51 AM, R A wrote: Especially if you try to implement cloud-like services, where you have the possibility of links temporarily going down between servers, and mail can come

Re: [Dovecot] Password field limitations

2008-12-23 Thread Charles Marcus
On 12/23/2008 12:25 PM, Luigi Rosa wrote: If I'm not mistaken, dovecot doesn't care - this will be a limitation of your Filesystem and/or password storage tool... in this case, MySQL... I Use MySQL and I don't have such kind of limitations. I would blame Tom's MySQL interface or

[Dovecot] SQL field format for digest-md5?

2008-12-23 Thread Darren Pilgrim
I'm enabling digest-md5 authentication with u...@example.com username and plain-text passwords stored in a MySQL database. What should the password field contain in order to work with digest-md5? Would the following: SELECT CONCAT('{digest-md5}', MD5(CONCAT(username, '::', password))) AS

Re: [Dovecot] SQL field format for digest-md5?

2008-12-23 Thread Timo Sirainen
On Dec 23, 2008, at 8:57 PM, Darren Pilgrim wrote: I'm enabling digest-md5 authentication with u...@example.com username and plain-text passwords stored in a MySQL database. What should the password field contain in order to work with digest-md5? Would the following: SELECT

[Dovecot] Possible to log IMAP connections to MySQL Table?

2008-12-23 Thread Corey Shaw
Is it currently possible to log all IMAP connection attempts to a MySQL table?   Thanks. _ Corey

Re: [Dovecot] Possible to log IMAP connections to MySQL Table?

2008-12-23 Thread Seth Mattinen
Corey Shaw wrote: Is it currently possible to log all IMAP connection attempts to a MySQL table? Thanks. Sure. You could use syslog-ng to log directly to a database or syslog plus SEC (http://kodu.neti.ee/~risto/sec/) to trigger insert rules. ~Seth

Re: [Dovecot] Possible to log IMAP connections to MySQL Table?

2008-12-23 Thread Brandon Lamb
On Tue, Dec 23, 2008 at 1:30 PM, Seth Mattinen se...@rollernet.us wrote: Corey Shaw wrote: Is it currently possible to log all IMAP connection attempts to a MySQL table? Thanks. Sure. You could use syslog-ng to log directly to a database or syslog plus SEC (http://kodu.neti.ee/~risto/sec/)

Re: [Dovecot] Possible to log IMAP connections to MySQL Table?

2008-12-23 Thread Corey Shaw
On our current mail system we've gone down the route of a PHP script as well for logging the connections.  Since I use metalog for logging (instead of syslog-ng) and I don't really want to make an exception for one of our servers, I'll probably still have to use that script.  I definitely want

Re: [Dovecot] SQL field format for digest-md5?

2008-12-23 Thread Darren Pilgrim
Timo Sirainen wrote: On Dec 23, 2008, at 8:57 PM, Darren Pilgrim wrote: I'm enabling digest-md5 authentication with u...@example.com username and plain-text passwords stored in a MySQL database. What should the password field contain in order to work with digest-md5? Would the

Re: [Dovecot] Possible to log IMAP connections to MySQL Table?

2008-12-23 Thread Seth Mattinen
Brandon Lamb wrote: On Tue, Dec 23, 2008 at 1:30 PM, Seth Mattinen se...@rollernet.us wrote: Corey Shaw wrote: Is it currently possible to log all IMAP connection attempts to a MySQL table? Thanks. Sure. You could use syslog-ng to log directly to a database or syslog plus SEC

[Dovecot] Dovecot-auth timeouts

2008-12-23 Thread Javier Fox
Hello, I've unfortunately been unable to find anything relating to the problem I'm having specifically, in searching the list or google, and so I now plead to you to assistance. I'm running Dovecot as an LDA and SASL auth for Postfix on a Debian 4 box. Dovecot is version 1.0.rc15 (the

Re: [Dovecot] Possible to log IMAP connections to MySQL Table?

2008-12-23 Thread Brandon Lamb
On Tue, Dec 23, 2008 at 1:54 PM, Seth Mattinen se...@rollernet.us wrote: Brandon Lamb wrote: On Tue, Dec 23, 2008 at 1:30 PM, Seth Mattinen se...@rollernet.us wrote: Corey Shaw wrote: Is it currently possible to log all IMAP connection attempts to a MySQL table? Thanks. Sure. You could

Re: [Dovecot] Possible to log IMAP connections to MySQL Table?

2008-12-23 Thread Justin Krejci
If you use MySQL for auth you could include some logging bits as part of your SQL query. -Original Message- From: dovecot-bounces+jkrejci=usinternet@dovecot.org [mailto:dovecot-bounces+jkrejci=usinternet@dovecot.org] On Behalf Of Corey Shaw Sent: Tuesday, December 23, 2008 2:50 PM

[Dovecot] SSL cert problems.

2008-12-23 Thread Geoff Sweet
I'm really racking my brain trying to figure this one out here. I am running a pop3 server for remote offices on CentOS 5.2. We purchased a SSL cert from Verisign and installed it on our dovecot server, but I continue to get failure problems with the cert and I don't know where to go from here.

Re: [Dovecot] Replication (Re: MySQL as a storage only.?)

2008-12-23 Thread R A
Seth Mattinen wrote: Multiple master in MySQL is still more of a hack. Also, performance for billion-row SQL tables is rather poor for something interactive like clicking on a message in IMAP and expecting it to pop up right away. I'm looking forward to master-master replication. Not SQL

Re: [Dovecot] Replication (Re: MySQL as a storage only.?)

2008-12-23 Thread Seth Mattinen
R A wrote: Seth Mattinen wrote: Multiple master in MySQL is still more of a hack. Also, performance for billion-row SQL tables is rather poor for something interactive like clicking on a message in IMAP and expecting it to pop up right away. I'm looking forward to master-master replication.

Re: [Dovecot] SSL cert problems.

2008-12-23 Thread Sahil Tandon
Geoff Sweet wrote: and last but not least, here is my test from openssl. Mind you this fails as a BAD ssl cert in Evolution. :~$ openssl s_client -ssl2 -connect pop.x10.com:995 Try -ssl3 here; you'll see more. CONNECTED(0003) depth=0 /C=US/ST=Washington/L=Renton/O=X10 Wireless

Re: [Dovecot] Possible to log IMAP connections to MySQL Table?

2008-12-23 Thread Luigi Rosa
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Seth Mattinen said the following on 23/12/08 22:30: Sure. You could use syslog-ng to log directly to a database or syslog plus SEC (http://kodu.neti.ee/~risto/sec/) to trigger insert rules. Or you can enable MySQL query log and see what's