Page 1 of 1

new server timetrex saying it cannot connect to database

Posted: Fri Dec 23, 2016 5:07 pm
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.

Re: new server timetrex saying it cannot connect to database

Posted: Fri Dec 23, 2016 5:27 pm
by shaunw
Please check the PHP and TimeTrex logs for more detailed information.

Re: new server timetrex saying it cannot connect to database

Posted: Fri Dec 23, 2016 8:26 pm
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)"

Re: new server timetrex saying it cannot connect to database

Posted: Sat Dec 24, 2016 12:12 pm
by shaunw
Please see this FAQ on how to enable TimeTrex logging:
http://forums.timetrex.com/viewtopic.php?f=6&t=89

Re: new server timetrex saying it cannot connect to database

Posted: Sat Dec 24, 2016 5:00 pm
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?

Re: new server timetrex saying it cannot connect to database

Posted: Sun Dec 25, 2016 6:00 am
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

Re: new server timetrex saying it cannot connect to database

Posted: Mon Dec 26, 2016 8:57 am
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) ]---------------

Re: new server timetrex saying it cannot connect to database

Posted: Mon Dec 26, 2016 10:25 am
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) ]---------------

Re: new server timetrex saying it cannot connect to database

Posted: Mon Dec 26, 2016 2:15 pm
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:
============================================================================

Re: new server timetrex saying it cannot connect to database

Posted: Mon Dec 26, 2016 4:53 pm
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

Re: new server timetrex saying it cannot connect to database

Posted: Tue Dec 27, 2016 8:21 am
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

Re: new server timetrex saying it cannot connect to database

Posted: Tue Dec 27, 2016 9:17 pm
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.

Re: new server timetrex saying it cannot connect to database

Posted: Tue Dec 27, 2016 9:30 pm
by MickG01
Sorry firefox issues

Re: new server timetrex saying it cannot connect to database

Posted: Wed Dec 28, 2016 3:56 am
by MickG01
Here I hope is the timetrex,ini.php

Re: new server timetrex saying it cannot connect to database

Posted: Wed Dec 28, 2016 8:06 am
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.

Re: new server timetrex saying it cannot connect to database

Posted: Wed Dec 28, 2016 7:21 pm
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.