I'm seeing intermittent failures of vpopmail to do various things involving the MySQL database.
The symptoms are:
1) users fail to authenticate occasionally.
2) Mail is occasionally bounced with the message:
vmysql: sql error[1]: Can't create database 'vpopmail'. Database exists
3) clearopensmtp occasionally fails with the same message.
Watching the MySQL log, I occasionally see the "CREATE DATABASE vpopmail" command being issued.
95% of the time, everything works fine.
Load and memory usage on the MySQL server are extremely low, so I don't think it is refusing connections or anything like that.
This started after I moved my machines to a new physical location and changed their IP addresses. No other significant changes were made.
Using vpopmail 5.4.0.
I did see one reference to a similar problem on the mailing list about a year ago, but no solution.
Any suggestions?
Problem apparently solved, thanks to Matt. See the mailing list archives if you're interested in his full post, but:
> Is there hostname or IP issues involved? Bad DNS? Try using /etc/hosts
> entries to override DNS.
I thought I had already done this, but apparently not. After adding the /etc/hosts entry, I ran clearopensmtp from the command line 100 times without failure, so that appears to have solved the problem. (Previously it was failing about 1 in 20 times).