Error connecting to database

[mdr]

Hello. I'm trying to set up Zabbix on Ubuntu 18.04 with the following settings like the ubuntu guide instructed:

sudo wget https://repo.zabbix.com/zabbix/4.0/u...bionic_all.deb
sudo dpkg -i zabbix-release_4.0-2+bionic_all.deb
sudo apt update

sudo apt install zabbix-server-pgsql zabbix-frontend-php php-pgsql zabbix-agent

sudo -u postgres createuser --pwprompt zabbix
sudo -u postgres createdb -O zabbix zabbix

sudo zcat /usr/share/doc/zabbix-server-pgsql*/create.sql.gz | sudo -u zabbix psql zabbix

DBPassword=*************

php_value date.timezone Europe/Riga

sudo systemctl restart zabbix-server zabbix-agent apache2
sudo systemctl enable zabbix-server zabbix-agent apache2

http://***.***.***.***/zabbix

When I try to do the frontend setup, also following the instructions to the letter, I get Error connecting to database.

I haven't been able to find any solutions online, please advise.

Thanks
Matias