(RADIATOR) Radiator - Config & results
Hugh Irvine
hugh at open.com.au
Sat Jun 14 01:08:08 CDT 2008
Hello -
Can you please tell me the name of the registered company that has
purchased this copy of Radiator?
Please reply to me directly.
In answer to your question, you need to specify the AcctColumnDef's
you need.
See section 5.29.16 and 5.29.19 in the Radiator 4.2 reference manual
("doc/ref.pdf").
regards
Hugh
On 14 Jun 2008, at 14:13, Goboxe wrote:
>
> Hi,
>
> I need your help to verify that I am in the right track for
> Radiator installation on Windows 2003 & using PostgreSQL.
>
> I have 3 observations below, pls scroll down.
>
> 1. Below is my radiator.cfg
>
> #---------------------------------------------------------------------
> -------------------------------
> # windows.cfg
> #
> # Example Radiator configuration file.
> # This very simple file will allow you to get started with
> # a simple system on Windows. You can then add and change features.
> # We suggest you start simple, prove to yourself that it
> # works and then develop a more complicated configuration.
> #
> # This example is expected to be installed in
> # c:\Program Files\Radiator\radius.cfg
> # It will authenticate from a standard users file in
> # c:\Program Files\Radiator\users
> # it will log debug and other messages to
> # c:\Program Files\Radiator\logfile
> # and log accounting to a file in
> # c:\Program Files\Radiator\detail
> # (of course you can change all these by editing this config file
> if you wish)
> #
> # It will accept requests from any client and try to handle requests
> # for any realm.
> # And it will print out what its doing in great detail to the log
> file.
> #
> # See radius.cfg for more complete examples of features and
> # syntax, and refer to the reference manual for a complete description
> # of all the features and syntax.
> #
> # You should consider this file to be a starting point only
> # $Id: windows.cfg,v 1.1 2003/03/27 09:41:28 mikem Exp $
> Foreground
> LogStdout
> LogDir c:/Program Files/Radiator
> DbDir c:/Program Files/Radiator
> # This will log at DEBUG level: very verbose
> # User a lower trace level in production systems, typically use 3
> Trace 4
> # You will probably want to add other Clients to suit your site,
> # one for each NAS you want to work with. This will work
> # at least with radpwtst running on the local machine
> <Client DEFAULT>
> Secret mysecret
> DupInterval 0
> </Client>
>
> # Authenticate all realms with this
> <Realm DEFAULT>
> <AuthBy SQL>
> DBSource dbi:Pg:dbname=radiator
> DBUsername sa
> DBAuth vision2020
> AuthSelect select PASSWORD from SUBSCRIBERS \
> where USERNAME=%0
> # store accounting records in RADUSAGEyyyymm table
> AccountingTable ACCOUNTING
> # maybe update if this is a duplicate
> AcctInsertQuery update or insert into %0 (%1) values (%2)
> # Log all accounting to a single log file in LogDir
> AcctFailedLogFileName %L/misseddetails
>
> </AuthBy>
> </Realm>
>
>
> 2. Next, I run "perl radpwtst -user mikem -password frjhjlkhlo" and
> got the log below.
> I still wondering why I do not see any SQL statement like SELECT,
> INSERT in the log.
>
>
> Sat Jun 14 02:53:19 2008: DEBUG: Finished reading configuration
> file 'C:\Program Files\Radiator\radius.cfg'
> Sat Jun 14 02:53:19 2008: DEBUG: Reading dictionary file 'c:/
> Program Files/Radiator/dictionary'
> Sat Jun 14 02:53:19 2008: DEBUG: Creating authentication port
> 0.0.0.0:1645
> Sat Jun 14 02:53:19 2008: DEBUG: Creating accounting port 0.0.0.0:1646
> Sat Jun 14 02:53:19 2008: NOTICE: Server started: Radiator 4.2 on
> MYCBJ01T600022 (LOCKED)
> Sat Jun 14 02:53:53 2008: DEBUG: Packet dump:
> *** Received from 127.0.0.1 port 2471 ....
> Code: Accounting-Request
> Identifier: 154
> Authentic: d<241><165><201>{<197><214>W+<234>d<27>WT<145>]
> Attributes:
> User-Name = "mikem"
> Service-Type = Framed-User
> NAS-IP-Address = 203.63.154.1
> NAS-Identifier = "203.63.154.1"
> NAS-Port = 1234
> NAS-Port-Type = Async
> Acct-Session-Id = "00001234"
> Acct-Status-Type = Start
> Called-Station-Id = "123456789"
> Calling-Station-Id = "987654321"
> Acct-Delay-Time = 0
> Sat Jun 14 02:53:53 2008: DEBUG: Handling request with Handler
> 'Realm=DEFAULT'
> Sat Jun 14 02:53:53 2008: DEBUG: Adding session for mikem,
> 203.63.154.1, 1234
> Sat Jun 14 02:53:53 2008: DEBUG: Handling with Radius::AuthSQL:
> Sat Jun 14 02:53:53 2008: DEBUG: Handling accounting with
> Radius::AuthSQL
> Sat Jun 14 02:53:53 2008: DEBUG: AuthBy SQL result: ACCEPT,
> Sat Jun 14 02:53:53 2008: DEBUG: Accounting accepted
> Sat Jun 14 02:53:53 2008: DEBUG: Packet dump:
> *** Sending to 127.0.0.1 port 2471 ....
> Code: Accounting-Response
> Identifier: 154
> Authentic: d<241><165><201>{<197><214>W+<234>d<27>WT<145>]
> Attributes:
> Sat Jun 14 02:53:53 2008: DEBUG: Packet dump:
> *** Received from 127.0.0.1 port 2471 ....
> Code: Accounting-Request
> Identifier: 155
> Authentic:
> <27><225><9><214><29><254><200><247><197><172><195>'9<186>"<166>
> Attributes:
> User-Name = "mikem"
> Service-Type = Framed-User
> NAS-IP-Address = 203.63.154.1
> NAS-Identifier = "203.63.154.1"
> NAS-Port = 1234
> NAS-Port-Type = Async
> Acct-Session-Id = "00001234"
> Acct-Status-Type = Stop
> Called-Station-Id = "123456789"
> Calling-Station-Id = "987654321"
> Acct-Delay-Time = 0
> Acct-Session-Time = 1000
> Acct-Input-Octets = 20000
> Acct-Output-Octets = 30000
> Sat Jun 14 02:53:53 2008: DEBUG: Handling request with Handler
> 'Realm=DEFAULT'
> Sat Jun 14 02:53:53 2008: DEBUG: Deleting session for mikem,
> 203.63.154.1, 1234
> Sat Jun 14 02:53:53 2008: DEBUG: Handling with Radius::AuthSQL:
> Sat Jun 14 02:53:53 2008: DEBUG: Handling accounting with
> Radius::AuthSQL
> Sat Jun 14 02:53:53 2008: DEBUG: AuthBy SQL result: ACCEPT,
> Sat Jun 14 02:53:53 2008: DEBUG: Accounting accepted
> Sat Jun 14 02:53:53 2008: DEBUG: Packet dump:
> *** Sending to 127.0.0.1 port 2471 ....
> Code: Accounting-Response
> Identifier: 155
> Authentic:
> <27><225><9><214><29><254><200><247><197><172><195>'9<186>"<166>
> Attributes:
>
>
> 3. After that, I check PostgreSQL log and only see the following
> entry which I believe call from Radiator.
> And still wondering why no new records created in Accounting table
>
> 2008-06-14 02:56:24 LOG: statement: SELECT count(*) FROM
> public.accounting WHERE false
> 2008-06-14 02:56:24 LOG: duration: 0.000 ms
> 2008-06-14 02:56:24 LOG: QUERY STATISTICS
>
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?
Have you checked the RadiusExpert wiki:
http://www.open.com.au/wiki/index.php/Main_Page
--
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