Install - Freeradius can't connect to MySQL

[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: freeradius-users-bounces+chayes=afo.net at lists.freeradius.org
[mailto:freeradius-users-bounces+chayes=afo.net at 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 at 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 at tele-net.net     |
---------------------------

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