X-Original-To: pgsql-php@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8C048476967 for ; Fri, 16 May 2003 16:02:28 -0400 (EDT) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with ESMTP id 47083-05 for ; Fri, 16 May 2003 16:02:25 -0400 (EDT) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by postgresql.org (Postfix) with ESMTP id 61A01476D2A for ; Fri, 16 May 2003 16:02:24 -0400 (EDT) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.9/8.12.9) with ESMTP id h4GK1Var015402; Fri, 16 May 2003 14:01:31 -0600 (MDT) Date: Fri, 16 May 2003 13:51:04 -0600 (MDT) From: "scott.marlowe" To: David Busby Cc: Subject: Re: Inquiry From Form [pgsql] In-Reply-To: <035801c31be3$fc2fe7f0$1100000a@busbydev> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-MailScanner: Found to be clean X-MailScanner-SpamCheck: X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/20 X-Sequence-Number: 2025 The way I "show" linux where to find the libs for postgresql is to edit /etc/ld.so.conf to have a line like /usr/local/pgsql/lib and then run ldconfig. Otherwise PHP will compile, but apache won't start. On Fri, 16 May 2003, David Busby wrote: > Look for the files libpq.h and also libpq-fe??? something like that. Those > are the PostgreSQL headers (.h) and libraires (.so) You'll have to have > those for pg_connect to work. When PHP is built it needs to know where > those are (in path with other includes and libraries? or something else > (/usr/local?/opt/postgre)). > > /B > > > > ----- Original Message ----- > From: "scott.marlowe" > To: "Mark" > Cc: ; "Marc G. Fournier" ; > > Sent: Friday, May 16, 2003 11:48 > Subject: Re: [PHP] Inquiry From Form [pgsql] > > > > On Thu, 15 May 2003, Mark wrote: > > > > > I have a Raq4i and I am trying to write PHP 4 to the PostgreSQL. But I > > > keep getting undefined function: pg_connect() . I have the extension > > > enabled and the PHP was compiled for postgreSQL. I do not understand > > > what is going on? > > > > If PHP says pg_connect is undefined, then the php the RAQ is running isn't > > compiled for postgresql connectivity. > > > > There are two common causes of this: > > > > 1: You compiled one build of PHP, the RAQ is running on another build. > > > > 2: You told PHP to build in postgresql connectivity, it couldn't find the > > right header file, failed, writing an error message to the screen during > > configuration, saying something along the lines of "could not find file > > xxxxx.h" skipping postgresql configuration. > > > > PHP will then happily build and run, without postgresql capabilities. > > > > Try this: > > > > write a web page with this in it: > > > > > phpinfo(); > > ?> > > > > Look through the page to see if it mentions postgresql. At the top will > > be a list of all the switches it was configged with. If you have a > > --with-pgsql there, but no pgsql section in phpinfo, then the configure > > script couldn't find the right headers. Make sure you're running a fairly > > late model version of both PHP and postgresql, as there was a bit of an > > issue about a year ago when postgresql changed the name of one of it's > > connection headers. > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >