Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Solved Vaultwarden Database

    Vaultwarden
    2
    3
    430
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M
      mazarian last edited by

      Hi all- I'm a bit new to Cloudron and I've been testing Vaultwarden outside of Cloudron for a while (installed as an add-on through Home Assistant) and I need a little guidance on importing my SQLite database from Vaultwarden on Home Assistant to the MySQL database for Vaultwarden in Cloudron.

      I can see the database url in the Vaultwarden Admin section, but I'm not quite sure how to connect to it in terminal.

      Any help is greatly appreciated!

      Thanks!

      M 1 Reply Last reply Reply Quote 0
      • M
        mazarian @mazarian last edited by

        Of course, you always figure things out after posting, so I thought I'd do a mini-writeup on exporting your Vaultwarden database from the Home Assistant installation and bringing it into Cloudron's instance. Doing so brought over all of the users and organizations that were created before.

        1. I followed this guide to take a SQLite dump of my Home Assistant Vaultwarden database.

        2. Once I had the dump, I opened the web terminal for Vaultwarden in Cloudron and uploaded the dump to /tmp

        3. Once the database was finished being uploaded, I put Vaultwarden in recovery mode (found under the repair section)

        4. After, I clicked on the "MySQL" button, which pasts in the command to connect to the Vaultwarden database in Cloudron. Don't press enter - simply add the following after the connection string: < mysqldump.sql
          The string should look something like this:

        mysql --user=${CLOUDRON_MYSQL_USERNAME} --password=${CLOUDRON_MYSQL_PASSWORD} --host=${CLOUDRON_MYSQL_HOST} ${CLOUDRON_MYSQL_DATABASE} < /tmp/mysqldump.sql
        

        After completing these steps, I took Vaultwarden out of recovery mode, went to the admin page, and confirmed all users exported successfully.

        girish 1 Reply Last reply Reply Quote 4
        • girish
          girish Staff @mazarian last edited by

          @mazarian thanks for following up!

          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          Powered by NodeBB