R: Sql Counter reads only the first 4 digits

What happens when you replace that SELECT statement with a hard-coded number, like 123456? Does it still truncate the result?

Alan DeKok.

Yes, it does. Check the following output: ----------------------------------------- rlm_sqlcounter: Entering module authorize code sqlcounter_expand: 'SELECT 123456 FROM radacct WHERE UserName='%{User-Name}'' [sessioncounter] expand: SELECT 123456 FROM radacct WHERE UserName='%{Use r-Name}' -> SELECT 123456 FROM radacct WHERE UserName='mauro' sqlcounter_expand: '%{sql:SELECT 123456 FROM radacct WHERE UserName='mauro'}' [sessioncounter] sql_xlat [sessioncounter] expand: %{User-Name} -> mauro [sessioncounter] sql_set_user escaped user --> 'mauro' [sessioncounter] expand: SELECT 123456 FROM radacct WHERE UserName='mauro ' -> SELECT 123456 FROM radacct WHERE UserName='mauro' [sessioncounter] expand: /usr/var/log/radius/sqltrace.sql -> /usr/var/log /radius/sqltrace.sql rlm_sql (sql): Reserving sql socket id: 3 query: SELECT 123456 FROM radacct WHERE UserName='mauro' [sessioncounter] sql_xlat finished rlm_sql (sql): Released sql socket id: 3 [sessioncounter] expand: %{sql:SELECT 123456 FROM radacct WHERE UserName= 'mauro'} -> 1234 rlm_sqlcounter: Check item is greater than query result rlm_sqlcounter: Authorized user mauro, check_item=3600, counter=1234 rlm_sqlcounter: Sent Reply-Item for user mauro, Type=Session-Timeout, value=2366 ++[sessioncounter] returns ok WARNING: Please update your configuration, and remove 'Auth-Type = Local' WARNING: Use the PAP or CHAP modules instead. User-Password in the request is correct. +- entering group post-auth {...} ++[exec] returns noop Sending Access-Accept of id 213 to 192.168.4.203 port 44967 Session-Timeout = 2366 Finished request 0. ----------------------------------------- But when I use isql or tsql tools and runs the same query I get (since I have 12 records in radacct): SQL> select 123456 from radacct where username = 'mauro' +------------+ | | +------------+ | 123456 | | 123456 | | 123456 | | 123456 | | 123456 | | 123456 | | 123456 | | 123456 | | 123456 | | 123456 | | 123456 | | 123456 | +------------+ SQLRowCount returns 12 12 rows fetched So I think everything about unixodbc drivers is working properly. Mauro Iorio.