[root@bg BGBillingServer]# ./bg_installer.sh update
 05-31/11:56:06  INFO [main] DefaultServerSetup - Init DB connection pools
 05-31/11:56:06  INFO [main] DefaultServerSetup - Init trash pools..
Update starting..
Update from ftp://ftp.bgbilling.ru/pub/bgbilling
Server version is 5.0
Set passive mode..
Changing dir to /pub/bgbilling/5.0
Checking updates for bill..
Checking updates for dialup..
Found update for dialup build 230 packet dialup_5.0_232.zip updating to build 232
Checking updates for email..
Checking updates for ipn..
Found update for ipn build 249 packet ipn_5.0_252.zip updating to build 252
Checking updates for npay..
Checking updates for phone..
Checking updates for reports..
Checking updates for rscm..
Checking updates for voiceip..
Found update for voiceip build 182 packet voiceip_5.0_183.zip updating to build 183
Checking updates for ru.bitel.bgbilling.plugins.cashcheck..
Checking updates for ru.bitel.bgbilling.plugins.cladr..
Checking updates for ru.bitel.bgbilling.plugins.helpdesk..
Checking updates for server..
Found update for BGBillingServer build 737 packet update_5.0.zip updating to build 742
Install 4 updates (y/n):
y
Downloading dialup_5.0_232.zip OK!
Downloading ipn_5.0_252.zip OK!
Downloading voiceip_5.0_183.zip OK!
Downloading update_5.0.zip OK!
Start installing..
 05-31/11:56:44  INFO [main] DefaultServerSetup - Init DB connection pools
 05-31/11:56:44  INFO [main] DefaultServerSetup - Init trash pools..
 05-31/11:56:44  INFO [main] DefaultServerSetup - Init DB connection pools
 05-31/11:56:44  INFO [main] DefaultServerSetup - Init trash pools..
Module: dialup already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
Module Instance init => OK
Executing call AddSchedulerTasks; param: dialup.sc
Scheduled class bitel.billing.server.dialup.MaxCalculator already exists!
Result => true
Executing call PutFile; param: dialup.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module dialup was successfull installed!
Please, restart BGBilling server.
 05-31/11:56:44  INFO [main] DefaultServerSetup - Init DB connection pools
 05-31/11:56:44  INFO [main] DefaultServerSetup - Init trash pools..
Module: ipn already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 1
Unknown table 'max_dates'
Unknown table 'problem_cids'
Can't DROP 'cid'; check that column/key exists
Module Instance init => OK
Executing call AddSchedulerTasks; param: ipn.sc
Scheduled class bitel.billing.server.ipn.LogCalculator already exists!
Scheduled class bitel.billing.server.ipn.IPNTestGates already exists!
Scheduled class bitel.billing.server.ipn.MaxCalculator already exists!
Result => true
Executing call PutFile; param: ipn.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module ipn was successfull installed!
Please, restart BGBilling server.
 05-31/11:56:44  INFO [main] DefaultServerSetup - Init DB connection pools
 05-31/11:56:44  INFO [main] DefaultServerSetup - Init trash pools..
Module: voiceip already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
Module Instance init => OK
Executing call PutFile; param: voiceip.xml:actions
Result => true
Executing call AddSchedulerTasks; param: voiceip.sc
Scheduled class bitel.billing.server.voiceip.BalanceSetter already exists!
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module voiceip was successfull installed!
Please, restart BGBilling server.
 05-31/11:56:45  INFO [main] DefaultServerSetup - Init DB connection pools
 05-31/11:56:45  INFO [main] DefaultServerSetup - Init trash pools..
Installing module: update...
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Module Instance init => OK
Executing call ExecuteSQL; param: patch.sql
Duplicate column name 'tgid'
Duplicate column name 'scrid'
Duplicate key name 'pid'
Table 'tariff_group' already exists
Table 'tariff_group_tariff' already exists
Table 'contract_tariff_group' already exists
Table 'contract_script' already exists
Table 'script' already exists
Table 'script_event_queue' already exists
Table 'script_event_type' already exists
Table 'script_function' already exists
Table 'script_function_event_type' already exists
Duplicate column name 'gr'
Table 'bgs_group' already exists
Table 'bgs_group_action' already exists
Table 'bgs_user_group' already exists
Table 'bgs_module_action' already exists
Duplicate column name 'room'
Duplicate column name 'status'
Table 'bgs_user_action' already exists
Duplicate column name 'parent_tree'
Incorrect table definition; there can be only one auto column and it must be defined as a key
Duplicate column name 'id'
Duplicate column name 'date1'
Duplicate column name 'date2'
Duplicate column name 'title'
Duplicate key name 'cid'
Unknown column 'etid' in 'script_function_event_type'
Duplicate column name 'event_id'
Table 'object_type' already exists
Table 'object_param' already exists
Table 'object_type_param' already exists
Table 'object' already exists
Table 'object_list_value' already exists
Table 'object_param_value_text' already exists
Table 'object_param_value_address' already exists
Table 'object_param_value_date' already exists
Table 'object_param_value_list' already exists
Duplicate column name 'config'
Table 'user_tables' already exists
Duplicate column name 'name_pattern'
Duplicate column name 'scid'
Duplicate key name 'scid'
Duplicate column name 'sub_list'
Duplicate column name 'pos'
Duplicate column name 'pos'
Duplicate key name 'cid'
Duplicate column name 'gid'
Table 'web_request_count' already exists
Duplicate column name 'cgr'
Duplicate column name 'cgr'
Duplicate key name 'cid'
Duplicate column name 'pids'
Duplicate column name 'pids'
Duplicate column name 'contract_pid'
Duplicate column name 'contract_cid'
Duplicate column name 'pos'
Duplicate key name 'pos'
Duplicate column name 'script'
Duplicate column name 'id'
Duplicate column name 'enabled'
Table 'plugin_config' already exists
Table 'contract_password_once' already exists
Duplicate column name 'config'
Duplicate column name 'comment'
Duplicate column name 'days'
Duplicate column name 'status'
Duplicate column name 'status_date'
Duplicate column name 'last_tariff_change'
Duplicate column name 'data'
Duplicate column name 'date1'
Duplicate column name 'emid'
Duplicate column name 'eid'
Duplicate column name 'emid'
Duplicate column name 'eid'
Duplicate column name 'load_log'
Duplicate column name 'p_index'
Duplicate column name 'cityid'
Duplicate column name 'cityid'
Duplicate column name 'cityid'
Duplicate column name 'visibled'
Table 'sql_template' already exists
Duplicate column name 'pos'
Duplicate key name 'cid'
Duplicate column name 'event_mode'
Duplicate column name 'actual'
Duplicate column name 'cgr_mode'
Duplicate column name 'cgr_mode'
Duplicate column name 'crm_customer_id'
Duplicate key name 'crm_customer_id'
Duplicate column name 'crm_user_id'
Key column 'crm_user_id' doesn't exist in table
Table 'contract_parameter_type_9' already exists
Duplicate column name 'phone_format1'
Duplicate column name 'sub_mode'
Duplicate column name 'pod_diapazon'
Duplicate column name 'actual'
Duplicate column name 'gr'
Duplicate column name 'pattern'
Duplicate column name 'face'
Duplicate column name 'isusing'
Table 'contract_module' already exists
Table 'contract_status_log' already exists
Table 'billing_event_bus' already exists
Table 'periodic_errors' already exists
Duplicate column name 'history'
Table 'contract_parameter_type_1_log' already exists
Table 'contract_parameter_type_5_log' already exists
Table 'contract_parameter_type_6_log' already exists
Table 'contract_parameter_type_7_log' already exists
Table 'contract_parameter_type_8_log' already exists
Table 'contract_parameter_type_9_log' already exists
Unknown column 'value' in 'contract_parameter_type_9_log'
Table 'contract_pattern_modules' already exists
Can't DROP 'pfid_id'; check that column/key exists
Can't DROP 'id_pfid'; check that column/key exists
Can't DROP 'pfid_date2_id'; check that column/key exists
Can't DROP 'pfid_gr_date2_id'; check that column/key exists
Can't DROP 'date2_'; check that column/key exists
Can't DROP 'pfid_date2'; check that column/key exists
Can't DROP 'pfid_date2_gr'; check that column/key exists
Can't DROP 'pfid_gr_date2'; check that column/key exists
Can't DROP 'yy_mm_cid'; check that column/key exists
Table 'contract_comment_patterns' already exists
Duplicate column name 'patid'
Duplicate column name 'title_pattern_id'
Duplicate column name 'cgr_mode'
Duplicate column name 'cgr_mode'
Duplicate column name 'ptitle'
Duplicate column name 'regtype'
Table 'contract_parameter_type_2_log' already exists
Table 'contract_parameter_type_3_log' already exists
Table 'contract_parameter_type_4_log' already exists
Table 'script_lib' already exists
Key column 'cityid' doesn't exist in table
Can't DROP 'PRIMARY'; check that column/key exists
Duplicate key name 'cid_pid'
Table 'global_script' already exists
Table 'tariff_option' already exists
Table 'tariff_option_activate_mode' already exists
Table 'contract_tariff_option' already exists
Duplicate column name 'date1'
Duplicate column name 'depends'
Duplicate column name 'incompatible'
Duplicate column name 'activated_mode'
Duplicate column name 'activated_time'
Duplicate column name 'deactivated_time'
Duplicate column name 'deactivation_mode'
Duplicate column name 'reactivation_mode'
Duplicate column name 'contract_groups'
Duplicate column name 'pos'
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `module_config` MODIFY COLUMN `config` longtext NULL' at line 3
Executing database update...OK
Result => true
Executing call AddSchedulerTasks; param: patch.sc
Scheduled class bitel.billing.server.script.TimerEventGenerate already exists!
Scheduled class bitel.billing.server.contract.DebtMailSender already exists!
Scheduled class bitel.billing.server.contract.ContractStatusSetter already exists!
Scheduled class bitel.billing.server.admin.integration.PaymentLoader already exists!
Scheduled class ru.bitel.bgbilling.kernel.task.server.Validator already exists!
Scheduled class bitel.billing.server.script.global.bean.GlobalScriptTimer inserted into database.
Scheduled class ru.bitel.bgbilling.kernel.task.server.TaskUpdateAddressDirectory already exists!
Result => true
Executing call PutFile; param: style.css:webroot
Result => true
Executing call PutFile; param: menu.xml:data
Result => true
Executing call PutFile; param: img:webroot
Result => true
Executing call PutFile; param: auth.html:webroot
Result => true
Executing call PutFile; param: actions:.
Result => true
Executing call PutFile; param: help:webroot
Result => true
Executing call PutFile; param: log4j.xml:data
Result => true
Executing call PutFile; param: default.web.xml:data
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module update was successfull installed!
Please, restart BGBilling server.
REPLACED FILES:
/usr/local/BGBillingServer/data/log4j.xml
[root@bg BGBillingServer]#

[root@bg BGBillingServer]# ./bg_installer.sh update
 05-31/14:49:35  INFO [main] DefaultServerSetup - Init DB connection pools
 05-31/14:49:35  INFO [main] DefaultServerSetup - Init trash pools..
Update starting..
Update from ftp://ftp.bgbilling.ru/pub/bgbilling
Server version is 5.0
Set passive mode..
Changing dir to /pub/bgbilling/5.0
Checking updates for bill..
Checking updates for dialup..
Checking updates for email..
Checking updates for ipn..
Checking updates for npay..
Found update for npay build 213 packet npay_5.0_215.zip updating to build 215
Checking updates for phone..
Checking updates for reports..
Checking updates for rscm..
Checking updates for voiceip..
Checking updates for ru.bitel.bgbilling.plugins.cashcheck..
Checking updates for ru.bitel.bgbilling.plugins.cladr..
Checking updates for ru.bitel.bgbilling.plugins.helpdesk..
Checking updates for server..
Found update for BGBillingServer build 742 packet update_5.0.zip updating to build 743
Checking updates for client..
Found update for BGBillingClient build 626 packet update_5.0.zip updating to build 627
Install 2 updates (y/n):
y
Downloading npay_5.0_215.zip OK!
Downloading update_5.0.zip OK!
Start installing..
 05-31/14:49:52  INFO [main] DefaultServerSetup - Init DB connection pools
 05-31/14:49:52  INFO [main] DefaultServerSetup - Init trash pools..
 05-31/14:49:52  INFO [main] DefaultServerSetup - Init DB connection pools
 05-31/14:49:52  INFO [main] DefaultServerSetup - Init trash pools..
Module: npay already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 2
Module Instance init => OK
Executing call AddSchedulerTasks; param: pay.sc
Scheduled class bitel.billing.server.npay.Calculator already exists!
Scheduled class ru.bitel.bgbilling.modules.npay.server.task.DebetStatusManageLocker already exists!
Result => true
Executing call PutFile; param: npay.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module npay was successfull installed!
Please, restart BGBilling server.
 05-31/14:49:52  INFO [main] DefaultServerSetup - Init DB connection pools
 05-31/14:49:52  INFO [main] DefaultServerSetup - Init trash pools..
Module: update already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Module Instance init => OK
Executing call ExecuteSQL; param: patch.sql
Executing database update...OK
Result => true
Executing call AddSchedulerTasks; param: patch.sc
Scheduled class bitel.billing.server.script.TimerEventGenerate already exists!
Scheduled class bitel.billing.server.contract.DebtMailSender already exists!
Scheduled class bitel.billing.server.contract.ContractStatusSetter already exists!
Scheduled class bitel.billing.server.admin.integration.PaymentLoader already exists!
Scheduled class ru.bitel.bgbilling.kernel.task.server.Validator already exists!
Scheduled class bitel.billing.server.script.global.bean.GlobalScriptTimer already exists!
Scheduled class ru.bitel.bgbilling.kernel.task.server.TaskUpdateAddressDirectory already exists!
Result => true
Executing call PutFile; param: style.css:webroot
Result => true
Executing call PutFile; param: menu.xml:data
Result => true
Executing call PutFile; param: img:webroot
Result => true
Executing call PutFile; param: auth.html:webroot
Result => true
Executing call PutFile; param: actions:.
Result => true
Executing call PutFile; param: help:webroot
Result => true
Executing call PutFile; param: log4j.xml:data
Result => true
Executing call PutFile; param: default.web.xml:data
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module update was successfull installed!
Please, restart BGBilling server.
[root@bg BGBillingServer]#