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

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

PeterOn 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