Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Inside firewall access to outside firewall MySQL server

 
   Database Help (Home) -> mySQL RSS
Next:  Error 5173  
Author Message
dstewart

External


Since: Feb 05, 2005
Posts: 4



(Msg. 1) Posted: Sat Feb 05, 2005 7:58 pm
Post subject: Inside firewall access to outside firewall MySQL server
Archived from groups: mailing>database>mysql (more info?)

I have 2 Suse 9.1 boxes with similar configurations. I'm in the
process of moving some PHP code from one server (192.168.0.100) to
another (192.168.0.102). MySQL is running on each server, and the same
PHP code can access its respective localhost databases and make queries
with no problem.

However, the code on the old server (.100) can access a MySQL server
(12.xx.xx.50) outside the firewall (192.168.0.1), while the code on the
new server cannot.

There is NO firewall rule regarding the two servers -- they are NOT
being accessed from outside the firewall.

Give me an idea where to start looking for the cure to the problem.

Danny

 >> Stay informed about: Inside firewall access to outside firewall MySQL server 
Back to top
Login to vote
dstewart

External


Since: Feb 05, 2005
Posts: 4



(Msg. 2) Posted: Sat Feb 12, 2005 10:44 am
Post subject: Re: Inside firewall access to outside firewall MySQL server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Aggro wrote:

 >
  > > Give me an idea where to start looking for the cure to the problem.
 >
 > Have you granted access to MySQL from outside? For example by
 >

 > 'password';

I am using the same routines, including the same user names and
passwords, from the 2nd server. The MySQL server sees the same IP
address (the firewall IP number() for the new server as the old server.
So, there is not a difference, is there?

 >> Stay informed about: Inside firewall access to outside firewall MySQL server 
Back to top
Login to vote
dstewart

External


Since: Feb 05, 2005
Posts: 4



(Msg. 3) Posted: Sat Feb 12, 2005 10:45 am
Post subject: Re: Inside firewall access to outside firewall MySQL server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Mike A wrote:
 > Can your new server access the internet at all?
 >
 > Is the default route, gateway, and DNS information correct?
 >
 > Try pinging the destination IP (12.xx.xx.50)...
 >
 >

Yes, it's fine for all functions except accessing the MySQL database
server.
 >> Stay informed about: Inside firewall access to outside firewall MySQL server 
Back to top
Login to vote
dstewart

External


Since: Feb 05, 2005
Posts: 4



(Msg. 4) Posted: Sat Feb 12, 2005 10:50 am
Post subject: Re: Inside firewall access to outside firewall MySQL server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Mike A wrote:
 > One other thing to check...
 >
 > Try using a different private IP address. Your firewall may have
DHCP
 > running, even if you are using static adresses on your lan, and may
not
 > accept connections outside of its configured IP address range. Maybe
..100
 > happens to be within its range and .102 isn't. Take your old server
 > offline for a few minutes and set the IP of the new server to
192.168.0.100.
 >
 > Good luck!
 >
 > Mike
 >

I'm sure this is not a network issue. The netmask inside the firewall
is 255.255.255.0. DHCP is handled from one box inside the firewall
(not the firewall). There are only a few DHCP addresses and all are
above .200 .
 >> Stay informed about: Inside firewall access to outside firewall MySQL server 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Installing MySQL-Cluster: can't start management server - Hi, I'm finally trying to set up a MySQL-CLuster with this tutorial ( http://dev.mysql.com/tech-resources/articles/mysql-cluster-for-two-servers.html ) on openSUSE 11.2. I've been past stage 1 and nearly stage 2, but when I try to start the management..

MySQL, MyODBC and ACCESS 2003 - Ok I have an interesting problem. I have written a database in Access to connect to our web shop and update prices etc from a supplier feed. It works almost perfectly! The prices are doubles, I am using ADO in access to connect via myodbc (with options....

Tuning Mysql 4.1.10 - I have a freebsd box with 1 gig of memory for mysql/php, I was wondering what my my.cnf should look like, I am doing alot of searches and writes on ISAM tables, I currently have the following: [client] port=3306 socket=/tmp/mysql.sock [mysqld]..

Mysql InnoDB PHP - i have a strange problem : MySQL 4.0.21 innodb and php 4.3.9-1 all tables are in innodb type. For a simple select statement, sometimes i get result and sometimes nothing (i.e mysql_num_rows()>0 or mysql_num_rows()==0). It's a random behaviour. If my....

Installation and config of MYSQL - Hi, Need help. Installed Mysql in Redhat 9.0 workstation. I have installed MYSQL,Appache,PHP. PHP,Appache installation is fine and intergration is also working fine. I have installed and configured MYSQL Problem : I cannot log into MYSQL database either...
   Database Help (Home) -> mySQL All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]