Hi to all! I'm desperate ;( ...
I have to work with a MS SQL server from freeradius. Debian team removed feeradius-unixodbc (i've used only unixodbc until now) from repos and i installed freeradius-unixodbc. When i launch freeradius -X i see this errors (with trace enabled): ---------------------------------------------------- rlm_sql (sql): Driver rlm_sql_iodbc (module rlm_sql_iodbc) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:1433/Radius_DB rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_iodbc #0 ** iODBC Trace file ** Trace started on Mon Sep 18 12:21:31 2006 ** Driver Manager: 03.52.0406.0126 [000000.000053] freeradius 2B88599C0250 ENTER SQLAllocEnv SQLHENV * 0x5b0ea0 [000000.000073] freeradius 2B88599C0250 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS) SQLHENV * 0x5b0ea0 (0x5b0ee0) [000000.000091] freeradius 2B88599C0250 ENTER SQLAllocConnect SQLHENV 0x5b0ee0 SQLHDBC * 0x5b0ea8 [000000.000105] freeradius 2B88599C0250 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS) SQLHENV 0x5b0ee0 SQLHDBC * 0x5b0ea8 (0x5b1030) [000000.000124] freeradius 2B88599C0250 ENTER SQLConnect SQLHDBC 0x5b1030 SQLCHAR * 0x63ac40 | Radius_DB | SQLSMALLINT -3 (SQL_NTS) SQLCHAR * 0x5aee00 | wireless_admin | SQLSMALLINT -3 (SQL_NTS) SQLCHAR * 0x2b885a32a700 | **** | SQLSMALLINT -3 (SQL_NTS) [000000.000552] freeradius 2B88599C0250 EXIT SQLConnect with return code -1 (SQL_ERROR) SQLHDBC 0x5b1030 SQLCHAR * 0x63ac40 SQLSMALLINT -3 (SQL_NTS) SQLCHAR * 0x5aee00 SQLSMALLINT -3 (SQL_NTS) SQLCHAR * 0x2b885a32a700 SQLSMALLINT -3 (SQL_NTS) [000000.000595] freeradius 2B88599C0250 ENTER SQLError SQLHENV 0x5b0ee0 SQLHDBC 0x5b1030 SQLHSTMT 0x0 (SQL_NULL_HANDLE) SQLCHAR * 0x7fffffa4e040 SQLINTEGER * 0x7fffffa4e148 SQLCHAR * 0x2b885a2e6b80 SQLINTEGER 256 SQLSMALLINT * 0x7fffffa4e14e [000000.000637] freeradius 2B88599C0250 EXIT SQLError with return code 0 (SQL_SUCCESS) SQLHENV 0x5b0ee0 SQLHDBC 0x5b1030 SQLHSTMT 0x0 (SQL_NULL_HANDLE) SQLCHAR * 0x7fffffa4e040 | IM002 | SQLINTEGER * 0x7fffffa4e148 (0) SQLCHAR * 0x2b885a2e6b80 | [iODBC][Driver Manager]Data source name | | not found and no default driver specifie | | d. Driver could not be loaded | SQLINTEGER 256 SQLSMALLINT * 0x7fffffa4e14e (109) sql_create_socket: SQLConnectfailed: [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. ---------------------------------------------------- My configuration worked well with unixodbc. If i try with iodbctest "DSN=MSSQL;UID=wireles_admin;PWD=***" everything works well. Why??? Please help me !!! Thanks!!! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html