[Spce-user] Mediator not starting after upgrade

[qabane me]

/Hi

I had found the file in the meantime, in this case /etc/default/mediator I
think? The contents look fine. The mediator.tt2 file also looks correct as
far as I can see. And yes :-) I am having fun!


RUN_MEDIATOR="yes"

PIDFILE="/var/run/mediator.pid"
FORK="yes"
INTERVAL="10"
SOURCE_HOST="localhost"
SOURCE_PORT="3306"
SOURCE_USER="kamailio"
SOURCE_PASS='fmepWPtkisz7WvvoEouR'
SOURCE_DB="kamailio"
DEST_HOST="localhost"
DEST_PORT="3306"
DEST_USER="mediator"
DEST_PASS='wFTN34Xnoeyzae3yEzyv'
DEST_DB="accounting"
PROV_HOST="localhost"
PROV_PORT="3306"
PROV_USER="mediator"
PROV_PASS='wFTN34Xnoeyzae3yEzyv'
PROV_DB="provisioning"
STATS_DB="stats"
STATS_HOST="localhost"
STATS_PORT="3306"
STATS_USER="mediator"
STATS_PASS="wFTN34Xnoeyzae3yEzyv"
STATS_PERIOD="1"



On Tue, Aug 21, 2018 at 10:54 AM, Alex Lutay <alutay at sipwise.com> wrote:

> Hi,
>
> Correct. The default MySQL port is 3306.
>
> You can check mediator config to find the option with port 0:
> > grep port /etc/ngcp-mediator/ngcp-mediator.conf
>
> later you can check ngcpcfg to find which YML options is missing for you
> > /etc/ngcp-config/templates/etc/ngcp-mediator/ngcp-mediator.conf.tt2
> Also ensure you have no customtt file there.
>
> Ensure your YML file has all the necessary values.
>
> BTW, modern releases have ability to validate your YML config:
> > ngcpcfg --validate check
>
> Have fun!
>
> On 08/20/2018 08:34 PM, qabane me wrote:
> > Ok the grants are ok seemingly but the port is wrong:
> >
> > Aug 20 20:16:10 sipwise mediator[20666]: STATS database
> > host='localhost', port='0', user='mediator', name='stats'
> >
> > that should be port 3306 surely?
> >
> > I have checked the constants.yml file which only has references to port
> > 3306 as far as I can see?
> --
> 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/20180821/d985865e/attachment-0001.html>