freeradius2 + iODBC + Informix
vanish
vanishox at coltel.ru
Tue Dec 2 14:05:08 CET 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 at 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 at 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.
More information about the Freeradius-Users
mailing list