View Single Post

  #2 (permalink)  
Old 12-22-2006
TimBlagbrough@gmail.com
 
Posts: n/a
Default Re: User authentication using Mysql table - radacct

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


Reply With Quote