Categories
Linux Mastering Development Ubuntu

Error: Could not find pg_ctl executable for version 11 (PostgreSQL 11) + let’s encrypt

I have a VPS hosting with a domain redirecting to it.
I have LAMP stack for my main website using WordPress CMS.
Plus I am using Odoo as my back-end with python and PostgreSQL in a sub-domain.

Everything was working fine until I installed Certbot Let’s Encrypt to obtain an SSL certificate by following these tutorials

For My WordPress i installed is plugin:

WP Encryption – One Click single / wildcard Free SSL certificate & force HTTPS

Which got me in a loop because it forced the https i will explain it later on

So when the plugin didn’t work i searched for another way for the the Whole VPS with these tutorials:

How To Secure Apache with Let’s Encrypt on Ubuntu 16.04

How To Secure Apache with Let’s Encrypt on Ubuntu 18.04

After completing the second tutorial for ubuntu 18.04 i noticed that all my domain traffic is going to https and it got stuck in a loop saying same as i said above

“ERR_TOO_MANY_REDIRECTS which means Site redirected too many times”

and couldn’t access the website front-end for the wordpress in the doamin.

Then when i applied

“Step 3 — Allowing HTTPS Through the Firewall”

my internet connection got interpreted and when i got back to the ssh session i found my self locked out of the server and did not find any way to get back in.

And when i tired to use the sub-domain that has Odoo on it i have got the same errr

“ERR_TOO_MANY_REDIRECTS which means Site redirected too many times”

Until here i was hopeless and did’t know what to do.

I contacted my VPS server provider and told him about what exactly happened. Then some how he managed to get me into the server again with a URL to the terminal i still couldn’t access the server using ssh clients like putty.. so when i entered the server after he provided me with the URL first thing noticed is that he “rebooted the VPS” will get to this in a second.

So first thing i did was removing the wordpress plugin “WP Encryption” and update the wordpress site-url in wp_options table in mysql database because the plugin changed it from http to https so i changed it back and that solved the ERR_TOO_MANY_REDIRECTS for my website.

Then the second thing i did was disabling the ufw firewall that i enabled in the tutorial in Step 3 above.

I instantly got my connection to the server back using ssh client putty but what i have noticed again is the postgres service was inactive and went down with the reboot of the VPS. i tried to start the service but it didn’t a gave me this error.

Failed to start postgresql.service: Unit postgresql.service is masked.

i searched for a soultion and found these commands to unmask

sudo systemctl unmask postgresql
sudo systemctl enable postgresql
sudo systemctl restart postgresql

and then the service has started and everything sames Ok when i run the status command

service postgresql status

the response is

● postgresql.service - LSB: PostgreSQL RDBMS server
   Loaded: loaded (/etc/init.d/postgresql; generated)
   Active: active (exited) since Thu 2020-03-26 05:54:09 UTC; 2h 22min ago
     Docs: man:systemd-sysv-generator(8)
    Tasks: 0 (limit: 2286)
   Memory: 0B
   CGroup: /system.slice/postgresql.service

but when i try to connect to postgres through the default port is says:

could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"

after many searches i made i found the posgres main cluster is also inactive or down i tried to start it with this command

pg_ctlcluster 11 main start

but i have got this error

Job for postgresql@11-main.service failed because the service did not take the steps required by its unit configuration. See "systemctl status postgresql@11-main.service" and "journalctl -xe" for details.

and when i run the command as requested

systemctl status postgresql@11-main.service

i have got this error

● postgresql@11-main.service - PostgreSQL Cluster 11-main    Loaded: loaded (/lib/systemd/system/postgresql@.service; disabled; vendor preset: enabled)    Active: failed (Result: protocol) since Thu 2020-03-26 15:22:15 UTC; 14s ago   Process: 18930 ExecStart=/usr/bin/pg_ctlcluster --skip-systemctl-redirect 11-main start (code=exited, status=1/FAILURE)

alone with

systemd[1]: Starting PostgreSQL Cluster 11-main...
postgresql@11-main[18930]: Error: Could not find pg_ctl executable for version 11
systemd[1]: postgresql@11-main.service: Can't open PID file /run/postgresql/11-main.pid (yet?) after start: No such file or
systemd[1]: postgresql@11-main.service: Failed with result 'protocol'.
systemd[1]: Failed to start PostgreSQL Cluster 11-main.

I guessed Let’s Encrypt added an ssl configuration to the pg_hba.conf and postgres.conf like id did with apache so i searched for them and commented the “ssl on” lines and restarted postgres service along with the main cluster but nothing happened still the the same error which is

Error: Could not find pg_ctl executable for version 11

I have searched a lot for this problem but nothing worked how can i solve the pg_ctl executable in version 11 ??

Thanks in advanced i really appreciate it

Ps:
I am using Ubuntu 19.10 (GNU/Linux 5.3.0-24-generic x86_64)
Odoo 11 with postgres 11 as the database odoo can’t connect to postgres as i mentioned before

Leave a Reply

Your email address will not be published. Required fields are marked *