Thanks David, that worked. Message: 6 Date: Sun, 20 Jan 2008 17:46:16 +0000 From: "Anthony McGarry" <[EMAIL PROTECTED]> Subject: MySQL To: [email protected] Message-ID: <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> Subject: Re: MySQL To: FreeRadius users mailing list <[email protected]> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain;charset=us-ascii;format=flowed Hi Anthony, In message <[EMAIL PROTECTED]>, Anthony McGarry <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
