Hi dudes,
I´m trying to configure freeradius to autenticate
with Firebird DataBase.
I´m using freeradius 0.8.1 and UnixODBC
2.2.3 I´ve just to install UnixOdbc and I
configured the connection with the Firebird, if I test the connection with
odbcconfig it says for me that every thing working out, no
problems, but the freeradius don´t work with the database(or
UnixODBC).
When I started the radiusd with #radiusd
-X
it´s showing me this answers:
Starting - reading configuration files
...
Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded eap rlm_eap: Loaded and initialized the type md5 Module: Instantiated eap (eap) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded SQL rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED] 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 Module: Instantiated sql (sql) Module: Loaded files Module: Instantiated files (files) Module: Loaded Acct-Unique-Session-Id Module: Instantiated acct_unique (acct_unique) Module: Loaded detail Module: Instantiated detail (detail) Module: Loaded System Module: Instantiated unix (unix) Module: Loaded radutmp Module: Instantiated radutmp (radutmp) Initializing the thread pool... Listening on IP address *, ports 1812/udp and 1813/udp, with proxy on 1814/udp. Ready to process requests. ............................................................
Example sql.conf that I´m
using:
sql {
#
Database type
# Current supported are: rlm_sql_mysql, rlm_sql_postgresql, # rlm_sql_iodbc, rlm_sql_oracle, rlm_sql_unixodbc, rlm_sql_freetds driver = "rlm_sql_unixodbc" server =
"localhost"
login = "MYLOGIN" ///// my login and pass both corrects password = "MYPASS" # Database table configuration radius_db = "RADIUS.GDB" /////My database in FIREBIRD # If you want both stop and start records logged to the # same SQL table, leave this as is. If you want them in # different tables, put the start table in acct_table1 # and stop table in acct_table2 acct_table1 = "radacct" /////There are data into the all tables acct_table2 = "radacct" authcheck_table = "radcheck" authreply_table = "radreply" groupcheck_table = "radgroupcheck" groupreply_table = "radgroupreply" usergroup_table = "usergroup" ................................... |