(RADIATOR) ClientListSQL problem: fetchrow failed

[Hugh Irvine]

Hello Edoardo -

Do you have other clauses (AuthBy SQL) that connect successfully to the 
database? Have you correctly configured the nettuno.DBT_RADIUSCLIENT table? 
And have you correctly entered the Client definitions into the table?

Could you send me an example table dump of a Client definition?

thanks

Hugh

On Tuesday 12 June 2001 22:48, Edoardo Martelli wrote:
> Hi
>
> I've just upgraded to 2.18.2 and all works fine with my old 2.13
> configuration file.
> Now I would like to test the ClientListSQL feature and when the server
> start it says:
>
> DBD::Oracle::st fetchrow failed: ORA-65285: Message 65285 not found;
> product=RDBMS; facility=ORA (DBD ERROR: OCIStmtFetch) at
> /usr/local/lib/perl5/site_perl/5.6.1/Radius/ClientListSQL.pm line 101,
> <FILE> line 33.
>
> and in the log:
>
> Tue Jun 12 14:14:43 2001: DEBUG: Adding Clients from SQL database
> Tue Jun 12 14:14:43 2001: DEBUG: Query is: select CLIENT, SECRET,
> NULL, DUPINTERVAL, DEFAULTREALM from nettuno.DBT_RADIUSCLIENT
> Tue Jun 12 14:14:43 2001: INFO: Server started: Radiator 2.18.2 on
> presto.nextra.it
>
> But the server doesn't run correctly.
>
> I've looked for the error ORA-65285 but I haven't found anything.
>
> Does anyone have ever seen something like that?
>
> Here the configuration lines I'm testing:
>
> <ClientListSQL>
>          DBSource        dbi:Oracle:nextra
>          DBUsername      user
>          DBAuth          passwd
>          GetClientQuery select CLIENT, SECRET, NULL, DUPINTERVAL, \
> 				DEFAULTREALM \
>                          from nettuno.DBT_RADIUSCLIENT
> </ClientListSQL>
>
> regards
> Edoardo

-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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.