Heroku database updated, now no permissions
Hi Pat
I'm getting a `role "wondbwcmwzxhue" is not permitted to log in` error after upgrading my Heroku database. Nothing in the knowledge base I can find around this.
Is the sphinx auth tied to the database somehow? What's the best way to reestablishing the right auth user - re-add the product or something around config?
Hope you're well!
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
Support Staff 1 Posted by Pat Allan on 03 Aug, 2017 01:07 AM
Heya Nate :)
The Sphinx configuration has the database auth details in it - so yeah, when the database changes, Sphinx needs to be updated as well. The following command should do the trick: `heroku run bundle exec flying-sphinx configure` - and then you can run a full index after to confirm everything’s fine: `heroku run bundle exec flying-sphinx index`.
Flying Sphinx doesn’t have any ability to get new database credentials automatically - which is completely fair and right - but yeah, such situations are often the cause of db/indexing failures. I’ll try to make that clear in the docs!
Hope all’s going well for you,
—
Pat