freeradius and mysql

[Stefan Winter]

> # mysql -u root -p > mysql.sql
>  after entering password there is this error:
>
>  ERROR 1064(42000) at line 1:you have an error in your sql syntax,.......
>   use the ql.sal rlm_sql Freeradius sql module.
>
>  I don't know the reason of this error.

You want to feed the commands from the file mysql.sql to the mysql command? 
Then you must use <, not >. I.e.:

mysql -u root -p < mysql.sql

Also, IIRC the mysql.sql script does only create the tables, not the database 
itself. So, first create a database called "radius", and then make your 
client use this database to execute the commands:

mysql -u root -p radius < mysql.sql

Greetings,

Stefan Winter

-- 
Stefan WINTER

Stiftung RESTENA - Réseau Téléinformatique de l'Education Nationale et de 
la Recherche
Ingenieur Forschung & Entwicklung

6, rue Richard Coudenhove-Kalergi
L-1359 Luxembourg
E-Mail: stefan.winter at restena.lu     Tel.:     +352 424409-1
http://www.restena.lu                Fax:      +352 422473
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070801/c631e77f/attachment.pgp>