8000 Try WeKan Snap Manual upgrade to newest Candidate? · Issue #4780 · wekan/wekan · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Try WeKan Snap Manual upgrade to newest Candidate? #4780

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
xet7 opened this issue Dec 19, 2022 · 74 comments
Closed

Try WeKan Snap Manual upgrade to newest Candidate? #4780

xet7 opened this issue Dec 19, 2022 · 74 comments

Comments

@xet7
Copy link
Member
xet7 commented Dec 19, 2022

Does someone have time to test? It's not automatic upgrade, because if there is not enough disk space, there could be data loss.

https://github.com/wekan/wekan-snap/wiki/Candidate-WeKan-Snap-Manual-Upgrade

@ManZosh
Copy link
ManZosh commented Dec 21, 2022

Hi @xet7, I went ahead and followed your guide for the manual upgrade procedure from WeKan-Snap Stable v6.09 to Candidate 6.62. It seems like it was a great success!

Before the upgrade:

  • Ubuntu v20.04.5 LTS GNU/Linux 5.4.0-135-generic
  • WeKan v6.09.0
  • Meteor v2.2
  • Node v12.22.10
  • MongoDB v3.2.22

After the upgrade:

  • WeKan v6.62.0
  • Meteor v2.9.0
  • Node v14.21.2
  • MongoDB v5.0.14

For us, we use WeKan heavily for IT projects, tasks, and long-term strategy. I also use it for facilitating our ERP migration project, and our Accounting & HR teams also use it, although not as much as I think they should! That being said our /var/snap/wekan/common directory is only 403MB.

Some notes maybe specific to our case when following your upgrade instructions:

  • Since we're on v20 LTS, we just had to get the appropriate mongodb-tools for our instance. However, when we went to run dpkg on the .deb, it kept whining about an error trying to overwrite bsondump:
$ sudo dpkg -i mongodb-database-tools-ubuntu2004-x86_64-100.6.1.deb
(Reading database ... 108998 files and directories currently installed.)
Preparing to unpack mongodb-database-tools-ubuntu2004-x86_64-100.6.1.deb ...
Unpacking mongodb-database-tools (100.6.1) ...
dpkg: error processing archive mongodb-database-tools-ubuntu2004-x86_64-100.6.1.deb (--install):
 trying to overwrite '/usr/bin/bsondump', which is also in package mongo-tools 3.6.3-0ubuntu1
dpkg-deb: error: paste subprocess was killed by signal (Broken pipe)
Errors were encountered while processing:
 mongodb-database-tools-ubuntu2004-x86_64-100.6.1.deb

Once I looked up that this is just a diagnostic tool, I just went ahead and forced it:
$ sudo dpkg -i --force-overwrite mongodb-database-tools-ubuntu2004-x86_64-100.6.1.deb
Which that executed smoothly. I was kinda confused why at this point you asked to run sudo apt -f install as I ensured my system was totally up-to-date prior to taking a VM snapshot and proceeding with your upgrade steps! I would hope most people would default to this.

  • The only other thing I was confused on was your step right after the sudo cp common/Caddyfile /var/snap/wekan/common/, you just have ./snap-settings.sh, so I presumed you wanted that copied over to common as well, which I did:
    $ sudo cp snap-settings.sh /var/snap/wekan/common/

Started up and logged into WeKan and everything seems to work great! Exactly as we left it. All our attachments seem intact as well, which is mostly just PDFs and PNGs. So I hope this is big success for you!!! I did notice the Activities feed seems to spam attachment deletions, however from my spot-checking they all still seem to present on those cards:
image

For cleanup, I should be good to delete the common, dump, and snap folders from my home directory right?

Moreover, some features we were excited about and looking forward to, wondering if they are working in v6.62?

  • Input text/formatting when creating a card description or comment is not lost when accidentally clicking off the card. We did test this and it seems clicking off the card still erases any input you had prior. I thought from #4619 a solution was implemented?
  • Email notifications for Mentions, #3529 dunno if current version has any improvements to this?
  • Linking to a card, from another card. Clicking on that linked card just highlights/opens it instead of ope 8000 ning a new browser tab. Is this the Parent Card functionality now? I don't recall seeing that previously. Thought I saw someone asking about this but couldn't find any related Issues/FRs.

2 new small bugs I noticed:

  • opening a card on the far-right edge of the board doesn't automatically scroll your browser page view to see that card it as it did in v6.09.
  • clicking on a linked card in the Activities feed dims the page but does not show the card if the Activities menu is over-top that card. Since our 'Completed' column list is on the far-right, no cards in that list open when clicked on their associated activity.

Do let me know if there's anything else I can do to help or test for you!!! Thanks very much!!!

@xet7
Copy link
Member Author
xet7 commented Dec 21, 2022

@xet7
Copy link
Member Author
xet7 commented Dec 21, 2022

Because manual steps seem to work, I'll try can I make automatic upgrade working.

@xet7
Copy link
Member Author
xet7 commented Dec 21, 2022

@ManZosh

Linking to a card, from another card. Clicking on that linked card just highlights/opens it instead of opening a new browser tab. Is this the Parent Card functionality now? I don't recall seeing that previously. Thought I saw someone asking about this but couldn't find any related Issues/FRs.

Linked card shows the content of card that is somewhere else, like at other board. It's kind of realtime mirror. It's possible to make boards like dashboard, where you link most important cards from other boards to dashboard board, and see in realtime what is most important.

opening a card on the far-right edge of the board doesn't automatically scroll your browser page view to see that card it as it did in v6.09.

It is not fixed yet.

clicking on a linked card in the Activities feed dims the page but does not show the card if the Activities menu is over-top that card. Since our 'Completed' column list is on the far-right, no cards in that list open when clicked on their associated activity.

Can you record animated gif (e.g. with https://github.com/phw/peek) about that and add it as attachment to comment to this issue? Without any private data?

@ManZosh
Copy link
ManZosh commented Dec 21, 2022

Can you record animated gif (e.g. with https://github.com/phw/peek) about that and add it as attachment to comment to this issue? Without any private data?

Ask and you shall receive!!
WeKan_Card_Bugs

We have Lists of Current, H-P Projects, Tasks, L-P Projects, R&D, Ideas, Completed.

Since the Sidebar menu overlaps the last 2 lists, any cards linked in the Activities history do not open. This was not the case back in v6.09. You can see there is 1 card that is able to open from the 3rd list from the right, our On-Hold/Research list, however it seems cut-off on the side and not fully visible. Cards in all the other lists seem to dim & open fine from that Activities history, I just specifically avoided those to do less obfuscating.

Hope this is helpful! Lemme know if I can be of any further assistance. (: As you can see we heavily use this wonderful application so always happy to help.

Unrelated: Is the Favicon supposed to be gone!? On the prior version we still had the default WeKan logo. My pinned WeKan tab on Firefox ESR v102 now:
image

@xet7
Copy link
Member Author
xet7 commented Dec 21, 2022

@ManZosh

Unrelated: Is the Favicon supposed to be gone!? On the prior version we still had the default WeKan logo. My pinned WeKan tab on Firefox ESR v102 now:

No, it's a bug. Thanks!

@mimZD
Copy link
mimZD commented Dec 26, 2022

@xet7
is it safe to update manually now ?
how can i found size of database or wekan app?

@xet7
Copy link
Member Author
xet7 commented Dec 26, 2022

@mohammadZahedian

Manual updating does work. Size etc is explained at:
https://github.com/wekan/wekan-snap/wiki/Candidate-WeKan-Snap-Manual-Upgrade

This month I try to finish some features.

I maybe try to make automatic update working at next month, January 2023. (Or this month, if I have time. I don't know yet.)

@xet7
Copy link
Member Author
xet7 commented Dec 28, 2022

Related to using external file storage, upgrade info:

https://github.com/wekan/wekan/wiki/Rclone

@Meridiana
Copy link

@xet7

I tried to update to newest version according to "Candidate WeKan Snap Manual Upgrade" but it failed in step 15:

root@wekan-test:~# snap stop wekan
Stopped.

root@wekan-test:~# snap start wekan.mongodb
Started.

root@wekan-test:~# mongorestore --drop --port 27019
2023-01-06T12:41:47.896+0100 error connecting to host: could not connect to server: server selection error: server selection timeout, current topology: { Type: Single, Servers: [{ Addr: localhost:27019, Type: Unknown, Last error: connection() error occurred during connection handshake: dial tcp 127.0.0.1:27019: connect: connection refused }, ] }

root@wekan-test:~# snap logs wekan
2023-01-06T12:49:15+01:00 wekan.mongodb[62963]: /snap/wekan/2323/bin/mongodb-control: line 113: mongo: command not found
2023-01-06T12:49:15+01:00 systemd[1]: snap.wekan.mongodb.service: Main process exited, code=exited, status=127/n/a
2023-01-06T12:49:15+01:00 systemd[1]: snap.wekan.mongodb.service: Failed with result 'exit-code'.
2023-01-06T12:49:15+01:00 systemd[1]: snap.wekan.mongodb.service: Consumed 1.112s CPU time.

root@wekan-test:~# ls -l /snap/wekan/2323/bin
total 331828
-rwxr-xr-x 1 root root 21953868 Jul 22 2020 caddy
-rwxr-xr-x 1 root root 390 Jan 3 17:05 caddy-control
-rwxr-xr-x 1 root root 32052 Jan 3 17:05 config
-rwxr-xr-x 1 root root 60 Jan 3 17:05 database-list-backups
-rwxr-xr-x 1 root root 15205 Nov 14 19:25 install_compass
-rwxr-xr-x 1 root root 140396744 Nov 14 20:36 mongod
-rwxr-xr-x 1 root root 662 Jan 3 17:05 mongodb-backup
-rwxr-xr-x 1 root root 6007 Jan 3 17:05 mongodb-control
-rwxr-xr-x 1 root root 503 Jan 3 17:05 mongodb-restore
-rwxr-xr-x 1 root root 101914872 Nov 14 20:38 mongos
-rwxr-xr-x 1 root root 75433976 Dez 13 07:44 node
-rwxr-xr-x 1 root root 1500 Jan 3 17:05 wekan-control
-rwxr-xr-x 1 root root 32045 Jan 3 17:05 wekan-help
-rwxr-xr-x 1 root root 709 Jan 3 17:05 wekan-read-settings

@xet7
Copy link
Member Author
xet7 commented Jan 6, 2023

@Meridiana

Did you do steps 13 and 14?

What does this command produce?

which mongorestore

@xet7
Copy link
Member Author
xet7 commented Jan 6, 2023

New version of mongorestore is is package mongodb-database-tools. That should be used for mongorestore.

@mimZD
Copy link
mimZD commented Jan 8, 2023

@xet7
i just successfully updated to last vesion

titles are weird

image

i think it must be some thing about language pack
i also cannot change language

@xet7
Copy link
Member Author
xet7 commented Jan 8, 2023

@mohammadZahedian

https://github.com/wekan/wekan/wiki/Settings

#4803

@Meridiana
Copy link

New version of mongorestore is is package mongodb-database-tools. That should be used for mongorestore.

The problem is not mongorestore, the problem ist mongodb.service in the snap: it doesnt start because it cannot find the "mongo" command as you can see from the logs:

root@wekan-test:~# snap logs wekan
2023-01-06T12:49:15+01:00 wekan.mongodb[62963]: /snap/wekan/2323/bin/mongodb-control: line 113: mongo: command not found
2023-01-06T12:49:15+01:00 systemd[1]: snap.wekan.mongodb.service: Main process exited, code=exited, status=127/n/a

mongorestore cant connect because the service is not running.

@xet7
Copy link
Member Author
xet7 commented Jan 9, 2023

@Meridiana

What does this command show?

sudo snap list

@Meridiana
Copy link
Meridiana commented Jan 9, 2023

It's latest:

root@wekan-test:~# snap list
Name Version Rev Tracking Publisher Notes
core 16-2.57.6 14399 latest/stable canonical✓ core
core20 20221212 1778 latest/stable canonical✓ base
wekan 6.68 2327 latest/candidate xet7 -
root@wekan-test:~#

@mimZD
Copy link
mimZD commented Jan 9, 2023

@xet7
😨 all of my attachments are gone!!!!!!!!

@xet7
Copy link
Member Author
xet7 commented Jan 9, 2023

@mohammadZahedian

No, your attachments are not gone. It's just that you have not set root-url correctly #4803 (comment)

@xet7
Copy link
Member Author
xet7 commented Jan 9, 2023

@Meridiana

Try starting WeKan:

sudo snap start wekan

And then mongorestore.

@Meridiana
Copy link

It doesn't start because mongodb.service cannot start:

2023-01-09T11:58:22+01:00 wekan.mongodb[1403146]: error: error running snapctl: get which option?
2023-01-09T11:58:22+01:00 wekan.mongodb[1402371]: NODE_OPTIONS=--max_old_space_size=4096 (default value)
2023-01-09T11:58:22+01:00 wekan.mongodb[1402371]: mongodb bind options: --bind_ip 127.0.0.1 --port 27019
2023-01-09T11:58:22+01:00 wekan.mongodb[1402371]: Sending mongodb logs to /dev/null
2023-01-09T11:58:22+01:00 wekan.mongodb[1403158]: /snap/wekan/2327/bin/mongodb-control: line 111: mongo: command not found
2023-01-09T11:58:22+01:00 wekan.mongodb[1403159]: /snap/wekan/2327/bin/mongodb-control: line 113: mongo: command not found
2023-01-09T11:58:22+01:00 systemd[1]: snap.wekan.mongodb.service: Main process exited, code=exited, status=127/n/a
2023-01-09T11:58:22+01:00 systemd[1]: snap.wekan.mongodb.service: Failed with result 'exit-code'.
2023-01-09T11:58:22+01:00 systemd[1]: snap.wekan.mongodb.service: Consumed 1.011s CPU time.

@xet7
Copy link
Member Author
xet7 commented Jan 9, 2023

@Meridiana
Copy link

Yes, I did ... but i will start a new attempt with a fresh copy of our production system ... maybe something went wrong during copy.

I will report later.

@Meridiana
Copy link

@xet7:
looks like it was a problem with the copy ... now i was able to start and restore mongodb successfully.

2023-01-09T14:31:06.827+0100 573 document(s) restored successfully. 0 document(s) failed to restore.

But the attachments are missing:

2023-01-09T14:32:04+01:00 wekan.wekan[1463773]: Error: /var/snap/wekan/common/files/attachments/hWzbQfW6cBMSCMtEC-Test.mp4 Error [MongoError]: Unsupported OP_QUERY command: find. The client driver may require an upgrade. For more details see https://dochub.mongodb.org/core/legacy-opcode-removal
2023-01-09T14:32:04+01:00 wekan.wekan[1463773]: at Function.MongoError.create (/snap/wekan/2327/programs/server/npm/node_modules/meteor/cfs_gridfs/node_modules/mongodb/node_modules/mongodb-core/lib/error.js:31:11)
2023-01-09T14:32:04+01:00 wekan.wekan[1463773]: at queryCallback (/snap/wekan/2327/programs/server/npm/node_modules/meteor/cfs_gridfs/node_modules/mongodb/node_modules/mongodb-core/lib/cursor.js:213:36)
2023-01-09T14:32:04+01:00 wekan.wekan[1463773]: at /snap/wekan/2327/programs/server/npm/node_modules/meteor/cfs_gridfs/node_modules/mongodb/node_modules/mongodb-core/lib/connection/pool.js:436:18
2023-01-09T14:32:04+01:00 wekan.wekan[1463773]: at processTicksAndRejections (internal/process/task_queues.js:77:11) {
2023-01-09T14:32:04+01:00 wekan.wekan[1463773]: ok: 0,
2023-01-09T14:32:04+01:00 wekan.wekan[1463773]: errmsg: 'Unsupported OP_QUERY command: find. The client driver may require an upgrade. For more details see https://dochub.mongodb.org/core/legacy-opcode-removal',
2023-01-09T14:32:04+01:00 wekan.wekan[1463773]: code: 352,
2023-01-09T14:32:04+01:00 wekan.wekan[1463773]: codeName: 'UnsupportedOpQueryCommand'
2023-01-09T14:32:04+01:00 wekan.wekan[1463773]: }
2023-01-09T14:32:04+01:00 wekan.wekan[1463773]: > Finishing migrate-attachment-drop-index-cardId migration.

mongorestore version is:
root@wekan-test:~# mongorestore --version
mongorestore version: 100.6.1
git version: 6d9d341edd33b892a2ded7bae529b0e2a96aae01
Go version: go1.17.10
os: linux
arch: amd64
compiler: gc

@xet7
Copy link
Member Author
xet7 commented Jan 9, 2023

@Meridiana

From that error message it seems WeKan has too old MongoDB driver npm package. I'll try can I upgrade it.

@biolimbo
Copy link
biolimbo commented Jul 8, 2023

Hi @xet7, we tried to upgrade from stable (6.09) to candidate (latest up to date 6.98) and we are not being able to see attachments. Here is a report on the step by step process we followed:

Migration guide report

We have a wean snap v6.09 instance running on a ubuntu 20.04 server which is production. We are trying to migrate to Candidate version in a different server (ubuntu 20.04), we are not able to see the attachments, when we open the cards it says: “If filename is invalid, upload or rename is cancelled.”.

This are the exact step by step we did:

  1. We SSH in to the production server.
  2. We saved snap settings by running:

sudo snap get wekan > snap-settings.sh


  1. We created a dump using this commands:



export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/snap/wekan/current/lib/x86_64-linux-gnu

export PATH="$PATH:/snap/wekan/current/bin"

mongodump --port 27019


  1. We copied the ./dump and snap-settings.sh to a new server using the commands:



scp -r ./dump remote_username@remote_ip_address:/home/remote_username
scp ./snap-settings.sh remote_username@remote_ip_address:/home/remote_username


  1. We SSH into the new server.
  2. We install Wekan using the following command sequence:



sudo su
apt install snapd
snap install wekan


  1. We change the version from stable to candidate by using the command:



sudo snap refresh wekan --channel=latest/candidate


  1. We install mongodb tools (the version specified on the guide):



sudo dpkg -i mongodb-database-tools-ubuntu2004-x86_64-100.6.1.deb


  1. We restore the db by using the following sequence of commands:



sudo snap stop wekan
sudo snap start wekan.mongodb

mongorestore --drop --port 27019 --noIndexRestore


  1. We restore the settings by running manually one by one the snap set command with the values from the saved snap-settings.sh:

sudo snap set wekan root-url='https://boards.***.org'

… all oidc, email, port etc.


  1. We restart Wekan by running:

sudo snap stop wekan
sudo snap start wekan


  1. We go to https://boards.***.org on the browser and login with oidc, all boards look good and the cards too.
  2. We are not seeing any attachment, when we open a card that we know has attachments, we see the message: “If filename is invalid, upload or rename is cancelled.” On the attachments section.

Are we doing something wrong?

Thanks, Santiago

@Milenco
Copy link
Milenco commented Jul 16, 2023

Same issue here. Updated from snap stable version 6.09 to candidate 6.99 using the instructions provided (https://github.com/wekan/wekan-snap/wiki/Candidate-WeKan-Snap-Manual-Upgrade), everything seems to work except attachments and avatars. Running Debian 11.7 here.

The files are there in /var/snap/wekan/common/files/attachments/ and /var/snap/wekan/common/files/avatars/ but are zero bytes, as reported by others.

No errors were reported during the mongodump and mongorestore commands:
import.txt
export.txt

Trying to load the avatars or attachments result in a 503 error code. For example, my Avatar is linked at https://ourwebsite/cfs/files/avatars/RXZMjrbqNzfrBsCdg/Schermafbeelding%202021-11-11%20om%2022.46.03.png but results in a 503.

Maybe this is relevant: We use a Nginx proxy proxy on another server to handle traffic to this wekan server, which also handles certificates and https. The wekan server hosts at port 8080.

Everything else is working: Sessions were restored, logging out and in works (using Google OAuth), new cards and responses work, uploading and downloading new attachments works as expected. Only the current avatars and attachments are gone.

@xet7
Copy link
Member Author
xet7 commented Jul 20, 2023

@Milenco (or someone else) can you try this:

See is attachment and avatar filename/path/URL wrong?

  1. Install WeKan Snap Stable sudo snap install wekan
  2. Add settings, for example: sudo snap set root-url='http://192.168.0.100' and sudo snap set port='80' or something similar
  3. Register, login, add card and attachment image, add avatar image
  4. Backup: mongodump --port 27019
  5. Stop wekan: sudo snap stop wekan
  6. Delete Snap wekan data: sudo rm -rf /var/snap/wekan/common/*
  7. Remove wekan snap: sudo snap remove wekan
  8. Install WeKan Snap Candidate: sudo snap install wekan --channel=latest/candidate
  9. Stop wekan, but not stop mongodb: sudo snap stop wekan.wekan
  10. Restore MongoDB data: mongorestore --drop --port 27019 --noIndexRestore
  11. Start wekan: sudo snap start wekan.wekan or sudo snap start wekan
  12. Create new user, add board, add card, add new different name attachment, add new different name avatar
  13. Use DBGate https://dbgate.org to connect to localhost 27019 and look at attachment filename/path/URL, collection/table etc differences, for old and new attachment and avatar?

I think, fix would probably be to in wekan/server/migrations.js at ostrio migrations change database atttachment text metadata (not binary file chunks) to be in correct table/collection and have correct filename/path/URL so that attachments would be visible.

For upgrading MongoDB from 3.x to newest, here https://github.com/wekan/wekan/blob/master/snapcraft.yaml#L93-L108 in Snap is commented out adding old version of MongoDB Tools etc.

Also here https://github.com/wekan/wekan/blob/master/snap-src/bin/mongodb-control#L20 could be code to:

  1. Detect is there old MongoDB
  2. Have code to check is there enough free disk space
  3. Use old mongodump command to dump old database
  4. Stop old MongoDB 3.x
  5. Start new MongoDB 5.x
  6. Use new mongorestore to restore to new database
  7. Maybe leave old backup to disk, if something went wrong

It is possible to build wekan Snap this way on Ubuntu amd64 I presume:

cd wekan
sudo snap install snapcraft --classic
snapcraft

And install WeKan Snap:

sudo snap install --dangerous wekan.snap

@xet7
Copy link
Member Author
xet7 commented Jul 20, 2023

Build from source and send PR

It's possible to build WeKan from source and send PR like this https://github.com/wekan/wekan/wiki/Emoji

Docker

git clone https://github.com/wekan/wekan

cd wekan
docker-compose up -d --build

@Milenco
F438 Copy link
Milenco commented Jul 22, 2023

Hey @xet7,

Thanks for the detailled steps. Currently I'm in holiday, but I will test it when I'm back (in ~two weeks) and report back then. Sorry this is taking some time on my side..

@C0rn3j
Copy link
Contributor
C0rn3j commented Oct 1, 2023

How would the upgrade path from 6.09 snap to latest docker look like?

I presume first step would be getting 6.09 docker image to run, then somehow attempt to migrate data, then start upgrading (version by version or can larger jumps be made?)

Side note, docker-compose (v1) is dead and unsupported, wiki examples should be moved to docker compose(v2), just drop the hyphen - https://docs.docker.com/compose/migrate/

@xet7
Copy link
Member Author
xet7 commented Oct 1, 2023

@C0rn3j

I'm developing new upgrade path. Previous incomplete migrations are not in use.

@xet7
Copy link
Member Author
xet7 commented Oct 1, 2023

@C0rn3j

Preferred way to upgrade Snap is to do nothing. There will be automatic upgrade to newest WeKan, when I get that upgrade migrations working.

@jeroenstoker
Copy link
jeroenstoker commented Nov 14, 2023

Looking forward! 🥰

@xet7 xet7 closed this as completed Nov 21, 2023
@C0rn3j
Copy link
Contributor
C0rn3j commented Nov 22, 2023

@xet7 Is the automatic upgrade meant to be working now as the ticket has been closed?

[0] # snap list; snap warnings; snap refresh wekan
Name   Version    Rev    Tracking       Publisher   Notes
core   16-2.60.4  16202  latest/stable  canonical✓  core
wekan  6.09       1999   latest/stable  xet7        -
--
last-occurrence:  6 days ago, at 16:17 CET
warning: |
  the snapd.apparmor service is disabled; snap applications will likely not start.
  Run "systemctl enable --now snapd.apparmor" to correct this.
--
snap "wekan" has no updates available

@xet7
Copy link
Member Author
xet7 commented Nov 22, 2023

@C0rn3j
Copy link
Contributor
C0rn3j commented Nov 22, 2023

Your project, your rules, but losing the ability to subscribe to specific issues I care about is disappointing.

Glad to see a fix is still in the works at least.

@xet7
Copy link
Member Author
xet7 commented Nov 22, 2023

@C0rn3j

Your project, your rules, but losing the ability to subscribe to specific issues I care about is disappointing.

It is much faster to look at short Big Picture Roadmap wiki page, than to receive hundreds of emails. That is why there is also upcoming WeKan feature to combine notifications to one notification.

There also were many duplicates of same issues.

There is nothing disappointing in about having faster progress of getting features and fixes.

@xet7
Copy link
Member Author
xet7 commented Nov 22, 2023

@C0rn3j

Your project, your rules, but losing the ability to subscribe to specific issues I care about is disappointing.

There is a possibility, that you are right. So I added this limitation to https://github.com/wekan/wekan/blob/main/FUTURE.md

Moved Import/Export/Sync issues to Big Picture Roadmap wiki page.
This change is limited to only Import/Export/Sync issues, while those are In Progress of being fixed.

I also opened those issues that were not specifically about Import/Export/Sync etc.

If some closed issue needs more discussion, someone can comment in that issue, so I can open it again.

@e-gaulue
Copy link
Contributor

I think I read almost all the posts.

I think I understand all the commands I executed, but I still miss few informations.

I tried to restore to a new Wekan without success for attachments and avatars. For avatars, it looks rather easy: I can request users to put new ones, for attachments it's harder.

As far as I understand, we make a mongodump from old version. And we use mongorestore (new version) to restore the database. So mongo, is restoring data "knowing" the database version difference. Then what "break" attachments looks to be linked with what is/was used to handle files at the Meteor level. So, I believe some works need to be done by wekan at service startup to detect we have old file datas in the db and need to convert them to new datas. Is this right? If yes? How could we request/observe this "migration" script to try to help overcome the trouble. As it something to do with #4891 ? Can we help in anything?

Other remarks:

  • tried directly http://ip_adresse on port 80 or using Apache proxyPass, but leads to the same result.
  • in my case the version of mongorestore present in the snap is the same than the one you requested to install on the OS (installing mongoldb 6 on Debian 12)
  • I felt in the mongoldb unable to start trouble that lots described. I think it's due to a wrong sudo snap install wekan, that I then tried to correct with a sudo snap refresh wekan --channel=latest/candidate. This seems to lead to a mongodb --bind_ip parameter error at service startup. Removing snap and then reinstalling wekan with sudo snap refresh wekan --channel=latest/candidate looks to solve the issue. This situation is really weird.
  • new avatars/attachments show full URI in the HTML, while old ones show relative ones starting with /cfs/

@xet7
Copy link
Member Author
xet7 commented Feb 12, 2024

@C0rn3j
Copy link
Contributor
C0rn3j commented Apr 14, 2024

Since I do not have a lot of attachments or boards, I ended up migrating manually to docker.

In short:

Export your boards as JSON from WeKan snap. 7BF5

Manually export all attachments you care about.

# Clone this repo
git clone --depth 1 https://github.com/wekan/wekan

Edit the wekan/docker-compose.yml for some needed parameters, in my case namely:

      - ROOT_URL={{ wekan_root_url }}  #   <=== using only at same laptop/desktop where Wekan is installed
      - MAIL_URL={{ wekan_mail_url }}
      - MAIL_FROM={{ wekan_mail_from }}

Then spin up the docker mongo and wekan:

cd wekan
docker compose up -d
# Exec into the container
docker exec -it wekan-app bash
# Make attachment imports not do anything instead of failing, so import can go through
sed -i -e 's|Attachment\.load|//|g' -e 's|Attachment\.write|//|g' /build/programs/server/app/app.js
# Exit out of the container
exit
# Restart containers to apply changes
docker compose restart

Import the boards by copypasting the JSON.

Manually import attachments back.

Future plans are to fix this importing to allow to do this without hacks and manual attachmetn exports/imports - #5207 (comment) - but I tired of waiting.

If all fails, just keep using the snap instance, these steps do not require you to take it down.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

0