Solved

MySQL Connection through a SmoothWall Firewall

Posted on 2004-09-30
4
359 Views
Last Modified: 2006-11-17
Hello Experts,
I have opened a port on our SmoothWall firewall to connect to a MySQL box from outside of the firewall.
When the expected IP address comes in the firewall forwards it to the MySQL box.
I keep getting a unable to connect error.  I am using PHP and here is my code

$hostname = "firewall IP address";
$username = "username";
$database_CAB = "database";
$password_CAB = "password";
$CON = mysql_pconnect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db($database, $CON);

If I need to post this in another section like PHP or Firewall, please let me know.
Any help would be greatly appreciated.
Thanks
Chad
0
Comment
Question by:ChadMarsh
  • 2
  • 2
4 Comments
 
LVL 13

Accepted Solution

by:
cLFlaVA earned 500 total points
ID: 12191954
are you declaring the server/port like this:

    $hostname = "servername:port";
0
 
LVL 2

Author Comment

by:ChadMarsh
ID: 12191984
Thank you..Always something simple.
0
 
LVL 13

Expert Comment

by:cLFlaVA
ID: 12192053
lol - glad to help, I originally avoided this question because the title scared me.  Next time dumb it down a bit :)

Maybe something like "I can't get a connection".
0
 
LVL 2

Author Comment

by:ChadMarsh
ID: 12192069
OK thanks for the tip.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now