pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PHP and PostgreSQL: Cannot create new link. Too many open links (0)
3+ messages / 2 participants
[nested] [flat]

* PHP and PostgreSQL: Cannot create new link. Too many open links (0)
@ 2004-01-28 09:30 Johannes Alfänger <johannes.alfaenger@itwing.de>
  2004-01-28 11:46 ` Re: PHP and PostgreSQL: Cannot create new link. Too many open Adam Alkins <postgresql@rasadam.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Johannes Alfänger @ 2004-01-28 09:30 UTC (permalink / raw)
  To: pgsql-php

Hi All!

After working with PHP and MySQL and Firebird quite a while I need to
install PostgreSQL. After installation I made a new build of PHP to
support
PostgreSQL. I looked over the ini files and re-started Apache.

With psql I can connect like: "psql -h localhost ...". But not any
chancen
seen with PHP. I even just made a small script with just two echo lines
and
a pg_pconnect() / pg_connect().

This is the error Message I get: "Warning: pg_pconnect(): Cannot create
new
link. Too many open links (0). in /www/test.php on line 5".

I get this message no matter what connection string I use. Even if I
leave
it totally blank or put some nonsense in, I get the same error.

Any hint appreciated - Thanks in advance! Johannes

Configuration:
Red Hat 9
PHP Version 4.3.4
Apache 2.0.48
PostgreSQL 7.3.4
PostgreSQL libpq 7.3.4

pg_hba.conf:
local  all  all trust
host all all 127.0.0.1 255.255.255.255 trust




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: PHP and PostgreSQL: Cannot create new link. Too many open
  2004-01-28 09:30 PHP and PostgreSQL: Cannot create new link. Too many open links (0) Johannes Alfänger <johannes.alfaenger@itwing.de>
@ 2004-01-28 11:46 ` Adam Alkins <postgresql@rasadam.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Adam Alkins @ 2004-01-28 11:46 UTC (permalink / raw)
  To: Johannes Alfänger <johannes.alfaenger@itwing.de>; +Cc: pgsql-php

Another Redhat user with your error wrote:

---
In my /etc/php.ini file I had this line:

extension=pgsql.so
(now removed).

; Note: For Red Hat Linux, packaged extension modules are now loaded via
; the ini files in the directory /etc/php.d.

# ls -l /etc/php.d
-rw-r--r--    1 root     root           51 10 nov 16:40 pgsql.ini

# cat /etc/php.d/pgsql.ini
; Enable pgsql extension module
extension=pgsql.so

Thank you for help!
Now it's ok!!

---

Hope that helps,
Adam

Johannes Alfänger wrote:

>Hi All!
>
>After working with PHP and MySQL and Firebird quite a while I need to
>install PostgreSQL. After installation I made a new build of PHP to
>support
>PostgreSQL. I looked over the ini files and re-started Apache.
>
>With psql I can connect like: "psql -h localhost ...". But not any
>chancen
>seen with PHP. I even just made a small script with just two echo lines
>and
>a pg_pconnect() / pg_connect().
>
>This is the error Message I get: "Warning: pg_pconnect(): Cannot create
>new
>link. Too many open links (0). in /www/test.php on line 5".
>
>I get this message no matter what connection string I use. Even if I
>leave
>it totally blank or put some nonsense in, I get the same error.
>
>Any hint appreciated - Thanks in advance! Johannes
>
>Configuration:
>Red Hat 9
>PHP Version 4.3.4
>Apache 2.0.48
>PostgreSQL 7.3.4
>PostgreSQL libpq 7.3.4
>
>pg_hba.conf:
>local  all  all trust
>host all all 127.0.0.1 255.255.255.255 trust
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html
>
>
>
>  
>


-- 
Adam Alkins
1-868-627-9115
http://www.rasadam.com

Attachments:

postgresql.vcf (text/x-vcard, 337B) download begin:vcard fn:Adam Alkins n:Alkins;Adam org:Snikla enterprises;I.T. adr:;;#8 French Street;Woodbrook;;;Trinidad and Tobago email;internet:postgresql at (@) rasadam dot (.) com title:PHP Programmer tel;work:1-868-627-9115 tel;fax:1-868-627-9117 tel;cell:1-868-756-5173 x-mozilla-html:FALSE url:http://www.snikla.com version:2.1 end:vcard
^ permalink raw reply [nested|flat] 3+ messages in thread

* Re: PHP and PostgreSQL: Cannot create new link. Too many open links (0)
@ 2004-01-28 12:15 Johannes Alfänger <johannes.alfaenger@itwing.de>
  0 siblings, 0 replies; 3+ messages in thread

From: Johannes Alfänger @ 2004-01-28 12:15 UTC (permalink / raw)
  To: pgsql-php

Thanks everyone for the quick help! It did the trick!

BTW: I search the list archive for the error message in any thinkable
way - but I did not get that thread in the result set.

Cheers - Johannes

On Wednesday 28 January 2004 02:30, you wrote:
> This is the error Message I get: "Warning: pg_pconnect(): Cannot
> create new link. Too many open links (0). in /www/test.php on line 5".




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-01-28 12:15 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-28 09:30 PHP and PostgreSQL: Cannot create new link. Too many open links (0) Johannes Alfänger <johannes.alfaenger@itwing.de>
2004-01-28 11:46 ` Re: PHP and PostgreSQL: Cannot create new link. Too many open Adam Alkins <postgresql@rasadam.com>
2004-01-28 12:15 Re: PHP and PostgreSQL: Cannot create new link. Too many open links (0) Johannes Alfänger <johannes.alfaenger@itwing.de>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox