Re: [rt-users] Default password
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
Re: [rt-users] Default password
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 [EMAIL PROTECTED] ver.net To Sent by: rt-users@lists.bestpractical.com rt-users-bounces@ cc lists.bestpractic al.comSubject 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. [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
Re: [rt-users] Default password
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
Re: [rt-users] Default password
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.comSubject 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
Re: [rt-users] Default password
On Tue, Jul 31, 2007 at 02:53:50PM -0700, Chaim Rieger wrote: John Oliver wrote: I shouldn't have to manually add a 'root' user. Right? after use rt3 do show tables then select * from Users is root in there ? No. But the tables are there... [EMAIL PROTECTED] ~]# mysql -h ntdbs01 -u rt_user -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 Server version: 5.0.22 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use rt3; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql show tables; +-+ | Tables_in_rt3 | +-+ | ACL | | Attachments | | Attributes | | CachedGroupMembers | | CustomFieldValues | | CustomFields| | GroupMembers| | Groups | | Links | | ObjectCustomFieldValues | | ObjectCustomFields | | Principals | | Queues | | ScripActions| | ScripConditions | | Scrips | | Templates | | Tickets | | Transactions| | Users | | sessions| +-+ 21 rows in set (0.00 sec) Absolutely bizarre. OK, how do I add a root user correctly? -- *** * 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
Re: [rt-users] Default password
Yes all you need is ~]# /usr/sbin/rt-setup-database and all mysql related stuff as per the read me .. have a look at the wiki installation document it explains how to deal with your error. Roy - Original Message - From: John Oliver [EMAIL PROTECTED] To: rt-users@lists.bestpractical.com Sent: Wednesday, August 01, 2007 6:41 PM Subject: Re: [rt-users] Default password On Wed, Aug 01, 2007 at 06:09:42PM +0100, Roy El-Hames wrote: Have you any users in your Users table, if not then I would recommend re-installing RT, cause you need more than just the root user like the user Nobody and RT_System. Reinstall??? Wouldn't dropping the database and re-running rt-setup-database, in theory, be sufficient? Which leads to another problem... [EMAIL PROTECTED] ~]# /usr/sbin/rt-setup-database --action init --dba rt_user --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 rt_user. 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 'rt_user'@'10.12.14.164' to database 'mysql' at /usr/sbin/rt-setup-database line 345. Problem with statement: USE mysql; Access denied for user 'rt_user'@'10.12.14.164' to database 'mysql' at /usr/sbin/rt-setup-database line 346. rt-setup-database apparantly can start setting up the database, but runs into a problem because it tries to access the 'mysql' database. I dropped the rt3 database and granted all to rt_user, but it still fails. So... what is the correct way to initialize the rt3 database? -- *** * 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
Re: [rt-users] Default password
On 8/1/07, John Oliver [EMAIL PROTECTED] wrote: On Wed, Aug 01, 2007 at 06:09:42PM +0100, Roy El-Hames wrote: Have you any users in your Users table, if not then I would recommend re-installing RT, cause you need more than just the root user like the user Nobody and RT_System. Reinstall??? Wouldn't dropping the database and re-running rt-setup-database, in theory, be sufficient? should Which leads to another problem... [EMAIL PROTECTED] ~]# /usr/sbin/rt-setup-database --action init --dba rt_user --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 rt_user. 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 'rt_user'@'10.12.14.164' to database 'mysql' at /usr/sbin/rt-setup-database line 345. Problem with statement: USE mysql; Access denied for user 'rt_user'@'10.12.14.164' to database 'mysql' at /usr/sbin/rt-setup-database line 346. rt-setup-database apparantly can start setting up the database, but runs into a problem because it tries to access the 'mysql' database. I dropped the rt3 database and granted all to rt_user, but it still fails. So... what is the correct way to initialize the rt3 database? 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. -- *** * 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 -- Best regards, Ruslan. ___ 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
Re: [rt-users] Default password
On Tue, Jul 31, 2007 at 01:33:32PM -0700, John Oliver wrote: The default password 'password' isn't working for me (do I have a black thumb of death or what? :-) ). I haven't been able to find anything about resetting it. I found http://wiki.bestpractical.com/view/RecoverRootPassword However... it doesn't help :-( mysql update Users set Password='X03MO1qnZdYdgyfeuILPmQ' where Name='root'; Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed: 0 Warnings: 0 mysql UPDATE Users SET Password='X03MO1qnZdYdgyfeuILPmQ' WHERE Name='root'; Query OK, 0 rows affected (0.01 sec) Rows matched: 0 Changed: 0 Warnings: 0 0 rows affected sounds like there is no username root? -- *** * 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
Re: [rt-users] Default password
John Oliver wrote: I found http://wiki.bestpractical.com/view/RecoverRootPassword However... it doesn't help :-( mysql update Users set Password='X03MO1qnZdYdgyfeuILPmQ' where Name='root'; Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed: 0 Warnings: 0 mysql UPDATE Users SET Password='X03MO1qnZdYdgyfeuILPmQ' WHERE Name='root'; Query OK, 0 rows affected (0.01 sec) Rows matched: 0 Changed: 0 Warnings: 0 0 rows affected sounds like there is no username root mysql -u (whatever) -p (if needed) then you need to change to the rt db use name_of_rt_db then you can reset the passwd. ___ 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
Re: [rt-users] Default password
At Tuesday 7/31/2007 04:33 PM, John Oliver wrote: The default password 'password' isn't working for me (do I have a black thumb of death or what? :-) ). I haven't been able to find anything about resetting it. -- http://wiki.bestpractical.com/view/RecoverRootPassword Steve ___ 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
Re: [rt-users] Default password
On Tue, Jul 31, 2007 at 01:49:29PM -0700, Chaim Rieger wrote: John Oliver wrote: I found http://wiki.bestpractical.com/view/RecoverRootPassword However... it doesn't help :-( mysql update Users set Password='X03MO1qnZdYdgyfeuILPmQ' where Name='root'; Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed: 0 Warnings: 0 mysql UPDATE Users SET Password='X03MO1qnZdYdgyfeuILPmQ' WHERE Name='root'; Query OK, 0 rows affected (0.01 sec) Rows matched: 0 Changed: 0 Warnings: 0 0 rows affected sounds like there is no username root mysql -u (whatever) -p (if needed) then you need to change to the rt db use name_of_rt_db then you can reset the passwd. Yes, I know... :-) [EMAIL PROTECTED] ~]# mysql -h ntdbs01 -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 15 Server version: 5.0.22 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use rt3; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql update Users set Password='X03MO1qnZdYdgyfeuILPmQ' where Name='root'; Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed: 0 Warnings: 0 mysql UPDATE Users SET Password='X03MO1qnZdYdgyfeuILPmQ' WHERE Name='root'; Query OK, 0 rows affected (0.01 sec) Rows matched: 0 Changed: 0 Warnings: 0 I shouldn't have to manually add a 'root' user. Right? -- *** * 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
Re: [rt-users] Default password
John Oliver wrote: I shouldn't have to manually add a 'root' user. Right? after use rt3 do show tables then select * from Users is root in there ? ___ 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