[Spce-user] Mediator not starting after upgrade

[qabane me]

Hi Alex

Yes we have just upgraded. I will start a vm with 3.8 to check it out. The
grants currently there are:
+-----------------------------------------------------------------------------------------------------------------+
| Grants for mediator at localhost
|
+-----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'mediator'@'localhost' IDENTIFIED BY PASSWORD
'*C7DDD65A344BE2A8C499E1114EB5C80F53358E1A' |
| GRANT ALL PRIVILEGES ON `accounting`.* TO 'mediator'@'localhost'
|
| GRANT SELECT ON `provisioning`.* TO 'mediator'@'localhost'
|
| GRANT SELECT ON `billing`.* TO 'mediator'@'localhost'
|
| GRANT SELECT, INSERT, UPDATE ON `stats`.`call_info` TO
'mediator'@'localhost'
|
+------------------------------------------------------------------------------------------

So it seems like the privilege is there at face value

On Mon, Aug 20, 2018 at 10:53 AM, Alex Lutay <alutay at sipwise.com> wrote:

> Hi,
>
> I do not recall such issues. Just to be sure,
> have you upgraded to mr3.8.13 ?
>
> In modern releases mysql credentials and grants are updated
> on every 'ngcpcfg apply', so they are always correct and up2date with
> the running release. Release mr3.8 didn't have such functionality.
>
> As a hint here, start mr3.8.13 Vagrant VM and check the default grants
> there for user mediator, apply the similar credentials to your system.
>
> Please share your findings. Tnx!
>
> On 08/17/2018 05:30 PM, qabane me wrote:
> > After our upgrade from 2.8 to 3.8 the mediator is not running.
> >
> >  Error connecting to STATS db: Access denied for user
> > 'mediator'@'localhost' (using password: YES)
> >
> > is the reason. Did something change between those versions in that
> > regard? I know 3.8 is eol and we'll upgrade from it but would like to
> > get this going in the meantime.
>
>
> --
> Alex Lutay
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20180820/e59a2aa2/attachment-0001.html>