<div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><div>[Unit]</div><div>Description=NGCP Mediator</div><div>After=mariadb.service</div><div>After=redis-server.service</div><div>After=remote-fs.target</div><div>Wants=mariadb.service</div><div>Wants=redis-server.service</div><div><br></div><div>[Service]</div><div>Type=notify</div><div>ExecStart=/usr/bin/mediator</div><div><br></div><div>[Install]</div><div>WantedBy=multi-user.target</div><div>Alias=mediator.service</div></div><div><br></div><div><br></div><div>● ngcp-mediator.service - NGCP Mediator</div><div> Loaded: loaded (/lib/systemd/system/ngcp-mediator.service; enabled; vendor preset: enabled)</div><div> Active: failed (Result: exit-code) since Mon 2019-03-25 09:59:38 PDT; 2min 6s ago</div><div> Process: 1356 ExecStart=/usr/bin/mediator (code=exited, status=255)</div><div><br></div><div><br></div><div><div>Mar 25 09:53:17 spce (warning) mediator[1806]: medmysql.c:1043 [<unknown>]: Skipping duplicate IP '72.15.250.77'<br></div><div>Mar 25 09:53:17 spce (warning) mediator[1806]: medmysql.c:1043 [<unknown>]: Skipping duplicate IP '72.15.250.77'</div><div>Mar 25 09:54:57 spce (warning) mediator[1806]: medmysql.c:1043 [<unknown>]: Skipping duplicate IP '72.15.250.77'</div><div>Mar 25 09:54:57 spce (warning) mediator[1806]: medmysql.c:1043 [<unknown>]: Skipping duplicate IP '72.15.250.77'</div><div>Mar 25 09:56:37 spce (warning) mediator[1806]: medmysql.c:1043 [<unknown>]: Skipping duplicate IP '72.15.250.77'</div><div>Mar 25 09:56:37 spce (warning) mediator[1806]: medmysql.c:1043 [<unknown>]: Skipping duplicate IP '72.15.250.77'</div><div>Mar 25 09:58:17 spce (warning) mediator[1806]: medmysql.c:1043 [<unknown>]: Skipping duplicate IP '72.15.250.77'</div><div>Mar 25 09:58:17 spce (warning) mediator[1806]: medmysql.c:1043 [<unknown>]: Skipping duplicate IP '72.15.250.77'</div><div>Mar 25 09:58:17 spce (crit) mediator[1806]: medmysql.c:579 [<unknown>]: No records found for callid '<a href="mailto:275265300_129868401@55.193.4.151">275265300_129868401@55.193.4.151</a>'!</div><div>Mar 25 09:58:17 spce (info) mediator[1806]: mediator.c:424 [main]: Runtime for loop processing 1 callids and generating 0 CDRs was 3852 us.</div><div>Mar 25 09:58:17 spce (info) mediator[1806]: mediator.c:425 [main]: Total CDR creation rate 0.000000 CDR/sec</div><div>Mar 25 09:58:27 spce (crit) mediator[1806]: medmysql.c:579 [<unknown>]: No records found for callid '<a href="mailto:275265300_129868401@55.193.4.151">275265300_129868401@55.193.4.151</a>'!</div><div>Mar 25 09:58:27 spce (info) mediator[1806]: mediator.c:424 [main]: Runtime for loop processing 1 callids and generating 0 CDRs was 1247 us.</div><div>Mar 25 09:58:27 spce (info) mediator[1806]: mediator.c:425 [main]: Total CDR creation rate 0.000000 CDR/sec</div><div>Mar 25 09:58:37 spce (crit) mediator[1806]: medmysql.c:579 [<unknown>]: No records found for callid '<a href="mailto:275265300_129868401@55.193.4.151">275265300_129868401@55.193.4.151</a>'!</div><div>Mar 25 09:58:37 spce (info) mediator[1806]: mediator.c:424 [main]: Runtime for loop processing 1 callids and generating 1 CDRs was 11627 us.</div><div>Mar 25 09:58:37 spce (info) mediator[1806]: mediator.c:425 [main]: Total CDR creation rate 86.006709 CDR/sec</div><div>Mar 25 09:59:38 spce (notice) mediator[1356]: mediator.c:190 [main]: Starting mediator</div><div>Mar 25 09:59:38 spce (info) mediator[1356]: mediator.c:221 [main]: ACC acc database host='localhost', port='3306', user='kamailio', name='kamailio'</div><div>Mar 25 09:59:38 spce (info) mediator[1356]: mediator.c:223 [main]: CDR acc database host='localhost', port='3306', user='mediator', name='accounting'</div><div>Mar 25 09:59:38 spce (info) mediator[1356]: mediator.c:225 [main]: PROV database host='localhost', port='3306', user='mediator', name='provisioning'</div><div>Mar 25 09:59:38 spce (info) mediator[1356]: mediator.c:227 [main]: STATS database host='localhost', port='3306', user='mediator', name='stats'</div><div>Mar 25 09:59:38 spce (info) mediator[1356]: mediator.c:231 [main]: REDIS database host='localhost', port='6379', pass='<none>', id='21'</div><div>Mar 25 09:59:38 spce (err) mediator[1356]: medredis.c:420 [medredis_init]: Failed to perform redis query 'PING': LOADING Redis is loading the dataset in memory</div></div><div><br></div><div><br></div><div>what do you think the issue is?</div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Mar 25, 2019 at 3:28 AM Alex Lutay <<a href="mailto:alutay@sipwise.com">alutay@sipwise.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
AFAIK mediator has dependency on redis-server.service since<br>
the very beginning (mr6.2+):<br>
<br>
>> ~/git/mediator$ grep redis debian/ngcp-mediator.service <br>
> After=redis-server.service<br>
> Wants=redis-server.service<br>
<br>
I am afraid it is something else. Check /var/log/ngcp/cdr.log on errors.<br>
Also check systemd service status after boot:<br>
<br>
>> systemctl | grep mediator<br>
> ngcp-mediator.service loaded active running NGCP Mediator <br>
>> systemctl status ngcp-mediator<br>
<br>
You can find some hints there about the real origin of your issue.<br>
<br>
Have fun!<br>
<br>
On 3/23/19 9:47 AM, Jon Bonilla (Manwe) wrote:<br>
> El Fri, 22 Mar 2019 18:05:05 -0700<br>
> Andy Clark <<a href="mailto:andyclark05251978@gmail.com" target="_blank">andyclark05251978@gmail.com</a>> escribió:<br>
> <br>
>> ngcp-mediator.service failing on reboot<br>
>> SPCE 6.5.3.1+0~mr6.5.3.1<br>
>> will startup manually without issues<br>
> <br>
> probably it needs redis to start first if you're using acc2redis. <br>
> <br>
> I think it will be solved in 6.5.4<br>
> <br>
>><br>
>> what do you need from me to help solve this?<br>
> <br>
> you can edit systemd startup and add redis dependency<br>
<br>
-- <br>
Alex Lutay<br>
_______________________________________________<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/listinfo/spce-user</a><br>
</blockquote></div>