Re: [pe-users] MySQL and PuppetDB

[Daniel Pittman]

On Mon, Sep 24, 2012 at 3:03 PM, Stuart Cracraft <smcra...@me.com> wrote:
>
> Anyone know how to resolve this mysql
> issue in the log below?

Something is wrong with your RVM built Ruby - it doesn't have the
'psych' library for YAML support. That isn't the root cause of the
problem, but it will totally mess you up later, so you should fix
that.

The MySQL problem looks like it can't find the OpenSSL headers or
development libraries on your system. You should install those; more
details are hidden, as the system notes, in the `mkmf.log` for the
MySQL gem. I don't recall where RVM hides those by default, but you
should hopefully be able to dig it out of the RVM reference.

Finally, I wouldn't recommend using Ruby 1.9 with a Puppet 2.7
release. There is some support in there, but it generally isn't a
great idea. Better to stick with Ruby 1.8.7 for the moment. (When
Telly releases using 1.9.3-p125 or later should be pretty solid. :)

> On a related note, can PuppetDB be substituted for mysql and if so how?

Yes and no: PuppetDB can replace the built-in ActiveRecord based
StoreConfigs, which are the only thing you need the Ruby MySQL
bindings for.

PuppetDB has an internal database, or can use an external PostgreSQL
database for extra performance.

So, you should be able to run up PuppetDB and replace the use of MySQL
with it. If the internal database is too slow you can upgrade by
installing an external PostgreSQL server and using that for PuppetDB
data.

--
Daniel Pittman
⎋ Puppet Labs Developer – http://puppetlabs.com
♲ Made with 100 percent post-consumer electrons

[Daniel Pittman]

On Mon, Sep 24, 2012 at 7:37 PM, Stuart Cracraft <smcra...@me.com> wrote:
> Notes with ++

>
>> Something is wrong with your RVM built Ruby - it doesn't have the
>> 'psych' library for YAML support. That isn't the root cause of the
>> problem, but it will totally mess you up later, so you should fix
>> that.
>

> ++ Thanks. Have installed YAML and Psych at last.

>
>> The MySQL problem looks like it can't find the OpenSSL headers or
>> development libraries on your system.
>

> ++ What is a reputable site to obtain these at for Redhat 5/6? Can you share the paths to the rpms or tarballs?

They should be available as part of the core RedHat software distribution.