Hi.
We have just purchased Radiator 3.0.
After evaluating 2.19 I installed ver 3.0 with no problems.
I am running Radiator on SunOS 5.8, Database is MS SQL Server 2000 on a
windows 2000 Server, and Im using Easysoft ODBC - ODBC Bridge. All database
activity works fine till now including <ClientListSQL>, <Authby SQL>,
<SessionDatabase SQL> and <AddressAllocator SQL>.
<Log SQL> works with a trace level of 3 but when trace is 4 or higher
Radiator stops responding.
Even kill <psid> does nothing I have to use kill -9 <psid>.
Is this a known bug?
Config file is as follows:
#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~
# Global /
#~~~~~~~~
Foreground
LogStdout
LogDir .
DbDir .
# Put trace level to 4 sothat all logs can be sent to SQL !!
Trace 4
# List NAS-Clients in DB
<ClientListSQL>
include %D/ODBCconn.inc
GetClientQuery exec GetClientList
</ClientListSQL>
#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~
# IP Pool Defenition /
#~~~~~~~~~~~~~~~~~~~
<AddressAllocator SQL>
# This name allows us to refer to it from inside an AuthBy DYNADDRESS
Identifier IPAllocator
# DB Connection goes here
include %D/ODBCconn.inc
<AddressPool Pool1>
Subnetmask 255.255.255.0
Range 10.201.0.0 10.201.0.10
</AddressPool>
<AddressPool Pool2>
Subnetmask 255.255.255.0
Range 10.201.1.128 10.201.1.138
</AddressPool>
<AddressPool Pool3>
Subnetmask 255.255.255.0
Range 10.201.1.64 10.201.1.74
</AddressPool>
</AddressAllocator>
#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~
# Handlers start here /
#~~~~~~~~~~~~~~~~~~~~~
#Handler for Multilink for NAS-Port-Type 5, used for multilink connections
<Handler NAS-Port-Type=5>
AuthByPolicy ContinueWhileAccept
<AuthBy SQL>
# Adjust DBSource, DBUsername, DBAuth to suit your DB
include %D/ODBCconn.inc
# Default reply attributes
AddToReplyIfNotExist User-Service-Type = Framed-User, Framed-Protocol =
PPP, Framed-Routing = None, Framed-Compression = Van-Jacobsen-TCP-IP,
Framed-Filter-Id = "prot.out", Framed-MTU = 1500, Idle-Timeout = 1200,
Port-Limit = 1, Port-Message = "DYNPPP\r\n\n\rNow you are connected ..."
# Do not check for default
NoDefault
# Lets use our own stored procedure instead of a default query
AuthSelect exec AuthUsr @login=%0
</AuthBy>
# dont give an IP for second link.
StripFromReply PoolHint
</Handler> #NAS-Port-Type 5
#Handler for Dynamic IPS for all Dialups
<Handler NAS-Address-Port-List=./portlist>
AuthByPolicy ContinueWhileAccept
<AuthBy SQL>
# Adjust DBSource, DBUsername, DBAuth to suit your DB
include %D/ODBCconn.inc
# Default reply attributes
# Dont include Framed-Address = 255.255.255.254, Framed-Netmask =
255.255.255.255
# .. this is assigned dynamicly from DB
AddToReplyIfNotExist User-Service-Type = Framed-User, Framed-Protocol =
PPP, Framed-Routing = None, Framed-Compression = Van-Jacobsen-TCP-IP,
Framed-Filter-Id = "prot.out", Framed-MTU = 1500, Idle-Timeout = 1200,
Port-Limit = 1, Port-Message = "DYNPPP\r\n\n\rNow you are connected ..."
# Do not check for default
NoDefault
# Lets use our own stored procedure instead of a default query
AuthSelect exec AuthUsr @login=%0
</AuthBy>
<AuthBy DYNADDRESS>
# This refers to the AddressAllocator to use
Allocator IPAllocator
# Use a PoolHint to define which IP Pool to use. (not used in this case)
#PoolHint TestPool1
# These parameters tell us how to set reply attribtues from the result of
the allocation.
MapAttribute yiaddr, Framed-Address
MapAttribute subnetmask, Framed-Netmask
# The AuthBy block above sets the pseudo reply attribute
# PoolHint as the clue to the address allocator need to strip it out at the
end of processing
StripFromReply PoolHint
</AuthBy>
</Handler> #NAS-Address-Port-List=./portlist
#Default handler for all requests
<Handler>
<AuthBy SQL>
# Adjust DBSource, DBUsername, DBAuth to suit your DB
include %D/ODBCconn.inc
# You can arrange to log accounting to a file if the
# SQL insert fails with AcctFailedLogFileName
# That way you could recover from a broken SQL server
AcctFailedLogFileName %D/missedaccounting
# Default reply attributes
AddToReplyIfNotExist User-Service-Type = Framed-User, Framed-Protocol =
PPP, Framed-Address = 255.255.255.254, Framed-Netmask = 255.255.255.255,
Framed-Routing = None, Framed-Compression = Van-Jacobsen-TCP-IP,
Framed-Filter-Id = "prot.out", Framed-MTU = 1500, Idle-Timeout = 1200,
Port-Limit = 1, Port-Message = "DYNPPP\r\n\n\rNow you are connected ..."
# Do not check for default
NoDefault
# Lets try our own stored procedure instead of a default query
AuthSelect exec AuthUsr @login=%0
# Lets try our own stored procedure to keep track of who is online
AcctSQLStatement exec AcctStatus @USERNAME='%u', @NASIDENTIFIER='%N',
@NASPORT=0%{NAS-Port}, @ACCTSESSIONID='%{Acct-Session-Id}',
@ACCTSTATUSTYPE='%{Acct-Status-Type}', @TIME_STAMP=%{Timestamp},
@FRAMEDIPADDRESS='%{Framed-IP-Address}'
</AuthBy>
</Handler> #Default
#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~
# Session Database /
#~~~~~~~~~~~~~~~~~~
# Use sql for current Sessions and online pool!
<SessionDatabase SQL>
include %D/ODBCconn.inc
AddQuery exec SessionAdd @USERNAME='%u', @NASIDENTIFIER='%N',
@NASPORT=0%{NAS-Port}, @ACCTSESSIONID='%{Acct-Session-Id}',
@TIME_STAMP=%{Timestamp}, @FRAMEDIPADDRESS='%{Framed-IP-Address}',
@NASPORTTYPE='%{NAS-port-Type}', @SERVICETYPE='%{Service-Type}'
DeleteQuery exec SessionDel @NASIDENTIFIER='%N', @NASPORT=0%{NAS-Port}
ClearNasQuery exec SessionClearNAS @NASIDENTIFIER='%N'
CountQuery exec SessionCnt @USERNAME='%u'
</SessionDatabase>
#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~
# Log Database /
#~~~~~~~~~~~~~~
<Log SQL>
include %D/ODBCconn.inc
Table RADLOG
Trace 4
LogQuery insert into %3 (TIME_STAMP, PRIORITY, MESSAGE) values (%t, %0, %2)
</Log>
# End of config.
GX
[EMAIL PROTECTED]
(George Charalambous)
SpiderNet Services LTD.
===
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.
