[RADIATOR] No Hosts defined for AuthRADIUS

[Hugh Irvine]

Hello -

This message is just a warning, which you can stop by adding a default host to the AuthBy SQLRADIUS clause.

See section 5.47 in the Radiator 4.5.1 reference manual ("doc/ref.pdf").

You should also correctly set the AuthPort and AcctPort in your configuration file for the RADIUS port numbers you want to receive requests on.

See sections 5.4.4 and 5.4.5 in the manual.

regards

Hugh


On 2 Jan 2010, at 23:55, Goboxe wrote:

> 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 #
> 
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator



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.