[rt-users] Vintage upgrade fails - SOLUTION
"Tamás, Szép"
tamas.szep at govcert.hu
Fri Jul 25 05:03:29 EDT 2014
I got this finally! You were right, it really missed the 'rt_user' from
MySQL. So I typed:
CREATE USER 'rt_user'@'localhost' IDENTIFIED BY 'rt_pass';
GRANT ALL PRIVILEGES ON rt4.* TO 'rt_user'@'localhost' IDENTIFIED BY
'rt_pass';
and there it goes, the database upgrade ran smoothly.
Thank you Alex for all the help!
Coming soon (ASAP): vintage IR plugin upgrade... fingers crossed.
Tamas
on 2014.07.24. 16:05, Alex Peters wrote:
> I've just realised that RT will be using a default password of "rt_pass" in
> some cases.
>
> Try additionally setting the RT_DB_PASSWORD environment variable before
> running the script.
>
> Alternatively, create an RT_SiteConfig.pm file in the etc directory of your
> upgrade containing all of the necessary database configuration details.
>
>
> On 24 July 2014 23:54, "Tamás, Szép" <tamas.szep at govcert.hu> wrote:
>
>> Everything seems to work smoothly:
>>
>> root at 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.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
>>>>>>>>
>>>>
>>>
>>
>
--
Üdvözlettel:
Szép Tamás
osztályvezető helyettes
Ügyeleti Osztály
GovCERT-Hungary
More information about the rt-users
mailing list