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 [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.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
