[ VaultWarden SQL ] [ 1.21.0.0 ] Password management solution for individuals, teams

This is the best place for community developers to publish their genius work. Your Apps enrich the QNAP Turbo NAS.
mschubert
Starting out
Posts: 12
Joined: Wed May 26, 2021 1:38 am

Re: [ VaultWarden SQL ] [ 1.21.0.0 ] Password management solution for individuals, teams

Post by mschubert »

Hello Stephane,

Thank you for your hard work on implementing this! I actually spent a week searching for ways to host Bitwarden on our QNAP and just yesterday came across this forum. I was able to deploy and configure Vaultwarden very quickly and easily so thank you very much for that!

Two things that concern me about this QPKG implementation are 1) Backups and 2) Updates.

Can you provide or direct me to a simple guide on how to implement automatic (daily) backups of our Vaultwarden implementation to a shared folder on the NAS? And how I can restore from the backup should disaster strike. As well as how I keep Vaultwarden up to date? Will the app update automatically or will the QNAP App Center prompt to update the app when one is available? Or is there another way to update the software?

Thank you!
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ VaultWarden SQL ] [ 1.21.0.0 ] Password management solution for individuals, teams

Post by QNAP_Stephane »

guess a mysqldump in a cronjob should be enought to dump the Database

Update are done by myself (need a rust compilation)
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
mschubert
Starting out
Posts: 12
Joined: Wed May 26, 2021 1:38 am

Re: [ VaultWarden SQL ] [ 1.21.0.0 ] Password management solution for individuals, teams

Post by mschubert »

Hey Stephane,

Thank you for the quick reply and sorry for the delay getting back to you.

"guess a mysqldump in a cronjob should be enought to dump the Database" - I have an idea of what a cronjob is but that's about it. I have little experience with Linux and basically no experience with bash/CLI. That said, if you can provide very simple (step-by-step) instructions on what to do I can likely get this setup. Alternatively, I'd be happy to pay for a version of the app with an easy (point-and-click) backup feature, or perhaps I could pay for an hour of your time to remote in and give me a hand?

And for the updates, will the app running on my NAS update automatically?

Thank you again. We've started using Vaultwarden quite a bit and it's working really well, but having to do the manual exports is a pain for sure!
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ VaultWarden SQL ] [ 1.21.0.0 ] Password management solution for individuals, teams

Post by QNAP_Stephane »

I will check when i have time to create a VaultWarden SQLdumper qpkg

or include it directly in the QPKG and do this on each QPKG Start/Stop
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
mschubert
Starting out
Posts: 12
Joined: Wed May 26, 2021 1:38 am

Re: [ VaultWarden SQL ] [ 1.21.0.0 ] Password management solution for individuals, teams

Post by mschubert »

That'd be awesome! Would it be possible to schedule it to backup every 24 hours? We'd like to stay in-line with our other RPOs, and minimize loss should disaster strike. Also, where would this be backing up to? Is there a way to get those backups into one of the shared folders on the NAS?

And what about the updates?

Thank you!
(If I'm the only one asking you about these things then I don't mind paying for your time to help me setup something custom here)
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ VaultWarden SQL ] [ 1.21.0.0 ] Password management solution for individuals, teams

Post by QNAP_Stephane »

i cant promise for tomorrow, it needs times to think which is the best solution
also the restore has to be think (good to backup , better to be able to restore)

Update will already need a rust compilation... (i monitoring github everyday with alert)
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
mschubert
Starting out
Posts: 12
Joined: Wed May 26, 2021 1:38 am

Re: [ VaultWarden SQL ] [ 1.21.0.0 ] Password management solution for individuals, teams

Post by mschubert »

Hi Stephane,

Checking in to see where things are at with automated schedule backup and steps for restoration. We're doing manual exports on a weekly basis but it would be great to automate this as well as have full backup (including application and configuration) and steps for restoration to minimize downtime should the app crash or the database get corrupted or the NAS fail for some reason. We're relying on this app more and more now so would really like to make sure we've got a solid backup and restore plan implemented. Thank you.
mschubert
Starting out
Posts: 12
Joined: Wed May 26, 2021 1:38 am

Re: [ VaultWarden SQL ] [ 1.21.0.0 ] Password management solution for individuals, teams

Post by mschubert »

Hi Stephane,

I've been investigating ways of setting up an automated backup. I was able to SSH in and find the path to the Vaultwarden QPKG folder. I then created a symlink to this folder in one of my shared folder and tried to backup the symlink using HBS 3, hoping that it would backup the contents of the Vaultwarden folder. Unfortunately it skipped the symlink file. I then thought about specifying the actual sub-directories and files within the symlink in HBS 3 config and started to wonder if it's even safe to use HBS 3 to backup those files (including the mySQLlite database)?

Can you confirm whether or not I'm on the right track with this or point me in a better direction?
Thank you.
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ VaultWarden SQL ] [ 1.21.0.0 ] Password management solution for individuals, teams

Post by QNAP_Stephane »

Hi yes it is a workaround ... it sould work

consider HBS3 make a snapshot before backup as well (include in HBS option) and add option follow symlink and hidden directory

if you have a second NAs you can try the restore as well to double check all is ok
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
mschubert
Starting out
Posts: 12
Joined: Wed May 26, 2021 1:38 am

Re: [ VaultWarden SQL ] [ 1.21.0.0 ] Password management solution for individuals, teams

Post by mschubert »

Okay so I don't have to worry about HBS 3 corrupting the database (I assume that's why you want it to do a snapshot first)?
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ VaultWarden SQL ] [ 1.21.0.0 ] Password management solution for individuals, teams

Post by QNAP_Stephane »

yes exactly
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
Post Reply

Return to “Community Apps”