Re: [vchkpw] Vpopmail mysql and aborted clients
the warnings are daily... on sarge unless on etch yesterday in a testing machine I had a hang of courier and had to restart it by hand, but today have started mysqld_safe with --wait_timeout=345600 and haven't seen today any warning and courier has logged properly... I'm gonna check the two solutions... the wait_timeout increasing and the vmysql.patch... (that I think it come from vpopmail 5.4.17 to more newer...) thanks a lot mates :) have a nice day [EMAIL PROTECTED] wrote: Yes it really goes ok... and now for example the server has a uptime of more or less 110 days... I have never had to restart courier-imap package (wich I use for pop and imap services) and seems to be running ok... so this is normal then? and I shouldn't change nothing then? or is it advisable to increase mysql timeout?? or I could stay as I'm now? I would suggest setting the mysql timeout to about twice the longest interval between pop/imap logins. 4 or 5 days is probably good. One day wouldn't be bad if you don't mind seeing a few warnings on weekends. I don't use mysql though. Rick
Re: [vchkpw] Vpopmail mysql and aborted clients
[EMAIL PROTECTED] wrote: Yes it really goes ok... and now for example the server has a uptime of more or less 110 days... I have never had to restart courier-imap package (wich I use for pop and imap services) and seems to be running ok... so this is normal then? and I shouldn't change nothing then? or is it advisable to increase mysql timeout?? or I could stay as I'm now? I would suggest setting the mysql timeout to about twice the longest interval between pop/imap logins. 4 or 5 days is probably good. One day wouldn't be bad if you don't mind seeing a few warnings on weekends. I don't use mysql though. Rick
Re: [vchkpw] Vpopmail mysql and aborted clients
So then no matter for worrying about this? This can't break the database or... don't know cause any type of problem... or should I do any conf in authdaemon for this to be avoided? or is this normal and nothing happens with it? Thanks a lot!!! As told in other messages, the way of playing is different. Each vpopmail/qmail program usually executes brieftly and opens and closes MySQL, so there are no abnormal exits. When courier plays (both imap and pop), it asks auth data to courier's auth daemon. When this daemon is started, it opens MySQL and never closes it, as it supposes to reuse continuosly the same opened connection. But if none is going to use the connection for eigth hours, MySQL itself closes the connection. This will be opened again automatically by vpopmail library in courier's daemon, but you see an error in MySQL stats. Hope I've been clear. Tonino At 12.54 05/10/2007, [EMAIL PROTECTED] wrote: sorry for insisting but this happens when courier enters, it's the same for pop, or imap or... in the moment courier enters in the play for imap only imagine because you use qmail-pop there in the way I told yesterday... after some time of inactivity happens this... sorry for insisting At 04.55 05/10/2007, you wrote: tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail? Yes, but you see in the logs that some connections have been dropped. Tonino Yep but wait a minute! if you have a machine in wich you only run qmail for mail scanning or smtp relay, or even with qmail-pop3d you don't get those aborted clients... but if you run there pop and imap with couier, so the problem occurs when you use courier... if you don't use it... you don't see any error... and both use vpopmail equally aren't they (courier and qmail) ? if you have for example qmail-smtpd with smtp auth only and of course vpopmail you will never have that errors... and you go to ask to courier and they say is a vpopmail question... but vpopmail works fine with qmail-smtpd!!! this was an important detail I forgot to tell yesterday... could this give you any more clue???
Re: [vchkpw] Vpopmail mysql and aborted clients
If your courier still works without you need to restart it, it means you already have vpopmail in the right configuration, and you are only facing a log warning (which reason is now known). Ciao, Tonino At 11.00 06/10/2007, you wrote: So then no matter for worrying about this? This can't break the database or... don't know cause any type of problem... or should I do any conf in authdaemon for this to be avoided? or is this normal and nothing happens with it? Thanks a lot!!! As told in other messages, the way of playing is different. Each vpopmail/qmail program usually executes brieftly and opens and closes MySQL, so there are no abnormal exits. When courier plays (both imap and pop), it asks auth data to courier's auth daemon. When this daemon is started, it opens MySQL and never closes it, as it supposes to reuse continuosly the same opened connection. But if none is going to use the connection for eigth hours, MySQL itself closes the connection. This will be opened again automatically by vpopmail library in courier's daemon, but you see an error in MySQL stats. Hope I've been clear. Tonino At 12.54 05/10/2007, [EMAIL PROTECTED] wrote: sorry for insisting but this happens when courier enters, it's the same for pop, or imap or... in the moment courier enters in the play for imap only imagine because you use qmail-pop there in the way I told yesterday... after some time of inactivity happens this... sorry for insisting At 04.55 05/10/2007, you wrote: tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail? Yes, but you see in the logs that some connections have been dropped. Tonino Yep but wait a minute! if you have a machine in wich you only run qmail for mail scanning or smtp relay, or even with qmail-pop3d you don't get those aborted clients... but if you run there pop and imap with couier, so the problem occurs when you use courier... if you don't use it... you don't see any error... and both use vpopmail equally aren't they (courier and qmail) ? if you have for example qmail-smtpd with smtp auth only and of course vpopmail you will never have that errors... and you go to ask to courier and they say is a vpopmail question... but vpopmail works fine with qmail-smtpd!!! this was an important detail I forgot to tell yesterday... could this give you any more clue???
Re: [vchkpw] Vpopmail mysql and aborted clients
Christopher Chan wrote: [EMAIL PROTECTED] wrote: So then no matter for worrying about this? This can't break the database or... don't know cause any type of problem... or should I do any conf in authdaemon for this to be avoided? or is this normal and nothing happens with it? Either restarted authdaemon if this happens or upgrade vpopmail. This should not break the database. It just affects your imap connections. Or change your my.cnf for mysql to allow unlimited timeout's. That's what I did (Well I actually set it to 4 days). Rick
Re: [vchkpw] Vpopmail mysql and aborted clients
sorry for insisting but this happens when courier enters, it's the same for pop, or imap or... in the moment courier enters in the play for imap only imagine because you use qmail-pop there in the way I told yesterday... after some time of inactivity happens this... sorry for insisting At 04.55 05/10/2007, you wrote: tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail? Yes, but you see in the logs that some connections have been dropped. Tonino Yep but wait a minute! if you have a machine in wich you only run qmail for mail scanning or smtp relay, or even with qmail-pop3d you don't get those aborted clients... but if you run there pop and imap with couier, so the problem occurs when you use courier... if you don't use it... you don't see any error... and both use vpopmail equally aren't they (courier and qmail) ? if you have for example qmail-smtpd with smtp auth only and of course vpopmail you will never have that errors... and you go to ask to courier and they say is a vpopmail question... but vpopmail works fine with qmail-smtpd!!! this was an important detail I forgot to tell yesterday... could this give you any more clue???
Re: [vchkpw] Vpopmail mysql and aborted clients
At 04.55 05/10/2007, you wrote: tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail? Yes, but you see in the logs that some connections have been dropped. Tonino Yep but wait a minute! if you have a machine in wich you only run qmail for mail scanning or smtp relay, or even with qmail-pop3d you don't get those aborted clients... but if you run there pop and imap with couier, so the problem occurs when you use courier... if you don't use it... you don't see any error... and both use vpopmail equally aren't they (courier and qmail) ? if you have for example qmail-smtpd with smtp auth only and of course vpopmail you will never have that errors... and you go to ask to courier and they say is a vpopmail question... but vpopmail works fine with qmail-smtpd!!! this was an important detail I forgot to tell yesterday... could this give you any more clue???
Re: [vchkpw] Vpopmail mysql and aborted clients
thanks a lot mates for you're answers, and in where logs could you see connections have been droped?? you doing an overview for all answers some mysql versions have timeout for it's persistent connections (connections as vpopmail connections) and this causes connection not to close properly and the aborted client... so then is a mysql issue?? could this cause problems? At 04.55 05/10/2007, you wrote: tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail? Yes, but you see in the logs that some connections have been dropped. Tonino
Re: [vchkpw] Vpopmail mysql and aborted clients
At 04.55 05/10/2007, you wrote: tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail? Yes, but you see in the logs that some connections have been dropped. Tonino
Re: [vchkpw] Vpopmail mysql and aborted clients
[EMAIL PROTECTED] wrote: sorry for insisting but this happens when courier enters, it's the same for pop, or imap or... in the moment courier enters in the play for imap only imagine because you use qmail-pop there in the way I told yesterday... after some time of inactivity happens this... sorry for insisting The problem does not really lie with courier. All qmail processes run under tcpserver and are only invoked when a connection appears. courier has this authdaemon that maintains persistent connections to mysql via the vpopmail library and so its behaviour is different from being run under tcpserver in qmail-smtpd or qmail-pop3d. This is why it appears that courier is the problem but it actually is not. It is just that courier has a different way of being run and this was not taken into account by vpopmail because none of the relevant qmail processes run persistently.
Re: [vchkpw] Vpopmail mysql and aborted clients
As told in other messages, the way of playing is different. Each vpopmail/qmail program usually executes brieftly and opens and closes MySQL, so there are no abnormal exits. When courier plays (both imap and pop), it asks auth data to courier's auth daemon. When this daemon is started, it opens MySQL and never closes it, as it supposes to reuse continuosly the same opened connection. But if none is going to use the connection for eigth hours, MySQL itself closes the connection. This will be opened again automatically by vpopmail library in courier's daemon, but you see an error in MySQL stats. Hope I've been clear. Tonino At 12.54 05/10/2007, [EMAIL PROTECTED] wrote: sorry for insisting but this happens when courier enters, it's the same for pop, or imap or... in the moment courier enters in the play for imap only imagine because you use qmail-pop there in the way I told yesterday... after some time of inactivity happens this... sorry for insisting At 04.55 05/10/2007, you wrote: tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail? Yes, but you see in the logs that some connections have been dropped. Tonino Yep but wait a minute! if you have a machine in wich you only run qmail for mail scanning or smtp relay, or even with qmail-pop3d you don't get those aborted clients... but if you run there pop and imap with couier, so the problem occurs when you use courier... if you don't use it... you don't see any error... and both use vpopmail equally aren't they (courier and qmail) ? if you have for example qmail-smtpd with smtp auth only and of course vpopmail you will never have that errors... and you go to ask to courier and they say is a vpopmail question... but vpopmail works fine with qmail-smtpd!!! this was an important detail I forgot to tell yesterday... could this give you any more clue???
Re: [vchkpw] Vpopmail mysql and aborted clients
MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). Ciao, Tonino At 09.36 04/10/2007, you wrote: Hi, I'm running vpopmail-5.4.13 with courier-imap-4.0.2 and courier-authlib-0.55... have noticed that each morning for example after all the night without poping or imaping... the next time someone pop or imap in the morning I get no errors on mail client and everything works fine... but have noticed that 10 aborted cliets appear... in show status in mysql... it is as this near 1 year now (since I set up that server) and everything works fine and there's any error and everything fine... but only those aborted clients each morning... why is this happening? I have asked sometime in courier mailing lists but they say me to ask at vpopmail mailing lists... and I know qmail and vpopmail both don't cause this aborteds because I have another machine in the same way configured (of course as the machine in wich this is seeing) but without courier because it's only for mail scanning and have any aborted client... each machine has it's own mysql server... and I'm totally sure this aborted happen when courier talks to vpopmail the first time after a inactivity period... is this normal¿? why happens this?? Have a nice day! P.D. John (John Simpson) perhaps this could be a challenge for you :)
Re: [vchkpw] Vpopmail mysql and aborted clients
On 2007-10-04, at 0336, [EMAIL PROTECTED] wrote: ... have noticed that each morning for example after all the night without poping or imaping... the next time someone pop or imap in the morning I get no errors on mail client and everything works fine... but have noticed that 10 aborted cliets appear... in show status in mysql... P.D. John (John Simpson) perhaps this could be a challenge for you :) i don't know a whole lot about how vpopmail uses mysql, the only thing i use mysql for is the back-end storage for my jabber server, and a few clients who need it for their web sites. my only guess would be the eight-hour timeout that tonix already mentioned. | John M. Simpson--- KG4ZOW ---Programmer At Large | | http://www.jms1.net/ [EMAIL PROTECTED] | | http://video.google.com/videoplay?docid=-1656880303867390173 | PGP.sig Description: This is a digitally signed message part
Re: [vchkpw] Vpopmail mysql and aborted clients
tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail?
Re: [vchkpw] Vpopmail mysql and aborted clients
On 2007-10-04, at 2255, Christopher Chan wrote: tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail? when vpopmail tries to do something on the sql server and gets a connection was closed error, it now opens a new connection and tries the operation again. it sounded like he was talking about seeing the stale client threads/ processes within the sql server itself, which for whatever reason hadn't been harvested by the sql server's reaper. if so, that question has more to do with the sql server's internals than it does with vpopmail. | John M. Simpson--- KG4ZOW ---Programmer At Large | | http://www.jms1.net/ [EMAIL PROTECTED] | | http://video.google.com/videoplay?docid=-1656880303867390173 | PGP.sig Description: This is a digitally signed message part