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

[Raúl Alexis Betancor Santana]

If both users must exist ... then there are a bug elsewhere ...

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

I did not created any grants or users ... just run ngcp-upgrade, than it stops where I told.

Whoe constants.yml should look like ? ...

[...]
mysql:
    asterisk:
      p: qwrssbnAdrrMcyoyLg4C
      u: asterisk
    cdrexport:
      p: AUTnuv4y7AmRdYhcRJ7x
      u: exporter
    checktools:
      p: hfgdqnu47EhHdxCgVWfE
      u: nagios
    cleanuptools:
      p: WAzfabycjnHFrCg7bXCC
      u: dbcleaner
    debian:
      p: erAAaB0oMoOSEvxQ
      u: debian-sys-maint
    fileshare:
      p: prp3nEozpecw7JqwPmaH
      u: fileshare
    kamailio:
      p: MMLyTk39jWn7CvhmMExE
      u: kamailio
    kamailioro:
      p: sKMeARwN7a9sejpLcNeo
      u: kamailioro
    ldap:
      p: jkXXmjYT3XkyvNUgumJp
      u: ldap
    mediator:
      p: nw4hzLjwrstPtoUsxjpN
      u: mediator
    prosody:
      p: nriaWcKFPrp4JmKEo4rv
      u: prosody
    provisioning:
      p: KPqeCapEuVEja4VgU9UE
      u: soap
    rateomat:
      p: vfRiHfTzCnR9eqavryed
      u: rateomat
    replicator:
      p: vtyWeAfugHkPqPzC39Tc
      u: replicator
    rsyslog:
      p: VV4opnyfmMAbUFJkHpC7
      u: rsyslog
    rtpengine:
      p: Ptcsi9JgH7ug4aANEPhV
      u: rtpengine
    sems:
      p: XknajiJLqqF4vJVKYoWx
      u: sems_prepaid
    voisniff:
      p: gnJruwHPytowiR7taRxR
      u: visniff
[...]

I changed rtcengine by rtpengine there

----- Mensaje original -----
> De: "Alex Lutay" <alutay at sipwise.com>
> Para: spce-user at lists.sipwise.com
> Enviados: Miércoles, 24 de Enero 2018 11:13:37
> Asunto: Re: [Spce-user] Errror while upgrading from mr4.5.3 to mr5.5.2

> Hi,
> 
> 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
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
(null)