Contents
Probably your PostgreSQL server isn't allowing incoming connections through the network. Check the file pg_hba.conf (location in Fedora: /var/lib/pgsql/data/, Debian/Ubuntu: /etc/postgresql/<version>/main/). You will probably need to add the following lines:
# TYPE DATABASE USER CIDR-ADDRESS METHOD # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5
If your system uses SELinux (Fedora does), you also need to allow network connections from Apache to the database with:
setsebool -P httpd_can_network_connect_db 1
Maybe you haven't set the storage files up. Check the actual reason of your problem with:
# systemctl status postgresql.service systemd[1]: Starting PostgreSQL database server... postgresql-check-db-dir[10598]: Directory "/var/lib/pgsql/data" is missing or empty. postgresql-check-db-dir[10598]: Use "/usr/bin/postgresql-setup --initdb" postgresql-check-db-dir[10598]: to initialize the database cluster. postgresql-check-db-dir[10598]: See /usr/share/doc/postgresql/README.rpm-dist for more informa systemd[1]: postgresql.service: Control process exited, code=exited status=1
Follow the instructions to fix it:
# /usr/bin/postgresql-setup --initdb * Initializing database in '/var/lib/pgsql/data' * Initialized, logs are in /var/lib/pgsql/initdb_postgresql.log
Edit the configuration file php.ini, adding a line like the following one but changing Europe/Madrid with your own time zone:
date.timezone = Europe/Madrid
php.ini is usually located in:
Disable error output in PHP settings. Edit the configuration file php.ini and locate the parameter display_errors, changing its value to off:
display_errors = Off
This file is part of PhpReport 2.22-126-g762ba97a documentation. Generated on Wed 12 Jul 2023 05:04:53 PM UTC