Is firewall preventing MySQL access?
4 Message(s) by 4 Author(s) originally posted in mysql database
| From: Kevin Killion |
Date: Tuesday, September 05, 2006
|
I have 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 not connect to MySQL
server", with
code "10060" and
error "2003". The
port is 3306, which is
the default for MySQL access.
(The problem doesn't seem unique to MySQL: we're having the same
problem with PostgreSQL.)
I have 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
have not found much while web searching that explicitly confirms that.
More to the point, I do not 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
| From: Steven Musumeche |
Date: Wednesday, September 06, 2006
|
That does
sound like a firewall problem. The easiest
solution is to
have them
open port 3306 on the firewall.
-Steven
wrote in message:
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 not connect to MySQL
server", with code "10060" and error "2003". The port is 3306, which is
the default for MySQL access.
(The problem doesn't seem unique to MySQL: we're having the same
problem with PostgreSQL.)
I have 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
have not found much while web searching that explicitly confirms that.
More to the point, I do not 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
| From: Michael Austin |
Date: Friday, September 15, 2006
|
wrote in message:
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 not connect to MySQL
server", with code "10060" and error "2003". The port is 3306, which is
the default for MySQL access.
(The problem doesn't seem unique to MySQL: we're having the same
problem with PostgreSQL.)
I have 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
have not found much while web searching that explicitly confirms that.
More to the point, I do not 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've 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
| From: Bill F |
Date: Friday, April 06, 2007
|
"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 not connect with either of these ways you are being blocked
somewhere.
wrote in message:
That does sound like a firewall problem. The easiest solution is to have
them open port 3306 on the firewall.
-Steven
wrote in message:
I have 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 not connect to MySQL
server", with code "10060" and error "2003". The port is 3306, which is
the default for MySQL access.
(The problem doesn't seem unique to MySQL: we're having the same
problem with PostgreSQL.)
I have 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
have not found much while web searching that explicitly confirms that.
More to the point, I do not 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
Blogs related to Is firewall preventing MySQL access?
ZRM For MySQL Now Available On Ubuntu
ZRM for
MySQL is primarily designed to help
MySQL DBAs
prevent serious damage caused by data loss in the
... Ability to backup a database across a
firewall ... technical support, knowledgebase
access, software updates and security alerts.
December Mix
Access Device Fraud and Related Financial Crimes.pdf
... creating a transparent openbsd
firewall.pdf
... Sams - PHP and
MySQL Web Development, Second Edition.pdf
... preventing ddos attacks at the source - theory.pdf
...
BH #2 - /dev/null
Yes a
firewall can be used to
prevent the spread of internet worms by blocking
... False (
mySQL is cheaper, more secure, and provides better performance)
... A
firewall is a system designed to
prevent unauthorized
access to or from a
...
Questions about Rails Assignment
The
mysql client on rohan is not compatable with the rails, so I can either make one or the other work. A
firewall prevents off-campus
access to the database. So unless
... In lecture doc 21, slide 38, doesn't the 'verify'
prevent the
...
What is SQL Injection
If valid, the user is allowed
access. In other words, the web application that controls the login
... Microsoft
Access, MS SQL Server,
MySQL, and Filemaker Pro,
... How do I
prevent SQL Injection attacks? Firewalls and similar intrusion
...
Tips to Secure Linux Workstation
The
firewall is the front-line defense against remote attacks. It’s
... The lines
prevent anyone in the users group from having more than 150 processes,
... if you use
MySQL for local development, then it’s safer to limit its
...