[rt-users] Vintage upgrade fails

[Alex Peters]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140724/6aaba3d1/attachment.htm>