<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>