Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Using the Registration with Postgres cannot start as the SQL database initialization fails #67

Closed
donicrosby opened this issue Jul 3, 2021 · 3 comments
Labels
bug Something isn't working

Comments

@donicrosby
Copy link

donicrosby commented Jul 3, 2021

Describe the bug

Serving the registration app with a postgres backed database fails as multiple steps in the database creation process are not done

  • The ips table does not have a unique constraint with address
  • Manually adding the constraint still fails as the token and name are incompatible types

To Reproduce

  1. Create a new postgres database with "createdb -O <registration-user> <registration-table>"
  2. Connect to the postgres database using the "postgress://..." connection string
  3. The container will crash hard and will not start up and will display the error about unique constraints, fixing that it still will not start as there are incompatible types with the token and name

Expected behavior

Database is successfully created and the container will start

Screenshots

N/A

System:

  • OS: Ubuntu (Docker/K8s)
  • python version: Docker container version
  • matrix registration version: v0.9.1/v0,9.1.post1

Additional context

N/A

@donicrosby donicrosby added the bug Something isn't working label Jul 3, 2021
@zeratax
Copy link
Owner

zeratax commented Jul 10, 2021

fixed with 4454b3c try this release:
pip install matrix-registration==1.0.0.dev7

I'll get a docker version running hopefully soon!

@zeratax
Copy link
Owner

zeratax commented Jul 10, 2021

alright docker image:
docker pull zeratax/matrix-registration:v1.0.0.dev7

@donicrosby
Copy link
Author

That seemed to work, thanks for the quick update!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants