TimeTrex_C_Edition_v9.1.2 Linux - Network connection lost

Ask your questions regarding TimeTrex installation here.
Post Reply
DrK
Posts: 8
Joined: Fri Jul 29, 2016 1:03 am

TimeTrex_C_Edition_v9.1.2 Linux - Network connection lost

Post by DrK »

I'm getting a "Network connection was lost error" that is preventing the installer complete the step concerning database creation.
Capture4.PNG
On the page it refers to a username and password for the time management. Is this a linux user name or sql username. If the latter do I need to create it, or does the install do it for me, I note this but it is 10 years old so it may be automated now...
viewtopic.php?f=6&t=65

Code: Select all

:~$ mysql -u root -p timetrex

mysql> connect timetrex
Connection id:    26
Current database: timetrex
but with

Code: Select all

:~$ mysql -u timetrex -p timetrex
Enter password: 
ERROR 1045 (28000): Access denied for user 'timetrex'@'localhost' (using password: YES)
In my php.ini:
error_reporting = E_ALL & ~E_DEPRECATED & ~E_STRICT
and
display_errors = Off
Where should I check next please?



Setup:
TimeTrex_Community_Edition_v9.1.2 on Linux 4.4.0-31-generic
PHP Version 7.0.8-0ubuntu0.16.04.1
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: TimeTrex_C_Edition_v9.1.2 Linux - Network connection los

Post by shaunw »

I would probably start with your MySQL connection error, if you can't connect from the command line to the TimeTrex database with the username/password you setup, then there is no point in going any further with the TimeTrex installer, as it will also get the same error.
DrK
Posts: 8
Joined: Fri Jul 29, 2016 1:03 am

Re: TimeTrex_C_Edition_v9.1.2 Linux - Network connection los

Post by DrK »

Hi, solved now. I did a manual addition of the the db user. I thought the install wizard would have done this for me but it was ambiguous on what the page was going to do with the info i.e. use the details or create with the details, it asks for a privileged username and password after all!
To help others, I ran these and then resumed the install script via the web page.

Code: Select all

$ mysql -u root -p timetrex
mysql> CREATE USER 'timetrex'@'localhost' IDENTIFIED BY '*********';
mysql> GRANT ALL PRIVILEGES ON * . * TO 'timetrex'@'localhost';
Post Reply