Re: [rt-users] Database relocated onto alternate server
More Info: I can successfully connect through mysql command line tools, php test script and through a test perl script with the default apache2 config. This all leads me to it being something with RT's setup specifically. Once I switch back to the RT apache config RT fails to connect to the db. This is when trying to connect from perl 5.8.8, apache2.2.3. The local database was 5.0.32 which worked fine whereas the remote database is 4.0.24 which does meet the minimum required version in the docs. Any other ideas I can try? Thanks, Keith Raed El-Hames wrote: Hi Keith; Most likely the problem is with the @hostname bit not being recognised correctly ..(and cauing permissions problems) try to login with rt_user from your rt server to the database via mysql client and tail your sql server log files to determine why rt_user is being denied. Regards; Roy Keith A McDermott wrote: Thanks Odhiambo, Yes - I can connect fine through the standard mysql tools from the same host without issue however, I was trying rt_user previously. It actually does fail when connecting with rt_u...@hostname. As I manually moved the database over, manually create the user and manually granted the rights (I don't want to run make initialize-database against our very stable and department-wide mysql server), I'll look through and see what else I need to do. Keith Odhiambo Washington wrote: On Tue, Mar 31, 2009 at 4:59 PM, Keith A McDermott kmcde...@purdue.edu mailto:kmcde...@purdue.edu wrote: Hi there, I'm moving forward with my testing of RT 3.8.2. Setup: Virtual machine (Virtualbox) running RT3.8.2 in Debian Etch. Web port is forwarded to the virtual machine through the host but otherwise there is no access to the VM. I moved the database onto a production database server. RT_SiteConfig.pm has been altered to say: $DatabaseHost is set to dbproductionserver $DatabaseRTHost is set to the hostname of the vm host machine Problem: In the apache error logs, I get: DBI connect('dbname=rt;host=dbproductionhost','rt_user',...) failed: Access denied for user: 'rt_u...@hostmachinehostname' (Using password: YES) at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106 [Tue Mar 31 08:58:05 2009] [error] [client hostmachine.ip.goes.here] Connect Failed Access denied for user: 'rt_u...@hostmachinehostname' (Using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n And I get a 500 server error page returned to me. However, I can use the mysql command line tools from the virtual machine and connect just fine. Is there possibly a port that's being expected to be open that i need to forward or something else that I'm missing? This seemed like a pretty straightforward change in the beginning... It should be straighforward just as you say. Have you tested manually connecting to the DB like: mysql -h dbproductionserver -urt_u...@hostmachinehostname -pSec3t rt ?? Did it work? If not, then go to the dbproductionserver and give the necessary privileges for rt_user to connect: mysql GRANT ALL ON rt.* TO rt_u...@hostmachinehostname IDENTIFIED BY Sec3t; mysql flush privileges; -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The only time a woman really succeeds in changing a man is when he is a baby. - Natalie Wood ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Database relocated onto alternate server
Ignore. Someone showed me how to turn on DBI_Trace (which I'm liking quite a bit) and, I will admit, I found a subtle password mis-type I've missed for the past few weeks of tinkering. Fix that, revert a few code changes and voila - RT works. Thanks for the help, Keith Keith A McDermott wrote: More Info: I can successfully connect through mysql command line tools, php test script and through a test perl script with the default apache2 config. This all leads me to it being something with RT's setup specifically. Once I switch back to the RT apache config RT fails to connect to the db. This is when trying to connect from perl 5.8.8, apache2.2.3. The local database was 5.0.32 which worked fine whereas the remote database is 4.0.24 which does meet the minimum required version in the docs. Any other ideas I can try? Thanks, Keith Raed El-Hames wrote: Hi Keith; Most likely the problem is with the @hostname bit not being recognised correctly ..(and cauing permissions problems) try to login with rt_user from your rt server to the database via mysql client and tail your sql server log files to determine why rt_user is being denied. Regards; Roy Keith A McDermott wrote: Thanks Odhiambo, Yes - I can connect fine through the standard mysql tools from the same host without issue however, I was trying rt_user previously. It actually does fail when connecting with rt_u...@hostname. As I manually moved the database over, manually create the user and manually granted the rights (I don't want to run make initialize-database against our very stable and department-wide mysql server), I'll look through and see what else I need to do. Keith Odhiambo Washington wrote: On Tue, Mar 31, 2009 at 4:59 PM, Keith A McDermott kmcde...@purdue.edu mailto:kmcde...@purdue.edu wrote: Hi there, I'm moving forward with my testing of RT 3.8.2. Setup: Virtual machine (Virtualbox) running RT3.8.2 in Debian Etch. Web port is forwarded to the virtual machine through the host but otherwise there is no access to the VM. I moved the database onto a production database server. RT_SiteConfig.pm has been altered to say: $DatabaseHost is set to dbproductionserver $DatabaseRTHost is set to the hostname of the vm host machine Problem: In the apache error logs, I get: DBI connect('dbname=rt;host=dbproductionhost','rt_user',...) failed: Access denied for user: 'rt_u...@hostmachinehostname' (Using password: YES) at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106 [Tue Mar 31 08:58:05 2009] [error] [client hostmachine.ip.goes.here] Connect Failed Access denied for user: 'rt_u...@hostmachinehostname' (Using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n And I get a 500 server error page returned to me. However, I can use the mysql command line tools from the virtual machine and connect just fine. Is there possibly a port that's being expected to be open that i need to forward or something else that I'm missing? This seemed like a pretty straightforward change in the beginning... It should be straighforward just as you say. Have you tested manually connecting to the DB like: mysql -h dbproductionserver -urt_u...@hostmachinehostname -pSec3t rt ?? Did it work? If not, then go to the dbproductionserver and give the necessary privileges for rt_user to connect: mysql GRANT ALL ON rt.* TO rt_u...@hostmachinehostname IDENTIFIED BY Sec3t; mysql flush privileges; -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The only time a woman really succeeds in changing a man is when he is a baby. - Natalie Wood ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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: sa...@bestpractical.com 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Database relocated onto alternate server
On Tue, Mar 31, 2009 at 4:59 PM, Keith A McDermott kmcde...@purdue.eduwrote: Hi there, I'm moving forward with my testing of RT 3.8.2. Setup: Virtual machine (Virtualbox) running RT3.8.2 in Debian Etch. Web port is forwarded to the virtual machine through the host but otherwise there is no access to the VM. I moved the database onto a production database server. RT_SiteConfig.pm has been altered to say: $DatabaseHost is set to dbproductionserver $DatabaseRTHost is set to the hostname of the vm host machine Problem: In the apache error logs, I get: DBI connect('dbname=rt;host=dbproductionhost','rt_user',...) failed: Access denied for user: 'rt_u...@hostmachinehostname' (Using password: YES) at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106 [Tue Mar 31 08:58:05 2009] [error] [client hostmachine.ip.goes.here] Connect Failed Access denied for user: 'rt_u...@hostmachinehostname' (Using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n And I get a 500 server error page returned to me. However, I can use the mysql command line tools from the virtual machine and connect just fine. Is there possibly a port that's being expected to be open that i need to forward or something else that I'm missing? This seemed like a pretty straightforward change in the beginning... It should be straighforward just as you say. Have you tested manually connecting to the DB like: mysql -h dbproductionserver -urt_u...@hostmachinehostname -pSec3t rt ?? Did it work? If not, then go to the dbproductionserver and give the necessary privileges for rt_user to connect: mysql GRANT ALL ON rt.* TO rt_u...@hostmachinehostname IDENTIFIED BY Sec3t; mysql flush privileges; -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The only time a woman really succeeds in changing a man is when he is a baby. - Natalie Wood ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Database relocated onto alternate server
Thanks Odhiambo, Yes - I can connect fine through the standard mysql tools from the same host without issue however, I was trying rt_user previously. It actually does fail when connecting with rt_u...@hostname. As I manually moved the database over, manually create the user and manually granted the rights (I don't want to run make initialize-database against our very stable and department-wide mysql server), I'll look through and see what else I need to do. Keith Odhiambo Washington wrote: On Tue, Mar 31, 2009 at 4:59 PM, Keith A McDermott kmcde...@purdue.edu mailto:kmcde...@purdue.edu wrote: Hi there, I'm moving forward with my testing of RT 3.8.2. Setup: Virtual machine (Virtualbox) running RT3.8.2 in Debian Etch. Web port is forwarded to the virtual machine through the host but otherwise there is no access to the VM. I moved the database onto a production database server. RT_SiteConfig.pm has been altered to say: $DatabaseHost is set to dbproductionserver $DatabaseRTHost is set to the hostname of the vm host machine Problem: In the apache error logs, I get: DBI connect('dbname=rt;host=dbproductionhost','rt_user',...) failed: Access denied for user: 'rt_u...@hostmachinehostname' (Using password: YES) at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106 [Tue Mar 31 08:58:05 2009] [error] [client hostmachine.ip.goes.here] Connect Failed Access denied for user: 'rt_u...@hostmachinehostname' (Using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n And I get a 500 server error page returned to me. However, I can use the mysql command line tools from the virtual machine and connect just fine. Is there possibly a port that's being expected to be open that i need to forward or something else that I'm missing? This seemed like a pretty straightforward change in the beginning... It should be straighforward just as you say. Have you tested manually connecting to the DB like: mysql -h dbproductionserver -urt_u...@hostmachinehostname -pSec3t rt ?? Did it work? If not, then go to the dbproductionserver and give the necessary privileges for rt_user to connect: mysql GRANT ALL ON rt.* TO rt_u...@hostmachinehostname IDENTIFIED BY Sec3t; mysql flush privileges; -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The only time a woman really succeeds in changing a man is when he is a baby. - Natalie Wood ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Database relocated onto alternate server
Hi Keith; Most likely the problem is with the @hostname bit not being recognised correctly ..(and cauing permissions problems) try to login with rt_user from your rt server to the database via mysql client and tail your sql server log files to determine why rt_user is being denied. Regards; Roy Keith A McDermott wrote: Thanks Odhiambo, Yes - I can connect fine through the standard mysql tools from the same host without issue however, I was trying rt_user previously. It actually does fail when connecting with rt_u...@hostname. As I manually moved the database over, manually create the user and manually granted the rights (I don't want to run make initialize-database against our very stable and department-wide mysql server), I'll look through and see what else I need to do. Keith Odhiambo Washington wrote: On Tue, Mar 31, 2009 at 4:59 PM, Keith A McDermott kmcde...@purdue.edu mailto:kmcde...@purdue.edu wrote: Hi there, I'm moving forward with my testing of RT 3.8.2. Setup: Virtual machine (Virtualbox) running RT3.8.2 in Debian Etch. Web port is forwarded to the virtual machine through the host but otherwise there is no access to the VM. I moved the database onto a production database server. RT_SiteConfig.pm has been altered to say: $DatabaseHost is set to dbproductionserver $DatabaseRTHost is set to the hostname of the vm host machine Problem: In the apache error logs, I get: DBI connect('dbname=rt;host=dbproductionhost','rt_user',...) failed: Access denied for user: 'rt_u...@hostmachinehostname' (Using password: YES) at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106 [Tue Mar 31 08:58:05 2009] [error] [client hostmachine.ip.goes.here] Connect Failed Access denied for user: 'rt_u...@hostmachinehostname' (Using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n And I get a 500 server error page returned to me. However, I can use the mysql command line tools from the virtual machine and connect just fine. Is there possibly a port that's being expected to be open that i need to forward or something else that I'm missing? This seemed like a pretty straightforward change in the beginning... It should be straighforward just as you say. Have you tested manually connecting to the DB like: mysql -h dbproductionserver -urt_u...@hostmachinehostname -pSec3t rt ?? Did it work? If not, then go to the dbproductionserver and give the necessary privileges for rt_user to connect: mysql GRANT ALL ON rt.* TO rt_u...@hostmachinehostname IDENTIFIED BY Sec3t; mysql flush privileges; -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The only time a woman really succeeds in changing a man is when he is a baby. - Natalie Wood ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Database relocated onto alternate server
Hi there, I'm moving forward with my testing of RT 3.8.2. Setup: Virtual machine (Virtualbox) running RT3.8.2 in Debian Etch. Web port is forwarded to the virtual machine through the host but otherwise there is no access to the VM. I moved the database onto a production database server. RT_SiteConfig.pm has been altered to say: $DatabaseHost is set to dbproductionserver $DatabaseRTHost is set to the hostname of the vm host machine Problem: In the apache error logs, I get: DBI connect('dbname=rt;host=dbproductionhost','rt_user',...) failed: Access denied for user: 'rt_u...@hostmachinehostname' (Using password: YES) at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106 [Tue Mar 31 08:58:05 2009] [error] [client hostmachine.ip.goes.here] Connect Failed Access denied for user: 'rt_u...@hostmachinehostname' (Using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n And I get a 500 server error page returned to me. However, I can use the mysql command line tools from the virtual machine and connect just fine. Is there possibly a port that's being expected to be open that i need to forward or something else that I'm missing? This seemed like a pretty straightforward change in the beginning... -- Keith McDermott Desktop Support Specialist - PCN Physics Department, Purdue University Web:http://www.physics.purdue.edu/pcn E-mail: kmcde...@purdue.edu Phone: (765)49-45562 Address:525 Northwestern Avenue West Lafayette, IN 47907 Check out our new documentation at: http://www.physics.purdue.edu/PCN/doc/wiki ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com