Project

General

Profile

Forums » Open discussion »

goAutodial 3.0 Change Mysql Host Addres

Added by encep tea about 8 years ago

Hi, anyone can help. How to change config mysql host address ?

i have already edit my config file goautodial.conf & astguiclient.conf but IAX server can't respon when i register to zoiper client.

Advice me please.

Thanks All.


Replies (1)

RE: goAutodial 3.0 Change Mysql Host Addres - Added by encep tea about 8 years ago

Ah... my mistake.

problem solve :

UPDATE servers SET server_ip='YOUR_NEW_IP_GOAUTODIAL' where server_ip='YOUR_OLD_IP_GOAUTODIAL';
     UPDATE phones SET server_ip='YOUR_NEW_IP_GOAUTODIAL' where server_ip='YOUR_OLD_IP_GOAUTODIAL';
     UPDATE inbound_numbers SET server_ip='YOUR_NEW_IP_GOAUTODIAL' where server_ip='YOUR_OLD_IP_GOAUTODIAL';
     UPDATE server_updater SET server_ip='YOUR_NEW_IP_GOAUTODIAL' where server_ip='YOUR_OLD_IP_GOAUTODIAL';
     UPDATE conferences SET server_ip='YOUR_NEW_IP_GOAUTODIAL' where server_ip='YOUR_OLD_IP_GOAUTODIAL';
     UPDATE vicidial_conferences SET server_ip='YOUR_NEW_IP_GOAUTODIAL' where server_ip='YOUR_OLD_IP_GOAUTODIAL';
     UPDATE vicidial_stations SET server_ip='YOUR_NEW_IP_GOAUTODIAL' where server_ip='YOUR_OLD_IP_GOAUTODIAL';
     UPDATE vicidial_remote_agents SET server_ip='YOUR_NEW_IP_GOAUTODIAL' where server_ip='YOUR_OLD_IP_GOAUTODIAL';
     UPDATE phone_favorites SET server_ip='YOUR_NEW_IP_GOAUTODIAL' where server_ip='YOUR_OLD_IP_GOAUTODIAL';
     UPDATE vicidial_server_trunks SET server_ip='YOUR_NEW_IP_GOAUTODIAL' where server_ip='YOUR_OLD_IP_GOAUTODIAL';
     UPDATE vicidial_server_carriers SET server_ip='YOUR_NEW_IP_GOAUTODIAL' where server_ip='YOUR_OLD_IP_GOAUTODIAL';
     UPDATE vicidial_inbound_dids SET server_ip='YOUR_NEW_IP_GOAUTODIAL' where server_ip='YOUR_OLD_IP_GOAUTODIAL';
     UPDATE vicidial_process_triggers SET server_ip='YOUR_NEW_IP_GOAUTODIAL' where server_ip='YOUR_OLD_IP_GOAUTODIAL';
     UPDATE servers SET rebuild_conf_files='Y' where generate_vicidial_conf='Y' and active_asterisk_server='Y';
    (1-1/1)     Go to top