[Opendnssec-user] Cannot run 'ksmutil update': "ERROR: error executing SQL - no such table: dbadmin"

[sion at nominet.org.uk]

This was an issue that I introduced into b4 that is fixed in trunk...

Short of running the version from trunk you could execute something like:

$ sqlite3 /var/opendnssec/kasp.db <
/share/opendnssec/database_create.sqlite3

after which ksmutil setup and ksmutil update should work.

Sorry,

Sion

opendnssec-user-bounces at lists.opendnssec.org wrote on 27/10/2009 11:31:16:

> Stephane Bortzmeyer <bortzmeyer at nic.fr>
> Sent by: opendnssec-user-bounces at lists.opendnssec.org
>
> 27/10/2009 11:31
>
> To
>
> opendnssec-user at lists.opendnssec.org
>
> cc
>
> Subject
>
> [Opendnssec-user] Cannot run 'ksmutil update': "ERROR: error
> executing SQL - no such table: dbadmin"
>
> I'm running OpenDNSSEC (1.0.0b4). 'make' and 'make install' apparently
> went fine (no error reported). But I cannot initialize the KASP
> database:
>
> % sudo ksmutil setup
> *WARNING* This will erase all data in the database; are you sure? [y/N] y
> SQLite database set to: /var/opendnssec/kasp.db
> ERROR: error executing SQL - no such table: dbadmin
> Failed to connect to database
>
> /var/opendnssec/kasp.db exists but is empty:
>
> % ls -l /var/opendnssec/kasp.db
> -rw-r--r-- 1 root root 0 Oct 27 12:24 /var/opendnssec/kasp.db
>
> If 'ksmutil setup' cannot create the schema of the database (I also
> tried 'ksmutil update'), which program can do it? I do not find it in
> ksmutil help or in the user's guide.
>
> _______________________________________________
> Opendnssec-user mailing list
> Opendnssec-user at lists.opendnssec.org
> https://lists.opendnssec.org/mailman/listinfo/opendnssec-user