[Spce-user] Observations/issues after upgrading to 3.6.1 - nginx

Thomas Odorfer odotom at gmail.com
Mon Nov 17 13:15:00 EST 2014


Just fixed the setup by enforcing ngcp-update-cfg-schema and ngcp-update-db-schema with -f 
Why it did not run initially I have no clue yet.

Many thanks for pointing me into that direction.

Am 17.11.2014 um 16:36 schrieb Thomas Odorfer <odotom at gmail.com>:

> Dear Alex,
> 
> many thanks for your comments.
> Actually it is quite strange: ngcp-cfg-schema and ngcp-db-schema contain all the necessary files, but for some reason they are not executed - the system however thinks it is up-to-date. 
> Please see the results below as annotations. 
> 
> Does it have something to do with „active node“? It seems that the only scripts being performed are *_not_replicated.up
> Some checks: 
> 
> # ngcp-check_active -p
> !
> # ngcp-nodename
> sip0
> (identical with ngcp.cfg_schema.node )
> 
> Probably I should run ngcp-update-cfg-schema and ngcp-update-db-schema with -f flag?
> 
> Thanks, Thomas
> 
> PS: config.yml will be sent separately to you
> 
> Am 17.11.2014 um 14:55 schrieb Alex Lutay <alutay at sipwise.com>:
> 
>> Dear Thomas,
>> 
>> First of all, thank you for the bug report!
>> 
>> Please find my in-line reply:
>> 
>> On 14/11/14 17:23, Thomas Odorfer wrote:
>>> Just upgraded from 3.5.1 to 3.6.1 - got major issues concerning apache2 replecement for panel:
>>> 
>>> 1) after upgrade nginx start failed due to missing port numbers in nginx conf file sites-enabled/ngcp-panel
>>> 
>>> Reason: config.yml had not been adapted during the upgrade to reflect the new entries within www_admin (http_admin and http_csc).
>>> I had to adapt config.yml manually (started a fresh vagrant setup to compare with a reference config.yml)
>> 
>> This is really strange, because is should be done in statement 15060:
>>>> https://github.com/sipwise/cfg-schema/blob/mr3.6.1/cfg_scripts/config/15060_www_admin_apache_move.up
>> 
>> Please check that is was executed during upgrade:
>>>> mysql ngcp -e "select * from cfg_schema where revision=15060“
> 
> Not executed.
> mysql> select * from cfg_schema where revision=15060;
> Empty set (0.00 sec)
> 
>> Can you please send me privately your config.yml from backup
>> if 15060 was executed but resulted config.yml had no http_admin and http_csc. You can find it in /var/backup/ngcp-mr3.6.1/ngcp-config
>> Tnx!
>> 
>> ------------------------------------------
>> 
>>> BTW:  /etc/nginx/sites-enabled still contained a link for discarded ngcp-www-csc
>> 
>> Yes, it contains. It is correct because ngcp-www-csc was not deleted,
>> it has been disabled only. It is going to be deleted in upcoming release(s).
>> 
>> ------------------------------------------
>> 
>>> 2) Login of users successful , however any activity including dashboard immediately results in "500 Internal server error (admin is working).
>>> The error log from panel.log:
>>> 
>>> Nov 14 17:14:04 ngcptest ngcp-panel: ERROR: fatal error, id=13A693CDA07AF0B0, timestamp=2014-11-14T16:14:04.224590000Z, error=DBIx::Class::ResultSet::all(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'me.source_gpp0' in 'field list' [for Statement "SELECT `me`.`id`, `me`.`update_time`, `me`.`source_user_id`, `me`.`source_provider_id`, `me`.`source_external_subscriber_id`, `me`.`source_external_contract_id`, `me`.`source_account_id`, `me`.`source_user`, `me`.`source_domain`, `me`.`source_cli`, `me`.`source_clir`, `me`.`source_ip`, `me`.`source_gpp0`, `me`.`source_gpp1`, `me`.`source_gpp2`, `me`.`source_gpp3`, `me`.`source_gpp4`, `me`.`source_gpp5`, `me`.`source_gpp6`, `me`.`source_gpp7`, `me`.`source_gpp8`, `me`.`source_gpp9`, `me`.`destination_user_id`, `me`.`destination_provider_id`, `me`.`destination_external_subscriber_id`, `me`.`destination_external_contract_id`, `me`.`destination_account_id`, `me`.`destination_user`, `me`.`destination_domain`, `me`.`destinatio
>> n_user_dialed`, `me`.`destination_user_in`, `me`.`destination_domain_in`, `me`.`destination_gpp0`, `me`.`destination_gpp1`, `me`.`destination_gpp2`, `me`.`destination_gpp3`, `me`.`destination_gpp4`, `me`.`destination_gpp5`, `me`.`destination_gpp6`, `me`.`destination_gpp7`, `me`.`destination_gpp8`, `me`.`destination_gpp9`, `me`.`peer_auth_user`, `me`.`peer_auth_realm`, `me`.`call_type`, `me`.`call_status`, `me`.`call_code`, `me`.`duration`, `me`.`call_id`, `me`.`source_carrier_cost`, `me`.`source_reseller_cost`, `me`.`source_customer_cost`, `me`.`source_carrier_free_time`, `me`.`source_reseller_free_time`, `me`.`source_customer_free_time`, `me`.`source_carrier_billing_fee_id`, `me`.`source_reseller_billing_fee_id`, `me`.`source_customer_billing_fee_id`, `me`.`source_carrier_billing_zone_id`, `me`.`source_reseller_billing_zone_id`, `me`.`source_customer_billing_zone_id`, `me`.`destination_carrier_cost`, `me`.`destination_reseller_cost`, `me`.`destination_customer_cost`, `me`.`destinatio
>> n_carrier_free_time`, `me`.`destination_reseller_free_time`, `me`.`destination_customer_free_time`, `me`.`destination_carrier_billing_fee_id`, `me`.`destination_reseller_billing_fee_id`, `me`.`destination_customer_billing_fee_id`, `me`.`destination_carrier_billing_zone_id`, `me`.`destination_reseller_billing_zone_id`, `me`.`destination_customer_billing_zone_id`, `me`.`frag_carrier_onpeak`, `me`.`frag_reseller_onpeak`, `me`.`frag_customer_onpeak`, `me`.`is_fragmented`, `me`.`split`, `me`.`rated_at`, `me`.`rating_status`, `me`.`exported_at`, `me`.`export_status`, `me`.`init_time`, `me`.`start_time` FROM (SELECT `me`.`id`, `me`.`update_time`, `me`.`source_user_id`, `me`.`source_provider_id`, `me`.`source_external_subscriber_id`, `me`.`source_external_contract_id`, `me`.`source_account_id`, `me`.`source_user`, `me`.`source_domain`, `me`.`source_cli`, `me`.`source_clir`, `me`.`source_ip`, `me`.`source_gpp0`, `me`.`source_gpp1`, `me`.`source_gpp2`, `me`.`source_gpp3`, `me`.`source_gpp4`, `m
>> e`.`source_gpp5`, `me`.`source_gpp6`, `me`.`source_gpp7`, `me`.`source_gpp8`, `me`.`source_gpp9`, `me`.`destination_user_id`, `me`.`destination_provider_id`, `me`.`destination_external_subscriber_id`, `me`.`destination_external_contract_id`, `me`.`destination_account_id`, `me`.`destination_user`, `me`.`destination_domain`, `me`.`destination_user_dialed`, `me`.`destination_user_in`, `me`.`destination_domain_in`, `me`.`destination_gpp0`, `me`.`destination_gpp1`, `me`.`destination_gpp2`, `me`.`destination_gpp3`, `me`.`destination_gpp4`, `me`.`destination_gpp5`, `me`.`destination_gpp6`, `me`.`destination_gpp7`, `me`.`destination_gpp8`, `me`.`destination_gpp9`, `me`.`peer_auth_user`, `me`.`peer_auth_realm`, `me`.`call_type`, `me`.`call_status`, `me`.`call_code`, `me`.`duration`, `me`.`call_id`, `me`.`source_carrier_cost`, `me`.`source_reseller_cost`, `me`.`source_customer_cost`, `me`.`source_carrier_free_time`, `me`.`source_reseller_free_time`, `me`.`source_customer_free_time`, `me`.`sourc
>> e_carrier_billing_fee_id`, `me`.`source_reseller_billing_fee_id`, `me`.`source_customer_billing_fee_id`, `
>> 
>> From one side I suspect cfg/db schema update was not executed during the upgrade, from another side I see in your log:
>>> Running CFG update...
>>> Running DB update...
>> So, no idea for the moment.... Can you please check max ID in cfg_schema and db_schema tables? They should have
>>>> root at spce:~# mysql ngcp -e "select * from cfg_schema order by revision desc limit 1"
>>>> +----+----------+------+---------------------+
>>>> | id | revision | node | applied_at          |
>>>> +----+----------+------+---------------------+
>>>> | 90 |    15067 | spce | 2014-11-17 02:55:08 |
>>>> +----+----------+------+---------------------+
>>>> root at spce:~# mysql ngcp -e "select * from db_schema order by revision desc limit 1"
>>>> +-----+----------+------+---------------------+
>>>> | id  | revision | node | applied_at          |
>>>> +-----+----------+------+---------------------+
>>>> | 325 |    15111 | spce | 2014-11-17 02:55:01 |
>>>> +-----+----------+------+---------------------+
>>>> root at spce:~# cat /etc/ngcp_version
>>>> mr3.6.1
> 
> Similar result - no update.
> 
> mysql> select * from cfg_schema order by revision desc limit 1;
> +-----+----------+------+——————————+
> | id  | revision | node | applied_at          |
> +-----+----------+------+---------------------+
> | 105 |    15058 | sip0 | 2014-10-24 17:18:39 |
> +-----+----------+------+---------------------+
> 1 row in set (0.00 sec)
> 
> 
> 
>> You can try to upgrade them once more (already executed statements will be skipped):
>>> VERBOSE=yes ngcp-update-cfg-schema
>>> VERBOSE=yes ngcp-update-db-schema
>> 
>> Please share your results here. Tnx!
>> 
> Quite strange:
> 
> 
> root at sip0:/# VERBOSE=yes ngcp-update-cfg-schema
> This seems to be the active node, nothing to do.
> 
> root at sip0:/# VERBOSE=yes ngcp-update-db-schema
> [ ok ] Starting MySQL database server: mysqld already running.
> This seems to be the active node, nothing to do.
> Replication script 0010_create_bss.up noted, nothing to do on active node
> Replication script 0020_create_oss.up noted, nothing to do on active node
> Replication script 0030_create_kamailio_301.up noted, nothing to do on active node
> Replication script 0040_create_oss_triggers_kamailio.up noted, nothing to do on active node
> Replication script 0050_create_accounting.up noted, nothing to do on active node
> Replication script 0060_create_syslog.up noted, nothing to do on active node
> Replication script 0080_grants_dbs.up noted, nothing to do on active node
> Replication script 3972.up noted, nothing to do on active node
> Replication script 3975.up noted, nothing to do on active node
> Replication script 4026.up noted, nothing to do on active node
> Replication script 4042.up noted, nothing to do on active node
> Replication script 4063.up noted, nothing to do on active node
> Replication script 4085.up noted, nothing to do on active node
> Replication script 4095.up noted, nothing to do on active node
> Replication script 4112.up noted, nothing to do on active node
> Replication script 4145.up noted, nothing to do on active node
> Replication script 4496.up noted, nothing to do on active node
> Replication script 4665.up noted, nothing to do on active node
> Replication script 4668.up noted, nothing to do on active node
> Replication script 4701.up noted, nothing to do on active node
> Replication script 4711.up noted, nothing to do on active node
> Replication script 4712.up noted, nothing to do on active node
> Replication script 4717.up noted, nothing to do on active node
> Replication script 4735.up noted, nothing to do on active node
> Replication script 4762.up noted, nothing to do on active node
> Replication script 4832.up noted, nothing to do on active node
> Replication script 4875.up noted, nothing to do on active node
> Replication script 4968.up noted, nothing to do on active node
> Replication script 4984.up noted, nothing to do on active node
> Replication script 5000_fix_billing.up noted, nothing to do on active node
> Replication script 5249.up noted, nothing to do on active node
> Replication script 5283.up noted, nothing to do on active node
> Replication script 5300.up noted, nothing to do on active node
> Replication script 5347.up noted, nothing to do on active node
> Replication script 5472.up noted, nothing to do on active node
> Replication script 5538.up noted, nothing to do on active node
> Replication script 5543.up noted, nothing to do on active node
> Replication script 5553.up noted, nothing to do on active node
> Replication script 5603.up noted, nothing to do on active node
> Replication script 5604.up noted, nothing to do on active node
> Replication script 5607.up noted, nothing to do on active node
> Replication script 5670_grants_dbs.up noted, nothing to do on active node
> Replication script 5709.up noted, nothing to do on active node
> Replication script 5722.up noted, nothing to do on active node
> Replication script 5726.up noted, nothing to do on active node
> Replication script 5728.up noted, nothing to do on active node
> Replication script 5737.up noted, nothing to do on active node
> Replication script 5744.up noted, nothing to do on active node
> Replication script 5749.up noted, nothing to do on active node
> Replication script 5800.up noted, nothing to do on active node
> Replication script 5824.up noted, nothing to do on active node
> Replication script 5826.up noted, nothing to do on active node
> Replication script 5831.up noted, nothing to do on active node
> Replication script 5833.up noted, nothing to do on active node
> Replication script 5843.up noted, nothing to do on active node
> Replication script 5973.up noted, nothing to do on active node
> Replication script 6254.up noted, nothing to do on active node
> Replication script 6346.up noted, nothing to do on active node
> Replication script 6425.up noted, nothing to do on active node
> Replication script 6436.up noted, nothing to do on active node
> Replication script 6459.up noted, nothing to do on active node
> Replication script 6465.up noted, nothing to do on active node
> Replication script 6551.up noted, nothing to do on active node
> Replication script 6560.up noted, nothing to do on active node
> Replication script 6568.up noted, nothing to do on active node
> Replication script 6619.up noted, nothing to do on active node
> Replication script 6624.up noted, nothing to do on active node
> Replication script 6643.up noted, nothing to do on active node
> Replication script 6712.up noted, nothing to do on active node
> Replication script 6746.up noted, nothing to do on active node
> Replication script 7006.up noted, nothing to do on active node
> Replication script 7036.up noted, nothing to do on active node
> Replication script 7065.up noted, nothing to do on active node
> Replication script 7095.up noted, nothing to do on active node
> Replication script 7209.up noted, nothing to do on active node
> Replication script 7252.up noted, nothing to do on active node
> Replication script 7259.up noted, nothing to do on active node
> Replication script 7260.up noted, nothing to do on active node
> Replication script 7485.up noted, nothing to do on active node
> Replication script 7493.up noted, nothing to do on active node
> Replication script 7496.up noted, nothing to do on active node
> Replication script 7500.up noted, nothing to do on active node
> Replication script 7644.up noted, nothing to do on active node
> Replication script 7647.up noted, nothing to do on active node
> Replication script 7656.up noted, nothing to do on active node
> Replication script 7764.up noted, nothing to do on active node
> Replication script 7937.up noted, nothing to do on active node
> Replication script 7991.up noted, nothing to do on active node
> Replication script 8169.up noted, nothing to do on active node
> Replication script 8293.up noted, nothing to do on active node
> Replication script 8408.up noted, nothing to do on active node
> Replication script 8461.up noted, nothing to do on active node
> Replication script 8466.up noted, nothing to do on active node
> Replication script 8467.up noted, nothing to do on active node
> Replication script 8629.up noted, nothing to do on active node
> Replication script 8704.up noted, nothing to do on active node
> Replication script 8846.up noted, nothing to do on active node
> Replication script 8878.up noted, nothing to do on active node
> Replication script 8997.up noted, nothing to do on active node
> Replication script 9069.up noted, nothing to do on active node
> Replication script 9086.up noted, nothing to do on active node
> Replication script 9106.up noted, nothing to do on active node
> Replication script 9114.up noted, nothing to do on active node
> Replication script 9119.up noted, nothing to do on active node
> Replication script 9150.up noted, nothing to do on active node
> Replication script 9154.up noted, nothing to do on active node
> Replication script 9159.up noted, nothing to do on active node
> Replication script 9166.up noted, nothing to do on active node
> Replication script 9187.up noted, nothing to do on active node
> Replication script 9188.up noted, nothing to do on active node
> Replication script 9204.up noted, nothing to do on active node
> Replication script 9205.up noted, nothing to do on active node
> Replication script 9221.up noted, nothing to do on active node
> Replication script 9222.up noted, nothing to do on active node
> Replication script 9228.up noted, nothing to do on active node
> Replication script 9249.up noted, nothing to do on active node
> Replication script 9256.up noted, nothing to do on active node
> Replication script 9303.up noted, nothing to do on active node
> Replication script 9312.up noted, nothing to do on active node
> Replication script 9458.up noted, nothing to do on active node
> Replication script 9675.up noted, nothing to do on active node
> Replication script 9723.up noted, nothing to do on active node
> Replication script 9733.up noted, nothing to do on active node
> Replication script 9791.up noted, nothing to do on active node
> Replication script 9868.up noted, nothing to do on active node
> Replication script 10180.up noted, nothing to do on active node
> Replication script 10203.up noted, nothing to do on active node
> Replication script 10210.up noted, nothing to do on active node
> Replication script 10268.up noted, nothing to do on active node
> Replication script 10272.up noted, nothing to do on active node
> Replication script 10287.up noted, nothing to do on active node
> Replication script 10290.up noted, nothing to do on active node
> Replication script 10331.up noted, nothing to do on active node
> Replication script 10332.up noted, nothing to do on active node
> Replication script 10423.up noted, nothing to do on active node
> Replication script 10538.up noted, nothing to do on active node
> Replication script 10639.up noted, nothing to do on active node
> Replication script 10728.up noted, nothing to do on active node
> Replication script 10860.up noted, nothing to do on active node
> Replication script 10877.up noted, nothing to do on active node
> Replication script 10890.up noted, nothing to do on active node
> Replication script 10934.up noted, nothing to do on active node
> Replication script 10950.up noted, nothing to do on active node
> Replication script 10951.up noted, nothing to do on active node
> Replication script 11039.up noted, nothing to do on active node
> Replication script 11062.up noted, nothing to do on active node
> Replication script 11188.up noted, nothing to do on active node
> Replication script 11245.up noted, nothing to do on active node
> Replication script 11350.up noted, nothing to do on active node
> Replication script 11379.up noted, nothing to do on active node
> Replication script 11565.up noted, nothing to do on active node
> Replication script 11581.up noted, nothing to do on active node
> Replication script 11812.up noted, nothing to do on active node
> Replication script 11817.up noted, nothing to do on active node
> Replication script 11818.up noted, nothing to do on active node
> Replication script 11819.up noted, nothing to do on active node
> Replication script 12002.up noted, nothing to do on active node
> Replication script 12061.up noted, nothing to do on active node
> Replication script 12062.up noted, nothing to do on active node
> Replication script 12117.up noted, nothing to do on active node
> Replication script 12144.up noted, nothing to do on active node
> Replication script 12162.up noted, nothing to do on active node
> Replication script 12279.up noted, nothing to do on active node
> Replication script 12649.up noted, nothing to do on active node
> Replication script 12693.up noted, nothing to do on active node
> Replication script 12765.up noted, nothing to do on active node
> Replication script 13041.up noted, nothing to do on active node
> Replication script 13117.up noted, nothing to do on active node
> Replication script 13125.up noted, nothing to do on active node
> Replication script 13126.up noted, nothing to do on active node
> Replication script 13127.up noted, nothing to do on active node
> Replication script 13140.up noted, nothing to do on active node
> Replication script 13216.up noted, nothing to do on active node
> Replication script 13225.up noted, nothing to do on active node
> Replication script 13226.up noted, nothing to do on active node
> Replication script 13288.up noted, nothing to do on active node
> Replication script 13393.up noted, nothing to do on active node
> Replication script 13447.up noted, nothing to do on active node
> Replication script 13449.up noted, nothing to do on active node
> Replication script 13474.up noted, nothing to do on active node
> Replication script 13475.up noted, nothing to do on active node
> Replication script 13519.up noted, nothing to do on active node
> Replication script 13658.up noted, nothing to do on active node
> Replication script 13659.up noted, nothing to do on active node
> Replication script 13829.up noted, nothing to do on active node
> Replication script 13830.up noted, nothing to do on active node
> Replication script 13831.up noted, nothing to do on active node
> Replication script 13833.up noted, nothing to do on active node
> Replication script 13834.up noted, nothing to do on active node
> Replication script 13835.up noted, nothing to do on active node
> Replication script 13836.up noted, nothing to do on active node
> Replication script 13837.up noted, nothing to do on active node
> Replication script 13838.up noted, nothing to do on active node
> Replication script 13839.up noted, nothing to do on active node
> Replication script 13841.up noted, nothing to do on active node
> Replication script 15000.up noted, nothing to do on active node
> Replication script 15001.up noted, nothing to do on active node
> Replication script 15005.up noted, nothing to do on active node
> Replication script 15006.up noted, nothing to do on active node
> Replication script 15007.up noted, nothing to do on active node
> Replication script 15008.up noted, nothing to do on active node
> Replication script 15009.up noted, nothing to do on active node
> Replication script 15010.up noted, nothing to do on active node
> Replication script 15011.up noted, nothing to do on active node
> Replication script 15013.up noted, nothing to do on active node
> Replication script 15014.up noted, nothing to do on active node
> Replication script 15015.up noted, nothing to do on active node
> Replication script 15016.up noted, nothing to do on active node
> Replication script 15017.up noted, nothing to do on active node
> Replication script 15018.up noted, nothing to do on active node
> Replication script 15019.up noted, nothing to do on active node
> Replication script 15020.up noted, nothing to do on active node
> Replication script 15021.up noted, nothing to do on active node
> Replication script 15022.up noted, nothing to do on active node
> Replication script 15023.up noted, nothing to do on active node
> Replication script 15024.up noted, nothing to do on active node
> Replication script 15025.up noted, nothing to do on active node
> Replication script 15026.up noted, nothing to do on active node
> Replication script 15027.up noted, nothing to do on active node
> Replication script 15028.up noted, nothing to do on active node
> Replication script 15029.up noted, nothing to do on active node
> Replication script 15030.up noted, nothing to do on active node
> Replication script 15031.up noted, nothing to do on active node
> Replication script 15032.up noted, nothing to do on active node
> Replication script 15033.up noted, nothing to do on active node
> Replication script 15034.up noted, nothing to do on active node
> Replication script 15035.up noted, nothing to do on active node
> Replication script 15036.up noted, nothing to do on active node
> Replication script 15037.up noted, nothing to do on active node
> Replication script 15038.up noted, nothing to do on active node
> Replication script 15039.up noted, nothing to do on active node
> Replication script 15040.up noted, nothing to do on active node
> Replication script 15041.up noted, nothing to do on active node
> Replication script 15042.up noted, nothing to do on active node
> Replication script 15043.up noted, nothing to do on active node
> Replication script 15044.up noted, nothing to do on active node
> Replication script 15045.up noted, nothing to do on active node
> Replication script 15046.up noted, nothing to do on active node
> Replication script 15047.up noted, nothing to do on active node
> Replication script 15048.up noted, nothing to do on active node
> Replication script 15049.up noted, nothing to do on active node
> Replication script 15050.up noted, nothing to do on active node
> Replication script 15051.up noted, nothing to do on active node
> Replication script 15052.up noted, nothing to do on active node
> Replication script 15053.up noted, nothing to do on active node
> Replication script 15054.up noted, nothing to do on active node
> Replication script 15055.up noted, nothing to do on active node
> Replication script 15056.up noted, nothing to do on active node
> Replication script 15057.up noted, nothing to do on active node
> Replication script 15058.up noted, nothing to do on active node
> Replication script 15059.up noted, nothing to do on active node
> Replication script 15060.up noted, nothing to do on active node
> Replication script 15061.up noted, nothing to do on active node
> Replication script 15062.up noted, nothing to do on active node
> Replication script 15063.up noted, nothing to do on active node
> Replication script 15064.up noted, nothing to do on active node
> Replication script 15065.up noted, nothing to do on active node
> Replication script 15066.up noted, nothing to do on active node
> Replication script 15067.up noted, nothing to do on active node
> Replication script 15068.up noted, nothing to do on active node
> Replication script 15069.up noted, nothing to do on active node
> Replication script 15070.up noted, nothing to do on active node
> Replication script 15071.up noted, nothing to do on active node
> Replication script 15072.up noted, nothing to do on active node
> Replication script 15073.up noted, nothing to do on active node
> Replication script 15074.up noted, nothing to do on active node
> Replication script 15075.up noted, nothing to do on active node
> Replication script 15076.up noted, nothing to do on active node
> Replication script 15077.up noted, nothing to do on active node
> Replication script 15078.up noted, nothing to do on active node
> Replication script 15079.up noted, nothing to do on active node
> Replication script 15080.up noted, nothing to do on active node
> Replication script 15081.up noted, nothing to do on active node
> Replication script 15082.up noted, nothing to do on active node
> Replication script 15083.up noted, nothing to do on active node
> Replication script 15084.up noted, nothing to do on active node
> Replication script 15085.up noted, nothing to do on active node
> Replication script 15086.up noted, nothing to do on active node
> Replication script 15087.up noted, nothing to do on active node
> Replication script 15088.up noted, nothing to do on active node
> Replication script 15089.up noted, nothing to do on active node
> Replication script 15090.up noted, nothing to do on active node
> Replication script 15091.up noted, nothing to do on active node
> Replication script 15092.up noted, nothing to do on active node
> Replication script 15093.up noted, nothing to do on active node
> Replication script 15094.up noted, nothing to do on active node
> Replication script 15095.up noted, nothing to do on active node
> Replication script 15096.up noted, nothing to do on active node
> Replication script 15097.up noted, nothing to do on active node
> Replication script 15098.up noted, nothing to do on active node
> Replication script 15099.up noted, nothing to do on active node
> Replication script 15100.up noted, nothing to do on active node
> Replication script 15101.up noted, nothing to do on active node
> Replication script 15102.up noted, nothing to do on active node
> Replication script 15103.up noted, nothing to do on active node
> Replication script 15104.up noted, nothing to do on active node
> Replication script 15105.up noted, nothing to do on active node
> Replication script 15106.up noted, nothing to do on active node
> Replication script 15107.up noted, nothing to do on active node
> Replication script 15109.up noted, nothing to do on active node
> Replication script 15110.up noted, nothing to do on active node
> Replication script 15111.up noted, nothing to do on active node
> Synchronizing passwords with MySQL
> 
> 
> 
> 
>> ------------------------------------------
>> 
>>> after a quick investigation, I think ngcp-upgrade for mr3.5.1 to mr3.6.1 has the following issues:
>>> a) config.yml has not been upgraded (easy to fix)
>> 
>> It should be upgraded automatically... maybe you have more then one config.yml into /etc/ngcp-config/ ? Or some customtt files?
>> 
> 
> Actually only a rather old copy config.yml.factory_default exists, there is/was no config customtt file.
> 
>> ------------------------------------------
>> 
>>> b) the database schema has not been updated to 3.6.1 although ngcp-upgrade-schema had been executed  (e.g. accounting.cdr is missing the new fields source_gpp0 …) (not so easy to fix)
>>> The files within /usr/share/ngcp-db-schema are all dated 30th Oct.
>> 
>> The DB update statement #15109 had to do this:
>>> https://github.com/sipwise/db-schema/blob/mr3.6.1/db_scripts/diff/15109.up
>> Please check the content of ngcp.db_schema table...
>> 
>> Also please check that content of field 'node' from ngcp.db_schema equal to content of file /etc/ngcp_nodename
> 
> mysql ngcp -e "select * from db_schema"
> +-----+----------+------+---------------------+
> | id  | revision | node | applied_at          |
> +-----+----------+------+---------------------+
> |   1 |       10 | sip0 | 2014-04-14 15:01:58 |
> |   2 |       20 | sip0 | 2014-04-14 15:01:58 |
> 
> ….
> | 301 |    15087 | sip0 | 2014-08-07 16:40:35 |
> | 302 |    15089 | sip0 | 2014-08-07 16:40:35 |
> | 303 |    15090 | sip0 | 2014-08-07 16:40:35 |
> | 304 |    15108 | sip0 | 2014-11-14 12:35:15 |
> +-----+----------+------+——————————+
> 
> # cat /etc/ngcp_nodename 
> sip0
> 
> 
>> Tnx! I hope those comments were useful for you.
>> 
>> -- 
>> Alexander Lutay
>> Head of Quality Assurance
>> Sipwise GmbH, Campus 21/Europaring F15
>> AT-2345 Brunn am Gebirge
>> 
>> Office: +43(0)13012036
>> Email: alutay at sipwise.com
>> Website: http://www.sipwise.com
>> 
>> Meet us @ AFRICACOM : Booth A17/A18
>> 11-13 November 2014 : CTICC Cape Town, South Africa
>> _______________________________________________
>> Spce-user mailing list
>> Spce-user at lists.sipwise.com
>> https://lists.sipwise.com/listinfo/spce-user
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 496 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20141117/97445306/attachment-0001.asc>


More information about the Spce-user mailing list