FW: MSSQL using unixodbc and truncation of characters

Franks Andy (RLZ) IT Systems Engineer Andy.Franks at sath.nhs.uk
Thu Jun 13 14:25:53 CEST 2013

Ok, so I've compiled 3 from scratch with support for the freetds and unixodbc modules. I have some issues :
Using the unixodbc driver that was working before gives me this now :

rlm_sql (sql_postauth_lan0): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked
rlm_sql (sql_postauth_lan0): Attempting to connect to database "SATHSupport"
rlm_sql (sql_postauth_lan0): Initialising connection pool
rlm_sql (sql_postauth_lan0): Opening additional connection (0)
rlm_sql_unixodbc: 01000 [unixODBC][Driver Manager]Can't open lib '/usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so' : *¶?±: undefined symbol: get_vtable
rlm_sql_unixodbc: SQL down 08003 [unixODBC][Driver Manager]Connnection does not exist
rlm_sql_unixodbc: Can't allocate the statement
rlm_sql_sybase: Socket destructor called, closing socket
rlm_sql (sql_postauth_lan0): Opening connection failed (0)
rlm_sql (sql_postauth_lan0): Removing connection pool
/usr/local/etc/raddb/mods-enabled/sql_postauth_lan0[1]: Instantiation failed for module "sql_postauth_lan0"

The libtdsodbc.so file exists, and I've briefly altered the permissions to no avail. The .so file is from a package that ubuntu provides, and was working fine with FR2.2.1, just with the previous issue noted (truncation)

Also, the rlm_sql_freetds module gives ,from a simple 
update control {
  SQLComputerID := "%{sql_test_mssql:Select 123456}")

Gives :

LITERAL: %{sql_test_mssql:Select 123456}
LITERAL: %{sql_test_mssql:Select 123456} --> %{sql_test_mssql:Select 123456}
EXPANSION: %{sql_test_mssql:Select 123456}
MOD: sql_test_mssql -->
LITERAL: Select 123456}
xlat aprint 2
xlat aprint 0
expand mod sql_test_mssql --> 'Select 123456'
LITERAL: %{User-Name}
LITERAL: %{User-Name} --> %{User-Name}
EXPANSION: %{User-Name}
Looking for attribute name in User-Name
xlat aprint 3
expand attr User-Name --> '0023ae604b02'
(0)     expand: '%{User-Name}' -> '0023ae604b02'
(0) SQL-User-Name updated
rlm_sql (sql_test_mssql): Reserved connection (4)
rlm_sql (sql_test_mssql): Executing query: 'Select 123456'
rlm_sql_freetds sql_select_query(): unsupported
rlm_sql (sql_test_mssql): Database query error '<UNKNOWN>'
rlm_sql (sql_test_mssql): Released connection (4)
rlm_sql (sql_test_mssql): Closing connection (0): Too many free connections (5 > 3)
rlm_sql_freetds: Socket destructor called, closing socket

I'm stuck, any ideas. Sorry to spam the mailing list so much but I've reached the limit of my knowledge on this one..

More information about the Freeradius-Users mailing list