(RADIATOR) Re: RADIUS DBI problem

[Bon sy]

Hugh,
	We resolved the problem. It's an embrassing story. A technical
staff doing the maintainence inadverdently rebooted the system. During the
manual startup process to bring up various servers, the staff forgot to
"source .profile" to initialize the environment variables. (This caused
the afamous errors about "ORACLE_HOME and NLS setting not found".) 

	And afterwards each of us either do not know about the event of
system reboot, or totally forgot to mention that the system has been
rebooted ... and I happened to be in the former category and not knowing
about the system reboot until after I talked to that particular staff. 

	In any event, "source .profile" took care the environment variable
initialization as we have set up and now everything is working fine. 

Bon


On Mon, 28 Jun 2004, Hugh Irvine wrote:

> 
> Hello Bon -
> 
> Is this a permanent error? Or does it only happen from time to time?
> 
> And what do you do to fix the problem?
> 
> What does the configuration file look like?
> 
> Does the database reside on the same machine or on a different machine?
> 
> We need more information to be able to help.
> 
> BTW - a Google search on
> 
> 	UNKNOWN OCI STATUS 1804
> 
> brings up lots of useful hits.
> 
> regards
> 
> Hugh
> 
> 
> On 28 Jun 2004, at 11:20, Bon sy wrote:
> 
> > Hugh, Mike, and all,
> >
> > 	We have been running RADIUS 3.8 happily since we installed
> > it. Suddenly (last week) we got the following error with the DBI Oracle
> > connectivity. Would you please help to shed lights on the problems and 
> > how
> > we should go around fixing it. Many thanks in advance!
> >
> > Bon
> >
> >
> > Sun Jun 27 17:41:32 2004: DEBUG: Handling request with Handler
> > 'Client-Identifier = Orinoco_AP2000, Request-Type=Access-Request'
> > Sun Jun 27 17:41:32 2004: DEBUG:  Deleting session for bon, 
> > 192.168.x.x,
> > Sun Jun 27 17:41:32 2004: DEBUG: Handling with Radius::AuthSQL
> > Sun Jun 27 17:41:32 2004: DEBUG: Handling with Radius::AuthSQL:
> > Sun Jun 27 17:41:32 2004: DEBUG: Handling with EAP: code 2, 6, 1056
> > Sun Jun 27 17:41:32 2004: DEBUG: Response type 13
> > Sun Jun 27 17:41:32 2004: ERR: Could not connect to SQL database with
> > DBI->connect
> > dbi:Oracle:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.x.x)
> > (PORT=1521))(CONNECT_DATA=(SID=whatever))), <user>, <pass>:  (UNKNOWN 
> > OCI
> > STATUS
> > 1804) OCIInitialize. Check ORACLE_HOME and NLS settings etc.
> > Sun Jun 27 17:41:32 2004: ERR: Could not connect to SQL database with
> > DBI->connect dbi:Oracle:host=localhost;sid=whatever, , :  (UNKNOWN OCI
> > STATUS 1804)
> > OCIInitialize. Check ORACLE_HOME and NLS settings etc.
> > Sun Jun 27 17:41:32 2004: ERR: Could not connect to any SQL
> > database. Request
> > is ignored. Backing off for 600 seconds
> > Sun Jun 27 17:41:32 2004: INFO: EAP TLS Could not authenticate user
> > bon: User
> > database access error
> > Sun Jun 27 17:41:32 2004: INFO: EAP TLS certificate verification
> > failed: 50,
> > 25507: 1 - error:140890B2:SSL routines:SSL3_GET_CLIENT_CERTIFICATE:no
> > certificate returned
> >
> >
> >
> >
> 
> NB: 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.
> 

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