(RADIATOR) Re: ORA-03113: DBD ERROR

[Hugh Irvine]

Hello Kon -

A quick Google search on "ORA-03113: end-of-file on communication  
channel" gives lots of hits - I am not an Oracle specialist so I'm  
not sure I can help much.

 From the debug shown below, it appears that Radiator is doing a  
select using stored functions in the database and there is a problem.

The functions in the database that are used in the query are  
"vpnuser.stripSubRealm('sslbrt1')" and "vpnuser.checkInputChars 
('r1b1user1')".

You will need to look at the Radiator configuration file, the  
Radiator debug and the Oracle logs to see why the problem is occuring.

What happens when you run the same query in sqlplus?

	select user_password, user_profile from useradm.users where  
user_realm = vpnuser.stripSubRealm('sslbrt1') and user_name =  
vpnuser.checkInputChars('r1b1user1')

regards

Hugh



On 28 Nov 2007, at 09:56, Kon Georgopoulos ((Alphawest)) wrote:

> Hi Hugh:
>
> Can you assist with an radiator (3.17.1) issue:
>
> "ORA-03113: end-of-file on communication channel (DBD ERROR:
> OCIStmtExecute/Describe)"
>
> The radiator server is running instantclient (basic, sdk, sqlplus)
> 10.2.0.3.0 and the Oracle server version is 10.2.0.1.0; and are all  
> SUN
> T2000 servers.
>
> I can sqlplus from the radiator server to Oracle and query fine. The
> radius.cfg upon load can also query to load in client list.
> However the error occurs with validation of user passwords:
>
> ---
> Tue Nov 27 22:06:36 2007: DEBUG: Query is: 'select user_password,
> user_profile from useradm.users where user_realm =
> vpnuser.stripSubRealm('sslbrt1') and user_name =
> vpnuser.checkInputChars('r1b1user1')':
> Tue Nov 27 22:06:36 2007: ERR: Execute failed for 'select  
> user_password,
> user_profile from useradm.users where user_realm =
> vpnuser.stripSubRealm('sslbrt1') and user_name =
> vpnuser.checkInputChars('r1b1user1')': ORA-03113: end-of-file on
> communication channel (DBD ERROR: OCIStmtExecute/Describe)
> Tue Nov 27 22:06:36 2007: DEBUG: Radius::AuthSQL looks for match with
> r1b1user1 at sslbrt1 [r1b1user1 at sslbrt1]
> Tue Nov 27 22:06:36 2007: DEBUG: Radius::AuthSQL REJECT: Bad Password:
> r1b1user1 at sslbrt1 [r1b1user1 at sslbrt1]
> Tue Nov 27 22:06:36 2007: DEBUG: AuthBy GROUP result: REJECT, Bad
> Password
> Tue Nov 27 22:06:36 2007: INFO: Access rejected for r1b1user1 at sslbrt1:
> Bad Password
> ---
>
> I do not think it is a bad password issue, but the client/DBD Oracle
> issue?
> The odd thing is that this worked fine again a lab Oracle Windows  
> server
> running 10.2.0.1.0 also.
>
> Regards,
> Kon Georgopoulos.



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?
Have you checked the RadiusExpert wiki:
http://www.open.com.au/wiki/index.php/Main_Page

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
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.