[rt-users] Vintage upgrade fails

[Alex Peters]

To me, this suggests a problem independent of RT.

Is your database running on localhost?  What happens when you try to
connect to the database directly with that username using a MySQL client?


On 24 July 2014 23:41, "Tamás, Szép" <tamas.szep at govcert.hu> wrote:

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