I'm not exactly sure which list to bounce this request off of but I'll start here. If this would be better on a different list, please let me know.
ok... Server farm setup is.... srv01 - mysql-master database. srv02, srv03 and srv04 are machines with identical installation of qmail/mysql/vpopmail/courier/etc... (built using Matt Simerson's toaster.) srv05 is an NFS storage server. srv02, srv03 and srv04 have mysql servers that are replicated from srv01. vpopmail version is 5.4.2 ucspi-tcp is 0.88 with Simerson's mysql+rss patch. courier-imap is 3.0.2 mysql is 4.0.18 (srv01 through srv04 have same versions) Everything seems to be working fine but the last couple of days, I'll occassionaly see the following in my logs. Jun 29 11:07:18 srv03 vpopmail[47983]: vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:10.x.x.x Jun 29 11:07:18 srv03 imapd: vmysql: sql error[1]: Can't create database 'vpopmail'. Database exists Jun 29 11:07:18 srv03 vpopmail[47986]: vchkpw-pop3: (PLAIN) login success [EMAIL PROTECTED]:x.x.x.x Jun 29 11:07:18 srv03 vpopmail[47988]: vchkpw-pop3: (PLAIN) login success [EMAIL PROTECTED]:x.x.x.x Jun 29 11:07:18 srv03 imapd: vmysql: sql error[1]: Can't create database 'vpopmail'. Database exists Jun 29 11:07:18 srv03 imapd: vmysql: sql error[1]: Can't create database 'vpopmail'. Database exists Jun 29 11:07:18 srv03 vpopmail[47976]: vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:x.x.x.x Jun 29 11:07:23 srv03 imapd: LOGIN FAILED, ip=[::ffff:172.x.x.x] Jun 29 11:07:23 srv03 last message repeated 2 times Jun 29 11:07:24 srv03 vpopmail[48017]: vchkpw-pop3: (PLAIN) login success [EMAIL PROTECTED]:10.x.x.x What would cause the vmysql: sql error[1]: Can't create database 'vpopmail'. Database exists ?????? When running in DNS round robin configuration, when this error happens it seems to happen on all three machines at the same time. I'm doing a carbon copy of my Yahoo account to help make sure I see responses as there is a chance due to this error that my mail mail server cluster may not be receiving all email. Thanks for any help. David Brinks -- Power-Net Internet Services -- Network Manager [EMAIL PROTECTED] Local Office : 402 N. Mission, Mt.Pleasant, MI 48858 Phone : 989.772.1121 Fax : 989.772.8008
