Re: radsqlrelay questions

2005-03-07 Thread Nicolas Baradakis
[EMAIL PROTECTED] wrote:

 3. if the radsqlrelay process dies (or i kill -9 it) - after
 restarting it - all the data in the detail-file will processed
 again

You're right. At startup radsqlrelay sends the detail-file from the
beginning, but perhaps some records were already in the database...

I understand you don't want to duplicate records in the database, but
killing radsqlrelay from time to time is not something you usually do.

Of course, patches are welcome.

-- 
Nicolas Baradakis

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: radsqlrelay questions

2005-03-06 Thread Kostas Kalevras
On Sun, 6 Mar 2005 [EMAIL PROTECTED] wrote:
hi all,
i've tested radsqlrelay for moving big acct-logs (detail-file) into my
database - and have read the comments about the code:
1. is it possibile to (log-)rotate the detail-file - when radsqlrelay is
running - and read it ?
Why? The idea is that the detail will not grow unless there is a problem in the 
receiving end. Even then radsqlrelay should be the one handling the problem not 
logrotate.

2. i've read about the .work file - but couldn't see it. will it only
created, if the rlm_detail want write to the detail-file ?
It will be created when radsqlrelay reaches the end of the detail file and still 
has outstanding accounting requests unacknowledged if i remember correctly.

3. if the radsqlrelay process dies (or i kill -9 it) - after restarting it -
all the data in the detail-file will processed again
what could be a solution for this problems ?
None at this point. Usually there will only be detail.work to process and only 
new records in the detail file though. Maybe radsqlrelay could print out (or 
store in a file) the detail file offset it was working on before it ends (on a 
KILL signal). There's not much you can do on a -9 signal though, unless you 
write the file offset somewhere all the time.

thx4allinfos,joachim
--
DSL Komplett von GMX +++ Supergnstig und stressfrei einsteigen!
AKTION Kein Einrichtungspreis nutzen: http://www.gmx.net/de/go/dsl
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED]   National Technical University of Athens, Greece
Work Phone: +30 210 7721861
'Go back to the shadow' Gandalf