cannot initialize fido sqlite db

[yih-redhat]

In the HOWTO.md, there are commands to initialize sqlite db, like:

cargo install --force diesel_cli --no-default-features --features sqlite
diesel migration run --migration-dir /usr/share/doc/fdo/migrations/migrations_manufacturing_server_sqlite --database-url "${manufacturer_db_file}"
diesel migration run --migration-dir /usr/share/doc/fdo/migrations/migrations_owner_onboarding_server_sqlite --database-url "${owner_db_file}"
diesel migration run --migration-dir /usr/share/doc/fdo/migrations/migrations_rendezvous_server_sqlite --database-url "${rendezvous_db_file}"

After I run these commands, the table is not created, I need to manually create them, like:

tee "create_table.sql" > /dev/null << EOF
CREATE TABLE manufacturer_vouchers (
    guid varchar(36) NOT NULL PRIMARY KEY,
    contents blob NOT NULL,
    ttl bigint
);
EOF
sqlite3 "${manufacturer_db_file}" < create_table.sql

I suppose this "diesel migration" command should create the table, as this is the only command provided to initialize db in HOWTO.md.

[7flying]

When you are using the RPMs we only install the sql files, and you need to run those to generate the DB. If you use the project from source you can use the diesel tool, basically diesel needs named migration dirs which we do not ship in the RPM