FW: MSSQL using unixodbc and truncation of characters
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
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..
Ok, i'll take a closer took at it tonight. Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS Development Team
On 13 Jun 2013, at 13:56, Arran Cudbard-Bell <a.cudbardb@freeradius.org> wrote:
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..
Ok, i'll take a closer took at it tonight.
Um, apparently the original author didn't add select support to the freetds driver. Hence the error. https://github.com/FreeRADIUS/freeradius-server/blob/master/src/modules/rlm_... Isn't the sybase driver equivalent? Doesn't it just use a different version of the API? I know I meant to delete one... The other one looks like a linker issue. Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS Development Team
participants (2)
-
Arran Cudbard-Bell -
Franks Andy (RLZ) IT Systems Engineer