Hi everyone, I'm using PowerDNS on a MySql backend.
All worked fine until I decided to create a slightly modified version of
the mysql database schema
<http://doc.powerdns.com/generic-mypgsql-backends.html#idp8855424>
In particular, I changed the 'domain_id' field from the 'records' table
to be of type *varchar*, since I want to use the domain name itself as
the foreign key and not some autoincremental numeric value. Postfix, for
instance, uses this approach.
The problem is that PowerDns tries to cast the 'domain_id' value to
integer and, failing in doing so, the resulting value is always a 0.
That's my interpretation, since I've seen a '0' showing up in subsequent
mysql queries.
Any hints on how I might solve this problem without actually
reintroducing the numeric field?
Thank you in advance!
<http://doc.powerdns.com/generic-mypgsql-backends.html#idp8855424>
_______________________________________________
Pdns-users mailing list
[email protected]
http://mailman.powerdns.com/mailman/listinfo/pdns-users
