Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qkRNu-00ET3g-Qp for pgsql-general@arkaria.postgresql.org; Sun, 24 Sep 2023 15:51:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qkRNr-009UD5-Kt for pgsql-general@arkaria.postgresql.org; Sun, 24 Sep 2023 15:50:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qkRNq-009UCm-Tc for pgsql-general@lists.postgresql.org; Sun, 24 Sep 2023 15:50:59 +0000 Received: from sonic307-2.consmr.mail.bf2.yahoo.com ([74.6.134.41]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qkRNj-006OFH-0c for pgsql-general@lists.postgresql.org; Sun, 24 Sep 2023 15:50:57 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1695570647; bh=yqxnvuxk75h5XNxp2NuKHIXbDnzIaEE6iH+iP+TNVf8=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=otpO1PhY7oij7iuB+ABTXgTBoLi4rYOEcZZc21euLs/768mb3WWKRORYig4L3kTM7o6lpCyCKbtc3rHMOmfPa00vlNjM0hgK87D/jMfBKQBYKHp3NaFEaQe51hlUXC5D5X5q2H05Y7xj3u7bf7Ptt+lVqikbw02s61Wf7eskyeyPJmy722mqF4phkzUX6D0Vk63d3w4E6kMHJ25WSxtNUuzhSGHNNykIlpqGW4CQ6sG58YAil0Q79ZyzpuLkDwECoXXwnpfgpjjMLzJXs6dJww0kR7dLeN0WyQpjwUkclvfFqGeOCVfJ3StP/VZM3Yr6qiXiuWv/dzY9ykoAZ74RCA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1695570647; bh=TtjH4jOdCrLV7Lwh3klEjpxG8Rm4iRpbcxkoFX5Aol7=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=IL7uwCQnwLR9wCXz+jMwqTD3MbI73rrRAorBJZCoLfONuTLLElwIed3w+JY92zC8xfkyNps1oRZep+giZJZYwgxko3coYGYk3VOm1OKCihisGRMyUmyi60cfCib7yWOWqIOKIG24tl1+EzkEiDMhMFR5jWFYHzW50fYyamz9YB+lUpaUBmDNOndJmkRI01yo8is6s17XPzOL5zBLTxKB9U26oAyDgiEncx660QuS3dFFVh5j5ntmto58n4S2lZNkd+wI3CwQZTDUTnV5+VezZrf9lWoIXk3zioWk/ce5b6+eV4Q+dIiieV9IA64EjhC+smlVgvlnqX/11jkYhXXw0Q== X-YMail-OSG: 54EqYjYVM1lx_dr7VYZVr_._ksCi_PZoHNIFkRBx81UxyL8rY0Rslb2XjQw0S.n XjgCtu6IzqEMmaPjANKwdLkkzG_ZpOkvl_ZTETr9BkmLOrmCHgjfNdpV1J38qXwNfPWa71LAnmCj Xq6c65lHDkI7DiQYZPKO2Qv.50lUXVwSwv3fW4D40XLoNHBeHH.UsF80NjJCpo7qeqrtZIRTfRl9 c70NrxjX_11QLfYaAPHo1h8ANcv4xoHn50d3BZcxhG9wDzTC03Lmr0x3MXORkmoviTwCCyLQ3x8Z zvsHp2Ofqb8swT7tWt55Sqh1t4jfkb5PPSAJm8WHInKmnDpYY4maIvexqs41hmrLz.h8jR460exy WVvGH1ZuliJMF6ORLDou2o1xYpQMs1eHkjbibitPcNtx6v368K7K_vDR3ZAMM6GdV1jYPltpTWBA XCaap7uUNuCT9ilxfHHLB9N_P.OBc1X750LmYhbyQeWsdvarvlMbKmARg4hDOYzXyI8ECNVd1rXZ UYNDBxcQAVk1Vmtx2G9blg8dtrundG.FcbJux8SeC_fAK9aC8dDqNJ3mAdNErj_BW2RC7ADskTty n0IBHxzLj8gm_jV32zf6oXGO7iGdDb31SbMTwKUnIpI540zttjQDfiQX0SsPS.rfBMtmaIKkl4sQ 1wCyJpInwCSOn.m5P59wAm0jO5sD.HEHCqCP3GFfEaDN1PEdpzkRwzNVS3QS9kaCpXZm6jHCf56J 1qlYUdIgXunHt1VGm3eJhPW_M1A0dCrgn_O5NtPeDbjDCJh9vQruH_fp3pnT35M841cu4Zy1Zafn 1IQu3NbWHTVFxlxBZ7uVrkXvQwXcPrFmbgVKT40ZjLX5W7foiK5jhKnxu4232mhoJnvT0JQRhFXt 2gJNlvXzre456b_TJ836ZF.Oh_kYP29RFTfDzHFe_MFd9Qly2YZ4iWzsU9LUXr8TwMVie5O0JE1X GL_ZMXsZLorWA3_M3ax9bM67jMzYZo.LYL8cf8JWd8wXGXKdXGBmGE283.UC7E3hKRrU0rwGSpB1 EAbWCQOGZmxBg95r1elSm9Vh.YJO.FUgAJpOPGASrCWHKFZzALRExOEHNc9FgD1uj4BFc3U606x. iz1ME28qaVy_9owlthgP7gd3u1KDdiX41zPlx1oHQAYkW9oqc6OF5GHLf4A9lPH4A9vioVotNx0k pi56gOdrXqZ_f2bAoc3WMUP16Jn1xrPAKzvpC9spqqUL2dRL1NpZ77GT3XDI7.VXHIoDUYwVSb_r ytjvylM4nCVsOfbZxH9caqFWPxuVqR_vupBE6U.3FrFpQ4BqJD31Xcea3C9ZDi9D96woyLFyHOrm ekUnWeoovm81JdP.fWl4hRNa_Hf9ycDpDqG.3egtrGJe5VS3m9oLkb6Vcty8xc6g0yFRr7MzTtyR 115.V35DkB9Bn6e4jURLrwntfbIpZCk4.tGMbfz0g9iv3cWazGhLrSGqoJ_BNEAOtO698GtJ8Al. 3xFDBzLJ5plZrzAbGCFBKBHtt3o2vZ1CxTHJ8MP8j1UnIQwkZiBEiPFjZIRMs0ymDcaduh4jUhsl UpIG8nXat1mO0J8VQ5Glq0TzsHDh.LOoe3EPd1BAE7stJ9DktWknAD5AOqJKz6vkuQOJpkUGesIb aeD224lLtn83dnfDqh_SBt9S5Li8NndzSRZER6nvWSQmm9Zb9a9CZcu6VP1Vy0MWU5P4CvRQktqj u5v0u6opBqo5PPoxliB3jC9Sy3.KUqoicC0slVU1w1OEx5EZoV4GH6KMHgVL7QJM9N7ZLka4PVNE KW.VB2XXyGK1J7DC0ARvckmZg5zB73LdkTsSghfjK_EMzNuidk_K_p6OIgS3bEJpNmOINGLN3Rjc 2w_8epo7wFXcsm55oH7PhvsM5CGcH8HobEFUbLcjwlToAkSD2R.nlrFl8_MmgJv6X1p4rbVMQEQ8 r1ckpsBlsbS87vZg.4IPszj0YTucU6ZxsjqugpSZqNMIsbZpN6Y1d.o2NqhbybHFjv6U2vL5dzKf YKGffOhOU88N4aoa8_U62UFnDSr82b_WZNgaysnHUrBbmMZKw9308tPMmkeoz4XJ4p5pzs1mMHob APr0.yCHVA.q_8YGk3YAWhrwXPKrFH3EAsNY4XJ0QRrl.Z9eh_HeKDNwKoOInpHI0kXzQ_RvlPqQ .4x4yvkbA6qg74BxbBAeS52zSW4SyQ6rSHT3s0U7kgGxvnCcP72RSahP2rx4bzcSYWjn6_dTq8ZH .CPRL2oKkCBGqSrhD3ay1ojHwsKMPQEv7humzRbLAMGSMd1yfe8wZ5RiOMCNZQ2U- X-Sonic-MF: X-Sonic-ID: f39fadc2-93c8-4b69-a623-c647be2c2f59 Received: from sonic.gate.mail.ne1.yahoo.com by sonic307.consmr.mail.bf2.yahoo.com with HTTP; Sun, 24 Sep 2023 15:50:47 +0000 Date: Sun, 24 Sep 2023 15:50:45 +0000 (UTC) From: Chris Kelly To: pgsql-general@lists.postgresql.org Message-ID: <266549494.2475514.1695570645992@mail.yahoo.com> In-Reply-To: References: <916245735.130528.1695415197705.ref@mail.yahoo.com> <916245735.130528.1695415197705@mail.yahoo.com> <18abed3b888.2834.f9dd809031fc0469edf0bbbf79c1d468@rodonnell.ie> <1579525868.3160198.1695495398844@mail.yahoo.com> Subject: Re: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2475513_725641538.1695570645991" X-Mailer: WebService/1.1.21797 YMailNodin Content-Length: 5977 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_2475513_725641538.1695570645991 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Suddenly everything becomes clear: I'm running an OS that reached EOL 3 mo= nths ago. I'll upgrade to Ubuntu 20 if I need to get it working on this com= puter. Thanks. On Saturday, September 23, 2023 at 02:15:19 PM PDT, wrote: =20 =20 Am 23.09.23 um 20:56 schrieb Chris Kelly: >=C2=A0 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 cod= ebase. 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 467B942D3A7= 9BD29". > > >=C2=A0 =C2=A0 =C2=A0 On Friday, September 22, 2023 at 02:38:24 PM PDT, Ray= O'Donnell wrote: >=C2=A0=20 >=C2=A0=20 > On 22 September 2023 21:40:38 Chris Kelly wrot= e: > > The need has mostly passed (I used another computer with Ubuntu 20) but a= re there clear, *working* instructions for how to connect to Postgress on U= buntu 18 via PDO? I don't see drivers that would work. This is for a Drupal= site. > >=C2=A0 From memory (not at my laptop now) you need to install the php8.2-p= gsql 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 installa= tion. 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-unabl= e-to-locate-package-php8-2 i would say it's time to update/upgrade or maybe build php from sources =20 ------=_Part_2475513_725641538.1695570645991 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Suddenly everything becomes clear: I'm running an = OS that reached EOL 3 months ago. I'll upgrade to Ubuntu 20 if I need t= o 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
&= gt;
>
> # apt-cache search pgsql = | grep php
> php-pgsql - PostgreSQL module for PHP [de= fault]
> php7.2-pgsql - PostgreSQL module for PHP
> php-db - Database Abstraction Layer
&g= t; 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 compose= r requirements.
>
> I tried to ad= d the ondrej repo but got "The following signatures couldn't be verified be= cause 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 h= as mostly passed (I used another computer with Ubuntu 20) but are there cle= ar, *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 lapto= p now) you need to install the php8.2-pgsql package (or maybe it's php8.2-p= do-pgsql). It should just work then... Drupal will notice the driver and of= fer Postgresql as an option on installation. Don't forget to restart Apache= after installing that package
> Ray.

read this
https://stackoverflow.com/questions/7686= 4353/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 s= ources


=
------=_Part_2475513_725641538.1695570645991--