Public bug reported:
Hi,
found some issues setting up PowerDNS with MySQL backend. There's a
script to create the tables located at /usr/share/dbconfig-common/data
/pdns-backend-mysql/install/mysql
This script has several issues:
1) It contains type=InnoDB for some tables (doesn't specify engine on others).
This is no longer supported and needs to be engine=InnoDB. The script thus fails
2) It creates grants for the domains, records and supermasters tables. Whilst
this is fine it does lead to the assumption the script will set the rights
properly. It does not, as it does not come with grants for the new DNSSec
tables (cryptokeys, domainmetadata, tsigkeys). In my humble opinion one either
does the rights properly or not at all. You don't leave people with only half
the rights configured.
On a side-note, the creation script also alters several tables. I find
that pretty weird. Some might say it's for upgrades, but that just isn't
right as there's a separate script for that in the upgrade directory
(next to the install dir). This one for example doesn't include the
create statements for the domains, records and supermasters tables. Been
using PowerDNS for a year or 4 and those tables have always existed, so
clearly this script is intended for upgrades.
The documentation under /usr/share/doc regarding the package states that
the sql script would be called mysql.sql. It doesn't specify it's
location. One would assume it to be in the documentation directory then,
with the doc itself, but this isn't the case and the extension has thus
been omitted. It would be nice if the documentation would properly
address the name and location of the script to create the required
tables.
Thanks in advance.
PS, the release is 12.04.1 LTS Server (64 bit). The ubuntu-bug tool has
provided this if I'm not mistaken but don't see it on this page.
ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: pdns-backend-mysql 3.0-1.1ubuntu1
ProcVersionSignature: Ubuntu 3.2.0-30.48-generic 3.2.27
Uname: Linux 3.2.0-30-generic x86_64
ApportVersion: 2.0.1-0ubuntu13
Architecture: amd64
Date: Fri Sep 14 11:10:43 2012
InstallationMedia: Ubuntu-Server 12.04.1 LTS "Precise Pangolin" - Release amd64
(20120817.3)
SourcePackage: pdns
UpgradeStatus: No upgrade log present (probably fresh install)
** Affects: pdns (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug precise
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1050829
Title:
PowerDNS - Issues with SQL table creation
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/pdns/+bug/1050829/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
