(RADIATOR) ClientListSQL problem: fetchrow failed

[Edoardo Martelli]

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
>>
> 



-- 
e.martelli at nextra.it
phone: +39 051 6139242
fax:   +39 051 6114455

===
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.