Thread: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers

The need has mostly passed (I used another computer with Ubuntu 20) but are there clear, *working* instructions for how
toconnect to Postgress on Ubuntu 18 via PDO? I don't see drivers that would work. This is for a Drupal site.
 

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
howto 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

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
howto 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
shouldjust work then... Drupal will notice the driver and offer Postgresql as an option on installation. Don't forget
torestart 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-2
i would say it's time to update/upgrade or maybe build php from sources

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