Problems with MySQL on Win32.

jdtoronto has asked for the wisdom of the Perl Monks concerning the following question:

Esteemed monks,

Well, the problem isn't with MySQL, but it does seemt o be that there is some brain-deadedness about Windows and some other applications - specifically firewalls.

I have a Win32 app written in Perl/Tk using MySQL. Naturally I use DBI and Class::DBI. But I am finding that many Windows boxes have things like Widows Firewall and Norton Internet security that dont know how to spell 'localhost'! They see any attempt to connect to a socket as an attempt by some insidious and/or nefarious application to call home and divulge all your secrets - thus even the MySQL command line client cannot connect to the running server on the same machine.

Does anyone know of a DBI/Class::DBI friendly alternative to socket based connections?

jdtoronto

Comment on Problems with MySQL on Win32.

Replies are listed 'Best First'.
Re: Problems with MySQL on Win32. by vek (Prior) on Dec 08, 2005 at 07:45 UTC
Unless I'm missing something (highly possible), couldn't you go into the config of whatever firewall app is running on that Win32 box and allow your app through? I've recently had to do something similar on my Wife's WinXP box that had some McAfee Internet Firewall thingy installed. -- vek --	[reply]
Re^2: Problems with MySQL on Win32. by jdtoronto (Prior) on Dec 08, 2005 at 22:37 UTC
No, you aren't missing a thing! That is exactly the problem. But then we have to deal with Nortons, for example, in a recent live update they set everybodies security at maximum. If a flea scrathed in Uzebekiatan, you got an error message! People condn't even collect their email. So I am loking for a way to talk to MySQL without using a socket. Basically, Windows and Norton and MacAfee's don't know how localhost is spelled, so they just reject ANY attempt to connect to a socket, local or otherwise. I need aninstaller to install my product without having to go through lengthy support calls with clients who don't even know what software they have on the computer! Let alone hoe to use it. John	[reply]
Re^3: Problems with MySQL on Win32. by BrowserUk (Patriarch) on Dec 08, 2005 at 22:50 UTC
Have you consider/tried the named pipe connection option? See the docs Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error. Lingua non convalesco, consenesco et abolesco. -- Rule 1 has a caveat! -- Who broke the cabal? "Science is about questioning the status quo. Questioning authority". In the absence of evidence, opinion is indistinguishable from prejudice.	[reply] [d/l]
Re: Problems with MySQL on Win32. by kulls (Hermit) on Dec 08, 2005 at 05:03 UTC
can you post the error message?. so that we can able to identify whether it's mySQL issue or it's `DBI` issue. I guess it's mySQL. -kulls	[reply] [d/l]