[OpenSIPS-Users] Opensips AAA / Radius Question

2009-11-21 Thread Alberto Listas
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

2009-11-21 Thread Alberto Listas
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