Hi, I''m upgrading from 23.2 to the latest and have "dbmigrate = true" in my config. When I try to run puppetd, I''m getting: Could not migrate database: SQLite3::SQLException: no such table: schema_info: SELECT version FROM schema_info I''m perfectly blowing away my old db (by deleting /var/lib/puppet/ state/clientconfigs.sqlite3 ?), but I haven''t figured out how to create a new db with the latest schema. I''ve tried re-running the install.rb, but that doesn''t seem to do anything. Any tips here? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com To unsubscribe from this group, send email to puppet-users-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en -~----------~----~----~----~------~----~------~--~---
On Mar 29, 10:34 am, scaldwell <scaldw...@gmail.com> wrote:> > I''m perfectly blowing away my old db (by deleting /var/lib/puppet/that should be "perfectly happy" blowing my old db --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com To unsubscribe from this group, send email to puppet-users-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en -~----------~----~----~----~------~----~------~--~---
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Saturday 29 March 2008, scaldwell wrote:> When I try to run puppetd, I''m getting: > > Could not migrate database: SQLite3::SQLException: no such table: > schema_info: SELECT version FROM schema_info > > I''m perfectly blowing away my old db (by deleting /var/lib/puppet/ > state/clientconfigs.sqlite3 ?),yes> but I haven''t figured out how to > create a new db with the latest schema. I''ve tried re-running the > install.rb, but that doesn''t seem to do anything. Any tips here?AFAIK, the puppetmaster should create the database on first run.> Hi, I''m upgrading from 23.2 to the latest and have "dbmigrate = true" > in my config.But I''m not so sure why you have this. I didn''t need to dbmigrate and I''m not aware of any schema changes. Regards, DavidS - -- The primary freedom of open source is not the freedom from cost, but the free- dom to shape software to do what you want. This freedom is /never/ exercised without cost, but is available /at all/ only by accepting the very different costs associated with open source, costs not in money, but in time and effort. - -- http://www.schierer.org/~luke/log/20070710-1129/on-forks-and-forking -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFH7oSD/Pp1N6Uzh0URAhPcAJ9OJw9mAcbah9UsFva2zMgfDe3QggCgje9M ekVlVnANbvE/x4n/Vx8/y6Q=veIR -----END PGP SIGNATURE----- --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com To unsubscribe from this group, send email to puppet-users-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en -~----------~----~----~----~------~----~------~--~---
On Mar 29, 11:03 am, David Schmitt <da...@schmitt.edv-bus.at> wrote:> > > but I haven''t figured out how to > > create a new db with the latest schema. I''ve tried re-running the > > install.rb, but that doesn''t seem to do anything. Any tips here? > > AFAIK, the puppetmaster should create the database on first run. >When I do this: mv /var/lib/puppet/state/clientconfigs.sqlite3 /var/lib/puppet/state/ clientconfigs.sqlite3.bak /etc/init.d/puppetmaster restart puppetd --test I get: Could not retrieve catalog: Uncaught exception could not open database: unable to open database file in method puppetmaster.getconfig> > But I''m not so sure why you have this. I didn''t need to dbmigrate and I''m not > aware of any schema changes. >If I don''t have dbmigrate set to true, I get this error: Could not store configs: SQLite3::SQLException: SQL logic error or missing database: DELETE FROM fact_values WHERE "id" = 39 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com To unsubscribe from this group, send email to puppet-users-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en -~----------~----~----~----~------~----~------~--~---
On Mar 30, 2008, at 10:14 AM, scaldwell wrote:> > On Mar 29, 11:03 am, David Schmitt <da...@schmitt.edv-bus.at> wrote: >> >>> but I haven''t figured out how to >>> create a new db with the latest schema. I''ve tried re-running the >>> install.rb, but that doesn''t seem to do anything. Any tips here? >> >> AFAIK, the puppetmaster should create the database on first run. >> > > When I do this: > mv /var/lib/puppet/state/clientconfigs.sqlite3 /var/lib/puppet/state/ > clientconfigs.sqlite3.bak > /etc/init.d/puppetmaster restart > puppetd --test > > I get: > > Could not retrieve catalog: Uncaught exception could not open > database: unable to open database file in method > puppetmaster.getconfig > >> >> But I''m not so sure why you have this. I didn''t need to dbmigrate >> and I''m not >> aware of any schema changes. >> > > If I don''t have dbmigrate set to true, I get this error: > > Could not store configs: SQLite3::SQLException: SQL logic error or > missing database: DELETE FROM fact_values > WHERE "id" = 39You should just be able to use touch to create the empty file using, and then the it will be able to recreate the schema. -Blake --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com To unsubscribe from this group, send email to puppet-users-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en -~----------~----~----~----~------~----~------~--~---
On Mar 30, 4:11 pm, Blake Barnett <sha...@gmail.com> wrote:> > You should just be able to use touch to create the empty file using, > and then the it will be able to recreate the schema. >OK, I tried that and am now getting this error: err: Could not retrieve catalog: SQLite3::SQLException: SQL logic error or missing database: CREATE TABLE resources ("id" INTEGER PRIMARY KEY NOT NULL, "title" text NOT NULL, "restype" varchar(255) NOT NULL, "host_id" integer DEFAULT NULL, "source_file_id" integer DEFAULT NULL, "exported" boolean DEFAULT NULL, "line" integer DEFAULT NULL, "updated_at" datetime DEFAULT NULL) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com To unsubscribe from this group, send email to puppet-users-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en -~----------~----~----~----~------~----~------~--~---
On Mar 30, 2008, at 5:20 PM, scaldwell wrote:> > On Mar 30, 4:11 pm, Blake Barnett <sha...@gmail.com> wrote: >> >> You should just be able to use touch to create the empty file using, >> and then the it will be able to recreate the schema. >> > > OK, I tried that and am now getting this error: > > err: Could not retrieve catalog: SQLite3::SQLException: SQL logic > error or missing database: CREATE TABLE resources ("id" INTEGER > PRIMARY KEY NOT NULL, "title" text NOT NULL, "restype" varchar(255) > NOT NULL, "host_id" integer DEFAULT NULL, "source_file_id" integer > DEFAULT NULL, "exported" boolean DEFAULT NULL, "line" integer DEFAULT > NULL, "updated_at" datetime DEFAULT NULL)Sorry, I never use sqlite3, think you may have to create a table for it to think it''s a valid database? I really don''t know, but try doing this in the clientconfigs.sqlite3 file: CREATE TABLE test(test INT); Personally I''d use mysql though. ;) -Blake --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com To unsubscribe from this group, send email to puppet-users-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en -~----------~----~----~----~------~----~------~--~---
On Mar 30, 9:11 pm, Blake Barnett <sha...@gmail.com> wrote:> > > err: Could not retrieve catalog: SQLite3::SQLException: SQL logic > > error or missing database: CREATE TABLE resources ("id" INTEGER > > PRIMARY KEY NOT NULL, "title" text NOT NULL, "restype" varchar(255) > > NOT NULL, "host_id" integer DEFAULT NULL, "source_file_id" integer > > DEFAULT NULL, "exported" boolean DEFAULT NULL, "line" integer DEFAULT > > NULL, "updated_at" datetime DEFAULT NULL) > > Sorry, I never use sqlite3, think you may have to create a table for > it to think it''s a valid database? I really don''t know, but try doing > this in the clientconfigs.sqlite3 file: > CREATE TABLE test(test INT);Nope, didn''t work. I also just tried executing the create table statement I got on the error above, and now am getting: Could not retrieve catalog: Puppet::Parser::Compiler failed with error ActiveRecord::StatementInvalid: ActiveRecord::StatementInvalid> > Personally I''d use mysql though. ;)Yeah, I''m coming around to that conclusion too. Thanks. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com To unsubscribe from this group, send email to puppet-users-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en -~----------~----~----~----~------~----~------~--~---
Hi>> Personally I''d use mysql though. ;) > > Yeah, I''m coming around to that conclusion too. Thanks.with an certain amount of hosts and data sqlite is getting really slow. I think the general recommendation is to use a "real DBMS". greets pete --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com To unsubscribe from this group, send email to puppet-users-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en -~----------~----~----~----~------~----~------~--~---
On Sun, Mar 30, 2008 at 09:51:53PM -0700, scaldwell wrote:> Could not retrieve catalog: Puppet::Parser::Compiler failed with error > ActiveRecord::StatementInvalid: ActiveRecord::StatementInvalidCould this be a permissions error? Dean -- Dean Wilson http://www.unixdaemon.net Profanity is the one language all programmers understand --- Anon --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com To unsubscribe from this group, send email to puppet-users-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en -~----------~----~----~----~------~----~------~--~---
On Mar 31, 5:02 am, Dean Wilson <dwil...@unixdaemon.net> wrote:> On Sun, Mar 30, 2008 at 09:51:53PM -0700, scaldwell wrote: > > Could not retrieve catalog: Puppet::Parser::Compiler failed with error > > ActiveRecord::StatementInvalid: ActiveRecord::StatementInvalid > > Could this be a permissions error? >doubtful - the new sqlite file has the same permissions as the old one. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com To unsubscribe from this group, send email to puppet-users-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en -~----------~----~----~----~------~----~------~--~---