User authentication using Mysql table - radacct

[N S]

Hi All,
I was running radius both the daemon and the debug mode as the root user.
And this is the log from radius.log

Thu Dec 21 20:06:00 2006 : Error: rlm_sql (sql): Failed to connect DB handle 
#0
Thu Dec 21 20:06:00 2006 : Info: Ready to process requests.
Thu Dec 21 20:06:16 2006 : Info: rlm_sql (sql): There are no DB handles to 
use! skipped 10, tried to connect 0
Thu Dec 21 20:06:23 2006 : Info: rlm_sql (sql): There are no DB handles to 
use! skipped 10, tried to connect 0
Thu Dec 21 20:09:00 2006 : Info: Using deprecated naslist file.  Support for 
this will go away soon.
Thu Dec 21 20:09:00 2006 : Info: rlm_exec: Wait=yes but no output defined. 
Did you mean output=none?
Thu Dec 21 20:09:00 2006 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module 
rlm_sql_mysql) loaded and linked
Thu Dec 21 20:09:00 2006 : Info: rlm_sql (sql): Attempting to connect to 
root at localhost:/radius
Thu Dec 21 20:09:00 2006 : Info: rlm_sql_mysql: Starting connect to MySQL 
server for #0
Thu Dec 21 20:09:00 2006 : Error: rlm_sql_mysql: Couldn't connect socket to 
MySQL server root at localhost:radius
Thu Dec 21 20:09:00 2006 : Error: rlm_sql_mysql: Mysql error 'Can't connect 
to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)'
Thu Dec 21 20:09:00 2006 : Error: rlm_sql (sql): Failed to connect DB handle 
#0
Thu Dec 21 20:09:00 2006 : Info: Ready to process requests.
Thu Dec 21 20:09:16 2006 : Info: rlm_sql (sql): There are no DB handles to 
use! skipped 50, tried to connect 0
Thu Dec 21 20:09:23 2006 : Info: rlm_sql (sql): There are no DB handles to 
use! skipped 50, tried to connect 0



N S wrote:
 > Hi All,
 > The authentication works in the debug mode but it does not work in the
 > regular mode.
....
 > main: user = "radiusd"
 > main: group = "radiusd"

   Does that user have permissions to read/write the files the server needs?

   Try using "su" to become user "radiusd", and THEN run the server in
debugging mode.  It will tell you what's going wrong.

   Alan DeKok.
--
   http://deployingradius.com       - The web site of the book
   http://deployingradius.com/blog/ - The blog
-
List info/subscribe/unsubscribe? See 
http://www.freeradius.org/list/users.html

_________________________________________________________________
Get live scores and news about your team: Add the Live.com Football Page 
www.live.com/?addtemplate=football&icid=T001MSN30A0701