(RADIATOR) MaxSession

[Hugh Irvine]

Hello Adam -

I will need to see a trace 4 debug from Radiator showing what is happening, 
and I will need a detailed description of the problem.

thanks

Hugh

On Monday 04 June 2001 20:03, Mohammed Adam wrote:
> Hi all
>
> i'm facing a problem with Maxsessions, it doesnt work the following is my
> Radius config file
>
> #
>
> Foreground
> LogStdout
> LogDir		.
> DbDir		.
> DictionaryFile d:\radiator-demo-2.18\dictionary.cisco
> Trace 4
>
> # For testing: this allows us to honour requests from radpwtst
> # on the same host.
> <Client localhost>
> 	Secret mysecret
> 	DupInterval 300
> </Client>
> #<Client X>
> #	Secret mysecret
> #	DupInterval 300
> #</Client>
>
> <SessionDatabase SQL>
>
>
> 	#Identifier 	OnlineUsers
> 	DBSource	dbi:ODBC:MDBTest
> 	DBUsername
> 	DBAuth
> 	AddQuery	insert into RADONLINE \
>
>
> 	(USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
> FRAMEDIPADDRESS, #NASPORTTYPE, SERVICETYPE, CALLEDSID) \ values \
> 	('%n', '%N', %{NAS-Port}, '%{Acct-Session-Id}', %{Timestamp},
> #'%{Framed-IP-Address}', '%{Port-Type}', '%{Service-Type}',
> '%{Called-Station-Id}')
>
> </SessionDatabase>
>
> <Realm>
>
> #-----------------------------------------------------------------------
> #
> # This is for Aythenticating Authorizing and Accounting the hourly users
> #
> #-----------------------------------------------------------------------
>
>
> #------------------------------------
>
> 	MaxSessions 1
> 	AuthByPolicy ContinueUntilAccept
>
> 	<AuthBy SQL>
> 		# Change DBSource, DBUsername, DBAuth for your database
> 		# See the reference manual
> 		DBSource	dbi:ODBC:MDBTest
> 		DBUsername
> 		DBAuth
>
> 		AccountingStopsOnly
> 		AccountingTable	Accounting
> 		AcctColumnDef	UserName,User-Name
> 		AcctColumnDef	CallDate,Timestamp,integer-date
> 		AcctColumnDef	AcctStatusType,Acct-Status-Type,integer
> 		AcctColumnDef	AcctDelayTime,Acct-Delay-Time,integer
> 		AcctColumnDef	AcctInputOctets,Acct-Input-Octets,integer
> 		AcctColumnDef	AcctOutputOctets,Acct-Output-Octets,integer
> 		AcctColumnDef	AcctSessionId,Acct-Session-Id
> 		AcctColumnDef	AcctSessionTime,Acct-Session-Time,integer
> 		AcctColumnDef	AcctTerminateCause,Acct_Terminate-Cause
> 		AcctColumnDef	NASIdentifier,NAS-Identifier
> 		AcctColumnDef	NASIdentifier,NAS-IP-Address
> 		AcctColumnDef	NASPort,NAS-Port,integer
>
> 		# You can use this to force Radiator to limit
> 		# maximum session times to how many minutes
> 		# are left in subaccounts.timeleft
>
> #		AcctSQLStatement update Authentication set BalanceTime =
> (BalanceTime)-0%{Acct-Session-Time}, \ AcctSQLStatement update
> Authentication set %Q = %Q-0%{Acct-Session-Time} \ #, Last = '%Q' \
> 						where USERNAME = '%n' \
> 						And Type = 'H'
>
> 		#
> 	</AuthBy>
>
>
>
> 	<AuthBy SQL>
> 		# Change DBSource, DBUsername, DBAuth for your database
> 		# See the reference manual
> 		DBSource	dbi:ODBC:MDBTest
> 		DBUsername
> 		DBAuth
>
> 		AuthSelect select Password from Authentication where USERNAME='%n' And
> Type='P'and ExpiryDate > now()
>
> 		AuthColumnDef	0,Password,check
> 		#AuthColumnDef	1,Session-Timeout,reply
> 		AddToReply		Service-Type = Framed,Framed-Protocol = PPP
> 	#	#DefaultReply Service-Type = Framed,Framed-Protocol = PPP
> 		# You can add to or change these if you want.
>
> 	</AuthBy>
>
> 	<AuthBy SQL>
> 		# daily control
> 		# Change DBSource, DBUsername, DBAuth for your database
> 		# See the reference manual
> 		DBSource	dbi:ODBC:MDBTest
> 		DBUsername
> 		DBAuth
> 		#AuthSelect select Password, %Q from Authentication where USERNAME='%n'
> And %Q > 0 And Type='H'  And Last <> '%Q' And ThursdayFrom < %H AuthSelect
> select Password, %Q from Authentication where USERNAME='%n' And %Q > 0 And
> Type='H'  And %QFrom < %H  And %QTo > %H and (IP1=%{NAS-Port} or (IP1=0 and
> IP2=0) or IP2=%{NAS-Port})
>
>
> 		AuthColumnDef	0,Password,check
> 		AuthColumnDef	1,Session-Timeout,reply
> 		AddToReply	Service-Type = Framed,Framed-Protocol = PPP
> 	</AuthBy>
>
> </Realm>
>
>
>
> Thanks all
>
> ===
> 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.

-- 
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.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.