Hello, I just installed the latest version of puppet and puppetmaster on an up to date RHEL4 system. If I turn on ''storeconfigs'' on the puppetmaster server I get the following error: debug: Calling puppetmaster.getconfigerr: Could not retrieve configuration: Uncaught exception No such file to load -- sqlite3 in method puppetmaster.getconfig I have gems and rails installed from David Lutterkort''s yum repository. My sqlite rpms where build from source using the source RPMs from Fedora Core (sqlite-3.3.3-1.2). Is this problem with my sqlite or can someone reproduce this elsewhere? I tested it with a virtually blank site.pp and just storeconfigs turned on in my puppetd.conf file. This seems only relevant on the puppetmaster server, if the clients have the configuration option enabled it doesn''t make much of a difference. Thanks a bunch, R
On Nov 13, 2006, at 2:28 PM, RijilV wrote:> Hello, > > I just installed the latest version of puppet and puppetmaster on an > up to date RHEL4 system. If I turn on ''storeconfigs'' on the > puppetmaster server I get the following error: > > debug: Calling puppetmaster.getconfigerr: Could not retrieve > configuration: Uncaught exception No such file to load -- sqlite3 in > method puppetmaster.getconfigI seem to be getting an error, too, although not that one. I''m not actually using storeconfigs, and I was stupid enough not to do a real functional test on it. Are you using this in your configurations? Are you sure you have sqlite3 for ruby installed? Is anyone in a position to test this with MySQL to see if it''s a problem there, too?> I have gems and rails installed from David Lutterkort''s yum > repository. My sqlite rpms where build from source using the source > RPMs from Fedora Core (sqlite-3.3.3-1.2).Did you install the ruby bindings?> Is this problem with my sqlite or can someone reproduce this > elsewhere? I tested it with a virtually blank site.pp and just > storeconfigs turned on in my puppetd.conf file. This seems only > relevant on the puppetmaster server, if the clients have the > configuration option enabled it doesn''t make much of a difference.Yeah, the storeconfigs setting only ever affects the server. -- Luke Kanies http://madstop.com | http://reductivelabs.com | 615-594-8199
On Mon, Nov 13, 2006 at 12:28:57PM -0800, RijilV wrote:> puppetmaster server I get the following error: > > debug: Calling puppetmaster.getconfigerr: Could not retrieve > configuration: Uncaught exception No such file to load -- sqlite3 in > method puppetmaster.getconfigYou''re missing the Ruby sqlite3 bindings. You can probably use gem to install them ("gem install sqlite3") or there might be a package for your distribution of choice. - Matt -- I told [my daughter] that if I see her digging a hole that she might not be able to crawl out of, my job isn''t to stand back and say "That''s a *real* nice hole you''re digging there". -- Paul Tomblin, ASR
On Mon, 2006-11-13 at 12:28 -0800, RijilV wrote:> I have gems and rails installed from David Lutterkort''s yum > repository. My sqlite rpms where build from source using the source > RPMs from Fedora Core (sqlite-3.3.3-1.2).You also need to rebuild ruby-sqlite3 (the ruby bindings) from Fedora Core. David
On 11/13/06, David Lutterkort <dlutter@redhat.com> wrote:> On Mon, 2006-11-13 at 12:28 -0800, RijilV wrote: > > I have gems and rails installed from David Lutterkort''s yum > > repository. My sqlite rpms where build from source using the source > > RPMs from Fedora Core (sqlite-3.3.3-1.2). > > You also need to rebuild ruby-sqlite3 (the ruby bindings) from Fedora > Core. > > DavidHey thanks, that totally did the trick. I''m getting a new error, I suspect it''s the same one Luke referenced earlier: Luke:> I seem to be getting an error, too, although not that one....> Are you using this in your configurations?No, not using it currently in my configuration, I was just trying to break puppet and I do plan on using storeconfigs in the future. And while the problems I''m having right now could very well be linked to my ruby/sqlite ''install'' on this RHEL4 machine, I get a crash with storeconfigs and the following site.pp: node default { file { "/etc/issue": checksum => md5, owner => root, group => root, mode => 400, recurse => false, ensure => present, backup => false, source => "puppet://puppet/issue", } } To generate the error I connected with a remotehost, and puppetmaster will crash the next time a remotehost connects to it. notice: Starting Puppet server version 0.20.1info: Creating PID file to /var/run/puppet/puppetmasterd.pid debug: Allowing remotehost(149.101.1.101) trusted access to puppetmaster.getconfig debug: Our client is remote info: Found default in /etc/puppet/manifests/site.pp notice: Using default node for remotehost debug: Finishing transaction -606690168 with 0 changes err: /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/callbacks.rb:335:in `eval''/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract_adapter.rb:88:in `log''SQLite3::SQLException: SQL logic error or missing database: INSERT INTO rails_parameters ("name", "line", "value", "rails_resource_id", "file") VALUES(''recurse'', 7, NULL, 2, ''/etc/puppet/manifests/site.pp'') debug: Allowing remotehost(149.101.1.101) trusted access to puppetmaster.getconfig debug: Our client is remoteinfo: Found default in /etc/puppet/manifests/site.pp notice: Using default node for remotehost err: /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/callbacks.rb:335:in `eval''/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract_adapter.rb:88:in `log''SQLite3::SQLException: SQL logic error or missing database: INSERT INTO rails_parameters ("name", "line", "value", "rails_resource_id", "file") VALUES(''recurse'', 7, NULL, 2, ''/etc/puppet/manifests/site.pp'') *** glibc detected *** corrupted double-linked list: 0x099588f8 *** Aborted
On Nov 14, 2006, at 12:25 PM, RijilV wrote:> On 11/13/06, David Lutterkort <dlutter@redhat.com> wrote: >> > `eval''/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/ > active_record/connection_adapters/abstract_adapter.rb:88:in > `log''SQLite3::SQLException: SQL logic error or missing database:Have you created the sqlite database file? -Blake
So after some playing I got it working, I had to modify the database:
INSERT INTO rails_parameters ("name", "line",
"value",
"rails_resource_id", "file")
VALUES(''recurse'', 7, NULL, 2,
''/etc/puppet/manifests/site.pp'')
was generating an error, "value" could not be null. I changed this in
the database creation file to accept null as a value and thusfar
things are working.
On a side note, when I try to start puppetmasterd with --dbadapter
puppetmasterd complains about an invalid option.
.r''
On 11/14/06, Blake Barnett <shadoi@nanovoid.com>
wrote:> Have you created the sqlite database file?
>
> -Blake
> _______________________________________________
> Puppet-users mailing list
> Puppet-users@madstop.com
> https://mail.madstop.com/mailman/listinfo/puppet-users
>
On Nov 21, 2006, at 2:57 AM, RijilV wrote:> So after some playing I got it working, I had to modify the database: > > INSERT INTO rails_parameters ("name", "line", "value", > "rails_resource_id", "file") VALUES(''recurse'', 7, NULL, 2, > ''/etc/puppet/manifests/site.pp'') > > was generating an error, "value" could not be null. I changed this in > the database creation file to accept null as a value and thusfar > things are working.Yeah, I fixed this bug a few days before I left, but it''s only in trunk not in a released version.> On a side note, when I try to start puppetmasterd with --dbadapter > puppetmasterd complains about an invalid option.Hmmm. That definitely shouldn''t be the case. Can you file that as a bug? -- Luke Kanies http://madstop.com | http://reductivelabs.com | 615-594-8199