Bug #56683 [Opn->Fbk]: PDO_PGSQL cannot be upgraded

Edit report at https://bugs.php.net/bug.php?id=56683&edit=1 ID: 56683 Updated by: ssufficool@php.net Reported by: mdv at inyourpocket dot com Summary: PDO_PGSQL cannot be upgraded -Status: Open +Status: Feedback Type: Bug -Package: PDO_PGSQL +Package: *General Issues Operating System: debian PHP Version: 5.1.1 Block user comment: N Private report: N New Comment: Please try using this snapshot: http://snaps.php.net/php5.3-latest.tar.gz For Windows: http://windows.php.net/snapshots/ Previous Comments: ------------------------------------------------------------------------ [2006-02-08 15:13:04] m dot regner at larkos dot de Sorry i missed somthing in my description of my solution: I only copied the link and not the full command so here it is: pear install -f http://pecl.php.net/get/PDO_PGSQL-1.0.1.tgz The -f overruns the dependency-testing of pear. Greetings again ------------------------------------------------------------------------ [2006-02-08 15:10:03] m dot regner at larkos dot de I don't get this error during update but when i tried to install pdo and pdo_pgsql. I got it running now and maybe someone can put some light in this matter. I discovered while crawling through the configure file of the pdo_pgsql package, that it seems to pretend, that pdo is build statically. It checkes a variable called: PHP_PDO_SHARED So when i do: export PHP_PDO_SHARED="true" and than do http://pecl.php.net/get/PDO_PGSQL-1.0.1.tgz everything installs and works fine. I don't know, if this is a bug or if i have overseen some other configuration step. However for everybody who needs to get this stuff running fast, this is hopefully a interim solution Greetings so far ------------------------------------------------------------------------ [2006-01-27 02:17:50] mastabog at hotmail dot com Join the club :( Following a hint from #6117 I converted the package.xml to package2.xml (pecl convert) and tried inserting a bogus dependency and provider ... no luck. Tried removing the pdo dependency ... no luck with that either. This definitely needs to be addressed. I'm surprised though because it has been reported 2 months ago ... ------------------------------------------------------------------------ [2006-01-17 09:00:14] miki at canaan dot co dot il Reinstalled pdp 1.0.2 easily. then I added extension=pdo.so to both: /etc/php5/apache/php.ini & /etc/php5/cli/php.ini phpinfo(); showed that: the configure was with --disable-pdo but later on i see the PDO is enabled. referance: http://www.canaan-net.com/test.phtml and still im getting the folloing error: ( now with all the buid info ) # pear install http://pecl.php.net/get/PDO_PGSQL-1.0.1.tgz downloading PDO_PGSQL-1.0.1.tgz ... Starting to download PDO_PGSQL-1.0.1.tgz (13,308 bytes) .....done: 13,308 bytes 7 source files, building running: phpize Configuring for: PHP Api Version: 20041225 Zend Module Api No: 20050922 Zend Extension Api No: 220051025 building in /var/tmp/pear-build-root/PDO_PGSQL-1.0.1 running: /tmp/tmpYiSIwo/PDO_PGSQL-1.0.1/configure checking for egrep... grep -E checking for a sed that does not truncate output... /bin/sed checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ANSI C... none needed checking whether gcc and cc understand -c and -o together... yes checking if compiler supports -R... no checking if compiler supports -Wl,-rpath,... yes checking build system type... i686-pc-linux-gnu checking host system type... i686-pc-linux-gnu checking target system type... i686-pc-linux-gnu checking for PHP prefix... /usr checking for PHP includes... -I/usr/include/php5 -I/usr/include/php5/main -I/usr/include/php5/TSRM -I/usr/include/php5/Zend -I/usr/include/php5/ext checking for PHP extension directory... /usr/lib/php5/20050922 checking for PHP installed headers prefix... /usr/include/php5 checking for re2c... no configure: WARNING: You will need re2c 0.9.11 or later if you want to regenerate PHP parsers. checking for gawk... no checking for nawk... nawk checking if nawk is broken... no checking for PostgreSQL support for PDO... yes, shared checking for pg_config... /usr/bin/pg_config checking for openssl dependencies... yes checking for PQescapeString in -lpq... yes checking for PQsetnonblocking in -lpq... yes checking for PQcmdTuples in -lpq... yes checking for PQoidValue in -lpq... yes checking for PQclientEncoding in -lpq... yes checking for PQparameterStatus in -lpq... yes checking for PQprotocolVersion in -lpq... yes checking for PQtransactionStatus in -lpq... yes checking for PQunescapeBytea in -lpq... yes checking for PQExecParams in -lpq... no checking for PQresultErrorField in -lpq... yes checking for pg_encoding_to_char in -lpq... yes checking for PQprepare in -lpq... no checking for PDO includes... checking for PDO includes... /usr/include/php/ext configure: error: You've configured extension pdo_pgsql, which depends on extension pdo, but you've either not enabled pdo, or have disabled it. ERROR: `/tmp/tmpYiSIwo/PDO_PGSQL-1.0.1/configure' failed tried to play with includes and such but no success. The server is Debian Sarge with Dotdeb backports im totaly lost ------------------------------------------------------------------------ [2006-01-17 05:47:40] mdv at inyourpocket dot com i think that is problem with pear/pecl (pear loads extensions like pdo.so... but pecl not), so you cannot install PDO_XXXX using pecl (i think) 1. install PDO via pecl (should be no problem) 2. add "extension=pdo.so" to php.ini 3. use pear (NOT pecl) to install pdo_pgsql (but specify file to install): pear install http://pecl.php.net/get/PDO_PGSQL-1.0.1.tgz 4. If get error like: checking for pg_config... not found configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path ERROR: `/tmp/tmpjkxUNQ/PDO_PGSQL-1.0.1/configure' failed postgresql installed in nonstandard location (like /usr/local/pgsql) need link pg_config to /usr/bin: 4.1. ln -s <where you have installed psql>/bin/pg_config /usr/bin/pg_config 4.2. then run again pear install http://pecl.php.net/get/PDO_PGSQL-1.0.1.tgz 5. add "extension=pdo_pgsql.so" to php.ini ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=56683 -- Edit this bug report at https://bugs.php.net/bug.php?id=56683&edit=1