Description of problem: zone2sqlite cannot create a table when table name contain ".", "-" or start with a digit, etc. Version-Release number of selected component (if applicable): bind-9.9.2-9.P1 bind-sdb-9.9.2-9.P1 How reproducible: # zone2sqlite usage: zone2sqlite <zone> <zonefile> <dbfile> <dbtable> # zone2sqlite domaintest.org m:domaintest.org zones.db domaintest.org Connecting to 'zones.db' DROP TABLE domaintest.org CREATE TABLE domaintest.org (NAME TEXT, TTL INTEGER, RDTYPE TEXT, RDATA TEXT) CREATE TABLE domaintest.org failed: unknown database domaintest # zone2sqlite 0-255.1.168.192.in-addr.arpa m:0-255.1.168.192.in-addr.arpa zones.db 0-255.1.168.192.in-addr.arpa Connecting to 'zones.db' DROP TABLE 0-255.1.168.192.in-addr.arpa CREATE TABLE 0-255.1.168.192.in-addr.arpa (NAME TEXT, TTL INTEGER, RDTYPE TEXT, RDATA TEXT) CREATE TABLE 0-255.1.168.192.in-addr.arpa failed: near "0": syntax error # zone2sqlite 0-255.1.168.192.in-addr.arpa m:0-255.1.168.192.in-addr.arpa zones.db rev_0-255.1.168.192.in-addr.arpa Connecting to 'zones.db' DROP TABLE rev_0-255.1.168.192.in-addr.arpa CREATE TABLE rev_0-255.1.168.192.in-addr.arpa (NAME TEXT, TTL INTEGER, RDTYPE TEXT, RDATA TEXT) CREATE TABLE rev_0-255.1.168.192.in-addr.arpa failed: near "-": syntax error Additional info: 1. Table can be created with dummy names and renamed after. 2. named-sdb seems to work fine with table names containing ".", "-" or starting with a digit. 3. Fixing the bug is trivial.
This bug appears to have been reported against 'rawhide' during the Fedora 19 development cycle. Changing version to '19'. (As we did not run this process for some time, it could affect also pre-Fedora 19 development cycle bugs. We are very sorry. It will help us with cleanup during Fedora 19 End Of Life. Thank you.) More information and reason for this action is here: https://fedoraproject.org/wiki/BugZappers/HouseKeeping/Fedora19
This package has changed ownership in the Fedora Package Database. Reassigning to the new owner of this component.
Fixed in bind-9.9.3-0.4.rc1.fc19
zone2sqlite works fine now. Thank you.
bind-9.9.3-0.6.rc2.fc19 has been submitted as an update for Fedora 19. https://admin.fedoraproject.org/updates/bind-9.9.3-0.6.rc2.fc19
bind-9.9.3-0.6.rc2.fc19, dhcp-4.2.5-12.fc19, bind-dyndb-ldap-3.2-1.fc19, dnsperf-2.0.0.0-6.fc19 has been pushed to the Fedora 19 stable repository. If problems still persist, please make note of it in this bug report.