asterisk users - Jun 2005 - I want to move the MySQL server out to another machine

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@vpbx.elmit.com>' failed
for '192.168.10.18'

What do I miss?


bye

Ronald

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@elmit.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users@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@vpbx.elmit.com>' failed
> for '192.168.10.18'
>
> What do I miss?
>
>
> bye
>
> Ronald
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@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

Quoting Ronald Wiplinger <ronald@elmit.com>:

Did you just copy the database files over to the new server?

You may have to grant the user rights again. Also remember that mysql
rights are host sensitive. If all your previous grants were localhost based,
instead of ip address/netmask based, you will have to adjusts the hosts when
you grant the rights again.


Look at the MySQL rights documentation


> 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@vpbx.elmit.com>' failed
> for '192.168.10.18'
>
> What do I miss?
>
>
> bye
>
> Ronald
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@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
>



----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

Ritesh Jalan wrote:
>Have you given the access to your asterisk server in your database server??
>
>
>  
>
Thanks, you are right, ...

However, I cannot find the right way to GRANT the access. Do you have an 
example for me, please?


bye

Ronald

Read /var/log/asterisk/debug for errors

-Matthew
> From: Ronald Wiplinger <ronald@elmit.com>
> Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion
> <asterisk-users@lists.digium.com>
> Date: Tue, 07 Jun 2005 18:26:54 +0800
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> <asterisk-users@lists.digium.com>
> Subject: [Asterisk-Users] I want to move the MySQL server out to another
> machine
> 
> 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@vpbx.elmit.com>' failed
> for '192.168.10.18'
> 
> What do I miss?
> 
> 
> bye
> 
> Ronald
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@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