Mailing List Archive

unrecognized roll option "nocreateuser"
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
Re: unrecognized roll option "nocreateuser" [ In reply to ]
I found this string in:
/opt/rt4/etc/acl.Pg

Peter

On Mon, Mar 6, 2017 at 11:31 AM, BALLANTINE, JAMES W <jb7492@att.com> 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