Sion Lloyd wrote: > 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 >
The kasp.db was created before the change, so I ran the script and it's happy again. Thanks! > 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 -- Sebastian Castro DNS Specialist .nz Registry Services (New Zealand Domain Name Registry Limited) desk: +64 4 495 2337 mobile: +64 21 400535 _______________________________________________ Opendnssec-user mailing list [email protected] https://lists.opendnssec.org/mailman/listinfo/opendnssec-user
