[Asterisk-Users] I want to move the MySQL server out to anothermachine

[Mike Holloway]

Ritesh is likely correct, have a look at:

http://dev.mysql.com/doc/mysql/en/adding-users.html

You will want to make sure that for the mysql user you are using to 
connect to the mysql server you have granted permissions in the 'mysql' 
database in the 'db' table for some or all foreign 'Host's . % is used 
to allow all foreign hosts.  You probably are just allowing 'localhost' 
currently for that mysql user.

-mike


Ritesh Jalan wrote:
> Have you given the access to your asterisk server in your database server??
> 
> 
> Thanks & Regards
> Ritesh Jalan
> Senior Engineer - Test & Audit
> Net4India Ltd.
> 703 Bikaji Cama Bhawan
> 11 Bikaji Cama Place
> New Delhi - 110029
> Ph: +91-11-26160129 ext. 131
> Web site: http://www.net4india.com
> ============================================================================
> ==============================================
> This message may contain confidential and/or privileged information. If you
> are not the addressee or authorized to receive this for the addressee, you
> must not use, copy, disclose or take any action based on this message or any
> information herein. If you have received this message in error, please
> advise the sender immediately by reply e-mail and delete this message. Thank
> you for your cooperation.
> ============================================================================
> ==============================================
> ----- Original Message ----- 
> From: "Ronald Wiplinger" <ronald at elmit.com>
> To: "Asterisk Users Mailing List - Non-Commercial Discussion"
> <asterisk-users at lists.digium.com>
> Sent: Tuesday, June 07, 2005 3:56 PM
> Subject: [Asterisk-Users] I want to move the MySQL server out to
> anothermachine
> 
> 
> 
>>I tried to add the databases from the localhost to the database server
>>and changed the every /etc/asterisk/*.conf from host=localhost to
>>host=192.168.10.10
>>(my dababase server)
>>
>>When I restart asterisk, I do not get any errors, but after a phone call
>>I see:
>>
>>Jun  7 18:11:56 ERROR[7877]: cdr_addon_mysql.c:400 my_load_module:
>>Failed to connect to mysql database cdr on 192.168.10.10
>>
>>Or if I try to register a phone, which is in the sipbuddies.
>>
>>Jun  7 18:14:43 NOTICE[7870]: chan_sip.c:8098 handle_request:
>>Registration from '"Ronald Video (612)"<sip:612 at vpbx.elmit.com>' failed
>>for '192.168.10.18'
>>
>>What do I miss?
>>
>>
>>bye
>>
>>Ronald
>>
>>_______________________________________________
>>Asterisk-Users mailing list
>>Asterisk-Users at lists.digium.com
>>http://lists.digium.com/mailman/listinfo/asterisk-users
>>To UNSUBSCRIBE or update options visit:
>>   http://lists.digium.com/mailman/listinfo/asterisk-users
> 
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
> 
>