[rt-users] Allowing remote access to RT mySQL

2011-05-12 Thread Vance Walsh
So this may seem rudimentary but I am not a solid SQL tech. My Boss would like to make remote ODBC connections to RT's DB. Is there a set of instructions I can review to set this up for him? Thanks in advance -Vance --- Vance Walsh Network and Systems Administrator Concord Academy - Concord,

Re: [rt-users] Allowing remote access to RT mySQL

2011-05-12 Thread Ruslan Zakirov
Hi, On Thu, May 12, 2011 at 10:43 PM, Vance Walsh vance_wa...@concordacademy.org wrote: So this may seem rudimentary but I am not a solid SQL tech. My Boss would like to make remote ODBC connections to RT's DB. Is there a set of instructions I can review to set this up for him? It's incorrect

Re: [rt-users] Allowing remote access to RT mySQL

2011-05-12 Thread Vance Walsh
Ruslan, Thanks for the response, I was more curious if there is anything specific to how RT connects to MySQL that would not allow for me to setup standard GRANT permissions to the DB I have tried the standard GRANT ALL PRIVILEGES ON *.* TO vwalsh@10.2.8.17 IDENTIFIED by Password; and have not

Re: [rt-users] Allowing remote access to RT mySQL

2011-05-12 Thread Rob Munsch
Sent: Thursday, May 12, 2011 3:04 PM To: r...@bestpractical.com Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Allowing remote access to RT mySQL Ruslan, Thanks for the response, I was more curious if there is anything

Re: [rt-users] Allowing remote access to RT mySQL

2011-05-12 Thread Ruslan Zakirov
Hi, Nothing RT specific. mysql by default may be configured without listening network. You may have firewall that blocks connections. Start from telnet or mysql client on anther machine. On Thu, May 12, 2011 at 11:03 PM, Vance Walsh vance_wa...@concordacademy.org wrote: Ruslan, Thanks for the