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.

Sign up for GitHub

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

Jump to bottom

1.12.58: build_db.py broken with Postgresql #81

Open
jouvin opened this issue May 21, 2018 · 0 comments
Open

1.12.58: build_db.py broken with Postgresql #81

jouvin opened this issue May 21, 2018 · 0 comments

Comments

@jouvin
Copy link
Contributor

jouvin commented May 21, 2018

build_db.py in 1.12.58 has been modified to support both IPv4 and IPv6. Network CIDR constraint has been defined with a condition on the IP version and the syntax used doesn't seem to work with Postgres, leading to a failure to initialize the DB. The problem is https://github.com/quattor/aquilon/blob/upstream/lib/aquilon/aqdb/model/network.py#L147 in 1.12.58.

The versions used in my case were Postgres 9.6 (but I guess that the CentOS-provided 9.2 will exhibit the same problem) and SQLAlchemy 1.2.7.

A workaround is to remove the condition and define CIDR to be 32 bit but this breaks the IPv6 support. A clean solution is needed.

This issue seems somewhat related to #42.
@jouvin jouvin mentioned this issue May 21, 2018
Closed
ned21 pushed a commit to ned21/aquilon that referenced this issue Mar 4, 2020
Merge pull request quattor#81 in AQUILON_AQD/aqd from ~AQBLD/aqd:for_…
eb504c8 
…merge/master/by_topic/fix_build_db_on_oracle to master

* commit '47e5cf308978a2d0fbf93f7c9151eb164ef4e1e6':
  Fix EMAQ constraint naming in build_db on Oracle
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@jouvin