(RADIATOR) Ascend SNMP Problems
Leon Oosterwijk
leon at isdn.net
Wed Aug 29 08:46:51 CDT 2001
Hugh,
Please help me in trying to setup the SNMP Pull with the non-rewritten
username. I've altered the config for my session db to store both versions
of the username. Following is the session Database as it is defined in our
configuration. Where do I change the behaviour of RADIATOR to use the
non-rewritten username for NAS-SNMP checks?
Leon
#*******************************************************************
#*******************************************************************
# SESSIONS Database holds the sessions for all the users
# /usr/local/bin/Radius-Session-DBCheck.pl removes stale entries
#*******************************************************************
#*******************************************************************
<SessionDatabase SQL>
Identifier sessiondb
DBSource dbi:mysql:radadmin:host=host.isdn.net
DBUsername username
DBAuth password
AddQuery insert into RADONLINE (RRUSERNAME, USERNAME,
NASIDENTIFIER, NASPORT, \
ACCTSESSIONID, FRAMEDIPADDRESS, NASPORTTYPE, \
SERVICETYPE, DNIS, CALLINGSTATIONID, TIME_STAMP)
values ('%U', '%u', '%N', %{NAS-Port}, \
'%{Acct-Session-Id}',
'%{Framed-IP-Address}', '%{Port-Type}', '%{Framed-Protocol}', \
'%{Called-Station-Id}', '%{Calling-Station-Id}',
'%{Timestamp}' )
DeleteQuery delete from RADONLINE where USERNAME='%u' and \
NASIDENTIFIER='%N' and NASPORT='%{NAS-Port}'
ClearNasQuery delete from RADONLINE where NASIDENTIFIER='%N'
CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from \
RADONLINE where USERNAME='%u'
# The OLD query:
#select nasid, slotitem, sessionid from ses4web where
username='%u'
</SessionDatabase SQL>
-----Original Message-----
From: Hugh Irvine [mailto:hugh at open.com.au]
Sent: Tuesday, August 28, 2001 6:50 PM
To: Leon Oosterwijk; 'radiator at open.com.au'
Subject: Re: (RADIATOR) Ascend SNMP Problems
Hello Leon -
You don't show the session database that you are using, but the problem is
because you are doing a RewriteUsername and the rewritten username is being
used to check against the NAS (which of course won't work).
The usual way to deal with this problem is to use an SQL session database
and
store both the original username and the rewritten username therein with
your
own queries. That way you can use the rewritten username for simultaneous
use
limit checking, and the original username for checking with the NAS.
regards
Hugh
===
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.
More information about the radiator
mailing list