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