Weird issue with RT/mySQL DB queries

RT Users
1

I’ve been trying to connect to mySQL from a separate host so that I can run
queries to generate a ticket report and have had no luck. I have added a
separate user for this and still can’t get this to work. I did make sure to
permit from all hosts. This is on the Windows port of RT, version 3.0.10
rc1 w/ mySQL version 4.0.17. I have tried this from CLI as well as the
admin GUI. Any ideas?

Thanks,

Travis Niedens
Network Manager
University of Redlands

Phone: (909) 748-6328
Fax: (909) 793-2029
VoIP Phone: (909) 799-4778
VoIP Extension: 4778

“Defending the Network from Human Nature”… Cisco

2

I’ve been trying to connect to mySQL from a separate host so that I can run
queries to generate a ticket report and have had no luck. I have added a
separate user for this and still can’t get this to work. I did make sure to
permit from all hosts. This is on the Windows port of RT, version 3.0.10
rc1 w/ mySQL version 4.0.17. I have tried this from CLI as well as the
admin GUI. Any ideas?

You need to edit global settings in /Edit/Global/Basic/, enable the
“DatabaseBindRemote” option, then restart the mysql server, then restart
apache. The DB by default only binds to localhost for security reasons.

(This is a win32-port specific question.)

Thanks,
/Autrijus/