Re: [OpenSIPS-Users] (Solved) Radius repeats the record to CDRTool/Radius
Repetition of entries in the dictionary where casing the repetition of records. - Original Message - From: Alberto Listas To: users@lists.opensips.org Sent: Friday, November 20, 2009 5:30 PM Subject: [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 ___ 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