X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9ECDA11F68E7 for ; Thu, 27 Apr 2006 05:49:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 96428-03-2 for ; Thu, 27 Apr 2006 05:48:45 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from pproxy.gmail.com (pproxy.gmail.com [64.233.166.177]) by postgresql.org (Postfix) with ESMTP id 2AC0711F692A for ; Thu, 27 Apr 2006 05:48:30 -0300 (ADT) Received: by pproxy.gmail.com with SMTP id x66so1920754pye for ; Thu, 27 Apr 2006 01:48:31 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=PmJmrk+N61RVqE0HcWN3uGIGNo1tV35JPe6H82Cw1TsT84/KUnr96gH06ggoM7Y2TLQd+Cj3yLOZHP83wHxz5FGDH4jBNNJv+bs0Xcx7lWJjVuVKxzbrd1vykFjYXDCDizyO+FnlMCIRnpoquX5WC6mRH0g/vTH3kE5qG1uMC2o= Received: by 10.35.34.20 with SMTP id m20mr1530068pyj; Thu, 27 Apr 2006 01:48:31 -0700 (PDT) Received: by 10.35.12.15 with HTTP; Thu, 27 Apr 2006 01:48:31 -0700 (PDT) Message-ID: Date: Thu, 27 Apr 2006 09:48:31 +0100 From: "Neil Saunders" To: "belfegor666@gazeta.pl" Subject: Re: PostgreSQL 8.1 + PHP5.1.x/4.4.2 + Apache 2.0.55/1.3.34 PROBLEM!! PLEASE HELP Cc: pgsql-php@postgresql.org In-Reply-To: <25468211.13431146121351565.JavaMail.webadm@ew9> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <25468211.13431146121351565.JavaMail.webadm@ew9> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/22 X-Sequence-Number: 3492 Ok, not to worry, first of all, look at the output to phpinfo() again. Look in the top section for the "Configuration File (php.ini) Path"; in my case, "C:\WINDOWS\php.ini". Ensure that this is the one you're editting. If it isn't, thats your problem. If it is... Your "extension_dir" setting should be your php folder with "/ext" tabbed on the end, so in my case: extension_dir =3D "c:/php/ext/" Note the forward slashes. Next, ensure that "php_pgsql.dll" exists in the c:\php\ext directory, and then check that the following exists in the dynamic extensions section: extension=3Dphp_pgsql.dll I'd bet you're just editting the wrong php.ini - Been there, done that :) Neil. On 4/27/06, belfegor666@gazeta.pl wrote: > Help! I was trying to make an installation of PHP 5.1.2 + Apache > 2.0.55 + PostgreSQL 8.1 on Windows 2003 Server, and I'm stuck. I > got PHP to work with Apache quite smoothly, so did I marry PHP with > PostgreSQL - scripts connecting to the database work fine from > windows command line, except that the following code: > > if (extension_loaded("php_pgsql")) { > echo "PGSQL loaded!"; > } > > returns no message. Still database queries work fine. Trouble starts > when I try to open a page in my browser - then I get an error > message like this: > > Error: call to udefined function pg_connect()... > > I changed the php.ini file a billion times, trying to figure out > what to set in the "extension_dir" and "extension=3Dphp_pgsql.dll" > lines, and I tried at least as many times to change apache's > httpd.conf file so that the php module is loaded properly. And it > is, as far as I'm concerned - the phpinfo() page shows without a > problem. One peculiar thing about it is that in the "Loaded > modules" section (don't remember the exact name) there's absolutely > no sign of the pgsql module. > > I also tried downloading and installing the latest php snapshot, > because someone on a forum told me it might work, but it didn't :o( > I even tried earlier versions of Apache and PHP, but nothing > worked. Initially I figured I must have found a bug, but I don't > really believe it could've gone on for so long without being > noticed by somebody... > > I'm begging for help, because the person I'm doing the server for > strongly insists on the machine working on Win 2003 and not some > distribution of linux or unix. > > Regards, > krzysieq > > > -- > Nie przychodz! Nie przyjezdzaj! Nie dzwon! Zamow ogloszenie drobne do "Ga= zety Wyborczej" przez internet wchodzac na http://www.aaaby.pl/wyborcza i w= ygraj nawet 10.000 zl! > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >