HelioHost Posted March 9, 2023 Posted March 9, 2023 Username: pysimplesql, Server: Tommy, Main domain: pysimplesql.heliohost.usHello, I have both a Maria and Postgres database set up, each on their own domain. I can connect to the Maria database just fine, but for some reason I'm unable to connect to the Postgres database. Using psycopg2 in python, I get the following error: psycopg2.OperationalError: connection to server at "65.19.141.77", port 5432 failed: FATAL: no pg_hba.conf entry for host "129.222.220.164", user "pysimplesql_admin", database "pysimplesql_examples", SSL off I've checked Plesk and have not been able to find any kind of configuration for the Postgres database. Thanks for any assistance you can provide
Kairion Posted March 9, 2023 Posted March 9, 2023 Hi pysimplesql. For PostgreSQL databases you need to request remote access to be enabled on your database. Could you please tell us what is the database name and confirm which database user will have remote access enabled? I'm guessing the username will be pysimplesql_admin, but I'm asking just to be sure (and because we also need the database name). When you provide us those information a root admin can enable remote access for you.
Krydos Posted March 10, 2023 Posted March 10, 2023 18 hours ago, HelioHost said: no pg_hba.conf entry for host "129.222.220.164", user "pysimplesql_admin", database "pysimplesql_examples" 7 hours ago, Kairion said: Could you please tell us what is the database name and confirm which database user will have remote access enabled? The error message lists the database and the user they were trying to connect with. Remote access enabled.
HelioHost Posted March 10, 2023 Author Posted March 10, 2023 Yes, I would like remote access enabled for pysimplesql_user and pysimplesql_admin users, to the pusimplesql_examples database. Thanks again, Jon On Fri, Mar 10, 2023, 2:17 AM HelioHost Support wrote: > 18 hours ago, HelioHost said: no pg_hba.conf entry for host > "129.222.220.164", user "pysimplesql_admin", database > "pysimplesql_examples" 7 hours ago, Kairion said: Could you please tell us > what is the database name and confirm which database user will have remote > access enabled? The error message lists the database and the user they were > trying to connect with. Remote access enabled. > > You may view the status of your ticket by visiting: > > https://helionet.org/index/index.php?showtopic=55290 > > Thank you, > Heliohost support > https://heliohost.org/ > https://helionet.org/ > >
Krydos Posted March 10, 2023 Posted March 10, 2023 The user pysimplesql_user now has remote access to the pysimplesql_examples database as well.
HelioHost Posted March 11, 2023 Author Posted March 11, 2023 Hello, I'm still having some issues with Postgres: - The user pysimplesql_admin works and I'm able to query the pysimplesql_database - The user pysimplesql_user does not work and is unable to query the pysimplesql_examples database (only empty resultsets are returned). Additionally, once working I want this user to only have select, insert, create, delete access - I've found no way to get to any type of web admin for the Postgres database - is this normal? Thanks, Jon On Fri, Mar 10, 2023 at 5:09?PM HelioHost Support wrote: > The user pysimplesql_user now has remote access to > the pysimplesql_examples database as well. > > You may view the status of your ticket by visiting: > > https://helionet.org/index/index.php?showtopic=55290 > > Thank you, > Heliohost support > https://heliohost.org/ > https://helionet.org/ > >
Krydos Posted March 12, 2023 Posted March 12, 2023 I have set the owner of the database pysimplesql_examples to pysimplesql_admin. See if you can grant access to pysimplesql_user yourself now. As far as web admin goes you can install phppgadmin on your account if you want. Since you already have remote access you can use psql on the command line, or pgadmin or something.
Recommended Posts