Sorry, I got the IP addresses backwards. What I wanted you to figure out was if you could connect to the db server from the RT server using the 'root' user via mysql client. From the RT server try:
mysql -u root -p -h 10.12.14.149 What about: mysql -u root -p -h 10.12.14.149 rt3 If you can connect successfully to the rt3 database using the 2nd command above, try creating a test table: mysql> create table testing123; If your manual connection attempts to the mysql database or your table creation attempt fails, then you simply haven't set your permissions correctly for the root user. At that point, I would suggest you read the mysql help pages regarding grant permission syntax: http://dev.mysql.com/doc/refman/5.0/en/grant.html Also, disable selinux on the DB server, if applicable. James Moseley John Oliver <[EMAIL PROTECTED] ver.net> To Sent by: rt-users@lists.bestpractical.com rt-users-bounces@ cc lists.bestpractic al.com Subject Re: [rt-users] Default password 08/02/2007 03:41 PM On Thu, Aug 02, 2007 at 01:44:41PM -0500, James Moseley wrote: > Well, sounds like you have a mysql problem now. While logged into your RT > host, and assuming you have a mysql client installed, can you successfully > connect the mysqld instance on 10.12.14.164? What happens when you do: > > mysql -u root -p -h 10.12.14.164 > > What about: > > mysql -u root -p -h 10.12.14.164 rt3 > > In the examples above, you will be prompted for the password. There is no MySQL running on .164 MySQL is on .149 I'm absolutely sure that this is a MySQL issue... it appears that "root" on .164 doesn't have the correct privileges on .149 I tried to at least temporarily give [EMAIL PROTECTED] full access on .149 but it didn't work as expected. My first guess is that rt-setup-database is trying to be too selective in the permissions it's granting... we can see that it's trying to give GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE to rt_user, so maybe when it creates the rt3 database it is using something other than ALL for 'root'? > Access denied for user 'root'@'10.12.14.164' to database 'rt3' at > /usr/sbin/rt-setup-database line 346. Since 'root'@'10.12.14.164' created rt3, that's the only reason I can think of that it's failing... the creator doesn't have enough privileges, or is assuming that the database is on localhost, if that makes a difference. > On Thu, Aug 02, 2007 at 02:39:18AM +0400, Ruslan Zakirov wrote: > > Here is the DatabaseRTHost option in the config that comes into play. > > Set it to '10.12.14.164' before running `make initdb`. As well you can > > use --with-db-rt-host option of the configure script to set it, note > > that you MUST run `make install` again before `make initdb` in this > > case. > > Ahh! > > Now I'm getting closer. > > [EMAIL PROTECTED] ~]# /usr/sbin/rt-setup-database --action init --dba root > --prompt-for-dba-password > In order to create or update your RT database,this script needs to > connect to your mysql instance on 10.12.14.149 as root. > Please specify that user's database password below. If the user has no > database > password, just press return. > > Password: > Now creating a database for RT. > Creating mysql database rt3. > Now populating database schema. > Creating database schema. > readline() on closed filehandle SCHEMA_LOCAL at > /usr/sbin/rt-setup-database line 192. > Done setting up database schema. > Now inserting database ACLs > DBD::mysql::st execute failed: Access denied for user > 'root'@'10.12.14.164' to database 'rt3' at /usr/sbin/rt-setup-database > line 345. > Problem with statement: > GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON rt3.* TO > rt_user@'10.12.14.164' IDENTIFIED BY '***********'; > Access denied for user 'root'@'10.12.14.164' to database 'rt3' at > /usr/sbin/rt-setup-database line 346. > > > On the MySQL server, I did: > > grant all on *.* to 'root'@'10.12.14.164' identified by '********' > > but am still getting that error. > > Thanks! -- *********************************************************************** * John Oliver http://www.john-oliver.net/ * * * *********************************************************************** _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com