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

[asterisklists at adontendev.net]

Quoting Ronald Wiplinger <ronald at 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 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
>




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