Everything seems to work smoothly: root@ubuntu:/# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 53 Server version: 5.5.38-0ubuntu0.12.04.1 (Ubuntu)
-----blablabla----- mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | rt3 | | rt4 | +--------------------+ 5 rows in set (0.00 sec) mysql> use rt4; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +-------------------------+ | Tables_in_rt4 | +-------------------------+ | ACL | | Attachments | | Attributes | | CachedGroupMembers | | CustomFieldValues | | CustomFields | | GroupMembers | | Groups | | Links | | Principals | | Queues | | ScripActions | | ScripConditions | | Scrips | | Sessions | | Templates | | TicketCustomFieldValues | | Tickets | | Transactions | | Users | +-------------------------+ 20 rows in set (0.00 sec) Before you ask: the 'rt4' database was created by me simply typing 'create database rt4;', because the upgrade process needs it, but it will not create it for you. That is why I have both 'rt3' and 'rt4'. on 2014.07.24. 15:43, Alex Peters wrote: > 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.s...@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.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