(RADIATOR) SQL Config

[Hugh Irvine]

Hello Andrew -

As mentioned in my previous mail, you should run "radiusd" from the  
Radiator 3.12 distribution directory and specify your configuration  
file on the command line:

         perl radiusd -foreground -log_stdout -trace 4 -config_file  
your_file.cfg

where "your_file.cfg" is the name of your configuration file, in  
which you specify everything required.

There are numerous examples in the "goodies" directory of the  
distribution.

If you are running on Windows you will need to install the DBI and  
DBD-ODBC modules from Active-State (using "ppm").

See section 26.7 in the reference manual ("doc/ref.html").

regards

Hugh




On 17 May 2005, at 01:17, Andrew W. Johnson III wrote:

> I'm new to this list.
>
> I am trying to get Radiator to read my Microsoft SQL database and  
> cannot find the configs
> to do just that.  I keep getting the following:
> ____________________________________________
> Mon May 16 12:54:54 2005: DEBUG: Adding Clients from SQL database
> Mon May 16 12:54:54 2005: DEBUG: Query is: 'select
>         NASIDENTIFIER,
>         SECRET,
>         IGNOREACCTSIGNATURE,
>         DUPINTERVAL,
>         DEFAULTREALM,
>         NASTYPE,
>         SNMPCOMMUNITY,
>         LIVINGSTONOFFS,
>         LIVINGSTONHOLE,
>         FRAMEDGROUPBASEADDRESS,
>         FRAMEDGROUPMAXPORTSPERCLASSC,
>         REWRITEUSERNAME,
>         NOIGNOREDUPLICATES,
>         PREHANDLERHOOK from RADCLIENTLIST':
> Mon May 16 12:54:54 2005: ERR: Execute failed for 'select
>         NASIDENTIFIER,
>         SECRET,
>         IGNOREACCTSIGNATURE,
>         DUPINTERVAL,
>         DEFAULTREALM,
>         NASTYPE,
>         SNMPCOMMUNITY,
>         LIVINGSTONOFFS,
>         LIVINGSTONHOLE,
>         FRAMEDGROUPBASEADDRESS,
>         FRAMEDGROUPMAXPORTSPERCLASSC,
>         REWRITEUSERNAME,
>         NOIGNOREDUPLICATES,
>         PREHANDLERHOOK from RADCLIENTLIST': [Microsoft][ODBC SQL  
> Server Driver][SQL Server]Invalid obj
> ect name 'RADCLIENTLIST'. (SQL-42S02)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could  
> not be prepared. (SQL-42000)(DBD: st
> _execute/SQLExecute err=-1)
> Mon May 16 12:54:55 2005: ERR: Execute failed for 'select
>         NASIDENTIFIER,
>         SECRET,
>         IGNOREACCTSIGNATURE,
>         DUPINTERVAL,
>         DEFAULTREALM,
>         NASTYPE,
>         SNMPCOMMUNITY,
>         LIVINGSTONOFFS,
>         LIVINGSTONHOLE,
>         FRAMEDGROUPBASEADDRESS,
>         FRAMEDGROUPMAXPORTSPERCLASSC,
>         REWRITEUSERNAME,
>         NOIGNOREDUPLICATES,
>         PREHANDLERHOOK from RADCLIENTLIST': [Microsoft][ODBC SQL  
> Server Driver][SQL Server]Invalid obj
> ect name 'RADCLIENTLIST'. (SQL-42S02)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could  
> not be prepared. (SQL-42000)(DBD: st
> _execute/SQLExecute err=-1)
> Mon May 16 12:54:55 2005: DEBUG: Finished reading configuration  
> file 'radius.cfg'
>
> ______________________________________________________________________ 
> _______
>
> I'm not sure where all this is configured and can't seem to get it  
> to read the database.
>
> Does anyone have any ideas where I need to start so that this can  
> read through ODBC.
>
> thanks..
>
>
> Sincerely,
>
>
> Andrew W. Johnson III
> Operations Manager
> InterStar Communications Inc.
> 102 Sampson Street
> Clinton, NC  28328
> Voice: 910-564-4638
> Fax: 910-564-7990
> aj3 at intrstar.net
>


NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/ 
radiator)?
Have you had a quick look on Google (www.google.com)?
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.