Weer probleem met mysql

MySQL, FireBird, MSSQL, etc..
Plaats reactie
John Winter

Weer probleem met mysql

Ongelezen bericht door John Winter »

Hoi, op deze http://www.hitradiomegastar.nl/Jukebox/playing.php
heb ik momenteel een probleem.....

Weet iemand wat het is

Code: Selecteer alles

Warning: mysql_pconnect() [function.mysql-pconnect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /home/radiomonta/domains/hitradiomegastar.nl/public_html/Jukebox/common/db.php on line 43

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/radiomonta/domains/hitradiomegastar.nl/public_html/Jukebox/common/db.php on line 44

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/radiomonta/domains/hitradiomegastar.nl/public_html/Jukebox/common/db.php on line 58

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/radiomonta/domains/hitradiomegastar.nl/public_html/Jukebox/common/db.php on line 59
status=err
SQL error=2013
SQL error string=Lost connection to MySQL server at 'reading initial communication packet', system error: 111
SQL=SELECT songlist.*, historylist.listeners as listeners, historylist.requestID as requestID, historylist.date_played as starttime FROM historylist,songlist WHERE (historylist.songID = songlist.ID) AND (songlist.songtype='S') ORDER BY historylist.date_played DESC LIMIT 6
Ik post gelijk ff de config en db config mee :


Config.php :

Code: Selecteer alles

<?
 
/* ## ======================================== ## */  
  $commonpath = "./common";
  
  //Station general details
  $station  = "My station name";
  $email    = "email@mailbox.com";
  $logo     = "images/logo.gif";
  
  //Your CHAT details
  $chat["room"] = "#audiorealm";
  $chat["host"] = "hogan.freenode.net";
  $chat["port"] = "6667";
  
  //Your MySQL database login details
  $dblogin["host"]     = "85.149.212.32";
  $dblogin["username"] = "Johnny";
  $dblogin["password"] = "xxxxxx";
  $dblogin["database"] = "samdb";
  
  $stationID = 0; //The ID of your station on AudioRealm.com
  $sam["host"] = "85.149.212.32"; //The IP address of the machine SAM is running on (DO NOT use a local IP address like 127.0.0.1 or 192.x.x.x)
  $sam["port"] = "1221"; //The port SAM handles HTTP requests on. Usually 1221.
  
  //General options
  $showpic         = true; //Must we show pictures in now playing section? 
  $privaterequests = true;  //If False, AudioRealm will handle the requests
  $top10requests   = true;  //Must we show the top 10 requests on the now playing page?
  
  $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();
 $db->connectdb($dblogin,$dblogin["database"]);
  
?>
DBconfig.php:

Code: Selecteer alles

<CONFIG application="SAM" version="3.1.6 (RC2)">
	<Database>
		<Driver>MYSQL</Driver>
		<Host>85.149.212.32</Host>
		<Port>3306</Port>
		<Database>samdb</Database>
		<Username>Johnny</Username>
		<Password>xxx</Password>
	</Database>
</CONFIG>

Hopelijk kan iemand hier iets mee..
Gebruikersavatar
Kees
Beheerder
Berichten: 3165
Lid geworden op: 28 nov 2005, 22:07
SAM-versie: 4.2.2.*
Database: MySQL
Windows: 11
Locatie: Bergen op Zoom
Contacteer:

Re: Weer probleem met mysql

Ongelezen bericht door Kees »

Stuur je wachtwoord eens naar mijn info email adres.
Plaats reactie
  • Vergelijkbare Onderwerpen
    Reacties
    Weergaves
    Laatste bericht