On Feb 22, 6:17pm, Lars Marowsky-Bree wrote:
> Subject: (RADIATOR) Discrepancy between Start Stop records?
> Good morning,
>
> I am not actually sure if this is a problem with Radiator or my Maxen. But
>
> mysql> select count(*) from radius_acct where statustype='Start' \g
> | 21857 |
> mysql> select count(*) from radius_acct where statustype='Stop' \g
> | 23525 |
>
> does not make sense to me.
>
> I could understand that lost packets would lead to both numbers being roughly
> too low by the same percentage, and of course there are most likely always
> more Start records than Stop records (for those who are online).
>
> But this difference has accumulated within a few days after we started to use
> SQL logging. We authenticate from a file, and use ContinueAlways while having
> the SQL statement before the file.
>
> What reasons can I look into?
Hmmm, havent struck this one before.
I would try this:
1. Check in the Radiator log to see if you are getting any SQL errors or errors
that affect Starts rather than Stops.
2. Try to match up some cases where there is a Stop but no Start, and look for
a pattern, possibly try to match it with the Radiator log (you can determine
the time you should have got the missing Start from the details in the Stop
record, and then look in the radiator log for what might have happened at that
time.
>From that we might be able to deduce whether the Starts were received but
ignored, or whether they were never received at all.
Cheers.
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia Consulting and development
Phone, Fax: +61 3 9598-0985 http://www.open.com.au
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, external, etc etc etc on Unix, Win95, NT, Rhapsody
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
