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.s...@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.s...@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@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 > >> > > >
-- RT Training - Boston, September 9-10 http://bestpractical.com/training