Hi,<div><br></div><div> So I did another reboot and now see sems is failing due to mysql connection. Could sems be starting up before mysql?</div><div><br></div><div>Here is what I'm seeing:</div><div><br></div><div><div>
root@dev3:~# /etc/init.d/sems status</div><div>sems is not running ... failed!</div><div>root@dev3:~# tail /var/log/ngcp/sems.log </div><div>Feb 20 19:13:48 dev3 sems[861]: [#7f44d45c7720] [dump_Ifs, AmConfig.cpp:812] INFO: #011LocalSIPPort=5080</div>
<div>Feb 20 19:13:48 dev3 sems[861]: [#7f44d45c7720] [dump_Ifs, AmConfig.cpp:813] INFO: #011RtpLowPort=40001</div><div>Feb 20 19:13:48 dev3 sems[861]: [#7f44d45c7720] [dump_Ifs, AmConfig.cpp:814] INFO: #011RtpHighPort=50000</div>
<div>Feb 20 19:13:48 dev3 sems[861]: [#7f44d45c7720] [dump_Ifs, AmConfig.cpp:817] INFO: Signaling address map:</div><div>Feb 20 19:13:48 dev3 sems[861]: [#7f44d45c7720] [dump_Ifs, AmConfig.cpp:822] INFO: #011127.0.0.1 -> default</div>
<div>Feb 20 19:13:48 dev3 sems[886]: [#7f44d45c7720] [main, sems.cpp:463] INFO: Loading plug-ins</div><div>Feb 20 19:13:48 dev3 sems[886]: [#7f44d45c7720] [load, AmPlugIn.cpp:216] INFO: AmPlugIn: loading modules: 'wav;gsm;xmlrpc2di;di_dial;stats;uac_auth;session_timer;click2dial;sw_vsc;conference;sbc;registrar_client;reg_agent;db_reg_agent'</div>
<div>Feb 20 19:13:48 dev3 sems[886]: [#7f44d45c7720] [onLoad, DBRegAgent.cpp:203] ERROR: MySQL++ error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)</div><div>Feb 20 19:13:48 dev3 sems[886]: [#7f44d45c7720] [main, sems.cpp:509] INFO: Disposing plug-ins</div>
<div>Feb 20 19:13:48 dev3 sems[886]: [#7f44d45c7720] [main, sems.cpp:520] INFO: Exiting (failure)</div><div>root@dev3:~# /etc/init.d/mysql status</div><div>/usr/bin/mysqladmin Ver 8.42 Distrib 5.1.60, for debian-linux-gnu on x86_64</div>
<div>Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.</div><div><br></div><div>Oracle is a registered trademark of Oracle Corporation and/or its</div><div>affiliates. Other names may be trademarks of their respective</div>
<div>owners.</div><div><br></div><div>Server version<span class="Apple-tab-span" style="white-space:pre"> </span>5.1.60-rel13.1-log</div><div>Protocol version<span class="Apple-tab-span" style="white-space:pre"> </span>10</div>
<div>Connection<span class="Apple-tab-span" style="white-space:pre"> </span>Localhost via UNIX socket</div><div>UNIX socket<span class="Apple-tab-span" style="white-space:pre"> </span>/var/run/mysqld/mysqld.sock</div><div>
Uptime:<span class="Apple-tab-span" style="white-space:pre"> </span>1 min 38 sec</div><div><br></div><div>Threads: 4 Questions: 337 Slow queries: 0 Opens: 600 Flush tables: 1 Open tables: 149 Queries per second avg: 3.438.</div>
</div><div><br></div><div>--skyler</div><div><br><div class="gmail_quote">On Mon, Feb 20, 2012 at 10:06 AM, Skyler <span dir="ltr"><<a href="mailto:skchopperguy@gmail.com">skchopperguy@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Andrew,<div><br></div><div><div class="gmail_quote"><div class="im">On Mon, Feb 20, 2012 at 9:11 AM, Andrew Pogrebennyk <span dir="ltr"><<a href="mailto:apogrebennyk@sipwise.com" target="_blank">apogrebennyk@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 Skyler,<br>
maybe others will correct me, but the destination is only normalized in<br>
the csc panel's CDR list. If you go to csc you should really see<br>
"Voicebox", at least that's what it looks like for me. We do not have<br>
normalization in the admin panel.<br>
<br></blockquote></div>Yes, in csc this is normalized. Actually, now that I think about it the admin panel should NOT be normalized for quick debug reasons. Makes sense.<div class="im"><br><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
As for the issue with missing CDRs please check /var/log/ngcp/cdr.log<br>
(mediator) and /var/log/ngcp/rate-o-mat.log (rate-o-mat).<br></blockquote><div><br></div></div><div> Ok, will look there when this occurs again. Thanks.</div><div class="im"><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
And I don't have a problem with sems start on boot in version 2.4, could<br>
you please show me the output from ls -l /etc/rc2.d?<br>
<div><div><br></div></div></blockquote><div><br></div></div><div> It appears to be in startup sequence but when trying to make a call after reboot no calls connect. When I do /etc/init.d/sems status after a reboot it shows 'failed'. No errors in /var/log/ngcp/sems.log to indicate a problem. I'll just keep this in mind as a first check after any reboots.</div>
<div> </div><div>root@dev3:~# ls -l /etc/rc2.d</div><div>total 4</div><div>-rw-r--r-- 1 root root 677 Jan 1 2011 README</div><div>lrwxrwxrwx 1 root root 20 Feb 1 11:40 S01fancontrol -> ../init.d/fancontrol</div><div>
lrwxrwxrwx 1 root root 17 Feb 1 11:40 S01rsyslog -> ../init.d/rsyslog</div><div>lrwxrwxrwx 1 root root 14 Feb 1 12:18 S01sudo -> ../init.d/sudo</div><div>lrwxrwxrwx 1 root root 17 Feb 2 10:05 S02apache2 -> ../init.d/apache2</div>
<div>lrwxrwxrwx 1 root root 15 Feb 2 10:05 S03acpid -> ../init.d/acpid</div><div>lrwxrwxrwx 1 root root 18 Feb 2 10:05 S03collectd -> ../init.d/collectd</div><div>lrwxrwxrwx 1 root root 14 Feb 2 10:05 S03cron -> ../init.d/cron</div>
<div>lrwxrwxrwx 1 root root 20 Feb 2 10:06 S03irqbalance -> ../init.d/irqbalance</div><div>lrwxrwxrwx 1 root root 21 Feb 2 10:06 S03kamailio-lb -> ../init.d/kamailio-lb</div><div>lrwxrwxrwx 1 root root 15 Feb 2 10:05 S03mysql -> ../init.d/mysql</div>
<div>lrwxrwxrwx 1 root root 35 Feb 2 10:05 S03ngcp-mediaproxy-ng-daemon -> ../init.d/ngcp-mediaproxy-ng-daemon</div><div>lrwxrwxrwx 1 root root 25 Feb 2 10:06 S03ngcp-rate-o-mat -> ../init.d/ngcp-rate-o-mat</div>
<div>lrwxrwxrwx 1 root root 13 Feb 2 10:05 S03ntp -> ../init.d/ntp</div><div>lrwxrwxrwx 1 root root 15 Feb 2 10:06 S03rsync -> ../init.d/rsync</div><div>lrwxrwxrwx 1 root root 14 Feb 2 10:06 S03sems -> ../init.d/sems</div>
<div>lrwxrwxrwx 1 root root 15 Feb 2 10:05 S03snmpd -> ../init.d/snmpd</div><div>lrwxrwxrwx 1 root root 13 Feb 2 10:05 S03ssh -> ../init.d/ssh</div><div>lrwxrwxrwx 1 root root 17 Feb 2 10:06 S03sysstat -> ../init.d/sysstat</div>
<div>lrwxrwxrwx 1 root root 18 Feb 2 10:06 S04asterisk -> ../init.d/asterisk</div><div>lrwxrwxrwx 1 root root 15 Feb 2 10:05 S04exim4 -> ../init.d/exim4</div><div>lrwxrwxrwx 1 root root 18 Feb 2 10:05 S04kamailio -> ../init.d/kamailio</div>
<div>lrwxrwxrwx 1 root root 24 Feb 2 10:06 S04kamailio-proxy -> ../init.d/kamailio-proxy</div><div>lrwxrwxrwx 1 root root 18 Feb 2 10:06 S04mediator -> ../init.d/mediator</div><div>lrwxrwxrwx 1 root root 18 Feb 2 10:05 S05bootlogs -> ../init.d/bootlogs</div>
<div>lrwxrwxrwx 1 root root 18 Feb 2 10:05 S06rc.local -> ../init.d/rc.local</div><div>lrwxrwxrwx 1 root root 19 Feb 2 10:05 S06rmnologin -> ../init.d/rmnologin</div><div>lrwxrwxrwx 1 root root 23 Feb 2 10:05 S06stop-bootlogd -> ../init.d/stop-bootlogd</div>
<div><br></div><div> </div><div>Thanks!</div><div class="im"><div><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>
On 02/19/2012 11:02 PM, Skyler wrote:<br>
> Hi,<br>
><br>
> When I look at Call Data for a subscriber from within the admin panel,<br>
> I see calls to voicemail showing like "abc17778884545@voicebox.local" or<br>
> "vmu17778884545@voicebox.local". I'm sure that back in 2.2 all calls<br>
> used to show like "voicebox" or "voicemail".<br>
><br>
> How would I change this so calls to voicebox show "voicebox" in the<br>
> Call Data display? I don't mind hacking around if you can point me in<br>
> the direction ;)<br>
><br>
> I've also noticed that CDR's sometimes don't display at all until<br>
> server is rebooted. Which service is responsible for this so I can<br>
> monitor it? doesn't affect calls so I haven't noticed before today.<br>
> Also, I have to manually start SEMS after reboots it<br>
> seems. /var/log/ngcp/sems.log is empty so I have no idea what might be<br>
> the problem there.<br>
><br>
> - Skyler<br>
</div></div></blockquote></div></div><br></div>
</blockquote></div><br></div>