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:
-
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)
User: rt_user
Password: ***** (my rt-user password on MySQL)
Database: rt3When 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) -
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?
SOLUTION:
-
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 --flushiptables --delete-chain
iptables -t nat --delete-chain
iptables -t mangle --delete-chainB. 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 ‘*******’;
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