Hello Andrew -
I would like to see a trace 4 debug from Radiator showing a complete sequence
of access request, accounting start and accounting stop from your providers
proxy. Perhaps we can find some way to deal with the problem.
Note, however, that if you cannot reliably distinguish between sessions, then
it follows that you cannot have a reliable session database.
thanks
Hugh
On Tuesday 06 March 2001 21:00, Andrew Chant wrote:
> 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.
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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.
