Delicious      Technorati      Blinklist      Furl      Reddit

TimeTrex Time and Attendance

TimeTrex Time and Attendance


* FAQ    * Search
* Login   * Register

All times are UTC - 8 hours [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
PostPosted: Wed Aug 03, 2016 12:50 am 
Offline

Joined: Fri Jul 29, 2016 1:03 am
Posts: 8
I'm getting a "Network connection was lost error" that is preventing the installer complete the step concerning database creation.
Attachment:
Capture4.PNG
Capture4.PNG [ 76.03 KiB | Viewed 1091 times ]


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:
:~$ mysql -u root -p timetrex

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


but with
Code:
:~$ mysql -u timetrex -p timetrex
Enter password:
ERROR 1045 (28000): Access denied for user 'timetrex'@'localhost' (using password: YES)


In my php.ini:
Quote:
error_reporting = E_ALL & ~E_DEPRECATED & ~E_STRICT
and
Quote:
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


Top
 Profile  
 
PostPosted: Wed Aug 03, 2016 7:54 am 
Offline

Joined: Tue Sep 19, 2006 2:22 pm
Posts: 7230
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.


Top
 Profile  
 
PostPosted: Fri Aug 05, 2016 2:54 am 
Offline

Joined: Fri Jul 29, 2016 1:03 am
Posts: 8
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:
$ mysql -u root -p timetrex
mysql> CREATE USER 'timetrex'@'localhost' IDENTIFIED BY '*********';
mysql> GRANT ALL PRIVILEGES ON * . * TO 'timetrex'@'localhost';


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 8 hours [ DST ]


Who is online

Users browsing this forum: Bing [Bot] and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron


Time and Attendance




Powered by phpBB® Forum Software © phpBB Group