[Opendnssec-user] ods-ksmutil zone add -- Failed to import zone

[Sebastian Castro]

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
> Opendnssec-user at lists.opendnssec.org
> 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