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
domains.
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 \
--enable-sql-logging
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.
Hi,
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.
Regards,
Rick
