Installing pgsql/postgres driver for custom PHP application using postgres from another server

darkwings92 2019-11-05 17:46:12 UTC #1

Keywords: General - AWS - How to - Other
Description:
I have a custom php application that needs to connect to a PostgreSQL DB. I have read another post where they explain that bitnatmi dosn't use system packages, that I need to compile the driver for it. I checked the tutorial, but I have a problem, my PostgresQL DB is in another AWS server. how can I compile the driver using that postgres server? or do I need to install postgres in the bitnami server just to compile it?

thanks!

miguelaeh 2019-11-06 10:08:18 UTC #2

Hi @darkwings92,
If you need a system package you can just install it as usual. About the compilation, I am not sure if I understand what you mean, to compile something you don't need the connection with the database. Could you please give details about what are you trying to do?

darkwings92 2019-11-06 16:23:33 UTC #3

I'm talking about this tutorial

jota 2019-11-07 10:34:39 UTC #4

Hi @darkwings92,

If you are using the Bitnami Discourse solution, you already have a PostgreSQL installation in the machine. You will need to use this command

./configure --with-pdo-pgsql=/opt/bitnami/postgresql

Happy to help!

Was my answer helpful? Click on

darkwings92 2019-11-12 07:33:23 UTC #5

I installed postgres and used that command, but when I use the make command (make && sudo make install), but I got errors that said something like:
error: macro "ZVAL_STRING" passed 3 arguments, but takes just 2.
As far as I know, this error comes because pecl is deprecated in php 7.X.

So I tried installing using sudo apt-get install php7.0-pgsql, restarted the service with sudo /opt/bitnami/ctlscript.sh restart apache, removed the ";" for the pdo_pgsql and pgsql lines in php.ini and I get the following error:

PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_pgsql' (tried: /opt/bitnami/php/lib/php/extensions/pdo_pgsql (/opt/bitnami/php/lib/php/extensions/pdo_pgsql: cannot open shared object file: No such file or directory), /opt/bitnami/php/lib/php/extensions/pdo_pgsql.so (/opt/bitnami/php/lib/php/extensions/pdo_pgsql.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library 'pgsql' (tried: /opt/bitnami/php/lib/php/extensions/pgsql (/opt/bitnami/php/lib/php/extensions/pgsql: cannot open shared object file: No such file or directory), /opt/bitnami/php/lib/php/extensions/pgsql.so (/opt/bitnami/php/lib/php/extensions/pgsql.so: cannot open shared object file: No such file or directory)) in Unknown on line 0

jota 2019-11-12 10:15:05 UTC #6

Hi @darkwings92,

As I mentioned, Discourse comes with PostgreSQL, you don't need to install it.

The Bitnami stacks doesn't use the system's packages. That apt-get command doesn't modify the Bitnami installation at all, that's why you are getting the error after enabling the PHP's extension.

As I mentioned before, if you launched a Bitnami Discourse stack, it comes with PostgreSQL and the required extensions to connect to that database

$ php -m | grep pgsql
pdo_pgsql
pgsql

Can you confirm you are using the Bitnami Discourse stack or are you using a different one?

PS: If you have a Bitnami LAPP stack, you also have these extensions enabled by default.

Thanks

darkwings92 2019-11-12 17:23:51 UTC #7

I'm not using LAPP AFAIK, it is an AWS and it only has wordpress installed, I don't know if I can install more apps using the terminal, I don't have access to the AWS account.

jota 2019-11-13 10:24:05 UTC #8

Hi @darkwings92

The WordPress solution doesn't include PostgreSQL and that's why you can't use that extension with PHP. If you want to deploy a custom PHP application with PostgreSQL, you will need to use the LAPP solution that comes with PostgreSQL and the pgsql extensions and deploy that custom application following this guide

https://docs.bitnami.com/aws/infrastructure/lapp/administration/create-custom-application-php/

Happy to help!

Was my answer helpful? Click on

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!