Interim-Updates

[Irina]

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" <hugh at alaweb.com>
To: "'FreeRadius users mailing list'"
<freeradius-users at 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
>