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

[Autrijus Tang]

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.)

Thanks,
/Autrijus/
-------------- 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>