Interim-Updates

[Hugh Messenger]

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