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://requesttracker.8502.n7.nabble.com/Can-t-upgrade-database-upgrading-to-4-4-externalauthid-issue-tp61350.html

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@lists.bestpractical.com] On Behalf Of fleon
Sent: Thursday, February 11, 2016 6:03 AM
To: rt-users@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

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

I grew impatient and decided to update the table manually and made the field
null and removed the entry from the config file as well. So far so good,
upgrade completed and was able to log in just fine.

I will try the ldap import later to see if it works, so far it seems the
only line pertinent to Active Directory’s user name is the mapping to the
field ‘Name’ such as:

‘Name’ => ‘sAMAccountName’

Thanks

View this message in context: http://requesttracker.8502.n7.nabble.com/Can-t-upgrade-database-upgrading-to-4-4-externalauthid-issue-tp61350p61354.html