(RADIATOR) Error in AddressAllocator SQL

[Hugh Irvine]

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.