Issue #2815 has been reported by Tim Stoop.
----------------------------------------
Bug #2815: Sqlite no longer working in Debian Etch?
http://projects.reductivelabs.com/issues/2815
Author: Tim Stoop
Status: Unreviewed
Priority: Normal
Assigned to:
Category:
Target version:
Affected version: 0.25.1
Keywords:
Branch:
Hi there,
I'm trying to create a small test setup using a sqlite based storeconfigs.
However, I keep getting the message that it's missing the hosts table. When I
check the sqlite file, it's there, however. If I enable dbmigrate, it tells me
it's missing the resources table, but it's there too. After I remove the file,
it initialises the database, but after that it seems to no longer be able to
access it.
The puppetmaster config:
<pre>[puppetmasterd]
storeconfigs=true
#thin_storedconfigs=true
dbadapter=sqlite3
dblocation=/var/lib/puppet/storeconfigs.sqlite
#dbmigrate=true</pre>
The file (which I've already tried to remove to see if starting from scratch
helped):
<pre>t...@etch:/var/lib/puppet$ sudo sqlite3 storeconfigs.sqlite
SQLite version 3.3.8
Enter ".help" for instructions
sqlite> .schema
CREATE TABLE "fact_names" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"name" varchar(255) NOT NULL, "updated_at" datetime DEFAULT NULL NULL,
"created_at" datetime DEFAULT NULL NULL);
CREATE TABLE "fact_values" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"value" text NOT NULL, "fact_name_id" integer NOT NULL, "host_id" integer NOT
NULL, "updated_at" datetime DEFAULT NULL NULL, "created_at" datetime DEFAULT
NULL NULL);
CREATE TABLE "hosts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name"
varchar(255) NOT NULL, "ip" varchar(255) DEFAULT NULL NULL, "environment"
varchar(255) DEFAULT NULL NULL, "last_compile" datetime DEFAULT NULL NULL,
"last_freshcheck" datetime DEFAULT NULL NULL, "last_report" datetime DEFAULT
NULL NULL, "updated_at" datetime DEFAULT NULL NULL, "source_file_id" integer
DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL);
CREATE TABLE "param_names" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"name" varchar(255) NOT NULL, "updated_at" datetime DEFAULT NULL NULL,
"created_at" datetime DEFAULT NULL NULL);
CREATE TABLE "param_values" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"value" text NOT NULL, "param_name_id" integer NOT NULL, "line" integer DEFAULT
NULL NULL, "resource_id" integer DEFAULT NULL NULL, "updated_at" datetime
DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL);
CREATE TABLE "puppet_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"name" varchar(255) DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL,
"created_at" datetime DEFAULT NULL NULL);
CREATE TABLE "resource_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"resource_id" integer DEFAULT NULL NULL, "puppet_tag_id" integer DEFAULT NULL
NULL, "updated_at" datetime DEFAULT NULL NULL, "created_at" datetime DEFAULT
NULL NULL);
CREATE TABLE "resources" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"title" text NOT NULL, "restype" varchar(255) NOT NULL, "host_id" integer
DEFAULT NULL NULL, "source_file_id" integer DEFAULT NULL NULL, "exported"
boolean DEFAULT NULL NULL, "line" integer DEFAULT NULL NULL, "updated_at"
datetime DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL);
CREATE TABLE "source_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"filename" varchar(255) DEFAULT NULL NULL, "path" varchar(255) DEFAULT NULL
NULL, "updated_at" datetime DEFAULT NULL NULL, "created_at" datetime DEFAULT
NULL NULL);
CREATE INDEX "index_fact_names_on_name" ON "fact_names" ("name");
CREATE INDEX "index_fact_values_on_fact_name_id" ON "fact_values"
("fact_name_id");
CREATE INDEX "index_fact_values_on_host_id" ON "fact_values" ("host_id");
CREATE INDEX "index_hosts_on_name" ON "hosts" ("name");
CREATE INDEX "index_hosts_on_source_file_id" ON "hosts" ("source_file_id");
CREATE INDEX "index_param_names_on_name" ON "param_names" ("name");
CREATE INDEX "index_param_values_on_param_name_id" ON "param_values"
("param_name_id");
CREATE INDEX "index_param_values_on_resource_id" ON "param_values"
("resource_id");
CREATE INDEX "index_puppet_tags_on_id" ON "puppet_tags" ("id");
CREATE INDEX "index_resource_tags_on_puppet_tag_id" ON "resource_tags"
("puppet_tag_id");
CREATE INDEX "index_resource_tags_on_resource_id" ON "resource_tags"
("resource_id");
CREATE INDEX "index_resources_on_host_id" ON "resources" ("host_id");
CREATE INDEX "index_resources_on_source_file_id" ON "resources"
("source_file_id");
CREATE INDEX "index_resources_on_title_and_restype" ON "resources" ("title",
"restype");
CREATE INDEX "index_source_files_on_filename" ON "source_files" ("filename");
sqlite></pre>
Please let me know if you need additional information!
--
You have received this notification because you have either subscribed to it,
or are involved in it.
To change your notification preferences, please click here:
http://reductivelabs.com/redmine/my/account
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Puppet Bugs" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/puppet-bugs?hl=en
-~----------~----~----~----~------~----~------~--~---
