Re: [rt-users] unrecognized roll option "nocreateuser"

[Peter Nikolaidis]

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

Peter

On Mon, Mar 6, 2017 at 11:31 AM, BALLANTINE, JAMES W  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 'XX' 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 'XX' 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 '' 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

, GCFE 
, GCIH 
, GPPA 
, GSNA 
Paradigm Consulting Co.
MA:617.517.2940 * NH:603.676.7119 * VT:802.234.6368
http://pa.radigm.com
-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Paris - April 24-26, 2017

[rt-users] unrecognized roll option "nocreateuser"

[BALLANTINE, JAMES W]

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 'XX' 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 'XX' 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 '' 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