Re: [OpenSIPS-Users] CallControl - CDRTool : MySQL server has goneaway (2006)
Hi, I am having this same problem. Has someone found a solution? Thanks, Alberto - Original Message - From: Adrian Georgescu a...@ag-projects.com To: OpenSIPS users mailling list users@lists.opensips.org Sent: Sunday, October 04, 2009 7:35 AM Subject: Re: [OpenSIPS-Users] CallControl - CDRTool : MySQL server has goneaway (2006) Hi Carlo, I am aware of this problem. To my dispair I could not find what is causing for it. I have already captured both errors 2006 and 2013 at the lowest level possible in PHP code (in phplib/db_mysql.inc) where when such error code is detected a new connection to mysql server is initiated. This problem seems to bypass these checks altogether though if you follow through the code it would be logically impossible. As this happens only on particular systems while on others it does not, I suspect the cause is related to a particular version of mysql C client library or a combination of particular client and server versions. So I am looking for hints myself for how to solve this nasty issue. -- Adrian On Oct 2, 2009, at 10:58 AM, Carlo Dimaggio wrote: Il giorno 24/lug/09, alle ore 15:02, Adrian Georgescu ha scritto: If you lower the mysql connection timeout to a a few minutes you will see in syslog that the software is able to reconnect correctly in case of 2006 or 2013. But I have seen this myself too, randomly it fails and though the error code is intercepted in mysql connection library used by cdrtool (in db_mysql.inc) sometimes it still does not work as expected and could not trace the reason how it can do this. Maybe you can inspect that code add some debugging statements to it and find the culprit. Hi Adrian, I took your mail of last july because I'm experiencing with the same problems. After the mysql timeout (8 hours), cdrtool doesn't reconnect to mysql: Database error for query 'select * from prepaid where account = '1...@sip.xxx.it '': MySQL server has gone away (2006), link_id =Resource id #53, query_id = I think is useful to tell you that I hadn't these problems with an ubuntu 8.04 installation (now I have a lenny 64bit)... There could be something in this last installation (like some parameters in mysql config?) Do you have hints for this? Thanks and regards, Carlo Dimaggio ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.14.3/2412 - Release Date: 10/03/09 18:34:00 ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] CallControl - CDRTool : MySQL server has goneaway (2006)
I have added a wake up call that is executed during normalization process. This way the rating engine mysql connection stays up even if the servers is idle and handles no client requests. It is already in the trunk and will be available in the next release. -- Adrian ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] Restricting caller id
I know that OpenSIPS is not really intended as a feature server but I'm wondering if anyone has found a way to implement some of the simpler features without having to go out to another system like Asterisk or FreeSWITCH. For example, say I just wanted to implement caller id blocking. Normally on a PBX call this might be *67+number for per call blocking. Has anyone done this on OpenSIPS, and if so would you mind sharing your experiences? I know it could be done by writing a custom module or script...but before I go that far I figured I would ask here. After all I don't want to re-invent the wheel :) Thanks -dg ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Restricting caller id
Dan, I use a scripting flag to indicate when a call is supposed to have CID blocking enabled. I have some scripting in the early part of the call processing that looks for factors that indicate blocked caller ID, like values of a Privacy header, part of the RPID header, a *67 prefix on the call, etc. If I find any of those I set the flag. I check for the flag on a branch route on the way out, and if it¹s set, I make sure I apply the proper indications, including obfuscating the From header with uac_replace_from(). By doing that at the end I ensure I don¹t run more than one uac_replace_from() per transaction (which is a no-no). By having it in the branch route I can indicate privacy in different ways depending on where I¹m sending it, in the case of serial/failover forking. Does that make sense? - Jeff On 12/4/09 3:04 PM, Daniel Goepp d...@goepp.net wrote: I know that OpenSIPS is not really intended as a feature server but I'm wondering if anyone has found a way to implement some of the simpler features without having to go out to another system like Asterisk or FreeSWITCH. For example, say I just wanted to implement caller id blocking. Normally on a PBX call this might be *67+number for per call blocking. Has anyone done this on OpenSIPS, and if so would you mind sharing your experiences? I know it could be done by writing a custom module or script...but before I go that far I figured I would ask here. After all I don't want to re-invent the wheel :) Thanks -dg ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] Regular expression problems with replace_body
Hello, i try to use replace_body to modify the RTP port in INVITE and OK messages: from: m=audio 13740 RTP/AVP 8 0 3 101 to: m=audio 666 RTP/AVP 8 0 3 101 with: replace_body(^m=audio \d+, m=audio 666); but ^m=audio \d+ does not match. But the regular expression should be correct. Kristijan ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users