View Single Post

  #1 (permalink)  
Old 12-22-2006
N S
 
Posts: n/a
Default Re: User authentication using Mysql table - radacct

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@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@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
http://www.live.com/?addtemplate=foo...T001MSN30A0701

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Reply With Quote