select 123456 from radacct where username = 'mauro' LIMIT 1 On Wed, May 20, 2009 at 2:44 PM, Mauro Iorio - Smart Soft s.r.l. < m.io...@smartsoft.it> wrote:
> > > > 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. > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html >
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html