new server timetrex saying it cannot connect to database

Ask your questions regarding TimeTrex installation here.
Post Reply
MickG01
Posts: 144
Joined: Mon Nov 09, 2009 11:48 am

new server timetrex saying it cannot connect to database

Post by MickG01 »

Because Ubuntu 12.04 LVM couldn't upgrade due to space issues & timetrex updates wouldn't install so I installed 16.o4 on another drive.
The /var/www/html/timetrex is an exact copy of the original and the database Postgresql 9.5.0 has the timetrex db restored to it.
I can login to postgres using psql as timetrex with the password from timetrex.ini.php and see the database.
When I try to remotely connect to timetrex via a browser (Firefox) it displays a dialog:

Down for Maintenance
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.

So I'm close and I assume I'm connecting to timetrex but before I try to upgrade I need to resolve this issue.

I am now able to boot to either system 12.04 or 16.04 Ubuntu and the original system still lets me connect.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: new server timetrex saying it cannot connect to database

Post by shaunw »

Please check the PHP and TimeTrex logs for more detailed information.
MickG01
Posts: 144
Joined: Mon Nov 09, 2009 11:48 am

Re: new server timetrex saying it cannot connect to database

Post by MickG01 »

This was the only log with relevant time data /var/log/apache2/access.log:
::1 - - [23/Dec/2016:16:51:28 -0500] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.18 (Ubuntu) (internal dummy connection)"
192.168.1.12 - - [23/Dec/2016:18:01:34 -0500] "GET /timetrex/interface/DownForMaintenance.php?exception=DBError HTTP/1.1" 200 2074 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:01:34 -0500] "GET /timetrex/interface/global.css.php HTTP/1.1" 304 260 "http://192.168.1.100/timetrex/interface ... on=DBError" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:01:34 -0500] "GET /timetrex/interface/images//timetrex_logo_wbg_small2.png HTTP/1.1" 304 182 "http://192.168.1.100/timetrex/interface ... on=DBError" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:01:34 -0500] "GET /timetrex/interface/images//facebook_button.jpg HTTP/1.1" 304 182 "http://192.168.1.100/timetrex/interface ... on=DBError" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:01:34 -0500] "GET /timetrex/interface/images//twitter_button.jpg HTTP/1.1" 304 181 "http://192.168.1.100/timetrex/interface ... on=DBError" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:01:34 -0500] "GET /timetrex/interface//send_file.php?object_type=copyright HTTP/1.1" 302 889 "http://192.168.1.100/timetrex/interface ... on=DBError" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:01:34 -0500] "GET /timetrex/interface/images/table_top.gif HTTP/1.1" 304 179 "http://192.168.1.100/timetrex/interface/global.css.php" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:01:34 -0500] "GET /timetrex/interface/images/table_bottom.gif HTTP/1.1" 304 180 "http://192.168.1.100/timetrex/interface/global.css.php" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:01:34 -0500] "GET /timetrex/interface/DownForMaintenance.php?exception=DBError HTTP/1.1" 200 2074 "http://192.168.1.100/timetrex/interface ... on=DBError" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:01:34 -0500] "GET /timetrex/interface/images/spacer.gif HTTP/1.1" 304 179 "http://192.168.1.100/timetrex/interface ... on=DBError" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:49:02 -0500] "GET /timetrex/interface/DownForMaintenance.php?exception=DBError HTTP/1.1" 200 2075 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:49:03 -0500] "GET /timetrex/interface/global.css.php HTTP/1.1" 304 260 "http://192.168.1.100/timetrex/interface ... on=DBError" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:49:03 -0500] "GET /timetrex/interface/images//timetrex_logo_wbg_small2.png HTTP/1.1" 304 181 "http://192.168.1.100/timetrex/interface ... on=DBError" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:49:03 -0500] "GET /timetrex/interface/images//facebook_button.jpg HTTP/1.1" 304 182 "http://192.168.1.100/timetrex/interface ... on=DBError" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:49:03 -0500] "GET /timetrex/interface/images//twitter_button.jpg HTTP/1.1" 304 181 "http://192.168.1.100/timetrex/interface ... on=DBError" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:49:03 -0500] "GET /timetrex/interface/images/table_bottom.gif HTTP/1.1" 304 180 "http://192.168.1.100/timetrex/interface/global.css.php" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:49:03 -0500] "GET /timetrex/interface/images/table_top.gif HTTP/1.1" 304 179 "http://192.168.1.100/timetrex/interface/global.css.php" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:49:03 -0500] "GET /timetrex/interface//send_file.php?object_type=copyright HTTP/1.1" 302 953 "http://192.168.1.100/timetrex/interface ... on=DBError" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:49:03 -0500] "GET /timetrex/interface/images/spacer.gif HTTP/1.1" 304 179 "http://192.168.1.100/timetrex/interface ... on=DBError" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
192.168.1.12 - - [23/Dec/2016:18:49:03 -0500] "GET /timetrex/interface/html5/index.php?installer=1&disable_db=1&external_installer=0 HTTP/1.1" 200 3105 "http://192.168.1.100/timetrex/interface ... on=DBError" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
::1 - - [23/Dec/2016:18:49:09 -0500] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.18 (Ubuntu) (internal dummy connection)"
::1 - - [23/Dec/2016:18:49:10 -0500] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.18 (Ubuntu) (internal dummy connection)"
::1 - - [23/Dec/2016:18:49:11 -0500] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.18 (Ubuntu) (internal dummy connection)"
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: new server timetrex saying it cannot connect to database

Post by shaunw »

Please see this FAQ on how to enable TimeTrex logging:
http://forums.timetrex.com/viewtopic.php?f=6&t=89
MickG01
Posts: 144
Joined: Mon Nov 09, 2009 11:48 am

Re: new server timetrex saying it cannot connect to database

Post by MickG01 »

PHP 7.0
Postgresql 7.0
Server apache2
Timetrex I beeive is 8.0.9
Enabling errors gave:
Debug Buffer ============================================================================ Memory Usage: 888152 Buffer Size: 22 ---------------------------------------------------------------------------- DEBUG [L0440] [00707ms]: [Function](): URI: /timetrex/interface/html5/ IP Address: 192.168.1.12 DEBUG [L0442] [00707ms]: [Function](): USER-AGENT: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0 DEBUG [L0445] [00707ms]: [Function](): Version: 9.1.3 (PHP: v7.0.8-0ubuntu0.16.04.3) Edition: 10 Production: 1 Server: 192.168.1.100 Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.php Demo DEBUG [L0445] [00707ms]: [Function](): Mode: 0 DEBUG [L0155] [00795ms]: [Function](): Error connecting to the database! DEBUG [L0057] [00795ms]: DBError::__construct(): Begin Exception... DEBUG [L0058] [00795ms] Array: DBError::__construct(): BackTrace: string(424) "#0.Debug::backTrace() /var/www/html/timetrex/classes/modules/core/Exception.class.php:58 #1.DBError->__construct(Object(ADODB_Exception)) /var/www/html/timetrex/includes/Database.inc.php:156 #2.require_once(/var/www/html/timetrex/includes/Database.inc.php) /var/www/html/timetrex/includes/global.inc.php:466 #3.require_once(/var/www/html/timetrex/includes/global.inc.php) /var/www/html/timetrex/interface/html5/index.php:41 " DEBUG [L0067] [00795ms]: DBError::__construct(): Code: DBError(-1) Message: postgres8 error: [-1: Missing extension for postgres] in CONNECT(localhost:5432, 'timetrex', '****', timetrex) DEBUG [L0072] [00806ms] Array: DBError::__construct(): Exception... string(187) "require_once(/var/www/html/timetrex/includes/Database.inc.php) % line 466, file: global.inc.php require_once(/var/www/html/timetrex/includes/global.inc.php) % line 41, file: index.php " DEBUG [L0075] [00806ms]: DBError::__construct(): End Exception... ============================================================================
Fatal error: Uncaught Error: Class 'SoapClient' not found in /var/www/html/timetrex/classes/modules/soap/TimeTrexSoapClient.class.php:59 Stack trace: #0 /var/www/html/timetrex/classes/modules/soap/TimeTrexSoapClient.class.php(45): TimeTrexSoapClient->getSoapObject() #1 /var/www/html/timetrex/classes/modules/core/TTMail.class.php(281): TimeTrexSoapClient->__construct() #2 /var/www/html/timetrex/classes/modules/core/Misc.class.php(2098): TTMail->Send(false) #3 /var/www/html/timetrex/classes/modules/core/Debug.class.php(433): Misc::sendSystemMail('TimeTrex - Erro...', 'DEBUG [L0440] [...') #4 /var/www/html/timetrex/classes/modules/core/Exception.class.php(81): Debug::emailLog() #5 /var/www/html/timetrex/includes/Database.inc.php(156): DBError->__construct('require_once(/v...') #6 /var/www/html/timetrex/includes/global.inc.php(466): require_once('/var/www/html/t...') #7 /var/www/html/timetrex/interface/html5/index.php(41): require_once('/var/www/html/t...') #8 {main} thrown in /var/www/html/timetrex/classes/modules/soap/TimeTrexSoapClient.class.php on line 59

Fatal error: Uncaught Error: Class 'SoapClient' not found in /var/www/html/timetrex/classes/modules/soap/TimeTrexSoapClient.class.php:59 Stack trace: #0 /var/www/html/timetrex/classes/modules/soap/TimeTrexSoapClient.class.php(45): TimeTrexSoapClient->getSoapObject() #1 /var/www/html/timetrex/classes/modules/core/TTMail.class.php(281): TimeTrexSoapClient->__construct() #2 /var/www/html/timetrex/classes/modules/core/Misc.class.php(2098): TTMail->Send(false) #3 /var/www/html/timetrex/classes/modules/core/Debug.class.php(433): Misc::sendSystemMail('TimeTrex - Erro...', 'DEBUG [L0440] [...') #4 /var/www/html/timetrex/classes/modules/core/Debug.class.php(401): Debug::emailLog() #5 [internal function]: Debug::Shutdown() #6 {main} thrown in /var/www/html/timetrex/classes/modules/soap/TimeTrexSoapClient.class.php on line 59
============================================================================
I think this means something was missed in the copy?
MickG01
Posts: 144
Joined: Mon Nov 09, 2009 11:48 am

Re: new server timetrex saying it cannot connect to database

Post by MickG01 »

Here's the contents of php_errors.log
[24-Dec-2016 18:51:19 America/New_York] PHP Fatal error: Uncaught Error: Class 'SoapClient' not found in /var/www/html/timetrex/classes/modules/soap/TimeTrexSoapClient.class.php:59
Stack trace:
#0 /var/www/html/timetrex/classes/modules/soap/TimeTrexSoapClient.class.php(45): TimeTrexSoapClient->getSoapObject()
#1 /var/www/html/timetrex/classes/modules/core/TTMail.class.php(281): TimeTrexSoapClient->__construct()
#2 /var/www/html/timetrex/classes/modules/core/Misc.class.php(2098): TTMail->Send(false)
#3 /var/www/html/timetrex/classes/modules/core/Debug.class.php(433): Misc::sendSystemMail('TimeTrex - Erro...', 'DEBUG [L0440] [...')
#4 /var/www/html/timetrex/classes/modules/core/Exception.class.php(81): Debug::emailLog()
#5 /var/www/html/timetrex/includes/Database.inc.php(156): DBError->__construct('require_once(/v...')
#6 /var/www/html/timetrex/includes/global.inc.php(466): require_once('/var/www/html/t...')
#7 /var/www/html/timetrex/interface/html5/index.php(41): require_once('/var/www/html/t...')
#8 {main}
thrown in /var/www/html/timetrex/classes/modules/soap/TimeTrexSoapClient.class.php on line 59
MickG01
Posts: 144
Joined: Mon Nov 09, 2009 11:48 am

Re: new server timetrex saying it cannot connect to database

Post by MickG01 »

And finally this morning in timetrex.log:
DEBUG [L0067] [00689ms]: DBError::__construct(): Code: DBError(-1) Message: postgres8 error: [-1: Missing extension for postgres] in CONNECT(localhost:5432, 'timetrex', '****', timetrex)

DEBUG [L0072] [00700ms] Array: DBError::__construct(): Exception...
string(187) "require_once(/var/www/html/timetrex/includes/Database.inc.php) % line 466, file: global.inc.php
require_once(/var/www/html/timetrex/includes/global.inc.php) % line 41, file: index.php
"


DEBUG [L0075] [00700ms]: DBError::__construct(): End Exception...
---------------[ 26-Dec-2016 10:18:10 -0500 [1482765490.6729] (PID: 17369) ]---------------
MickG01
Posts: 144
Joined: Mon Nov 09, 2009 11:48 am

Re: new server timetrex saying it cannot connect to database

Post by MickG01 »

After some web searching and adjustments to pg_hba.conf where I added:
host all all 192.168.0.0/32 md5

I get this in /var/www/log/timetrex.log:

---------------[ 26-Dec-2016 12:13:10 -0500 [1482772390.558] (PID: 1297) ]---------------
DEBUG [L0440] [00237ms]: [Function](): URI: /timetrex/interface/html5/ IP Address: 192.168.1.12
DEBUG [L0442] [00237ms]: [Function](): USER-AGENT: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0
DEBUG [L0445] [00237ms]: [Function](): Version: 9.1.3 (PHP: v7.0.8-0ubuntu0.16.04.3) Edition: 10 Production: 1 Server: 192.168.1.100 Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.php Demo
DEBUG [L0445] [00237ms]: [Function](): Mode: 0
DEBUG [L0155] [00314ms]: [Function](): Error connecting to the database!
DEBUG [L0057] [00314ms]: DBError::__construct(): Begin Exception...
DEBUG [L0058] [00314ms] Array: DBError::__construct(): BackTrace:
string(424) "#0.Debug::backTrace() /var/www/html/timetrex/classes/modules/core/Exception.class.php:58
#1.DBError->__construct(Object(ADODB_Exception)) /var/www/html/timetrex/includes/Database.inc.php:156
#2.require_once(/var/www/html/timetrex/includes/Database.inc.php) /var/www/html/timetrex/includes/global.inc.php:466
#3.require_once(/var/www/html/timetrex/includes/global.inc.php) /var/www/html/timetrex/interface/html5/index.php:41
"


DEBUG [L0067] [00314ms]: DBError::__construct(): Code: DBError(-1) Message: postgres8 error: [-1: Missing extension for postgres] in CONNECT(localhost:5432, 'timetrex', '****', timetrex)

DEBUG [L0072] [00325ms] Array: DBError::__construct(): Exception...
string(187) "require_once(/var/www/html/timetrex/includes/Database.inc.php) % line 466, file: global.inc.php
require_once(/var/www/html/timetrex/includes/global.inc.php) % line 41, file: index.php
"


DEBUG [L0075] [00325ms]: DBError::__construct(): End Exception...
---------------[ 26-Dec-2016 12:13:10 -0500 [1482772390.8823] (PID: 1297) ]---------------
MickG01
Posts: 144
Joined: Mon Nov 09, 2009 11:48 am

Re: new server timetrex saying it cannot connect to database

Post by MickG01 »

Finally since I still have the backup of the original timetrex install on Ubuntu 14.04 I decided to install the zip of the latest release, 10.0.2 and run the install.php.
I had to change the permissions on several files from root:root to www-data:www-data after the overwrite.
It gave this. I repeat that I can log in to postgresql with the timetrex user and password from timetrex.ini.php and see connect to the database. What privileges should that user have in postgresql?

Detailed Error Messages

PHP CLI Requirements Output:
----WARNING----WARNING----WARNING-----
--------------------------------------
Minimum PHP Requirements are NOT met!!
--------------------------------------
Failed Requirements: SOAP,BCMATH,GD,SIMPLEXML,CURL,ZIP
--------------------------------------
PHP INI: /etc/php/7.0/cli/php.ini
Process Owner: www-data
--------------------------------------


Failed Requirements: Require,SOAP,BCMATH,GD,SIMPLEXML,CURL,ZIP

Debug Buffer
============================================================================
Memory Usage: 2993688 Buffer Size: 15
----------------------------------------------------------------------------
DEBUG [L0440] [00021ms]: [Function](): URI: /var/www/html/timetrex/tools/unattended_upgrade.php IP Address:
DEBUG [L0442] [00021ms]: [Function](): USER-AGENT: N/A
DEBUG [L0445] [00021ms]: [Function](): Version: 10.0.2 (PHP: v7.0.8-0ubuntu0.16.04.3) 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 [L0163] [00044ms]: TTDate::setTimeZone(): Setting TimeZone: America/New_York
DEBUG [L0753] [00051ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.8-0ubuntu0.16.04.3
DEBUG [L0753] [00054ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.8-0ubuntu0.16.04.3
DEBUG [L1160] [00055ms]: Install::getWebServerUser(): Webserver running as User: www-data
DEBUG [L0480] [00057ms]: TTi18n::chooseBestLocale(): Unable to find and set a locale.
DEBUG [L0215] [00057ms]: [Function](): Checking requirements only...
DEBUG [L0218] [00057ms]: [Function](): Launched from web installer...
DEBUG [L1919] [00058ms]: Misc::cleanDir(): Cleaning: /var/www/cache Exclude Regex: \.ZIP|upgrade_staging
DEBUG [L0753] [00058ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.8-0ubuntu0.16.04.3
DEBUG [L1226] [00058ms]: Install::checkPHPOpenBaseDir(): Open BaseDir:
DEBUG [L0753] [00058ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.8-0ubuntu0.16.04.3
DEBUG [L1226] [00058ms]: Install::checkPHPOpenBaseDir(): Open BaseDir:
============================================================================
PHP CLI Requirements Output:
----WARNING----WARNING----WARNING-----
--------------------------------------
Minimum PHP Requirements are NOT met!!
--------------------------------------
Failed Requirements: SOAP,BCMATH,GD,SIMPLEXML,CURL,ZIP
--------------------------------------
PHP INI: /etc/php/7.0/cli/php.ini
Process Owner: www-data
--------------------------------------


Failed Requirements: Require,SOAP,BCMATH,GD,SIMPLEXML,CURL,ZIP

Debug Buffer
============================================================================
Memory Usage: 2993688 Buffer Size: 15
----------------------------------------------------------------------------
DEBUG [L0440] [00021ms]: [Function](): URI: /var/www/html/timetrex/tools/unattended_upgrade.php IP Address:
DEBUG [L0442] [00021ms]: [Function](): USER-AGENT: N/A
DEBUG [L0445] [00021ms]: [Function](): Version: 10.0.2 (PHP: v7.0.8-0ubuntu0.16.04.3) 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 [L0163] [00044ms]: TTDate::setTimeZone(): Setting TimeZone: America/New_York
DEBUG [L0753] [00051ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.8-0ubuntu0.16.04.3
DEBUG [L0753] [00054ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.8-0ubuntu0.16.04.3
DEBUG [L1160] [00055ms]: Install::getWebServerUser(): Webserver running as User: www-data
DEBUG [L0480] [00057ms]: TTi18n::chooseBestLocale(): Unable to find and set a locale.
DEBUG [L0215] [00058ms]: [Function](): Checking requirements only...
DEBUG [L0218] [00058ms]: [Function](): Launched from web installer...
DEBUG [L1919] [00058ms]: Misc::cleanDir(): Cleaning: /var/www/cache Exclude Regex: \.ZIP|upgrade_staging
DEBUG [L0753] [00058ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.8-0ubuntu0.16.04.3
DEBUG [L1226] [00058ms]: Install::checkPHPOpenBaseDir(): Open BaseDir:
DEBUG [L0753] [00058ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.8-0ubuntu0.16.04.3
DEBUG [L1226] [00058ms]: Install::checkPHPOpenBaseDir(): Open BaseDir:
============================================================================
MickG01
Posts: 144
Joined: Mon Nov 09, 2009 11:48 am

Re: new server timetrex saying it cannot connect to database

Post by MickG01 »

After more following logs and error messages I have got to where I accept the License agreement on install and get:

Local cache has expired. Click OK to reload.

When I click OK it goes back to the license agreement.

Attached is the timetrex.log file
Attachments
timetrex.log
(84.02 KiB) Downloaded 417 times
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: new server timetrex saying it cannot connect to database

Post by shaunw »

Not sure why you can't get to the system requirements screen, but regardless the key is this:

Code: Select all

PHP CLI Requirements Output:
----WARNING----WARNING----WARNING-----
--------------------------------------
Minimum PHP Requirements are NOT met!!
--------------------------------------
Failed Requirements: SOAP,BCMATH,GD,SIMPLEXML,CURL,ZIP
You need to install the following PHP extensions: SOAP, BCMATH, GD, SIMPLEXML, CURL, ZIP, PGSQL
MickG01
Posts: 144
Joined: Mon Nov 09, 2009 11:48 am

Re: new server timetrex saying it cannot connect to database

Post by MickG01 »

Thank you much closer but it now tells me to use a MySQL database whereas my Db is Postgresql
Probably changes I made?
I'm attaching latest timetrex.log, timetrex.ini.php and a screenshot.
Attachments
timetrex.log
(126.84 KiB) Downloaded 403 times
TimeTrex.png
TimeTrex.png (103.93 KiB) Viewed 20702 times
MickG01
Posts: 144
Joined: Mon Nov 09, 2009 11:48 am

Re: new server timetrex saying it cannot connect to database

Post by MickG01 »

Sorry firefox issues
MickG01
Posts: 144
Joined: Mon Nov 09, 2009 11:48 am

Re: new server timetrex saying it cannot connect to database

Post by MickG01 »

Here I hope is the timetrex,ini.php
Attachments
timetrex.ini.php.txt
(1.92 KiB) Downloaded 428 times
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: new server timetrex saying it cannot connect to database

Post by shaunw »

Your timetrex.ini.php has lines that start with "#" which is not valid, to comment out a line from a .ini file you must use ";" instead.

In the Database Type dropdown box, does it show PostgreSQL as an option? If not, then your PHP PGSQL extension is not installed/enabled.
MickG01
Posts: 144
Joined: Mon Nov 09, 2009 11:48 am

Re: new server timetrex saying it cannot connect to database

Post by MickG01 »

Thank you for rescuing my payroll records.

Fortunately I had kepd reglar database backups.

I would caution others to be wary og mixng Ubuntu Server LVM with PHP applications like TimeTrex and depending on Ubuntu's LTS keeng everything current.

I am not back in to my company Payroll and hust have to update from TimeTrex 10.0.2 to 10.0.3. But I'm too tired tonight.
Post Reply