All the known problems with qmailadmin and MySQL replication are now fixed. In cases where MySQL slave(s) fail replication there could be a race condition but fixing that requires some code additions to vpopmail. My patch is based on Bill's patch that fixes the MySQL replication issues. To that base I applied Justin Hopper's quota patches and adjusted the quota patches to work the same way as the rest of modusergo (as with Bill's updates).
The patch is at http://matt.simerson.net/computing/mail/toaster/qmailadmin-106- quotafix.txt.
The patch applies cleanly to qmailadmin-1.06. In addition to the quota patches, I also did a bunch of pretty work to the HTML. The most substantial is on the modify user page. See the jpg here:
http://matt.simerson.net/computing/mail/toaster/qmailadmin_quota.jpg
I'd love to know what you think about it. I added some Javascript to that page so that users could only make mail routing choices that make sense. I'd appreciate if people would have a look at it and let me know what they think.
If everyone likes the changes, I respectfully request that the changes be incorporated into the qmailadmin source.
Matt
PS: I'm running this code on a production system with 50,000+ users, using replicated MySQL databases and the aforementioned code.
On Wednesday, October 23, 2002, at 04:21 PM, Bill Shupp wrote:
On Wednesday, October 23, 2002, at 01:20 PM, Matt Simerson wrote:Perfect, that patch worked nicely.Cool, thanks. I'll start doing universal diffs from now on.Bill
