freeradius2 + iODBC + Informix
vanish
vanishox at coltel.ru
Wed Jan 14 13:04:10 CET 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 at 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.
More information about the Freeradius-Users
mailing list