samPHPweb : Could not connect to MySQL server

ZaKArthuR

27 sept. 2006

Aprés avoir réussi l'instalation de SAM, je tente de mettre en place le samPHPweb...

(hebergeur : OVH 90plan)

J'ai ouvert mes ports sur livebox et sur mon Firewall

Mais Voilà l'erreur qu'il me met :

status=err

SQL error=Could not connect to MySQL server

"config.php" :



  $commonpath = "./common";

  //Station general details
  $station  = "Kuube";
  $email    = "[email protected]";
  $logo     = "images/logo.gif";

  $stationid   = 75279;
  $sam["host"] = "http://kuube.no-ip.org"; 
  $sam["port"] = "1221";  

  //General options
  $privaterequests = true;  //If False, AudioRealm.com will handle the requests
  $showtoprequests = true;  //Must we show the top 10 requests on the now playing page?
  $requestdays     = 30;    //Show the top10 requests for the last xx days

  $showpic     = true; //Must we show pictures in now playing section?   
  $picture_dir = "pictures/"; //Directory where all your album pictures are stored
  $picture_na  = $picture_dir."na.gif"; //Use this picture if the song has no picture

  //Row colors used
  $darkrow  = "#dadada";
  $lightrow = "#F6F6F6";  

/* ## ======================================== ## */

 require_once("common/form.php");
 require_once("common/db.php");
 require_once("common/functions.php");

 // Load EGPCS vars into globals (emulates register_globals = On in php.ini)
if (!empty($HTTP_ENV_VARS)) while(list($name, $value) = each($HTTP_ENV_VARS)) $$name = $value;
if (!empty($HTTP_GET_VARS)) while(list($name, $value) = each($HTTP_GET_VARS)) $$name = $value;
if (!empty($HTTP_POST_VARS)) while(list($name, $value) = each($HTTP_POST_VARS)) $$name = $value;
if (!empty($HTTP_COOKIE_VARS)) while(list($name, $value) = each($HTTP_COOKIE_VARS)) $$name = $value;
if (!empty($HTTP_SERVER_VARS)) while(list($name, $value) = each($HTTP_SERVER_VARS)) $$name = $value;


 $db = new DBTable();

 //Your REMOTE MySQL database login details
 //IMPORTANT: This is the database login details for the database located on the WEBSERVER.
 $db->ReadXMLConfig("dbconfig.xml.php");

 //Your LOCAL MySQL database login details
 //This is the login details the webserver will use to contact the local database on the SAM Broadcaster server.
 //This is only used for making dedications from the request window.
 //$db->ReadXMLConfig("samdb.xml.php");
 $samlogin = $db->login; //In most cases the remote database will be the same as the local database.

 //Finally connect to the database
 $db->connect();

dbconfig.xml.php


<?/* 


MYSQL
http://kuube.no-ip.org
3306
SAMDB
admin
************



 */?>

MySQL config "myconfig.ini"


#This File was made using the WinMySQLAdmin 1.4 Tool
#24/09/2006 21:24:00

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/mysql
#bind-address=localhost
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=admin
password=admin

Merci de votre aide ;)

Je vous en remercie milles fois... :D

:wink: