extdb3 kann nicht geladen werden

Martin18186

Hallo ich habe alle so gemacht wie im Tutorial
Aber er will sich nicht verbinden hier kommen die Server Log + extdb3 config + tanoalife.sql

Kann jemand helfen wir haben die Datenbank neu installiert

Code: extdb3-conf.ini

[Main]
Version = 1

Randomize Config File = false
;; Randomizes Config File after loading.
;;   Recommend to turn on, if you have enabled filepatching on arma.

Allow Reset = false
;; Allows 9:RESET, usefull for development work

Thread = 0;
;; Option to force number of worker threads for extDB3.
;;   Auto = 0, Min = 2, Max = 6

[Log]
Flush = true;
;; Flush logfile after each update.
;;    Option really only usefull if running DEBUG BUILD


[tanoalife]
IP = 127.0.0.1
Port = 3306
Username = Test18185
Password =
Database = tanoalife

Alles anzeigen

tanoalife SQL

Code

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Compatible with newer MySQL versions. (After MySQL-5.5)
-- This SQL uses utf8mb4 and has CURRENT_TIMESTAMP function.
--


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Creates database `tanoalife` unless it already exists and uses `tanoalife`
-- Default Schema
--
CREATE DATABASE IF NOT EXISTS `tanoalife` DEFAULT CHARACTER SET utf8mb4;
USE `tanoalife`;

--
-- Drop procedures to ensure no conflicts
--
DROP PROCEDURE IF EXISTS `resetLifeVehicles`;
DROP PROCEDURE IF EXISTS `deleteDeadVehicles`;
DROP PROCEDURE IF EXISTS `deleteOldHouses`;
DROP PROCEDURE IF EXISTS `deleteOldGangs`;
DROP PROCEDURE IF EXISTS `deleteOldContainers`;
DROP PROCEDURE IF EXISTS `deleteOldWanted`;

DELIMITER $$
--
-- Procedures
-- CURRENT_USER function returns the name of the current user in the SQL Server database.
--

CREATE DEFINER=CURRENT_Test18185PROCEDURE `resetLifeVehicles`()
BEGIN
UPDATE `vehicles` SET `active`= 0;
END$$

CREATE DEFINER=CURRENT_Test18185PROCEDURE `deleteDeadVehicles`()
BEGIN
DELETE FROM `vehicles` WHERE `alive` = 0;
END$$

CREATE DEFINER=CURRENT_Test18185PROCEDURE `deleteOldHouses`()
BEGIN
DELETE FROM `houses` WHERE `owned` = 0;
END$$

CREATE DEFINER=CURRENT_Test18185PROCEDURE `deleteOldGangs`()
BEGIN
DELETE FROM `gangs` WHERE `active` = 0;
END$$

CREATE DEFINER=CURRENT_Test18185PROCEDURE `deleteOldContainers`()
BEGIN
DELETE FROM `containers` WHERE `owned` = 0;
END$$

CREATE DEFINER=CURRENT_Test18185PROCEDURE `deleteOldWanted`()
BEGIN
DELETE FROM `wanted` WHERE `active` = 0;
END$$

DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `players`
--

CREATE TABLE IF NOT EXISTS `players` (
`uid`          INT NOT NULL AUTO_INCREMENT,
`pid`          VARCHAR(17) NOT NULL,
`name`         VARCHAR(32) NOT NULL,
`aliases`      TEXT NOT NULL,
`cash`         INT NOT NULL DEFAULT 0,
`bankacc`      INT NOT NULL DEFAULT 0,
`coplevel`     ENUM('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
`mediclevel`   ENUM('0','1','2','3','4','5') NOT NULL DEFAULT '0',
`civ_licenses` TEXT NOT NULL,
`cop_licenses` TEXT NOT NULL,
`med_licenses` TEXT NOT NULL,
`civ_gear`     TEXT NOT NULL,
`cop_gear`     TEXT NOT NULL,
`med_gear`     TEXT NOT NULL,
`civ_stats`    VARCHAR(25) NOT NULL DEFAULT '"[100,100,0]"',
`cop_stats`    VARCHAR(25) NOT NULL DEFAULT '"[100,100,0]"',
`med_stats`    VARCHAR(25) NOT NULL DEFAULT '"[100,100,0]"',
`arrested`     TINYINT NOT NULL DEFAULT 0,
`adminlevel`   ENUM('0','1','2','3','4','5')  NOT NULL DEFAULT '0',
`donorlevel`   ENUM('0','1','2','3','4','5')  NOT NULL DEFAULT '0',
`blacklist`    TINYINT NOT NULL DEFAULT 0,
`civ_alive`    TINYINT NOT NULL DEFAULT 0,
`civ_position` VARCHAR(32) NOT NULL DEFAULT '"[]"',
`playtime`     VARCHAR(32) NOT NULL DEFAULT '"[0,0,0]"',
`insert_time`  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`last_seen`    TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

PRIMARY KEY (`pid`),
UNIQUE KEY `unique_uid` (`uid`),
INDEX `index_name` (`name`),
INDEX `index_blacklist` (`blacklist`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `vehicles`
--

CREATE TABLE IF NOT EXISTS `vehicles` (
`id`          INT NOT NULL AUTO_INCREMENT,
`pid`         VARCHAR(17) NOT NULL,
`side`        VARCHAR(10) NOT NULL,
`classname`   VARCHAR(64) NOT NULL,
`type`        VARCHAR(16) NOT NULL,
`alive`       TINYINT NOT NULL DEFAULT 1,
`blacklist`   TINYINT NOT NULL DEFAULT 0,
`active`      TINYINT NOT NULL DEFAULT 0,
`plate`       MEDIUMINT NOT NULL,
`color`       INT NOT NULL,
`inventory`   TEXT NOT NULL,
`gear`        TEXT NOT NULL,
`fuel`        DOUBLE NOT NULL DEFAULT 1,
`damage`      VARCHAR(256) NOT NULL,
`insert_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id`),
INDEX `fkIdx_players_vehicles` (`pid`),
CONSTRAINT `FK_players_vehicles` FOREIGN KEY `fkIdx_players_vehicles` (`pid`)
REFERENCES `players` (`pid`)
ON UPDATE CASCADE ON DELETE CASCADE,
INDEX `index_side` (`side`),
INDEX `index_type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `houses`
-- Needed for extDB latest update on git
--

CREATE TABLE IF NOT EXISTS `houses` (
`id`          INT NOT NULL AUTO_INCREMENT,
`pid`         VARCHAR(17) NOT NULL,
`pos`         VARCHAR(32) DEFAULT NULL,
`owned`       TINYINT DEFAULT 0,
`garage`      TINYINT NOT NULL DEFAULT 0,
`insert_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id`),
INDEX `fkIdx_players_houses` (`pid`),
CONSTRAINT `FK_players_houses` FOREIGN KEY `fkIdx_players_houses` (`pid`)
REFERENCES `players` (`pid`)
ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `gangs`
-- Needed for extDB latest update on git
--

CREATE TABLE IF NOT EXISTS `gangs` (
`id`          INT NOT NULL AUTO_INCREMENT,
`owner`       VARCHAR(17) NOT NULL,
`name`        VARCHAR(32) DEFAULT NULL,
`members`     TEXT,
`maxmembers`  INT DEFAULT 8,
`bank`        INT DEFAULT 0,
`active`      TINYINT NOT NULL DEFAULT 1,
`insert_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id`),
UNIQUE KEY `unique_name` (`name`),
INDEX `fkIdx_players_gangs` (`owner`),
CONSTRAINT `FK_players_gangs` FOREIGN KEY `fkIdx_players_gangs` (`owner`)
REFERENCES `players` (`pid`)
ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `containers`
-- Needed for extDB latest update on git
--

CREATE TABLE IF NOT EXISTS `containers` (
`id`          INT NOT NULL AUTO_INCREMENT,
`pid`         VARCHAR(17) NOT NULL,
`classname`   VARCHAR(32) NOT NULL,
`pos`         VARCHAR(32) DEFAULT NULL,
`inventory`   TEXT NOT NULL,
`gear`        TEXT NOT NULL,
`dir`         VARCHAR(128) DEFAULT NULL,
`active`      TINYINT NOT NULL DEFAULT 0,
`owned`       TINYINT NOT NULL DEFAULT 0,
`insert_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id`),
INDEX `fkIdx_players_containers` (`pid`),
CONSTRAINT `FK_players_containers` FOREIGN KEY `fkIdx_players_containers` (`pid`)
REFERENCES `players` (`pid`)
ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `wanted`
-- Needed for extDB latest update on git
--

CREATE TABLE IF NOT EXISTS `wanted` (
`wantedID`     VARCHAR(17) NOT NULL,
`wantedName`   VARCHAR(32) NOT NULL,
`wantedCrimes` TEXT NOT NULL,
`wantedBounty` INT NOT NULL,
`active`       TINYINT NOT NULL DEFAULT 0,
`insert_time`  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`wantedID`),
CONSTRAINT `FK_players_wanted` FOREIGN KEY `fkIdx_players_wanted` (`wantedID`)
REFERENCES `players` (`pid`)
ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------
--
-- Creates default user `arma3` with password `changeme` unless it already exists
-- Granting permissions to user `arma3`, created below
-- Reloads the privileges from the grant tables in the MySQL system database.
--

CREATE USER IF NOT EXISTS `arma3`@`localhost` IDENTIFIED BY 'changeme';
GRANT SELECT, UPDATE, INSERT, EXECUTE ON `tanoalife`.* TO 'arma3'@'localhost';
FLUSH PRIVILEGES;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Alles anzeigen

moeck

Moin,

du hast leider kein rpt vom Server angehängt, aber ich habe da einen Verdacht. In der description.ext solltest du dann auch die richtige DB angeben. In deinem Fall "tanoalife". In Standard steht nämlich Altislife drin

Code

class CfgServer {
    DatabaseName = "tanoalife"; //Config name that'll be grep in the extdb-conf.ini. Default: [altislife]
    DebugMode = 0; //Enable many server/hc debugging logs. Default: 0 (1 = Enabled / 0 = Disabled)
    HeadlessSupport = 0; //Enable/Disable Headless client support. Default: 1 (1 = Enabled / 0 = Disabled)
    /*
    Enabled: When HeadlessSupport is set to 1 (enabled), the server will run without fault when no Headless Client is connected. However, it will support the Headless Client if you choose to connect one.
    Disabled: If HeadlessSupport is set to 0 (disabled), the connection of a Headless Client will make no difference. This option will increase server performance a TINY but negligible amount.
    */
};

Gruß,

moeck

blackfisch

Bitte in Zukunft Spoiler & Code Tags nutzen! Ist absolut unlesbar so

Pennywise

Einmal die RPT Log

EDIT: Auch Battleye deaktivieren hilft nicht

extdb3 kann nicht geladen werden

Ähnliche Themen

Workflow Environment? Minimaler Zeitaufwand zwischen dem Debuggen? Scripts testen.

Config: Some input after EndOfFile

setup EVH Fehler

Server startet nicht

extDB3: Config Error: : No such node (.IP) Was tun?

Benutzer online in diesem Thema