A CentOS MySQL server, a .NET app, and me.

by Simon Duvall.

Hey all,

Ripping my hair out the past day trying to migrate an MS-SQL server app to a MySQL server. There's a front-end Windows Forms app in C#.NET 2.0 that reads data in from a Scantron machine and sends the data to a MS-SQL server, and several ASP.NET 2.0 forms that both submit data to the same database and display reports from it. Love this project...

Anyway, the MySQL server is on a CentOS 4 box. I kept getting this wonderful exception when I moved to Connector/.NET (from the MySQL site):

A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied.

I, of course, over-thought the problem and overlooked the simple fact that the CentOS box had it's iptables firewall blocking the default 3306 port.

So, for any of you also going through this debacle, check your iptables: iptables -L

Cheers,

~simon