(RADIATOR) Error in AddressAllocator SQL

Mon Jan 19 10:09:10 CST 2004

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.