Hi,
About my previous post, I find a solution for my new server. The
situation was that I copy all maildir, databases and config files on the
new server and no mailbox can be shown on the Web Admin pannel and of
course, no user/domain was valid for login.
After a few hours of testing, I discover that
/var/qmail/control/virtualdomains and /var/qmail/users/assign file were
empty. After setup these files correctly and update cdb files, all
domains/users appear on Web admin panel and users can log on. (Maybe I
forgot to tell something, I didn't sleep since 37 hours ago to solve
this...) Let me know if you need more precisions about the
solution. About my update problem on my old server, if someone
wants root access to lookup for a solution to help others people of
just for personal knowledge, feel free to ask ;) I got so
much trouble with this problem; if it could help someone else in the
same mess I will be glad!
The only one problem I have now is that I can't receive mail from
outside. I can send mail to myself with Squirrelmail and can send mail
to myself from my second mail server. I tried using Hotmail without
success.
Sincerely, thank you for all you're support!
Regards,
Kaven G.
-----Original Message-----
From: Ray Van Dolson [mailto:[EMAIL PROTECTED]
Sent: August 25, 2006 12:00 PM
To: qmailtoaster-list@qmailtoaster.com
Subject: Re: [qmailtoaster] (URGENT) Upgrade failure/migrate on a new
server.
On Fri, Aug 25, 2006 at 11:51:24AM -0400, Kaven Gagnon wrote:
> Thanks for you're reply, but I already try this without success. I'm
really
> struck... I've check every file one by one for permissions, settings...
the
> whole kit!
Well, if you still want to try one more thing on the "old" server, try
disabling SELinux. Wonder if it could be causing problems...
>
> At this point, I think to forget about this server and try to make it work
> with the new one that I build last night. My only problem is that no
domain
> and user can be shown in the Web admin panel. I tried to create a test
> domain with a test user... it work well; I can see it in the Web panel. I
> double check for difference between this table (new test domain) and
tables
> of other domains... they are identical.
>
> Anyone knows how to make my old db appear in Qmail administration site?
>
Could be a number of problems causing this. Probably what I'd do (not
knowing the internals of qmailadmin) is enable MySQL query logging and
determine what query it runs against your DB to get the list of domains.
Edit /etc/my.cnf, should look something like this when query logging is
enabled:
[mysqld]
log=/var/log/mysql/query.log
Then, mkdir -p /var/log/mysql and chown mysql.mysql /var/log/mysql and
restart MySQLd.
Try and view your qmail admin, then look at the /var/log/mysql/query.log
file. You should be able to determine a) what user qmailadmin uses to
connect ot the database with (ensure this user exists and can read the
correct tables), b) what database the user is connecting to (confirm it
exists and user has access to it) and c) what queries are being run.
I'd probably end up running those queries manually from a mysql command
shell to see if they return anything.
Post output of your query log here if you like...
Also make sure /var/lib/mysql/<dbname> that you copied over is owned by the
MySQL user. Check /var/lib/mysql/*.err to see if there were problems
opening this database when you started MySQL up...
If you connect to MySQL from the command line (as root user) can you do a
USE <dbname> and SHOW TABLES?
Some things to try.
Ray
---------------------------------------------------------------------
QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
