Irina said > I need to apply it according to this document > http://www.netexpertise.eu/en/FreeRadius/DailyAcct.html > > Could someone reply with simple yes/no answers? I am going to do it on a > life server. Please.
Firstly, I strongly recommend you set up a test copy of FR with its own test db, and work on that with a test client, before laying hands on your live server. Just my $0.02, but you could avoid a lot of pain and heartache that way. Might take an hour or so to set up, but worth the effort. > 1. Can I issue mysql queries while radius is running? Yes. > 2. Can I issue PROCEDURE queries at MYSQL prompt (including comments?), > or > should I save it to a file fist then run like > mysql -uroot -prootpass radius < sql.file Either. > 3. In the document > "Note Don't forget to redefine the delimiter before and after the > procedure or you'll get an error!" > Is it part of PROCEDURE sql statements. Or... not sure what it means > "to redefine the delimiter" The normal SQL command delimiter is the ;, but the stored procedures you will be defining use ; as an end of line delimiter. So before you enter the procedures, you have to tell MySQL to use something else as the command delimiter: mysql> delimiter ^ mysql> show tables^ +------------------+ | Tables_in_radius | ... then switch it back to ; when you are done. If you cat the commands from a file (as per your Q2), you'll need to add the delimiter command to the start of the file. > 4. In sql.conf file, do I replace only accounting_update_query > Why asking? There are other "_alt" queries. I don't need to touch them, > do > I? Nope. > Thank you for your help in advance. > Irina -- hugh - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
