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..
Thanks
Andy
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
