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