无法使用外部网站连接到MariaDB数据库

yqyhoc1h  于 4个月前  发布在  其他
关注(0)|答案(1)|浏览(62)

我正在尝试创建一个Geometry Dash专用服务器（我想将其托管在我的Synology NAS上），但是URL太长，所以我正在创建另一个网站来连接到我的数据库。我有一个文件“connection.php”：

<?php
$servername = "X.X.X.X";
$port = 3307;
$username = "root";
$password = "";
$dbname = "database";
?>

字符串
getGJLevels.php：

<?php
//header
chdir(dirname(__FILE__));
include "../lib/connection.php";
require_once "../lib/GJPCheck.php";
require_once "../lib/exploitPatch.php";
require_once "../lib/mainLib.php";
$gs = new mainLib();
require "../lib/generateHash.php";

//initializing variables
$lvlstring = ""; $userstring = ""; $songsstring = ""; $lvlsmultistring = []; $str = ""; $order = "uploadDate";
$orderenabled = true; $ordergauntlet = false;
$params = array("NOT unlisted = 1");
$morejoins = "";

if(!empty($_POST["gameVersion"])){
  $gameVersion = ExploitPatch::number($_POST["gameVersion"]);
}else{
  $gameVersion = 0;
}
if(!is_numeric($gameVersion)){
  exit("-1");
}
if($gameVersion == 20){
  $binaryVersion = ExploitPatch::number($_POST["binaryVersion"]);
  if($binaryVersion > 27){
    $gameVersion++;
  }
}
if(!empty($_POST["type"])){
  $type = ExploitPatch::number($_POST["type"]);
}else{
  $type = 0;
}
if(!empty($_POST["diff"])){
  $diff = ExploitPatch::numbercolon($_POST["diff"]);
}else{
  $diff = "-";
}

//ADDITIONAL PARAMETERS
if($gameVersion==0){
  $params[] = "levels.gameVersion <= 18";
}else{
  $params[] = "levels.gameVersion <= '$gameVersion'";
}
if(!empty($_POST["featured"]) AND $_POST["featured"]==1){
  $params[] = "starFeatured = 1";
}
if(!empty($_POST["original"]) AND $_POST["original"]==1){
  $params[] = "original = 0";
}
if(!empty($_POST["coins"]) AND $_POST["coins"]==1){
    $params[] = "starCoins = 1 AND NOT levels.coins = 0";
}
if(!empty($_POST["epic"]) AND $_POST["epic"]==1){
  $params[] = "starEpic = 1";
}
if(!empty($_POST["uncompleted"]) AND $_POST["uncompleted"]==1){
  $completedLevels = ExploitPatch::numbercolon($_POST["completedLevels"]);
  $params[] = "NOT levelID IN ($completedLevels)";
}
if(!empty($_POST["onlyCompleted"]) AND $_POST["onlyCompleted"]==1){
  $completedLevels = ExploitPatch::numbercolon($_POST["completedLevels"]);
  $params[] = "levelID IN ($completedLevels)";
}
if(!empty($_POST["song"])){
  if(empty($_POST["customSong"])){
    $song = ExploitPatch::number($_POST["song"]);
    $song = $song -1;
    $params[] = "audioTrack = '$song' AND songID = 0";
  }else{
    $song = ExploitPatch::number($_POST["song"]);
    $params[] = "songID = '$song'";
  }
}
if(!empty($_POST["twoPlayer"]) AND $_POST["twoPlayer"]==1){
  $params[] = "twoPlayer = 1";
}
if(!empty($_POST["star"])){
  $params[] = "NOT starStars = 0";
}
if(!empty($_POST["noStar"])){
  $params[] = "starStars = 0";
}
if(!empty($_POST["gauntlet"])){
  $ordergauntlet = true;
  $order = "starStars";
  $gauntlet = ExploitPatch::remove($_POST["gauntlet"]);
  $query=$db->prepare("SELECT * FROM gauntlets WHERE ID = :gauntlet");
  $query->execute([':gauntlet' => $gauntlet]);
  $actualgauntlet = $query->fetch();
  $str = $actualgauntlet["level1"].",".$actualgauntlet["level2"].",".$actualgauntlet["level3"].",".$actualgauntlet["level4"].",".$actualgauntlet["level5"];
  $params[] = "levelID IN ($str)";
  $type = -1;
}
if(!empty($_POST["len"])){
  $len = ExploitPatch::numbercolon($_POST["len"]);
}else{
  $len = "-";
}
if($len != "-" AND !empty($len)){
  $params[] = "levelLength IN ($len)";
}

//DIFFICULTY FILTERS
switch($diff){
  case -1:
    $params[] = "starDifficulty = '0'";
    break;
  case -3:
    $params[] = "starAuto = '1'";
    break;
  case -2:
    if(!empty($_POST["demonFilter"])){
      $demonFilter = ExploitPatch::number($_POST["demonFilter"]);
    }else{
      $demonFilter = 0;
    }
    $params[] = "starDemon = 1";
    switch($demonFilter){
      case 1:
        $params[] = "starDemonDiff = '3'";
        break;
      case 2:
        $params[] = "starDemonDiff = '4'";
        break;
      case 3:
        $params[] = "starDemonDiff = '0'";
        break;
      case 4:
        $params[] = "starDemonDiff = '5'";
        break;
      case 5:
        $params[] = "starDemonDiff = '6'";
        break;
      default:
        break;
    }
    break;
  case "-";
    break;
  default:
    if($diff){
      $diff = str_replace(",", "0,", $diff) . "0";
      $params[] = "starDifficulty IN ($diff) AND starAuto = '0' AND starDemon = '0'";
    }
    break;
}
//TYPE DETECTION
//TODO: the 2 non-friend types that send GJP in 2.11
if(!empty($_POST["str"])){
  $str = ExploitPatch::remove($_POST["str"]);
}
if(isset($_POST["page"]) AND is_numeric($_POST["page"])){
  $offset = ExploitPatch::number($_POST["page"]) . "0";
}else{
  $offset = 0;
}
switch($type){
  case 0:
  case 15: //most liked, changed to 15 in GDW for whatever reason
    $order = "likes";
    if(!empty($str)){
      if(is_numeric($str)){
        $params = array("levelID = '$str'");
      }else{
        $params[] = "levelName LIKE '%$str%'";
      }
    }
    break;
  case 1:
    $order = "downloads";
    break;
  case 2:
    $order = "likes";
    break;
  case 3: //TRENDING
    $uploadDate = time() - (7 * 24 * 60 * 60);
    $params[] = "uploadDate > $uploadDate ";
    $order = "likes";
    break;
  case 5:
    $params[] = "levels.userID = '$str'";
    break;
  case 6: //featured
  case 17: //featured GDW //TODO: make this list of daily levels
    $params[] = "NOT starFeatured = 0";
    $order = "rateDate DESC,uploadDate";
    break;
  case 16: //HALL OF FAME
    $params[] = "NOT starEpic = 0";
    $order = "rateDate DESC,uploadDate";
    break;
  case 7: //MAGIC
    $params[] = "objects > 9999";
    break;
  case 10: //MAP PACKS
  case 19: //unknown but same as map packs (on real GD type 10 has star rated filter and 19 doesn't)
    $order = false;
    $params[] = "levelID IN ($str)";
    break;
  case 11: //AWARDED
    $params[] = "NOT starStars = 0";
    $order = "rateDate DESC,uploadDate";
    break;
  case 12: //FOLLOWED
    $followed = ExploitPatch::numbercolon($_POST["followed"]);
    $params[] = "users.extID IN ($followed)";
    break;
  case 13: //FRIENDS
    $accountID = GJPCheck::getAccountIDOrDie();
    $peoplearray = $gs->getFriends($accountID);
    $whereor = implode(",", $peoplearray);
    $params[] = "users.extID IN ($whereor)";
    break;
  case 21: //DAILY SAFE
    $morejoins = "INNER JOIN dailyfeatures ON levels.levelID = dailyfeatures.levelID";
    $params[] = "dailyfeatures.type = 0";
    $order = "dailyfeatures.feaID";
    break;
  case 22: //WEEKLY SAFE
    $morejoins = "INNER JOIN dailyfeatures ON levels.levelID = dailyfeatures.levelID";
    $params[] = "dailyfeatures.type = 1";
    $order = "dailyfeatures.feaID";
    break;
  case 23: //EVENT SAFE (assumption)
    $morejoins = "INNER JOIN dailyfeatures ON levels.levelID = dailyfeatures.levelID";
    $params[] = "dailyfeatures.type = 2";
    $order = "dailyfeatures.feaID";
    break;
}
//ACTUAL QUERY EXECUTION
$querybase = "FROM levels LEFT JOIN songs ON levels.songID = songs.ID LEFT JOIN users ON levels.userID = users.userID $morejoins";
if(!empty($params)){
  $querybase .= " WHERE (" . implode(" ) AND ( ", $params) . ")";
}
$query = "SELECT levels.*, songs.ID, songs.name, songs.authorID, songs.authorName, songs.size, songs.isDisabled, songs.download, users.userName, users.extID $querybase $morejoins ";
if($order){
  if($ordergauntlet){
    $query .= "ORDER BY $order ASC";
  }else{
    $query .= "ORDER BY $order DESC";
  }
}
$query .= " LIMIT 10 OFFSET $offset";
//echo $query;
$countquery = "SELECT count(*) $querybase";
//echo $query;
$query = $db->prepare($query);
$query->execute();
//echo $countquery;
$countquery = $db->prepare($countquery);
$countquery->execute();
$totallvlcount = $countquery->fetchColumn();
$result = $query->fetchAll();
$levelcount = $query->rowCount();
foreach($result as &$level1) {
  if($level1["levelID"]!=""){
    $lvlsmultistring[] = ["levelID" => $level1["levelID"], "stars" => $level1["starStars"], 'coins' => $level1["starCoins"]];
    if(!empty($gauntlet)){
      $lvlstring .= "44:$gauntlet:";
    }
    $lvlstring .= "1:".$level1["levelID"].":2:".$level1["levelName"].":5:".$level1["levelVersion"].":6:".$level1["userID"].":8:10:9:".$level1["starDifficulty"].":10:".$level1["downloads"].":12:".$level1["audioTrack"].":13:".$level1["gameVersion"].":14:".$level1["likes"].":17:".$level1["starDemon"].":43:".$level1["starDemonDiff"].":25:".$level1["starAuto"].":18:".$level1["starStars"].":19:".$level1["starFeatured"].":42:".$level1["starEpic"].":45:".$level1["objects"].":3:".$level1["levelDesc"].":15:".$level1["levelLength"].":30:".$level1["original"].":31:".$level1['twoPlayer'].":37:".$level1["coins"].":38:".$level1["starCoins"].":39:".$level1["requestedStars"].":46:1:47:2:40:".$level1["isLDM"].":35:".$level1["songID"]."|";
    if($level1["songID"]!=0){
      $song = $gs->getSongString($level1);
      if($song){
        $songsstring .= $song . "~:~";
      }
    }
    $userstring .= $gs->getUserString($level1)."|";
  }
}
$lvlstring = substr($lvlstring, 0, -1);
$userstring = substr($userstring, 0, -1);
$songsstring = substr($songsstring, 0, -3);
echo $lvlstring."#".$userstring;
if($gameVersion > 18){
  echo "#".$songsstring;
}
echo "#".$totallvlcount.":".$offset.":10";
echo "#";
echo GenerateHash::genMulti($lvlsmultistring);
?>

型
但是当它连接到数据库时，我得到了错误
“连接失败：SQLSTATE[HY 000] [2002]连接被拒绝”
和
“致命错误：未捕获错误：在/home/runner/openedgdps/incl/levels/getGJLevels中调用成员函数prepare（）on null.php：252堆栈跟踪：#0 /home/runner/openedgdps/getGJLevels21.php（2）：include（）#1 {main} thrown in/home/runner/openedgdps/incl/levels/getGJLevels.php on line 252”，can someone help me？
谢谢
我尝试了所有我在互联网上找到的解决方案，但没有任何工作。

mariadb

1条答案

按热度按时间
j13ufse2

j13ufse21#

这通常表明您的应用程序无法建立到MariaDB数据库服务器的连接。可能服务器没有运行，或者主机或端口不正确。可能有防火墙阻止连接或其他网络问题。请仔细检查您的凭据（用户/密码）。检查文档和bind-address属性的配置检查MariaDB错误日志，可能位于/var/log/mariadb/mariadb.log或/var/log/mysql/error.log中。

赞(0）分享  回复(0）举报  4个月前
我来回答

相关问题

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com