1.12.58: build_db.py broken with Postgresql

[jouvin]

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 has been open in the wrong repo. Closing it. Replaced by quattor/aquilon#81.

[jrha]

@jouvin, for the record, which version of Postgresql and sqlalchemy are you using?

[jouvin]

@jrha sorry for forgetting mentioning it. Description updated.

[jouvin]

Reopening the issue in the aquilon repository....