Error: rlm_sql_unixodbc: SQL down 08S01 [unixODBC][FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist

Bill Grant wgrant at EBPL.org
Sun May 26 01:28:13 CEST 2013


I am having trouble starting freeradius at boot on CentOS 6.4. It starts, but it does not connect to my database; however, if run it manually from the command the it works fine. I think there is permission issue somewhere. See the log below:

when I run following command as root it works

# radiusd

Sat May 25 10:26:20 2013 : Info: rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked
Sat May 25 10:26:20 2013 : Info: rlm_sql (sql): Attempting to connect to radius at EBHorizon:5000/Horizon
Sat May 25 10:26:20 2013 : Info: rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #0
Sat May 25 10:26:20 2013 : Info: rlm_sql (sql): Connected new DB handle, #0
Sat May 25 10:26:20 2013 : Info: rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #1
Sat May 25 10:26:20 2013 : Info: rlm_sql (sql): Connected new DB handle, #1
Sat May 25 10:26:20 2013 : Info: rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #2
Sat May 25 10:26:21 2013 : Info: rlm_sql (sql): Connected new DB handle, #2
Sat May 25 10:26:21 2013 : Info: rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #3
Sat May 25 10:26:21 2013 : Info: rlm_sql (sql): Connected new DB handle, #3
Sat May 25 10:26:21 2013 : Info: rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #4
Sat May 25 10:26:21 2013 : Info: rlm_sql (sql): Connected new DB handle, #4
Sat May 25 10:26:21 2013 : Info: Loaded virtual server <default>
Sat May 25 10:26:21 2013 : Info: Loaded virtual server inner-tunnel
Sat May 25 10:26:21 2013 : Info:  ... adding new socket proxy address * port 35688
Sat May 25 10:26:21 2013 : Info: Ready to process requests.

When I run the command below it does not connect.
#service radiusd start


Sat May 25 10:29:05 2013 : Info: rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked
Sat May 25 10:29:05 2013 : Info: rlm_sql (sql): Attempting to connect to radius at EBHorizon:5000/Horizon
Sat May 25 10:29:05 2013 : Info: rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #0
Sat May 25 10:29:05 2013 : Error: rlm_sql_unixodbc: SQL down 08S01 [unixODBC][FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist
Sat May 25 10:29:05 2013 : Error: rlm_sql_unixodbc: Connection failed
Sat May 25 10:29:05 2013 : Error: rlm_sql (sql): Failed to connect DB handle #0
Sat May 25 10:29:05 2013 : Info: Loaded virtual server <default>
Sat May 25 10:29:05 2013 : Info: Loaded virtual server inner-tunnel
Sat May 25 10:29:05 2013 : Info:  ... adding new socket proxy address * port 59524
Sat May 25 10:29:05 2013 : Info: Ready to process requests.

Any help would be greatly appreciated.


More information about the Freeradius-Users mailing list