(RADIATOR) No PoolHint Found

Sun May 20 21:55:00 CDT 2007

Hello Edward -

Depending on how your system has been designed, this may in fact be  
normal.

If your NAS equipment has IP address pools defined for default use,  
it may be the case that the IP address pools defined in Radiator are  
only used for "special" purposes. Hence it may be normal for no  
PoolHint to be found. Without knowing more details regarding your  
system design it is not really possible to give definitive answers.

As mentioned previously - it is the presence or absence of a  
"PoolHint" reply attribute in the user records in the database that  
cause this.

What exactly do you expect to happen? How has your system been designed?

regards

Hugh

On 21 May 2007, at 12:14, Edward C. Jakosalem wrote:

> Hello All,
>
> I have this problem showing up on the logs saying 'No Poolhint found'.
> What's not clear to me is why this happens to only some customers.  
> Some
> using the same NAS are being allocated an IP address so I don't  
> think it's
> a problem with MySQL. Another thing is that these transactions are  
> being
> granted access although not given any IP address.
>
> Here is an excerpt from my log:
>
> START ---
> Code:       Access-Request
> Identifier: 90
> Authentic:  <<143><246>+<170><216>w<191><232><13><162><176><189>@(<17>
> Attributes:
>         User-Name = "<user>"
>         User-Password = <168><221><145>F<155><197>
>         NAS-IP-Address = <our nas>
>         NAS-Port = 1202
>         NAS-Port-Type = Async
>         Service-Type = Framed-User
>         Framed-Protocol = PPP
>         State =
>         Calling-Station-Id = "<calling number>"
>         Called-Station-Id = "<called number>"
>         Acct-Session-Id = "421144753"
>         Ascend-Data-Rate = 33600
>         Ascend-Xmit-Rate = 28800
>
> Mon May 21 12:07:59 2007: DEBUG: Handling request with Handler  
> 'DEFAULT'
> Mon May 21 12:07:59 2007: DEBUG:  Deleting session for <user>, <our  
> nas>,
> 1202
> Mon May 21 12:07:59 2007: DEBUG: do query is: 'DELETE FROM Session  
> WHERE
> (RADClientIdentifier = '<our nas>' AND PortNumber = '1202') OR
> (LENGTH('called number') > 0 AND CallingStationID = 'calling  
> number')':
>
> Mon May 21 12:07:59 2007: DEBUG: Handling with Radius::AuthGROUP
> Mon May 21 12:07:59 2007: DEBUG: Handling with Radius::AuthSQL
> Mon May 21 12:07:59 2007: DEBUG: Handling with Radius::AuthSQL:
> Mon May 21 12:07:59 2007: DEBUG: Query is: 'SELECT
> Password,MaxSessions,CTemplate.GenCheck,RTemplate.GenReply,Login.GenCh 
> eck,Login.GenReply
> FROM  DialPool  LEFT JOIN POP ON (POP.FKDialPoolKey = DialPoolKey )  
> INNER
> JOIN Login ON (Login.FKDialPoolKey = DialPoolKey) LEFT JOIN  
> RTemplate ON
> (RTempKey = FKRTempKey) LEFT JOIN CTemplate ON (CTempKey = FKCTempKey)
> WHERE (STRCMP(Number,RIGHT('<called number>',LENGTH(Number))) = 0 OR
> DialPool.Realm = '<correct realm here' ) AND LoginName = '<user>' AND
> ConnectionType = 'dialup' AND Disabled = 0 GROUP BY DialPool.Realm  
> LIMIT
> 1':
>
> Mon May 21 12:07:59 2007: DEBUG: Radius::AuthSQL looks for match with
> pmcd at telpacific.com.au
> Mon May 21 12:07:59 2007: DEBUG: Query is: 'SELECT
> RADClientIdentifier,PortNumber,SessionID,IP FROM Session, Login,  
> DialPool,
> POP WHERE Session.FKLoginKey = LoginKey AND DialPoolKey =
> Login.FKDialPoolKey AND DialPoolKey = POP.FKDialPoolKey AND  
> LoginName =
> 'pmcd' AND (STRCMP(POP.Number,RIGHT('called number',LENGTH 
> (POP.Number))) =
> 0 OR DialPool.Realm = 'correct realm here') GROUP BY
> RADClientIdentifier,PortNumber':
>
> Mon May 21 12:07:59 2007: DEBUG: Radius::AuthSQL ACCEPT:
> Mon May 21 12:07:59 2007: DEBUG: Handling with Radius::AuthDYNADDRESS
> Mon May 21 12:07:59 2007: DEBUG: No PoolHint found. No address will be
> allocated
> Mon May 21 12:07:59 2007: DEBUG: Access accepted for <user>@<realm>.
>
> END ---
>
> I have modified some entries that I think are not relevenat to hide  
> actual
> values. I hope that's ok.
>
>
> TIA,
> Edward
>
>
> _____________________________________
> The vine Jane!!! The VINE!!! - Tarzan
>
>
>
>
> --
> 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.

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.