(RADIATOR) Unknown keyword 'AddATDefaults' in C:\Program Files\Radiator\radius.cfg
Hugh Irvine
hugh at open.com.au
Sat Nov 25 01:36:36 CST 2006
Hello Adrian -
As mentioned previously you can only use AddATDefaults and
TimeBanking in an AuthBy EMERALD clause, not in an AuthBy SQL clause.
See section 5.33 in the Radiator 3.16 reference manual for details.
regards
Hugh
On 24 Nov 2006, at 23:14, Adrian Jones wrote:
> Hugh
>
> Thanks for your reply. It was information I knew already.
>
> I really need to know how to get the new radius server to
> acknowledge the AddATDefaults, and TimeBanking keywords; the old
> one is doing it fine and I have used all the same files, even the
> same database, and the same Perl installation. I don't know what
> could be different.
>
> I paste my radius.cfg below:
>
> ######################################################################
> ############
> #
> # Startup Options:
> # Client Options :
> #
> ######################################################################
> ############
> #Foreground
> AuthPort 1645
> AcctPort 1646
> LogStdout
> LogDir c:/Program Files/Radiator
> DbDir c:/Program Files/Radiator
> LogFile %L/%Y-%m/debugLog %d-%q.txt
> Trace 3
>
>
> <Client x.x.x.x>
> DupInterval 1
> Secret axaxaxax
> </Client>
> ######################################################################
> ############
> #
> # Dynamic Address Allicator
> #
> # Wireless Client End Address's
> # Different Pools are for the different Bandwidth Tears.
> #
> ######################################################################
> ############
> <Realm DEFAULT>
> RewriteUsername s/^.*\\|@.*$|^\s+|\s+$//g #Strip
> Leading and trailing shit
> RewriteUsername tr/A-Z/a-z/ #Convert
> Upper to Lower case
> AuthByPolicy ContinueWhileAccept
> RejectHasReason
> PostAuthHook file:"c:/Program Files/Radiator/handle_users"
>
> <AuthLog SQL>
> DBSource dbi:ODBC:Emerald
> DBUsername
> DBAuth
> Table radlogs
> FailureQuery INSERT into RadLogs
> (RadLogMsgID,LogDate,Username,Data,NASIdentifier,NASport,CallerID)
> values (%1,GETDATE(),'%n','%P','%N','%{NAS-Port}','%{Calling-
> Station-Id}')
> </AuthLog>
>
> <AuthBy SQL>
>
> DBSource dbi:ODBC:Emerald
> DBUsername
> DBAuth
>
> NoDefault
> NoDefaultIfFound
> CaseInsensitivePasswords
> AuthSelect select DateAdd(Day, sa.extension, saExpireDate),
> sa.AccountID, sa.AccountType, \
> sa.password, sa.login, sa.TimeLeft, sa.LoginLimit \
> from masteraccounts ma, subaccounts sa \
> where sa.login = %0 \
> and ma.customerid = sa.customerid \
> and sa.active <> 0 and ma.active <> 0
>
> AuthColumnDef 0, Expiration, check
> AuthColumnDef 3, User-Password, check
> AuthColumnDef 5, Session-Timeout, reply
> AuthColumnDef 6, Simultaneous-Use, check
> AccountingTable ACCOUNTING
> AcctColumnDef USERNAME,User-Name
> AcctColumnDef TIME_STAMP,Timestamp,integer
> AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
> 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-IP-Address
> AcctColumnDef NASPORT,NAS-Port,integer
> AcctColumnDef FRAMEDIPADDRESS,Framed-Address
> AcctColumnDef FramedIPAddress,Framed-IP-Address
> AcctColumnDef CallerID,Calling-Station-Id
> AcctColumnDef ConnectInfo,Connect-Info
> AcctColumnDef ConnectInfo,Ascend-Xmit-Rate
> AddATDefaults
> TimeBanking
>
> HandleAcctStatusTypes Start
> AcctSQLStatement \
> update SubAccounts \
> set First_Use = getdate() \
> where Login like 'tic%' \
> and login = '%n' \
> and '%{Acct-Status-Type}' = 'Start' \
> and First_Use is NULL
>
>
>
> HandleAcctStatusTypes Stop
> AcctSQLStatement \
> update SubAccounts \
> set TimeLeft=TimeLeft- 0%{Acct-Session-Time}\
> where login='%n' \
> and %{Acct-Delay-Time} = 0 \
> and '%{Acct-Status-Type}' = 'Stop' \
> and TimeLeft > 0
> </AuthBy>
>
> <SessionDatabase SQL>
> DBSource dbi:ODBC:Emerald
> DBUsername sa
> DBAuth
>
> AddQuery insert into RADONLINE (UserName,
> SessionId,TimeStart,NASIPAddress,FramedIPAddress,NasPort,NASPortType,C
> LI,NASIdentifier, ConnectInfo) values \
> ('%n','%{Acct-Session-Id}',GETDATE(),'%{NAS-IP-Address}','%
> {Framed-IP-Address}','%{NAS-Port}','%{NAS-Port-Type}','%{Calling-
> Station-Id}','%N', '%{Connect-Info}')
> DeleteQuery delete from RADONLINE where NasPort='%{NAS-Port}' and
> NASIdentifier='%N'
> ClearNasQuery delete from RADONLINE where NASIdentifier='%N'
> CountQuery select NASIdentifier, NasPort, SessionID from
> RADONLINE where UserName='%n'
> </SessionDatabase>
> </Realm>
>
>
> Regards,
>
>
> Adrian Jones
> System Analyst/Programmer
> TeleBarbados Inc.
> 6th Floor CGI Towers
> Warrens, St. Michael,
> Barbados
> Tel: (246) 421-9250 ext 730
> Email: ajones at telebarbados.com
> Website: www.telebarbados.com
>
>
> From: Hugh Irvine [mailto:hugh at open.com.au]
> Sent: Thu 11/23/2006 8:48 AM
> To: Adrian Jones
> Cc: radiator at open.com.au
> Subject: Re: (RADIATOR) Unknown keyword 'AddATDefaults' in C:
> \Program Files\Radiator\radius.cfg
>
>
> Hello Adrian -
>
> The AddATDefaults parameter is only for use in an AuthBy EMERALD
> clause.
>
> I will need to see a copy of your configuration file to say any more.
>
> BTW - the most recent version of Radiator is 3.16.
>
> regards
>
> Hugh
>
>
> On 24 Nov 2006, at 00:53, Adrian Jones wrote:
>
> > Hi
> >
> > I have a radiator 3.7.1 installation on windows 2000 server.
> >
> > I wish to install same on a new machine so we can phase out the old
> > one.
> >
> > When I complete the installation on the new machine, the following
> > messages are present in the log file:
> >
> > Thu Nov 23 09:05:41 2006: ERR: Unknown keyword 'AddATDefaults' in C:
> > \Program Files\Radiator\radius.cfg line 248
> > Thu Nov 23 09:05:41 2006: ERR: Unknown keyword 'TimeBanking' in C:
> > \Program Files\Radiator\radius.cfg line 249
> > Thu Nov 23 09:05:41 2006: NOTICE: Server started: Radiator 3.7.1 on
> > myradius
> > If I restart the old radius server, it gives the notice as
> > expected, but not the 2 error messgaes.
> >
> > I want to incorporate information from the RadATConfigs table which
> > I understand is signalled by 'AddATDefaults' keyword.
> >
> > I cannot figure out how to have the new installation correctly
> > acknowledge the 'AddATDefaults' keyword. Assistance would be
> > greatly appreciated.
> >
> > Regards,
> >
> > Adrian Jones
> > System Analyst/Programmer
> > TeleBarbados Inc.
> > 6th Floor CGI Towers
> > Warrens, St. Michael,
> > Barbados
> > Tel: (246) 421-9250 ext 730
> > Email: ajones at telebarbados.com
> > Website: www.telebarbados.com
> >
>
>
>
> NB:
>
> Have you read the reference manual ("doc/ref.html")?
> Have you searched the mailing list archive (www.open.com.au/archives/
> radiator)?
> Have you had a quick look on Google (www.google.com)?
> Have you included a copy of your configuration file (no secrets),
> together with a trace 4 debug showing what is happening?
>
> --
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows, MacOS X.
> Includes support for reliable RADIUS transport (RadSec),
> and DIAMETER translation agent.
> -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence.
> -
> CATool: Private Certificate Authority for Unix and Unix-like systems.
>
>
NB:
Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/
radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.
--
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