X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 23370D1B1D1 for ; Wed, 4 Aug 2004 14:42:48 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 14200-04 for ; Wed, 4 Aug 2004 17:42:41 +0000 (GMT) Received: from relay2.mecon.ar (relay2.mecon.gov.ar [168.101.16.11]) by svr1.postgresql.org (Postfix) with ESMTP id 56AFDD1B17A for ; Wed, 4 Aug 2004 14:42:30 -0300 (ADT) Received: from racing.mecon.ar (racing.mecon.gov.ar [168.101.133.15]) by relay2.mecon.ar (8.12.8p2/8.12.8) with ESMTP id i74HgNlL043375 for ; Wed, 4 Aug 2004 14:42:23 -0300 (ART) (envelope-from anferr@mecon.gov.ar) Received: from racing.mecon.ar (meyosp.mecon.gov.ar [10.11.0.149]) by racing.mecon.ar (8.12.8p2/8.12.8) with ESMTP id i74HgNsU074628 for ; Wed, 4 Aug 2004 14:42:23 -0300 (ART) (envelope-from anferr@mecon.gov.ar) Received: from imapsic2.minproduccion.gov.ar (imapsic2.mecon.ar [10.25.0.16]) by racing.mecon.ar (8.12.8p2/8.12.8) with ESMTP id i74HgNt5074625 for ; Wed, 4 Aug 2004 14:42:23 -0300 (ART) (envelope-from anferr@mecon.gov.ar) Received: from mecon.gov.ar (localhost [127.0.0.1]) by imapsic2.minproduccion.gov.ar (8.12.9/8.12.9) with ESMTP id i74HgMAm018168 for ; Wed, 4 Aug 2004 14:42:22 -0300 Message-ID: <4110D981.7080404@mecon.gov.ar> Date: Wed, 04 Aug 2004 14:41:37 +0200 From: Andres Ferrando User-Agent: Mozilla/5.0 (X11; U; Linux i686; es-ES; rv:1.6) Gecko/20040114 X-Accept-Language: es-ar, es, en-us, en MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: Re: pg calls not working from within Apache References: <080420041716.1841.411119D500083B76000007312200750330CBC9C7CE9F0D@comcast.net> In-Reply-To: <080420041716.1841.411119D500083B76000007312200750330CBC9C7CE9F0D@comcast.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.7 tagged_above=0.0 required=5.0 tests=DATE_IN_PAST_03_06, MAILTO_TO_SPAM_ADDR X-Spam-Level: * X-Archive-Number: 200408/4 X-Sequence-Number: 2892 Hi, PHP is loaded as Apache's module or CGI? Remember that this module is not the same that the script interpreter. You can compare the phpinfo() output from both. You have postgresql client libraries in this machine? bp1974@comcast.net escribió: >Hi, > I am trying to get a PostGresql <-->PHP<-->Apache working and am running to the well documented problem of : > >Fatal error: Call to undefined function: pg_connect() in /var/www/html/dbview.php on line 14 > >I have checked and double checked that php is compiled in with pgsql. List of compiled in modules looks like: >[PHP Modules] >SPL >SQLite >SimpleXML >calendar >ctype >dba >dom >ftp >gettext >iconv >libxml >openssl >pcre >pgsql <--- >posix >session >soap >standard >tokenizer >xml >zlib > >Apache and PHP seem to work, as evidenced by running the basic phpinfo() script. I also checked wheter pg calls work when running from the script interpreter, i.e. running a php script. >However, I am not able to get the same script running from within a browser. >Can anyone point out what little bit of the puzzle I might be missing? >I have pgsql 7.4.3 PHP 4.3.2 and Apache 2.0. > >Any help appreciated. > >thanks, >Balaji > >---------------------------(end of broadcast)--------------------------- >TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > > -- Andrés Ferrando Centro de Desarrollo de Sistemas Secretaria de Industria, Comercio y PyME