CDR XMLs don't get generated sometimes
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?
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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (2)
-
Siri MM
-
Steven Ayre