Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

new postgresql instance #91

Closed
PHaroZ opened this issue May 25, 2015 · 6 comments
Closed

new postgresql instance #91

PHaroZ opened this issue May 25, 2015 · 6 comments
Labels
Milestone

Comments

@PHaroZ
Copy link

@PHaroZ PHaroZ commented May 25, 2015

puppetlabs/postgresql v4.3.0
wdijkerman/zabbix v1.4.0

Creation of a new postgresql instance fail with following message :

Notice: /Stage[main]/Zabbix::Database/Postgresql::Server::Db[zabbix_server]/Postgresql::Server::Database[zabbix_server]/Exec[/usr/lib/postgresql/9.1/bin/createdb --port='5432' --owner='' --template=template0  'zabbix_server']/returns:                                               ^
Error: /Stage[main]/Zabbix::Database/Postgresql::Server::Db[zabbix_server]/Postgresql::Server::Database[zabbix_server]/Exec[/usr/lib/postgresql/9.1/bin/createdb --port='5432' --owner='' --template=template0  'zabbix_server']: Failed to call refresh: /usr/lib/postgresql/9.1/bin/createdb --port='5432' --owner='' --template=template0  'zabbix_server' returned 1 instead of one of [0]
Error: /Stage[main]/Zabbix::Database/Postgresql::Server::Db[zabbix_server]/Postgresql::Server::Database[zabbix_server]/Exec[/usr/lib/postgresql/9.1/bin/createdb --port='5432' --owner='' --template=template0  'zabbix_server']: /usr/lib/postgresql/9.1/bin/createdb --port='5432' --owner='' --template=template0  'zabbix_server' returned 1 instead of one of [0]

This is due to --owner=''.

To avoid this I edit manifests/database.pp:130 to change

        postgresql::server::db { $database_name:
          user     => $database_user,
          password => postgresql_password($database_user, $database_password),
          require  => Class['postgresql::server'],
        }

to

        postgresql::server::db { $database_name:
          user     => $database_user,
          owner    => $database_user,
          password => postgresql_password($database_user, $database_password),
          require  => Class['postgresql::server'],
        }

And thanks for your job ;)

@dj-wasabi

This comment has been minimized.

Copy link
Collaborator

@dj-wasabi dj-wasabi commented May 25, 2015

Hi PHaroZ,

Thank you for making time to create and investigate this issue. I'll take a look at it and let you know when this is fixed.

Kind regards,
Werner

@dj-wasabi dj-wasabi added this to the 1.5.0 milestone May 25, 2015
dj-wasabi pushed a commit that referenced this issue May 28, 2015
@dj-wasabi

This comment has been minimized.

Copy link
Collaborator

@dj-wasabi dj-wasabi commented Jun 2, 2015

Hi,

I pushed an fix for this. Please let me know if you have any issues.

Kind regards,
Werner

@PHaroZ

This comment has been minimized.

Copy link
Author

@PHaroZ PHaroZ commented Jun 3, 2015

please could you say me how I can test your fix while it's not released in https://forge.puppetlabs.com (I've installed modules with puppet module install).
thx

@dj-wasabi

This comment has been minimized.

Copy link
Collaborator

@dj-wasabi dj-wasabi commented Jun 3, 2015

Hi @PHaroZ

You can clone this git repository on the puppet master. Or you have to wait till I release it on the forge. Don't know when I release it, but I only added the "owner => $database_user," line.

Kind regards,
Werner

@dj-wasabi

This comment has been minimized.

Copy link
Collaborator

@dj-wasabi dj-wasabi commented Jun 8, 2015

Hi @PHaroZ

I just uploaded the new release (1.5.0) to the forge.

Kind regards,
Werner

@PHaroZ

This comment has been minimized.

Copy link
Author

@PHaroZ PHaroZ commented Jun 10, 2015

thank you, i'll test that !

@PHaroZ PHaroZ closed this Jun 10, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.