[Spce-user] mr4.5.3 upgrade issue - synchronizing mysql grants

Matthias Hohl matthias.hohl at telematica.at
Sun Jan 15 11:21:40 EST 2017


No problem ;)

 

Von: Thomas Odorfer [mailto:odotom at gmail.com] 
Gesendet: Sonntag, 15. Jänner 2017 11:15
An: Spce-user <spce-user at lists.sipwise.com>
Cc: Matthias Hohl <matthias.hohl at telematica.at>
Betreff: Re: [Spce-user] mr4.5.3 upgrade issue - synchronizing mysql grants

 

Thanks for the hint -solved -

thought that update schema (ngcp-update-db-schema) will be performed automatically.

 

Am 14.01.2017 um 23:32 schrieb Matthias Hohl <matthias.hohl at telematica.at <mailto:matthias.hohl at telematica.at> >:

 

Hey,

 

did you it with this?

 

apt-get update && apt-get upgrade && ngcp-update-db-schema && ngcp-update-cfg-schema && ngcpcfg apply 'Hotfix Update'

 

don’t sure but this but an idea, that the problem ist he db schema

 

Von: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] Im Auftrag von Thomas Odorfer
Gesendet: Samstag, 14. Jänner 2017 23:10
An: Spce-user <spce-user at lists.sipwise.com <mailto:spce-user at lists.sipwise.com> >
Betreff: [Spce-user] mr4.5.3 upgrade issue - synchronizing mysql grants

 

After performing an apt-upgrade on mr4.5.3 the following happened during ngcpcfg apply:

 

2017-01-14 22:47:10:Synchronizing MySQL grants/credentials
Warning: Cannot apply grant: Table 'accounting.events_tag' doesn't exist
Warning: Cannot apply grant: Table 'accounting.events_tag_data' doesn't exist
Warning: Cannot apply grant: Table 'accounting.events_relation' doesn't exist
Warning: Cannot apply grant: Table 'accounting.events_relation_data' doesn't exist
                     -->   revoke all from: exporter at localhost
2017-01-14 22:47:10: Synchronizing MySQL grants/credentials
Warning: Cannot apply grant: Table 'accounting.events_tag' doesn't exist
Warning: Cannot apply grant: Table 'accounting.events_tag_data' doesn't exist
Warning: Cannot apply grant: Table 'accounting.events_relation' doesn't exist
Warning: Cannot apply grant: Table 'accounting.events_relation_data' doesn't exist
                     -                        

 

2017-01-14 22:47:10: Synchronizing MySQL grants/credentials

Warning: Cannot apply grant: Table 'accounting.events_tag' doesn't exist

Warning: Cannot apply grant: Table 'accounting.events_tag_data' doesn't exist

Warning: Cannot apply grant: Table 'accounting.events_relation' doesn't exist

Warning: Cannot apply grant: Table 'accounting.events_relation_data' doesn't exist

                     -->   revoke all from: exporter at localhost

                     -->   grant select,update on accounting.cdr to exporter at localhost 






(Repeatable with ngcpcfg apply)

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20170115/a4b6c64c/attachment-0001.html>


More information about the Spce-user mailing list