(RADIATOR) No PoolHint Found

[Edward C. Jakosalem]

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.GenCheck,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.