ubuntu 18.04 - php errors on installing community edition.

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

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

Post by MickG01 » Sun Aug 26, 2018 7:00 am

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

mikeb
Posts: 534
Joined: Thu Jul 27, 2006 11:58 am

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

Post by mikeb » Sun Aug 26, 2018 11:28 am

What happens when you click the "Test Connection" button?
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!

MickG01
Posts: 110
Joined: Mon Nov 09, 2009 11:48 am

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

Post by MickG01 » Mon Aug 27, 2018 3:17 am

Screenshot from 2018-08-27 06-15-53.png
Screenshot from 2018-08-27 06-15-53.png (9.25 KiB) Viewed 772 times

mikeb
Posts: 534
Joined: Thu Jul 27, 2006 11:58 am

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

Post by mikeb » Mon Aug 27, 2018 8:14 am

Okay, you will need to enable debugging in the timetrex.ini.php file as per the FAQ, then attach the TimeTrex log file here.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!

MickG01
Posts: 110
Joined: Mon Nov 09, 2009 11:48 am

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

Post by MickG01 » Tue Aug 28, 2018 3:34 am

So it then connects to the empty databas but creates nothing

MickG01
Posts: 110
Joined: Mon Nov 09, 2009 11:48 am

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

Post by MickG01 » Tue Aug 28, 2018 3:35 am

I ned a bit of time but I'll do that.

MickG01
Posts: 110
Joined: Mon Nov 09, 2009 11:48 am

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

Post by MickG01 » Mon Sep 03, 2018 9:01 am

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 18 times

mikeb
Posts: 534
Joined: Thu Jul 27, 2006 11:58 am

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

Post by mikeb » Tue Sep 04, 2018 8:30 am

There appears to be a syntax error in your timetrex.ini.php file on line 61, so TimeTrex can't finish the install process.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!

MickG01
Posts: 110
Joined: Mon Nov 09, 2009 11:48 am

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

Post by MickG01 » Wed Sep 05, 2018 4:12 am

Screenshot from 2018-09-05 07-00-59.png
Screenshot from 2018-09-05 07-00-59.png (26.14 KiB) Viewed 747 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:

mikeb
Posts: 534
Joined: Thu Jul 27, 2006 11:58 am

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

Post by mikeb » Wed Sep 05, 2018 7:49 am

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.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!

Post Reply