Hi all, i'' m trying to configure puppet to use rails with postgresql. I'' m having troubles to make it work. Got no error when running puppetmasterd but nothing is being populated in the DB. Is anybody using puppet with postgres ? my config (in puppet.conf) [rails] dbadapter = postgresql dbname = mydb dbserver = localhost dbuser = user dbpassword = password _______________________________________________ Puppet-users mailing list Puppet-users@madstop.com https://mail.madstop.com/mailman/listinfo/puppet-users
chems zair wrote:> Hi all, > > i'' m trying to configure puppet to use rails with postgresql. I'' m > having troubles to make it work. Got no error when running > puppetmasterd but nothing is being populated in the DB. Is anybody using > puppet with postgres ? > > my config (in puppet.conf) > > [rails] > dbadapter = postgresql > dbname = mydb > dbserver = localhost > dbuser = user > dbpassword = passwordAssuming that those credentials are valid for the database (I would imagine that if they''re not an error would be generated, but it''s worth checking), here''s some other db related options that I have in my working setup: # Whether to store each client''s configuration. This # requires ActiveRecord from Ruby on Rails. storeconfigs = true # Whether to automatically migrate the database. dbmigrate = true -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Senior Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC
Credentials are valid, because I can connect to the db using ActiveRecord. I found in previous emails somebody having the same pbm with mysql, Luke''s response was that this definition should not be in [rails] section !! http://mail.madstop.com/pipermail/puppet-users/2007-August/004039.html Any improvement of the wiki in this issue ?!!! Rgs, On Dec 23, 2007 1:04 AM, Frank Sweetser <fs@wpi.edu> wrote:> chems zair wrote: > > Hi all, > > > > i'' m trying to configure puppet to use rails with postgresql. I'' m > > having troubles to make it work. Got no error when running > > puppetmasterd but nothing is being populated in the DB. Is anybody using > > puppet with postgres ? > > > > my config (in puppet.conf) > > > > [rails] > > dbadapter = postgresql > > dbname = mydb > > dbserver = localhost > > dbuser = user > > dbpassword = password > > Assuming that those credentials are valid for the database (I would > imagine > that if they''re not an error would be generated, but it''s worth checking), > here''s some other db related options that I have in my working setup: > > # Whether to store each client''s configuration. This > # requires ActiveRecord from Ruby on Rails. > storeconfigs = true > > # Whether to automatically migrate the database. > dbmigrate = true > > > -- > Frank Sweetser fs at wpi.edu | For every problem, there is a solution > that > WPI Senior Network Engineer | is simple, elegant, and wrong. - HL > Mencken > GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC > _______________________________________________ > Puppet-users mailing list > Puppet-users@madstop.com > https://mail.madstop.com/mailman/listinfo/puppet-users >_______________________________________________ Puppet-users mailing list Puppet-users@madstop.com https://mail.madstop.com/mailman/listinfo/puppet-users
On Dec 23, 2007, at 2:12 AM, chems zair wrote:> Credentials are valid, because I can connect to the db using > ActiveRecord. > I found in previous emails somebody having the same pbm with mysql, > Luke''s response > was that this definition should not be in [rails] section !! > http://mail.madstop.com/pipermail/puppet-users/2007-August/004039.html > > Any improvement of the wiki in this issue ?!!!The ConfigurationReference no longer makes any reference to sections, so yeah, I guess it is. -- There is nothing worse than aggressive stupidity. -- Johann Wolfgang von Goethe --------------------------------------------------------------------- Luke Kanies | http://reductivelabs.com | http://madstop.com
Upgrading to the 0.24.1 version did not fix the problem. Now I have only one
section puppetmasterd
in my puppet.conf, so now even sqlite is not working!!
#cat /etc/puppet/puppet.conf
[main]
# Where Puppet stores dynamic and growing data.
# The default value is ''/var/puppet''.
vardir = /var/lib/puppet
statedir = $vardir/state
# The Puppet log directory.
# The default value is ''$vardir/log''.
logdir = /var/log/puppet
# Where Puppet PID files are kept.
# The default value is ''$vardir/run''.
rundir = /var/run/puppet
# Where SSL certificates are kept.
# The default value is ''$confdir/ssl''.
ssldir = $vardir/ssl
[puppetmasterd]
storeconfigs = true
reports = store
dblocation = $statedir/clientconfigs.sqlite3
dbname = puppet
dbpassword = puppet
rails_loglevel = info
dbadapter = sqlite3
dbserver = localhost
dbmigrate = true
railslog = $logdir/rails.log
Also , I have the following error when I run puppetd -v -o from clients
err: Could not retrieve configuration: Settings[/etc/puppet/puppet.conf] is
already being managed
Any help ?
Rgs,
Chems
On Dec 23, 2007 4:11 PM, Luke Kanies <luke@madstop.com> wrote:
> On Dec 23, 2007, at 2:12 AM, chems zair wrote:
>
> > Credentials are valid, because I can connect to the db using
> > ActiveRecord.
> > I found in previous emails somebody having the same pbm with mysql,
> > Luke''s response
> > was that this definition should not be in [rails] section !!
> > http://mail.madstop.com/pipermail/puppet-users/2007-August/004039.html
> >
> > Any improvement of the wiki in this issue ?!!!
>
> The ConfigurationReference no longer makes any reference to sections,
> so yeah, I guess it is.
>
> --
> There is nothing worse than aggressive stupidity.
> -- Johann Wolfgang von Goethe
> ---------------------------------------------------------------------
> Luke Kanies | http://reductivelabs.com | http://madstop.com
>
>
> _______________________________________________
> Puppet-users mailing list
> Puppet-users@madstop.com
> https://mail.madstop.com/mailman/listinfo/puppet-users
>
_______________________________________________
Puppet-users mailing list
Puppet-users@madstop.com
https://mail.madstop.com/mailman/listinfo/puppet-users
When I disable storeconfigs in puppetmasterd then everything works fine. On Dec 23, 2007 6:02 PM, chems zair <chzair@gmail.com> wrote:> Upgrading to the 0.24.1 version did not fix the problem. Now I have only > one section puppetmasterd > in my puppet.conf, so now even sqlite is not working!! > > #cat /etc/puppet/puppet.conf > [main] > # Where Puppet stores dynamic and growing data. > # The default value is ''/var/puppet''. > vardir = /var/lib/puppet > statedir = $vardir/state > # The Puppet log directory. > # The default value is ''$vardir/log''. > logdir = /var/log/puppet > > # Where Puppet PID files are kept. > # The default value is ''$vardir/run''. > rundir = /var/run/puppet > > # Where SSL certificates are kept. > # The default value is ''$confdir/ssl''. > ssldir = $vardir/ssl > > [puppetmasterd] > storeconfigs = true > reports = store > dblocation = $statedir/clientconfigs.sqlite3 > dbname = puppet > dbpassword = puppet > rails_loglevel = info > dbadapter = sqlite3 > dbserver = localhost > dbmigrate = true > railslog = $logdir/rails.log > > Also , I have the following error when I run puppetd -v -o from clients > > err: Could not retrieve configuration: Settings[/etc/puppet/puppet.conf] > is already being managed > > Any help ? > > Rgs, > > Chems > > > On Dec 23, 2007 4:11 PM, Luke Kanies <luke@madstop.com> wrote: > > > On Dec 23, 2007, at 2:12 AM, chems zair wrote: > > > > > Credentials are valid, because I can connect to the db using > > > ActiveRecord. > > > I found in previous emails somebody having the same pbm with mysql, > > > Luke''s response > > > was that this definition should not be in [rails] section !! > > > http://mail.madstop.com/pipermail/puppet-users/2007-August/004039.html > > > > > > > > Any improvement of the wiki in this issue ?!!! > > > > The ConfigurationReference no longer makes any reference to sections, > > so yeah, I guess it is. > > > > -- > > There is nothing worse than aggressive stupidity. > > -- Johann Wolfgang von Goethe > > --------------------------------------------------------------------- > > Luke Kanies | http://reductivelabs.com | http://madstop.com > > > > > > _______________________________________________ > > Puppet-users mailing list > > Puppet-users@madstop.com > > https://mail.madstop.com/mailman/listinfo/puppet-users > > > >_______________________________________________ Puppet-users mailing list Puppet-users@madstop.com https://mail.madstop.com/mailman/listinfo/puppet-users
<Derek.Whayman@barclayscapital.com>
2007-Dec-24 09:50 UTC
Re: puppet with postgresql adapter
We based our PostgreSQL setup from David Lutterkort''s setup: http://mail.madstop.com/pipermail/puppet-users/2007-September/004459.htm l The attachment''s been scrubbed, but here it is again, attached. You may or may not want to ignore the Mongrel stuff for now. Cheers, Derek In the spirit of sharing, the attached tarball contains a puppet module that does most of the setup of a puppetmaster cluster with storeconfigs in a PostgreSQL database. To use, untar in some DIR and run puppet --modulepath $DIR/modules $DIR/modules/cluster/scripts/setup.pp The module contains code to setup the PostgreSQL databse, too, but IIRC that needs a small amount of love; otherwise, you''ll have to setup PostgreSQL manually. This is far from perfect, but I hope it''s a start. If there''s interest in this kind of thing, I''d like to hear about it, especially what people''s preferences on making modules like this available are. David ________________________________ From: puppet-users-bounces@madstop.com [mailto:puppet-users-bounces@madstop.com] On Behalf Of chems zair Sent: 22 December 2007 21:38 To: puppet-users@madstop.com Subject: [Puppet-users] puppet with postgresql adapter Hi all, i'' m trying to configure puppet to use rails with postgresql. I'' m having troubles to make it work. Got no error when running puppetmasterd but nothing is being populated in the DB. Is anybody using puppet with postgres ? my config (in puppet.conf) [rails] dbadapter = postgresql dbname = mydb dbserver = localhost dbuser = user dbpassword = password ------------------------------------------------------------------------ For important statutory and regulatory disclosures and more information about Barclays Capital, please visit our web site at http://www.barcap.com. Internet communications are not secure and therefore the Barclays Group does not accept legal responsibility for the contents of this message. Although the Barclays Group operates anti-virus programmes, it does not accept responsibility for any damage whatsoever that is caused by viruses being passed. Any views or opinions presented are solely those of the author and do not necessarily represent those of the Barclays Group. Replies to this email may be monitored by the Barclays Group for operational or business reasons. Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP. This email may relate to or be sent from other members of the Barclays Group. ------------------------------------------------------------------------ _______________________________________________ Puppet-users mailing list Puppet-users@madstop.com https://mail.madstop.com/mailman/listinfo/puppet-users
On Dec 23, 2007, at 11:02 AM, chems zair wrote:> Upgrading to the 0.24.1 version did not fix the problem. Now I have > only one section puppetmasterd > in my puppet.conf, so now even sqlite is not working!!I don''t understand -- this configuration change broke sqlite3 also? What about if you don''t set anything related to db on sqlite3? As to this working with ActiveRecord but not with Puppet, check lib/ puppet/rails.rb in the database_arguments method -- that should tell you exactly how I configure Rails, and you''ll see that I''m doing very little.> Also , I have the following error when I run puppetd -v -o from > clients > > err: Could not retrieve configuration: Settings[/etc/puppet/ > puppet.conf] is already being managedLooks like this is being discussed on another thread. -- When your work speaks for itself, don''t interrupt. -- Henry J. Kaiser --------------------------------------------------------------------- Luke Kanies | http://reductivelabs.com | http://madstop.com
the issue is with the new version (0.24.x). I downgrade to 0.23.2 and it works fine with sqlite3 and postgres. I will open a ticket for this issue. Tks Chems On Dec 28, 2007 2:08 AM, Luke Kanies <luke@madstop.com> wrote:> On Dec 23, 2007, at 11:02 AM, chems zair wrote: > > > Upgrading to the 0.24.1 version did not fix the problem. Now I have > > only one section puppetmasterd > > in my puppet.conf, so now even sqlite is not working!! > > I don''t understand -- this configuration change broke sqlite3 also? > What about if you don''t set anything related to db on sqlite3? > > As to this working with ActiveRecord but not with Puppet, check lib/ > puppet/rails.rb in the database_arguments method -- that should tell > you exactly how I configure Rails, and you''ll see that I''m doing very > little. > > > Also , I have the following error when I run puppetd -v -o from > > clients > > > > err: Could not retrieve configuration: Settings[/etc/puppet/ > > puppet.conf] is already being managed > > Looks like this is being discussed on another thread. > > > > -- > When your work speaks for itself, don''t interrupt. > -- Henry J. Kaiser > --------------------------------------------------------------------- > Luke Kanies | http://reductivelabs.com | http://madstop.com > > > _______________________________________________ > Puppet-users mailing list > Puppet-users@madstop.com > https://mail.madstop.com/mailman/listinfo/puppet-users >_______________________________________________ Puppet-users mailing list Puppet-users@madstop.com https://mail.madstop.com/mailman/listinfo/puppet-users