(RADIATOR) Handler working now.... but ;-)

[Skeeve Stevens]

Ok.. With the awesome help of Hugh my handler is working fine.

But.....  my SessionDatabase is still getting both accounting data.

Can I move the below into the main <Handler> or is there something else to address this?



#This keeps track of who is online
<SessionDatabase SQL>
        Identifier SDB1
        DBSource dbi:mysql:x:x
        DBUsername radius
        DBAuth t3ch3xAuTh

        AddQuery insert into online (acct_handle,nas_id,online_nasport,online_sessionid,online_date,online_ipaddress,online_servicetype,online_calling_station,online_called_station,online_key) values ('%n','%N','%{NAS-Port}','%{Acct-Session-Id}',from_unixtime(%{Timestamp}),'%{Framed-IP-Address}','%{Service-Type}','%{Calling-Station-Id}','%{Called-Station-Id}','%{Ascend-Session-Svr-Key}')

        DeleteQuery delete from online where acct_handle = '%n' and nas_id = '%N' and online_nasport = %{NAS-Port}

        ClearNasQuery delete from online where nas_id = '%N'

        CountQuery select nas_id,online_nasport,online_sessionid from online where acct_handle = '%n'
</SessionDatabase>




-- 
     ---------------------------------------------------------------------
    | Skeeve Stevens                          url: http://www.skeeve.org/ |
    | email://skeeve@skeeve.org/          url: http://www.eIntellego.org/ |
     ---------------------------------------------------------------------
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.