problem with mysql accounting
basile
bmathieu at siris.sorbonne.fr
Thu Dec 21 12:45:17 CET 2006
hi
i try to account with mysql
here are the mysql start stop and update definition
accounting_start_query = "INSERT into radaact SET\
`User-Name` = '%{User-Name}',\
`Calling-Station-Id` = '%{Calling-Station-Id}',\
`Called-Station-Id` = '%{Called-Station-Id}',\
`NAS-IP-Address` = '%{NAS-IP-Address}',\
`NAS-Port` = %{NAS-Port},\
`Timestamp Start` = NOW(),\
`Acct-Unique-Session-Id` = '%{Acct-Unique-Session-Id}'
"
accounting_update_query = "UPDATE radaact SET\
`Acct-Session-Time` = '%{Acct-Session-Time}',\
`Acct-Input-Octets` = '%{Acct-Input-Octets}',\
`Acct-Output-Octets` = '%{Acct-Output-Octets}',\
`Acct-Input-Packets` = '%{Acct-Input-Packets}',\
`Acct-Output-Packets` = '%{Acct-Output-Packets}'\
WHERE `Acct-Unique-Session-Id` = '%{Acct-Unique-Session-Id}'\
LIMIT 1
"
accounting_stop_query = "UPDATE radaact SET\
`Timestamp Stop` = NOW(),\
`Acct-Session-Time` = '%{Acct-Session-Time}',\
`Acct-Input-Octets` = '%{Acct-Input-Octets}',\
`Acct-Output-Octets` = '%{Acct-Output-Octets}',\
`Acct-Input-Packets` = '%{Acct-Input-Packets}',\
`Acct-Output-Packets` = '%{Acct-Output-Packets}',\
`Acct-Terminate-Cause` = '%{Acct-Terminate-Cause}'\
WHERE `Acct-Unique-Session-Id` = '%{Acct-Unique-Session-Id}'\
LIMIT 1
"
update works fine
rlm_sql (sql): sql_set_user escaped user --> 'xxxx'
radius_xlat: 'UPDATE radaact SET??`Acct-Session-Time` =
'292',??`Acct-Input-Octets` = '94237',??`Acct-Output-Octets` =
'937628',??`Acct-Input-Packets` = '597',??`Acct-Output-Packets` =
'816'?WHERE `Acct-Unique-Session-Id` = '814b38bc0e9c60f4'?LIMIT 1 '
rlm_sql (sql): Reserving sql socket id: 2
radius_xlat: ''
rlm_sql (sql): Released sql socket id: 2
modcall[accounting]: module "sql" returns ok for request 61
modcall: leaving group accounting (returns ok) for request 61
but start and stop not
rlm_sql (sql): sql_set_user escaped user --> 'yyyy'
radius_xlat: 'INSERT into radaact SET '
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_mysql: MYSQL check_error: 1064 received
rlm_sql (sql): Couldn't insert SQL accounting START record - You have an
error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near '' at line 1
radius_xlat: ''
rlm_sql (sql): Released sql socket id: 4
modcall[accounting]: module "sql" returns ok for request 59
modcall: leaving group accounting (returns ok) for request 59
rlm_sql (sql): sql_set_user escaped user --> 'yyyy'
radius_xlat: 'UPDATE radaact SET '
rlm_sql (sql): Reserving sql socket id: 3
rlm_sql_mysql: MYSQL check_error: 1064 received
rlm_sql (sql): Couldn't update SQL accounting STOP record - You have an
error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near '' at line 1
rlm_sql (sql): Released sql socket id: 3
modcall[accounting]: module "sql" returns fail for request 60
modcall: leaving group accounting (returns fail) for request 60
i use mysql 4.1 , freeradius 1.1
thanks for help
basile
More information about the Freeradius-Users
mailing list