Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[F] [Solved] Installation Script : DB Host value
#1
There seems to be a problem in the install script, when I enter another value than 'localhost' in the DB Host field. Every time, I put an DNS value in the field, the script tells me, that the host cannot be reached.

I've written a short php script to prove, that the DB Hosts (I've tested 3 seperate hosts) are reachable - everyone can be reached from another host (so they are NOT bound to the 'localhost' interface only).

Here are some further Informations :

- The MySQL Hosts are reachable from outside - they are not bound to the 'localhost' interface only.
- I've tested 3 different MySQL hosts : 2 of my webspace providers and one I use for local evaluation and development in my LAN. Same result ...
- I've placed my test script (see below) on the same machine (webspace) as the installation script - the 2 DB servers of my web providers can
be reached from there (the one MySQL server in my LAN is not reachable from the internet).

I was also able to install several other BB Systems on the same Webspace / Database combination without any problems.

FYI : Here is the script, I've tested the connectivity with :

<?PHP

   $host = '<value>';
   $user = '<value>';
   $pass = '<value>';
   $db   = '<value>';
  

   $link = mysql_connect($host, $user, $pass);
   if (!$link) 
   {
      die('Could not connect: ' . mysql_error());
   }
   else
   {
      echo 'Connected to host \''.$host.'\' successfully<br>';
      
   
      $db_selected = mysql_select_db($db, $link);
      
      if (!$db_selected) 
      {
         die ('Can\'t use '.$db.' : ' . mysql_error());
      }
      else
      {
         echo 'Selected database \''.$db.'\' successfully';
      }
   
      mysql_close($link);
   
   }

?>

If you have any further questions - just let me know ...


Messages In This Thread
[F] [Solved] Installation Script : DB Host value - by bollmann - 05-13-2007, 11:10 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)