FW: Install - Freeradius can't connect to MySQL

[Chris Carver]

This doesn't really help your situation, but I've always thought just 
typing it on the command line, 'radiusd' or having it started 
automatically on boot was the "way its supposed to be."  Its also the 
way I've always know everyone else to do it too.  What exactly does 
service do any differently?  As far as I know, radiusd is designed to 
just be run straight from the command-line.

Chris Carver
Network Engineer

Cliff Hayes wrote:
> Here's even more light:
>
> When I start freeradius by just typing radiusd on the command line, it
> connects to MySQL ok.  But if I start it like I'm supposed to:  service
> radiusd start, it doesn't.  I'm using Fedora 5 with the latest
> freeradius.i386, freeradius-unixODBC.i386, and  freeradius-mysql.i386.
>
> Cliff
>
> -----Original Message-----
> From: freeradius-users-bounces+chayes=afo.net at lists.freeradius.org
> [mailto:freeradius-users-bounces+chayes=afo.net at lists.freeradius.org]On
> Behalf Of Cliff Hayes
> Sent: Wednesday, June 07, 2006 4:03 PM
> To: freeradius-users at lists.freeradius.org
> Subject: FW: Install - Freeradius can't connect to MySQL
>
>
> Hello again,
>
> This may shed some light on the situation.  When I run in debug mode with -x
> option, it looks like it may be connecting.  Am I interpreting the output
> correctly?  If so, is it normal to connect 5 times?
>
> Cliff
>
> Starting - reading configuration files ...
> Using deprecated naslist file.  Support for this will go away soon.
> Module: Loaded exec
> rlm_exec: Wait=yes but no output defined. Did you mean output=none?
> Module: Instantiated exec (exec)
> Module: Loaded expr
> Module: Instantiated expr (expr)
> Module: Loaded PAP
> Module: Instantiated pap (pap)
> Module: Loaded CHAP
> Module: Instantiated chap (chap)
> Module: Loaded MS-CHAP
> Module: Instantiated mschap (mschap)
> Module: Loaded System
> Module: Instantiated unix (unix)
> Module: Loaded eap
> rlm_eap: Loaded and initialized type md5
> rlm_eap: Loaded and initialized type leap
> rlm_eap: Loaded and initialized type gtc
> rlm_eap: Loaded and initialized type mschapv2
> Module: Instantiated eap (eap)
> Module: Loaded preprocess
> Module: Instantiated preprocess (preprocess)
> Module: Loaded realm
> Module: Instantiated realm (suffix)
> Module: Loaded SQL
> rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
> rlm_sql (sql): Attempting to connect to root at localhost:/radius
> rlm_sql (sql): starting 0
> rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
> rlm_sql_mysql: Starting connect to MySQL server for #0
> rlm_sql (sql): Connected new DB handle, #0
> rlm_sql (sql): starting 1
> rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
> rlm_sql_mysql: Starting connect to MySQL server for #1
> rlm_sql (sql): Connected new DB handle, #1
> rlm_sql (sql): starting 2
> rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
> rlm_sql_mysql: Starting connect to MySQL server for #2
> rlm_sql (sql): Connected new DB handle, #2
> rlm_sql (sql): starting 3
> rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
> rlm_sql_mysql: Starting connect to MySQL server for #3
> rlm_sql (sql): Connected new DB handle, #3
> rlm_sql (sql): starting 4
> rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
> rlm_sql_mysql: Starting connect to MySQL server for #4
> rlm_sql (sql): Connected new DB handle, #4
> Module: Instantiated sql (sql)
> Module: Loaded Acct-Unique-Session-Id
> Module: Instantiated acct_unique (acct_unique)
> Module: Loaded files
> Module: Instantiated files (files)
> Module: Loaded detail
> Module: Instantiated detail (detail)
> Module: Loaded radutmp
> Module: Instantiated radutmp (radutmp)
> Initializing the thread pool...
> Listening on authentication *:1812
> Listening on accounting *:1813
> Ready to process requests.
>
> -----Original Message-----
> From: freeradius-users-bounces+chayes=afo.net at lists.freeradius.org
> [mailto:freeradius-users-bounces+chayes=afo.net at lists.freeradius.org]On
> Behalf Of Cliff Hayes
> Sent: Wednesday, June 07, 2006 2:28 PM
> To: freeradius-users at lists.freeradius.org
> Subject: Install - Freeradius can't connect to MySQL
>
>
> Hello,
>
> Warning - newbie installing Freeradius.
>
> I get this in the radius.log even though the sql.conf has the correct
> host/user/password (and I can access MySQL from the command line using the
> same login criteria):
>
> Wed Jun  7 14:01:52 2006 : Info: rlm_sql_mysql: Starting connect to MySQL
> server for #0
> Wed Jun  7 14:01:52 2006 : Error: rlm_sql_mysql: Couldn't connect socket to
> MySQL server root at localhost:radius
> Wed Jun  7 14:01:52 2006 : Error: rlm_sql_mysql: Mysql error 'Can't connect
> to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)'
> Wed Jun  7 14:01:52 2006 : Error: rlm_sql (sql): Failed to connect DB handle
> #0
> Wed Jun  7 14:01:52 2006 : Info: Ready to process requests.
>
> Thanks,
>
> Cliff
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>