Page 1 of 1

svn update required?

PostPosted: Tue Mar 17, 2015 10:05 pm
by THUFIR
This indicates that I must upgrade as per the manual?


Code: Select all

tleilax:/ #
tleilax:/ # perl /root/subversion/trunk/bin/ADMIN_update_server_ip.pl
Previous astGUIclient configuration file found at: /etc/astguiclient.conf

Would you like to use interactive mode (y/n): [y]

STARTING SERVER IP ADDRESS CHANGE FOR VICIDIAL...

Old server IP address or press enter for default: [192.168.1.3]

server IP address or press enter for default: [192.168.0.21]

  old server_ip:      192.168.1.3
  new server_ip:      192.168.0.21

Are these settings correct?(y/n): [y]
Writing change to astguiclient.conf file: /etc/astguiclient.conf

STARTING DATABASE TABLES UPDATES PHASE...
  Updating servers table...
     |0E0|UPDATE servers SET server_ip='192.168.0.21' where server_ip='192.168.1.3';|
  Updating phones table...
     |2|UPDATE phones SET server_ip='192.168.0.21' where server_ip='192.168.1.3';|
  Updating inbound_numbers table...
     |0E0|UPDATE inbound_numbers SET server_ip='192.168.0.21' where server_ip='192.168.1.3';|
  Updating server_updater table...
     |1|UPDATE server_updater SET server_ip='192.168.0.21' where server_ip='192.168.1.3';|
  Updating conferences table...
     |49|UPDATE conferences SET server_ip='192.168.0.21' where server_ip='192.168.1.3';|
  Updating vicidial_conferences table...
     |249|UPDATE vicidial_conferences SET server_ip='192.168.0.21' where server_ip='192.168.1.3';|
  Updating vicidial_stations table...
     |0E0|UPDATE vicidial_stations SET server_ip='192.168.0.21' where server_ip='192.168.1.3';|
  Updating vicidial_remote_agents table...
     |0E0|UPDATE vicidial_remote_agents SET server_ip='192.168.0.21' where server_ip='192.168.1.3';|
  Updating phone_favorites table...
     |0E0|UPDATE phone_favorites SET server_ip='192.168.0.21' where server_ip='192.168.1.3';|
  Updating vicidial_server_trunks table...
     |0E0|UPDATE vicidial_server_trunks SET server_ip='192.168.0.21' where server_ip='192.168.1.3';|
  Updating vicidial_server_carriers table...
     |0E0|UPDATE vicidial_server_carriers SET server_ip='192.168.0.21' where server_ip='192.168.1.3';|
  Updating vicidial_inbound_dids table...
     |0E0|UPDATE vicidial_inbound_dids SET server_ip='192.168.0.21' where server_ip='192.168.1.3';|
  Updating vicidial_process_triggers table...
     |0E0|UPDATE vicidial_process_triggers SET server_ip='192.168.0.21' where server_ip='192.168.1.3';|
  Setting servers to rebuild conf files...
     |1|UPDATE servers SET rebuild_conf_files='Y' where generate_vicidial_conf='Y' and active_asterisk_server='Y';|

SERVER IP ADDRESS CHANGE FOR VICIDIAL FINISHED!


     - process runtime      (12 sec) (0.2 minutes)
You have new mail in /var/mail/root
tleilax:/ #
tleilax:/ #
tleilax:/ # perl /root/subversion/trunk/bin/ADMIN_keepalive_ALL.pl
DBD::mysql::st execute failed: Unknown column 'meetme_enter_login_filename' in 'field list' at /root/subversion/trunk/bin/ADMIN_keepalive_ALL.pl line 1299.
executing: SELECT sounds_central_control_active,active_voicemail_server,custom_dialplan_entry,default_codecs,generate_cross_server_exten,voicemail_timezones,default_voicemail_timezone,call_menu_qualify_enabled,allow_voicemail_greeting,reload_timestamp,meetme_enter_login_filename,meetme_enter_leave3way_filename FROM system_settings; Unknown column 'meetme_enter_login_filename' in 'field list' at /root/subversion/trunk/bin/ADMIN_keepalive_ALL.pl line 1299.
tleilax:/ #
tleilax:/ # cat /etc/vicibox-version
- ViciBox Redux v.6.0.3-141118
* Updates to SVN 2192 v.2.10-452a build 141111-0554
* Added concurrent_insert=2 to my.cnf
* Added tmpdir=/tmp to my.cnf
* Adjusted PHP post variable to 4000
* Added vicidial-mysqldiff for comparing schemas
- ViciBox Redux v.6.0.2-140825
* Added tmpdir setting to MySQL settings
* added chan_ooh323.so to noload in modules.conf
* Crypt::RC4 causing issues with lead loader, created symlink
- ViciBox Redux v.6.0.1-140722
* Updates to SVN 2153 v.2.10-448a build 140706-0927
* OpenSuSE v.13.1 has the mod_access_compat statically compiled
  in Apache 2.4 which requires older Apache 2.2 access directives
  Modified viciarchive.conf and vicirecord.conf to account for it
- ViciBox Redux v.6.0.0-140619tleilax:/ #
tleilax:/ #
tleilax:/ #



http://wiki.vicidial.org/index.php/SVN:howto

Re: svn update required?

PostPosted: Wed Mar 18, 2015 1:10 am
by williamconley
No. This indicates that it completed the ip update. It's not a command, it's a notification.

Re: svn update required?

PostPosted: Wed Mar 18, 2015 2:33 pm
by THUFIR
thanks; got it. There was an error, running the correct script fixed that:

Code: Select all
tleilax:~ # perl /usr/share/astguiclient/ADMIN_update_server_ip.pl
Previous astGUIclient configuration file found at: /etc/astguiclient.conf

Would you like to use interactive mode (y/n): [y]

STARTING SERVER IP ADDRESS CHANGE FOR VICIDIAL...

Old server IP address or press enter for default: [192.168.0.21]

server IP address or press enter for default: [192.168.0.21]

  old server_ip:      192.168.0.21
  new server_ip:      192.168.0.21

Are these settings correct?(y/n): [y]
Writing change to astguiclient.conf file: /etc/astguiclient.conf

STARTING DATABASE TABLES UPDATES PHASE...
  Updating servers table...
     |1|UPDATE servers SET server_ip='192.168.0.21' where server_ip='192.168.0.21';|
  Updating phones table...
     |3|UPDATE phones SET server_ip='192.168.0.21' where server_ip='192.168.0.21';|
  Updating inbound_numbers table...
     |0E0|UPDATE inbound_numbers SET server_ip='192.168.0.21' where server_ip='192.168.0.21';|
  Updating server_updater table...
     |1|UPDATE server_updater SET server_ip='192.168.0.21' where server_ip='192.168.0.21';|
  Updating conferences table...
     |49|UPDATE conferences SET server_ip='192.168.0.21' where server_ip='192.168.0.21';|
  Updating vicidial_conferences table...
     |249|UPDATE vicidial_conferences SET server_ip='192.168.0.21' where server_ip='192.168.0.21';|
  Updating vicidial_stations table...
     |0E0|UPDATE vicidial_stations SET server_ip='192.168.0.21' where server_ip='192.168.0.21';|
  Updating vicidial_remote_agents table...
     |0E0|UPDATE vicidial_remote_agents SET server_ip='192.168.0.21' where server_ip='192.168.0.21';|
  Updating phone_favorites table...
     |0E0|UPDATE phone_favorites SET server_ip='192.168.0.21' where server_ip='192.168.0.21';|
  Updating vicidial_server_trunks table...
     |0E0|UPDATE vicidial_server_trunks SET server_ip='192.168.0.21' where server_ip='192.168.0.21';|
  Updating vicidial_server_carriers table...
     |1|UPDATE vicidial_server_carriers SET server_ip='192.168.0.21' where server_ip='192.168.0.21';|
  Updating vicidial_inbound_dids table...
     |0E0|UPDATE vicidial_inbound_dids SET server_ip='192.168.0.21' where server_ip='192.168.0.21';|
  Updating vicidial_process_triggers table...
     |0E0|UPDATE vicidial_process_triggers SET server_ip='192.168.0.21' where server_ip='192.168.0.21';|
  Setting servers to rebuild conf files...
     |1|UPDATE servers SET rebuild_conf_files='Y' where generate_vicidial_conf='Y' and active_asterisk_server='Y';|

SERVER IP ADDRESS CHANGE FOR VICIDIAL FINISHED!


     - process runtime      (7 sec) (0.116666666666667 minutes)
tleilax:~ #
tleilax:~ #
tleilax:~ #
tleilax:~ #
tleilax:~ # perl /usr/share/astguiclient/ADMIN_
ADMIN_adjust_GMTnow_on_leads.pl  ADMIN_audio_store_sync.pl        ADMIN_keepalive_ALL.pl           ADMIN_restart_roll_logs.pl       ADMIN_update_server_ip.pl
ADMIN_archive_log_tables.pl      ADMIN_backup.pl                  ADMIN_qm_sync.pl                 ADMIN_timeclock_auto_logout.pl   ADMIN_www_languages.pl
ADMIN_area_code_populate.pl      ADMIN_bcrypt_convert.pl          ADMIN_reset_failed_count.pl      ADMIN_update_archive_url.pl     
tleilax:~ # perl /usr/share/astguiclient/ADMIN_keepalive_ALL.pl
tleilax:~ #
tleilax:~ #