Re: [Help-gnu-radius] A few unrelated (but not OT) questions

[Sergey Poznyakoff]

> That's what I was thinking :)  On that note, what if a user is
> connected for 2 months and status is still 1 (and rightfully so)?  

Then, the query would be

  DELETE FROM calls
  WHERE unix_timestamp(now())-unix_timestamp(event_date_time) > 2*31*86400
  AND status <> 1;


> Yes, question 3... is two parts.  /var/log/radius.log and
> /var/log/radius.info contain *almost* identical information by default,
> and I don't quite understand how to change this.
> One file with all info, logins, failed, emeg notices would be fine for
> my needs.

The following statement in raddb/config file will do the job:

logiing {
        channel default {
                file "radius.log";
                print-category yes;
                print-level yes;
        };
        category * {
                 channel default;
        };
};

> In the sql
> table, is there anyway to determine how long a user was online?

`acct_session_time' field in the default accounting table structure
keeps this information. So, in order to retrieve it:

  SELECT acct_session_time FROM calls WHERE acct_session_id = 'ID'
  AND status <> 1;

Regards,
Sergey