Hi I am new in radius, I want to use sql for accounting in freeradius. for creating tables of radius I use # 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. --------------------------------- Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV.
And the error is? Ivan Kalik Kalik Informatika ISP Dana 1/8/2007, "zahra bahar" <zahra_bahar@yahoo.com> piše:
Hi I am new in radius, I want to use sql for accounting in freeradius. for creating tables of radius I use # 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.
--------------------------------- Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV.
I send the error in my email. this error is: ERROR 1064(42000) at line 1:you have an error in your sql syntax,.. tnt@kalik.co.yu wrote: And the error is? Ivan Kalik Kalik Informatika ISP Dana 1/8/2007, "zahra bahar" pi¹e:
Hi I am new in radius, I want to use sql for accounting in freeradius. for creating tables of radius I use # 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.
--------------------------------- Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html --------------------------------- Shape Yahoo! in your own image. Join our Network Research Panel today!
USE : # mysql -u root -p < mysql.sql NOT : # mysql -u root -p > mysql.sql By; -----Message d'origine----- De : freeradius-users-bounces+wdg-tech=wanadoo.fr@lists.freeradius.org [mailto:freeradius-users-bounces+wdg-tech=wanadoo.fr@lists.freeradius.org]De la part de zahra bahar Envoyé : samedi 4 août 2007 06:05 À : FreeRadius users mailing list Objet : Re: freeradius and mysql I send the error in my email. this error is: ERROR 1064(42000) at line 1:you have an error in your sql syntax,.. tnt@kalik.co.yu wrote: And the error is? Ivan Kalik Kalik Informatika ISP Dana 1/8/2007, "zahra bahar" pi¹e: >Hi > I am new in radius, I want to use sql for accounting in freeradius. for creating tables of radius I use > # 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. > > >--------------------------------- >Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV. > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ---------------------------------------------------------------------------- -- Shape Yahoo! in your own image. Join our Network Research Panel today!
yes I had mistake in writing.I used # mysql -u root -p < mysql.sql but it has that error. wdg-tech@wanadoo.fr wrote: USE : # mysql -u root -p < mysql.sql NOT : # mysql -u root -p > mysql.sql By; -----Message d'origine----- De : freeradius-users-bounces+wdg-tech=wanadoo.fr@lists.freeradius.org [mailto:freeradius-users-bounces+wdg-tech=wanadoo.fr@lists.freeradius.org]De la part de zahra bahar Envoyé : samedi 4 août 2007 06:05 À : FreeRadius users mailing list Objet : Re: freeradius and mysql I send the error in my email. this error is: ERROR 1064(42000) at line 1:you have an error in your sql syntax,.. tnt@kalik.co.yu wrote: And the error is? Ivan Kalik Kalik Informatika ISP Dana 1/8/2007, "zahra bahar" pi¹e:
Hi I am new in radius, I want to use sql for accounting in freeradius. for creating tables of radius I use # 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.
--------------------------------- Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html --------------------------------- Shape Yahoo! in your own image. Join our Network Research Panel today! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html --------------------------------- Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out.
You have posted the beginning of the error statement (which is irrelevant) and left out the most important bit that comes after: "Check the manual that corresponds to your MySQL server version for the right syntax to use near" Script provided with the server doesn't have any errors. You have done something to it. You should also post the lines just before the line with the error (including the line with the error). Ivan Kalik Kalik Informatika ISP Dana 5/8/2007, "zahra bahar" <zahra_bahar@yahoo.com> piše:
yes I had mistake in writing.I used # mysql -u root -p < mysql.sql but it has that error.
wdg-tech@wanadoo.fr wrote: USE : # mysql -u root -p < mysql.sql
NOT : # mysql -u root -p > mysql.sql
By;
-----Message d'origine----- De : freeradius-users-bounces+wdg-tech=wanadoo.fr@lists.freeradius.org [mailto:freeradius-users-bounces+wdg-tech=wanadoo.fr@lists.freeradius.org]De la part de zahra bahar Envoyé : samedi 4 aoűt 2007 06:05 Ŕ : FreeRadius users mailing list Objet : Re: freeradius and mysql
I send the error in my email. this error is:
ERROR 1064(42000) at line 1:you have an error in your sql syntax,..
tnt@kalik.co.yu wrote: And the error is?
Ivan Kalik Kalik Informatika ISP
Dana 1/8/2007, "zahra bahar" piše:
Hi I am new in radius, I want to use sql for accounting in freeradius. for creating tables of radius I use # 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.
--------------------------------- Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
--------------------------------- Shape Yahoo! in your own image. Join our Network Research Panel today! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
--------------------------------- Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out.
Sorry, USE : # mysql -u root -p radius < mysql.sql and not : # mysql -u root -p > mysql.sql -----Message d'origine----- De : freeradius-users-bounces+wdg-tech=wanadoo.fr@lists.freeradius.org [mailto:freeradius-users-bounces+wdg-tech=wanadoo.fr@lists.freeradius.org]De la part de zahra bahar Envoyé : samedi 4 août 2007 06:05 À : FreeRadius users mailing list Objet : Re: freeradius and mysql I send the error in my email. this error is: ERROR 1064(42000) at line 1:you have an error in your sql syntax,.. tnt@kalik.co.yu wrote: And the error is? Ivan Kalik Kalik Informatika ISP Dana 1/8/2007, "zahra bahar" pi¹e: >Hi > I am new in radius, I want to use sql for accounting in freeradius. for creating tables of radius I use > # 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. > > >--------------------------------- >Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV. > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ---------------------------------------------------------------------------- -- Shape Yahoo! in your own image. Join our Network Research Panel today!
# 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@restena.lu Tel.: +352 424409-1 http://www.restena.lu Fax: +352 422473
On Wed 01 Aug 2007, zahra bahar wrote:
Hi I am new in radius, I want to use sql for accounting in freeradius. for creating tables of radius I use # mysql -u root -p > mysql.sql after entering password there is this error:
You are using the wrong pipe.. Use < instead
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.
http://wiki.freeradius.org/SQL_HOWTO -- Peter Nixon http://peternixon.net/
participants (5)
-
Peter Nixon -
Stefan Winter -
tnt＠kalik.co.yu -
wdg-tech＠wanadoo.fr -
zahra bahar