• Registered: 2011-03-22
  • Posts: 2

Topic: PHP 5.3.6 with pgsql errors - PQescapeByteaConn

Trying to install PHP with pgsql on RHEL4 (32bit) system.  Packages install fine, but when using PHP, I get errors with "undefined symbol: PQescapeByteaConn in Unknown on line 0"

[root@myvdx RHEL4-RPMs-famillecollet.com]# rpm -ivh php-5.3.6-1.el4.remi.i386.rpm php-cli-5.3.6-1.el4.remi.i386.rpm php-common-5.3.6-1.el4.remi.i386.rpm php-pdo-5.3.6-1.el4.remi.i386.rpm php-pgsql-5.3.6-1.el4.remi.i386.rpm sqlite-3.3.6-2.i386.rpm
warning: php-5.3.6-1.el4.remi.i386.rpm: V3 DSA signature: NOKEY, key ID 00f97f56
warning: sqlite-3.3.6-2.i386.rpm: V3 DSA signature: NOKEY, key ID 443e1821
Preparing...                ########################################### [100%]

WARNING : This php-* RPM are not official Fedora/Redhat build and
overrides the official ones. Don't file bugs on Fedora Project nor Redhat.

Use dedicated forums http://forums.famillecollet.com/

   1:php-common             ########################################### [ 17%]
   2:php-cli                ########################################### [ 33%]
   3:sqlite                 ########################################### [ 50%]
   4:php-pdo                ########################################### [ 67%]
   5:php                    ########################################### [ 83%]
   6:php-pgsql              ########################################### [100%]
[root@myvdx RHEL4-RPMs-famillecollet.com]#
[root@myvdx RHEL4-RPMs-famillecollet.com]# php -v
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/pdo_pgsql.so' - /usr/lib/php/modules/pdo_pgsql.so: undefined symbol: PQescapeByteaConn in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/pgsql.so' - /usr/lib/php/modules/pgsql.so: undefined symbol: PQescapeByteaConn in Unknown on line 0
PHP 5.3.6 (cli) (built: Mar 17 2011 20:03:59)
Copyright (c) 1997-2011 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2011 Zend Technologies
[root@myvdx RHEL4-RPMs-famillecollet.com]#
[root@myvdx RHEL4-RPMs-famillecollet.com]# uname -a
Linux myvdx 2.6.9-34.EL #1 Fri Feb 24 16:44:51 EST 2006 i686 i686 i386 GNU/Linux
[root@myvdx RHEL4-RPMs-famillecollet.com]#


Also tried installing php-5.3.5-1.el4.remi.1.i386.rpm group of RPMs, but receive the same errors.

Anyone have the same issue, or a resolution?
--Gord.

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,836

Re: PHP 5.3.6 with pgsql errors - PQescapeByteaConn

Which postgresql version is installed ?

rpm -qa postgresql\*

Should work with the standard version from RedHat/CentOS repository (against which php is build)

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,836

Re: PHP 5.3.6 with pgsql errors - PQescapeByteaConn

On my test machine

# cat /etc/redhat-release 
CentOS release 4.9 (Final)

# rpm -q postgresql-libs php-pgsql
postgresql-libs-7.4.30-1.el4_8.2
php-pgsql-5.3.6-1.el4.remi

# php -v
PHP 5.3.6 (cli) (built: Mar 17 2011 19:38:37) 
Copyright (c) 1997-2011 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2011 Zend Technologies

# php -m | grep pgsql
pdo_pgsql
pgsql
Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

  • Registered: 2011-03-22
  • Posts: 2

Re: PHP 5.3.6 with pgsql errors - PQescapeByteaConn

Here is the Postgresql setup:

[root@myvdx ~]# rpm -qa postgresql\*
postgresql-pl-8.1.5-6PGDG
postgresql-libs-7.4.8-1.RHEL4.1
postgresql-server-8.1.5-6PGDG
postgresql-8.1.5-6PGDG
postgresql-odbc-08.02.0100-2PGDG
postgresql-libs-8.1.5-6PGDG
postgresql-docs-8.1.5-6PGDG
[root@myvdx ~]#

[root@myvdx ~]# cat /etc/redhat-release
Red Hat Enterprise Linux ES release 4 (Nahant Update 3)

The RPM packages for php-5.1.6 from http://mirror.centos.org/centos/4/centosplus/i386/RPMS/ installed without issue.  I don't have the option of changing the Postgresql packages.  I will keep the php-5.1.6 installation.
Thanks,
--Gord.