Datenbank Probleme

PhilippS

Guten Tag
Leider haben wir seit längerem das Problem das unser Server gar nicht mehr zu der Datenbank verbinden möchte.

Hier mal all unsere Logs dazu und Config der extDB3.

Das ist ein ArmA3 Altis Life 5.0 Server. Wir benutzen keine Mods.

extdb3-conf

[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

[Database]

IP = 127.0.0.1

Port = 3310

Username = atlis

Password = *******

Database = altislife

Server RPT

=====================================================================

== C:\projekt\goodlife\arma3\arma3server.exe

== "arma3server.exe" -cfg=basic.cfg -config=config.cfg -profiles=ServerProfiles -autoInit -BEpath=C:\Projekte\RealAltis\Arma3\battleye -nosound -port=2302 -serverMod=@life_server;@extDB3;

Original output filename: Arma3Retail_Server

Exe timestamp: 2018/07/24 22:39:33

Current time: 2018/11/10 17:09:38

Type: Public

Build: Stable

Version: 1.84.144923

17:10:05 modsReadOnly = false

17:10:05 safeModsActivated = false

17:10:05 customMods = true

17:10:05 hash = '7F20211A7E8EBFCCFB76AF394C2D4E79647AA312'

17:10:05 hashShort = '4b9a1f38'

17:10:05 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

17:10:05 ==========================================================================================================================================================================================================

17:10:05 InitSound ...

17:10:05 InitSound - complete

17:10:05 PhysX3 SDK Init started ...

17:10:05 PhysX3 SDK Init ended.

17:10:11 core\skyobject\skyobject.p3d: No geometry and no visual shape

17:10:11 a3\data_f\krater.p3d: No geometry and no visual shape

17:10:11 a3\data_f\koule.p3d: No geometry and no visual shape

17:10:12 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.

a3_characters_f

17:10:12 Loading movesType CfgGesturesMale

17:10:12 Creating action map cache

17:10:12 MovesType CfgGesturesMale load time 136 ms

17:10:12 Loading movesType CfgMovesMaleSdr

17:10:12 Reading cached action map data

17:10:16 MovesType CfgMovesMaleSdr load time 4138 ms

17:10:16 a3\characters_f\proxies\flag.p3d: No geometry and no visual shape

17:10:16 'restart' voteThreshold must be in 0..1 range. Using global voteThreshold

Initializing Steam server - Game Port: 2302, Steam Query Port: 2303

Steam AppId from steam_appid.txt: 107410

Unsupported language English in stringtable

Connected to Steam servers

Starting mission:

Mission file: Altis_Life

Mission world: Altis

Mission directory: mpmissions\Altis_Life.Altis\

a3\data_f\blesk1.p3d: No geometry and no visual shape

a3\data_f\blesk2.p3d: No geometry and no visual shape

a3\data_f\raindrop.p3d: No geometry and no visual shape

a3\map_stratis\data\obloha.p3d: No geometry and no visual shape

a3\data_f\stars.p3d: No geometry and no visual shape

a3\map_stratis\data\horizont.p3d: No geometry and no visual shape

a3\data_f\rainbow.p3d: No geometry and no visual shape

Strange convex component202 in a3\structures_f\households\house_small01\d_house_small_01_v1_f.p3d:geometryView

Strange convex component203 in a3\structures_f\households\house_small01\d_house_small_01_v1_f.p3d:geometryView

Strange convex component145 in a3\plants_f\tree\t_pinuss2s_b_f.p3d:geometryView

Strange convex component149 in a3\plants_f\tree\t_pinuss2s_b_f.p3d:geometryView

Strange convex component65 in a3\rocks_f\sharp\sharprock_wallh.p3d:geometryFire

Strange convex component06 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component18 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component30 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component31 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component32 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component42 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component43 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component44 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component46 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component58 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component64 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component76 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component98 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component100 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component132 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component145 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component149 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component151 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component167 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component198 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component244 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component304 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component310 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component337 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component353 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component378 in a3\rocks_f\sharp\sharprock_monolith.p3d:geometryFire

Strange convex component05 in a3\rocks_f\sharp\sharprock_spike.p3d:geometryFire

Strange convex component74 in a3\rocks_f\sharp\sharprock_spike.p3d:geometryFire

Strange convex component202 in a3\rocks_f\sharp\sharprock_spike.p3d:geometryFire

Strange convex component391 in a3\rocks_f\sharp\sharprock_spike.p3d:geometryFire

"---------------------------------------------------------------------"

CallExtension loaded: extDB3 (C:\projekt\goodlife\arma3\@extDB3\extDB3.dll) [Ì½_Ì½_(`‘Ø*]

"extDB3 Loaded"

"---------------------------------------------------------------------"

a3\structures_f\mil\flags\flag_f.p3d: No geometry and no visual shape

a3\weapons_f\binocular\nvg_proxy.p3d: No geometry and no visual shape

a3\weapons_f\binocular\nvg_proxy_opfor.p3d: No geometry and no visual shape

a3\weapons_f\binocular\nvg_proxy_off_opfor.p3d: No geometry and no visual shape

No speaker given for 'Ali Ngige'

a3\characters_f_beta\heads\glasses\g_shades_green.p3d: No geometry and no visual shape

No speaker given for 'Ali Okonkwo'

a3\characters_f_gamma\heads\glasses\g_aviators.p3d: No geometry and no visual shape

No speaker given for 'Dixon Walker'

a3\characters_f_beta\heads\glasses\g_shades_red.p3d: No geometry and no visual shape

No speaker given for 'Hamidi Azikiwe'

No speaker given for 'Hu Chang'

soldier[B_diver_F]:Some of magazines weren't stored in soldier Vest or Uniform?

No speaker given for 'Tavish Anderson'

No speaker given for 'Donald Warren'

No speaker given for 'Mike Thompson'

No speaker given for 'Spencer Bennett'

a3\characters_f\heads\glasses\g_shades_black.p3d: No geometry and no visual shape

No speaker given for 'Muhammad Okeke'

No speaker given for 'Mike White'

No speaker given for 'Connor Hill'

No speaker given for 'Kyle Young'

No speaker given for 'Dong Yeung'

No speaker given for 'Lu Chen'

No speaker given for 'Samuel Newton'

No speaker given for 'Luke O'Sullivan'

No speaker given for 'Jamie Taylor'

a3\characters_f\heads\glasses\g_shades_blue.p3d: No geometry and no visual shape

No speaker given for 'Lu Kung'

No speaker given for 'Archie Conrad'

No speaker given for 'Matthew White'

No speaker given for 'Oliver Clark'

soldier[B_diver_F]:Some of magazines weren't stored in soldier Vest or Uniform?

No speaker given for 'Max Jones'

No speaker given for 'Katungi Sesse-Seko'

No speaker given for 'Jake Anderson'

No speaker given for 'Dwan Smith'

No speaker given for 'Greer Nelson'

No speaker given for 'Keith Harris'

No speaker given for 'Greer Moore'

Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 1c not found

Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 2c not found

Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 3c not found

Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 4c not found

Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 5c not found

Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 6c not found

Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 7c not found

Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 8c not found

Wrong geometry convex component mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Convex component number 3. not found

No speaker given for 'Evangelos Costas'

No speaker given for 'Vasilis Karmanlis'

No speaker given for 'Evripidis Karmanlis'

No speaker given for 'Michalis Mastori'

No speaker given for 'Vasilis Zenon'

No speaker given for 'Kouris Manelia'

No speaker given for 'Angelos Nicolau'

No speaker given for 'Michalis Petridis'

No speaker given for 'Samaras Athanasiadis'

No speaker given for 'Biton Christou'

No speaker given for 'Fotini Dimitriadis'

No speaker given for 'Militiadis Manelia'

No speaker given for 'Sotiris Gikas'

No speaker given for 'Thanos Kammenou'

No speaker given for 'Sotiris Stanis'

No speaker given for 'Evripidis Manetta'

No speaker given for 'Nicolo Nicolau'

No speaker given for 'Costa Stanis'

No speaker given for 'Militiadis Papadopoulos'

No speaker given for 'Thamos Malas'

No speaker given for 'Panos Ioannou'

No speaker given for 'Thanos Ioannou'

No speaker given for 'Vasilis Elias'

No speaker given for 'Gamba Achebe'

Strange convex component116 in a3\rocks_f\sharp\sharprock_apart.p3d:geometryFire

Strange convex component117 in a3\rocks_f\sharp\sharprock_apart.p3d:geometryFire

Strange convex component118 in a3\rocks_f\sharp\sharprock_apart.p3d:geometryFire

Strange convex component119 in a3\rocks_f\sharp\sharprock_apart.p3d:geometryFire

Error: Object(2 : 551) not found

Error: Object(2 : 662) not found

c:\bis\source\stable\futura\lib\network\networkserver.cpp NetworkServer::OnClientStateChanged:NOT IMPLEMENTED - briefing!

Mission id: 6a8766947282ad166733d131c71ffb5400707955

"extDB3: Error with Database Connection"

Attempt to override final function - bis_fnc_storeparamsvalues_data

extDB3 Logs

extDB3: https://bitbucket.org/torndeco/extdb3/wiki/Home

extDB3: Version: 1.031

extDB3: Windows Version

Message: All development for extDB3 is done on a Linux Dedicated Server

Message: If you would like to Donate to extDB3 Development

Message: https://www.paypal.com/cgi-bin/webscr…d=2SUEFTGABTAM2

Message: Also leave a message if there is any particular feature you would like to see added.

Message: Thanks for all the people that have donated.

Message: Torndeco: 18/05/15

extDB3: Found extdb3-conf.ini

extDB3: Detected 10 Cores, Setting up 6 Worker Threads

extDB3: ...

[17:10:48:251743 +01:00] [Thread 5360] extDB3: Config Error: altislife: No such node (altislife.IP)

Bin Froh um jede Hilfe

*PS. Der RPT Log ist etwas verkürz da oben ja noch die addons vom server selber geladen werden ohne Fehler.

brandxp1

Zitat von PhilippBaumrp

extdb3-conf

Port = 3310

Sicher das, dass der richtige Port ist ? Der reguläre Datenbanken Port ist nämlich 3306 ?

PhilippS

Ja. Wir mussten den auf 3310 ändern da ein anderes program 3306 hat. Es geht ja auch alles mit den zugangsdaten per Navicat

brandxp1

Dann liegt es daran nicht....

Pls einmal die Description.ext aus der Mission.

PhilippS

Hier

Spoiler anzeigen

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"; //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 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;

};

brandxp1

Ind der extDB Config [Database] zu [altislife] ändern

Also so :

[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

[altislife]

IP = 127.0.0.1

Port = 3310

Username = atlis

Password = *******

Database = altislif

Dann sollte es laufen, wenn nicht einfach bescheit geben

PhilippS

Jetzt kommt in den Logs das

extDB3 Logs

extDB3: https://bitbucket.org/torndeco/extdb3/wiki/Home

extDB3: Version: 1.031

extDB3: Windows Version

Message: All development for extDB3 is done on a Linux Dedicated Server

Message: If you would like to Donate to extDB3 Development

Message: https://www.paypal.com/cgi-bin/webscr…d=2SUEFTGABTAM2

Message: Also leave a message if there is any particular feature you would like to see added.

Message: Thanks for all the people that have donated.

Message: Torndeco: 18/05/15

extDB3: Found extdb3-conf.ini

extDB3: Detected 10 Cores, Setting up 6 Worker Threads

extDB3: ...

[17:35:23:838952 +01:00] [Thread 9736] extDB3: MariaDBConnectorException: altislife: Plugin caching_sha2_password could not be loaded: Das angegebene Modul wurde nicht gefunden.

PhilippS

Zitat von brandxp1

Ind der extDB Config [Database] zu [altislife] ändern

Also so :

[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

[altislife]

IP = 127.0.0.1

Port = 3310

Username = atlis

Password = *******

Database = altislif

Dann sollte es laufen, wenn nicht einfach bescheit geben

Alles anzeigen

Leider bekome ich nun dieses Problem:

extDB3 Log

extDB3: https://bitbucket.org/torndeco/extdb3/wiki/Home

extDB3: Version: 1.031

extDB3: Windows Version

Message: All development for extDB3 is done on a Linux Dedicated Server

Message: If you would like to Donate to extDB3 Development

Message: https://www.paypal.com/cgi-bin/webscr…d=2SUEFTGABTAM2

Message: Also leave a message if there is any particular feature you would like to see added.

Message: Thanks for all the people that have donated.

Message: Torndeco: 18/05/15

extDB3: Found extdb3-conf.ini

extDB3: Detected 10 Cores, Setting up 6 Worker Threads

extDB3: ...

[18:05:41:356411 +01:00] [Thread 9368] extDB3: MariaDBConnectorException: altislife: Access denied for user 'atlis'@'localhost' (using password: YES)

brandxp1

Zitat von PhilippBaumrp

extDB3 Log

[18:05:41:356411 +01:00] [Thread 9368] extDB3: MariaDBConnectorException: altislife: Access denied for user 'atlis'@'localhost' (using password: YES)

Heist soweit ich weis das der Nutzer nicht die beötigten Rechte hat?

AvirexDE

Zitat von brandxp1

Heist soweit ich weis das der Nutzer nicht die beötigten Rechte hat?

Das ist richtig.

Siehe dazu im Tutorial: Schritt 8: [Tutorial] ArmA 3 Dedicated Server einrichten unter Windows (mit extDB3 & 64bit) (Altis Life & Tanoa Life)

PhilippS

Zitat von brandxp1

Heist soweit ich weis das der Nutzer nicht die beötigten Rechte hat?

Der Benutzer hat volle Adminrechte so wie der Rootbentzer

brandxp1

Zitat von PhilippBaumrp

Der Benutzer hat volle Adminrechte so wie der Rootbentzer

Auch auf die altislife datenbank ?

PhilippS

Zitat von brandxp1

Auch auf die altislife datenbank ?

Ja alles genau gleich

warsteiner

ihr habt bei username atlis anstatt altis ist das so gewollt?

PhilippS

Zitat von warsteiner

ihr habt bei username atlis anstatt altis ist das so gewollt?

Nein ist nicht so gewollt. Danke dir.

brandxp1

Zitat von PhilippBaumrp

Nein ist nicht so gewollt. Danke dir.

Läuft jetzt alles oder treten noch Fehler auf ?

PhilippS

Zitat von brandxp1

Läuft jetzt alles oder treten noch Fehler auf ?

Es läuft nun alles. Danke für eure Hilfe.

Datenbank Probleme

Dann sollte es laufen, wenn nicht einfach bescheit geben

Dann sollte es laufen, wenn nicht einfach bescheit geben

Ähnliche Themen

Garage Problem

Probleme bei OPFOR

Server Frägt UID des Spielers ab.

Der bekannte fehler "Frage Spieler Informationen zu UID [........] ab.

Probleme mit der Datenbank

Zwei Server Instanzen auf einem Root ?

Tags

Benutzer online in diesem Thema