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