Thank you very much for your clarifications. I will think how to set up a test environment.
Thanks again. Irina ============== ----- Original Message ----- From: "Hugh Messenger" <[EMAIL PROTECTED]> To: "'FreeRadius users mailing list'" <freeradius-users@lists.freeradius.org> Sent: Thursday, July 12, 2007 4:44 PM Subject: RE: Interim-Updates > 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 > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html