(RADIATOR) Current Logged in Users

[Brian Morris]

Hi Shane - 

Just add this code to the bottom of your radius.cfg file (or whatever you call yours)

<SessionDatabase SQL>
   DBSource dbi:ODBC:RadiusLog
   DBUsername radiususer
   DBAuth radiususerpassword
</SessionDatabase>

Where :
- RadiusLog is your ODBC datasource setup for Radiator (you probably already have this for authentication and accounting - use the same one)
- radiususer is the SQL user account with access to the above datasource
- radiususerpassword is the above users password for accessing the SQL datasource

You should have/create a table within the above database called RADONLINE its structure and details can be found in the goodies section.  Use the suggested structure for now (that way you can accept the defaults) but you can add to it to record additional helpful info later if you want.

Regards,  Brian Morris



  ----- Original Message ----- 
  From: Shane Malden 
  To: Brian Morris 
  Sent: Monday, February 11, 2002 4:10 PM
  Subject: Re: (RADIATOR) Current Logged in Users


  Thanks for this. Do you use NT and SQL yourself or just know Radiator fairly well??  Do you have any sample code on how so get Radiator to log this information??

  Regards,
  Shane
    ----- Original Message ----- 
    From: Brian Morris 
    To: Shane Malden ; radiator at open.com.au 
    Sent: Monday, February 11, 2002 3:22 PM
    Subject: Re: (RADIATOR) Current Logged in Users


    If you are using an SQL back-end database, the RADONLINE table contains a fairly accurate list of all users currently online.

    When I say 'fairly accurate' - if your NAS fails to deliver a STOP record to radiator, the user will not be removed from the online users database.

      ----- Original Message ----- 
      From: Shane Malden 
      To: radiator at open.com.au 
      Sent: Monday, February 11, 2002 2:59 PM
      Subject: (RADIATOR) Current Logged in Users


      Does anyone know any simple way of seeing who is logged on, using the logs from Radiator? We do receive start and stops from our gear. We are running ver 2.19 on a NT Server. Any help would be appreciated.

      Regards,
      Shane
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20020212/fcce6c0d/attachment.html>