(RADIATOR) ClientListSQL problem: fetchrow failed

[Hugh Irvine]

Hello Edoardo -

I am not sure I understand your Oracle table definition and the corresponding 
GetClientQuery. I would have thought that the NAS_IDENTIFIER field was what 
you wanted, although it is hard to tell what is being shown by the "select *" 
you show below.

Have you tried using the example table definition that we supply in the file 
"goodies/ansiCreate.sql"? Also note that there are differences in the table 
definitions that we provide and what you are using.

I have also copied Mike on this mail for his comments.

hth

Hugh


On Wednesday 13 June 2001 17:39, Edoardo Martelli wrote:
> Hi Hugh
>
> > Do you have other clauses (AuthBy SQL) that connect successfully to the
> > database?
>
> Yes, we succesfully use <SessionDatabase SQL> <AuthBy SQL> querying
> the same oracle instance.
>
> > Have you correctly configured the nettuno.DBT_RADIUSCLIENT table?
>
> Do you mean if I can use it? yes, I have a script running in the same
> box that dump nettuno.DBT_RADIUSCLIENT to a file.
>
> > And have you correctly entered the Client definitions into the table?
> >
> > Could you send me an example table dump of a Client definition?
>
> SQL> descr nettuno.DBT_RADIUSCLIENT
> Name Null? Type
> ------------------------------- -------- ----
> CLIENT NOT NULL VARCHAR2(255)
> NAS_IDENTIFIER VARCHAR2(255)
> SECRET VARCHAR2(255)
> DUPINTERVAL VARCHAR2(255)
> DEFAULTREALM VARCHAR2(255)
>
> SQL> select * from nettuno.DBT_RADIUSCLIENT;
> 130.186.34.6
> it01a21
> [removed]
> 2
> nettuno.it
>
> thank you
> Edoardo
>
> > 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.