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

Hi Naeem,

I had this problem and corrected it by granting read access to all
users to the /etc/shadow file

let me know if that works for you too.

Tim


"N S" wrote:
> 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