Re: postgresql connection failed - could not encrypt

--===============5249214758334564365==
Content-Type: multipart/alternative; boundary="0000000000003ae0bd0605ed0946"

--0000000000003ae0bd0605ed0946
Content-Type: text/plain; charset="UTF-8"

We connect using ecpg, can you connect with a simple esql/c program?

On Fri, 22 Sept 2023, 05:40 Michael Pope, <[email protected]> wrote:

> Hi,
>
> When I compile my 4gl file I get an error 'could not encrypt'
>
>
> Compile command
>
> $ 4glpc with_db.4gl -o with_db
>
>
> Error
> database pais_legacy
>
> MAIN
> |_^
> | Error at line 11, character 3
> | Could not connect to database pais_legacy (connection to server at
> "127.0.0.1", port 5432 failed: could not encrypt) (MAIN)
>
>
> I can access the 'pais_legacy' on the command line manually and see the
> tables;
>
> $ psql -h 127.0.0.1 -U postgres pais_legacy
>
>
> I've set the following environment variables;
>
>       - A4GL_UI=TUI
>       - A4GL_DBDATE="DMY4"
>       - A4GL_SQLTYPE=pg8
>       - PG_DATABASE=pais_legacy
>       - PG_PORT=5432
>       - PG_HOST=127.0.0.1
>       - PG_USER=postgres
>       - PG_PASSWORD=<my password>
>
> What am I missing here?
>
>
> --
> Regards,
>
> *Michael Pope*
>
> _______________________________________________
> Aubit4gl-discuss mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
>

--0000000000003ae0bd0605ed0946
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">We connect using ecpg, can you connect with a simple esql=
/c program?=C2=A0</div><br><div class=3D"gmail_quote"><div dir=3D"ltr" clas=
s=3D"gmail_attr">On Fri, 22 Sept 2023, 05:40 Michael Pope, &lt;<a href=3D"m=
ailto:[email protected]">[email protected]</a>&gt; wrote:<br></div>=
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
 =20

   =20
 =20
  <div>
    <p>Hi,</p>
    <p>When I compile my 4gl file I get an error &#39;could not encrypt&#39=
;</p>
    <p><br>
    </p>
    <p>Compile command</p>
    <p>$ 4glpc with_db.4gl -o with_db<br>
    </p>
    <p><br>
    </p>
    <p>Error<br>
      <font face=3D"monospace">database pais_legacy<br>
        <br>
        MAIN<br>
        |_^<br>
        | Error at line 11, character 3<br>
        | Could not connect to database pais_legacy (connection to
        server at &quot;127.0.0.1&quot;, port 5432 failed: could not encryp=
t)
        (MAIN)<br>
      </font></p>
    <p><br>
    </p>
    <p>I can access the &#39;pais_legacy&#39; on the command line manually =
and
      see the tables;<br>
    </p>
    <p>$ psql -h 127.0.0.1 -U postgres pais_legacy</p>
    <p><br>
    </p>
    <p>I&#39;ve set the following environment variables;</p>
    <p>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 - A4GL_UI=3DTUI<br>
      =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 - A4GL_DBDATE=3D&quot;DMY4&quot;<br>
      =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 - A4GL_SQLTYPE=3Dpg8<br>
      =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 - PG_DATABASE=3Dpais_legacy<br>
      =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 - PG_PORT=3D5432<br>
      =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 - PG_HOST=3D127.0.0.1<br>
      =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 - PG_USER=3Dpostgres<br>
      =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 - PG_PASSWORD=3D&lt;my password&gt;<br=
>
      <br>
    </p>
    <p>What am I missing here?<br>
    </p>
    <p><br>
    </p>
    <div>-- <br>
      <div dir=3D"ltr">
        <div>Regards,</div>
        <div><br>
        </div>
        <div><b>Michael Pope</b></div>
        <br>
      </div>
    </div>
  </div>

_______________________________________________<br>
Aubit4gl-discuss mailing list<br>
<a href=3D"mailto:[email protected]" target=3D"_blank"=
 rel=3D"noreferrer">[email protected]</a><br>
<a href=3D"https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss" r=
el=3D"noreferrer noreferrer" target=3D"_blank">https://lists.sourceforge.ne=
t/lists/listinfo/aubit4gl-discuss</a><br>
</blockquote></div>

--0000000000003ae0bd0605ed0946--


--===============5249214758334564365==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============5249214758334564365==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Aubit4gl-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss

--===============5249214758334564365==--