Accounting error

[tnt at kalik.net]

>       I hope anyone can help me with these errors I have in the
>radius.log file:
>
>Error: rlm_sql_getvpdata: database query error
>Error: rlm_sql (sql): SQL query error; rejecting user
>Error: rlm_sql (sql): Couldn't update SQL accounting ALIVE record -
>00000
>
>
>    I am using freeradius 1.1.7 with freetds and MSSQL 2005 as the
>backend database, the radius receives interim accounting update packets
>to calculate users utlized bandwidth and the data is inserted into the
>MSSQL database using SQL Procedures.
>
>    Does anyone knows what may cause these errors to occure, note that
>when I run radius -X most of the update statements return with status
>ok and for the statements that return with this error, they run fine
>from the MSSQL console.
>

Post the radiusd -X output showing those errors.

Ivan Kalik
Kalik Informatika ISP