freeradius2 + iODBC + Informix

14 Jan 2015

      Greeting, Fajar A. Nugraha-2, Alan DeKok-2.

After yours answers i tried to rebuild freeradius with unixodbc module.

1. Install unixodbc and  unixodbc-dev

2. Download 2.1.12 package:

freeradius_2.1.12+dfsg-1.2ubuntu8.debian.tar.gz
freeradius_2.1.12+dfsg-1.2ubuntu8.dsc
freeradius_2.1.12+dfsg.orig.tar.bz2

2. Edit debian/rules :

	--prefix=/usr \
        --exec-prefix=/usr \
        --mandir=$(mandir) \
        --sysconfdir=/etc \
        --libdir=$(libdir) \
        --datadir=/usr/share \
        --localstatedir=/var \
        --with-raddbdir=$(raddbdir) \
        --with-logdir=/var/log/$(package) \
        --enable-ltdl-install=no --enable-strict-dependencies \
        --with-large-files --with-udpfromto --with-edir \
        --enable-developer \
        --config-cache \
        --without-rlm_eap_tnc \
        --with-rlm_sql_postgresql_lib_dir=`pg_config --libdir` \
        --with-rlm_sql_postgresql_include_dir=`pg_config --includedir` \
        --without-rlm_eap_ikev2 \
        --without-rlm_sql_oracle \
!!      --without-rlm_sql_iodbc \     
!!      --with-rlm_sql_unixodbc \        
        --with-system-libtool

3. Build package:

 dpkg-buildpackage -d -rfakeroot

4. Install deb packet:

dpkg -i freeradius_2.1.12+dfsg-1.2ubuntu8_amd64.deb

5. Change sql.conf:

 +++++++++++++++++++++++++++++++++++++++++++++ 
        sql { 
                # 
                #  Set the database to one of: 
                # 
                #       mysql, mssql, oracle, postgresql 
                # 
                database = "unixodbc" 

                # 
                #  Which FreeRADIUS driver to use. 
                # 
                driver = "rlm_sql_${database}" 

                # Connection info: 
                server = "test.server.ru" 
                port = 1425 
                login = "test" 
                password = "test123" 
                radius_db = "test" 
         ... 
+++++++++++++++++++++++++++++++++++++++++++++ 

6. freeradius -X showed me:

rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded
and linked
rlm_sql (sql): Attempting to connect to test@test.server.ru:1425/test
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #0
rlm_sql_unixodbc: Connection failed 
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.

7. On test.server.ru  i used tcpdump utils to see incoming packets from
my machine with freeradius - but the entering packets was not detected.

Please, help me find the mistake.

-- 
============================================
С уважением, Богучарский Иван Владимирович.
Начальник СУТС ОРЭТС и ШПД ЗАО "Коламбия-Телеком".
тел. 8-937-084-25-89.

freeradius2 + iODBC + Informix

vanish