[Rt-users] Weird issue with RT/mySQL DB queries

Autrijus Tang autrijus at autrijus.org
Fri Apr 16 14:23:14 EDT 2004

On Fri, Apr 09, 2004 at 03:27:39PM -0700, Niedens, Travis wrote:
> 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.)

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20040417/7e8f8f13/attachment.sig>

More information about the rt-users mailing list