[rt-users] Default password

[James Moseley]

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.


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 01:09                                              
             PM                                                            
                                                                           
                                                                           
                                                                           




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