<div dir="ltr">I've just realised that RT will be using a default password of "rt_pass" in some cases.<div><br></div><div>Try additionally setting the RT_DB_PASSWORD environment variable before running the script.</div>
<div><br></div><div>Alternatively, create an RT_SiteConfig.pm file in the etc directory of your upgrade containing all of the necessary database configuration details.</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">
On 24 July 2014 23:54, "Tamás, Szép" <span dir="ltr"><<a href="mailto:tamas.szep@govcert.hu" target="_blank">tamas.szep@govcert.hu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Everything seems to work smoothly:<br>
<br>
root@ubuntu:/# mysql -u root -p<br>
Enter password:<br>
Welcome to the MySQL monitor. Commands end with ; or \g.<br>
Your MySQL connection id is 53<br>
Server version: 5.5.38-0ubuntu0.12.04.1 (Ubuntu)<br>
<br>
-----blablabla-----<br>
<br>
mysql> show databases;<br>
+--------------------+<br>
| Database |<br>
+--------------------+<br>
| information_schema |<br>
| mysql |<br>
| performance_schema |<br>
| rt3 |<br>
| rt4 |<br>
+--------------------+<br>
5 rows in set (0.00 sec)<br>
<br>
mysql> use rt4;<br>
Reading table information for completion of table and column names<br>
You can turn off this feature to get a quicker startup with -A<br>
<br>
Database changed<br>
mysql> show tables;<br>
+-------------------------+<br>
| Tables_in_rt4 |<br>
+-------------------------+<br>
| ACL |<br>
| Attachments |<br>
| Attributes |<br>
| CachedGroupMembers |<br>
| CustomFieldValues |<br>
| CustomFields |<br>
| GroupMembers |<br>
| Groups |<br>
| Links |<br>
| Principals |<br>
| Queues |<br>
| ScripActions |<br>
| ScripConditions |<br>
| Scrips |<br>
| Sessions |<br>
| Templates |<br>
| TicketCustomFieldValues |<br>
| Tickets |<br>
| Transactions |<br>
| Users |<br>
+-------------------------+<br>
20 rows in set (0.00 sec)<br>
<br>
<br>
Before you ask: the 'rt4' database was created by me simply typing<br>
'create database rt4;', because the upgrade process needs it, but it<br>
will not create it for you. That is why I have both 'rt3' and 'rt4'.<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
on 2014.07.24. 15:43, Alex Peters wrote:<br>
> To me, this suggests a problem independent of RT.<br>
><br>
> Is your database running on localhost? What happens when you try to<br>
> connect to the database directly with that username using a MySQL client?<br>
><br>
><br>
> On 24 July 2014 23:41, "Tamás, Szép" <<a href="mailto:tamas.szep@govcert.hu">tamas.szep@govcert.hu</a>> wrote:<br>
><br>
>> Now it says (went back to the right snapshot ofcourse):<br>
>><br>
>> Processing 3.1.0<br>
>> Now populating database schema.<br>
>> Now inserting database ACLs.<br>
>> DBI connect('dbname=rt4;host=localhost','root',...) failed: Access<br>
>> denied for user 'root'@'localhost' (using password: YES) at<br>
>> /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 105.<br>
>> Connect Failed Access denied for user 'root'@'localhost' (using<br>
>> password: YES)<br>
>> at /w/install/new/rt/sbin/../lib/RT.pm line 211.<br>
>><br>
>> FYI: as I work in a sandbox, everything is left as it was installed: RT<br>
>> 3.0.12 and IR 1.0.5. Have not edit a single file and that is why it is<br>
>> strange to me because the upgrade should work fluently.<br>
>><br>
>> Should I try to create the 'rt_user' DB user? I don't think that would<br>
>> be a solution but who knows.<br>
>><br>
>> Tamas<br>
>><br>
>> on 2014.07.24. 15:27, Alex Peters wrote:<br>
>>> RT is defaulting to database username "rt_user" because you didn't<br>
>> specify<br>
>>> the correct value when you ran the configure script.<br>
>>><br>
>>> You can work around this by setting environment variable RT_DB_USER to<br>
>>> "root" before running the command:<br>
>>><br>
>>> RT_DB_USER=root /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib<br>
>>> sbin/rt-setup-database --action upgrade --prompt-for-dba-password --dba<br>
>> root<br>
>>><br>
>>><br>
>>> On 24 July 2014 23:18, "Tamás, Szép" <<a href="mailto:tamas.szep@govcert.hu">tamas.szep@govcert.hu</a>> wrote:<br>
>>><br>
>>>> I only have one database user, the default 'root' DB user with a<br>
>> password.<br>
>>>> The command you suggested results the same error unfortunately.<br>
>>>> I do these in a sandbox environment so I can step back to any saved<br>
>>>> snapshots and try and try again. The RT4 upgrade process is done except<br>
>>>> this final one, the database upgrade.<br>
>>>> Any more ideas?<br>
>>>><br>
>>>> Tamas<br>
>>>><br>
>>>> on 2014.07.24. 14:57, Alex Peters wrote:<br>
>>>>> Running this step as the Unix root user should not be necessary.<br>
>>>>><br>
>>>>> The error message is interesting, because it suggests that RT is not<br>
>>>>> attempting to connect to the database as the correct database user.<br>
>>>>><br>
>>>>> Do you have two separate database user accounts set up for RT—one for<br>
>>>>> regular use, and one for database upgrades?<br>
>>>>><br>
>>>>> If not, consider running the following command instead:<br>
>>>>><br>
>>>>> /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib<br>
>>>>> sbin/rt-setup-database --action<br>
>>>>> upgrade --prompt-for-dba-password --dba XXX<br>
>>>>><br>
>>>>> where XXX is the name of the database user.<br>
>>>>><br>
>>>>><br>
>>>>> On 24 July 2014 22:32, "Tamás, Szép" <<a href="mailto:tamas.szep@govcert.hu">tamas.szep@govcert.hu</a>> wrote:<br>
>>>>><br>
>>>>>> Hello,<br>
>>>>>><br>
>>>>>> I try to upgrade RT 3.0.12 to RT 4.0.20. It works well until finally I<br>
>>>>>> get to the<br>
>>>>>> make upgrade-database<br>
>>>>>> command which dies. See below. I do these as root user.<br>
>>>>>><br>
>>>>>> -----BEGIN-----<br>
>>>>>> root@ubuntu:/w/install/new/rt# make upgrade-database<br>
>>>>>><br>
>>>>>> /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib<br>
>> sbin/rt-setup-database<br>
>>>>>> --action upgrade --prompt-for-dba-password<br>
>>>>>> In order to create or update your RT database, this script needs to<br>
>>>>>> connect to your mysql instance on localhost (port '') as root<br>
>>>>>> Please specify that user's database password below. If the user has no<br>
>>>>>> database<br>
>>>>>> password, just press return.<br>
>>>>>><br>
>>>>>> Password: -----HERE I TYPE THE DB ROOT PASSWORD-----<br>
>>>>>> Working with:<br>
>>>>>> Type: mysql<br>
>>>>>> Host: localhost<br>
>>>>>> Port:<br>
>>>>>> Name: rt4<br>
>>>>>> User: rt_user<br>
>>>>>> DBA: root<br>
>>>>>> Enter RT version you're upgrading from: 3.0.12 -----UPGRADING FROM<br>
>>>>>> THIS-----<br>
>>>>>><br>
>>>>>> Going to apply following upgrades:<br>
>>>>>> * 3.1.0<br>
>>>>>> * 3.1.15<br>
>>>>>> -----CUT TO SHORTEN THE LIST-----<br>
>>>>>> * 4.0.18<br>
>>>>>> * 4.0.19<br>
>>>>>><br>
>>>>>> Enter RT version if you want to stop upgrade at some point,<br>
>>>>>> or leave it blank if you want apply above upgrades: -----I JUST<br>
>> PRESS<br>
>>>>>> ENTER HERE-----<br>
>>>>>><br>
>>>>>> IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP<br>
>>>>>><br>
>>>>>> Proceed [y/N]:y<br>
>>>>>> Processing 3.1.0<br>
>>>>>> Now populating database schema.<br>
>>>>>> Now inserting database ACLs.<br>
>>>>>> -----HERE COMES THE ERROR-----<br>
>>>>>> DBI connect('dbname=rt4;host=localhost','rt_user',...) failed: Access<br>
>>>>>> denied for user 'rt_user'@'localhost' (using password: YES) at<br>
>>>>>> /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 105.<br>
>>>>>> Connect Failed Access denied for user 'rt_user'@'localhost' (using<br>
>>>>>> password: YES)<br>
>>>>>> at /w/install/new/rt/sbin/../lib/RT.pm line 211.<br>
>>>>>> make: *** [upgrade-database] Error 255<br>
>>>>>> -----END-----<br>
>>>>>><br>
>>>>>> I need help. Thank you.<br>
>>>>>><br>
>>>>>> Best regards,<br>
>>>>>><br>
>>>>>> Tamas Szep<br>
>>>>>> GovCERT-Hungary<br>
>>>>>> --<br>
>>>>>> RT Training - Boston, September 9-10<br>
>>>>>> <a href="http://bestpractical.com/training" target="_blank">http://bestpractical.com/training</a><br>
>>>>>><br>
>><br>
><br>
</div></div></blockquote></div><br></div>