<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi,<br>
you should check you kamailio.acc (or kamailio.acc_backup) entries
with<br>
<br>
<br>
sip_reason: Unknown Faxserver caller<br>
<br>
or<br>
<br>
sip_reason: Relaying Denied<br>
<br>
<br>
<br>
Anyway, this issue should be solve in the next package release for
mr3.4.2.<br>
<br>
Daniel<br>
<br>
<br>
<br>
On 09/18/2014 09:45 PM, Jasper Hagoort wrote:<br>
</div>
<blockquote
cite="mid:1663661673.485849.1411069523648.JavaMail.root@dside-telecom.nl"
type="cite">
<style type="text/css">p { margin: 0; }</style>
<div style="font-family: arial,helvetica,sans-serif; font-size:
12pt; color: #000000">
<div>hi</div>
<div><br>
</div>
i checkt the cdr tabel <br>
<div>
<p><br>
</p>
<p>mysql> select * from `cdr` where `call_type` like "";</p>
<p>Empty set (0.79 sec)</p>
<p><br>
</p>
<p><br>
</p>
<p>Sep 18 21:39:50 sip mediator[20854]: Setting up mysql
connections.</p>
<p>Sep 18 21:39:50 sip mediator[20854]: Up and running,
daemonized=1, pid-path='/var/run/mediator.pid', interval=10</p>
<p>Sep 18 21:39:52 sip mediator[20854]: Error inserting cdrs:
Data truncated for column 'call_type' at row 1840</p>
<p>Sep 18 21:39:52 sip mediator[20854]: Shutting down.</p>
<p>Sep 18 21:39:52 sip mediator[20854]: Successfully shut
down.</p>
<p>Sep 18 21:39:52 sip mediator[20854]: Unlocking mediator.</p>
<div><br>
</div>
<div>is there some ohter way that i cant find a solution. </div>
<p style="color: rgb(0, 0, 0); font-family: 'Times New Roman';
font-size: 12pt;"><br>
</p>
</div>
<hr id="zwchr" style="color: rgb(0, 0, 0); font-family: arial,
helvetica, sans-serif; font-size: 12pt;">
<div style="color: rgb(0, 0, 0); font-family: Helvetica, Arial,
sans-serif; font-size: 12pt; font-weight: normal; font-style:
normal; text-decoration: none;"><b>Van: </b>"Jasper Hagoort"
<a class="moz-txt-link-rfc2396E" href="mailto:jhagoort@dside-telecom.nl"><jhagoort@dside-telecom.nl></a><br>
<b>Aan: </b>"Daniel Grotti" <a class="moz-txt-link-rfc2396E" href="mailto:dgrotti@sipwise.com"><dgrotti@sipwise.com></a><br>
<b>Verzonden: </b>Dinsdag 16 september 2014 14:27:27<br>
<b>Onderwerp: </b>Re: [Spce-user] mediator stops working<br>
<br>
<style>p { margin: 0; }</style>
<div style="font-family: arial,helvetica,sans-serif;
font-size: 12pt; color: #000000"><br>
<div>Hi Daniel</div>
<div id="6a573f10-4d13-4b16-9d0d-72ad66616da5"><br>
</div>
<div id="6a573f10-4d13-4b16-9d0d-72ad66616da5">there are no
records white a emty call_type feild.</div>
<hr id="zwchr">
<div
style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>Van:
</b>"Daniel Grotti" <a class="moz-txt-link-rfc2396E" href="mailto:dgrotti@sipwise.com"><dgrotti@sipwise.com></a><br>
<b>Aan: </b><a class="moz-txt-link-abbreviated" href="mailto:spce-user@lists.sipwise.com">spce-user@lists.sipwise.com</a><br>
<b>Verzonden: </b>Dinsdag 16 september 2014 11:19:01<br>
<b>Onderwerp: </b>Re: [Spce-user] mediator stops working<br>
<br>
<div class="moz-cite-prefix">Hi,<br>
you probably have a cdr with "call_type" empty.<br>
That should cause the mediator error.<br>
We are aware of this and we are going to fix this issue.<br>
<br>
Daniel<br>
<br>
<br>
<br>
<br>
<br>
On 09/15/2014 04:03 PM, Daniel Grotti wrote:<br>
</div>
<blockquote cite="mid:5416F1BA.3030409@sipwise.com">
<div class="moz-cite-prefix">Ops,<br>
sorry, wrong paste.<br>
The type are:<br>
<br>
enum('call','cfu','cft','cfb','cfna')<br>
<br>
<br>
Daniel<br>
<br>
<br>
<br>
On 09/15/2014 04:02 PM, Daniel Grotti wrote:<br>
</div>
<blockquote cite="mid:5416F179.9040801@sipwise.com">
<div class="moz-cite-prefix">Hi,<br>
call_type is a column of accounting.cdr table and
its value type is :<br>
<br>
enum('ok','busy','noanswer','cancel','offline','timeout','other')<br>
<br>
<br>
Daniel<br>
<br>
<br>
<br>
<br>
On 09/14/2014 03:25 PM, Jasper Hagoort wrote:<br>
</div>
<blockquote
cite="mid:28416364.2299.1410701146562.JavaMail.jhagoort@w1">
<style>p { margin: 0; }</style>
<div style="font-family: arial,helvetica,sans-serif;
font-size: 10pt; color: #000000">Hi<br>
<br>
I have a problem over the last few days there are
no cdr records being written to the database <br>
i found that the mediator stopts on the call type
but içant find that table. <br>
<br>
<br>
<div>ep 14 15:08:12 sip mediator[3940]: Up and
running, daemonized=1,
pid-path='/var/run/mediator.pid', interval=10<br>
Sep 14 15:08:13 sip mediator[3940]: Error
inserting cdrs: Data truncated for column
'call_type' at row 1618<br>
Sep 14 15:08:13 sip mediator[3940]: Shutting
down.<br>
Sep 14 15:08:13 sip mediator[3940]: Successfully
shut down.<br>
Sep 14 15:08:13 sip mediator[3940]: Unlocking
mediator.<br>
<br>
Regards<br>
<br>
jasper<br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
Spce-user mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
Spce-user mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
Spce-user mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
<br>
_______________________________________________<br>
Spce-user mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a><br>
<a class="moz-txt-link-freetext" href="https://lists.sipwise.com/listinfo/spce-user">https://lists.sipwise.com/listinfo/spce-user</a><br>
</div>
<br>
</div>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>