pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedUbuntu 18 + PHP 8.2 + PDO: can't find drivers
8+ messages / 4 participants
[nested] [flat]
* Ubuntu 18 + PHP 8.2 + PDO: can't find drivers
@ 2023-09-22 20:39 Chris Kelly <sampro_domains@yahoo.com>
0 siblings, 3 replies; 8+ messages in thread
From: Chris Kelly @ 2023-09-22 20:39 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
The need has mostly passed (I used another computer with Ubuntu 20) but are there clear, *working* instructions for how to connect to Postgress on Ubuntu 18 via PDO? I don't see drivers that would work. This is for a Drupal site.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers
@ 2023-09-22 20:47 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Chris Kelly <sampro_domains@yahoo.com>
2 siblings, 0 replies; 8+ messages in thread
From: Adrian Klaver @ 2023-09-22 20:47 UTC (permalink / raw)
To: Chris Kelly <sampro_domains@yahoo.com>; pgsql-general@lists.postgresql.org
On 9/22/23 13:39, Chris Kelly wrote:
> The need has mostly passed (I used another computer with Ubuntu 20) but are there clear, *working* instructions for how to connect to Postgress on Ubuntu 18 via PDO? I don't see drivers that would work. This is for a Drupal site.
1) I'm assuming that when you refer to Ubuntu 18 and 20 you mean 18.04
LTS and 20.04 LTS. Is that correct?
2) What Postgres version?
3) What did you try?
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers
@ 2023-09-22 21:37 Ray O'Donnell <ray@rodonnell.ie>
parent: Chris Kelly <sampro_domains@yahoo.com>
2 siblings, 1 reply; 8+ messages in thread
From: Ray O'Donnell @ 2023-09-22 21:37 UTC (permalink / raw)
To: Chris Kelly <sampro_domains@yahoo.com>; pgsql-general@lists.postgresql.org
On 22 September 2023 21:40:38 Chris Kelly <sampro_domains@yahoo.com> wrote:
> The need has mostly passed (I used another computer with Ubuntu 20) but are
> there clear, *working* instructions for how to connect to Postgress on
> Ubuntu 18 via PDO? I don't see drivers that would work. This is for a
> Drupal site.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers
@ 2023-09-22 21:39 Ray O'Donnell <ray@rodonnell.ie>
parent: Chris Kelly <sampro_domains@yahoo.com>
2 siblings, 0 replies; 8+ messages in thread
From: Ray O'Donnell @ 2023-09-22 21:39 UTC (permalink / raw)
To: Chris Kelly <sampro_domains@yahoo.com>; pgsql-general@lists.postgresql.org
On 22 September 2023 21:40:38 Chris Kelly <sampro_domains@yahoo.com> wrote:
> The need has mostly passed (I used another computer with Ubuntu 20) but are
> there clear, *working* instructions for how to connect to Postgress on
> Ubuntu 18 via PDO? I don't see drivers that would work. This is for a
> Drupal site.
PS - depending on your Ubuntu version, you might need to take packages from
deb.sury.org in order to get PHP 8.2. I use them all the time, they're very
good.
Ray
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers
@ 2023-09-23 18:56 Chris Kelly <sampro_domains@yahoo.com>
parent: Ray O'Donnell <ray@rodonnell.ie>
0 siblings, 2 replies; 8+ messages in thread
From: Chris Kelly @ 2023-09-23 18:56 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
On Ubuntu "18.04.6 LTS (Bionic Beaver)":
# apt-cache search pgsql | grep 8
pike7.8-pg - PostgreSQL modules for Pike
pike8.0-pg - PostgreSQL modules for Pike
# apt-cache search pgsql | grep php
php-pgsql - PostgreSQL module for PHP [default]
php7.2-pgsql - PostgreSQL module for PHP
php-db - Database Abstraction Layer
php-mdb2-driver-pgsql - pgsql MDB2 driver
This is for an existing site with an existing db dump and an existing codebase. I can't use PHP7 due to composer requirements.
I tried to add the ondrej repo but got "The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29".
On Friday, September 22, 2023 at 02:38:24 PM PDT, Ray O'Donnell <ray@rodonnell.ie> wrote:
On 22 September 2023 21:40:38 Chris Kelly <sampro_domains@yahoo.com> wrote:
The need has mostly passed (I used another computer with Ubuntu 20) but are there clear, *working* instructions for how to connect to Postgress on Ubuntu 18 via PDO? I don't see drivers that would work. This is for a Drupal site.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers
@ 2023-09-23 21:14 postmaster@heinz-it.de
parent: Chris Kelly <sampro_domains@yahoo.com>
1 sibling, 1 reply; 8+ messages in thread
From: postmaster@heinz-it.de @ 2023-09-23 21:14 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
Am 23.09.23 um 20:56 schrieb Chris Kelly:
> On Ubuntu "18.04.6 LTS (Bionic Beaver)":
>
> # apt-cache search pgsql | grep 8
> pike7.8-pg - PostgreSQL modules for Pike
> pike8.0-pg - PostgreSQL modules for Pike
>
>
> # apt-cache search pgsql | grep php
> php-pgsql - PostgreSQL module for PHP [default]
> php7.2-pgsql - PostgreSQL module for PHP
> php-db - Database Abstraction Layer
> php-mdb2-driver-pgsql - pgsql MDB2 driver
>
>
> This is for an existing site with an existing db dump and an existing codebase. I can't use PHP7 due to composer requirements.
>
> I tried to add the ondrej repo but got "The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29".
>
>
> On Friday, September 22, 2023 at 02:38:24 PM PDT, Ray O'Donnell <ray@rodonnell.ie> wrote:
>
>
> On 22 September 2023 21:40:38 Chris Kelly <sampro_domains@yahoo.com> wrote:
>
> The need has mostly passed (I used another computer with Ubuntu 20) but are there clear, *working* instructions for how to connect to Postgress on Ubuntu 18 via PDO? I don't see drivers that would work. This is for a Drupal site.
>
> From memory (not at my laptop now) you need to install the php8.2-pgsql package (or maybe it's php8.2-pdo-pgsql). It should just work then... Drupal will notice the driver and offer Postgresql as an option on installation. Don't forget to restart Apache after installing that package
> Ray.
read this
https://stackoverflow.com/questions/76864353/php8-2-in-ubuntu-18-04-e-unable-to-locate-package-php8-...
i would say it's time to update/upgrade or maybe build php from sources
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers
@ 2023-09-24 11:56 Ray O'Donnell <ray@rodonnell.ie>
parent: Chris Kelly <sampro_domains@yahoo.com>
1 sibling, 0 replies; 8+ messages in thread
From: Ray O'Donnell @ 2023-09-24 11:56 UTC (permalink / raw)
To: Chris Kelly <sampro_domains@yahoo.com>; pgsql-general@lists.postgresql.org
On 23/09/2023 19:56, Chris Kelly wrote:
> On Ubuntu "18.04.6 LTS (Bionic Beaver)":
>
> # apt-cache search pgsql | grep 8
> pike7.8-pg - PostgreSQL modules for Pike
> pike8.0-pg - PostgreSQL modules for Pike
>
>
> # apt-cache search pgsql | grep php
> php-pgsql - PostgreSQL module for PHP [default]
> php7.2-pgsql - PostgreSQL module for PHP
> php-db - Database Abstraction Layer
> php-mdb2-driver-pgsql - pgsql MDB2 driver
>
>
> This is for an existing site with an existing db dump and an existing
> codebase. I can't use PHP7 due to composer requirements.
>
> I tried to add the ondrej repo but got "The following signatures
> couldn't be verified because the public key is not available: NO_PUBKEY
> 467B942D3A79BD29".
Yes, you need to add the key first - I think the instructions are on the
website - not in a position to check just now.
Ray.
--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers
@ 2023-09-24 15:50 Chris Kelly <sampro_domains@yahoo.com>
parent: postmaster@heinz-it.de
0 siblings, 0 replies; 8+ messages in thread
From: Chris Kelly @ 2023-09-24 15:50 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
Suddenly everything becomes clear: I'm running an OS that reached EOL 3 months ago. I'll upgrade to Ubuntu 20 if I need to get it working on this computer. Thanks.
On Saturday, September 23, 2023 at 02:15:19 PM PDT, <postmaster@heinz-it.de> wrote:
Am 23.09.23 um 20:56 schrieb Chris Kelly:
> On Ubuntu "18.04.6 LTS (Bionic Beaver)":
>
> # apt-cache search pgsql | grep 8
> pike7.8-pg - PostgreSQL modules for Pike
> pike8.0-pg - PostgreSQL modules for Pike
>
>
> # apt-cache search pgsql | grep php
> php-pgsql - PostgreSQL module for PHP [default]
> php7.2-pgsql - PostgreSQL module for PHP
> php-db - Database Abstraction Layer
> php-mdb2-driver-pgsql - pgsql MDB2 driver
>
>
> This is for an existing site with an existing db dump and an existing codebase. I can't use PHP7 due to composer requirements.
>
> I tried to add the ondrej repo but got "The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29".
>
>
> On Friday, September 22, 2023 at 02:38:24 PM PDT, Ray O'Donnell <ray@rodonnell.ie> wrote:
>
>
> On 22 September 2023 21:40:38 Chris Kelly <sampro_domains@yahoo.com> wrote:
>
> The need has mostly passed (I used another computer with Ubuntu 20) but are there clear, *working* instructions for how to connect to Postgress on Ubuntu 18 via PDO? I don't see drivers that would work. This is for a Drupal site.
>
> From memory (not at my laptop now) you need to install the php8.2-pgsql package (or maybe it's php8.2-pdo-pgsql). It should just work then... Drupal will notice the driver and offer Postgresql as an option on installation. Don't forget to restart Apache after installing that package
> Ray.
read this
https://stackoverflow.com/questions/76864353/php8-2-in-ubuntu-18-04-e-unable-to-locate-package-php8-...
i would say it's time to update/upgrade or maybe build php from sources
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2023-09-24 15:50 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-09-22 20:39 Ubuntu 18 + PHP 8.2 + PDO: can't find drivers Chris Kelly <sampro_domains@yahoo.com>
2023-09-22 20:47 ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-09-22 21:37 ` Ray O'Donnell <ray@rodonnell.ie>
2023-09-23 18:56 ` Chris Kelly <sampro_domains@yahoo.com>
2023-09-23 21:14 ` postmaster@heinz-it.de
2023-09-24 15:50 ` Chris Kelly <sampro_domains@yahoo.com>
2023-09-24 11:56 ` Ray O'Donnell <ray@rodonnell.ie>
2023-09-22 21:39 ` Ray O'Donnell <ray@rodonnell.ie>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox