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

Thomas Odorfer odotom at gmail.com
Mon Nov 17 10:36:18 EST 2014


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/mailman/private/spce-user_lists.sipwise.com/attachments/20141117/ccd0e1ee/attachment.asc>


More information about the Spce-user mailing list