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
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
Arlinelson Fernandes dos Santos wrote:
I saw this version and check the tables.sql, it has a few tables to create. You can get more tables by tables.sql from version 1.x.x, I don´t know why this new version comes with less table. Maybe only to update. I don´t know.
2.0.0 includes all of the schemas in raddb/sql/*. This is documented in the comments at the top of the sql.conf file. Is there another place it should be documented? Alan DeKok.
participants (4)
-
Alan DeKok -
Anthony McGarry -
Arlinelson Fernandes dos Santos -
David Wood