(RADIATOR) Error in AddressAllocator SQL

[William Hernandez]

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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: radius.log
Type: application/octet-stream
Size: 10642 bytes
Desc: not available
URL: <http://www.open.com.au/pipermail/radiator/attachments/20040119/0d9815bd/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: radius.cfg
Type: application/octet-stream
Size: 6351 bytes
Desc: not available
URL: <http://www.open.com.au/pipermail/radiator/attachments/20040119/0d9815bd/attachment-0001.obj>