• [Résolu] Problème de connexion ExtDB 3


    Bonjour,
    alors voilà je voudrais monter un serveur mais j’ai un problème mon serveur galère à se connecter à la base de donnée voici l’erreur :

    [21:41:54:473717 +020] [Thread 1420] extDB3: Config Error: altislife_gjoa: No such node (altislife_gjoa.IP)
    [21:41:54:473736 +020] [Thread 1420] extDB3: Output to Server: [0,"Database Config Error"]
    

    Je commence dans le dev et je m’y connais pas trop.Merci d’avance à ceux qui m’aideront.

  • helo :)

    Poste ton extdb_conf(cache user et mdp si c’est pas en local) et ton description.ext stp

  • envoie ton description.ext au passage

  • [Database]
    IP = 188.165.219.91
    Port = 3306
    Username = 
    Password = 
    Database = altislife_gjoa
    
    disableChannels[] = {{0,true,true},{1,true,true},{2,true,true}};    // Disabled text and voice for global, side, and command channels. Syntax: disableChannels[] = {{channelID<number>, disableChat<bool>, disableVoice<bool>}};
    overviewText = "$STR_MISC_overviewText";    // Text to be displayed below the overviewPicture on the mission selection screen when the mission is available to play.
    
    #include "config\Config_SpyGlass.hpp"
    #include "CfgRemoteExec.hpp"
    #include "dialog\MasterHandler.hpp"
    #include "config\Config_Master.hpp"
    
    class CfgServer {
        DatabaseName = "altislife_gjoa"; //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.
        */
    };
    
    class RscTitles {
        #include "dialog\progress.hpp"
        #include "dialog\hud_nameTags.hpp"
        #include "dialog\hud_stats.hpp"
    };
    
    class CfgFunctions {
        #include "Functions.hpp"
    };
    
    class CfgSounds {
        sounds[] = {};
        class sirenLong {
            name = "sirenLong";
            sound[] = {"\sounds\sirenLong.ogg", 1.0, 1};
            titles[] = {};
        };
    
        class medicSiren {
            name = "medicSiren";
            sound[] = {"\sounds\medicSiren.ogg", 1.0, 1};
            titles[] = {};
        };
    
        class tazerSound {
            name = "tazerSound";
            sound[] = {"\sounds\tazer.ogg", 0.25, 1};
            titles[] = {};
        };
    
        class flashbang {
            name = "flashbang";
            sound[] = {"\sounds\flashbang.ogg", 1.0, 1};
            titles[] = {};
        };
    
        class mining {
            name = "mining";
            sound[] = {"\sounds\mining.ogg", 1.0, 1};
            titles[] = {};
        };
    
        class harvest {
            name = "harvest";
            sound[] = {"\sounds\harvest.ogg", 1.0, 1};
            titles[] = {};
        };
    
        class lockCarSound {
            name = "lockCarSound";
            sound[] = {"\sounds\carLock.ogg", 0.25, 1};
            titles[] = {};
        };
    
        class unlockCarSound {
            name = "unlockCarSound";
            sound[] = {"\sounds\carUnlock.ogg", 0.25, 1};
            titles[] = {};
        };
    };
    
    class CfgDebriefing {
        class NotWhitelisted {
            title = "$STR_NotWhitelisted_Title";
            subtitle = "$STR_NotWhitelisted_SubTitle";
            description = "$STR_NotWhitelisted_Descript";
            pictureBackground = "";
            picture = "";
            pictureColor[] = {0,0.3,0.6,1};
        };
    
        class Blacklisted {
            title = "$STR_Blacklisted_Title";
            subtitle = "$STR_Blacklisted_SubTitle";
            description = "$STR_Blacklisted_Descript";
            pictureBackground = "";
            picture = "";
            pictureColor[] = {0,0.3,0.6,1};
        };
    
        class SpyGlass {
            title = "$STR_SpyDetect_Title";
            subTitle = "$STR_SpyDetect_SubTitle";
            description = "$STR_SpyDetect_Descript";
            pictureBackground = "";
            picture = "";
            pictureColor[] = {0,0.3,0.6,1};
        };
    };
    
    class CfgNotifications {
        class MedicalRequestEmerg {
            title = "$STR_MedicalRequestEmerg_Title";
            iconPicture = "\A3\ui_f\data\map\mapcontrol\taskIcon_ca.paa";
            description = "%1";
            duration = 5;
            priority = 7;
        };
    
        class DeliveryAssigned {
            title = "$STR_DeliveryAssigned_Title";
            iconPicture = "\A3\ui_f\data\map\mapcontrol\taskIcon_ca.paa";
            description = "%1";
            duration = 10;
            priority = 7;
        };
    
        class DeliveryFailed {
            title = "$STR_DeliveryFailed_Title";
            iconPicture = "\A3\ui_f\data\map\mapcontrol\taskiconfailed_ca.paa";
            description = "%1";
            duration = 7;
            priority = 7;
        };
    
        class DeliverySucceeded {
            title = "$STR_DeliverySucceeded_Title";
            iconPicture = "\A3\ui_f\data\map\mapcontrol\taskIcondone_ca.paa";
            description = "%1";
            duration = 6;
            priority = 6;
        };
    
        class TextMessage {
            title = "$STR_TextMessage_Title";
            iconPicture = "icons\ico_messageNew.paa";
            description = "%1";
            duration = 10;
            priority = 6;
        };
    
        class PoliceDispatch {
            title = "$STR_PoliceDispatch_Title";
            iconPicture = "icons\ico_messagePolice.paa";
            description = "%1";
            duration = 10;
            priority = 6;
        };
    
        class AdminDispatch {
            title = "$STR_AdminDispatch_Title";
            iconPicture = "icons\ico_messageAdmin.paa";
            description = "%1";
            duration = 10;
            priority = 6;
        };
    
        class AdminMessage {
            title = "$STR_AdminMessage_Title";
            iconPicture = "icons\ico_messageAdmin.paa";
            description = "%1";
            duration = 10;
            priority = 5;
        };
    };
    
  • L erreur est la

    [Database]  // ici tu dois mettre ce qui est indique dans ton description.ext
    IP = 188.165.219.91
    Port = 3306
    Username = 
    Password = 
    Database = altislife_gjoa
    

    donc

    [altislife_gjoa]
    IP = 188.165.219.91
    Port = 3306
    Username = 
    Password = 
    Database = altislife_gjoa
    
  • Ok bonne nouvelle j’ai avancé grâce à ça je n’ai plus setting up client please wait mais ça :

    Envoie de la requête au serveur pour obtenir des informations lecteur UID (monuid )

    Le serveur n’a pas trouvé les informations de lecteur correspondant à votre UID,tentative d’ajout du joueur dans le système

    En gros l’image change toutes les secondes entre le premier et le deuxième message

  • Niveau log ça donne ça :

    "```
    extDB3: Protocol Error: [0,""Error MariaDBQueryException Exception""]"
    "extDB3: Protocol Error: [0,""Error MariaDBQueryException Exception""]"
    "extDB3: Protocol Error: [0,""Error MariaDBQueryException Exception""]"
    "extDB3: Protocol Error: [0,""Error MariaDBQueryException Exception""]"
    "extDB3: Protocol Error: [0,""Error MariaDBQueryException Exception""]"
    "extDB3: Protocol Error: [0,""Error MariaDBQueryException Exception""]"
    "extDB3: Protocol Error: [0,""Error MariaDBQueryException Exception""]"
    "extDB3: Protocol Error: [0,""Error MariaDBQueryException Exception""]"
    "extDB3: Protocol Error: [0,""Error MariaDBQueryException Exception""]"
    "extDB3: Protocol Error: [0,""Error MariaDBQueryException Exception""]"
    "extDB3: Protocol Error: [0,""Error MariaDBQueryException Exception""]"
    "extDB3: Protocol Error: [0,""Error MariaDBQueryException Exception""]"
    
  • Bonsoir, envois les logs EXTDB3 stp :)

  • [22:34:59:612531 +02:00] [Thread 1344] extDB3: Output to Server: [3]
    [22:34:59:612596 +02:00] [Thread 1344] extDB3: Input from Server: 4:521
    [22:34:59:612617 +02:00] [Thread 1344] extDB3: Output to Server: [3]
    [22:34:59:612644 +02:00] [Thread 1344] extDB3: Input from Server: 4:521
    [22:34:59:612659 +02:00] [Thread 1344] extDB3: Output to Server: [3]
    [22:34:59:612682 +02:00] [Thread 1344] extDB3: Input from Server: 4:521
    [22:34:59:612693 +02:00] [Thread 952] extDB3: SQL: Error MariaDBQueryException: Unknown column 'pid' in 'field list'
    [22:34:59:612697 +02:00] [Thread 1344] extDB3: Output to Server: [3]
    [22:34:59:612734 +02:00] [Thread 952] extDB3: SQL: Error MariaDBQueryException: Input: SELECT pid, name FROM players WHERE pid='76561198073466123'
    [22:34:59:612782 +02:00] [Thread 1344] extDB3: Input from Server: 4:521
    [22:34:59:612917 +02:00] [Thread 1344] extDB3: Output to Server: [0,"Error MariaDBQueryException Exception"]
    [22:34:59:614210 +02:00] [Thread 1344] extDB3: Input from Server: 1:804:INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198073466123', 'Tito Wee', '0', '3000', '"[`Tito Wee`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
    [22:34:59:614241 +02:00] [Thread 1344] extDB3: Output to Server: 
    [22:34:59:614293 +02:00] [Thread 952] extDB3: SQL: Trace: Input: INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198073466123', 'Tito Wee', '0', '3000', '"[`Tito Wee`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
    [22:34:59:621862 +02:00] [Thread 952] extDB3: SQL: Error MariaDBQueryException: Unknown column 'pid' in 'field list'
    [22:34:59:621919 +02:00] [Thread 952] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198073466123', 'Tito Wee', '0', '3000', '"[`Tito Wee`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
    
  • utilise tu la bonne base de donnée ? du moin qui correspond a ta version life

    erreur : extDB3: SQL: Error MariaDBQueryException: Unknown column ‘pid’ in ‘field list’

    il ne trouve pas ta colonne pid dans la table players

  • @igore13 a dit dans Problème de connexion ExtDB 3 :

    utilise tu la bonne base de donnée ?

    erreur : extDB3: SQL: Error MariaDBQueryException: Unknown column ‘pid’ in ‘field list’

    il ne trouve pas ta colonne pid dans la table players

    C est pas le bon sql que t as mis en place …

  • Oui regarde :

    text alternatif

    mais quand je clique sur joueur ça me met ça

    text alternatif

  • @JeyJey Dans ta base de donnée il est écrit ‘playerid’ au lieu de 'pid’
    Tu n’as pas mis le bon SQL je pense x)

  • supprime tes table sql puis reimporte ton .sql , tu peut modifier les nom des tables mais tu peut en rencontré d’autre de probleme lié a la base de donnée

  • Donc je change la table playerid en pid ?

    Comme ceci :

    text alternatif

  • Tu peut oui mais tu peut rencontré dautre probleme si ce n’est pas celui qui correspond a ta version life.

    le mieu si c’est un server origine que tu as installer tu supprime toute tes tables et tu reimporte ton .sql fournit dans ton pack life

    EDIT : puis tu verifie de bien avoir la colonne ‘pid’

  • THANK YOU MY FRIEND IT’S WORKING

  • Passe ton topic en Résolu ;)

  • @JeyJey a dit dans Problème de connexion ExtDB 3 :

    THANK YOU MY FRIEND IT’S WORKING

    No problem (cc @Proto-LEDG possibilité de deplacer en résolu ? :p )

Messages 20Vues 1385