Re: [vchkpw] Vpopmail connecting to remote mysql
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!
Re: [vchkpw] Vpopmail connecting to remote mysql
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 - !DSPAM:4c1e17eb32718105716103!
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 - !DSPAM:4c1b1ea532711714016890!
[vchkpw] Vpopmail connecting to remote mysql
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. The Users till not authenticating. Please help suggest the solution. This message was sent using IMP, the Internet Messaging Program. !DSPAM:4c1b00e832711882912785!