freeradius2 + iODBC + Informix

2 Dec 2014


      Hello,
        Please help me set up  freeradius2 + iODBC + Informix 
        (I'm newbie in freeradius).
        
        - I have a test-machine with Ubuntu 14.04 and Freeradius-server
        v2.1.12.
        
        - I have a server with Informix Database Server v 10.00
        
        Step 1:
         - I installed unixODBC on test-machine
         - I installed informix-csdk for connect to Informix Database
        Server (Driver)
         - I configured files /etc/odbc.ini and /etc/odbcinst.ini to
        connect to Informix Database Server
         - Checking with isql:
        
        +++++++++++++++++++++++++++++++++++++++++
        root@test:/home/test# isql -v work
        +---------------------------------------+
        | Connected!                            |
        |                                       |
        | sql-statement                         |
        | help [tablename]                      |
        | quit                                  |
        |                                       |
        +---------------------------------------+
        SQL>  select 1 from TABLES(SET{1})
        1
        +++++++++++++++++++++++++++++++++++++++++
        
         - Everything is allright.
        
        Step 2:
         - I try to install freeradius-iodbc module to connect to
        Informix Database Server
         - During install I get next warning:
        
        +++++++++++++++++++++++++++++++++++++++++++++
        The following packages will be REMOVED:
         unixodbc  unixodbc-dev 
        The following NEW packages will be installed: 
         libiodbc2-dev
        +++++++++++++++++++++++++++++++++++++++++++++
        
         - so unixodbc and  unixodbc-dev packages was removed after
        install freeradius-iodbc
        
         - I included in radiusd.conf:
        
        +++++++++++++++++++++++++++++++++++++++++++++
        sql {
                #
                #  Set the database to one of:
                #
                #       mysql, mssql, oracle, postgresql
                #
                database = "iodbc"
        
                #
                #  Which FreeRADIUS driver to use.
                #
                driver = "rlm_sql_${database}"
        
                # Connection info:
                server = "test.server.ru"
                port = 1425
                login = "test"
                password = "test123"
                radius_db = "test"
         ...
        +++++++++++++++++++++++++++++++++++++++++++++
        
         -  freeradius -XXX showed me next error:
        
        ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
        ...
        Fri Nov 21 14:53:48 2014 : Info: rlm_sql (sql): Driver
        rlm_sql_iodbc (module rlm_sql_iodbc) loaded and linked
        Fri Nov 21 14:53:48 2014 : Info: rlm_sql (sql): Attempting to
        connect to test@test.server.ru:1425/test
        Fri Nov 21 14:53:48 2014 : Debug: rlm_sql (sql): starting 0
        Fri Nov 21 14:53:48 2014 : Info: rlm_sql (sql): Attempting to
        connect rlm_sql_iodbc #0
        Fri Nov 21 14:53:48 2014 : Error: sql_create_socket:
        SQLConnectfailed:  [iODBC][Driver Manager]Data source name
         not found and no default driver specified. Driver could not be
        loaded
        Fri Nov 21 14:53:48 2014 : Error: rlm_sql (sql): Failed to
        connect DB handle #0
        ...
        +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
         - Error - "SQLConnectfailed:  [iODBC][Driver Manager]Data
        source name not found and no default driver specified. Driver
        could not be loaded."
         
         - Where did I go wrong?
        
         - I found some information in net with same problem, but clear
        decision nowhere not found.

freeradius2 + iODBC + Informix

vanish