I have asked this question over at ask.puppet.com, but there has been no
response at all.
I did notice that there is a very old thread about this problem, but there
was never any solution posted.
I'm hoping that Ken Barber is still on this list and can remember if he was
able to help resolve this issue.
System info:
*OS:* CentOS 6.7
*Puppet Version:* 4.5.0
*Postgres Version:* 9.4
*Puppetlabs-Postgres Module Version:* v4.7.1
*Module Config:* Listed Below
*Configration Notes:* Postgress is running on the same host as the
puppetdb. There is no need for me to open the Postgres port to the internet
for remote access.
I have been trying to get the puppetlabs-postgres module running, but I
can't seem to get the *validate_postgresql_connection.sh* to complete. From
what I can see it runs this validation test, but Postgress replies with a
password request and the script times out. I did see some mention of this
issue in the puppet-users Google group back in mid 2015, but there was no
resolution to the issue posted there.
I took a look at the *validate_postgresql_connection.sh* script, and its
pretty simple with no space for a password to be passed to it.
Here I'm my module configuration:
# postgresql
############
$postgres_version = '9.4'
$postgres_package = '94'
class { 'postgresql::globals':
version => "${postgres_version}",
bindir => '/usr/bin',
confdir => "/var/lib/pgsql/${postgres_version}/data",
}
class { 'postgresql::server':
#postgres_password => 'PASSWORD1',
manage_pg_hba_conf => true,
service_restart_on_change => true,
package_ensure => true,
datadir => "/var/lib/pgsql/${postgres_version}/data",
package_name => "postgresql${postgres_package}-server",
client_package_name => "postgresql${postgres_package}",
service_name => "postgresql-${postgres_version}",
service_status => "service postgresql-${postgres_version}
status",
service_reload => "service postgresql-${postgres_version}
reload",
pg_hba_conf_defaults => false,
}
class { 'postgresql::server::contrib':
package_ensure => 'present',
package_name => "postgresql${postgres_package}-contrib",
}
postgresql::server::pg_hba_rule { 'local_access_postgres':
type => 'local',
database => 'all',
user => 'postgres',
auth_method => 'peer',
}
postgresql::server::pg_hba_rule { 'local_access_puppetdb':
type => 'local',
database => 'puppetdb',
user => 'puppetdb',
auth_method => 'peer',
}
postgresql::validate_db_connection { 'validate_local_puppetd_connection':
database_host => 'localhost',
database_name => 'puppetdb',
database_username => 'puppetdb',
database_port => '5432',
run_as => 'puppetdb',
database_password => 'PASSWORD2',
}
and here is the debugging output...
Debug: Executing: 'service postgresql-9.4 status'
Debug: Executing: '/sbin/chkconfig postgresql-9.4'
Debug: Exec[validate postgres connection for
@:5432/postgres](provider=posix): Executing check
'/usr/local/bin/validate_postgresql_connection.sh 1 60 '/usr/bin/psql
--tuples-only --quiet -p 5432 --dbname postgres ''
Debug: Executing with uid=postgres:
'/usr/local/bin/validate_postgresql_connection.sh 1 60 '/usr/bin/psql
--tuples-only --quiet -p 5432 --dbname postgres ''
Debug:
/Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate
postgres connection for @:5432/postgres]/unless: 1
Debug:
/Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate
postgres connection for @:5432/postgres]/unless: Password:
Debug:
/Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate
postgres connection for @:5432/postgres]/unless: psql: FATAL: password
authentication failed for user "postgres"
... *snip* 8< ...
Debug:
/Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate
postgres connection for @:5432/postgres]/unless: psql: FATAL: password
authentication failed for user "postgres"
Debug:
/Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate
postgres connection for @:5432/postgres]/unless: 60
Debug:
/Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate
postgres connection for @:5432/postgres]/unless: sleeping
Debug:
/Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate
postgres connection for @:5432/postgres]/unless: Password:
Debug:
/Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate
postgres connection for @:5432/postgres]/unless: psql: FATAL: password
authentication failed for user "postgres"
Debug:
/Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate
postgres connection for @:5432/postgres]/unless: Unable to connect to
postgresql
Debug: Exec[validate postgres connection for
@:5432/postgres](provider=posix): Executing 'echo 'Unable to connect to
defined database using: /usr/bin/psql --tuples-only --quiet -p 5432
--dbname postgres ' && false'
Debug: Executing with uid=postgres: 'echo 'Unable to connect to defined
database using: /usr/bin/psql --tuples-only --quiet -p 5432 --dbname
postgres ' && false'
Notice:
/Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate
postgres connection for @:5432/postgres]/returns: Unable to connect to
defined database using: /usr/bin/psql --tuples-only --quiet -p 5432
--dbname postgres
Error: echo 'Unable to connect to defined database using: /usr/bin/psql
--tuples-only --quiet -p 5432 --dbname postgres ' && false returned 1
instead of one of [0]
Error:
/Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate
postgres connection for @:5432/postgres]/returns: change from notrun to 0
failed: echo 'Unable to connect to defined database using: /usr/bin/psql
--tuples-only --quiet -p 5432 --dbname postgres ' && false returned 1
instead of one of [0]
Debug: Postgresql::Validate_db_connection[validate_service_is_running]:
Resource is being skipped, unscheduling all events
Any help would be greatly appreciated
--
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 puppet-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/af44a569-a7eb-4370-b4b8-cf8a1a0ac2db%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
