Oct 5, 2010, 2:54 PM
Post #1 of 1
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 172.17.81.116] (70007)The timeout specified has expired: ap_content_length_filter: apr_bucket_read() failed, referer: https://secldap2/passwords/getquery.pl?user=xxx
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;
$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