mysql on a separate server

[u_gots_2_go]

I am trying to put mysql database on a separate server behind firewall... and I am having issues

I set up separate OpenSuSE box with mysql. Backed up database from asterisk/vidial server and restored it to this new box. Gave all permissions to public. I can log into the server from console and select/insert/update/delete records... but vicidial is not autodialing. At first it complained by sending some mail (before I granted permissions), but now there are no errors, but it still don't work.

I changed database connection settings in /etc/astguiclient.conf.

Dunno what else I need to do... Please help.

TJ

[Op3r]

Did you also changed the ip on the asterisk database?

Did you check if your server time synced?

[u_gots_2_go]

OK, it works!

Last night I saw someone's post with similar context and they fixed it by installing ntpd service. I thought to myself, Ya, whatever, I am gonna try it, but it probably won't help.

I set up NTP on both servers and made them sync to my router. BOOM! Everything started working!

Op3r, could you explain why that happens? I vaguely remember reading something that if 2 linux pcs' times differ by more than certain amount, bad things will happen.

TJ

[u_gots_2_go]

Did you also changed the ip on the asterisk database?

You mean IP address of the mysql server in astguiclient.conf? Or is it something I have to change in the database? Which table?

TJ

[aster1]

there is a script in /usr/share/astguiclient with name of ADMIN_update_server_ip or something like that .. run that and follow prompts, it will do the work for you .