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 user/group
So... And If We ask the developers? It'll be very helpful for those intends to create RPMs if We could compile without check user / group... 2007/10/3, Christopher Chan [EMAIL PROTECTED]: Rick Widmer wrote: Christopher Chan wrote: Rick Widmer wrote: Christopher Chan wrote: Rick Widmer wrote: Christopher Chan wrote: Rick Widmer wrote: Christopher Chan wrote: Have you created the vpopmail user and vchkpw group? If not you must. Yes, I will create they when installing the package in my destination host. This is the why I need to get these values into the package when building. The build host isn't my dest host. That is a tough nut to crack. IIRC, vpopmail default uid/gid conflicts with postfix on Redhat distros. What is the problem? Just create the group and user with different values. It doesn't matter what the number is, it just has to exist when your run ./configure. Oh, the vpopmail uid and gid is not hardcoded into the binaries? The uid and gid are hard coded into the bianaries by ./configure. I cannot then use them on another host where they are different then. No. Well, that was the whole point of OP's post and why I said it was a tough nut to crack. The OP wants to build a package that will be used on other hosts... Then use the same numbers for the uid and gid values for all qmail and vpopmail users on all systems. Ah, but what can I do if those systems are not mine? I have been planning on make a package for Centos users and to have it included on one of the Centos repositories. -- [ ]'s Aledr - Alexandre OpenSource Solutions for SmallBusiness Problems
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