Skip site navigation (1) Skip section navigation (2)

Help me for "DBI->connect failed: Sorry, too many clients already."

From: "Joseph" <joseph(at)sitewarehouse(dot)net>
To: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-interfaces(at)postgresql(dot)org>, <joseph(at)sitewarehouse(dot)net>
Cc: <pgsql-admin(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Help me for "DBI->connect failed: Sorry, too many clients already."
Date: 2000-12-19 18:56:33
Message-ID: 000801c069ed$68ef1b00$a33b8acc@sitedom (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-hackerspgsql-interfaces
my cgi program is test.cgi:
#######################
require "./connectdb.pl";
&connectdatabase();
$query="select count(*) from messages";
$sth=$dbh->prepare($query);
$sth->execute();
$count=$sth->fetchrow_array();
print "Content-type: text/html\n\n";
print <<"TAG";
<html>
<body>
<h2> The count is $count. </h2>
</body>
</html>
TAG
exit 0;
#############
my connectdb.pl :
sub connectdatabase {
#  my ($dbusername,$dbpassword)=(at)_;
  $dbusername="postgres";
  $dbpassword="lokicom";
  $dbname="mboardsony";
  use DBI;
  $dbh=DBI->connect("dbi:Pg:dbname=$dbname",$dbusername,$dbpassword) or die "can
not connect to $dbname\n";
}
1;
#######################
my os is Redhat 6.2,and perl 5.005,and  web server is Apache.
The problem is:when I run test.cgi,it can work properly.But when I press F5
to refresh the web page for sever minutes,the Apache will have error message:
"DBI->connect failed: Sorry, too many clients already."
  Who can help me?
  Thank you ahead.
  
  My email: joel_xue(at)hotmail(dot)com

Responses

pgsql-hackers by date

Next:From: Stephan SzaboDate: 2000-12-19 19:19:16
Subject: Re: Three types of functions, ala function redux.
Previous:From: mlwDate: 2000-12-19 18:41:10
Subject: Three types of functions, ala function redux.

pgsql-admin by date

Next:From: JosephDate: 2000-12-19 19:01:46
Subject: help
Previous:From: Mustafa Timur GÖKÇEDate: 2000-12-19 17:02:28
Subject: Large Object

pgsql-interfaces by date

Next:From: JosephDate: 2000-12-19 19:01:46
Subject: help
Previous:From: npdavisDate: 2000-12-19 18:45:35
Subject: Re: Connection Pooling....an interesting question!! (was..Connection Pooling...(Repost)...please do help...)

pgsql-general by date

Next:From: JosephDate: 2000-12-19 19:01:46
Subject: help
Previous:From: Steve HeavenDate: 2000-12-19 18:08:48
Subject: Re: Schema

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group