TimeTrex is unable to connect to its database.

General support regarding TimeTrex, such as
configuring policies/taxes or processing payroll.
Post Reply
smirnovfg
Posts: 1
Joined: Wed Feb 21, 2018 2:02 am

TimeTrex is unable to connect to its database.

Post by smirnovfg » Wed Feb 21, 2018 4:28 am

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) ]---------------
Attachments
3.jpg
3.jpg (206.01 KiB) Viewed 910 times
2.jpg
2.jpg (197.54 KiB) Viewed 910 times
1.jpg
1.jpg (141.79 KiB) Viewed 910 times

shaunw
Posts: 7483
Joined: Tue Sep 19, 2006 2:22 pm

Re: TimeTrex is unable to connect to its database.

Post by shaunw » Thu Feb 22, 2018 10:39 am

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.

shoutnet
Posts: 2
Joined: Thu Oct 03, 2019 7:59 am

Re: TimeTrex is unable to connect to its database.

Post by shoutnet » Tue Oct 29, 2019 5:38 pm

Disable selinux

Post Reply