Delicious      Technorati      Blinklist      Furl      Reddit

TimeTrex Time and Attendance

TimeTrex Time and Attendance


* FAQ    * Search
* Login   * Register

All times are UTC - 8 hours [ DST ]




Post new topic Reply to topic  [ 16 posts ] 
Author Message
PostPosted: Fri Dec 23, 2016 5:07 pm 
Offline

Joined: Mon Nov 09, 2009 11:48 am
Posts: 81
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.


Top
 Profile  
 
PostPosted: Fri Dec 23, 2016 5:27 pm 
Offline

Joined: Tue Sep 19, 2006 2:22 pm
Posts: 7255
Please check the PHP and TimeTrex logs for more detailed information.


Top
 Profile  
 
PostPosted: Fri Dec 23, 2016 8:26 pm 
Offline

Joined: Mon Nov 09, 2009 11:48 am
Posts: 81
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/DownForMaintenance.php?exception=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/DownForMaintenance.php?exception=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/DownForMaintenance.php?exception=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/DownForMaintenance.php?exception=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/DownForMaintenance.php?exception=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/DownForMaintenance.php?exception=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/DownForMaintenance.php?exception=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/DownForMaintenance.php?exception=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/DownForMaintenance.php?exception=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/DownForMaintenance.php?exception=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/DownForMaintenance.php?exception=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/DownForMaintenance.php?exception=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/DownForMaintenance.php?exception=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/DownForMaintenance.php?exception=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)"


Top
 Profile  
 
PostPosted: Sat Dec 24, 2016 12:12 pm 
Offline

Joined: Tue Sep 19, 2006 2:22 pm
Posts: 7255
Please see this FAQ on how to enable TimeTrex logging:
http://forums.timetrex.com/viewtopic.php?f=6&t=89


Top
 Profile  
 
PostPosted: Sat Dec 24, 2016 5:00 pm 
Offline

Joined: Mon Nov 09, 2009 11:48 am
Posts: 81
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?


Top
 Profile  
 
PostPosted: Sun Dec 25, 2016 6:00 am 
Offline

Joined: Mon Nov 09, 2009 11:48 am
Posts: 81
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


Top
 Profile  
 
PostPosted: Mon Dec 26, 2016 8:57 am 
Offline

Joined: Mon Nov 09, 2009 11:48 am
Posts: 81
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) ]---------------


Top
 Profile  
 
PostPosted: Mon Dec 26, 2016 10:25 am 
Offline

Joined: Mon Nov 09, 2009 11:48 am
Posts: 81
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) ]---------------


Top
 Profile  
 
PostPosted: Mon Dec 26, 2016 2:15 pm 
Offline

Joined: Mon Nov 09, 2009 11:48 am
Posts: 81
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:
============================================================================


Top
 Profile  
 
PostPosted: Mon Dec 26, 2016 4:53 pm 
Offline

Joined: Mon Nov 09, 2009 11:48 am
Posts: 81
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 35 times
Top
 Profile  
 
PostPosted: Tue Dec 27, 2016 8:21 am 
Offline

Joined: Tue Sep 19, 2006 2:22 pm
Posts: 7255
Not sure why you can't get to the system requirements screen, but regardless the key is this:

Code:
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


Top
 Profile  
 
PostPosted: Tue Dec 27, 2016 9:17 pm 
Offline

Joined: Mon Nov 09, 2009 11:48 am
Posts: 81
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 35 times
TimeTrex.png
TimeTrex.png [ 103.93 KiB | Viewed 1275 times ]
Top
 Profile  
 
PostPosted: Tue Dec 27, 2016 9:30 pm 
Offline

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


Top
 Profile  
 
PostPosted: Wed Dec 28, 2016 3:56 am 
Offline

Joined: Mon Nov 09, 2009 11:48 am
Posts: 81
Here I hope is the timetrex,ini.php


Attachments:
timetrex.ini.php.txt [1.92 KiB]
Downloaded 38 times
Top
 Profile  
 
PostPosted: Wed Dec 28, 2016 8:06 am 
Offline

Joined: Tue Sep 19, 2006 2:22 pm
Posts: 7255
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.


Top
 Profile  
 
PostPosted: Wed Dec 28, 2016 7:21 pm 
Offline

Joined: Mon Nov 09, 2009 11:48 am
Posts: 81
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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 16 posts ] 

All times are UTC - 8 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron


Time and Attendance




Powered by phpBB® Forum Software © phpBB Group