Re: FW: Install - Freeradius can't connect to MySQL

2006-06-08 Thread A . L . M . Buxey
Hi,
 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.

sounds like SELINUX might be paying your processes a visit. I'd check the
system logs to see if selinux is getting in the way.

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


Re: FW: Install - Freeradius can't connect to MySQL

2006-06-07 Thread Chris Carver
According to your output it is definitely connecting.  5 open 
connections to the mysql db is the default configuration.  If you look 
in etc/raddb/sql.conf you'll see the variable 'num_sql_socks = 5'   This 
is what controls the number of open connections.


Chris Carver
Network Engineer

Cliff Hayes wrote:

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 [EMAIL PROTECTED]:/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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Behalf Of Cliff Hayes
Sent: Wednesday, June 07, 2006 2:28 PM
To: freeradius-users@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 [EMAIL PROTECTED]: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


Re: FW: Install - Freeradius can't connect to MySQL

2006-06-07 Thread 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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Behalf Of Cliff Hayes
Sent: Wednesday, June 07, 2006 4:03 PM
To: freeradius-users@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 [EMAIL PROTECTED]:/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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Behalf Of Cliff Hayes
Sent: Wednesday, June 07, 2006 2:28 PM
To: freeradius-users@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 [EMAIL PROTECTED]: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
  


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