Re: [vchkpw] HUGE pop3 bottleneck
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Said Justin R. Miller on Wed, Sep 18, 2002 at 03:19:43PM -0400: Having gotten a chance to look at this, it seems like it requires the MySQL backend for authentication. I use the vpasswd files. Does anyone have a solution for this? For anyone who is curious, I have altered vpopmail to do just the SMTP relaying stuff in MySQL and NOT the whole auth backend. It seems to work cleanly, and combined with the tcpserver -S patch, proves to be quite fast and reliable. I am running about 600 POP3 logins per minute and there is no delay when adding the IP addresses to MySQL, and the relaying via tcpserver is quite fast too. I will post my patch soon if there is interest. - -- [!] Justin R. Miller [EMAIL PROTECTED] Encrypted email preferred (key 0xC9C40C31) -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE9iimn94d6K8nEDDERAr6JAJ0Yf34h4hLMcxCWTfvxtjYNrquhpQCeOmph gw4bq+E11aXhUcFMTpEJdeU= =nOG0 -END PGP SIGNATURE-
RE: [vchkpw] HUGE pop3 bottleneck
From: Justin R. Miller Said Justin R. Miller on Wed, Sep 18, 2002 at 03:19:43PM -0400: Having gotten a chance to look at this, it seems like it requires the MySQL backend for authentication. I use the vpasswd files. Does anyone have a solution for this? For anyone who is curious, I have altered vpopmail to do just the SMTP relaying stuff in MySQL and NOT the whole auth backend. It seems to work cleanly, and combined with the tcpserver -S patch, proves to be quite fast and reliable. I am running about 600 POP3 logins per minute and there is no delay when adding the IP addresses to MySQL, and the relaying via tcpserver is quite fast too. I will post my patch soon if there is interest. Please note one in favor of interest :-) --- Regards, Stig Martin Fiskaa
RE: [vchkpw] HUGE pop3 bottleneck
I use the Matt Simerson's awesome tcpserver/mysql patch to get around this problem. http://matt.simerson.net/computing/mail/qmail/ucspi-tcp-0.88-mysql.patch Regards, Paul Fries [EMAIL PROTECTED] -Original Message- From: Justin R. Miller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 9:15 AM To: [EMAIL PROTECTED] Subject: [vchkpw] HUGE pop3 bottleneck -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have just located a large source of problems with our installation. We average about 500 POP3 logins per minute and we had roaming users enabled. It seems that writing to the /usr/local/vpopmail/etc/open-smtp file was a large bottleneck since so many logins were attempting to write to the same file. Users would get file busy errors while successful logins, when they happened, would take upwards of a minute. Failures would happen instantly, since the file was not written to. Has anyone found an alternate solution to this? I now use authenticated SMTP only for this installation. Perhaps a directory of entries instead of a file, or some kind of file-based DB? Any ideas? We'd like to keep this feature, but with so many users, this seems to be the only system bottleneck on this system (about 13,000 domains). - -- [!] Justin R. Miller [EMAIL PROTECTED] Encrypted email preferred (key 0xC9C40C31) -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE9iKZ194d6K8nEDDERAo5GAJ45bcY0yWBNoU/9HORPLXOGxFFDwwCgktIi cDeeXrcqEHFTAJ0M9Ccuvg8= =ZocT -END PGP SIGNATURE-
RE: [vchkpw] HUGE pop3 bottleneck
There's a patch that has it run queries against a MySQL database instead of constantly rebuilding the cdb file. I don't remember where it is offhand, but search the archives. -Clayton -Original Message- From: Justin R. Miller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 9:15 AM To: [EMAIL PROTECTED] Subject: [vchkpw] HUGE pop3 bottleneck -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have just located a large source of problems with our installation. We average about 500 POP3 logins per minute and we had roaming users enabled. It seems that writing to the /usr/local/vpopmail/etc/open-smtp file was a large bottleneck since so many logins were attempting to write to the same file. Users would get file busy errors while successful logins, when they happened, would take upwards of a minute. Failures would happen instantly, since the file was not written to. Has anyone found an alternate solution to this? I now use authenticated SMTP only for this installation. Perhaps a directory of entries instead of a file, or some kind of file-based DB? Any ideas? We'd like to keep this feature, but with so many users, this seems to be the only system bottleneck on this system (about 13,000 domains). - -- [!] Justin R. Miller [EMAIL PROTECTED] Encrypted email preferred (key 0xC9C40C31) -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE9iKZ194d6K8nEDDERAo5GAJ45bcY0yWBNoU/9HORPLXOGxFFDwwCgktIi cDeeXrcqEHFTAJ0M9Ccuvg8= =ZocT -END PGP SIGNATURE-
Re: [vchkpw] HUGE pop3 bottleneck
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thank you very much both Paul and Clayton for your quick and very useful replies. I'm already checking it out... - -- [!] Justin R. Miller [EMAIL PROTECTED] Encrypted email preferred (key 0xC9C40C31) -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE9iKlm94d6K8nEDDERAjGcAJ99eEJjtFKgJAqZ368+PH4NCVamfACeNM+l LIvgjX7Iu4yhYA/Tvc1Pew0= =CUFx -END PGP SIGNATURE-
Re: [vchkpw] HUGE pop3 bottleneck
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Said Justin R. Miller on Wed, Sep 18, 2002 at 12:27:18PM -0400: I'm already checking it out... Having gotten a chance to look at this, it seems like it requires the MySQL backend for authentication. I use the vpasswd files. Does anyone have a solution for this? - -- [!] Justin R. Miller [EMAIL PROTECTED] Encrypted email preferred (key 0xC9C40C31) -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE9iNHP94d6K8nEDDERAs99AKCAaZ9fT51xv5vEKwotrpOV5AvScgCfQmAa Cw2rFcvhTpr7G1+FRlPK1Yw= =0Q58 -END PGP SIGNATURE-