Re: [Gusdev-rad-issues] Re: RADSA, Oci8 and oracle

[Junmin L. <ju...@pc...>]

Hi, Amruta,
Here are my questions and suggestions:
1. did you see the login page with user name and password menus when you 
start up the RAD-SA?

I assume you did, then you saw the top saying "New users, click here", 
then you click that, and it didn't bring up anything, right?

2. check any output messages in the log file, which is defined in your 
webPropFile's log_file property? any useful message there?


3. from your email, i have to guess somehow the ora_logon function fails 
in your site, simply because the first "print" runs and second doesn't.

so this is the function:
ora_logon(DB_USER . "@" . DB_NAME, DB_PASS)

a. can you check if the "DB_USER" and "DB_NAME" can connect to db by 
using sqlplus?
b. you have correct "oracle_home" set up?
c. please write up a small test script to connect to your oracle db using 
the ora_logon() function.
d. in terms of the ora_logon(), you can write it in short/simple form 
like we does in RADSA,

or 
you can write it in long form:

$db = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 
cbildb03.pcbi.upenn.edu)(PORT = 1521)) ) (CONNECT_DATA=(SID=......
$connHandle = ora_logon(DB_USER . "@$db" , DB_PASS);

Somehow due to the way you set up the oracle, the long string works 
but short string doesn't. I guess that may be your case.

Please check all of the options and let me know how they go.
Thanks,
----junmin




On Sun, 22 Jan 2006, Amruta Joshi wrote:

> Hi,
>
> I'm trying to set up RAD StudyAnnotator using OCI.
> I'm facing a similar problem as Juan faced earlier.
> When I try to run user_registration.php from the web-browser, I get a blank 
> page
>
> I get no warning messages. In fact the function ora_logon itself fails and 
> does not return.
> I just added 2 print statements before and after the ora_logon call in 
> include.php dbConnectionSetup function.
> The first print is output, but not the second. Any idea where I might have 
> messed up?
>
> Regards,
> Amruta
>
>
>  print "Trying:dbConnectionSetup";
>  $connHandle = ora_logon(DB_USER . "@" . DB_NAME, DB_PASS);
>  print "dbConnectionSetup:ora_logon returned ".$connHandle;
>  // check if connect was successful
>  if ($connHandle <= 0) {
>     Header( "WWW-authenticate: basic realm=\"Oracle Realm\"");
>     Header( "HTTP/1.0 401 Unauthorized");
>     printf( "Could not log into the DB.<br>");
>     exit;
>  }
> }
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
> _______________________________________________
> Gusdev-rad-issues mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-rad-issues
>