Install TimeTracker on a Synology WebStation

Discussion forum about Anuko Time Tracker
Post Reply
jerome371
Posts: 10
Joined: Tue Jun 05, 2018 1:59 pm

Install TimeTracker on a Synology WebStation

Post by jerome371 » Tue Jun 05, 2018 2:05 pm

Hi !

Since a few days, i'm trying to install time tracker on my synology passing through apache, php5 and phpmyadmin without success...

Can someone help me with the process,

Thanking you in advance,

Cheers,

Jérôme

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

Re: Install TimeTracker on a Synology WebStation

Post by peter » Wed Jun 06, 2018 12:35 pm

What kind of errors do you see? What is not working exactly?

patricr
Posts: 8
Joined: Tue Apr 17, 2018 8:08 pm

Re: Install TimeTracker on a Synology WebStation

Post by patricr » Thu Jun 07, 2018 11:25 am

I have installed it on my Synology. Using the directions on the Anuko website for a Linux install, but I did not use all the terminal commands except for the permissions.
Steps:
1. In phpMyAdmin; make a user that has access to the same database as the user.
2. Using FTP client, upload the unzipped Timetracker files into the web folder.
3. In the config.php.dist, copy it with the name config.php
4. In the places where it says database name, database user and password enter those bits of information that you did in phpMyAdmin.
5. Make sure the folder/directory WEB-INF/templates_c is writable using the terminal do a chmod 777 on that folder. You may be able to change the permissions using Synology's DSM to change the permissions for that folder and click for all included files/folders. User can be http and group can be everyone.
6. Save the changes to the config.php. You can also make the changes to the config.php before you upload the files to the Synology.

That should do it.
The instructions at https://www.anuko.com/time_tracker/inst ... nstall.htm also talk about how to put Timetracker in a folder inside you web folder. That is what I did, so when I want to use Timetracker I address the app like this: http://myserver.myds.me/tt where tt is the folder name of Timetracker inside my web folder.

jerome371
Posts: 10
Joined: Tue Jun 05, 2018 1:59 pm

Re: Install TimeTracker on a Synology WebStation

Post by jerome371 » Fri Jun 08, 2018 2:28 pm

Hi Peter and Patricr !

Many thanks for your answers,

@Patricr I will follow your instructions and come back to you if it's working !

Best,

Jérôme

jerome371
Posts: 10
Joined: Tue Jun 05, 2018 1:59 pm

Re: Install TimeTracker on a Synology WebStation

Post by jerome371 » Fri Jun 08, 2018 5:06 pm

Dear Patricr,

Thanks so much, everything seems to work (I can access to time tracker home page now :) )

But...

Environment Checks

WEB-INF/templates_c/ directory is writable.
WEB-INF/config.php file exists.
DSN is defined.
PHP version: 5.6.34, good enough.
mysqli PHP extension is loaded.
mbstring PHP extension is loaded.
gd PHP extension is loaded.
Error: connection to database failed. MDB2 Error: unknown error

Impossible to set the dbinstall.php

Do you know from where the error come from ?

My conf.php settings : define('DSN', 'mysqli://user:user@%/timetracker?charset=utf8');

Thanks ;)

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

Re: Install TimeTracker on a Synology WebStation

Post by wrc » Fri Jun 08, 2018 5:27 pm

jerome371 wrote:
Fri Jun 08, 2018 5:06 pm
My conf.php settings : define('DSN', 'mysqli://user:user@%/timetracker?charset=utf8');
This looks strange. Try

Code: Select all

define('DSN', 'mysqli://user:password@localhost/timetracker?charset=utf8');
Here, the values are:
User: user.
Password: password.
Database name: timetracker.

jerome371
Posts: 10
Joined: Tue Jun 05, 2018 1:59 pm

Re: Install TimeTracker on a Synology WebStation

Post by jerome371 » Fri Jun 08, 2018 5:31 pm

Hi wrc,

Yes user was my password ^^
And I changed the host name to 'localhost'

But still the same problem

:(

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

Re: Install TimeTracker on a Synology WebStation

Post by wrc » Sat Jun 09, 2018 4:16 pm

Perhaps, this can help viewtopic.php?t=1740
Instead of
define('DSN', 'mysqli://DB_USER:DB_PASSWORD!@localhost/DB_NAME?charset=utf8');

This worked
define('DSN', 'mysqli://DB_USER:DB_PASSWORD!@SPECIFIC_HOSTNAME/DB_NAME?charset=utf8');

jerome371
Posts: 10
Joined: Tue Jun 05, 2018 1:59 pm

Re: Install TimeTracker on a Synology WebStation

Post by jerome371 » Sat Jun 09, 2018 5:23 pm

No cause in my first try i had put '%' who is actually a specific hostname

I think the mistake come from my database setup in phpmyadmin

Or the way a create the user..

jerome371
Posts: 10
Joined: Tue Jun 05, 2018 1:59 pm

Re: Install TimeTracker on a Synology WebStation

Post by jerome371 » Mon Jun 11, 2018 9:09 am

Hello again,

Two days but still don't fix this db error...

Maybe the problem is here : In phpMyAdmin; make a user that has access to the same database as the user.

I Grant all privilege

I'm using Maria DB 10

Thanks again for your help

Best
Jérôme

jerome371
Posts: 10
Joined: Tue Jun 05, 2018 1:59 pm

Re: Install TimeTracker on a Synology WebStation

Post by jerome371 » Mon Jun 11, 2018 9:46 am

@Patricr

In phpMyAdmin; make a user that has access to the same database as the user. What do you mean here ?


2. Using FTP client, upload the unzipped Timetracker files into the web folder. Which FTP Client did you use ?


ThxinAdv,

Jérôme

jerome371
Posts: 10
Joined: Tue Jun 05, 2018 1:59 pm

Re: Install TimeTracker on a Synology WebStation

Post by jerome371 » Mon Jun 11, 2018 3:13 pm

Which port should I open on my router ?

jerome371
Posts: 10
Joined: Tue Jun 05, 2018 1:59 pm

Re: Install TimeTracker on a Synology WebStation

Post by jerome371 » Tue Jun 12, 2018 11:30 am

If your in internal access on your Synology, where do you find your Specific_Hostname ? IP Address ?

jerome371
Posts: 10
Joined: Tue Jun 05, 2018 1:59 pm

Re: Install TimeTracker on a Synology WebStation

Post by jerome371 » Wed Jun 13, 2018 3:14 pm

HI everyone ! Thanks again for your precious help

I just want to let you know, that I finally arrived !

And for the following who may have a similar problem, here is my mistake :

Code: Select all

define('DSN', 'mysql://jeromexxx:idxxxx@192.168.1.xxx/timetracker?charset=utf8');
I forgot to insert the Maria DB port !

This is the solution :

Code: Select all

define('DSN', 'mysql://jeromexxx:idxxxx@192.168.1.xxx:330y/timetracker?charset=utf8');
Where y is the last number of your specific port, to find your specific port number open MariaDB in your Synology desktop

Best,

Jérôme

Post Reply