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 <th...@thibs.com>:
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" <hutchli...@midwales.com>
To: <vchkpw@inter7.com>
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!
