FW: Install - Freeradius can't connect to MySQL

[Cliff Hayes]

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