[rt-users] Error when initializing database with external auth enabled

[Jim Brandt]

To clarify the previous question, if you were using 
RT::Authen::ExternalAuth in a previous version of RT (pre-4.4) and have 
it pulled in as a Plugin, you need to remove it because it is now in 
core. It's not clear to me if your RT_SiteConfig.pm is from an earlier 
RT version. If so, you will need to make some updates due to the RT 
version change:

https://docs.bestpractical.com/rt/4.4.1/UPGRADING-4.4.html

On 5/25/16 10:21 PM, Bart Bunting wrote:
> Peter,
>
> Not sure, but this is a new install using rt 4.4.
>
>
>
> Kind regards
> Peter Viskup <skupko.sk at gmail.com> writes:
>
>> Couldn't this be related to RT::Authen::ExternalAuth migration to RT
>> core since 4.4 version?
>>
>> https://docs.bestpractical.com/rt/4.4.0/UPGRADING-4.4.html
>>
>> --
>> Peter
>>
>> On Wed, May 25, 2016 at 2:26 AM, Bart Bunting <bart.bunting at ursys.com.au> wrote:
>>>
>>> Hi there,
>>>
>>> I may be just missing something but this is failing miserably for me and
>>> I am not sure what the correct way to fix it is:
>>>
>>> Running rt 4.4.1 rc1 as of today.
>>>
>>> The situation is I have external authentication working fine using both
>>> RT::Authen::ExternalAuth and RT::LDAPImport.
>>>
>>> I use puppet to provision the machine.
>>>
>>> When I have the external authentication configuration enabled in
>>> RT_SiteConfig.pm the
>>> initial database import breaks.  I think this is because when it trys to
>>> add the "root" user it attempts to canonicalize the name from ldap which
>>> fails.
>>>
>>> Here is an example of the run:
>>>
>>>           make initialize-database
>>> /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action init --prompt-for-dba-password
>>> In order to create or update your RT database, this script needs to connect to your  mysql instance on localhost (port '') as root
>>> Please specify that user's database password below. If the user has no database
>>> password, just press return.
>>>
>>> Password:
>>> Working with:
>>> Type:   mysql
>>> Host:   localhost
>>> Port:
>>> Name:   rt4
>>> User:   rt
>>> DBA:    root
>>> Now creating a mysql database rt4 for RT.
>>> Done.
>>> Now populating database schema.
>>> Done.
>>> Now inserting database ACLs.
>>> Done.
>>> Now inserting RT core system objects.
>>> [15076] [Wed May 25 00:15:29 2016] [critical]: Undefined subroutine &RT::Authen::ExternalAuth::LDAP::CanonicalizeUserInfo called at /opt/rt_source/sbin/../lib/RT/User.pm line 787. (/opt/rt_source/sbin/../lib/RT.pm:390)
>>> Undefined subroutine &RT::Authen::ExternalAuth::LDAP::CanonicalizeUserInfo called at /opt/rt_source/sbin/../lib/RT/User.pm line 787.
>>> Makefile:386: recipe for target 'initialize-database' failed
>>> make: *** [initialize-database] Error 2
>>> root at rt-dev:/opt/rt_source#
>>>
>>> I can work around this by having puppet install one version of RT_SiteConfig.pm without
>>> external authentication configured, run the database import and then
>>> replace it with a version with external auth enabled.
>>>
>>> This works, I've tested it.
>>>
>>> It just feels terribly ugly and wrong.
>>>
>>> Can anyone suggest what I might be doing wrong here or is this a genuine
>>> issue?
>>>
>>>
>>> Kind regards
>>> Bart
>>> --
>>>
>>> Bart Bunting - URSYS
>>> PH: 02 87452811
>>> Mbl: 0409560005
>>> ---------
>>> RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
>>> * Los Angeles - September, 2016
> Bart
>