ubuntu 18.04 - php errors on installing community edition.

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

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

Post 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
mikeb
Posts: 709
Joined: Thu Jul 27, 2006 11:58 am

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

Post by mikeb »

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

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

Post by MickG01 »

Screenshot from 2018-08-27 06-15-53.png
Screenshot from 2018-08-27 06-15-53.png (9.25 KiB) Viewed 7343 times
mikeb
Posts: 709
Joined: Thu Jul 27, 2006 11:58 am

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

Post 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.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
MickG01
Posts: 144
Joined: Mon Nov 09, 2009 11:48 am

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

Post by MickG01 »

So it then connects to the empty databas but creates nothing
MickG01
Posts: 144
Joined: Mon Nov 09, 2009 11:48 am

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

Post by MickG01 »

I ned a bit of time but I'll do that.
MickG01
Posts: 144
Joined: Mon Nov 09, 2009 11:48 am

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

Post 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
mikeb
Posts: 709
Joined: Thu Jul 27, 2006 11:58 am

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

Post 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.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
MickG01
Posts: 144
Joined: Mon Nov 09, 2009 11:48 am

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

Post by MickG01 »

Screenshot from 2018-09-05 07-00-59.png
Screenshot from 2018-09-05 07-00-59.png (26.14 KiB) Viewed 7318 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: 709
Joined: Thu Jul 27, 2006 11:58 am

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

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