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