[prev in list] [next in list] [prev in thread] [next in thread]
List: spacewalk-list
Subject: [Spacewalk-list] Installing Spacewalk 2.10 in AWS using Postgres RDS
From: David Giordano <David.Giordano () synchronoss ! com>
Date: 2020-04-28 19:07:35
Message-ID: 88C2EAC2-DB59-49F7-A0A4-8D7EC826DC69 () synchronoss ! com
[Download RAW message or body]
[Attachment #2 (text/plain)]
Hello Spacewalk Community,
We are currently attempting to get the latest, stable version of Spacewalk installed \
in AWS using a Postgres RDS backend.
Wondering if anyone out there on the Net has ever gotten this to work? I did some \
googling around and I have seen some attempts but never a full, successful install.
Our current hurdle is when we go to run this command on the DB:
(As per: https://github.com/spacewalkproject/spacewalk/wiki/PostgreSQLServerSetup)
postgres=> create language pltclu;
ERROR: must be superuser to create procedural language "pltclu"
We get the above error.
So, obviously, the user AWS created on the DB doesn't have the proper permissions to \
install the untrusted version of this language. I read that the superuser in AWS has \
a limited set of privileges and this is what we are seeing as well. A colleague \
suggested we rather try the other, trusted version of TCL called pltcl. I have some \
reservations about a deviation from the specs but does anyone know if this will work? \
It installed it fine:
postgres=> create language pltcl;
CREATE LANGUAGE
postgres=> select * from pg_language;
lanname | lanowner | lanispl | lanpltrusted | lanplcallfoid | laninline | \
lanvalidator | lanacl
----------+----------+---------+--------------+---------------+-----------+--------------+--------
internal | 10 | f | f | 0 | 0 | \
2246 | c | 10 | f | f | 0 | 0 | \
2247 | sql | 10 | f | t | 0 | 0 | \
2248 | plpgsql | 10 | t | t | 13309 | 13310 | \
13311 | pltcl | 16393 | t | t | 74855 | 0 | \
0 | (5 rows)
Thank you,
Jg
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Hello Spacewalk \
Community,<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="font-size:11.0pt"><o:p> </o:p></span></p> <p class="MsoNormal"><span \
style="font-size:11.0pt">We are currently attempting to get the latest, stable \
version of Spacewalk installed in AWS using a Postgres RDS \
backend.<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="font-size:11.0pt"><o:p> </o:p></span></p> <p class="MsoNormal"><span \
style="font-size:11.0pt">Wondering if anyone out there on the Net has ever gotten \
this to work? I did some googling around and I have seen some attempts but \
never a full, successful install.<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="font-size:11.0pt"><o:p> </o:p></span></p> <p class="MsoNormal"><span \
style="font-size:11.0pt">Our current hurdle is when we go to run this command on the \
DB:<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="font-size:11.0pt"><o:p> </o:p></span></p> <p class="MsoNormal"><span \
style="font-size:11.0pt">(As per: </span><a \
href="https://github.com/spacewalkproject/spacewalk/wiki/PostgreSQLServerSetup">https: \
//github.com/spacewalkproject/spacewalk/wiki/PostgreSQLServerSetup</a>)<o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Courier \
New";color:#1F497D">postgres=> create language pltclu;</span><span \
style="font-size:11.0pt;color:black"><o:p></o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt;font-family:"Courier \
New";color:#1F497D">ERROR: must be superuser to create procedural language \
"pltclu"</span><span \
style="font-size:11.0pt;color:black"><o:p></o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt">We get the above \
error.<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="font-size:11.0pt"><o:p> </o:p></span></p> <p class="MsoNormal"><span \
style="font-size:11.0pt">So, obviously, the user AWS created on the DB doesn't have \
the proper permissions to install the untrusted version of this language. I \
read that the superuser in AWS has a limited set of privileges and this is what we \
are seeing as well. A colleague suggested we rather try the other, trusted \
version of TCL called pltcl. I have some reservations about a deviation from \
the specs but does anyone know if this will work? It installed it \
fine:<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="font-size:11.0pt"><o:p> </o:p></span></p> <p class="MsoNormal"><span \
style="font-size:11.0pt;font-family:"Courier \
New";color:#1F497D">postgres=> create language <span \
style="background:yellow">pltcl</span>;</span><span \
style="font-size:11.0pt;color:black"><o:p></o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt;font-family:"Courier \
New";color:#1F497D">CREATE LANGUAGE</span><span \
style="font-size:11.0pt;color:black"><o:p></o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt;font-family:"Courier \
New";color:#1F497D"> </span><span \
style="font-size:11.0pt;color:black"><o:p></o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt;font-family:"Courier \
New";color:#1F497D">postgres=> select * from pg_language;</span><span \
style="font-size:11.0pt;color:black"><o:p></o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt;font-family:"Courier \
New";color:#1F497D">lanname | lanowner | lanispl | lanpltrusted | \
lanplcallfoid | laninline | lanvalidator | lanacl</span><span \
style="font-size:11.0pt;color:black"><o:p></o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt;font-family:"Courier \
New";color:#1F497D">----------+----------+---------+--------------+---------------+-----------+--------------+--------</span><span \
style="font-size:11.0pt;color:black"><o:p></o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt;font-family:"Courier \
New";color:#1F497D">internal | 10 | \
f | \
f \
| 0 \
| 0 \
| 2246 |</span><span \
style="font-size:11.0pt;color:black"><o:p></o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt;font-family:"Courier \
New";color:#1F497D">c \
| 10 | f | \
f \
| 0 \
| 0 \
| 2247 |</span><span \
style="font-size:11.0pt;color:black"><o:p></o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt;font-family:"Courier \
New";color:#1F497D">sql | \
10 | f | \
t \
| 0 \
| 0 \
| 2248 |</span><span \
style="font-size:11.0pt;color:black"><o:p></o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt;font-family:"Courier \
New";color:#1F497D">plpgsql | 10 | \
t | \
t \
| 13309 | \
13310 | 13311 |</span><span \
style="font-size:11.0pt;color:black"><o:p></o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt;font-family:"Courier \
New";color:#1F497D;background:yellow">pltcl \
| 16393 | t | \
t \
| 74855 \
| 0 \
| 0 |</span><span \
style="font-size:11.0pt;color:black"><o:p></o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt;font-family:"Courier \
New";color:#1F497D">(5 rows)</span><span \
style="font-size:11.0pt;color:black"><o:p></o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt">Thank you,<o:p></o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt">Jg<o:p></o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p> <p \
class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p> </div>
</body>
</html>
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
--===============0865778130139789054==--
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic