> I figured out the issue with the embedded database. For some reason letting > the system default to ::cert for the “ssl_listen_address” had it binding to > localhost instead of the actual interface it should have. Specifying > “0.0.0.0” for that option made puppetdb work just fine when using the > embedded database. It still does not add the firewall rules in though- I’m > doing that myself. > > Going back to postgres still results in the same failure. Since it’s related > to the validation script I thought I would run it manually to see what > happens- > >> root@puppetdb01:/var/log# /usr/local/bin/validate_postgresql_connection.sh >> 2 10 '/usr/bin/psql --tuples-only --quiet -h localhost -U puppetdb -p >> 5432 --dbname puppetdb ' > > The result is that the script hangs while waiting for the user to put a > password in. > > Both machines are running Ubuntu 14.04 LTS. I am using Puppet 3.7.5 from the > PuppetLabs repository. This is on a VMWare ESXI box. > > I’m using a PuppetFile with librarian-puppet. Although the puppetdb machine > is new, and is a “plank role” so to speak, it does include other modules as > there are other services which are up and running. This is the first time > I’ve used the postgres module (it’s not being used by other nodes) so there > shouldn’t be any issues with conflicts. That being said, I did have to push > through a change to postgres to allow it to use the puppet labs apt-module, > since the puppet labs team have not managed to keep all their module > dependencies in sync. You can see the pull request I made for that here- > https://github.com/puppetlabs/puppetlabs-postgresql/pull/632/files
Okay, I think this is enough to start with, thanks Rob. I'm going to get something working now to try and reproduce, I'm in the UK though so I may end up going to bed before I get it going and respond, otherwise I'll pick it up again tomorrow. I suspect its because of Ubuntu 14.04, which we don't have automated tests for yet ... and we've got a bug we haven't noticed. At least this wouldn't surprise me. You definitely want to prefer PostgreSQL over embedded btw, so this is the correct direction to follow. Sorry about all the hassles again mate :-). ken. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/CAE4bNTmjkPr9mcsXF3%2BWHbbmaPRfDC37YehCY0SRbRFxM5zkZQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
