[rt-users] Can't upgrade database upgrading to 4.4 (externalauthid issue)

[Andrew Marosi]

I had to update the table and remove the ExternaAuthId; and comment out the ExternalAuthID from the LDAP config.  In my environment ExternalAuthId held the same info as Name

-----Original Message-----
From: rt-users [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of fleon
Sent: Thursday, February 11, 2016 6:03 AM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] Can't upgrade database upgrading to 4.4 (externalauthid issue)

I am upgrading to 4.4 from 4.2 and following all steps in the upgrading file and readme, but when i do make upgrade-database i am getting the following
error:

[23547] [Thu Feb 11 14:45:19 2016] [warning]: You have 626 users(s) with a non-empty value for column 'ExternalAuthId'. Core RT does not use this column, so perhaps an extension or local modification makes use of it.
Please migrate these user values to a custom field or an attribute because this upgrade will drop these columns. at ./etc/upgrade/4.3.0/content line 67, <$handle> line 1. (./etc/upgrade/4.3.0/content:67)
make: *** [upgrade-database] Error 1

The docs said to remove the plugin from the local dir, to remove the plugin declaration in SiteConfig and also to add Set($ExternalAuth, 1); to that file, which i did.

My guess is that the failure is caused by using this configuration:

[...]
# The mapping of RT attributes on to LDAP attributes
  'attr_map'                  =>  {   'Name' => 'sAMAccountName',
  'EmailAddress' => 'mail',
  'Organization' => 'physicalDeliveryOfficeName',
  'RealName' => 'displayName',
  *'ExternalAuthId' => 'sAMAccountName',* [...]

How do i fix this? This is practically required for any setup that uses Windows Active Directory. Let's suppose the answer is to drop all these values as the upgrade script says, but then how would i force the script to run since it stops?




--
View this message in context: http://cp.mcafee.com/d/2DRPow81MArhovvjKC-UOrKrhKOMOqem4THCQrIIcCzBxBx4SztBxAQsI9L8CQrIfffI9LK6ZlSdqi1hXqIEr2TYTjBPpXqIEr2TYTjBPqtQtIgsvW_cFzAS7A-LsKCCyNPwVBZ55_G8FHnjlK-POEuvkzaT0QSyrjdTdTdw0U-bd_isUXoHYuuvKDQ1TgQwgf_BY4JwnCnrm8NR3OW6PQxJfbJH4oWxa14LeFtwKMnYfDYoqvHsOsA2YGkrYLdpN5B-_0UT6ptKDNEn8lrxrW0E-l9QUxZ9HhSQVmQ_BPr3xEVvdCBKcOXtfzgQKCy0iS1EDCq86RyctgYQg8rfi6QYQgdH4oWxa14QgjGq86eod41EEYfDYoqvHsOsA3h1aB6_d59IsOrtRh2BZVc
Sent from the Request Tracker - User mailing list archive at Nabble.com.

---------
RT 4.4 and RTIR Training Sessions (http://cp.mcafee.com/d/5fHCNEg4x0idEIfLFTjvspdTdETpopd7b2rRPqdSm6jhOMOMyrhKOMOqem4TAjqdS7DDS4TT3uGX6J90EZJmkdxr-rFOVIZJmkdxr-rFOVJeWeS8efZvCkNOr3OvnKnjjhoVMsO-yy_R4kRHFGTvpVkffGhBrwqrjdFCXCXCM0p3WjmzJFOJF_bVjUCpm-CjzIEiwhU76UPbJQ-d2V2Hsbvg57OFeD4fFdqeSDaSDYKrosd7bVIQJNCnrFYq6BQQg2mMd4YPh0SIhzG7Cy13pWgSDCy1Joz7k9g8Cy2tjh0NP1Ewd57xY_z3jZrCjAwq89kETVEFdzCjsh1NtDWWUapi)
* Hamburg Germany  March 14 & 15, 2016