[rt-users] Vintage upgrade fails

["Tamás, Szép"]

I only have one database user, the default 'root' DB user with a password.
The command you suggested results the same error unfortunately.
I do these in a sandbox environment so I can step back to any saved
snapshots and try and try again. The RT4 upgrade process is done except
this final one, the database upgrade.
Any more ideas?

Tamas

on 2014.07.24. 14:57, Alex Peters wrote:
> Running this step as the Unix root user should not be necessary.
> 
> The error message is interesting, because it suggests that RT is not
> attempting to connect to the database as the correct database user.
> 
> Do you have two separate database user accounts set up for RT—one for
> regular use, and one for database upgrades?
> 
> If not, consider running the following command instead:
> 
> /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib
> sbin/rt-setup-database --action
> upgrade --prompt-for-dba-password --dba XXX
> 
> where XXX is the name of the database user.
> 
> 
> On 24 July 2014 22:32, "Tamás, Szép" <tamas.szep at govcert.hu> wrote:
> 
>> Hello,
>>
>> I try to upgrade RT 3.0.12 to RT 4.0.20. It works well until finally I
>> get to the
>>         make upgrade-database
>> command which dies. See below. I do these as root user.
>>
>> -----BEGIN-----
>> root at ubuntu:/w/install/new/rt# 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  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: -----HERE I TYPE THE DB ROOT PASSWORD-----
>> Working with:
>> Type:   mysql
>> Host:   localhost
>> Port:
>> Name:   rt4
>> User:   rt_user
>> DBA:    root
>> Enter RT version you're upgrading from: 3.0.12 -----UPGRADING FROM
>> THIS-----
>>
>> Going to apply following upgrades:
>> * 3.1.0
>> * 3.1.15
>> -----CUT TO SHORTEN THE LIST-----
>> * 4.0.18
>> * 4.0.19
>>
>> Enter RT version if you want to stop upgrade at some point,
>>   or leave it blank if you want apply above upgrades: -----I JUST PRESS
>> ENTER HERE-----
>>
>> IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP
>>
>> Proceed [y/N]:y
>> Processing 3.1.0
>> Now populating database schema.
>> Now inserting database ACLs.
>> -----HERE COMES THE ERROR-----
>> DBI connect('dbname=rt4;host=localhost','rt_user',...) failed: Access
>> denied for user 'rt_user'@'localhost' (using password: YES) at
>> /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 105.
>> Connect Failed Access denied for user 'rt_user'@'localhost' (using
>> password: YES)
>>  at /w/install/new/rt/sbin/../lib/RT.pm line 211.
>> make: *** [upgrade-database] Error 255
>> -----END-----
>>
>> I need help. Thank you.
>>
>> Best regards,
>>
>> Tamas Szep
>> GovCERT-Hungary
>> --
>> RT Training - Boston, September 9-10
>> http://bestpractical.com/training
>>
>