[rt-users] Upgrading from 4.2.0 > 4.4.0

Lush, Aaron alush at scentral.k12.in.us
Fri Feb 26 16:12:54 EST 2016

Thanks, Joop. I'll restore my 4.2 database backup and run the following SQL
command on the database:

UPDATE users SET ExternalAuthID=null WHERE ExternalAuthId IS NOT null;

MySQL isn't my strongest set of skills, but that is how I am understanding
your post. Thanks a lot for the quick response!


Aaron Lush
Network Administrator
South Central Community School Corporation
(219) 767-2266 ext. 1111

On Fri, Feb 26, 2016 at 2:59 PM, Joop <jvdwege at xs4all.nl> wrote:

> On 26-2-2016 18:47, Lush, Aaron wrote:
> I'm trying to upgrade from 4.2.0 > 4.4.0 on Ubuntu Server 15.10 and have
> been running into some snags. The first was that I had "ExternalAuthId"
> with values in my RT4 database, as I was using that plug-in. Once I dropped
> that table I was able to continue upgrading. However, my upgrade has
> stalled at the following:
> Using something like : update users set externalauthid=null where
> externalauthid is not null should do the trick. Don't drop the users table.
> I just did a test upgrade from 4.0.23 to 4.4.0 and we're using
> ExternalAuth too.
> For those interested: we also use AssetTracker and I migrated all its
> assets to the shine new RT::Assets :-)
> Got a question about something related but will post that in a new thread.
> Regards,
> Joop
> ---------
> RT 4.4 and RTIR Training Sessions (
> http://bestpractical.com/services/training.html)
> * Hamburg Germany - March 14 & 15, 2016
> * Washington DC - May 23 & 24, 2016

Email Confidentiality Notice: This email message, including all 
attachments, is for the sole use of the intended recipient(s) and contains 
confidential information. If you are not the intended recipient, you may 
not use, disclose, print, copy or disseminate this information. Please 
reply and notify the sender, delete the message and any attachments and 
destroy all copies. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20160226/fcec2eed/attachment.html>

More information about the rt-users mailing list