vaultwarden_heroku icon indicating copy to clipboard operation
vaultwarden_heroku copied to clipboard

offside db postgresql

Open geeks121 opened this issue 3 years ago β€’ 6 comments

i tried offside db using postgresql from bit.io but nothing happened

geeks121 avatar Jan 09 '22 17:01 geeks121

Could you provide more details on the issue you are facing and what you have done thus far to help troubleshoot?

davidjameshowell avatar Jan 10 '22 02:01 davidjameshowell

i tried with heroku verified : 0 using postgresql from bit.io and the setting above not triggered to use offside DB . as i read the readme ,, to use offside db i should set heroku verified to 0 right? ..

and if i set heroku verified : 0 use_psql : 0 the bot will setup without any database

i setup db connection in secrets github ..

geeks121 avatar Jan 11 '22 03:01 geeks121

HEROKU_VERIFIED variable is hardcoded in deploy.yml and update.yml, simple fix here

ncomerci avatar Feb 18 '22 00:02 ncomerci

The only real reason it is hard coded is any value that is listed in secret becomes redacted in logs, which subsequently means anything with a "1" becomes an asterisk. Can make debugging a pain.

davidjameshowell avatar Feb 18 '22 01:02 davidjameshowell

Yes, I get your point but I ran into the same problem mentioned here when I did my deploy and I solved it this way so I could change it quickly. I think it would be good to clarify this issue in the readme because I think it is not very clear πŸ™ŒπŸ»πŸ˜‰

ncomerci avatar Feb 18 '22 03:02 ncomerci

Yes, I get your point but I ran into the same problem mentioned here when I did my deploy and I solved it this way so I could change it quickly. I think it would be good to clarify this issue in the readme because I think it is not very clear πŸ™ŒπŸ»wink

Hi bro, I used the bit.io database but after deployment heroku is giving following error:

2022-04-14 20:09:39.204][panic][ERROR] thread 'main' panicked at 'Failed to disable Foreign Key Checks during migrations: DatabaseError(__Unknown, "QueryParsingError: Unsupported command: SET CONSTRAINTS ALL DEFERRED\nvalidate_unsupported_cmd")': src/db/mod.rs:449

If I use Heroku Postgres it works but for bitio,it doesn't works. Any suggestion?

aditya-shri avatar Apr 14 '22 20:04 aditya-shri