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

[Thomas Odorfer]

Hi,
after a quick investigation, I think ngcp-upgrade for mr3.5.1 to mr2.6.1 has the following issues:
a) config.yml has not been upgraded (easy to fix)
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.

See also attached the corresponding upgrade.log
BR, Thomas 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: ngcp-3.6.1-upgrade.log
Type: application/octet-stream
Size: 57944 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20141115/07b3a4bb/attachment-0001.log>
-------------- next part --------------

Am 14.11.2014 um 17:23 schrieb Thomas Odorfer <odotom at gmail.com>:

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)
BTW:  /etc/nginx/sites-enabled still contained a link for discarded ngcp-www-csc

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`.`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`.`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`.`destination_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`, `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`.`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`.`source_carrier_billing_fee_id`, `me`.`source_reseller_billing_fee_id`, `me`.`source_customer_billing_fee_id`, `


-------------- 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/20141115/07b3a4bb/attachment-0001.asc>