[rt-users] Vintage upgrade fails

["Tamás, Szép"]

Now it says (went back to the right snapshot ofcourse):

Processing 3.1.0
Now populating database schema.
Now inserting database ACLs.
DBI connect('dbname=rt4;host=localhost','root',...) failed: Access
denied for user 'root'@'localhost' (using password: YES) at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 105.
Connect Failed Access denied for user 'root'@'localhost' (using
password: YES)
 at /w/install/new/rt/sbin/../lib/RT.pm line 211.

FYI: as I work in a sandbox, everything is left as it was installed: RT
3.0.12 and IR 1.0.5. Have not edit a single file and that is why it is
strange to me because the upgrade should work fluently.

Should I try to create the 'rt_user' DB user? I don't think that would
be a solution but who knows.

Tamas

on 2014.07.24. 15:27, Alex Peters wrote:
> RT is defaulting to database username "rt_user" because you didn't specify
> the correct value when you ran the configure script.
> 
> You can work around this by setting environment variable RT_DB_USER to
> "root" before running the command:
> 
> RT_DB_USER=root /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib
> sbin/rt-setup-database --action upgrade --prompt-for-dba-password --dba root
> 
> 
> On 24 July 2014 23:18, "Tamás, Szép" <tamas.szep at govcert.hu> wrote:
> 
>> 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
>>>>