Thanks David, that worked.

Message: 6
Date: Sun, 20 Jan 2008 17:46:16 +0000
From: "Anthony McGarry" <agtmcgarry@gmail.com >
Subject: MySQL
To: freeradius-users@lists.freeradius.org
Message-ID:
       < a2cb32ac0801200946v4a98d251h4cd04f1bdc447ff1@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Hi,

I downloaded the latest version 2.0.0. Installed and tested ok.
I want to integrate with MySQL.

However when I follow the procedure on the howto to create the radius db on
mysql I run into a problem.

The howto says to enter the following commands

mysql -uroot -p
 CREATE DATABASE radius;
 GRANT ALL ON radius.* TO radius@localhost IDENTIFIED BY "radpass";
 exit

This works fine and I can see the newly created db and user.


However then it tells me to run mysql.sql
cd /usr/share/doc/packages
/freeradius/doc/examples/

mysql -uroot -p radius < mysql.sql

I have looked everywhere on my system for this file but it is not present.

I checked the tar for 2.0.0 and still no joy
I downloaded and checked the tar for 1.1.7 and its in the doc/example folder.

Is there a new way of updating the radius db in MySQL or where can I
get the mysql.sql
 script for ver 2.0.0

Thanks

Anthony
-------------- next part --------------
An HTML attachment was scrubbed...
URL: < https://lists.freeradius.org/pipermail/freeradius-users/attachments/20080120/cf567852/attachment-0001.html>

------------------------------

Message: 7
Date: Sun, 20 Jan 2008 18:03:26 +0000
From: David Wood < david@wood2.org.uk>
Subject: Re: MySQL
To: FreeRadius users mailing list
       < freeradius-users@lists.freeradius.org>
Message-ID: <O4NIQfEuz4kHFAUp@wood2.org.uk>
Content-Type: text/plain;charset=us-ascii;format=flowed

Hi Anthony,

In message
<a2cb32ac0801200946v4a98d251h4cd04f1bdc447ff1@mail.gmail.com >, Anthony
McGarry <agtmcgarry@gmail.com> writes
>I downloaded the latest version 2.0.0. Installed and tested ok.
>I want to integrate with MySQL.
>
>However when I follow the procedure on the howto to create the radius db on
>mysql I run into a problem.

The HOWTO that you're using is out of date.

The SQL files are in raddb/sql/mysql - you need schema.sql. The other
two files are optional - use them if you need the features the tables
are for.


Best wishes,




David
--
David Wood
david@wood2.org.uk