Hi,
I am Using Radiator with a MySQL Session Database.
What I am finding is that there seems to be calls being left in the
session database after they have finished, and therefore staying there
forever. The accounting database shows the sesion has ended, so RADIUS
packets are getting through from the proxy.
I have had to make a few minor changes to the default session database
settings to account for slight differences in our system. Normaly a call
can be uniquely identified by the NAS IP and port. My data comes through
my providers proxy, and Multiple NASes work through a single home gateway,
so the NAS IP Address field is always the home gateway IP address, so now
I cannot uniquely identify each call with these values. I think this is
half of the problem. You can see my fix attempts in the config inserted
below;
=======
<SessionDatabase SQL>
AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT,
ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE,
CALLEDSTATIONID, CALLINGSTATIONID) values ('%u', '%N', '0%{NAS-Port}',
'%{Acct-Session-Id}', %{Timestamp}, '%{Framed-IP-Address}',
'%{NAS-Port-Type}', '%{Service-Type}', '%{Called-Station-Id}',
'%{Calling-Station-Id}')
ClearNasQuery delete from RADONLINE where NASIDENTIFIER='%N'
CountNasSessionsQuery select ACCTSESSIONID from RADONLINE where
NASIDENTIFIER='%N'
CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from RADONLINE
where USERNAME='%u'
DBAuth VuQEu7Tw
DBSource DBI:mysql:radius
DBUsername root
DeleteQuery delete from RADONLINE where NASIDENTIFIER='%N' and
NASPORT='0%{NAS-Port}' and USERNAME='%u'
Description show sessions
Identifier mysqlsess
</SessionDatabase>
======
If anyone has any sugestions I'd be grateful.
Andrew
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
