CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

Home: Perl Programming Help: DBI:
ora_login timeout


New User

Oct 5, 2010, 2:54 PM

Post #1 of 1 (4403 views)
ora_login timeout Can't Post

I have a web app that accepts data from a web form, then does a lookup in a remote oracle database and returns the associated data. Pretty simple right? for some reason it stopped working this weekend and now I'm stuck trying to figure why it stopped.

I checked the tnsnames.ora file and it has all the correct information.

I did a telnet hostname 1521 and got a tcp connection.

I tried to run the perl script by hand and it just hangs. I let it run for about 20 min just to make sure I wasn't killing too soon.

The web page does a timeout - found in /var/log/httpd/ssl_error_log

[Tue Oct 05 17:10:05 2010] [error] [client] (70007)The timeout specified has expired: ap_content_length_filter: apr_bucket_read() failed, referer: https://secldap2/passwords/

I tried tcpdump on the web server and there is no connection to the database server. Nothing. Here are some key lines from the script:

eval 'use Oraperl; 1;' || die $@ if $] >= 5;
use CGI_Lite;
$cgi = new CGI_Lite();
%fdata = $cgi->parse_form_data();

$dbh = ora_login($system_id, $ora_user, $ora_pass) || die "error: $ora_errno, $o
$output="error: $ora_errstr \n";
system("echo `date`: $output >> $LOGFILE");

Any ideas? Thanks for any help in advance


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives