makecpphp - is trying to compile against pgsql

[mtindor]

In a few previous threads it was mentioned that if you want to update the client version shown in PHPMyAdmin (my client version is 4.1.1 or something), you should run /scripts/makecpphp.

note: my system never had postgreSQL on it in its life.

When I ran /scripts/makecpphp it tried to detect postgreSQL. When it couldn't find it, it installed:

rh-postgresql-libs-7.3.19-1
rh-postgresql-devel-7.3.19-1
rh-postgresql-server-7.3.19-1
rh-postgresql-7.3.19-1

Then it attempted to compile. Compile failed at the end with the following error:

/home/cpeasyapache/src/imap-2004g/c-client/osdep.c:268: the use of `tmpnam' is dangerous, better use `mkstemp'
ext/pgsql/pgsql.o(.text+0x76de): In function `zif_pg_escape_bytea':
: undefined reference to `PQfreemem'
ext/pgsql/pgsql.o(.text+0x7754): In function `zif_pg_unescape_bytea':
: undefined reference to `PQfreemem'
ext/pgsql/pgsql.o(.text+0x8202): In function `zif_pg_get_notify':
: undefined reference to `PQfreemem'
ext/pgsql/pgsql.o(.text+0xb0e5): In function `php_pgsql_convert':
: undefined reference to `PQfreemem'
collect2: ld returned 1 exit status
make: *** [sapi/cgi/php] Error 1
!! 'make' failed with exit code '512' !!

How does one make it not attempt to use postgreSQL?

Mike

[mtindor]

The answer was easy enough.. don't know why I didn't think of it - probably because I didn't know where the file was to handle this.

The Cpanel guys (specifically Cory) simply changed /scripts/makecpphp.profile.yaml , at the following:

Cpanel::Easy::PHP5::Pgsql: 1

to
Cpanel::Easy::PHP5::Pgsql: 0

It compiled fine and now the MySQL client in phpMyAdmin shows 5.0.27.

Mike

In a few previous threads it was mentioned that if you want to update the client version shown in PHPMyAdmin (my client version is 4.1.1 or something), you should run /scripts/makecpphp.

note: my system never had postgreSQL on it in its life.

When I ran /scripts/makecpphp it tried to detect postgreSQL. When it couldn't find it, it installed:

rh-postgresql-libs-7.3.19-1
rh-postgresql-devel-7.3.19-1
rh-postgresql-server-7.3.19-1
rh-postgresql-7.3.19-1

Then it attempted to compile. Compile failed at the end with the following error:

/home/cpeasyapache/src/imap-2004g/c-client/osdep.c:268: the use of `tmpnam' is dangerous, better use `mkstemp'
ext/pgsql/pgsql.o(.text+0x76de): In function `zif_pg_escape_bytea':
: undefined reference to `PQfreemem'
ext/pgsql/pgsql.o(.text+0x7754): In function `zif_pg_unescape_bytea':
: undefined reference to `PQfreemem'
ext/pgsql/pgsql.o(.text+0x8202): In function `zif_pg_get_notify':
: undefined reference to `PQfreemem'
ext/pgsql/pgsql.o(.text+0xb0e5): In function `php_pgsql_convert':
: undefined reference to `PQfreemem'
collect2: ld returned 1 exit status
make: *** [sapi/cgi/php] Error 1
!! 'make' failed with exit code '512' !!

How does one make it not attempt to use postgreSQL?

Mike