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

[Thomas Odorfer]

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>:

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>
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/2449ea5c/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 455 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20170115/2449ea5c/attachment-0001.asc>