kkaviani

Thank you!

Hi, I have a pg database that my app uses, and I would like to connect to it via pgAdmin. I used to do this about a year or two ago, but I don't have the conection string anymore. If I just try the ip address of the site for host name, I get connection failed: connection to server at "65.19.154.90", port 5432 failed: FATAL: no pg_hba.conf entry for host "136.152.214.87", user "kkaviani_admin", database "kkaviani_poems", SSL on connection to server at "65.19.154.90", port 5432 failed: FATAL: no pg_hba.conf entry for host "136.152.214.87", user "kkaviani_admin", database "kkaviani_poems", SSL off If I try tommy.heliohost.org as hostname, I get connection failed: connection to server at "65.19.154.90", port 5432 failed: FATAL: no pg_hba.conf entry for host "136.152.214.87", user "kkaviani_admin", database "kkaviani_poems", SSL on connection to server at "65.19.154.90", port 5432 failed: FATAL: no pg_hba.conf entry for host "136.152.214.87", user "kkaviani_admin", database "kkaviani_poems", SSL off Multiple connection attempts failed. All failures were: - host: 'tommy.heliohost.org', port: '5432', hostaddr: '2001:470:1:1ee::1002': connection failed: connection to server at "2001:470:1:1ee::1002", port 5432 failed: FATAL: no pg_hba.conf entry for host "2607:f140:400:13b:e8de:c71f:985d:ad55", user "kkaviani_admin", database "kkaviani_poems", SSL on connection to server at "2001:470:1:1ee::1002", port 5432 failed: FATAL: no pg_hba.conf entry for host "2607:f140:400:13b:e8de:c71f:985d:ad55", user "kkaviani_admin", database "kkaviani_poems", SSL off - host: 'tommy.heliohost.org', port: '5432', hostaddr: '65.19.154.90': connection failed: connection to server at "65.19.154.90", port 5432 failed: FATAL: no pg_hba.conf entry for host "136.152.214.87", user "kkaviani_admin", database "kkaviani_poems", SSL on connection to server at "65.19.154.90", port 5432 failed: FATAL: no pg_hba.conf entry for host "136.152.214.87", user "kkaviani_admin", database "kkaviani_poems", SSL off I know Heliohost has recently went through some changes. Is this something you have to enable again? Please help me connect remotely to this database: kkaviani_poems, user kkaviani_admin.

Fantastic! Thank you very much.

@wolstech All right, awesome! So we don't need this acme verification TXT record anymore, is that correct? After this change you've made, everything just seems to be working.

Hi, I have two apps under my account kkaviani in Tommy. I recently got several emails from Heliohost saying that the TLS certificates could not be renewed. So as of today, the certificates have all expired. When I go to renew them by clicking Reissue Certificate, I get this error: Could not issue an SSL/TLS certificate for qasemghazanfar.com Details Could not issue a Let's Encrypt SSL/TLS certificate for qasemghazanfar.com. Authorization for the domain failed. Details Invalid response from https://acme-v02.api.letsencrypt.org/acme/authz/xxxxx/xxxxx. Details: Type: urn:ietf:params:acme:error:connection Status: 400 Detail: xx.xx.xxx.xx: Fetching https://qasemghazanfar.com/.well-known/acme-challenge/xxxxx: Timeout during connect (likely firewall problem) Is the Tommy server having firewall problems when obtaining new TLS certificates from this ACME API? Thanks for your help.

Thank you, Krydos! My app is back up after this.

Actually I realized the error logs make it clear that it is python 3.12 that's running. So please install `psycopg2` for python 3.12.

I believe it's python 3.12, but might have to double check. I have no way of knowing for sure.

Please install `psycopg2` in Tommy. Any version will do, as long as it is compatible with the python3 currently running the web applications for my user kkaviani. Thanks.

Hi KazVee, thanks for the links. Per the instructions here I would like to request the above modules be installed for python3. All versions of the python3 are okay. It should be the same python currently running my apps and generating the 500 error. My account username is kkaviani, the server is Tommy I believe. Any version of the listed modules will be okay as long as it is compatible with the version of python. Here's the list again: dotenv flask flask_sqlalchemy flask_login flask_wtf wtforms passlib requests urllib mailjet_rest

Please install `dotenv flask flask_sqlalchemy flask_login flask_wtf wtforms passlib requests urllib mailjet_rest`. Thank you.