[RADIATOR] No Hosts defined for AuthRADIUS

[Goboxe]

Hi,

I am testing Radiator on Sun Solaris 10 using the backend PostgreSQL.

Could you advice why I getting warning:

Sat Jan  2 20:35:16 2010: WARNING: No Hosts defined for AuthRADIUS at
'/usr/local/etc/radiator/radius.cfg' line

This causing I am not able to connect to the server using radpwtst.
The connectivity to the DB is fine as RADCLIENTLIST is able to load data
from DB.
I think the issue is in the AuthBy SQLRADIUS.


--------------------------------------------
root at radius1 # /etc/init.d/radiator restart
Shutting down Radiator...
Starting Radiator with config /usr/local/etc/radiator/radius.cfg
Sat Jan  2 20:35:16 2010: DEBUG: Adding Clients from SQL database
Sat Jan  2 20:35:16 2010: DEBUG: Query is: 'select
NASIDENTIFIER,SECRET,IGNOREACCTSIGNATURE,DUPINTERVAL,
DEFAULTREALM,NASTYPE,SNMPCOMMUNITY,LIVINGSTONOFFS,
LIVINGSTONHOLE,FRAMEDGROUPBASEADDRESS,
FRAMEDGROUPMAXPORTSPERCLASSC,REWRITEUSERNAME,
NOIGNOREDUPLICATES,PREHANDLERHOOK, NULL, NULL, NULL, NULL, ALLOWINREPLY from
RADCLIENTLIST':
Sat Jan  2 20:35:16 2010: DEBUG: ClientListSQL adds Client 127.0.0.1
Sat Jan  2 20:35:16 2010: DEBUG: ClientListSQL adds Client 192.168.1.201
*Sat Jan  2 20:35:16 2010: WARNING: No Hosts defined for AuthRADIUS at
'/usr/local/etc/radiator/radius.cfg' line*
Sat Jan  2 20:35:16 2010: DEBUG: Finished reading configuration file
'/usr/local/etc/radiator/radius.cfg'




Below is the radius.cfg
--------------------------------------------------

Foreground
LogStdout
#AuthPort 1645
#AcctPort 1646
LogDir /var/log/radius
#DbDir /usr/local/etc/radiator

# Use a low trace level in production systems. Increase
# it to 4 or 5 for debugging, or use the -trace flag to radiusd
Trace 4

<ClientListSQL>
DBSource dbi:PgPP:dbname=tmradiusdb
 DBUsername postgres

RefreshPeriod 60
 GetClientQuery select NASIDENTIFIER,SECRET,IGNOREACCTSIGNATURE,DUPINTERVAL,
\
DEFAULTREALM,NASTYPE,SNMPCOMMUNITY,LIVINGSTONOFFS, \
 LIVINGSTONHOLE,FRAMEDGROUPBASEADDRESS, \
FRAMEDGROUPMAXPORTSPERCLASSC,REWRITEUSERNAME, \
 NOIGNOREDUPLICATES,PREHANDLERHOOK, \
NULL, NULL, NULL, NULL, ALLOWINREPLY from RADCLIENTLIST

</ClientListSQL>



#:::::: Proxies request to Target Radius server
<AuthBy SQLRADIUS>
Identifier ABTargetR
 DBSource dbi:PgPP:dbname=tmradiusdb
DBUsername postgres


 #DefaultSimultaneousUse 5
 HostSelect select HOST1, SECRET from RADSQLRADIUS where TARGETNAME='zz'
NumHosts 1
 #HostSelect select HOST%0, SECRET, AUTHPORT, ACCTPORT,\
# RETRIES, RETRYTIMEOUT, USEOLDASCENDPASSWORDS, \
 # SERVERHASBROKENPORTNUMBERS,SERVERHASBROKENADDRESSES, \
# IGNOREREPLYSIGNATURE, FAILUREPOLICY from RADSQLRADIUS \
 # where TARGETNAME='%R'
 #ReplyHook file:"/usr/local/etc/radiator/hook_reply.pl"
 </AuthBy>


#:::::: Session tracker
<SessionDatabase SQL>
Identifier sessionDB1
 Timeout 5
DBSource dbi:PgPP:dbname=tmradiusdb
DBUsername postgres

CountQuery select NASIDENTIFIER,NASPORT,ACCTSESSIONID from RADONLINE where
USERNAME like '%%@%W'
AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, \
 ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, \
SERVICETYPE) values ('%u', '%1', %2, %3, %{Timestamp}, \
 '%{Framed-IP-Address}', '%{NAS-Port-Type}', '%{Service-Type}')
DeleteQuery delete from RADONLINE where NASIDENTIFIER='%1' and NASPORT=0%2
</SessionDatabase>

#:::::: One Handler for all
<Handler>
AuthBy ABTargetR
SessionDatabase sessionDB1
 RejectHasReason
#AuthByPolicy DoEverything
 # AuthBy SQL ignores accounting
#AccountingHandled
AcctLogFileName /var/log/radius/%c/detail_%v-%d-%Y
</Handler>

### Default fall back clause - catches everything else ###
#<Handler>
#  SessionDatabase noDB
#</Handler>
### End of default fallback clause ###



### Null session clause ###
#<SessionDatabase NULL>
#  Identifier noDB
#</SessionDatabase>
### End of null session clause #
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20100102/b9255340/attachment.html