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" <[email protected]> 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" <[email protected]> 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" <[email protected]> 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
