[Openstack] Designate + Postges error

Nik Maslov azpekt at gmail.com
Sat Mar 8 12:02:50 UTC 2014


Hi, I was able to overcome this issue by manually setting the column type
within powerdns database in Postgres.

After that, everything works as needed.

Say, is there any possibility for designate to use LDAP backend?

Cheers, NM

On Friday, March 7, 2014, Hayes, Graham <graham.hayes at hp.com> wrote:

> Hi Nick,
>
> This looks like a bug in our PowerDNS backend driver.
>
> I *think* this is the offending line:
>
>
> https://github.com/stackforge/designate/blob/master/designate/backend/impl_powerdns/__init__.py#L449
>
> We generally use MySQL, which must just cast it to a bool, while Postgres
> gives out about the type.
>
> On Fri, 2014-03-07 at 18:00 +0200, Nick Maslov wrote:
> Hi,
>
>
> I have installed Designate with Postgres backend. Database initialisation
> went fine, but when I try to add servers it freaks out like this:
>
>
> 2014-03-07 15:57:00.478 3482 TRACE designate.api.middleware Backend:
> Unknown backend failure: ProgrammingError('(ProgrammingError) column "auth"
> is of type boolean but expression is of type integer\nLINE 1:
> ...f8c573e02bc4b\', domains.name, \'NS\', \'ns1.example.org\', 1, 1 \n
>
>
>
>
> Full stack trace is here - http://pastebin.com/Qi0JipGs
>
>
> Is anyone knows whats that?
>
>
> Cheers,
> NM
>
> --
> Nick Maslov
> Sent with Airmail
>
>
> _______________________________________________
> Mailing list:
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> Post to     : openstack at lists.openstack.org <javascript:;><mailto:
> openstack at lists.openstack.org <javascript:;>>
> Unsubscribe :
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>
>
> _______________________________________________
> Mailing list:
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> Post to     : openstack at lists.openstack.org <javascript:;>
> Unsubscribe :
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20140308/b6b631f8/attachment.html>


More information about the Openstack mailing list