Re: [Puppet Users] Stored configs in MySQL

2011-02-10 Thread Joe McDonagh
Sounds like you're running the wrong version of the mysql rubygem. If 
memory serves, this was a known issue.


--
Joe McDonagh
AIM: YoosingYoonickz
IRC: joe-mac on freenode
L'ennui est contre-révolutionnaire

--
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+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/puppet-users?hl=en.



[Puppet Users] Stored configs in MySQL

2011-02-10 Thread Jonathan Gazeley

Hi all,

I've been looking at using stored configs to generate my Nagios configs. 
I followed this guide[1] to set up the remote MySQL database for this 
purpose, like this:


[puppetmasterd]
storeconfigs = true
dbadapter = mysql
dbuser = puppet
dbpassword = password
dbserver = mydb.bris.ac.uk
#dbsocket = /var/run/mysqld/mysqld.sock

Trouble is, each time a node checks into puppet, a new db handle is 
opened without the old one being closed. With a few nodes, it doesn't 
take long before there are tens or hundreds of handles, and the db 
server won't accept any more.


This is Bad, since many other things rely on that database, and when it 
stops accepting more connections, things break.


So, does anyone know how I can make puppet open just one connection and 
keep it persistently?


Thanks,
Jonathan

[1] 
http://projects.puppetlabs.com/projects/puppet/wiki/Using_Stored_Configuration

--

Jonathan Gazeley
Systems Support Specialist
ResNet | Wireless & VPN Team
IT Services
University of Bristol


--
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+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/puppet-users?hl=en.