[rt-users] Vintage upgrade fails

[Alex Peters]

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