Unable to setup TimeTracker on Ubuntu 16.04LTS

Discussion forum about Anuko Time Tracker
Post Reply
GCS e-Santé Bretagne
Posts: 2
Joined: Wed Aug 10, 2016 1:48 pm

Unable to setup TimeTracker on Ubuntu 16.04LTS

Post by GCS e-Santé Bretagne » Wed Aug 10, 2016 2:00 pm

Good afternoon to you all,
We get some troubles when trying to set up Timetracker on a Ubuntu 16.04LTS server of ours.
It used to work well with Ubuntu 14.04.
We have read the setup guide and followed each step but we always get the same message when connecting http://xxxx.yyy/timetracker/dbinstall.php :
"Processing...
# Usage:
# 1) Create a database using the "CREATE DATABASE" mysql command.
# 2) Then, execute this script from command prompt with a command like this:
# mysql -h host -u user -p -D db_name < mysql.sql
# create database timetracker character set = 'utf8'
MDB2 Error: not found
"
For instance OwnCloud works quite well on the same serveur.
Thanks for your help !

wrc
Posts: 271
Joined: Tue May 25, 2010 8:30 pm

Re: Unable to setup TimeTracker on Ubuntu 16.04LTS

Post by wrc » Wed Aug 10, 2016 2:20 pm

GCS e-Santé Bretagne wrote:MDB2 Error: not found
Probably an SQL driver is not installed for PHP (mysql or mysqli depending on the DSN value in your config.php). Try using the latest Time Tracker code as it has some troubleshooting diagnostics in dbinstall.php file, which may get you more details.

GCS e-Santé Bretagne
Posts: 2
Joined: Wed Aug 10, 2016 1:48 pm

Re: Unable to setup TimeTracker on Ubuntu 16.04LTS

Post by GCS e-Santé Bretagne » Wed Aug 10, 2016 2:59 pm

We have juste set up the latest release. Here what we get now browsing http://xxxx.yyy/timetracker/dbinstall.php :
"PHP extension 'mysql' is required but is not loaded. Read Time Tracker Install Guide for help."
Nothing else available on this page, even any diagnosis tools.
Once again, everything works fine with other apps. Aren't there any issues with PHP7.0 ?

peter
Posts: 77
Joined: Sat May 29, 2010 2:06 pm

Re: Unable to setup TimeTracker on Ubuntu 16.04LTS

Post by peter » Wed Aug 10, 2016 4:03 pm

GCS e-Santé Bretagne wrote:"PHP extension 'mysql' is required but is not loaded. Read Time Tracker Install Guide for help."
This means that in your WEB-INF/config.php the DSN value is set to use the mysql driver. Which is not installed.

To fix it, either change the DSN to use mysqli driver instead (add an "i" after mysql). Or install mysql driver on Ubuntu. This last part usually goes like this:

Code: Select all

sudo apt-get install php5-mysql
Hope it helps.

Post Reply