script error in /opt/osdial/bin/ADMIN_update_server_ip.pl

For subjects not covered elsewhere

script error in /opt/osdial/bin/ADMIN_update_server_ip.pl

Postby MichaelPittingerSr » Mon Jan 13, 2014 10:35 am

Good morning,

got an error in using this perl script.


command:
/opt/osdial/bin/ADMIN_update_server_ip.pl

has error when addressing the sql daabase.

It appears that the osdial_carriers table may no longer contain a column called 'server_ip
__________________________________________________________________________________________

the file: /opt/osdial/bin/ADMIN_update_server_ip.pl

print " Updating osdial_carriers table...\n";
$stmtA = "UPDATE osdial_carriers SET server_ip='$VARserver_ip' where server_ip='$VARold_server_ip';";
$affected_rows = $dbhA->do($stmtA);
if ($DB) {print " |$affected_rows|$stmtA|\n";}


__________________________________________________________________________________________

[root@osdial-8b94e359 ~]# /opt/osdial/bin/ADMIN_update_server_ip.pl
Previous OSDial configuration file found at: /etc/osdial.conf

Would you like to use interactive mode (y/n): [y] n
Writing change to osdial.conf file: /etc/osdial.conf

STARTING DATABASE TABLES UPDATES PHASE...
Updating servers table...
|1|UPDATE servers SET server_ip='' where server_ip='192.168.1.27';|
Updating phones table...
|12|UPDATE phones SET server_ip='' where server_ip='192.168.1.27';|
Updating inbound_numbers table...
|0E0|UPDATE inbound_numbers SET server_ip='' where server_ip='192.168.1.27';|
Updating server_updater table...
|1|UPDATE server_updater SET server_ip='' where server_ip='192.168.1.27';|
Updating conferences table...
|50|UPDATE conferences SET server_ip='' where server_ip='192.168.1.27';|
Updating osdial_conferences table...
|50|UPDATE osdial_conferences SET server_ip='' where server_ip='192.168.1.27';|
Updating osdial_remote_agents table...
|0E0|UPDATE osdial_remote_agents SET server_ip='' where server_ip='192.168.1.27';|
Updating osdial_server_trunks table...
|0E0|UPDATE osdial_server_trunks SET server_ip='' where server_ip='192.168.1.27';|
Updating osdial_auto_calls table...
|0E0|UPDATE osdial_auto_calls SET server_ip='' where server_ip='192.168.1.27';|
Updating osdial_auto_calls table...
|0E0|UPDATE osdial_auto_calls SET server_ip='' where server_ip='192.168.1.27';|
Updating live_channels table...
|0E0|UPDATE live_channels SET server_ip='' where server_ip='192.168.1.27';|
Updating live_inbound table...
|0E0|UPDATE live_inbound SET server_ip='' where server_ip='192.168.1.27';|
Updating live_sip_channels table...
|0E0|UPDATE live_sip_channels SET server_ip='' where server_ip='192.168.1.27';|
Updating osdial_campaign_server_stats table...
|3|UPDATE osdial_campaign_server_stats SET server_ip='' where server_ip='192.168.1.27';|
Updating osdial_carriers table...

DBD::mysql::db do failed: Unknown column 'server_ip' in 'where clause' at /opt/osdial/bin/ADMIN_update_server_ip.pl line 412, <STDIN> line 1.
||UPDATE osdial_carriers SET server_ip='' where server_ip='192.168.1.27';|
Updating osdial_manager table...
|13|UPDATE osdial_manager SET server_ip='' where server_ip='192.168.1.27';|
Updating parked_channels table...
|0E0|UPDATE parked_channels SET server_ip='' where server_ip='192.168.1.27';|
Updating web_client_sessions table...
|0E0|UPDATE web_client_sessions SET server_ip='' where server_ip='192.168.1.27';|
kill 25972: No such process

SERVER IP ADDRESS CHANGE FOR OSDIAL FINISHED!

- process runtime (14 sec) (0.233333333333333 minutes)
[root@osdial-8b94e359 ~]#
MichaelPittingerSr
 
Posts: 37
Joined: Mon Jun 10, 2013 12:34 pm

Re: script error in /opt/osdial/bin/ADMIN_update_server_ip.p

Postby fadmin » Fri Jan 17, 2014 4:47 pm

It does not hurt the process, simply found a config error. You can safely continue.
Forum Administrator
OSDial
http://osdial.com
fadmin
Site Admin
 
Posts: 283
Joined: Fri Feb 12, 2010 7:27 am


Return to General

Who is online

Users browsing this forum: Blismrum, Sporpzok, Watacete and 2 guests

cron