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: freeradius-users-bounces+chayes=afo.net@lists.freeradius.org [mailto:freeradius-users-bounces+chayes=afo.net@lists.freeradius.org]On Behalf Of A.L.M.Buxey@lboro.ac.uk 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

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: freeradius-users-bounces+chayes=afo.net@lists.freeradius.org [mailto:freeradius-users-bounces+chayes=afo.net@lists.freeradius.org]On 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 root@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

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 | | nwtech@tele-net.net | --------------------------- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html