I am betting that my mysql auto-reconnect change that went into 2.x devel
tree didn't get into 1.2.x Ilja? maybe we can get out a 1.2.7b anyway in
the db_connect area you have to add a line like...

        /* auto re-connect */
        conn.reconnect = 1;

this is right after the mysql_init in the dbmysql.c (around line 68) and
then re-compile it shouldn't ever have this issue again.

-Leif

> I got the 1.2.6 dbmail installed and working perfect...except...
>
> I'm running dbmail-pop3 and dbmail-imapd.  They both work fine for about a
> day.  Almost exactly 24 hours (don't think that's important) later the
> IMAP server starts dropping connections and it won't let me check my mail.
>
> The pop3 server is still functioning fine...and postfix is working fine
> too...this seems to be only related to the dbmail-imapd server.  This has
> occurred for the last 4 days in a row.
>
> MySQL Server is running fine and max connections was around 121
> (configured to allow 500 connections).
>
> The maillog file is as follows:
>
> Apr 30 07:15:24 MAIL-SRV dbmail/imap4d[26393]: PerformChildTask():
> incoming connection from [127.0.0.1 (MAIL-SRV)]
> Apr 30 07:15:24 MAIL-SRV dbmail/imap4d[26393]: PerformChildTask(): client
> info init complete, calling client handler
> Apr 30 07:15:24 MAIL-SRV dbmail/imap4d[26393]: IMAPClientHandler(): line
> read for PID 26393
> Apr 30 07:15:24 MAIL-SRV dbmail/imap4d[26393]: COMMAND: [A001 LOGIN
> "[EMAIL PROTECTED]" "admin99366"]
> Apr 30 07:15:24 MAIL-SRV dbmail/imap4d[26393]: arg[0]: '<hidden-email>'
> Apr 30 07:15:24 MAIL-SRV dbmail/imap4d[26393]: arg[1]: '<hidden-pass>'
> Apr 30 07:15:24 MAIL-SRV dbmail/imap4d[26393]: IMAPClientHandler():
> Executing command login...
> Apr 30 07:15:24 MAIL-SRV dbmail/imap4d[26393]: _ic_login(): trying to
> validate user
> Apr 30 07:15:24 MAIL-SRV dbmail/imap4d[26393]: __auth_query(): connection
> failure
> Apr 30 07:15:24 MAIL-SRV dbmail/imap4d[26393]: auth_validate(): could not
> select user information
> Apr 30 07:15:25 MAIL-SRV dbmail/imap4d[26393]: _ic_login(): user
> (id:18446744073709551615, name [EMAIL PROTECTED]) tries login^M
> Apr 30 07:15:25 MAIL-SRV dbmail/imap4d[26393]: _ic_login(): db-validate
> error while validating user <hidden-email> (pass <hidden-pass>).
> Apr 30 07:15:25 MAIL-SRV dbmail/imap4d[26393]: IMAPClientHandler():
> Finished command login
> Apr 30 07:15:25 MAIL-SRV dbmail/imap4d[26393]: IMAPClientHandler():
> Closing connection for client from IP [127.0.0.1]
> Apr 30 07:15:25 MAIL-SRV dbmail/imap4d[26393]: PerformChildTask(): client
> handling complete, closing streams
> Apr 30 07:15:25 MAIL-SRV dbmail/imap4d[26393]: PerformChildTask():
> connection closed
> Apr 30 07:15:25 MAIL-SRV dbmail/imap4d[26393]: PerformChildTask(): waiting
> for connection
>
> Any suggestions on what to look at?  It looks like it's the _auth_query()
> connection problem...but I don't really know.
>
> _______________________________________________
> Dbmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>

Reply via email to