[Spce-user] Errror while upgrading from mr4.5.3 to mr5.5.2

Alex Lutay alutay at sipwise.com
Wed Jan 24 06:13:37 EST 2018


I am strongly believe you are right. You must have both users (since
they are for the different component):

> MariaDB [mysql]> select Host , User from user where User like '%engine';
> +-----------+-----------+
> | Host      | User      |
> +-----------+-----------+
> | localhost | rtcengine |
> | localhost | rtpengine |
> +-----------+-----------+
> 2 rows in set (0.00 sec)

When you restore 'rtpengine' you have to check and re-execute
'15324.up', I believe the necessary part is only:

> grant all on provisioning.recording_calls to 'rtpengine'@'localhost';
> grant all on provisioning.recording_streams to 'rtpengine'@'localhost';

and remove unnecessary grants from 'rtCengine' you have created.

When you finish, repeat: ngcpcfg apply "reapplying to sync rtPengine"

On 01/23/2018 01:05 PM, Raúl Alexis Betancor Santana wrote:
> Blaming that rtpengine user was not found on the user mysql table ... I
> checked and thats whats true, the user there was rtCengine, so I
> upgraded the user table, deleted the 2 recording related tables, fixed
> the constans.yml file that also points to rtcengine user and run
> ngcp-upgrade again ... it continues till the mentioned error about the
> grants/credentials ... that I have the feeling that its related to that
> previous error.

Alex Lutay

More information about the Spce-user mailing list