Issue #2815 has been updated by James Turnbull. Category set to plumbing Status changed from Unreviewed to Investigating Assigned to set to Brice Figureau Target version set to 0.25.2
Brice - can I ask you to take a look? Re-assign if doesn't suit. ---------------------------------------- Bug #2815: Sqlite no longer working in Debian Etch? http://projects.reductivelabs.com/issues/2815 Author: Tim Stoop Status: Investigating Priority: Normal Assigned to: Brice Figureau Category: plumbing Target version: 0.25.2 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 -~----------~----~----~----~------~----~------~--~---
