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 <[email protected]>:
>
> 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" <[email protected]>
> To: <[email protected]>
> Sent: Friday, June 18, 2010 9:21 AM
> Subject: Re: [vchkpw] Vpopmail connecting to remote mysql
>
>
>> On Friday 18 June 2010, [email protected] 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!
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.