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] Opensips AAA / Radius Question
Hi, I am having difficulty setting up acc with radiusclient-ng and a freeradius server to use CDRTool. Opensips sends 3 records: 1 Start, 1 CallStart and 1 CallStop, the same that it does with DB backend. The problem is that Radius doesn't accept the last 2 because it only expects one record per Session-Id. So in the Opensips I get: Nov 21 12:32:37 x4 /sbin/opensips[3931]: rc_send_server: no reply from RADIUS server :1813 Nov 21 12:32:37 x4 /sbin/opensips[3931]: ERROR:acc:acc_aaa_request: Radius accounting request failed for status: 'Start' Call-Id: 'ZDVjNmFiZjU5NzA3MWQ4N2E3MWI2MjhiYmE1NmY1N2M.' Nov 21 12:33:38 x4 /sbin/opensips[3932]: rc_send_server: no reply from RADIUS server :1813 Nov 21 12:33:38 x4 /sbin/opensips[3932]: ERROR:acc:acc_aaa_request: Radius accounting request failed for status: 'Stop' Call-Id: 'ZDVjNmFiZjU5NzA3MWQ4N2E3MWI2MjhiYmE1NmY1N2M.' Nov 21 12:33:38 x4 media-dispatcher[1243]: error: failed to send radius accounting record: And in the FreeRadius I get: Sat Nov 21 12:32:17 2009 : Error: rlm_sql (sql): Couldn't insert SQL accounting START record - Duplicate entry 'ZDVjNmFiZjU5NzA3MWQ4N2E3MWI2MjhiYmE1NmY1N2M.-as2080e7aa-f5066f05' for key 'sess_ id' Sat Nov 21 12:32:17 2009 : Error: rlm_sql_mysql: Cannot store result Sat Nov 21 12:32:17 2009 : Error: rlm_sql_mysql: MySQL error 'Duplicate entry 'ZDVjNmFiZjU5NzA3MWQ4N2E3MWI2MjhiYmE1NmY1N2M.-as2080e7aa-f5066f05' for key 'sess_id'' Sat Nov 21 12:32:27 2009 : Error: rlm_sql (sql): Couldn't insert SQL accounting START record - Duplicate entry 'ZDVjNmFiZjU5NzA3MWQ4N2E3MWI2MjhiYmE1NmY1N2M.-as2080e7aa-f5066f05' for key 'sess_id' Sat Nov 21 12:32:27 2009 : Error: rlm_sql_mysql: Cannot store result Sat Nov 21 12:32:27 2009 : Error: rlm_sql_mysql: MySQL error 'Duplicate entry 'ZDVjNmFiZjU5NzA3MWQ4N2E3MWI2MjhiYmE1NmY1N2M.-as2080e7aa-f5066f05' for key 'sess_id'' Am I doing something wrong or is this the right behavior? Thanks, Alberto ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] (Solved) Opensips AAA / Radius Question
Hi, Configuration in the proxy in Freeradius was causing multiple instances of radius in the server. The first one accepted the message but the other returned the message to radiusclient-ng so it looked as if rasdiusclient-ng was actually sending several messages went it was only sending one message but getting multiple replies. Just to document in case someone does this by mistake. Thanks, Alberto - Original Message - From: Alberto Listas To: users Sent: Saturday, November 21, 2009 11:21 AM Subject: [OpenSIPS-Users] Opensips AAA / Radius Question Hi, I am having difficulty setting up acc with radiusclient-ng and a freeradius server to use CDRTool. Opensips sends 3 records: 1 Start, 1 CallStart and 1 CallStop, the same that it does with DB backend. The problem is that Radius doesn't accept the last 2 because it only expects one record per Session-Id. So in the Opensips I get: Nov 21 12:32:37 x4 /sbin/opensips[3931]: rc_send_server: no reply from RADIUS server :1813 Nov 21 12:32:37 x4 /sbin/opensips[3931]: ERROR:acc:acc_aaa_request: Radius accounting request failed for status: 'Start' Call-Id: 'ZDVjNmFiZjU5NzA3MWQ4N2E3MWI2MjhiYmE1NmY1N2M.' Nov 21 12:33:38 x4 /sbin/opensips[3932]: rc_send_server: no reply from RADIUS server :1813 Nov 21 12:33:38 x4 /sbin/opensips[3932]: ERROR:acc:acc_aaa_request: Radius accounting request failed for status: 'Stop' Call-Id: 'ZDVjNmFiZjU5NzA3MWQ4N2E3MWI2MjhiYmE1NmY1N2M.' Nov 21 12:33:38 x4 media-dispatcher[1243]: error: failed to send radius accounting record: And in the FreeRadius I get: Sat Nov 21 12:32:17 2009 : Error: rlm_sql (sql): Couldn't insert SQL accounting START record - Duplicate entry 'ZDVjNmFiZjU5NzA3MWQ4N2E3MWI2MjhiYmE1NmY1N2M.-as2080e7aa-f5066f05' for key 'sess_ id' Sat Nov 21 12:32:17 2009 : Error: rlm_sql_mysql: Cannot store result Sat Nov 21 12:32:17 2009 : Error: rlm_sql_mysql: MySQL error 'Duplicate entry 'ZDVjNmFiZjU5NzA3MWQ4N2E3MWI2MjhiYmE1NmY1N2M.-as2080e7aa-f5066f05' for key 'sess_id'' Sat Nov 21 12:32:27 2009 : Error: rlm_sql (sql): Couldn't insert SQL accounting START record - Duplicate entry 'ZDVjNmFiZjU5NzA3MWQ4N2E3MWI2MjhiYmE1NmY1N2M.-as2080e7aa-f5066f05' for key 'sess_id' Sat Nov 21 12:32:27 2009 : Error: rlm_sql_mysql: Cannot store result Sat Nov 21 12:32:27 2009 : Error: rlm_sql_mysql: MySQL error 'Duplicate entry 'ZDVjNmFiZjU5NzA3MWQ4N2E3MWI2MjhiYmE1NmY1N2M.-as2080e7aa-f5066f05' for key 'sess_id'' Am I doing something wrong or is this the right behavior? Thanks, Alberto -- ___ 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
Re: [OpenSIPS-Users] CDRTool/Radius Problem
Hi Laszlo, It was a problem with the dictionaries! Thanks for the suggestion. I also fixed an error in the config for the new aaa_radius, and now I get the records in the Radius/CDRTool . But a strange thing happens when I look at the radius.log I get between 3 and 100 times these repeated messages: Fri Nov 20 18:14:31 2009 : Error: rlm_sql_mysql: MySQL error 'Duplicate entry 'NWFiYTY4NWVmYWZlNjc4OTYyNWMxZWMwZWZlZjIwYWI.-7f47744f-as27abee74' for key$ Fri Nov 20 18:14:31 2009 : Error: rlm_sql (sql): Couldn't insert SQL accounting START record - Duplicate entry 'NWFiYTY4NWVmYWZlNjc4OTYyNWMxZWMwZWZlZjIw$ Fri Nov 20 18:14:31 2009 : Error: rlm_sql_mysql: Cannot store result And this increments the KBIn and KBOut in CDRTool It looks like the radiusclient-ng is sending the same record more than 100 times !!! I am going to post this as another issue. Thanks, Alberto - Original Message - From: Laszlo To: OpenSIPS users mailling list Sent: Thursday, November 19, 2009 7:19 PM Subject: Re: [OpenSIPS-Users] CDRTool/Radius Problem Hi Alberto, 2009/11/19 Alberto Listas lis...@b2br.net Hi, I am installing Opensips v 1.6.0, MediaProxy v 2.3.9 and CDRTool v 6.9.9 on a test system. When a call finishes I get an error in the Opensips log: Nov 19 20:37:58 os4 media-dispatcher[9116]: error: failed to send radius accounting record: 'Sip-From-Tag' And Nothing gets added to the CDRTool or Radius Database. In the old versions I got error from /sbin/opensips when radius had trouble not from media-dispatcher. I know Radius is working because I can telnet in to the radius server. I get no errors in the CDRTool/Radius Server log. Does anyone have a suggestion? Thanks, Alberto Looks like a problem with the radius dictionaries. -Laszlo -- ___ 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
[OpenSIPS-Users] Radius repeats the record to CDRTool/Radius
Hi All, When I make a call opensips sends the radius info to freeradius without any indication of error. But a strange thing happens, when I look at the radius.log in the freeradius server I get between 2 and 100 times these repeated messages: Fri Nov 20 18:14:31 2009 : Error: rlm_sql_mysql: MySQL error 'Duplicate entry 'NWFiYTY4NWVmYWZlNjc4OTYyNWMxZWMwZWZlZjIwYWI.-7f47744f-as27abee74' for key$ Fri Nov 20 18:14:31 2009 : Error: rlm_sql (sql): Couldn't insert SQL accounting START record - Duplicate entry 'NWFiYTY4NWVmYWZlNjc4OTYyNWMxZWMwZWZlZjIw$ Fri Nov 20 18:14:31 2009 : Error: rlm_sql_mysql: Cannot store result And this increments the KBIn and KBOut in CDRTool It looks like the radiusclient-ng is sending the same record sometimes more than 100 times !!! Does anyone have a suggestion? Thanks, Alberto___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] CDRTool/Radius Problem
Hi, I am installing Opensips v 1.6.0, MediaProxy v 2.3.9 and CDRTool v 6.9.9 on a test system. When a call finishes I get an error in the Opensips log: Nov 19 20:37:58 os4 media-dispatcher[9116]: error: failed to send radius accounting record: 'Sip-From-Tag' And Nothing gets added to the CDRTool or Radius Database. In the old versions I got error from /sbin/opensips when radius had trouble not from media-dispatcher. I know Radius is working because I can telnet in to the radius server. I get no errors in the CDRTool/Radius Server log. Does anyone have a suggestion? Thanks, Alberto___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] BYE does not work / Opensips stops working
Hello, I am installing the new 1.6 and getting a strange behavior. When the call ended on one side the other side does not get disconnected, and the log shows: Nov 10 18:40:38 en4 /sbin/opensips[20610]: WARNING:dialog:dlg_onroute: unable to find dialog for BYE with route param 'a94.cd4c751' Nov 10 18:40:39 en4 /sbin/opensips[20609]: WARNING:dialog:dlg_onroute: unable to find dialog for BYE with route param 'a94.cd4c751' Nov 10 18:40:41 en4 /sbin/opensips[20611]: WARNING:dialog:dlg_onroute: unable to find dialog for BYE with route param 'a94.cd4c751' Nov 10 18:40:45 en4 /sbin/opensips[20609]: WARNING:dialog:dlg_onroute: unable to find dialog for BYE with route param 'a94.cd4c751' I did a ngrep and the SIP Route: shows the correct param. Eventually the Opensips starts not to accept INVITEs or creates a very long setup time for INVITEs (20-40s). I think I am doing something wrong, could someone please check my config below. Thanks, Alberto ### Global Parameters # debug=3 log_stderror=no log_facility=LOG_LOCAL0 fork=yes children=4 /* uncomment the following lines to enable debugging */ #debug=6 #log_stderror=yes /* uncomment the next line to disable TCP (default on) */ #disable_tcp=yes /* uncomment the next line to enable the auto temporary blacklisting of not available destinations (default disabled) */ #disable_dns_blacklist=no /* uncomment the next line to enable IPv6 lookup after IPv4 dns lookup failures (default disabled) */ #dns_try_ipv6=yes /* uncomment the next line to disable the auto discovery of local aliases based on revers DNS on IPs (default on) */ #auto_aliases=no /* uncomment the following lines to enable TLS support (default off) */ #disable_tls = no #listen = tls:your_IP:5061 #tls_verify_server = 1 #tls_verify_client = 1 #tls_require_client_certificate = 0 #tls_method = TLSv1 #tls_certificate = /usr/local/etc/opensips/tls/user/user-cert.pem #tls_private_key = /usr/local/etc/opensips/tls/user/user-privkey.pem #tls_ca_list = /usr/local/etc/opensips/tls/user/user-calist.pem port=5060 /* uncomment and configure the following line if you want opensips to bind on a specific interface/port/proto (default bind on all available) */ #listen=udp:192.168.1.2:5060 ### Modules Section #set module path mpath=//lib/opensips/modules/ /* uncomment next line for MySQL DB support */ loadmodule db_mysql.so loadmodule signaling.so loadmodule sl.so loadmodule tm.so loadmodule rr.so loadmodule maxfwd.so loadmodule usrloc.so loadmodule registrar.so loadmodule textops.so loadmodule mi_fifo.so loadmodule uri.so loadmodule xlog.so loadmodule acc.so loadmodule aaa_radius.so loadmodule auth.so loadmodule auth_db.so #loadmodule alias_db.so #loadmodule domain.so #loadmodule presence.so #loadmodule presence_xml.so loadmodule dialog.so # # - nat_traversal #** loadmodule nat_traversal.so #** modparam(nat_traversal, keepalive_interval, 90) modparam(nat_traversal, keepalive_method, OPTIONS) modparam(nat_traversal, keepalive_from, sip:keepal...@mydomain.com) # # -- nathelper #** loadmodule nathelper.so #** modparam(nathelper, natping_interval, 60) modparam(nathelper, ping_nated_only, 1) modparam(nathelper, sipping_bflag, 7) modparam(nathelper, received_avp, $avp(i:801)) modparam(nathelper, sipping_from, sip:pin...@mydomain.com) # #** loadmodule mediaproxy.so #** #--- Default Values modparam(mediaproxy, mediaproxy_socket, /var/run/mediaproxy/dispatcher.sock) modparam(mediaproxy, mediaproxy_timeout, 500) modparam(mediaproxy, signaling_ip_avp, $avp(s:nat_ip)) modparam(mediaproxy, media_relay_avp, $avp(s:media_relay)) loadmodule drouting.so loadmodule permissions.so # - permissions params - modparam(permissions, db_url, mysql://opensips:opensip...@127.0.0.1/opensips) loadmodule call_control.so # - setting module-specific parameters --- # - mi_fifo params - modparam(mi_fifo, fifo_name, /tmp/opensips_fifo) # - rr params - # add value to ;lr param to cope with most of the UAs modparam(rr, enable_full_lr, 1) # do not append from tag to the RR (no need for this script) modparam(rr, append_fromtag, 0) # - registrar params - /* uncomment the next line not to allow more than 10 contacts per AOR */ #modparam(registrar, max_contacts, 10) # - usrloc params - #modparam(usrloc, db_mode, 0) /* uncomment the following lines if you want to enable DB persistency for location entries */ modparam(usrloc, db_mode, 2) modparam(usrloc, db_url, mysql://opensips:opensip...@localhost/opensips) modparam(usrloc, nat_bflag, 6) # - uri params - modparam(uri, use_uri_table, 0) # - acc params - /* what sepcial events should be accounted ? */ #modparam(acc, early_media, 1) #modparam(acc, report_ack, 1) #modparam(acc, report_cancels, 1) /* by default ww do not adjust the direct of the sequential requests. if you enable this parameter, be sure the enable
[OpenSIPS-Users] CDRTool - Prepaid does not decrement balance
Hi, I am having a difficulty with prepaid in CDRTool. When I telnet to the server and give the commands manually as below the prepaid balance is decremented correctly. When I place the call thru Opensips the call is billed (as show below too) but the prepaid balance is not decremented. I did not install Call Control yet because it's not very important that I stop calls on the fly. Could that be the problem? Thanks in advance for any suggestions, Alberto _ os1:~# telnet os2 9024 Trying XXX.XXX.197.172... Connected to os2.voip.net. Escape character is '^]'. MaxSessionTimecallid=6432622...@1 From=sip:2...@os1.voip.net To=sip:005521850222...@xxx.xxx.197.171 Duration=7200 Gateway=XXX.XXX.188.229 Lock=1 402 ShowPrice From=sip:2...@os1.voip.net To=sip:005521850222...@xxx.xxx.197.171 Gateway=XXX.XXX.188.229 Duration=59 0.1300 Duration: 59 s App: audio Destination: 55218 Customer: subscriber=2...@os1.voip.net Connect: 0. StartTime: 2009-07-31 17:06:51 -- Span: 1 Duration: 60 s Increment: 6 Min duration: 30 ProfileId: plu / weekday RateId: plu / 0-24h Rate: 0.1300 / 60 s Price: 0.1300 DebitBalance callid=6432622...@1 From=sip:2...@os1.voip.net To=sip:005521850222...@xxx.xxx.197.171 Gateway=XXX.XXX.188.229 Duration=59 Ok MaxSessionTime=0 0.1300 Duration: 59 s App: audio Destination: 55218 Customer: subscriber=2...@os1.voip.net Connect: 0. StartTime: 2009-07-31 17:08:15 -- Span: 1 Duration: 60 s Increment: 6 Min duration: 30 ProfileId: plu / weekday RateId: plu / 0-24h Rate: 0.1300 / 60 s Price: 0.1300 ___ Id Start time Sip Proxy SIP caller SIP destination Dur Price KBIn KBOut Status Codecs 1N 2009-07-31 11:27:21 XXX.XXX.197.171 2...@os1.voip.net +552185022233 (BRAZIL CELL 55218) 00:04 0.0650 Ok (200) Signalling information Click here to show only this call id Call id: 1537464575-5264...@189.4.254.119 Click here to see the SIP trace for this call From/to tags: 1685903383/013be01d Start time: 2009-07-31 11:27:21 Stop time: 2009-07-31 11:27:25 Method: Invite from XXX.XXX.254.119:5264 From: 2...@os1.voip.net Domain: os1.voip.net To (dialed URI): 005521850222...@os1.voip.net Canonical URI: 005521850222...@os1.voip.net Next hop URI: 005521850222...@xxx.xxx.195.56 Destination: BRAZIL CELL (55218) Billing Party: 2...@os1.voip.net Reseller: 0 Rating information Duration: 4 s App: audio Destination: 55218 Customer: subscriber=2...@os1.voip.net Connect: 0. StartTime: 2009-07-31 16:27:21 -- Span: 1 Duration: 30 s Increment: 6 Min duration: 30 ProfileId: plu / weekday RateId: plu / 0-24h Rate: 0.1300 / 60 s Price: 0.0650 ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool does not identify by IP origin from OpenSips
Hi Dan, Thanks for the info, the doc/Rating.txt is very good but sometimes you need previous experience to understand the details. I was already using the param: Source-IP=$avp(s:source_ip); But I wasn't setting any values so the SourceIP column was blank. I added a line to the cfg to set the value: $avp(s:source_ip) = $si; And now the rating identifies the origin by SourceIP when the CallingStationId is in the form 123...@1.1.1.1 (and hence the domain is set to the IP of the source) but when CallingStationId is in the form 1.1.1.1 (just the IP) the Domain in the info of the call is blank and the rating does not work. When the Domain is blank the rating engine use the profile Customer: al...@example.com from the default Customer configuration of CDRTool. I suppose this is because this customer has a blank domain field. But this is an error since it should use the default profile instead. Anyway, Thanks for your help, now it can rate by IP. Cheers, Alberto - Original Message - From: DanB To: Alberto Listas Cc: users@lists.opensips.org Sent: Wednesday, July 22, 2009 4:23 AM Subject: Re: [OpenSIPS-Users] CDRTool does not identify by IP origin from OpenSips Hi Alberto, By default CDRTool takes the gateway parameter out of Source IP (nicely explained also in the doc/RATING.TXT) and if you don't modify the defaults, out of radacct.SourceIP column. In order to identify the gateway, you need to enforce that SourceIP inside opensips script to whatever IP you want to be used as your gateway. Example of params in opensips.cfg: modparam(acc, radius_extra,Source-IP=$avp(s:mygtw)) Another trick you can use is to write your own radius sql query which places the SourceIP from another radius attribute received. Cheers, DanB On Tue, Jul 21, 2009 at 9:44 PM, Alberto Listas lis...@b2br.net wrote: Hi, I am having a difficulty with the rating in CDRTool. When I telnet and give this command: ShowPrice From=sip:005521810...@10.0.0.4 To=sip:00552181000...@10.0.0.1 Gateway=10.0.0.4 Duration=30 (IPs where changed) The rating engine identifies the customer by the gateway and rates correctly. When the call comes from the OpenSips it doesn't identify the customer and uses the default profile: Start time: 2009-07-21 14:55:24 Stop time: 2009-07-21 14:55:59 Method:Invite from : From:5521083200...@10.0.0.4 Domain:10.0.0.4 To (dialed URI):005521810...@10.0.0.4 Canonical URI: 005521810...@10.0.0.1 Next hop URI:005521810...@10.0.0.2 Destination: BRAZIL CELL (55218) Billing Party:5521810...@10.0.0.4 Reseller: Duration: 35 s App: audio Destination: 55218 Customer: default Connect: 0. .. Should I set some different variable to FreeRadius for it to identify the GATEWAY? Thanks, Alberto ___ 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
[OpenSIPS-Users] CDRTool does not identify by IP origin from OpenSips
Hi, I am having a difficulty with the rating in CDRTool. When I telnet and give this command: ShowPrice From=sip:005521810...@10.0.0.4 To=sip:00552181000...@10.0.0.1 Gateway=10.0.0.4 Duration=30 (IPs where changed) The rating engine identifies the customer by the gateway and rates correctly. When the call comes from the OpenSips it doesn't identify the customer and uses the default profile: Start time: 2009-07-21 14:55:24 Stop time: 2009-07-21 14:55:59 Method:Invite from : From:5521083200...@10.0.0.4 Domain:10.0.0.4 To (dialed URI):005521810...@10.0.0.4 Canonical URI: 005521810...@10.0.0.1 Next hop URI:005521810...@10.0.0.2 Destination: BRAZIL CELL (55218) Billing Party:5521810...@10.0.0.4 Reseller: Duration: 35 s App: audio Destination: 55218 Customer: default Connect: 0. .. Should I set some different variable to FreeRadius for it to identify the GATEWAY? Thanks, Alberto___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool - Rating engine does not rate
I did not see an error in the import. But I also solved the problem adding a profile for grn_premium. Thanks, Alberto - Original Message - From: bay2x1 r...@racequeen.ph To: users@lists.opensips.org Sent: Monday, July 13, 2009 2:05 AM Subject: Re: [OpenSIPS-Users] CDRTool - Rating engine does not rate I think the problem is in your profiles table, check if you have a profile entry/record for grn_premium . If you encounter an error while importing the sample data for CDRTool (importRatingTables.php) we might have the same problem. I resolve this issue by inserting a record for grn_premium using the CDRTool web application (profiles section). ASHWINI NAIDU wrote: Have you populated all the relavent data needed for CDRTool rating Destinations table,customers, prfiles and rates. if yes. Delete the entries in Your memcache table and restart ur rating engine and try to get search again. I guess this should work. On Sat, Jul 11, 2009 at 3:21 AM, Alberto Listas lis...@b2br.net wrote: Hi, I have installed OpenSips 1.5.1, FreeRadius 2.1.6, CDRTool 6.8.0. The calls work but they all appear as free in CDRTool. I am using the standard customer and rate tables that come with the software. When I telnet to the rating engine and use the example in the documentation I get the result below: ShowPrice From=sip:1...@example.com sip%3a...@example.com To= sip:0031650222...@example.com sip%3a0031650222...@example.com Gateway=10.0.0.1 Duration=59 0 Duration: 59 s App: audio Destination: 31650 Customer: domain=example.com (And nothing else...) I don't get a price and the /var/log/syslog displays this error: Jul 10 18:28:49 os2 cdrtool[11392]: Error: Cannot find rates for callid=, billing party=...@example.com, customer domain=example.com, gateway=10.0.0.1, destination=31650, profile=grn_premium, app=audio I don't see the error. There is an entry in customers for the domain example.com, there is a rate for destination 31650. But the rating engine does find any. Anybody has a suggestion??? Thanks, Alberto ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Thanking You, Ashwini BR Naidu ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users - http://opensips.blogspot.com http://opensips.blogspot.com -- View this message in context: http://n2.nabble.com/CDRTool---Rating-engine-does-not-rate-tp3241434p3248819.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. ___ 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.375 / Virus Database: 270.13.6/2221 - Release Date: 07/06/09 17:54:00 ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] CDRTool - Rating engine does not rate
Hi, I have installed OpenSips 1.5.1, FreeRadius 2.1.6, CDRTool 6.8.0. The calls work but they all appear as free in CDRTool. I am using the standard customer and rate tables that come with the software. When I telnet to the rating engine and use the example in the documentation I get the result below: ShowPrice From=sip:1...@example.com To=sip:0031650222...@example.com Gateway=10.0.0.1 Duration=59 0 Duration: 59 s App: audio Destination: 31650 Customer: domain=example.com (And nothing else...) I don't get a price and the /var/log/syslog displays this error: Jul 10 18:28:49 os2 cdrtool[11392]: Error: Cannot find rates for callid=, billing party=...@example.com, customer domain=example.com, gateway=10.0.0.1, destination=31650, profile=grn_premium, app=audio I don't see the error. There is an entry in customers for the domain example.com, there is a rate for destination 31650. But the rating engine does find any. Anybody has a suggestion??? Thanks, Alberto ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] Mediaproxy 2.3.4 on 1 machine
Hi, I am trying to install a test system with OpenSIPS and Mediaproxy to use FreeRadius and CDRTool. Can 2.3.4 run dispatcher and relay on the same machine? Thanks, Alberto ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
