Chef 11 -- postgreql and erchef api


#1

hi chefs

Has anyone configured OSC 11 with ErChef and Postgres on different hosts?
I’ve managed to get them installed on separate hosts, but now i’m running
into some db connection problems…

i’m not a postgresql wizard, but for remote auth don’t i need to configure
pg_ident?

gist of the postgres log and configurations

https://gist.github.com/mvam75/5595086


Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.


#2

Hi Chris,

On May 16, 2013, at 14:08 , Chris grocerylist@gmail.com wrote:

Has anyone configured OSC 11 with ErChef and Postgres on different hosts?
I’ve managed to get them installed on separate hosts, but now i’m running into some db connection problems…

i’m not a postgresql wizard, but for remote auth don’t i need to configure pg_ident?

gist of the postgres log and configurations

https://gist.github.com/mvam75/5595086

I haven’t run a setup as your are describing, but it should be possible. In your gist you did not provide the /etc/chef-server/chef-server.rb of your two servers. The way I would attempt this is:

Install chef-server via omnibus on both servers. Use the /etc/chef-server/chef-server.rb config file to disable all services except for postgresql on one. On the other, disable postgresql and adjust postgresql config (vip) to point at other box.

  • seth

#3

Hi Seth

That is a bit of a different setup then i tried. I tried to do one of the
nodes with bootstrap = off, which seems like a bad idea. Oh, and it seems
like pgsql auth was working and it ended up being auth with rabbit. i’m
assuming with boostrap off the user and vhost didnt get created.

On Tue, May 21, 2013 at 10:16 AM, Seth Falcon seth@opscode.com wrote:

Hi Chris,

On May 16, 2013, at 14:08 , Chris grocerylist@gmail.com wrote:

Has anyone configured OSC 11 with ErChef and Postgres on different hosts?
I’ve managed to get them installed on separate hosts, but now i’m
running into some db connection problems…

i’m not a postgresql wizard, but for remote auth don’t i need to
configure pg_ident?

gist of the postgres log and configurations

https://gist.github.com/mvam75/5595086

I haven’t run a setup as your are describing, but it should be possible.
In your gist you did not provide the /etc/chef-server/chef-server.rb of
your two servers. The way I would attempt this is:

Install chef-server via omnibus on both servers. Use the
/etc/chef-server/chef-server.rb config file to disable all services except
for postgresql on one. On the other, disable postgresql and adjust
postgresql config (vip) to point at other box.

  • seth


Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.