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

2006-06-08 Thread Cliff Hayes
THAT WAS IT!  You were right!  Thanks!

I turned off selinux and the problem went away.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Behalf Of [EMAIL PROTECTED]
Sent: Thursday, June 08, 2006 3:10 AM
To: FreeRadius users mailing list
Subject: Re: FW: Install - Freeradius can't connect to MySQL


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

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


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
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


FW: Install - Freeradius can't connect to MySQL

2006-06-07 Thread 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: [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


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


FW: Install - Freeradius can't connect to MySQL

2006-06-07 Thread Cliff Hayes
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


RE: Install - Freeradius can't connect to MySQL

2006-06-07 Thread Cliff Hayes
That is correct.  Here is an exerpt from sql.conf

# Connect info
server = "localhost"
login = "root"
password = "***the real password is in the file"

# Database table configuration
radius_db = "radius"

And I have already created the radius database and imported the schema.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Behalf Of N White
Sent: Wednesday, June 07, 2006 2:45 PM
To: FreeRadius users mailing list
Subject: Re: Install - Freeradius can't connect to MySQL


Cliff Hayes wrote:
> 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
>
>
>
Just to clarify. It looks as though MySQL is running on the localhost
(same machine as FreeRADIUS) and you are logging into it with username
'root'. The FreeRADIUS database is named 'radius'. This is correct?

--
---
| Nick White  |
| [EMAIL PROTECTED] |
---

-
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: Install - Freeradius can't connect to MySQL

2006-06-07 Thread Cliff Hayes
Yes sir, sure does.

It is the same as mentioned in /etc/my.cnf

I also ran mysqladmin -p version to make sure

Cliff

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, June 07, 2006 2:42 PM
To: FreeRadius users mailing list
Subject: Re: Install - Freeradius can't connect to MySQL


Hi,

> to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)'

does this socket file exist? sounds very much like the classic 'socket
not where you expect' issue. eg
http://lists.cistron.nl/pipermail/freeradius-users/2004-July/034410.html

alan
-
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: Install - Freeradius can't connect to MySQL

2006-06-07 Thread N White

Cliff Hayes wrote:

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



  
Just to clarify. It looks as though MySQL is running on the localhost 
(same machine as FreeRADIUS) and you are logging into it with username 
'root'. The FreeRADIUS database is named 'radius'. This is correct?


--
---
| Nick White  |
| [EMAIL PROTECTED] |
---

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


Re: Install - Freeradius can't connect to MySQL

2006-06-07 Thread A . L . M . Buxey
Hi,

> to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)'

does this socket file exist? sounds very much like the classic 'socket
not where you expect' issue. eg
http://lists.cistron.nl/pipermail/freeradius-users/2004-July/034410.html

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


Install - Freeradius can't connect to MySQL

2006-06-07 Thread Cliff Hayes
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