<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Solved this issue. When I created the user 'root'@'10.10.10.3' on
the MySQL server, I used this command:<br>
GRANT ALL PRIVILEGES ON rt4.* TO 'root'@'10.10.10.3';<br>
<br>
This gave the root user privileges to manipulate the database, but
**not** to pass on their privileges to others. When I re-granted
using this command:<br>
GRANT ALL PRIVILEGES ON rt4.* TO 'root'@'10.10.10.3' WITH GRANT
OPTION;<br>
<br>
...the "Access denied" error vanished. I also had to readjust my
RT_SiteConfig.pm back to using root as the db admin. Solved and
archived for posterity. Thanks!<br>
<br>
<br>
<blockquote
cite="mid:CAFdkmptW63Pf7C-o6NWS7+MV9hCBssBEiVErCTMSaAGpqnF9xA@mail.gmail.com"
type="cite">
<div class="gmail_extra"><br>
<div class="gmail_quote">On 10 December 2014 at 01:56, Kristan
Wagner <span dir="ltr"><<a moz-do-not-send="true"
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/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 moz-do-not-send="true"
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/Handle.pm
line 452. (/tmp/rt-4.2.9/sbin/../lib/RT/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/Handle.pm line 452.
(/tmp/rt-4.2.9/sbin/../lib/RT.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/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>
+------------------------------------------------------------------------------------------------------------------------+<br>
| Grants for <a moz-do-not-send="true"
href="mailto:root@10.10.10.3" target="_blank">root@10.10.10.3</a><br>
+------------------------------------------------------------------------------------------------------------------------+<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>
+------------------------------------------------------------------------------------------------------------------------+<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>
</blockquote>
<br>
</body>
</html>