Hi
I use FreeRadius 0.71(snapshoot 20021104) on Solaris 8. Oracle 8.1.7
For accounting I use query as below (the query form is limited to important columns
only):
accounting_start_query="INSERT into TMP_TABLE( .......SESSION_START ............)
VALUES (.........'%{Acct-Status-Type}'......."
Below you can find appropriate output from radiusd -X:
radius_xlat: 'INSERT into TMP_TABLE( ....... SESSION_START ........) VALUES (
.......... 'Start'........)'
rlm_sql: Reserving sql socket id: 3
rlm_sql: Attempting to connect #3
rlm_sql: Connected new DB handle, #3
rlm_sql: failed after re-connect
rlm_sql: Couldn't update SQL accounting for START packet - ORA-01722: invalid number
One of values of attribute Acct-Status-Type is value (in mnemonic) Start.
For me it looks that instead of inserting into database numeric value of attribute
Acct-Status-Type, FreeRadius tries to insert mnemonic of that attribute (i.e. text
'Start').
Could someone help
Thanks
MM
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
