SOLUTION TO: MySQL ODBC question

I want to give a hearty “THANK YOU!” to the rt-users mailing list for your assistance with the MyODBC connection problem; which is now
solved.

RT rocks!

: ))

I’m posting this summary for future reference:

PROBLEM SUMMARY: MyODBC connection failure

PROBLEM DESCRIPTION:

  1. I have rt 3.4.1 set up on a Fedora Core 3 machine, and RT is running fine.

  2. I have installed the MyODBC connector on this machine.

  3. I have installed the MyODBC connector on a Windows 2000 server.
    It is from this machine that I want to access RT.

  4. On the Windows machine, I have the ODBC set up as follows:

    Data Source Name: RT3
    Description: MySQL ODBC 3.51 Driver DSN
    Server: 172.16.0.16 (the ip address of my rt server)
    User: rt_user
    Password: ***** (my rt-user password on MySQL)
    Database: rt3

    When I try to conenct I get the following error:

    [MySQL][ODBC 3.51 Driver]Can’t connect to MySQL server on
    ’172.16.0.16’(10065)

  5. rt_user can access RT from the host RT is running on.

  6. MyODBC does not connect from the Windows machine (172.16.0.30) to the RT server (172.16.0.16).

  7. Does anybody have a clue as to how to set up MyODBC?

SOLUTION:

  1. RT running on linux may have the iptables firewall installed, so a hole has to be punched thru the firewall for 3306/tcp.

    In my case, I am behind a Cisco Pix firewall so I just did the following
    based upon the following web site: (this just disabled iptables, not a good thing for everybody!)

     	http://www.siliconvalleyccie.com/linux-hn/iptables-intro.htm
    

    A. iptables --flush
    iptables -t nat --flush
    iptables -t mangle --flush

    iptables --delete-chain
    iptables -t nat --delete-chain
    iptables -t mangle --delete-chain

    B. service iptables save

    Please note that this is only a quick and dirty second solution, and that proper attention should be paid to your RT servers
    security. What I’ve done is to disable iptables (the Linux Fedora Core 3 firewall software).

  2. The rt_user must be granted priviliges to access the rt3 database from the Windows machine (172.16.0.30 in my case).

    A. grant all ON . TO ‘rt_user’@‘172.16.0.30’ IDENTIFIED BY ‘*******’;

Ennis McCaffrey

Time Warner Cable
Digital Network Engineer

1001 West Kennedy Avenue
PO Box 145
Kimberly, WI 54136

(920) 831-9220 Office
(920) 378-0416 Cell

Ennis@Mail.TWCGB.NET