<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<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" type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<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" type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<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"
type="cite">
<style type="text/css">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 wrap="">_______________________________________________
Spce-user mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">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">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Spce-user mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">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">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Spce-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a>
<a class="moz-txt-link-freetext" href="https://lists.sipwise.com/listinfo/spce-user">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
</body>
</html>