This is a known issue that had a bug report filed last Monday.
The problem is the ironic-inspector config is missing a “/” in the sqlite database name
making it a relative path instead of absolute. Change the database name to use 4 slashes
instead of 3, migrate the database and rerun the introspect was the workaround I used:
Config file: /etc/ironic-inspector/inspector.conf
Sync: ironic-inspector-dbsync –config-file /etc/ironic-inspector/inspector.conf upgrade
Jeff Richards
From: rdo-list-bounces(a)redhat.com [mailto:rdo-list-bounces@redhat.com] On Behalf Of
AliReza Taleghani
Sent: Sunday, October 11, 2015 2:42 AM
To: rdo-list(a)redhat.com
Subject: Re: [Rdo-list] Ironic sqlite db
This also caused bare metal hardware detection failed as following:
http://paste.ubuntu.com/12748714/<https://urldefense.proofpoint.com/v2...
I think it's can't load default sqlite schema :-/ where I can find the sql
template for manual importing into: inspector.sqlite
[root@undercloud ~]# sqlite3 /var/lib/ironic-inspector/inspector.sqlite
".dump"
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;
--
Sincerely,
Ali R. Taleghani
This message and any enclosures are intended only for the addressee. Please
notify the sender by email if you are not the intended recipient. If you are
not the intended recipient, you may not use, copy, disclose, or distribute this
message or its contents or enclosures to any other person and any such actions
may be unlawful. Ball reserves the right to monitor and review all messages
and enclosures sent to or from this email address.