[Spce-user] Failed upgrade 3.8.8 to 4.5 LTS
Abel Alejandro
aalejandro at alliedtechnologygrouppr.com
Fri Jan 20 05:52:30 EST 2017
I got the same issue, was there a fix?
root at sip:~# cat /etc/sipwise_ngcp_version
System installed. NGCP version mr5.0.1 on 2017-01-19 19:27:48
root at sip:~#
root at sip:~# /usr/sbin/ngcp-sync-grants --verbose
--> connected to localhost:3306 as sipwise
--> host: sip (self)
--> [defaults.asterisk.localhost]
--> [defaults.dbcleaner.localhost]
--> [defaults.export.localhost]
--> [defaults.exporter.localhost]
--> [defaults.fileshare.localhost]
--> [defaults.kamailio.localhost]
--> [defaults.kamailioro.localhost]
--> [defaults.ldap.localhost]
--> [defaults.mediator.localhost]
--> [defaults.nagios.localhost]
Error: Unknown grant element: create tablespace at
/usr/sbin/ngcp-sync-grants line 341.
root at sip:~#
root at sip:~# cat /etc/mysql/grants.yml
---
defaults:
asterisk:
localhost:
- all privileges on kamailio.voicemail_spool
- all privileges on kamailio.voicemail_users
- select on provisioning.voip_dbaliases
- select on provisioning.voip_subscribers
dbcleaner:
localhost:
- all privileges on accounting.*
- all privileges on kamailio.*
export:
localhost:
- select, update on accounting.events
- select, insert, update on accounting.mark
- select on billing.*
- select on provisioning.*
exporter:
localhost:
- select,update on accounting.cdr
- select on accounting.cdr_cash_balance
- select on accounting.cdr_cash_balance_data
- select on accounting.cdr_direction
- select on accounting.cdr_provider
- select on accounting.cdr_tag
- select on accounting.cdr_tag_data
- select on accounting.cdr_time_balance
- select on accounting.cdr_time_balance_data
- select on accounting.cdr_relation
- select on accounting.cdr_relation_data
- select on accounting.events_tag
- select on accounting.events_tag_data
- select on accounting.events_relation
- select on accounting.events_relation_data
- select, update on accounting.events
- select,insert,update on accounting.mark
- select on billing.*
- select on billing.billing_zones_history
- select on billing.resellers
- select on billing.voip_subscribers
- select on provisioning.*
fileshare:
localhost:
- all on fileshare.*
- select on provisioning.voip_subscribers
kamailio:
localhost:
- all on kamailio.*
- select on billing.lnp_numbers
- select on billing.ncos_levels
- select on billing.ncos_lnp_list
- select on billing.ncos_pattern_list
- select on provisioning.voip_dbaliases
- select on provisioning.voip_cf_source_sets
- select on provisioning.voip_cf_sources
- select on provisioning.voip_cf_destination_sets
- select on provisioning.voip_cf_destinations
- select on provisioning.voip_cf_mappings
- select on provisioning.voip_cf_periods
- select on provisioning.voip_cf_time_sets
- select on provisioning.voip_contract_locations
- select on provisioning.voip_contract_location_blocks
- select on provisioning.voip_peer_hosts
- select on provisioning.voip_sound_sets
- select on provisioning.voip_sound_handles
- select on provisioning.voip_sound_files
- select on provisioning.voip_subscribers
kamailioro:
localhost:
- select on billing.lnp_numbers
- select on billing.lnp_providers
- select on billing.ncos_levels
- select on billing.ncos_lnp_list
- select on billing.ncos_pattern_list
- select on kamailio.*
- select on provisioning.voip_cf_sources
- select on provisioning.voip_cf_source_sets
- select on provisioning.voip_cf_destinations
- select on provisioning.voip_cf_destination_sets
- select on provisioning.voip_cf_mappings
- select on provisioning.voip_cf_periods
- select on provisioning.voip_cf_time_sets
- select on provisioning.voip_dbaliases
- select on provisioning.voip_domains
- select on provisioning.voip_peer_hosts
- select on provisioning.voip_peer_groups
- select on provisioning.voip_peer_inbound_rules
- select on provisioning.voip_sound_files
- select on provisioning.voip_sound_handles
- select on provisioning.voip_sound_sets
- select on provisioning.voip_subscribers
- select on provisioning.emergency_mappings
ldap:
localhost:
- select on billing.contracts
- select on ldap.*
- select on provisioning.voip_preferences
- select on provisioning.voip_subscribers
- select on provisioning.voip_usr_preferences
mediator:
localhost:
- all on accounting.*
- select on billing.*
- select on provisioning.*
- select,insert,update on stats.call_info
nagios:
localhost:
- select on kamailio.location
- select on mysql.*
- select on provisioning.voip_subscribers
- select on sipstats.*
- select on stats.call_info
- reload, super, replication slave, replication client on *.*
prosody:
localhost:
- all privileges on prosody.*
- select on billing.contacts
- select on billing.contracts
- select on billing.domains
- select on billing.voip_subscribers
- select on kamailio.dbaliases
- select on kamailio.domain
- select on kamailio.subscriber
- select on provisioning.voip_dbaliases
- select on provisioning.voip_domains
- select on provisioning.voip_dom_preferences
- select on provisioning.voip_pbx_groups
- select on provisioning.voip_preferences
- select on provisioning.voip_rewrite_rule_sets
- select on provisioning.voip_rewrite_rules
- select on provisioning.voip_subscribers
- select on provisioning.voip_usr_preferences
rateomat:
localhost:
- select,insert,update on accounting.*
- delete on accounting.prepaid_costs
- select,insert,update on billing.*
- select on provisioning.voip_preferences
- select on provisioning.voip_subscribers
- select,delete,update,insert on
provisioning.voip_usr_preferences
rsyslog:
localhost:
- all on syslog.*
- reload on *.*
rtcengine:
localhost:
- all on rtcengine.*
sems_prepaid:
localhost:
- select on kamailio.dbaliases
- select,insert,update,delete on kamailio.sems_registrations
- select,insert,update,delete on accounting.malicious_calls
- select,insert,update on accounting.prepaid_costs
- select,insert,update on billing.*
- select on provisioning.voip_peer_hosts
- select on provisioning.voip_peer_groups
- select on provisioning.voip_sound_files
- select on provisioning.voip_sound_handles
- select on provisioning.voip_preferences
- select on provisioning.voip_subscribers
- select on provisioning.voip_domains
- select on provisioning.voip_rewrite_rules
- select on provisioning.voip_rewrite_rule_sets
- select on provisioning.voip_subscriber_profile_attributes
- select on provisioning.voip_cc_mappings
- select on provisioning.voip_pbx_autoattendants
- select,delete,update,insert on
provisioning.voip_usr_preferences
- select,delete,update,insert on
provisioning.voip_dom_preferences
- select,insert,update,delete on provisioning.voip_speed_dial
- select,insert,update,delete on provisioning.voip_reminder
- select,insert,update,delete on
provisioning.voip_cf_destination_sets
- select,insert,update,delete on
provisioning.voip_cf_destinations
- select,insert,update,delete on provisioning.voip_cf_mappings
sipwise:
localhost:
- grant all privileges on *.* with grant option
soap:
localhost:
- all on accounting.*
- all on billing.*
- all privileges on carrier.*
- all on kamailio.*
- all on provisioning.*
- all on sipstats.*
voisniff:
localhost:
- all on sipstats.*
- select on billing.voip_intercept
hosts:
self: defaults.*.*
copy: ~
drop:
hylafax: *
order:
- drop
- hosts
- copy
On Thu, Dec 29, 2016 at 6:47 AM, Alex Lutay <alutay at sipwise.com> wrote:
> This looks very strange "create tablespace at":
>
> On 12/19/2016 11:17 PM, Dave Massey wrote:
> > Error: Unknown grant element: create tablespace at
> > /usr/sbin/ngcp-sync-grants line 341.
>
> Any possibility to trigger manually:
> /usr/sbin/ngcp-sync-grants --verbose
> ?
>
> Also, please share content of /etc/mysql/grants.yml
>
> Thank you!
>
> --
> Alex Lutay
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
>
--
*Abel Alejandro*
787 586 8313 | 787 705 0555
<joquendo at alliedtechnologygrouppr.com>
400 Calle Calaf 477
San Juan, PR 00918
aalejandro at alliedtechnologygrouppr.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20170120/299ab420/attachment.html>
More information about the Spce-user
mailing list