postgresql connection failed - could not encrypt

Michael Pope <[email protected]> Fri, 22 Sep 2023 13:39:52 +1000
Newsgroups gmane.comp.lang.4gl.aubit.general
Message-ID <[email protected]> 
This is a multi-part message in MIME format.
--===============0148430443409212790==
Content-Type: multipart/alternative;
 boundary="------------VBbwAvhIc37GCvu7bMG6IfJx"
Content-Language: en-US

This is a multi-part message in MIME format.
--------------VBbwAvhIc37GCvu7bMG6IfJx
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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*

--------------VBbwAvhIc37GCvu7bMG6IfJx
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Hi,</p>
    <p>When I compile my 4gl file I get an error 'could not encrypt'</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="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 "127.0.0.1", port 5432 failed: could not encrypt)
        (MAIN)<br>
      </font></p>
    <p><br>
    </p>
    <p>I can access the 'pais_legacy' 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've set the following environment variables;</p>
    <p>      - A4GL_UI=TUI<br>
            - A4GL_DBDATE="DMY4"<br>
            - A4GL_SQLTYPE=pg8<br>
            - PG_DATABASE=pais_legacy<br>
            - PG_PORT=5432<br>
            - PG_HOST=127.0.0.1<br>
            - PG_USER=postgres<br>
            - PG_PASSWORD=&lt;my password&gt;<br>
      <br>
    </p>
    <p>What am I missing here?<br>
    </p>
    <p><br>
    </p>
    <div class="moz-signature">-- <br>
      <div dir="ltr">
        <div>Regards,</div>
        <div><br>
        </div>
        <div><b>Michael Pope</b></div>
        <br>
      </div>
    </div>
  </body>
</html>

--------------VBbwAvhIc37GCvu7bMG6IfJx--


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


--===============0148430443409212790==
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

--===============0148430443409212790==--