[Freeswitch-users] CDR XMLs don't get generated sometimes

[Siri MM]

Thanks Steven, it was indeed a problem with my SQL DB which was causing my
application not to work!


On Wed, Aug 13, 2014 at 6:17 PM, Steven Ayre <steveayre at gmail.com> wrote:

> You're seeing the post. That shows the error is within your application.
>
> To avoid any lost CDRs ensure your script returns a 4xx or 5xx error on
> any error. You can configure FS to write these to the err-log-dir so that
> they aren't lost and resubmit them when the error is fixed. Remember you
> should always check the result of mysql_query-type function calls.
>
> If the script returns 200 then FS will assume the CDR submission was
> successful.
>
> Assuming the webserver is apache, check the error_log file, you may see
> output indicating what the problem is.
>
> Since you changed the schema it's almost certainly a SQL error relating to
> the columns (not enough supplied or names changed).
>
> -Steve
>
>
> On 13 August 2014 05:28, Siri MM <sirimmfs at gmail.com> wrote:
>
>> Hi,
>>
>> I am facing an unusual problem off late. My setup is as follows: I use my
>> webserver with SQL DB, and have setup the url in xml_cdr.conf.xml for
>> posting xml cdr information. It works all well in a normal scenario - xml
>> cdrs are generated, and http post onto my url is also called.
>>
>> Now, when I try to add a new column to my database (which is by the way
>> very large), and then restart freeswitch, I see that the cdr xmls are not
>> getting created - http post does occur though. I don't see any CDR related
>> error messages in the freeswitch logs, either during start up, or after a
>> call - any pointers on how I could debug why xml cdrs are not created?
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> 
>> 
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://wiki.freeswitch.org
>> http://www.cluecon.com
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>>
>>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20140814/0ab03ee5/attachment.html