MySQL Connection through a SmoothWall Firewall

Posted on 2004-09-30
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.
Question by:ChadMarsh
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 13

Accepted Solution

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

    $hostname = "servername:port";

Author Comment

ID: 12191984
Thank you..Always something simple.
LVL 13

Expert Comment

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".

Author Comment

ID: 12192069
OK thanks for the tip.

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (  Today ( you would not use MySQL…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor ( Top Charts is a view in which you can set seve…

690 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