<div dir="ltr"><div>Hi</div><div><br></div><div>I reckon I have found the issue. /etc/init.d/mediator is incomplete for some obscure reason. Note the stats portion is missing. there is a mediator.dpkg.dist present which looks to be the correct new one. I have compared that one to a test install of 3.8.13 and it's identical. I will replace the file after hours just for safety's sake and check but that seems to be the mystery?<br></div><div><br></div><div>[ -z "$PIDFILE" ] || OPTIONS="$OPTIONS -D $PIDFILE"<br>[ -z "$INTERVAL" ] || OPTIONS="$OPTIONS -i $INTERVAL"<br>[ -z "$SOURCE_HOST" ] || OPTIONS="$OPTIONS -h $SOURCE_HOST"<br>[ -z "$SOURCE_PORT" ] || OPTIONS="$OPTIONS -o $SOURCE_PORT"<br>[ -z "$SOURCE_USER" ] || OPTIONS="$OPTIONS -u $SOURCE_USER"<br>[ -z "$SOURCE_PASS" ] || OPTIONS="$OPTIONS -p $SOURCE_PASS"<br>[ -z "$SOURCE_DB" ] || OPTIONS="$OPTIONS -b $SOURCE_DB"<br>[ -z "$DEST_HOST" ] || OPTIONS="$OPTIONS -H $DEST_HOST"<br>[ -z "$DEST_PORT" ] || OPTIONS="$OPTIONS -O $DEST_PORT"<br>[ -z "$DEST_USER" ] || OPTIONS="$OPTIONS -U $DEST_USER"<br>[ -z "$DEST_PASS" ] || OPTIONS="$OPTIONS -P $DEST_PASS"<br>[ -z "$DEST_DB" ] || OPTIONS="$OPTIONS -B $DEST_DB"<br>[ -z "$PROV_HOST" ] || OPTIONS="$OPTIONS -S $PROV_HOST"<br>[ -z "$PROV_PORT" ] || OPTIONS="$OPTIONS -T $PROV_PORT"<br>[ -z "$PROV_USER" ] || OPTIONS="$OPTIONS -R $PROV_USER"<br>[ -z "$PROV_PASS" ] || OPTIONS="$OPTIONS -A $PROV_PASS"<br>[ -z "$PROV_DB" ] || OPTIONS="$OPTIONS -N $PROV_DB"<br>if test "$FORK" = "yes" ; then<br> OPTIONS="$OPTIONS -d"<br></div><div><br></div><div>This part is just not present:</div><div><br></div><div>[ -z "$STATS_HOST" ] || OPTIONS="$OPTIONS -Z $STATS_HOST"<br>[ -z "$STATS_PORT" ] || OPTIONS="$OPTIONS -z $STATS_PORT"<br>[ -z "$STATS_USER" ] || OPTIONS="$OPTIONS -W $STATS_USER"<br>[ -z "$STATS_PASS" ] || OPTIONS="$OPTIONS -w $STATS_PASS"<br>[ -z "$STATS_DB" ] || OPTIONS="$OPTIONS -X $STATS_DB"<br>[ -z "$STATS_PERIOD" ] || OPTIONS="$OPTIONS -x $STATS_PERIOD"<br><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Aug 21, 2018 at 11:15 AM, qabane me <span dir="ltr"><<a href="mailto:qabaneitsolutions@gmail.com" target="_blank">qabaneitsolutions@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>/Hi</div><div><br></div><div>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!<br></div><div><br></div><div><br>RUN_MEDIATOR="yes"<br><br>PIDFILE="/var/run/mediator.<wbr>pid"<br>FORK="yes"<br>INTERVAL="10"<br>SOURCE_HOST="localhost"<br>SOURCE_PORT="3306"<br>SOURCE_USER="kamailio"<br>SOURCE_PASS='<wbr>fmepWPtkisz7WvvoEouR'<br>SOURCE_DB="kamailio"<br>DEST_HOST="localhost"<br>DEST_PORT="3306"<br>DEST_USER="mediator"<br>DEST_PASS='<wbr>wFTN34Xnoeyzae3yEzyv'<br>DEST_DB="accounting"<br>PROV_HOST="localhost"<br>PROV_PORT="3306"<br>PROV_USER="mediator"<br>PROV_PASS='<wbr>wFTN34Xnoeyzae3yEzyv'<br>PROV_DB="provisioning"<br>STATS_DB="stats"<br>STATS_HOST="localhost"<br>STATS_PORT="3306"<br>STATS_USER="mediator"<br>STATS_PASS="<wbr>wFTN34Xnoeyzae3yEzyv"<br>STATS_PERIOD="1"<br><br><br></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Aug 21, 2018 at 10:54 AM, Alex Lutay <span dir="ltr"><<a href="mailto:alutay@sipwise.com" target="_blank">alutay@sipwise.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
Correct. The default MySQL port is 3306.<br>
<br>
You can check mediator config to find the option with port 0:<br>
> grep port /etc/ngcp-mediator/ngcp-mediat<wbr>or.conf<br>
<br>
later you can check ngcpcfg to find which YML options is missing for you<br>
> /etc/ngcp-config/templates/etc<wbr>/ngcp-mediator/ngcp-mediator.<wbr>conf.tt2<br>
Also ensure you have no customtt file there.<br>
<br>
Ensure your YML file has all the necessary values.<br>
<br>
BTW, modern releases have ability to validate your YML config:<br>
> ngcpcfg --validate check<br>
<br>
Have fun!<br>
<span class="m_-9107264012428849214im m_-9107264012428849214HOEnZb"><br>
On 08/20/2018 08:34 PM, qabane me wrote:<br>
> Ok the grants are ok seemingly but the port is wrong:<br>
> <br>
> Aug 20 20:16:10 sipwise mediator[20666]: STATS database<br>
> host='localhost', port='0', user='mediator', name='stats'<br>
> <br>
> that should be port 3306 surely?<br>
> <br>
> I have checked the constants.yml file which only has references to port<br>
> 3306 as far as I can see?<br>
</span><div class="m_-9107264012428849214HOEnZb"><div class="m_-9107264012428849214h5">-- <br>
Alex Lutay<br>
______________________________<wbr>_________________<br>
Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
<a href="https://lists.sipwise.com/listinfo/spce-user" rel="noreferrer" target="_blank">https://lists.sipwise.com/list<wbr>info/spce-user</a><br>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>