[rt-users] Default password

[James Moseley]

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                                                   
             <joliver at john-oli                                             
             ver.net>                                                   To 
             Sent by:                  rt-users at 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 root at 10.12.14.164 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.
>
> [root at rt3 ~]# /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: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com