TimeTrex Time and Attendance

Dear all,

I installed Timetrex and used it for a while. Now I am getting the following error:

TimeTrex is unable to connect to its database, please make sure that the database service on your own local TimeTrex server has been started and is running. If you are unsure, try rebooting your server.

I checked via pgAdmin that DB is fine and connection can be established.

OS - Centos 7
TimeTrex version 11.1.4
PHP version 5.4.16
PostgreSQL server version 10

I saw on forum that changing installer_enabled from FALSE to TRUE might help.

I did this and got error as well

Connection to server as non privilege user is failed.

I have attached screen shots.

log file:

---------------[ 21-Feb-2018 10:17:06 +0000 [1519208226.6909] (PID: 32668) ]---------------
DEBUG [L0402] [00014ms]: [Function](): URI: /var/www/html/timetrex/tools/unattended_upgrade.php IP Address:
DEBUG [L0404] [00014ms]: [Function](): USER-AGENT: N/A
DEBUG [L0405] [00014ms]: [Function](): Version: 11.1.4 (PHP: v5.4.16) Edition: 10 Production: 1 Server: N/A OS: LINUX Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.php Demo Mode: 0
DEBUG [L0192] [00026ms]: TTDate::setTimeZone(): Setting TimeZone: GMT
DEBUG [L2989] [00030ms]: Misc::getCurrentOSUser(): Running as OS User: apache
DEBUG [L0923] [00030ms]: Install::checkPHPVersion(): Comparing with Version: 5.4.16
DEBUG [L0548] [00033ms]: TTi18n::chooseBestLocale(): Unable to find and set a locale.
DEBUG [L0187] [00033ms]: TTDate::setTimeZone(): TimeZone already set to: GMT
DEBUG [L0145] [00033ms]: [Function](): Version: 11.1.4 (PHP: v5.4.16) Edition: 10 Production: 1 Server: N/A Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.php Demo Mode: 0
DEBUG [L0165] [00033ms]: [Function](): Lock File: /tmp/timetrex/UnAttended_Upgrade_2737064364.lock
DEBUG [L0084] [00033ms]: LockFile::getCurrentPID(): Current PID: 32668
DEBUG [L0261] [00033ms]: [Function](): Checking requirements only...
DEBUG [L0264] [00033ms]: [Function](): Launched from web installer...
DEBUG [L2529] [00033ms]: Misc::cleanDir(): Cleaning: /tmp/timetrex Exclude Regex: \.ZIP|\.lock|.state|upgrade_staging
DEBUG [L0923] [00033ms]: Install::checkPHPVersion(): Comparing with Version: 5.4.16
DEBUG [L1493] [00033ms]: Install::checkPHPOpenBaseDir(): Open BaseDir:
---------------[ 21-Feb-2018 10:17:06 +0000 [1519208226.7237] (PID: 32668) ]---------------

Not much else to say other than TimeTrex can't connect to your database. You will want to start by confirming the hostname, username, password or database name is correct, or check that connections aren't being blocked by a firewall.

Disable selinux