(RADIATOR) Error in AddressAllocator SQL

Hugh Irvine hugh at open.com.au
Tue Jan 20 01:15:46 CST 2004


Hello William -

I think you have a problem with your configuration file - it appears 
the AddressAllocator is being called in a loop.

It is really _much_ easier if I can see the configuration file and a 
complete trace 4 debug.

regards

Hugh


On 20 Jan 2004, at 05:31, William Hernandez wrote:

> Hi Hugh,
>
> Now I'm seeing in radius.log the error "Too many simultaneous
> address requests".
>
> Please advise,
> William
>
>
> -----Original Message-----
> From: William Hernandez [mailto:whr at essnet.com]
> Sent: Monday, January 19, 2004 12:09 PM
> To: 'radiator at open.com.au'
> Subject: RE: (RADIATOR) Error in AddressAllocator SQL
>
>
> Hi Hugh,
>
> It appears that the AddressAllocator gets executed before the
> StartupHook.
>
> However, changing
> DBSource        dbi:Sybase:database=myradius
> To
> DBSource        dbi:Sybase:server=sql:database=myradius
> Did not work.
>
> Setting the environment variable DSQUERY before starting up
> radius did work.
>
> Please advise,
> William
>
>
> -----Original Message-----
> From: William Hernandez [mailto:whr at essnet.com]
> Sent: Monday, January 19, 2004 10:34 AM
> To: 'radiator at open.com.au'
> Subject: RE: (RADIATOR) Error in AddressAllocator SQL
>
>
> Hi Hugh,
>
> Yes, I agree there really isn't much information to go on except
> that startup message. The AuthBy SQL clauses below and the
> SessionDatabase all work. Perhaps you will find something in
> them.
>
> Some additional information:
> We're using:
> 	DBD-Sybase-0.94
> 	Freetds-0.53
> 	MS SQLServer 2000
> 	MySQL 3.23.58
>
> Regards,
>
> William
>
>
> -----Original Message-----
> From: owner-radiator at open.com.au
> [mailto:owner-radiator at open.com.au] On Behalf Of Hugh Irvine
> Sent: Friday, January 16, 2004 10:25 PM
> To: William Hernandez
> Cc: radiator at open.com.au
> Subject: Re: (RADIATOR) Error in AddressAllocator SQL
>
>
>
> Hello William -
>
> I don't think I have quite enough information to go on.
>
> It would be much easier if you showed us an AuthBy SQL clause
> that is
> working as well as the AddressAllocator, and a more complete
> trace 4
> showing both cases would also be very useful. The error shown is
> Radiator trying to connect to the database before any queries are
> done,
> so I would suspect a typo somewhere.
>
> regards
>
> Hugh
>
>
> On 17 Jan 2004, at 02:26, William Hernandez wrote:
>
>> Hello everyone,
>>
>> I'm getting an error with the following cfg.  Note that the
> same
>> DBSource,DBUsername,DBAuth works fine in all of my AuthBy SQL
> clauses.
>> Note also that the connection to the fallback mysql database
> works
>> fine.
>>
>>
>> -------------- snippet from radius.cfg ---------
> <AddressAllocator
>> SQL>
>>     Identifier dslpool1-IPallocator
>>
>>     DBSource        dbi:Sybase:database=myradius
>>     DBUsername      *
>>     DBAuth          *
>>     DBSource        dbi:mysql:myradius:www.prw.net
>>     DBUsername      *
>>     DBAuth          *
>>
>>     # 30 days = 60 * 60 * 24 * 30 = 2592000 seconds
>>     DefaultLeasePeriod     2592000
>>     #LeaseReclaimInterval 86400
>>
>>     <AddressPool dslpool1>
>>         Subnetmask  255.255.255.255
>>         Range   69.89.32.0/20
>>     </AddressPool>
>> </AddressAllocator>
>>
>>
>> ------------ snippet from radius foreground ------------
>> DBI connect('database=myradius','*',...) failed: (no error
>> string) at /usr/li
>> b/perl5/site_perl/5.8.0/Radius/SqlDb.pm line 110
>> Fri Jan 16 11:05:01 2004: ERR: Could not connect to SQL
> database with
>> DBI->conne ct dbi:Sybase:database=myradius, *, *:
>> Fri Jan 16 11:05:10 2004: DEBUG: Reading dictionary file
>> '/etc/raddb/dictionary. prw'
>> Fri Jan 16 11:05:10 2004: DEBUG: Creating authentication port
>> 0.0.0.0:1812
>> Fri Jan 16 11:05:10 2004: DEBUG: Creating accounting port
>> 0.0.0.0:1813
>> Fri Jan 16 11:05:10 2004: NOTICE: Server started: Radiator
> 3.7.1
>> on www.prw.net
>>
>>
>> Please advise,
>>
>> William Hernández
>> Radiator 3.7.1
>> RH 9 Kernel 2.4.20-20.9smp
>> Perl 5.8.0
>> TotalControl HiPerArc
>>
>> ===
>> 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 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.
> -
> 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.
> <radius.log>

NB: 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.
-
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.


More information about the radiator mailing list