(RADIATOR) IPs allocated forever

[Hugh Irvine]

Hi Jon -

At 12:11 +0200 01/7/5, Jon Omagojeaskoa wrote:
>Thanks Hugh
>
>My config-file was like:
>
><ClientListSQL>
>         DBSource       ...
>         DBUsername      ...
>         DBAuth          ...
>
>         GetClientQuery        select NASIDENTIFIER,SECRET,NULL,NULL,     \
>                                      DEFAULTREALM,NASTYPE,SNMPCOMMUNITY \
>                                 from RADCLIENTLIST
></ClientListSQL>
>
>
>
>I've added the DUPINTERVAL field to my RADCLIENTLIST table with 
>value "4"  for the problematic NAS and:
>
>         GetClientQuery        select 
>NASIDENTIFIER,SECRET,NULL,DUPINTERVAL,     \
>                                      DEFAULTREALM,NASTYPE,SNMPCOMMUNITY \
>                                 from RADCLIENTLIST
>
>
>Problem solved !!


Good.


>
>
>There are still "lost" IPs due to lost Stop-Packets, but I can clean 
>them once a day with a crontab-script that sets STATE=0 to those IPs 
>on RADPOOL that are not in RADONLINE.FRAMEDIPADDRESS. Is there a way 
>to do the same "cleaning" within radiusd using
>
>         ReclaimQuery
>         DefaultLeasePeriod
>                 LeaseReclaimInterval
>
>I work with MySQL database an nested SELECT querys are not allowed :-(
>

I think you will be better off doing your housekeeping outside Radiator.

hth

Hugh

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
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.