yunohost-apps/focalboard_ynh

Focalboard package for YunoHost

Focalboard for YunoHost

Read this README in other languages.

This package allows you to install Focalboard quickly and simply on a YunoHost server.
If you don't have YunoHost, please consult the guide to learn how to install it.

Overview

Focalboard is a project management tool that helps define, organize, track and manage work across teams, using a familiar kanban board view.

Shipped version: 7.11.4~ynh2

Screenshots

Documentation and resources

• Official app website: https://www.focalboard.com/
• Official user documentation: https://www.focalboard.com/guide/user/
• Official admin documentation: https://www.focalboard.com/guide/admin/
• Upstream app code repository: https://github.com/mattermost/focalboard
• YunoHost Store: https://apps.yunohost.org/app/focalboard
• Report a bug: https://github.com/YunoHost-Apps/focalboard_ynh/issues

Developer info

Please send your pull request to the testing branch.

To try the testing branch, please proceed like that:

sudo yunohost app install https://github.com/YunoHost-Apps/focalboard_ynh/tree/testing --debug
or
sudo yunohost app upgrade focalboard -u https://github.com/YunoHost-Apps/focalboard_ynh/tree/testing --debug

More info regarding app packaging: https://yunohost.org/packaging_apps

focalboard_ynh's Issues

Things noticed after post-installation (need clarification)

Describe the bug

Hello,
I did a fresh installation using 7.5.2~ynh1 on YunoHost 11.0.10.2 with private boards only.

Things I noticed:

• it's necessary to create a dedicated domain in order to install this application
• SSO doesn't work
• You need to create manually users
• It doesn't seem to have an admin user of the installation

I open that issue to be sure that is the expected behavior.

Doesn't run on ARM

Describe the bug

When installed on an ARM board, the app doesn't launch with an exec format error.

Context

• Hardware: Hummingboard i2ex
• YunoHost version: 4.2.6.1
• I have access to my server: Through the webadmin
• Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: no
• Using, or trying to install package version/branch: master

Steps to reproduce

• Install app via web interface
• Launch the app
• Notice a bad gateway error page
• Check the app status in the web interface and notice that the app keeps failing to start

Expected behavior

App should run on ARM as well.

Logs

Aug 01 18:29:41 systemd[1]: Started Focalboard server.
Aug 01 18:29:41 systemd[23643]: focalboard.service: Failed to execute command: Exec format error
Aug 01 18:29:41 systemd[23643]: focalboard.service: Failed at step EXEC spawning /opt/yunohost/focalboard/bin/focalboard-server: Exec format error
Aug 01 18:29:41 systemd[1]: focalboard.service: Main process exited, code=exited, status=203/EXEC
Aug 01 18:29:41 systemd[1]: focalboard.service: Failed with result 'exit-code'.
Aug 01 18:29:46 systemd[1]: focalboard.service: Service RestartSec=5s expired, scheduling restart.
Aug 01 18:29:46 systemd[1]: focalboard.service: Scheduled restart job, restart counter is at 3410.
Aug 01 18:29:46 systemd[1]: Stopped Focalboard server.

I believe the issue is that the x86 version is hardcoded here: https://github.com/YunoHost-Apps/focalboard_ynh/blob/master/conf/app.src#L1

Login and Registration does not work | 401 Unauthorized

may be an upstream issue, but since its probably caused by some stupid thing I did during the install or weird incompatibility ill post here.

Logging & Registering in does not work!
I get lots of "401 Unauthorizd" in my network logs.

IDK if that's the right place to ask and do not expect anyone to provide support just because they put code on GitHub, although some help would be sweet ^^

Steps to reproduce

admin@host:~$ sudo yunohost app install https://github.com/YunoHost-Apps/focalboard_ynh -l Focalboard -a "domain=focalboard.domain.tld"

I did change the domain and not did make any line breaks.

Logs and Context

Logs

DANGER! This app is known to be still experimental (if not explicitly not working)! 
You should probably NOT install it unless you know what you are doing. 
NO SUPPORT will be provided if this app doesn't work or breaks your system… 
If you are willing to take that risk anyway, type 'Yes, I understand': Yes, I understand

Should this app be exposed to anonymous visitors? [yes | no] (default: yes): no

Info: Installing focalboard...
Info: [....................] > Validating installation parameters...
Info: [+++.................] > Storing installation settings...
Info: [###.................] > Finding an available port...
Info: [###+................] > Installing dependencies...
Info: [####+++++...........] > Configuring system user...
Info: [#########+..........] > Creating a PostgreSQL database...
Info: [##########++........] > Setting up source files...
Info: [############+.......] > Configuring NGINX web server...
Info: [#############++.....] > Configuring a systemd service...
Info: [###############++...] > Integrating service in YunoHost...
Info: [#################...] > Starting a systemd service...
Info: [#################+..] > Configuring permissions...
Info: [##################+.] > Reloading NGINX web server...
Info: [####################] > Installation of focalboard completed
Success! Installation completed

note on the unauthorized access: after installation I explicitly allowed visitors through ynh/admin

...and you'll find the full Firefox network log (incl. full requests and responses) attached:
focalboard.domain.tld_Archive [21-06-06 07-39-39].har.txt

Context

• Hardware: VPS bought online
• YunoHost version: 4.2.5.3
• I have access to my server: Through SSH | through the webadmin
• I did not mess with any focalboard or ynh core configs

arm64 support

#9 was previously closed because upstream didn't offer arm64 binaries. However, now that mattermost-community/focalboard#124 has been closed there seems to be official support for this platform. Is it possible to enable the arm64 architecture for the Yunohost app now?

Focalboard upgrade 7.7.0 to 7.9.0 error - service doesn't start anymore

Describe the bug

After an upgrade of Focalboard from 7.7.0 to 7.9.0 the app doesn't run anymore with an error in service log.

Thanks a lot for your help

Context

• Hardware: * DELL 3050 i5 quadcore 8GB Ram 500G HD.*
• YunoHost version: 11.1.15
• I have access to my server: Through SSH | through the webadmin |
• Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: no
• Using, or trying to install package version/branch: 7.9.0~ynh1
• If upgrading, current package version: can be found in the admin, or with yunohost app info $app_id
  7.7.0~ynh1

Steps to reproduce

• If you performed a command from the CLI, the command itself is enough.

  sudo yunohost app upgrade focalboard

Expected behavior

No error during installation/upgrade of the app from 7.7.0 to 7.9.0 but focal board service doesn't start anymore. see log :

Logs

LOGFILE: journalctl
-- Journal begins at Tue 2023-02-21 15:32:29 CET, ends at Tue 2023-03-14 09:31:14 CET. --
mars 14 09:31:14 focalboard-server[2364565]: debug [2023-03-14 09:31:14.799 +01:00] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:273" version=20 current_version=35
mars 14 09:31:14 focalboard-server[2364565]: debug [2023-03-14 09:31:14.799 +01:00] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:281"
mars 14 09:31:14 focalboard-server[2364565]: debug [2023-03-14 09:31:14.800 +01:00] == Applying all remaining migrations ==================== caller="sqlstore/migrate.go:251" current_version=35
mars 14 09:31:14 focalboard-server[2364565]: 2023/03/14 09:31:14 == category_board_add_unique_constraint: migrating ===============================================
mars 14 09:31:14 focalboard-server[2364565]: debug [2023-03-14 09:31:14.810 +01:00] Closing migration engine caller="sqlstore/migrate.go:208"
mars 14 09:31:14 focalboard-server[2364565]: debug [2023-03-14 09:31:14.842 +01:00] Closing migrations connection caller="sqlstore/migrate.go:121"
mars 14 09:31:14 focalboard-server[2364565]: error [2023-03-14 09:31:14.843 +01:00] Table creation / migration failed caller="sqlstore/sqlstore.go:75" error="driver: postgres, message: failed to execute migration, command: executing_query, originalError: pq: n'a pas pu créer l'index unique « unique_user_category_board », query:
mars 14 09:31:14 focalboard-server[2364565]: DO
mars 14 09:31:14 focalboard-server[2364565]: $$
mars 14 09:31:14 focalboard-server[2364565]: BEGIN
mars 14 09:31:14 focalboard-server[2364565]: IF NOT EXISTS (
mars 14 09:31:14 focalboard-server[2364565]: SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
mars 14 09:31:14 focalboard-server[2364565]: WHERE constraint_schema = 'public'
mars 14 09:31:14 focalboard-server[2364565]: AND constraint_name = 'unique_user_category_board'
mars 14 09:31:14 focalboard-server[2364565]: AND constraint_type = 'UNIQUE'
mars 14 09:31:14 focalboard-server[2364565]: AND table_name = 'category_boards'
mars 14 09:31:14 focalboard-server[2364565]: ) THEN
mars 14 09:31:14 focalboard-server[2364565]: ALTER TABLE public.category_boards ADD CONSTRAINT unique_user_category_board UNIQUE(user_id, board_id);
mars 14 09:31:14 focalboard-server[2364565]: END IF;
mars 14 09:31:14 focalboard-server[2364565]: END;
mars 14 09:31:14 focalboard-server[2364565]: $$
mars 14 09:31:14 focalboard-server[2364565]: LANGUAGE plpgsql;
mars 14 09:31:14 focalboard-server[2364565]:
mars 14 09:31:14 focalboard-server[2364565]: "
mars 14 09:31:14 focalboard-server[2364565]: fatal [2023-03-14 09:31:14.843 +01:00] server.NewStore ERROR caller="main/main.go:136" error="driver: postgres, message: failed to execute migration, command: executing_query, originalError: pq: n'a pas pu créer l'index unique « unique_user_category_board », query:
mars 14 09:31:14 focalboard-server[2364565]: DO
mars 14 09:31:14 focalboard-server[2364565]: $$
mars 14 09:31:14 focalboard-server[2364565]: BEGIN
mars 14 09:31:14 focalboard-server[2364565]: IF NOT EXISTS (
mars 14 09:31:14 focalboard-server[2364565]: SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
mars 14 09:31:14 focalboard-server[2364565]: WHERE constraint_schema = 'public'
mars 14 09:31:14 focalboard-server[2364565]: AND constraint_name = 'unique_user_category_board'
mars 14 09:31:14 focalboard-server[2364565]: AND constraint_type = 'UNIQUE'
mars 14 09:31:14 focalboard-server[2364565]: AND table_name = 'category_boards'
mars 14 09:31:14 focalboard-server[2364565]: ) THEN
mars 14 09:31:14 focalboard-server[2364565]: ALTER TABLE public.category_boards ADD CONSTRAINT unique_user_category_board UNIQUE(user_id, board_id);
mars 14 09:31:14 focalboard-server[2364565]: END IF;
mars 14 09:31:14 focalboard-server[2364565]: END;
mars 14 09:31:14 focalboard-server[2364565]: $$
mars 14 09:31:14 focalboard-server[2364565]: LANGUAGE plpgsql;
mars 14 09:31:14 focalboard-server[2364565]:
mars 14 09:31:14 focalboard-server[2364565]: "
mars 14 09:31:14 focalboard-server[2364565]: main.main
mars 14 09:31:14 focalboard-server[2364565]: /home/runner/work/focalboard/focalboard/focalboard/server/main/main.go:136
mars 14 09:31:14 focalboard-server[2364565]: runtime.main
mars 14 09:31:14 focalboard-server[2364565]: /opt/hostedtoolcache/go/1.19.5/x64/src/runtime/proc.go:250
mars 14 09:31:14 focalboard-server[2364565]: runtime.goexit
mars 14 09:31:14 focalboard-server[2364565]: /opt/hostedtoolcache/go/1.19.5/x64/src/runtime/asm_amd64.s:1594
mars 14 09:31:14 systemd[1]: focalboard.service: Main process exited, code=exited, status=1/FAILURE
mars 14 09:31:14 systemd[1]: focalboard.service: Failed with result 'exit-code'.

502 Bad Gateway

Bonjour, j'utilise Yunohost sur un raspberry pi 4 / Arm V8

L'installation semble bien se dérouler, mais une fois "terminé", j'obtiens une erreur bad gateway (err 502) lorsque je vais sur l'adresse dédiés

Voici le log : https://paste.yunohost.org/raw/akojiroxuc

Merci!

integration with mattermost (yunohost)

YunoHost 4.2.8 (stable)
Installed:

1. "mattermost" Version5.38.1~ynh1
2. "focalboard" 0.8.0~ynh1
3. register an account to focalboard
4. at login page > enter creds > board shows for second and return to login page with empty fields
5. install focalboard plugin to mattermost
6. run MM
7. authorised in yunohost
8. try to authorize in focalboard
   expected result: login successful
   actual result: same as step 4 (board shows for second and return to login page with empty fields)
   same result was within first installation attempt, was unable to login at focalboard even without mm

yunohost.mp4

Install Issues

1. Trying to install via webadmin (pasting the URL into the bottom of the page) fails—it just loads forever and doesn't do anything.
2. Via CLI

 sudo yunohost app install https://github.com/YunoHost-Apps/focalboard_ynh
DANGER! This app is not part of Yunohost's app catalog. Installing third-party apps may compromise the integrity and security of your system. You should probably NOT install it unless you know what you are doing. NO SUPPORT will be provided if this app doesn't work or breaks your system… If you are willing to take that risk anyway, type 'Yes, I understand': Yes, I understand
Error: Could not fetch sources files, is the URL correct?

However, sudo yunohost app install https://github.com/YunoHost-Apps/focalboard_ynh/tree/main --debug does work.

I get to the login screen and tried my usual username and pw, but they don't work. I did the registration thing with my server email but it didin't quite work. I tried a different account altogether and it just said "invalid registration link"

Is there a default name/pw?