RT Upgrade going bad (4.0.8 -> 4.2.2)

RT Users
1

Hi All.

Having an issue upgrading our internal RT instance.

It’s been running 4.0.8 for a while now with no real issue. I had to perform some maintenance on the host so thought I’d throw the RT upgrade on at the same time. Usually the upgrades are pretty painless… but this one is the exception.

Most of the upgrade has been a success apart from the DB upgrade script won’t complete. I paste below the output (some omitted)…

{{{
root@rt:/tmp/rt-4.2.2# make upgrade-database
/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action upgrade --prompt-for-dba-password
In order to create or update your RT database, this script needs to connect to your SQLite 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:
Port:
Name: rt4
User: rt_user
DBA:
Enter RT version you’re upgrading from: 4.0.8

Going to apply following upgrades:

  • 4.0.9
  • 4.0.12
  • 4.0.13
  • 4.0.18
  • 4.0.19
  • 4.1.0
  • 4.1.1
  • 4.1.4
  • 4.1.5
  • 4.1.6
  • 4.1.7
  • 4.1.8
  • 4.1.9
  • 4.1.10
  • 4.1.11
  • 4.1.12
  • 4.1.13
  • 4.1.14
  • 4.1.15
  • 4.1.16
  • 4.1.17
  • 4.1.18
  • 4.1.19
  • 4.1.20
  • 4.1.21
  • 4.1.22
  • 4.1.23
  • 4.2.1
  • 4.2.2

Enter RT version if you want to stop upgrade at some point,
or leave it blank if you want apply above upgrades:

IT’S VERY IMPORTANT TO BACK UP BEFORE THIS STEP

Proceed [y/N]:y
Processing 4.0.9
[6096] [Tue Feb 4 10:12:39 2014] [warning]: Configuration option AutoCreate is deprecated, and will be removed in RT 4.4. You should use UserAutocreateDefaultsOnLogin instead. (/tmp/rt-4.2.2/sbin/…/lib/RT.pm:953)
[6096] [Tue Feb 4 10:12:39 2014] [critical]: Can’t use an undefined value as a HASH reference at /tmp/rt-4.2.2/sbin/…/lib/RT/Crypt.pm line 237. (/tmp/rt-4.2.2/sbin/…/lib/RT.pm:393)
Can’t use an undefined value as a HASH reference at /tmp/rt-4.2.2/sbin/…/lib/RT/Crypt.pm line 237.
make: *** [upgrade-database] Error 255
}}}

Any advice appreciated.

Thanks,

Nick
Nick Fennell
Senior Support Engineer

ApplianSys Limited
University of Warwick Science Park
Business Innovation Centre
Harry Weston Road
Coventry CV3 2TX

t: +44 (0) 870 7707 789
s: nick-fennell

Our sales team sells by referral:
Less time looking for customers, more time looking after them

Subscribe: http://eepurl.com/ibKtY

2

So it’s mainly this I’m having issues with;

{{{
[6096] [Tue Feb 4 10:12:39 2014] [critical]: Can’t use an undefined value as a HASH reference at /tmp/rt-4.2.2/sbin/…/lib/RT/Crypt.pm line 237. (/tmp/rt-4.2.2/sbin/…/lib/RT.pm:393)
Can’t use an undefined value as a HASH reference at /tmp/rt-4.2.2/sbin/…/lib/RT/Crypt.pm line 237.
make: *** [upgrade-database] Error 255
}}}

I’ve had to scrap the upgrade and revert to a snapshot (I love VMs) from before I started. Means I’m back to v4.0.8.

Any ideas would be good!
Nick Fennell
Senior Support Engineer

ApplianSys Limited
University of Warwick Science Park
Business Innovation Centre
Harry Weston Road
Coventry CV3 2TX

t: +44 (0) 870 7707 789
s: nick-fennell

Our sales team sells by referral:
Less time looking for customers, more time looking after them

Subscribe: EepURL - A Mailchimp Service 4 Feb 2014, at 10:20, Nick Fennell nick.fennell@appliansys.com wrote:

Hi All.

Having an issue upgrading our internal RT instance.

It’s been running 4.0.8 for a while now with no real issue. I had to perform some maintenance on the host so thought I’d throw the RT upgrade on at the same time. Usually the upgrades are pretty painless… but this one is the exception.

Most of the upgrade has been a success apart from the DB upgrade script won’t complete. I paste below the output (some omitted)…

{{{
root@rt:/tmp/rt-4.2.2# make upgrade-database
/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action upgrade --prompt-for-dba-password
In order to create or update your RT database, this script needs to connect to your SQLite 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:
Port:
Name: rt4
User: rt_user
DBA:
Enter RT version you’re upgrading from: 4.0.8

Going to apply following upgrades:

  • 4.0.9
  • 4.0.12
  • 4.0.13
  • 4.0.18
  • 4.0.19
  • 4.1.0
  • 4.1.1
  • 4.1.4
  • 4.1.5
  • 4.1.6
  • 4.1.7
  • 4.1.8
  • 4.1.9
  • 4.1.10
  • 4.1.11
  • 4.1.12
  • 4.1.13
  • 4.1.14
  • 4.1.15
  • 4.1.16
  • 4.1.17
  • 4.1.18
  • 4.1.19
  • 4.1.20
  • 4.1.21
  • 4.1.22
  • 4.1.23
  • 4.2.1
  • 4.2.2

Enter RT version if you want to stop upgrade at some point,
or leave it blank if you want apply above upgrades:

IT’S VERY IMPORTANT TO BACK UP BEFORE THIS STEP

Proceed [y/N]:y
Processing 4.0.9
[6096] [Tue Feb 4 10:12:39 2014] [warning]: Configuration option AutoCreate is deprecated, and will be removed in RT 4.4. You should use UserAutocreateDefaultsOnLogin instead. (/tmp/rt-4.2.2/sbin/…/lib/RT.pm:953)
[6096] [Tue Feb 4 10:12:39 2014] [critical]: Can’t use an undefined value as a HASH reference at /tmp/rt-4.2.2/sbin/…/lib/RT/Crypt.pm line 237. (/tmp/rt-4.2.2/sbin/…/lib/RT.pm:393)
Can’t use an undefined value as a HASH reference at /tmp/rt-4.2.2/sbin/…/lib/RT/Crypt.pm line 237.
make: *** [upgrade-database] Error 255
}}}

Any advice appreciated.

Thanks,

Nick

Nick Fennell
Senior Support Engineer

ApplianSys Limited
University of Warwick Science Park
Business Innovation Centre
Harry Weston Road
Coventry CV3 2TX

t: +44 (0) 870 7707 789
s: nick-fennell
www.appliansys.com

Our sales team sells by referral:
Less time looking for customers, more time looking after them

Subscribe: http://eepurl.com/ibKtY

3

So it’s mainly this I’m having issues with;

{{{
[6096] [Tue Feb 4 10:12:39 2014] [critical]: Can’t use an undefined
value as a HASH reference at /tmp/rt-4.2.2/sbin/…/lib/RT/Crypt.pm
line 237. (/tmp/rt-4.2.2/sbin/…/lib/RT.pm:393)
Can’t use an undefined value as a HASH reference
at /tmp/rt-4.2.2/sbin/…/lib/RT/Crypt.pm line 237.
make: *** [upgrade-database] Error 255
}}}

This says that it’s not finding the configuration value for either the %
GnuPG or the %SMIME configuration – which are part of RT 4.2’s core
RT_Config.pm file. To double-check, you did run ‘make upgrade’ prior to
‘make upgrade-database’, and your /tmp/rt-4.2.2/etc/RT_Config.pm does
contain the word “SMIME”?

  • Alex