[Rdo-list] Ironic sqlite db

[Richards, Jeff]

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 at redhat.com [mailto:rdo-list-bounces at redhat.com] On Behalf Of AliReza Taleghani
Sent: Sunday, October 11, 2015 2:42 AM
To: rdo-list at 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/url?u=http-3A__paste.ubuntu.com_12748714_&d=AwMFaQ&c=jF7FvYH6t0RX1HrEjVCgHQ&r=FFExSg3UjsQIQrH8XO10yUzkk87X74z_nQ3oetbwojM&m=_YPQ1sr-1hHShzfYXLLBwG0HkGlXDyLjvXRQg6ZhSDs&s=qRfjTqP63EyUw2BPVgGFbN4vpl2lB0FTByDFOZoCB9w&e=>
I think it's can't load default sqlite schema :-/ where I can find the sql template for manual importing into: inspector.sqlite

[root at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.rdoproject.org/pipermail/dev/attachments/20151012/9bfe67c6/attachment.html>