[Dbmail] DBMail and IMAP ... dropping connections
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]: '' Apr 30 07:15:24 MAIL-SRV dbmail/imap4d[26393]: arg[1]: '' 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 (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] DBMail and IMAP ... dropping connections
Hi all.. Sorry if I'm starting a new thread but I can't reply to any message since I've just joined the list ;). I upgraded to 1.2.7b too, but still I get those connection drops from mysql - but unlike John M. Brown I get those with pop3 too. Here's a short snap from my logs, in case they are helpful. May 4 17:29:12 46 dbmail/pop3d[30645]: PerformChildTask(): incoming connection from [1.2.3.4] May 4 17:29:12 46 dbmail/pop3d[30645]: PerformChildTask(): client info init complete, calling client handler May 4 17:29:12 46 dbmail/pop3d[30645]: create_unique_id(): created: 2ba72d9a365932cb2dd2e14083606ae8 May 4 17:29:12 46 dbmail/pop3d[30645]: pop3(): incoming buffer: [USER [EMAIL PROTECTED] May 4 17:29:12 46 dbmail/pop3d[30645]: pop3(): command issued :cmd [USER], value [EMAIL PROTECTED] May 4 17:29:12 46 dbmail/pop3d[30645]: pop3(): command looked up as commandtype 1 May 4 17:29:12 46 dbmail/pop3d[30645]: pop3(): incoming buffer: [PASS mypass] May 4 17:29:12 46 dbmail/pop3d[30645]: pop3(): command issued :cmd [PASS], value [mypass] May 4 17:29:12 46 dbmail/pop3d[30645]: pop3(): command looked up as commandtype 2 May 4 17:29:12 46 dbmail/pop3d[30645]: __auth_query(): connection failure May 4 17:29:12 46 dbmail/pop3d[30645]: auth_validate(): could not select user information May 4 17:29:12 46 dbmail/pop3d[30645]: pop3_handle_connection(): authorization layer failure May 4 17:29:12 46 dbmail/pop3d[30645]: PerformChildTask(): client handling complete, closing streams May 4 17:29:12 46 dbmail/pop3d[30645]: PerformChildTask(): connection closed Is there a simple way to fix it? Or would it be better to downgrade to like 1.6 or upgrade to 2.0? (I'm gonna use this mailserver on a daily basis, so I'd prefer having it running stably ;) ). Thanks, Rainer.
Re: [Dbmail] DBMail and IMAP ... dropping connections
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]: '' > Apr 30 07:15:24 MAIL-SRV dbmail/imap4d[26393]: arg[1]: '' > 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 (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 > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
Re: [Dbmail] DBMail and IMAP ... dropping connections
Got another problem when trying to add the line. Here's the error: In file included from /usr/include/mysql/mysql.h:64, from mysql/dbmysql.c:12: /usr/include/mysql/my_list.h:34: conflicting types for `list_reverse' list.h:43: previous declaration of `list_reverse' make: *** [mysql/dbmysql.o] Error 1 Sorry, Make failed. Please report any problems to the mailing list: dbmail@dbmail.org Upgrading to 1.2.7 version with MySQL 4.1 (latest) It compiles fine under 2.0rc4...but I can't use a release candidate on a production server. Any idea when 2.0 will be production ready? > > 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]: '' >> Apr 30 07:15:24 MAIL-SRV dbmail/imap4d[26393]: arg[1]: '' >> 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 (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 >> Dbmail@dbmail.org >> https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > > ___ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
Re: [Dbmail] DBMail and IMAP ... dropping connections
On Sun, 2004-05-02 at 20:41, John M. Brown wrote: > Got another problem when trying to add the line. > > Here's the error: > In file included from /usr/include/mysql/mysql.h:64, > from mysql/dbmysql.c:12: > /usr/include/mysql/my_list.h:34: conflicting types for `list_reverse' > list.h:43: previous declaration of `list_reverse' > make: *** [mysql/dbmysql.o] Error 1 > Sorry, Make failed. > Please report any problems to the mailing list: dbmail@dbmail.org > This is because of a function with the same name (list_reverse) that MySQL exports.. MySQL 4.0 does not export this function, AFAIK > Upgrading to 1.2.7 version with MySQL 4.1 (latest) > > It compiles fine under 2.0rc4...but I can't use a release candidate on a > production server. Any idea when 2.0 will be production ready? > Just out of curiosity: Why not run a release candidate when you do run alpha software (MySQL 4.1)? Ilja
Re: [Dbmail] DBMail and IMAP ... dropping connections
On Sun, 2004-05-02 at 18:58, Leif Jackson wrote: > 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. > Exactly. The reconnect option was missing. I've changed it in CVS. Just give me about ten minutes to release 1.2.7b.. Ilja
Re: [Dbmail] DBMail and IMAP ... dropping connections
You have a good point...but the reason for MySQL 4.1 is because it allows subqueries that are required for other software running through that server. I don't particularly like running alpha software, but I have been using MySQL for years and they have always proven to be stable for me even in the alpha and beta stages. I'll follow your suggestions and can always backup to 1.2.7 (or 1.2.6 as that's the one that actually compiled correctly before I updated to the later version of MySQL). Thanks. > On Sun, 2004-05-02 at 20:41, John M. Brown wrote: >> Got another problem when trying to add the line. >> >> Here's the error: >> In file included from /usr/include/mysql/mysql.h:64, >> from mysql/dbmysql.c:12: >> /usr/include/mysql/my_list.h:34: conflicting types for `list_reverse' >> list.h:43: previous declaration of `list_reverse' >> make: *** [mysql/dbmysql.o] Error 1 >> Sorry, Make failed. >> Please report any problems to the mailing list: dbmail@dbmail.org >> > This is because of a function with the same name (list_reverse) that > MySQL exports.. > > MySQL 4.0 does not export this function, AFAIK >> Upgrading to 1.2.7 version with MySQL 4.1 (latest) >> >> It compiles fine under 2.0rc4...but I can't use a release candidate on a >> production server. Any idea when 2.0 will be production ready? >> > Just out of curiosity: Why not run a release candidate when you do run > alpha software (MySQL 4.1)? > > Ilja > > > ___ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
Re: [Dbmail] DBMail and IMAP ... dropping connections
Okay, So I upgraded to 1.2.7b (with the conn.reconnect = 1 statement)...but I still get the same problem. After about a day of using the imap server I get the error "Connection dropped by Server" The POP3 (dbmail) and SMTP (Postfix) servers run just fine and do not give any errors. A restart of the dbmail imap server corrects the problem for another day. Any other ideas? (I'm working on an upgrade to 2.0, but since the table structure is a little different, and the configuration for the MTA is different I've got to do some more planning.) > On Sun, 2004-05-02 at 18:58, Leif Jackson wrote: >> 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. >> > > Exactly. The reconnect option was missing. I've changed it in CVS. Just > give me about ten minutes to release 1.2.7b.. > > Ilja > > ___ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail >