Hi Thibault,
Yes i have tried this already. I can connect and login to remote DB
from command line.
I have found a solution on google. made a file in
/var/qmail/control/sql and place the name of mysql server hostname in
it. After this i can connect to remote DB. Do you think this is the
solution. Thanks.
Quoting Thibault Richard :
From a command line try :
mysql -hYOUR-REMOTE-HOST -uYOUR-MYSQL-LOGIN -p and please tell us if
your are able ton connect
- Original Message - From: "Bob Hutchinson"
To:
Sent: Friday, June 18, 2010 9:21 AM
Subject: Re: [vchkpw] Vpopmail connecting to remote mysql
On Friday 18 June 2010, ta...@nayatel.com wrote:
I had vpopmail database on the local server. Now i have taken backup
of mysql and restored to a remote database server. I am connecting
vpopmail to remote mysql server. The users are not authenticated. I
have taken following steps.
1 - Database migration and restoration to the remote mysql DB server.
2 - Fixed the permission on remote database to allow access to Vpopmail IP.
3 - Fixed firewall settings.
4 - Edited the vpopmail.mysql file to connect to remote DB IP.
Can you connect from the commandline?
The Users till not authenticating. Please help suggest the solution.
This message was sent using IMP, the Internet Messaging Program.
--
-
Bob Hutchinson
Midwales dot com
-
This message was sent using IMP, the Internet Messaging Program.
!DSPAM:4c1eed6532712901243085!