zarb-ml/mageia-sysadm/2010-December/001285.html


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
 <HEAD>
   <TITLE> [Mageia-sysadm] [646] - do not include password on command line,	but use a environnement
   </TITLE>
   <LINK REL="Index" HREF="index.html" >
   <LINK REL="made" HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20%5B646%5D%20-%20do%20not%20include%20password%20on%20command%20line%2C%0A%09but%20use%20a%20environnement&In-Reply-To=%3C20101217014521.69A2140469%40valstar.mageia.org%3E">
   <META NAME="robots" CONTENT="index,nofollow">
   <META http-equiv="Content-Type" content="text/html; charset=us-ascii">
   <LINK REL="Previous"  HREF="001284.html">
   <LINK REL="Next"  HREF="001286.html">
 </HEAD>
 <BODY BGCOLOR="#ffffff">
   <H1>[Mageia-sysadm] [646] - do not include password on command line,	but use a environnement</H1>
    <B>root at mageia.org</B> 
    <A HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20%5B646%5D%20-%20do%20not%20include%20password%20on%20command%20line%2C%0A%09but%20use%20a%20environnement&In-Reply-To=%3C20101217014521.69A2140469%40valstar.mageia.org%3E"
       TITLE="[Mageia-sysadm] [646] - do not include password on command line,	but use a environnement">root at mageia.org
       </A><BR>
    <I>Fri Dec 17 02:45:21 CET 2010</I>
    <P><UL>
        <LI>Previous message: <A HREF="001284.html">[Mageia-sysadm] Puppet Report for alamut.mageia.org
</A></li>
        <LI>Next message: <A HREF="001286.html">[Mageia-sysadm] [179] remove inexistant attribute
</A></li>
         <LI> <B>Messages sorted by:</B> 
              <a href="date.html#1285">[ date ]</a>
              <a href="thread.html#1285">[ thread ]</a>
              <a href="subject.html#1285">[ subject ]</a>
              <a href="author.html#1285">[ author ]</a>
         </LI>
       </UL>
    <HR>  
<!--beginarticle-->
<PRE>Revision: 646
Author:   misc
Date:     2010-12-17 02:45:21 +0100 (Fri, 17 Dec 2010)
Log Message:
-----------
- do not include password on command line, but use a environnement
  variable, so we avoid password leak on the mailling list

Modified Paths:
--------------
    puppet/modules/postgresql/manifests/init.pp

Modified: puppet/modules/postgresql/manifests/init.pp
===================================================================
--- puppet/modules/postgresql/manifests/init.pp	2010-12-17 00:50:58 UTC (rev 645)
+++ puppet/modules/postgresql/manifests/init.pp	2010-12-17 01:45:21 UTC (rev 646)
@@ -91,10 +91,11 @@
     }
 
     define user($password) {
-        $sql = &quot;CREATE ROLE $name ENCRYPTED PASSWORD '$password' NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN;&quot;
+        $sql = &quot;CREATE ROLE $name ENCRYPTED PASSWORD '\$pass' NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN;&quot;
 
         exec { &quot;psql -U postgres -c \&quot;$sql\&quot; &quot;:
             user =&gt; root,
+            environment =&gt; &quot;pass=$password&quot;, 
             unless =&gt; &quot;psql -A -t -U postgres -c '\du $name' | grep '$name'&quot;,
         }
     }
-------------- next part --------------
An HTML attachment was scrubbed...
URL: &lt;/pipermail/mageia-sysadm/attachments/20101217/ee21d61a/attachment.html&gt;
</PRE>


<!--endarticle-->
    <HR>
    <P><UL>
        <!--threads-->
	<LI>Previous message: <A HREF="001284.html">[Mageia-sysadm] Puppet Report for alamut.mageia.org
</A></li>
	<LI>Next message: <A HREF="001286.html">[Mageia-sysadm] [179] remove inexistant attribute
</A></li>
         <LI> <B>Messages sorted by:</B> 
              <a href="date.html#1285">[ date ]</a>
              <a href="thread.html#1285">[ thread ]</a>
              <a href="subject.html#1285">[ subject ]</a>
              <a href="author.html#1285">[ author ]</a>
         </LI>
       </UL>

<hr>
<a href="https://www.mageia.org/mailman/listinfo/mageia-sysadm">More information about the Mageia-sysadm
mailing list</a><br>
</body></html>