Originally created by @Skaronator on GitHub (Aug 31, 2019).
Hi!
Just saw in the changelog that you can now backup the SQLite Database in the admin web interface but saidly it looks like that option isn't available for me.
Originally created by @Skaronator on GitHub (Aug 31, 2019).
Hi!
Just saw in the changelog that you can now backup the SQLite Database in the admin web interface but saidly it looks like that option isn't available for me.

Looks like this check results in a `false`:
https://github.com/dani-garcia/bitwarden_rs/blob/026f9da035dcbf5ff12387600162841f94b47154/src/api/admin.rs#L39-L41
since sqlite isn't available in the container:
https://github.com/dani-garcia/bitwarden_rs/blob/469318bcbdca68ca58735f7cc58dd1e943e4da1e/docker/amd64/sqlite/Dockerfile#L32-L35
I tried the following docker images:
- bitwardenrs/server:alpine
- bitwardenrs/server:latest
Currently running version 1.10.0-469318bc
Those lines you linked are for the build container, the final image never had sqlite bundled in. The PR #475 was merged with the understanding that there will be better option than running external command once the sqlite 3.27 becomes more common.
So right now, you can build your own version of the image with sqlite bundled in. Or we can discuss bundling in another binary or we can see if newer sqlite library and built-in backup functionality would be an option now. (the latest would be the ideal solution IMO)
@mprasil commented on GitHub (Sep 4, 2019):
Those lines you linked are for the build container, the final image never had sqlite bundled in. The PR #475 was merged with the understanding that there will be better option than running external command once the sqlite `3.27` becomes more common.
So right now, you can build your own version of the image with sqlite bundled in. Or we can discuss bundling in another binary or we can see if newer sqlite library and built-in backup functionality would be an option now. (the latest would be the ideal solution IMO)
@mprasil
I'm afraid we will have to wait for a few more months for the ideal solution.
We will need a libsqlite-sys 0.17 crate (that version uses SQLite 3.27 for VACUUM INTO support)
After that is out, we have to wait for Diesel to support it as libsqlite-sys 0.17 has a few breaking changes.
@TheMardy commented on GitHub (Sep 30, 2019):
@mprasil
I'm afraid we will have to wait for a few more months for the ideal solution.
We will need a libsqlite-sys 0.17 crate (that version uses SQLite 3.27 for `VACUUM INTO` support)
After that is out, we have to wait for Diesel to support it as libsqlite-sys 0.17 has a few breaking changes.
The latest images should have sqlite bundled in and the backup option should be present in the admin interface. I'm going to resolve this.
@mprasil commented on GitHub (Oct 2, 2019):
The latest images should have sqlite bundled in and the backup option should be present in the admin interface. I'm going to resolve this.
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
Originally created by @Skaronator on GitHub (Aug 31, 2019).
Hi!
Just saw in the changelog that you can now backup the SQLite Database in the admin web interface but saidly it looks like that option isn't available for me.
Looks like this check results in a
false:https://github.com/dani-garcia/bitwarden_rs/blob/026f9da035dcbf5ff12387600162841f94b47154/src/api/admin.rs#L39-L41
since sqlite isn't available in the container:
https://github.com/dani-garcia/bitwarden_rs/blob/469318bcbdca68ca58735f7cc58dd1e943e4da1e/docker/amd64/sqlite/Dockerfile#L32-L35
I tried the following docker images:
Currently running version 1.10.0-469318bc
@mprasil commented on GitHub (Sep 4, 2019):
Those lines you linked are for the build container, the final image never had sqlite bundled in. The PR #475 was merged with the understanding that there will be better option than running external command once the sqlite
3.27becomes more common.So right now, you can build your own version of the image with sqlite bundled in. Or we can discuss bundling in another binary or we can see if newer sqlite library and built-in backup functionality would be an option now. (the latest would be the ideal solution IMO)
@TheMardy commented on GitHub (Sep 30, 2019):
@mprasil
I'm afraid we will have to wait for a few more months for the ideal solution.
We will need a libsqlite-sys 0.17 crate (that version uses SQLite 3.27 for
VACUUM INTOsupport)After that is out, we have to wait for Diesel to support it as libsqlite-sys 0.17 has a few breaking changes.
@mprasil commented on GitHub (Sep 30, 2019):
I've created PR #638 to use the binary in the meantime.
@mprasil commented on GitHub (Oct 2, 2019):
The latest images should have sqlite bundled in and the backup option should be present in the admin interface. I'm going to resolve this.