Hi I have a similar problem to the one discussed few days earlier …
I am upgrading rt to 3.6.1 and mysql with a remote db server … my
configure options:
./configure --with-web-user=apache --with-web-group=users
–with-db-host=dbcluster01 --with-db-dba=root
–with-db-rt-host=dbcluster01.mydomain.com
** I also tried
./configure --with-web-user=apache --with-web-group=users
–with-db-host=dbcluster01 --with-db-dba=root@dbcluster01.mydomain.com
However when trying to run /opt/rt3/sbin/rt-setup-database --dba root
–prompt-for-dba-password --action schema --datadir etc/upgrade/
I am getting the error :DBI
connect(‘dbname=rt3;host=10.0.10.101’,‘root@dbcluster01.mydomain.com’,…)
failed: Access denied for user ‘root@dbcluster01’@‘web02.mydomain.com’
(using password: YES) at /opt/rt3/sbin/rt-setup-database line 170
web02 being the web server.
Have I missed anything, why ist assuming that my db user is
root@dbcluster01’@'web02.mydomain.com
Thanks;
Roy