Gehel has submitted this change and it was merged. (
https://gerrit.wikimedia.org/r/329328 )
Change subject: postgresql: Only set user password if different
......................................................................
postgresql: Only set user password if different
Change-Id: I7c74cca5e978ab9d6073e1d2d5c028e7c072d3d1
---
M modules/postgresql/manifests/user.pp
1 file changed, 4 insertions(+), 7 deletions(-)
Approvals:
Alexandros Kosiaris: Looks good to me, but someone else must approve
jenkins-bot: Verified
Gehel: Looks good to me, approved
diff --git a/modules/postgresql/manifests/user.pp
b/modules/postgresql/manifests/user.pp
index ab6e75a..d704f59 100644
--- a/modules/postgresql/manifests/user.pp
+++ b/modules/postgresql/manifests/user.pp
@@ -58,18 +58,15 @@
user => 'postgres',
unless => $userexists,
}
- # This will set the password and attributes on every puppet run. We
explicitly dont
- # depend on anything to ensure consistency with configuration and that
- # password is always the one defined
- # NOTE: This has the potential of the password leaking by process
- # listing tools like ps. Need to investigate better ways of setting the
- # password .e.g. hashed with md5 in the manifest
+
# This will not be run on a slave as it is read-only
if $master {
+ $password_md5 = md5("${password}${user}")
+
exec { "pass_set-${name}":
command => $pass_set,
user => 'postgres',
- onlyif => $userexists,
+ onlyif => "/usr/bin/test -n \"\$(/usr/bin/psql -Atc
\"SELECT 1 FROM pg_shadow WHERE usename = '${user}' AND passwd <>
'md5${password_md5}';\")\"",
subscribe => Exec["create_user-${name}"],
}
}
--
To view, visit https://gerrit.wikimedia.org/r/329328
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I7c74cca5e978ab9d6073e1d2d5c028e7c072d3d1
Gerrit-PatchSet: 5
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Tim Landscheidt <[email protected]>
Gerrit-Reviewer: Alexandros Kosiaris <[email protected]>
Gerrit-Reviewer: Filippo Giunchedi <[email protected]>
Gerrit-Reviewer: Gehel <[email protected]>
Gerrit-Reviewer: MaxSem <[email protected]>
Gerrit-Reviewer: Tim Landscheidt <[email protected]>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
