Freeradius IODBC bug?
Angelo Compagnucci
emailvarie at davide.it
Mon Sep 18 12:29:45 CEST 2006
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
wireless_admin at 192.168.1.21: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!!!
More information about the Freeradius-Users
mailing list