Thank you for your reply Gordon, I searched and read through both lists for any information about this issue first. Then I submitted this to the Vchkpw list, since this issue surely involves Vpopmail and I know how much the Courier list loves to answer Vpopmail questions. :O)
Yet, my testing makes me believe this is an issue with Courier-authlib and how it uses Vpopmail. More directly, in how Courier-authlib implements MySQL Replication that is configured in Vpopmail. The reasons I believe this are ... 1) Vpopmail alone (used for SMTP Auth, and adding/deleting virtual domains) appears to correctly use the read DB for reads, and the write DB for writes. Only when using Courier-authlib for POP3 or Imap authentication does the problem show up. 2) Vpopmail does not use persistent DB connections natively, Courier-authlib implements these, and I'm seeing persistent connections appearing on the write/update DB (where I suspect there shouldn't be DB queries). i.e. I see connections to the write/update DB and also to the read only DB for a single POP3 authentication, which should only touch the read only DB. I'm guessing that Courier-authlib is handing the DB access on it's own accord, and not simply calling vchkpw (or those persistent connections wouldn't be there). And I'm guessing it is within that DB handling that both DBs are getting accessed? Unfortunately, my C programming skills are between zero and none. Thanks in advance, Shane Metler -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gordon Messmer Sent: Monday, May 23, 2005 12:45 PM To: courier-users@lists.sourceforge.net Subject: Re: [courier-users] read DB vs. write / update DB - Qmail, Vpopmail (authvchkpw & Mysql replication), Courier-pop3d [EMAIL PROTECTED] wrote: > > This setup works fine. MySQL is replicating, SMTP and POP3 > authentication is working, and all mail delivery is fine ... On the > surface there are no issues with these mail servers. > > But I noticed (while testing Courier-pop3d connections) that both the > read and the write MySQL servers (as specified in vpopmail.mysql) have > persistent connections opened up (user: vpopsqluser, table: vpopmail ) > after checking mail once via POP3. You're asking about an implementation issue in vpopmail. Their mailing list would be the best place to ask about that... ------------------------------------------------------- This SF.Net email is sponsored by Oracle Space Sweepstakes Want to be the first software developer in space? Enter now for the Oracle Space Sweepstakes! http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click _______________________________________________ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users ------------------------------------------------------- This SF.Net email is sponsored by Oracle Space Sweepstakes Want to be the first software developer in space? Enter now for the Oracle Space Sweepstakes! http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click _______________________________________________ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users