pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Ubuntu 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