(RADIATOR) Re: radwho.cgi (Could not connect to database )

[MJ]

Hi Hugh,
I have already tried by adding ORACLE_HOME in the radwho.cgi as follows

$ORACLE_HOME = '/radius/oracle';
$DBSource = 'dbi:Oracle:imsmaster';
$DBUsername = 'ims';
$DBAuth = '****';

but still same error.
MJ
----- Original Message ----- 
From: "Hugh Irvine" <hugh at open.com.au>
To: "MJ" <php at cyberia.net.sa>
Cc: <radiator at open.com.au>
Sent: Monday, August 16, 2004 9:36 AM
Subject: Re: radwho.cgi (Could not connect to database )



Hello MJ -

As the error message says, you need to set the ORACLE_HOME environment 
variable.

regards

Hugh


On 16 Aug 2004, at 00:38, MJ wrote:

> Hi,
> I have created the RADONLINE table on the oracle database and the 
> necessary changes in the cfg file to keep online users information in 
> the RADONLINE table, it seems working fine as I am getting the result 
> when I run query, "select * from radonline;". Further I am working to 
> enable radwho.cgi on a remote machine (Oracle is running on server A, 
> Radiator is on Server B, and the webserver with CGI support is on 
> Server C.
> 
> I have oracle client installed on the webserver and I can connect to 
> the remote oracle database using sqlplus without any problem. 
> Initially while I was trying to access 
> http://webserver/cgi-cbin/radwho.cgi I was getting all the Headings 
> and static messages but it was not showing any user as online even 
> there were active users. I checked the error_log of Apache and found 
> the following error.
> 
> Can't locate DBI.pm in @INC (@INC contains: 
> /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 
> /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .) 
> at /var/apache/cgi-bin/radwho.cgi line 217.
> 
> Then I changed the first line of radwho.cgi from "#!/usr/bin/perl" to 
> "#!/usr/local/bin/perl" as I have installed newer version (5.8.3) of 
> perl in /usr/local/bin. After this change, in the browser I am 
> getting the following error:
> 
> Fatal Error
> A serious problem was encountered:
> Could not connect to database 
> 
> I checked the error_log of Apache and found the following error:
> 
> ORACLE_HOME environment variable not set!
> DBI connect('imsmaster','ims',...) failed: Error while trying to 
> retrieve text for error ORA-12514 (DBD ERROR: OCIServerAttach) at 
> /var/apache/cgi-bin/radwho.cgi line 226
> 
> I repeated the above two tests on the same machien where Radiator is 
> running (Server B) but I got exactly same errors. Please note that I 
> can access remote oracle database from both of these server which I 
> used as webservers using the same following DBSource
>  
> $DBSource = 'dbi:Oracle:imsmaster';
> $DBUsername = 'ims';
> $DBAuth = 'xxx';.
> 
> Please help.
> MJ
>

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.