On Tuesday 26 Oct 2010 11:24:39 am Sebastian Castro wrote: > Hi: > > I'm running OpenDNSSEC 1.2b1 r4141 and I tried the following: > > /usr/local/opendnssec/bin/ods-ksmutil zone add --zone srs.net.nz > --policy nz-srs > zonelist filename set to /etc/opendnssec/zonelist.xml. > SQLite database set to: /var/opendnssec/kasp.db > ERROR: error executing SQL - table zones has no column named signconf > Failed to Import zone > > Did I catch the system in an intermediate unstable version and we should > expect a change in the database schema? > > After reviewing old copies of the kasp.db, I haven't seen that column in > the 'zones' table. > > Any comments are appreciated.
Sorry. A change was made in revision 3823 that added these columns, so maybe you created your kasp.db before that revision? In which case you will need to run: OpenDNSSEC/enforcer/utils/migrate_100827_1.sqlite3 on your database. If it is a fresh database then it indicates that the database creation script did not get put into place at some point... Check the file <INSTALL_ROOT>/share/opendnssec/database_create.sqlite3 compared to OpenDNSSEC/enforcer/utils/database_create.sqlite3 Sion _______________________________________________ Opendnssec-user mailing list [email protected] https://lists.opendnssec.org/mailman/listinfo/opendnssec-user
