SOLUTION TO: [rt-users] MySQL ODBC question

[Ennis William McCaffrey]

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 at Mail.TWCGB.NET