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
I’m posting this summary for future reference:
PROBLEM SUMMARY: MyODBC connection failure
I have rt 3.4.1 set up on a Fedora Core 3 machine, and RT is running fine.
I have installed the MyODBC connector on this machine.
I have installed the MyODBC connector on a Windows 2000 server.
It is from this machine that I want to access RT.
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)
Password: ***** (my rt-user password on MySQL)
When I try to conenct I get the following error:
[MySQL][ODBC 3.51 Driver]Can’t connect to MySQL server on
rt_user can access RT from the host RT is running on.
MyODBC does not connect from the Windows machine (172.16.0.30) to the RT server (172.16.0.16).
Does anybody have a clue as to how to set up MyODBC?
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!)
A. iptables --flush
iptables -t nat --flush
iptables -t mangle --flush
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).
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 ‘*******’;
Time Warner Cable
Digital Network Engineer
1001 West Kennedy Avenue
PO Box 145
Kimberly, WI 54136
(920) 831-9220 Office
(920) 378-0416 Cell