<div dir="ltr">You're doing this:<div><br></div><div><div># make initialize-database</div><div><br></div><div>which is in turn running this:</div><div><br></div><div># /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action init --prompt-for-dba-password</div></div><div><br></div><div>which is going to connect to the database as the RT "DBA user" (RT_Config setting $DatabaseAdmin), which according to your pasted output:</div><div><br></div><div>In order to create or update your RT database, this script needs to connect to your mysql instance on 10.20.20.5 (port '3306') as root<br></div><div><br></div><div>is "root".</div><div><br></div><div>Going off your RT_SiteConfig.pm snippet, you actually want to connect to the database as user "rtuser". Therefore, adding this to RT_SiteConfig.pm might solve your issue:</div><div><br></div><div><span style="font-size:13px">Set($DatabaseAdmin, "rtuser");</span><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 10 December 2014 at 01:56, Kristan Wagner <span dir="ltr"><<a href="mailto:kristan.wagner@lifewireless.com" target="_blank">kristan.wagner@lifewireless.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I am having troubles with the database initialization, for a fresh install of RT 4.2.9. The error message is: DBD::mysql::st execute failed: Access denied for user 'root'@'10.10.10.3' to database 'rt4' at /tmp/rt-4.2.9/sbin/../lib/RT/<u></u>Handle.pm line 452. make: *** [initialize-database] Error 255<br>
<br>
Here's my setup: Separate servers for the web frontend and the database, both running Ubuntu 14.04. The web frontend is running Apache/2.4.7 and has an IP address 10.10.10.3. The database machine is running MySQL 5.5.40 and has the IP address 10.20.20.5. Both of these are fresh installs, and RT is a fresh install, but we plan to migrate our old RT database (3.6.5) when the 4.2.9 is (eventually) running and tested. Right now, I'm just trying to get 4.2.9 going.<br>
<br>
Here's the context for the error: I've been following the README on the bestpractical website. At step 2, I ran configure with only one flag, --with-db-host=10.20.20.5. At step 4, fixdeps kept claiming that MySQL was missing, so I had to install MySQL on the web frontend as well, just to get it to install. At step 6a, make initialize-database is failing with the following output:<br>
<a href="http://root@10.10.10.3/tmp/rt-4.2.9#" target="_blank">root@10.10.10.3/tmp/rt-4.2.9#</a> make initialize-database<br>
/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action init --prompt-for-dba-password<br>
In order to create or update your RT database, this script needs to connect to your mysql instance on 10.20.20.5 (port '3306') as root<br>
Please specify that user's database password below. If the user has no database password, just press return.<br>
<br>
Password:<br>
Working with:<br>
Type: mysql<br>
Host: 10.20.20.5<br>
Port: 3306<br>
Name: rt4<br>
User: rtuser<br>
DBA: root<br>
Now creating a mysql database rt4 for RT.<br>
Done.<br>
Now populating database schema.<br>
Done.<br>
Now inserting database ACLs.<br>
[23346] [Mon Dec 8 21:27:35 2014] [warning]: DBD::mysql::st execute failed: Access denied for user 'root'@'10.10.10.3' to database 'rt4' at /tmp/rt-4.2.9/sbin/../lib/RT/<u></u>Handle.pm line 452. (/tmp/rt-4.2.9/sbin/../lib/RT/<u></u>Handle.pm:452)<br>
[23346] [Mon Dec 8 21:27:35 2014] [critical]: DBD::mysql::st execute failed: Access denied for user 'root'@'10.10.10.3' to database 'rt4' at /tmp/rt-4.2.9/sbin/../lib/RT/<u></u>Handle.pm line 452. (/tmp/rt-4.2.9/sbin/../lib/RT.<u></u>pm:388)<br>
DBD::mysql::st execute failed: Access denied for user 'root'@'10.10.10.3' to database 'rt4' at /tmp/rt-4.2.9/sbin/../lib/RT/<u></u>Handle.pm line 452.<br>
make: *** [initialize-database] Error 255<br>
<br>
I've spent a lot of time reading forum questions about mysqld.sock, but please note that there is NO mention of any socket trouble in the error, so I don't think that's it. Plus, it's able to get through the first two steps just fine.<br>
<br>
Here is some of RT_SiteConfig.pm from the web frontend:<br>
Set($DatabaseHost, '10.20.20.5' );<br>
Set($DatabasePort, "3306");<br>
Set($DatabasePassword, q{passwordhere});<br>
Set($DatabaseUser, "rtuser");<br>
Set($DatabaseName, q{rt4});<br>
<br>
On the database server, here is some of my.cnf:<br>
[mysqld]<br>
user = mysql<br>
pid-file = /var/run/mysqld/mysqld.pid<br>
socket = /var/run/mysqld/mysqld.sock<br>
port = 3306<br>
basedir = /usr<br>
datadir = /var/lib/mysql<br>
tmpdir = /tmp<br>
lc-messages-dir = /usr/share/mysql<br>
skip-external-locking<br>
bind-address = 0.0.0.0<br>
<br>
I've already tried this using the option skip-name-resolve, but that did not help.<br>
<br>
Here are the permissions for the root user, as shown on 10.20.20.5's MySQL instance:<br>
+-----------------------------<u></u>------------------------------<u></u>------------------------------<u></u>------------------------------<u></u>-+<br>
| Grants for <a href="mailto:root@10.10.10.3" target="_blank">root@10.10.10.3</a><br>
+-----------------------------<u></u>------------------------------<u></u>------------------------------<u></u>------------------------------<u></u>-+<br>
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.10.10.3' IDENTIFIED BY PASSWORD '*hash'<br>
| GRANT ALL PRIVILEGES ON `rt4`.* TO 'root'@'10.10.10.3'<br>
+-----------------------------<u></u>------------------------------<u></u>------------------------------<u></u>------------------------------<u></u>-+<br>
<br>
I've even tried creating a general root user for 'root'@'%' but the same error is thrown. Any help is appreciated. Thanks.<br>
<br>
<br>
<br>
</blockquote></div><br></div>