Search found 106 matches

by MickG01
Wed Dec 28, 2016 7:21 pm
Forum: Installation Help
Topic: new server timetrex saying it cannot connect to database
Replies: 15
Views: 5493

Re: new server timetrex saying it cannot connect to database

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 ...
by MickG01
Wed Dec 28, 2016 3:56 am
Forum: Installation Help
Topic: new server timetrex saying it cannot connect to database
Replies: 15
Views: 5493

Re: new server timetrex saying it cannot connect to database

Here I hope is the timetrex,ini.php
by MickG01
Tue Dec 27, 2016 9:17 pm
Forum: Installation Help
Topic: new server timetrex saying it cannot connect to database
Replies: 15
Views: 5493

Re: new server timetrex saying it cannot connect to database

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.
by MickG01
Mon Dec 26, 2016 4:53 pm
Forum: Installation Help
Topic: new server timetrex saying it cannot connect to database
Replies: 15
Views: 5493

Re: new server timetrex saying it cannot connect to database

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
by MickG01
Mon Dec 26, 2016 2:15 pm
Forum: Installation Help
Topic: new server timetrex saying it cannot connect to database
Replies: 15
Views: 5493

Re: new server timetrex saying it cannot connect to database

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 ...
by MickG01
Mon Dec 26, 2016 10:25 am
Forum: Installation Help
Topic: new server timetrex saying it cannot connect to database
Replies: 15
Views: 5493

Re: new server timetrex saying it cannot connect to database

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/ht...
by MickG01
Mon Dec 26, 2016 8:57 am
Forum: Installation Help
Topic: new server timetrex saying it cannot connect to database
Replies: 15
Views: 5493

Re: new server timetrex saying it cannot connect to database

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... str...
by MickG01
Sun Dec 25, 2016 6:00 am
Forum: Installation Help
Topic: new server timetrex saying it cannot connect to database
Replies: 15
Views: 5493

Re: new server timetrex saying it cannot connect to database

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.cl...
by MickG01
Sat Dec 24, 2016 5:00 pm
Forum: Installation Help
Topic: new server timetrex saying it cannot connect to database
Replies: 15
Views: 5493

Re: new server timetrex saying it cannot connect to database

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 [L0...
by MickG01
Fri Dec 23, 2016 8:26 pm
Forum: Installation Help
Topic: new server timetrex saying it cannot connect to database
Replies: 15
Views: 5493

Re: new server timetrex saying it cannot connect to database

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?exceptio...
by MickG01
Fri Dec 23, 2016 5:07 pm
Forum: Installation Help
Topic: new server timetrex saying it cannot connect to database
Replies: 15
Views: 5493

new server timetrex saying it cannot connect to database

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 psq...
by MickG01
Fri May 15, 2015 6:32 am
Forum: Installation Help
Topic: PHP 5.6
Replies: 7
Views: 5027

Re: PHP 5.6

shaunw wrote:v8.0.7 of TimeTrex due out within a week will support PHP v5.6.
Appreciated
by MickG01
Mon Apr 27, 2015 7:19 am
Forum: Installation Help
Topic: PHP 5.6
Replies: 7
Views: 5027

Re: PHP 5.6

I hit this issue when upgrading Ubuntu server from 14.10 to 15.04 which automatically updates PHP to 5.6.4-ubuntu6 among other things. Startup also found a bad link trying to run pg_ctl. The latter I got round by manually running 'sudo ctl_cluster 9.3 main start'. Fortunately my timetrex needs are s...
by MickG01
Mon Jul 28, 2014 3:26 pm
Forum: General Discussion
Topic: Upgrade 32-bit to 64 bit
Replies: 3
Views: 2310

Re: Upgrade 32-bit to 64 bit

Bin installer - This will probably also involve a Db (postgresql) upgrade but the backup should restor OKc
by MickG01
Sun Jul 27, 2014 4:28 pm
Forum: General Discussion
Topic: Upgrade 32-bit to 64 bit
Replies: 3
Views: 2310

Upgrade 32-bit to 64 bit

I'm upgraduing an ubuntu server from 32 to 64 bit (12.04 to 14.04 also).
I have the /var and /home paths on a separate drive and have proven this works even changing Ubuntu to Debian. the timetrex install is on /var/www/timetrex.
Can I upgrade the timetrex install from 32 bit to 64 bit also?
by MickG01
Thu May 22, 2014 4:08 pm
Forum: Installation Help
Topic: Error after log in (TimeTrex system requirement check has..)
Replies: 5
Views: 5564

Re: Error after log in (TimeTrex system requirement check ha

I get this every week = I installed using the automatic install and each week have to clean the var/www/cache Linux Server folder (I installed timetrex to /var/www) The permissions for that folder are assigned to the User for timetrex.

This is really aggrevating
by MickG01
Tue Jan 21, 2014 7:58 pm
Forum: Help
Topic: No tax calulation for the first employee in Alphabetic Order
Replies: 8
Views: 2906

Re: No tax calulation for the first employee in Alphabetic O

OK I have this install on Ubuntu Server 12.04
Upgrading it insists I install as a regular user and not roo then it complains it can't change permissions to 040775 in all directories.
What do I do to resolve this?
by MickG01
Fri Jan 03, 2014 11:25 am
Forum: Help
Topic: No tax calulation for the first employee in Alphabetic Order
Replies: 8
Views: 2906

Re: No tax calulation for the first employee in Alphabetic O

OK Year end I can rescue where I am. I currently have Version 5.2.2 installed from the .bin file on an Ubuntu Server v12.04 I'm now prepared to upgrade but when I log in to pgsql it does NOT show a TimeTrex Database. Questions How do I back up a database pgsql doesn't see? Where are the tables for t...
by MickG01
Tue May 28, 2013 5:56 pm
Forum: Help
Topic: No tax calulation for the first employee in Alphabetic Order
Replies: 8
Views: 2906

Re: No tax calulation for the first employee in Alphabetic O

Thanks but with our few employees the legacy interface lets me easily enter, for each, "she worked 'x' hours this week" the new interface insists on Start time end time entries. This for employees that work 30+ hours a week is a royal pain. I'll stick to what I have until I locate something better o...
by MickG01
Tue May 21, 2013 6:43 pm
Forum: Help
Topic: No tax calulation for the first employee in Alphabetic Order
Replies: 8
Views: 2906

Re: No tax calulation for the first employee in Alphabetic O

I'm using TimeTrex 5.2.2 (I prefer the old Interface) on Ubuntu 12.10 Server being accessed using Firefox on Ubuntu 13.04 Desktop OR IE9 on Windows 7 I also get the same results accessing it from an Android Tablet using Dolphin Browser. As I said: My Alphabetically earliest employee had a last name ...
by MickG01
Fri May 17, 2013 4:06 pm
Forum: Help
Topic: No tax calulation for the first employee in Alphabetic Order
Replies: 8
Views: 2906

No tax calulation for the first employee in Alphabetic Order

I initially thought this was the first employee I had entered, but today I added employee #3 whose last name is earlier in the Alphabet. And now it is she who has no Federal Income Tax calculated. All other employees have their federal tax calculated correctly. For this employee I have set up a spre...
by MickG01
Fri Nov 02, 2012 6:39 pm
Forum: Installation Help
Topic: Timetrex not responding on upgrade to Ubuntu Server 12.10
Replies: 15
Views: 9187

Re: Timetrex not responding on upgrade to Ubuntu Server 12.1

OK I logged in to postgres in text mode (Well! it is a server, no gui) listing the databases does not show timetrex so I guess I should have uninstalled 9.1 not 8.4 Is there a way to impost the timetrex db in to this and do I change timetrex.php.ini to say postgres9 where it did say postgres8 ? I'm ...
by MickG01
Thu Nov 01, 2012 6:51 pm
Forum: Installation Help
Topic: Timetrex not responding on upgrade to Ubuntu Server 12.10
Replies: 15
Views: 9187

Re: Timetrex not responding on upgrade to Ubuntu Server 12.1

[02-Nov-2012 01:45:55 UTC] PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: password authentication failed for user "postgres" FATAL: password authentication failed for user "postgres" in /var/www/timetrex/classes/adodb/drivers/adodb-postgres64.inc.php on line 697 Obviously ...
by MickG01
Thu Nov 01, 2012 6:36 pm
Forum: Installation Help
Topic: Timetrex not responding on upgrade to Ubuntu Server 12.10
Replies: 15
Views: 9187

Re: Timetrex not responding on upgrade to Ubuntu Server 12.1

Well I uninstalled 8.4 Changed the timetrex.ini.php to postgres9 and it is the same The php_errors.log has these lines: [02-Nov-2012 00:41:34 UTC] PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host "localho...