Click here to get back home

Is firewall preventing MySQL access?

 HomeNewsGroups | Search | About
 mailing.database.mysql    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
Is firewall preventing MySQL access? Kevin Killion 09-05-2006
Get Chitika Premium
Posted by Kevin Killion on September 5, 2006, 10:06 am
Please log in for more thread options

I've recently features to a system by making use of some simple MySQL
access routines. It works fine at most test locations, correctkly
accessing a MySQL database on an internet server.

However, at certain test sites, I cannot access the database. We're
online, and I can access web files, for example. But when trying to say
hello to that MySQL database, the program fails at the
"mysql_real_connect" call. The message is "Can't connect to MySQL
server", with code "10060" and error "2003". The port is 3306, which is
the default for MySQL access.

(The problem does not seem unique to MySQL: we're having the same
problem with PostgreSQL.)

I've been told by an IT guy at one of these test sites, a very large
corporation, that their company firewall is probably what is keeping the
system from accessing that remore database. Sounds plausible, but I
haven't found much while web searching that explicitly confirms that.
More to the point, I don't have ANY clues or ideas from anywhere on how
to resolve this problem at client sites that seem to prohibit MySQL
access of a remore database.

Suggestions?

Confirmation that it's a firewall problem?

Ideas?

Encouragement?

*** THANKS! ***

Kevin Killion

Posted by Steven Musumeche on September 6, 2006, 10:56 am
Please log in for more thread options
That does sound like a firewall problem. The easiest solution is to
have them open port 3306 on the firewall.

-Steven

Kevin Killion wrote:
> I've recently features to a system by making use of some simple MySQL
> access routines. It works fine at most test locations, correctkly
> accessing a MySQL database on an internet server.
>
> However, at certain test sites, I cannot access the database. We're
> online, and I can access web files, for example. But when trying to say
> hello to that MySQL database, the program fails at the
> "mysql_real_connect" call. The message is "Can't connect to MySQL
> server", with code "10060" and error "2003". The port is 3306, which is
> the default for MySQL access.
>
> (The problem does not seem unique to MySQL: we're having the same
> problem with PostgreSQL.)
>
> I've been told by an IT guy at one of these test sites, a very large
> corporation, that their company firewall is probably what is keeping the
> system from accessing that remore database. Sounds plausible, but I
> haven't found much while web searching that explicitly confirms that.
> More to the point, I don't have ANY clues or ideas from anywhere on how
> to resolve this problem at client sites that seem to prohibit MySQL
> access of a remore database.
>
> Suggestions?
>
> Confirmation that it's a firewall problem?
>
> Ideas?
>
> Encouragement?
>
> *** THANKS! ***
>
> Kevin Killion

Posted by Bill F on April 6, 2007, 9:35 pm
Please log in for more thread options
"telnet MySQLServer 3306" for me returned
----
On Wed, 06 Sep 2006 09Connected to MySQLServer.
Escape character is '^]'.
0
3.23.41-Max-logg1YPc$%.V
----
The characters after log were random & 3.23.41 is my version I think.
From Galeon on Debian Linux it return a random character .exe file.

If you can't connect with either of these ways you are being blocked
somewhere.

:56:02 -0500, Steven Musumeche wrote:

> That does sound like a firewall problem. The easiest solution is to have
> them open port 3306 on the firewall.
>
> -Steven
>
> Kevin Killion wrote:
>> I've recently features to a system by making use of some simple MySQL
>> access routines. It works fine at most test locations, correctkly
>> accessing a MySQL database on an internet server.
>>
>> However, at certain test sites, I cannot access the database. We're
>> online, and I can access web files, for example. But when trying to say
>> hello to that MySQL database, the program fails at the
>> "mysql_real_connect" call. The message is "Can't connect to MySQL
>> server", with code "10060" and error "2003". The port is 3306, which is
>> the default for MySQL access.
>>
>> (The problem does not seem unique to MySQL: we're having the same
>> problem with PostgreSQL.)
>>
>> I've been told by an IT guy at one of these test sites, a very large
>> corporation, that their company firewall is probably what is keeping the
>> system from accessing that remore database. Sounds plausible, but I
>> haven't found much while web searching that explicitly confirms that.
>> More to the point, I don't have ANY clues or ideas from anywhere on how
>> to resolve this problem at client sites that seem to prohibit MySQL
>> access of a remore database.
>>
>> Suggestions?
>>
>> Confirmation that it's a firewall problem?
>>
>> Ideas?
>>
>> Encouragement?
>>
>> *** THANKS! ***
>>
>> Kevin Killion


Posted by Michael Austin on September 15, 2006, 9:39 pm
Please log in for more thread options
Kevin Killion wrote:
> I've recently features to a system by making use of some simple MySQL
> access routines. It works fine at most test locations, correctkly
> accessing a MySQL database on an internet server.
>
> However, at certain test sites, I cannot access the database. We're
> online, and I can access web files, for example. But when trying to say
> hello to that MySQL database, the program fails at the
> "mysql_real_connect" call. The message is "Can't connect to MySQL
> server", with code "10060" and error "2003". The port is 3306, which is
> the default for MySQL access.
>
> (The problem does not seem unique to MySQL: we're having the same
> problem with PostgreSQL.)
>
> I've been told by an IT guy at one of these test sites, a very large
> corporation, that their company firewall is probably what is keeping the
> system from accessing that remore database. Sounds plausible, but I
> haven't found much while web searching that explicitly confirms that.
> More to the point, I don't have ANY clues or ideas from anywhere on how
> to resolve this problem at client sites that seem to prohibit MySQL
> access of a remore database.
>
> Suggestions?
>
> Confirmation that it's a firewall problem?
>
> Ideas?
>
> Encouragement?
>
> *** THANKS! ***
>
> Kevin Killion

Unless you have a business reason to do so, I block those ports as well to keep
hackers from attacking mysql databases. IMPO - Any corporation NOT blocking it
is either very stupid or very ignorant. And the difference is - one can be
cured and unfortunately the other cannot.

--
Michael Austin.
DBA Consultant

Similar ThreadsPosted
mysql-cluster firewall December 8, 2006, 8:56 am
Access and MySQl July 5, 2005, 2:27 pm
Access and MYSQL May 31, 2006, 9:22 am
FYI: migration from Access to mySQL June 6, 2005, 1:42 pm
MS Access and MySQL databases July 3, 2005, 8:23 pm
Switching from Ms Access to MySql November 13, 2005, 5:21 am
Importing MySQL in MS Access January 31, 2006, 11:23 pm
MS Access, MySQL & MyODBC ..... March 16, 2006, 9:35 am
Connecting to MYSQL via MS Access April 1, 2006, 1:49 pm
ODBC Access -- MySQL (on the web) December 1, 2006, 7:08 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap