Sergio Rosa wrote:

Hi all,

I  had vpopmail running with cdb, upgraded to vpopmail with MySQL but
did a bad choice! I configure it without (the default) support for many

How can I convert my configuration, from one table per domain to a new
configuration of one column by domain?

I need to change things on my server because I now have a lot more
domains that I had a few weeks before.

BTW I'm running vpopmail 5.4.10 with the followinf config:
./configure \
--enable-clear-passwd \
--enable-learn-passwords \
--enable-domainquotas \
--disable-password \
--enable-logging=y \
--enable-valias \
--enable-mysql-limits \
--disable-many-domains \
--enable-auth-module=mysql \

on a Fedora Core 1 and a rpm build of MySQL 4.0.20, plus a lot of other
things like clamd, spamassassin, apache, and so on...

I only have this server and a down time is not welcome by the Clients.

Recently my sql server "Gone away!" for a while and it cause a big
trouble on mail delivery.


Sorry, I can't you with the conversion of the database but your "Gone Away!" problem can be helped by increasing the number of connections that MySQL allows and increasing the memory available to MySQL by modifying your my.cnf file. The large_my.cnf file that came with Fedora is a good place to start looking.

You may also not want to use mysql-logging as you do have to clean that out sometime or you'll just fill up your logging table with millions of records.



Reply via email to