rlm_sql (sql): Unsupported Acct-Status-Type = 15

2007-02-08 Thread tzieleniewski
Hi!

I am trying to process Accounting request to radius but I get the following 
error from sql module:
rlm_sql (sql): Unsupported Acct-Status-Type = 15

I have added the $INCLUDE dictionary.ser line to the dictionary file and the 
dictionary.ser file contains the following records:
VALUE Acct-Status-Type  Interim-Update   3 # RFC2866, acc_radius
VALUE Acct-Status-Type  Failed  15 # RFC2866, acc_radius

Why the rlm_sql doesn't see the Acct-Status-Type of the value 15?
Thanks in advanced for any help.

Below is the Accounting request received by radius.
Thu Feb  8 17:02:04 2007
SER-Attr = 
Acct-Session-Id = [EMAIL PROTECTED]
Sip-To-Tag = b27e1a1d33761e85846fc98f5f3a7e58.42d5
SER-From = hellboy sip:[EMAIL PROTECTED]:5061;tag=612417995
SER-Flags = 12
SER-Original-Request-ID = sip:[EMAIL PROTECTED]
Sip-Method = INVITE
Sip-Cseq = 19049
Sip-Translated-Request-ID = sip:[EMAIL PROTECTED]
Sip-Source-IP-Address = 192.168.0.117
Sip-From-Tag = 612417995
SER-To = sip:[EMAIL 
PROTECTED];tag=b27e1a1d33761e85846fc98f5f3a7e58.42d5
SER-Digest-Username = hellboy
SER-Request-Timestamp = 1170950524
Calling-Station-Id = sip:[EMAIL PROTECTED]:5061
Sip-Source-Port = 5061
SER-Digest-Realm = voip.touk.pl
Sip-Response-Code = 480
Called-Station-Id = sip:[EMAIL PROTECTED]
SER-Response-Timestamp = 1170950524
Acct-Status-Type = Failed
Service-Type = IAPP-Register
NAS-Port = 5060
Acct-Delay-Time = 0
NAS-IP-Address = 127.0.0.1
Acct-Unique-Session-Id = 1276a21c3858a944
Timestamp = 1170950524


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: rlm_sql (sql): Unsupported Acct-Status-Type = 15

2007-02-08 Thread Alan DeKok
tzieleniewski wrote:
 Hi!
 
 I am trying to process Accounting request to radius but I get the following 
 error from sql module:
 rlm_sql (sql): Unsupported Acct-Status-Type = 15
 
 I have added the $INCLUDE dictionary.ser line to the dictionary file and the 
 dictionary.ser file contains the following records:
 VALUE Acct-Status-Type  Interim-Update   3 # RFC2866, acc_radius
 VALUE Acct-Status-Type  Failed  15 # RFC2866, acc_radius
 
 Why the rlm_sql doesn't see the Acct-Status-Type of the value 15?

  Because the source code to rlm_sql needs to be updated to support it.

  There have been ongoing discussions with the OpenSER developers about
this.

  Alan DeKok.
--
  http://deployingradius.com   - The web site of the book
  http://deployingradius.com/blog/ - The blog
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: rlm_sql (sql): Unsupported Acct-Status-Type = 15

2005-10-03 Thread Alan DeKok
Cameron Beattie [EMAIL PROTECTED] wrote:
 When I run radiusd -X and watch what happens when I try to pass a record to 
 FreeRadius, I see the following:
 rlm_sql (sql): Unsupported Acct-Status-Type = 15
   modcall[accounting]: module sql returns noop for request 1

  The RADIUS client is sending an Accounting-Request with a status
that is not implemented by rlm_sql.

  There a are a number of hard-coded queries in rlm_sql.  Accounting
packets containing *other* kinds of status types are not supported.

  Alan DeKok.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


rlm_sql (sql): Unsupported Acct-Status-Type = 15

2005-10-02 Thread Cameron Beattie

I am using FreeRadius 1.0.5. I have configured accounting with sql.

When I run radiusd -X and watch what happens when I try to pass a record to 
FreeRadius, I see the following:

rlm_sql (sql): Unsupported Acct-Status-Type = 15
 modcall[accounting]: module sql returns noop for request 1

vi /usr/local/etc/raddb/dictionary
$INCLUDE/usr/local/share/freeradius/dictionary
$INCLUDE/usr/local/etc/ser/dictionary.ser

vi /usr/local/share/freeradius/dictionary
snip
VALUE   Acct-Status-TypeFailed  15
/snip

vi /usr/local/etc/ser/dictionary.ser
snip
VALUE Acct-Status-Type Failed   15 # RFC2866, acc
/snip

I've tried removing $INCLUDE /usr/local/etc/ser/dictionary.ser from 
/usr/local/etc/raddb/dictionary but the problem persists.


I'm sure there's a configuration step I've missed. Could anyone suggest some 
other things to check?


Thanks

Cameron


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html