Re: unrecognized roll option "nocreateuser"

Peter Nikolaidis <[email protected]> Mon, 6 Mar 2017 17:11:52 -0500
Newsgroups gmane.comp.bug-tracking.request-tracker.user
Message-ID <CACiQX-o3G4fxrKBntuWX=8habACkaBOcVgnbuu4JsmMR-Sae0A@mail.gmail.com>
--===============0657745645==
Content-Type: multipart/alternative; boundary=94eb2c05a3ae2d3dbd054a17317d

--94eb2c05a3ae2d3dbd054a17317d
Content-Type: text/plain; charset=UTF-8

I found this string in:
/opt/rt4/etc/acl.Pg

Peter

On Mon, Mar 6, 2017 at 11:31 AM, BALLANTINE, JAMES W <[email protected]> wrote:

> I'm trying to install rt on a RHEL7 system, and have apache2, perl
> 5.24.1 and postgresql-9.5.6 installed.
>
> When I try to run make initialize-database, it fails with :
>
> Now inserting database ACLs.
> [73393] [Mon Mar  6 14:46:20 2017] [warning]: DBD::Pg::st execute
> failed: ERROR:  unrecognized role option "nocreateuser"
> LINE 1: ...tuser" WITH PASSWORD 'XXXXXXXXXXXXXX' NOCREATEDB NOCREATEUS...
>                                                              ^ at
> /usr/local/add-on/src/rt-4.4.1/sbin/../lib/RT/Handle.pm line 476.
> (/usr/local/add-on/src/rt-4.4.1/sbin/../lib/RT/Handle.pm:476)
> [73393] [Mon Mar  6 14:46:20 2017] [critical]: DBD::Pg::st execute
> failed: ERROR:  unrecognized role option "nocreateuser"
> LINE 1: ...tuser" WITH PASSWORD 'XXXXXXXXXXXXXX' NOCREATEDB NOCREATEUS...
>                                                              ^ at
> /usr/local/add-on/src/rt-4.4.1/sbin/../lib/RT/Handle.pm line 476.
> (/usr/local/add-on/src/rt-4.4.1/sbin/../lib/RT.pm:390)
> DBD::Pg::st execute failed: ERROR:  unrecognized role option "nocreateuser"
> LINE 1: ...tuser" WITH PASSWORD 'XXXXXXXXXXXXXXXX' NOCREATEDB NOCREATEUS...
>                                                              ^ at
> /usr/local/add-on/src/rt-4.4.1/sbin/../lib/RT/Handle.pm line 476.
> make: *** [initialize-database] Error 255
>
> If I do a find . -depth -type f | grep -i NOCREATEUSER, it find
> nothing.  Now i understand that NOCREATEUSER was removed in
> pg-9.6, but why doesn't the make complete, and where is the NOCREATEUSER
> coming from?
>
> Thanks
>
> Jim Ballantine
> ---------
> RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
> * Paris - April 24-26, 2017
>



-- 
Peter Nikolaidis
CISSP
<https://webportal.isc2.org/custom/CertificationVerificationResults.aspx?FN=Peter&LN=Nikolaidis&CN=453003>
, GCFE <https://www.giac.org/certified-professional/peter-nikolaidis/118082>
, GCIH <https://www.giac.org/certified-professional/peter-nikolaidis/118082>
, GPPA <http://www.giac.org/certified-professional/peter-nikolaidis/118082>
, GSNA <http://www.giac.org/certified-professional/peter-nikolaidis/118082>
Paradigm Consulting Co.
MA:617.517.2940 * NH:603.676.7119 * VT:802.234.6368
http://pa.radigm.com

--94eb2c05a3ae2d3dbd054a17317d
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>I found this string in:</div><div>/opt/rt4/etc/acl.Pg=
</div><div><br></div><div>Peter</div></div><div class=3D"gmail_extra"><br><=
div class=3D"gmail_quote">On Mon, Mar 6, 2017 at 11:31 AM, BALLANTINE, JAME=
S W <span dir=3D"ltr">&lt;<a href=3D"mailto:[email protected]" target=3D"_blan=
k">[email protected]</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote=
" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I=
&#39;m trying to install rt on a RHEL7 system, and have apache2, perl<br>
5.24.1 and postgresql-9.5.6 installed.<br>
<br>
When I try to run make initialize-database, it fails with :<br>
<br>
Now inserting database ACLs.<br>
[73393] [Mon Mar=C2=A0 6 14:46:20 2017] [warning]: DBD::Pg::st execute<br>
failed: ERROR:=C2=A0 unrecognized role option &quot;nocreateuser&quot;<br>
LINE 1: ...tuser&quot; WITH PASSWORD &#39;XXXXXXXXXXXXXX&#39; NOCREATEDB NO=
CREATEUS...<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0^ at<b=
r>
/usr/local/add-on/src/rt-4.4.<wbr>1/sbin/../lib/RT/Handle.pm line 476.<br>
(/usr/local/add-on/src/rt-4.4.<wbr>1/sbin/../lib/RT/Handle.pm:<wbr>476)<br>
[73393] [Mon Mar=C2=A0 6 14:46:20 2017] [critical]: DBD::Pg::st execute<br>
failed: ERROR:=C2=A0 unrecognized role option &quot;nocreateuser&quot;<br>
LINE 1: ...tuser&quot; WITH PASSWORD &#39;XXXXXXXXXXXXXX&#39; NOCREATEDB NO=
CREATEUS...<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0^ at<b=
r>
/usr/local/add-on/src/rt-4.4.<wbr>1/sbin/../lib/RT/Handle.pm line 476.<br>
(/usr/local/add-on/src/rt-4.4.<wbr>1/sbin/../lib/RT.pm:390)<br>
DBD::Pg::st execute failed: ERROR:=C2=A0 unrecognized role option &quot;noc=
reateuser&quot;<br>
LINE 1: ...tuser&quot; WITH PASSWORD &#39;XXXXXXXXXXXXXXXX&#39; NOCREATEDB =
NOCREATEUS...<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0^ at<b=
r>
/usr/local/add-on/src/rt-4.4.<wbr>1/sbin/../lib/RT/Handle.pm line 476.<br>
make: *** [initialize-database] Error 255<br>
<br>
If I do a find . -depth -type f | grep -i NOCREATEUSER, it find<br>
nothing.=C2=A0 Now i understand that NOCREATEUSER was removed in<br>
pg-9.6, but why doesn&#39;t the make complete, and where is the NOCREATEUSE=
R<br>
coming from?<br>
<br>
Thanks<br>
<br>
Jim Ballantine<br>
---------<br>
RT 4.4 and RTIR Training Sessions <a href=3D"https://bestpractical.com/trai=
ning" rel=3D"noreferrer" target=3D"_blank">https://bestpractical.com/<wbr>t=
raining</a><br>
* Paris - April 24-26, 2017<br>
</blockquote></div><br><br clear=3D"all"><div><br></div>-- <br><div class=
=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><d=
iv><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div dir=3D=
"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr" style=3D"font-size=
:12.8px">Peter Nikolaidis<br><a href=3D"https://webportal.isc2.org/custom/C=
ertificationVerificationResults.aspx?FN=3DPeter&amp;LN=3DNikolaidis&amp;CN=
=3D453003" target=3D"_blank">CISSP</a>,=C2=A0<a href=3D"https://www.giac.or=
g/certified-professional/peter-nikolaidis/118082" target=3D"_blank">GCFE</a=
>,=C2=A0<a href=3D"https://www.giac.org/certified-professional/peter-nikola=
idis/118082" style=3D"font-size:12.8px" target=3D"_blank">GCIH</a><span sty=
le=3D"font-size:12.8px">,=C2=A0</span><a href=3D"http://www.giac.org/certif=
ied-professional/peter-nikolaidis/118082" style=3D"font-size:12.8px" target=
=3D"_blank">GPPA</a><span style=3D"font-size:12.8px">,=C2=A0</span><a href=
=3D"http://www.giac.org/certified-professional/peter-nikolaidis/118082" sty=
le=3D"font-size:12.8px" target=3D"_blank">GSNA</a></div><div dir=3D"ltr" st=
yle=3D"font-size:12.8px">Paradigm Consulting Co.<br>MA:617.517.2940 * NH:60=
3.676.7119 *=C2=A0VT:802.234.6368=C2=A0<br><a href=3D"http://pa.radigm.com/=
" target=3D"_blank">http://pa.radigm.com</a></div></div></div></div></div><=
/div></div></div></div></div></div></div>
</div>

--94eb2c05a3ae2d3dbd054a17317d--

--===============0657745645==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

---------
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Paris - April 24-26, 2017
--===============0657745645==--