[Spce-user] mediator stops working

[Daniel Grotti]

Hi,
you should check you kamailio.acc (or kamailio.acc_backup) entries with


sip_reason: Unknown Faxserver caller

or

sip_reason: Relaying Denied



Anyway, this issue should be solve in the next package release for mr3.4.2.

Daniel



On 09/18/2014 09:45 PM, Jasper Hagoort wrote:
> hi
>
> i checkt the cdr tabel 
>
>
> mysql> select * from `cdr` where `call_type` like "";
>
> Empty set (0.79 sec)
>
>
>
> Sep 18 21:39:50 sip mediator[20854]: Setting up mysql connections.
>
> Sep 18 21:39:50 sip mediator[20854]: Up and running, daemonized=1,
> pid-path='/var/run/mediator.pid', interval=10
>
> Sep 18 21:39:52 sip mediator[20854]: Error inserting cdrs: Data
> truncated for column 'call_type' at row 1840
>
> Sep 18 21:39:52 sip mediator[20854]: Shutting down.
>
> Sep 18 21:39:52 sip mediator[20854]: Successfully shut down.
>
> Sep 18 21:39:52 sip mediator[20854]: Unlocking mediator.
>
>
> is there some ohter way that i cant find a solution.  
>
>
> ------------------------------------------------------------------------
> *Van: *"Jasper Hagoort" <jhagoort at dside-telecom.nl>
> *Aan: *"Daniel Grotti" <dgrotti at sipwise.com>
> *Verzonden: *Dinsdag 16 september 2014 14:27:27
> *Onderwerp: *Re: [Spce-user] mediator stops working
>
>
> Hi Daniel
>
> there are no records white a emty call_type feild.
> ------------------------------------------------------------------------
> *Van: *"Daniel Grotti" <dgrotti at sipwise.com>
> *Aan: *spce-user at lists.sipwise.com
> *Verzonden: *Dinsdag 16 september 2014 11:19:01
> *Onderwerp: *Re: [Spce-user] mediator stops working
>
> Hi,
> you probably have a cdr with "call_type" empty.
> That should cause the mediator error.
> We are aware of this and we are going to fix this issue.
>
> Daniel
>
>
>
>
>
> On 09/15/2014 04:03 PM, Daniel Grotti wrote:
>
>     Ops,
>     sorry, wrong paste.
>     The type are:
>
>     enum('call','cfu','cft','cfb','cfna')
>
>
>     Daniel
>
>
>
>     On 09/15/2014 04:02 PM, Daniel Grotti wrote:
>
>         Hi,
>         call_type is a column of accounting.cdr table and its value
>         type is :
>
>         enum('ok','busy','noanswer','cancel','offline','timeout','other')
>
>
>         Daniel
>
>
>
>
>         On 09/14/2014 03:25 PM, Jasper Hagoort wrote:
>
>             Hi
>
>             I have a problem over the last few days there are no cdr
>             records being written to the database
>             i found that the mediator stopts on the call type but
>             içant find that table. 
>
>
>             ep 14 15:08:12 sip mediator[3940]: Up and running,
>             daemonized=1, pid-path='/var/run/mediator.pid', interval=10
>             Sep 14 15:08:13 sip mediator[3940]: Error inserting cdrs:
>             Data truncated for column 'call_type' at row 1618
>             Sep 14 15:08:13 sip mediator[3940]: Shutting down.
>             Sep 14 15:08:13 sip mediator[3940]: Successfully shut down.
>             Sep 14 15:08:13 sip mediator[3940]: Unlocking mediator.
>
>             Regards
>
>             jasper
>
>
>             _______________________________________________
>             Spce-user mailing list
>             Spce-user at lists.sipwise.com
>             https://lists.sipwise.com/listinfo/spce-user
>
>
>
>
>         _______________________________________________
>         Spce-user mailing list
>         Spce-user at lists.sipwise.com
>         https://lists.sipwise.com/listinfo/spce-user
>
>
>
>
>     _______________________________________________
>     Spce-user mailing list
>     Spce-user at lists.sipwise.com
>     https://lists.sipwise.com/listinfo/spce-user
>
>
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20140919/90bd1b3f/attachment-0001.html>