Page 2 of 2

Re: ubuntu 18.04 - php errors on installing community edition.

Posted: Sun Aug 26, 2018 7:00 am
by MickG01
MickG01 wrote: Sun Aug 26, 2018 6:52 am I have now got to the situation where the install tries to run with the attached sequence of screens, then it returns to the license screen.

connecting to postgres as user timetrex or user postgres the \dt command shows "Did not find any relations."
\du shows Role: postgres with Superuser, Create role, Create DB, Replication, Bypass RLS - and - timetrex with Create role, Create DB

l shows databases postgres, template0, teplate1, timetrex
timetrex has Owner postgres Encoding UTF8 Collate en_US.UTF8, Ctype en_US.UTF-8, no access privileges.

any suggestions?
Only the 1st 4 images are significant editing them is not working - Sorry

Re: ubuntu 18.04 - php errors on installing community edition.

Posted: Sun Aug 26, 2018 11:28 am
by mikeb
What happens when you click the "Test Connection" button?

Re: ubuntu 18.04 - php errors on installing community edition.

Posted: Mon Aug 27, 2018 3:17 am
by MickG01
Screenshot from 2018-08-27 06-15-53.png
Screenshot from 2018-08-27 06-15-53.png (9.25 KiB) Viewed 7341 times

Re: ubuntu 18.04 - php errors on installing community edition.

Posted: Mon Aug 27, 2018 8:14 am
by mikeb
Okay, you will need to enable debugging in the timetrex.ini.php file as per the FAQ, then attach the TimeTrex log file here.

Re: ubuntu 18.04 - php errors on installing community edition.

Posted: Tue Aug 28, 2018 3:34 am
by MickG01
So it then connects to the empty databas but creates nothing

Re: ubuntu 18.04 - php errors on installing community edition.

Posted: Tue Aug 28, 2018 3:35 am
by MickG01
I ned a bit of time but I'll do that.

Re: ubuntu 18.04 - php errors on installing community edition.

Posted: Mon Sep 03, 2018 9:01 am
by MickG01
This looks lik I have some permission errors.
There is no php_errors.log file generated and in postgres the database 'timetrex exists as:
\l+ timetrex
name | Owner | Encoding | Collate | Ctype | Access Privileges | Size | Tablespace | Description
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
timetrex | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | 8685 kB | pg_default |

\d and \dt give:
Did not find any relations.
timetrex.log
(644.55 KiB) Downloaded 284 times

Re: ubuntu 18.04 - php errors on installing community edition.

Posted: Tue Sep 04, 2018 8:30 am
by mikeb
There appears to be a syntax error in your timetrex.ini.php file on line 61, so TimeTrex can't finish the install process.

Re: ubuntu 18.04 - php errors on installing community edition.

Posted: Wed Sep 05, 2018 4:12 am
by MickG01
Screenshot from 2018-09-05 07-00-59.png
Screenshot from 2018-09-05 07-00-59.png (26.14 KiB) Viewed 7316 times
Thank You.
The result of switching keyboards between system and occasionally choosing the wrong one, no doubt.

Now I need to study that log file and see how you figured it out.
:oops:

Re: ubuntu 18.04 - php errors on installing community edition.

Posted: Wed Sep 05, 2018 7:49 am
by mikeb
When you go to http://<domain>/install/install.php it would tell you immediately if there was an error in the timetrex.ini.php file. Since you didn't see that my guess is you modified the .ini file after you already started the installer, which would make the error much more difficult to decipher.