[FitTrackee] Self-hosted outdoor activity tracker 🚴

petrus · September 23, 2024, 5:15pm

ls -lah /etc/postgresql/
total 12K
drwxr-xr-x 3 postgres postgres 4.0K Sep 21 09:26 .
drwxr-xr-x 106 root root 4.0K Sep 23 12:37 …
drwxr-xr-x 3 postgres postgres 4.0K Sep 21 09:26 13

Tho · September 23, 2024, 5:31pm

In the file /etc/postgresql/13/main/pg_hba.conf could you please share me what is the line under # "local" is for Unix domain socket connections only

It must be something like local all all md5.

If you have peer in place of md5, change it and restart posgresql service.

After that, try again to install FitTrackee and tell me if it helps!

petrus · September 24, 2024, 11:10am

Original file
postgresql-cap

I’ll change the “peer” by “md5” at the end of the “local” line.

petrus · September 24, 2024, 11:30am

Fittrackee uninstalled.
Restored from backup.
Applied your script yunohost app upgrade fittrackee -u https://github.com/YunoHost-Apps/fittrackee_ynh/tree/remove-venv-before-upgrade --debug
Upgraded to latest version.
WORKING with old datas

Thx Tho!! You’re the boss!

Tho · September 24, 2024, 3:18pm

Thanks for your feedback!
Glad it works now, enjoy

ghose · October 13, 2024, 5:38am

successfully upgraded to v0.8.10

thank you

Changelog


    #635 - Add ability to replace gpx title when adding a workout
    #636 - Get description from gpx file if present

Translations updates

Tho · December 17, 2024, 10:13am

Dear FitTrackee users, a big new version is in testing phase and the FitTrackee’s maintainer is asking for help!

What to expect? A new version with social features between members of a same instance

How to help?

By installing a new instance of FitTrackee version 0.9.0b2: yunohost app install https://github.com/YunoHost-Apps/fittrackee_ynh/tree/upgrade-to-0.9.X --debug
By upgrading an instance from 0.8.X to 0.9.0b2: yunohost app upgrade fittrackee -u https://github.com/YunoHost-Apps/fittrackee_ynh/tree/upgrade-to-0.9.X --debug An upgrade from production is not yet recommended nor tested. Please install a new version of FitTrackee, then put some random data (the more, the best) and upgrade (be sure to change fittrackee to fittrackee__2 or fittrackee__3 accordingly if it’s your second or third instance of FitTrackee when you upgrade. e.g. yunohost app upgrade fittrackee__2 …)

Please report your issues in this thread, or on the package repo.

For feature requests, be welcome to share them here.

Thanks and have great sport times

ghose · December 29, 2024, 6:54am

I’ve been testing 0.9.X version and it’s a long awaited upgrade, adding new features and acitivity controls to fittrackee. I had no problems installing and upgrading (as commented on matrix room). Thanks @Tho

My main fittrackee production install was in a more private server and now I have moved it to a more public/exposed VPS. When 0.9.x version gets master branch I will upgrade this instance too so it will be easy to publicly share (expose) activities and control how much info would be visible thanks to privacy controls per activity.

FTR, in case anyone need it: How I moved FitTrackee from server1 to server2

in server2 (vps online) create the same domain1 you were using in server1. You do NOT need to add letsencrypt certificate nor config DNS.
backup fitrackee in server1
move backup file to server2
restore backup in server2
in server2 move fittrackee app from domain1 to domain2 (as it was my case); OR if you want to use the same domain1 then config DNS and then install certificate.
--force fittrackee update in server2 because there was missing a package dependency in server2 (seen in logs) so fittrackee.service did not start.
enjoy fittrackee

I will now wait untill 0.9.x is ready.

many thanks

ghose · March 21, 2025, 11:24am

TL;DR: does your fittrackee backups contain «data» directory /home/yunohost.app/fittrackee/uploads/workouts/ ?

something I did notice after migrating to a new server was that I had lost «map» visualization for my activities. I did not care in the moment as statistics looked like the same so it was not untill few days ago I investigated and it happens that /home/yunohost.app/fittrackee contains .gpx and .png just from migration. I have lost all previous .gpx files. I’ve looked into old backup files (about june '24) and none of them have this folder data inside. This folder is the default value from install script, so I have not changed it.

Note that I’ve checked a backup from an YNH upgrade and that .tar does not contain that folder either. This is directly from upgrade script, not borg mediated.

do_not_backup_data: '0' is set in fittrackee’s config.yaml and borg_backup (my daily backup system) is set to backup multimedia (not related BTW) , so I don’t know where to look into to solve this issue.

I will review older backups from previous installation but I consider them lost. Database seems to be unafected as statistics shows data from the very first installation.

have you checked your backups? are those .gpx inside? It may well be a personal problem with my config but at the moment I dont know why this happens.

I will update/edit this if I found something relevant

from latest backup job log file:

2025-03-21 11:36:26,030: DEBUG - ++ ynh_app_setting_get --key=do_not_backup_data
2025-03-21 11:36:26,090: DEBUG - + local do_not_backup_data=0

thank you

Tho · March 21, 2025, 5:23pm

Oooh thank you, I was not aware of this issue x_x

I will fix this asap: Fix backup/restore data_dir by Thovi98 · Pull Request #100 · YunoHost-Apps/fittrackee_ynh · GitHub

Did you do a backup of /home/yunohost.app/ from your old server?

The issue exists at least since the 31 august 2024 (converting to helpers 2.1).

I’m so sorry. Your backups from borg did not take the data_dir into account neither?

ghose · March 22, 2025, 6:23am

thank you for taking care of fittrackee package

Tho · April 15, 2025, 11:55am

For those using FitTrackee and owning a Garmin watch, I’ve just made it simpler to upload your Garmin activities by packaging YunoHost app store | Garmin to FitTrackee.
It will be installable without warning next weekend.

ghose · April 22, 2025, 3:26am

hi @Tho

is garmin2fittrackee ready to install?

I’m not in a hurry, I’ve just seen that it is available to install from YNH repo.

Should I (we) install main, testing,… or Keep Calm & wait Tho tells Install Now

Upgraded to 0.9.7 now Thank you.

Tho · April 22, 2025, 6:35am

It’s ready to install and working on my system!

You can install the main version directly from the app store

ghose · April 22, 2025, 12:48pm

I’ve installed it now.

I’d like to share this for anyone that wants to install it:

use https://localhost as both url (callback, etc)
READ post-install notes, because there are some CLI commands you have to execute after ynh-package installation
execute those commands as root
when you authorize in browser you have to copy url shown in browser’s address bar (https://localhost:verylongkey) and paste it back in yunohost CLI (browser most likely will moan about that localhost url as 404 or similar)
on first sync it may show some 500 error code. Fittrackee tries to get a .gpx file, but maybe some of your Garmin activities has none (ex.: yoga, strength sessions, indoor cycling, breathwork,etc.) You will have to add this activities manually (I do with indoor cycling as «virtual cycling», FTR).
garmin activities marked as running, trailrunning, walking and mountain biking (tested so far) have been automatically and correctly marked as so in fittrackee

Question for @Tho :

I’ve not looked into, but is there any cron/systemd service that runs every given time to perform sync job? Should we sync manually from CLI? Thank you

(off to walk )

Tho · April 22, 2025, 5:06pm

Yes, I thought I had written it in the description.
There is a systemd service (in tools > services > garmin-to-fittrackee) which runs every hour and where you can see the logs.

ghose · April 23, 2025, 3:28am

thank you.

yes, yesterday’s walk was sinced. It actually created «six walk actitvities» in fittotrack (edit: actually twelve! one every hour as sync job does not detected it was previously synced?). Should this be a concern or something you have experienced? It did not happen when first sync job.

Also garmin2fittrackee service is failed, with this log file (about read-only database).

edit 2: I have stopped sync job, it keeps uploading the same activity every hour.

Tho · April 23, 2025, 5:44am

That strange. I imagine it’s related to the read-only database.

What are the rights/permissions of the db (/var/www/garmin-to-fittrackee/db.sqlite3)?

ghose · April 23, 2025, 6:46am

root@SERVER:~# ls -la /var/www/garmin-to-fittrackee/db.sqlite3
-rw-r--r-- 1 root root 16384 Apr 22 14:12 /var/www/garmin-to-fittrackee/db.sqlite3

is that last time accesed/written?

so synced jobs are triggered but then not stored in database? might be any other user diferent from root trying to write to database?

Tho · April 23, 2025, 7:34am

Ok nice! Could you please chown garmin-to-fittrackee: -R /var/www/garmin-to-fittrackee and try again?
Or better: upgrade garmin-to-fittrackee to the latest version (available on the webadmin)