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

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: DBI:
ora_login timeout

 



Samspade
New User

Oct 5, 2010, 2:54 PM

Post #1 of 1 (2474 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 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;
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
ra_errstr";
$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