extDB2 Einrichten - so geht's richtig

Xylometachlorid

Guten Tag zusammen,

mittlerweile sind 85% der Posts hier im Forum "Bei mir steht da Setting up client, kann mir jemand helfen ich komm nicht weiter"

Wenn ich das noch einmal lese nach diesem Tutorial, platzt mir ein Ei

Viel Spaß!

Wir beginnen einfach.

Wir öffnen den Downloadbereich von Native gamer und Navigieren in den extDB2 + @life_server (Altis Life 4.0) von nox. Wir halten uns Links und klicken auf Herunterladen.
Ist diese Hürde gemeistert, entpacken wir das Verzeichnis und öffnen @extDB2 und dort die extdb-conf.ini mit einem Editor eurer Wahl.
Diese Datei bearbeiten wir nun auf unsere Datenbank angepasst.
- Zeile 89 Der Name eurer Datenbank. Standardmäßig ist das arma3life.
- Zeile 91-94 Eure Userdaten die ihr beim erstellen der MySQL Datenbank angegeben habt.
- Speichern!
Ist das geschafft gehört ihr schon mal zu den besten 10 %. Herzlichen Glückwunsch.
Nun Navigieren wir in das Verzeichnis der altis-life-rpg-4.ini im Verzeichnis @extDB2\extdb\SQL_CUSTOM_V2
Hier ERSETZEN wir nun den gesamten Code mit folgendem altis-life-rpg-4.rar
Wichtig! Diese INI ist komplett umgeschrieben und erfordert eine komplett Leere Datenbank! User werden in dieser Version bspw. in einen String gepackt. Sollte dies mit einer schon laufenden Datenbank kollidieren zerschießt ihr euch zum einen die Datensätze, zum anderen Funktioniert dann gar nichts mehr!
Fügt nun alle Dateien in euer Arma3 Hauptverzeichnis auf dem Server.
Ladet euch folgendes "Testpaket" runter extDB2-v64.rar
Navigiert in das Verzeichnis test\windows und zieht die extDB2-test.exe in euer Server-Hauptverzeichnis.
Versucht den Server zu starten. Solltet ihr "Setting Up Client" erhalten, startet die extDB2-test.exe und postet das Ergebnis hier im Native gamer Forum.

Selbstverständlich ist das Tutorial und der extDB2 Code Native gamer Exklusiv und darf nicht in anderen Foren geteilt werden!

Sollte ich euch geholfen habe, freue ich mich immer über Feedback

Liebe Grüße
Xylometachlorid

nox

Nice. Nice. Nice! :held: :danke:

SBuserhy

Ich glaube, da wird bald einer mit nemm geplatzten Ei rumraufen pleasantry

jetzt mußt du den Beitrag hier nur noch im Download verlinken

nox

Zitat von SBuserhy

Ich glaube, da wird bald einer mit nemm geplatzten Ei rumraufen pleasantry

jetzt mußt du den Beitrag hier nur noch im Download verlinken

Gesagt, getan.

chris5790

Da fehlen noch ein paar essenzielle Dinge um die Performance aufrecht zu erhalten.

Alle Anweisungen

C

waitUntil {!DB_AsyncActive};

oder die so ähnlich aussehen müssen entfernt werden. Zusätzlich sollte die Variable DB_AsyncExtraLock (ich meine zumindest die war es, hab seit 5 Monaten kein vanilla Altis Life mehr gesehen) mit allen ihren Anweisungen entfernt werden. Somit vermeidet ihr einen Overhead, das klassische Warten im Ladescreen ab ~50 Spielern.

Die Datenbank muss auch nicht zwangsläufig leer sein, ein entsprechendes Konvertierungs-SQL Script poste ich sobald ich zu Hause bin.

Xylometachlorid

Zitat von chris5790
Da fehlen noch ein paar essenzielle Dinge um die Performance aufrecht zu erhalten.

Alle Anweisungen
C
waitUntil {!DB_AsyncActive};
oder die so ähnlich aussehen müssen entfernt werden. Zusätzlich sollte die Variable DB_AsyncExtraLock (ich meine zumindest die war es, hab seit 5 Monaten kein vanilla Altis Life mehr gesehen) mit allen ihren Anweisungen entfernt werden. Somit vermeidet ihr einen Overhead, das klassische Warten im Ladescreen ab ~50 Spielern.

Die Datenbank muss auch nicht zwangsläufig leer sein, ein entsprechendes Konvertierungs-SQL Script poste ich sobald ich zu Hause bin.

eieiei....

Entweder du erzählst gerade ganz schönen Scheiß oder ich bin einfach noch nicht ganz Wach um 7 Uhr.

DB_AsyncExtraLock und DB_AsyncActive werden in der 4.0 in der init vom life_server gleich am Anfang komplett deaktiviert!
Gut okay, Hochkomma an die Records anfügen ist jetzt nicht gerade eine Meisterleistung, in Zeiten aber in denen ich solche Tutorial wie oben verfassen muss, damit es wenigstens 10% verstehen, wollte ich so weit nicht gehen.

Na dann

Liebe Grüße

chris5790

Die Variablen werden initialisiert und in der asyncCall dementsprechend benutzt. Also bitte nenn das nicht "Scheiß".

Man sollte sich mit sowas vielleicht auch mal beschäftigen und nicht immer direkt in die Offensive gehen nur weil jemand sein heiliges Forenreich betreten hat und anscheinend auch Ahnung hat...

Xylometachlorid

Zitat von chris5790

Die Variablen werden initialisiert und in der asyncCall dementsprechend benutzt. Also bitte nenn das nicht "Scheiß".

Man sollte sich mit sowas vielleicht auch mal beschäftigen und nicht immer direkt in die Offensive gehen nur weil jemand sein heiliges Forenreich betreten hat und anscheinend auch Ahnung hat...

Nochmal. Die asyncCall wird in der Initialisierung der Life_Server bei AL 4.0 Standardmäßig deaktiviert!

chris5790

Was soll denn da deaktiviert werden? Da wird eine Variable gesetzt...

Xylometachlorid

Ok. Du hast Recht. Sinnlose Diskussion beendet.

MILLER-CONTROLS

Hay,
ich habe mal wieder probiert was aufzusetzen und zack geht nix mehr :p
bei mir trotz richtig erfolgter Schritte immer ein Setting up Client.
Ich verstehe nicht ganz was das Problem ist. Ging sonst auch immer?
Datenbank heißt Arma3Life
Importiert unter neuen Schema Arma3Life
(MySQL) - Localhost - 127.0.0.1 - 3306

Bitte um Hilfe!

Over and Out
Rene

Code

8:55:43 InitSound ...
 8:55:43 InitSound - complete
 8:55:43 PhysX3 SDK Init started ...
 8:55:43 PhysX3 SDK Init ended.
 8:55:44 Warning Message: Script \life_server\Functions\DynMarket\fn_calculatePrices.sqf not found
 8:55:44 Warning Message: Script \life_server\Functions\DynMarket\fn_config.sqf not found
 8:55:44 Warning Message: Script \life_server\Functions\DynMarket\fn_getUpdate.sqf not found
 8:55:44 Warning Message: Script \life_server\Functions\DynMarket\fn_HandleDB.sqf not found
 8:55:44 Warning Message: Script \life_server\Functions\DynMarket\fn_playerLogged.sqf not found
 8:55:44 Warning Message: Script \life_server\Functions\DynMarket\fn_sleeper.sqf not found
 8:55:44 Attempt to override final function - rscminimap_script
 8:55:44 Attempt to override final function - rscdisplayloading_script
 8:55:44 Attempt to override final function - rscdisplayloading_script
 8:55:44 Attempt to override final function - rscdisplayloading_script
 8:55:44 Attempt to override final function - rscdiary_script
 8:55:44 Attempt to override final function - rscdisplaysinglemission_script
 8:55:44 Attempt to override final function - rscdiary_script
 8:55:44 Attempt to override final function - rscdisplayremotemissions_script
 8:55:44 Attempt to override final function - rscdisplayloading_script
 8:55:44 Attempt to override final function - rscdiary_script
 8:55:44 Attempt to override final function - rscdiary_script
 8:55:44 Attempt to override final function - rscdisplaystrategicmap_script
 8:55:44 Attempt to override final function - rscdisplaycommon_script
 8:55:44 Attempt to override final function - rscdisplaygarage_script
 8:55:45 Attempt to override final function - rscdisplayloading_script
 8:55:45 Attempt to override final function - rscdisplaycurator_script
 8:55:45 Attempt to override final function - rscdisplayattributes_script
 8:55:45 Attempt to override final function - rscdisplayattributes_script
 8:55:45 Attempt to override final function - rscdisplayattributes_script
 8:55:45 Attempt to override final function - display3deneditattributes_script
 8:55:45 Attempt to override final function - display3deneditattributes_script
 8:55:45 Attempt to override final function - rscdisplayhostsettings_script
 8:55:45 Attempt to override final function - rscdisplaycommon_script
 8:55:45 Attempt to override final function - rscdisplaydebriefing_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - rscunitinfo_script
 8:55:45 Attempt to override final function - slidertime_script
 8:55:45 Attempt to override final function - slidertime_script
 8:55:45 Attempt to override final function - slidertime_script
Initializing Steam server - Game Port: 2302, Steam Query Port: 2303
Version: 2
GlobalFlags: 0
DLCFlags: 7
DLCHashes:
1636478954
-1247962422
1197120697
Mods(2):
Hash: -1515629901
PublishedId: 0
Name: @life_server
Hash: 0
PublishedId: 0
Name: @extDB2
Difficulty: 0
AILevel: 0
FlightModel: 0
ThirdPersonCamera: 0
WeaponCrosshair: 0
Signatures:
encodedStream length: 66
encodedStream: ꯊaʚݵٜZGԒɥ@life_server@extDB2
parts size:1)
part(66): ꯊaʚݵٜZGԒɥ@life_server@extDB2
Connected to Steam servers
Unsupported language English in stringtable
Unsupported language English in stringtable
Mission Altis_Life.Altis: Number of roles (99) is different from 'description.ext::Header::maxPlayer' (75)
Server error: Player without identity Rene Wachter (id 906589622)
Server error: Player without identity Rene Wachter (id 906589622)
Server error: Player without identity Rene Wachter (id 906589622)
Server error: Player without identity Rene Wachter (id 906589622)
Server error: Player without identity Rene Wachter (id 906589622)
Server error: Player without identity Rene Wachter (id 906589622)
Server error: Player without identity Rene Wachter (id 906589622)
Server error: Player without identity Rene Wachter (id 906589622)
Server error: Player without identity Rene Wachter (id 906589622)
Server error: Player without identity Rene Wachter (id 906589622)
Server error: Player without identity Rene Wachter (id 906589622)
Server error: Player without identity Rene Wachter (id 906589622)
Server error: Player without identity Rene Wachter (id 906589622)
Server error: Player without identity Rene Wachter (id 906589622)
Starting mission:
 Mission file: Altis_Life
 Mission world: Altis
 Mission directory: mpmissions\Altis_Life.Altis\
Attempt to override final function - bis_functions_list
Attempt to override final function - bis_functions_listpreinit
Attempt to override final function - bis_functions_listpostinit
Attempt to override final function - bis_functions_listrecompile
Attempt to override final function - bis_fnc_missiontaskslocal
Attempt to override final function - bis_fnc_missionconversationslocal
Attempt to override final function - bis_fnc_missionflow
MovesType CfgGesturesMale load time 45 ms
Animation a3\cargoposes_f_heli\anim\passenger_inside_5aim_obstructed.rtm not found or empty
Animation a3\cargoposes_f_heli\anim\passenger_inside_5aim_fromobstructed.rtm not found or empty
Animation a3\cargoposes_f_heli\anim\passenger_inside_5aim_toobstructed.rtm not found or empty
Animation a3\cargoposes_f_heli\anim\passenger_inside_5aimpistol_obstructed.rtm not found or empty
Animation a3\cargoposes_f_heli\anim\passenger_inside_5aimpistol_fromobstructed.rtm not found or empty
Animation a3\cargoposes_f_heli\anim\passenger_inside_5aimpistol_toobstructed.rtm not found or empty
MovesType CfgMovesMaleSdr load time 6289 ms
No speaker given for Imre Ibori
No speaker given for Oringo Ekwensi
No speaker given for Shaan Igwe
No speaker given for Callum Bennett
No speaker given for Hamidi Okonkwo
No speaker given for Pan Han
soldier[B_diver_F]:Some of magazines weren't stored in soldier Vest or Uniform?
No speaker given for Lucas Clarke
No speaker given for Ian Lee
No speaker given for Max Robertson
No speaker given for Jack Jones
No speaker given for Teshi Osmani
No speaker given for Adam Anderson
No speaker given for George Bennett
No speaker given for Shawn Martinez
No speaker given for Wu Yeung
No speaker given for Liang Sun
No speaker given for Ryan White
No speaker given for Oliver Taylor
No speaker given for David Bennett
No speaker given for Tan Sun
No speaker given for David Smith
No speaker given for Luke Halliwell
No speaker given for Harrison Burr
soldier[B_diver_F]:Some of magazines weren't stored in soldier Vest or Uniform?
No speaker given for Fred Davis
No speaker given for Omari Egwu
No speaker given for Colin Johnson
No speaker given for Keith MacDonald
No speaker given for Geoff Faulkner
No speaker given for Paul Taylor
No speaker given for Dwan Newton
Strange convex component322 in a3\structures_f\research\dome_big_f.p3d:geometryFire
Strange convex component327 in a3\structures_f\research\dome_big_f.p3d:geometryFire
Error: Object(2 : 5) not found
Error: Object(2 : 7) not found
Error: Object(2 : 9) not found
Error: Object(2 : 98) not found
c:\w\stable\futura\lib\network\networkserver.cpp NetworkServer::OnClientStateChanged:NOT IMPLEMENTED - briefing!
"extDB: Version: 63"
"extDB: Error with Database Connection"
 Mission id: 6b88c6b5e2501ac25775cef4fece2e82f22e68ff
Deinitialized shape [Class: "Underwear_F"; Shape: "a3\characters_f\common\basicbody.p3d";]
Deinitialized shape [Class: "B_medic_F"; Shape: "a3\characters_f\blufor\b_soldier_02.p3d";]
Deinitialized shape [Class: "B_soldier_AR_F"; Shape: "a3\characters_f\blufor\b_soldier_02.p3d";]
Deinitialized shape [Class: "B_diver_F"; Shape: "a3\characters_f\common\diver_slotable.p3d";]
Deinitialized shape [Class: "O_Soldier_F"; Shape: "a3\characters_f\opfor\o_soldier_01.p3d";]
Deinitialized shape [Class: "B_RangeMaster_F"; Shape: "a3\characters_f\civil\c_poloshirtpants.p3d";]
Deinitialized shape [Class: "C_man_hunter_1_F"; Shape: "a3\characters_f\civil\c_hunter_f.p3d";]
Deinitialized shape [Class: "C_man_p_beggar_F_afro"; Shape: "a3\characters_f\civil\c_poor.p3d";]
Deinitialized shape [Class: "C_man_p_beggar_F"; Shape: "a3\characters_f\civil\c_poor.p3d";]
Deinitialized shape [Class: "C_man_p_fugitive_F_asia"; Shape: "a3\characters_f\civil\c_poor.p3d";]
Deinitialized shape [Class: "C_man_p_fugitive_F"; Shape: "a3\characters_f\civil\c_poor.p3d";]
Deinitialized shape [Class: "C_man_w_worker_F"; Shape: "a3\characters_f\common\coveralls.p3d";]
Deinitialized shape [Class: "C_man_1"; Shape: "a3\characters_f\civil\c_poloshirt.p3d";]
Deinitialized shape [Class: "C_man_polo_3_F"; Shape: "a3\characters_f\civil\c_poloshirt.p3d";]
Deinitialized shape [Class: "C_man_polo_6_F"; Shape: "a3\characters_f\civil\c_poloshirt.p3d";]
Deinitialized shape [Class: "C_man_p_shorts_1_F_afro"; Shape: "a3\characters_f\civil\c_poloshirt.p3d";]
Deinitialized shape [Class: "C_man_p_shorts_1_F"; Shape: "a3\characters_f\civil\c_poloshirt.p3d";]
Deinitialized shape [Class: "C_man_shorts_3_F_euro"; Shape: "a3\characters_f\civil\c_poloshirt.p3d";]
Deinitialized shape [Class: "C_man_shorts_3_F"; Shape: "a3\characters_f\civil\c_poloshirt.p3d";]
Deinitialized shape [Class: "C_man_polo_4_F"; Shape: "a3\characters_f\civil\c_poloshirt.p3d";]
Deinitialized shape [Class: "C_man_polo_5_F"; Shape: "a3\characters_f\civil\c_poloshirt.p3d";]
Deinitialized shape [Class: "C_man_polo_2_F"; Shape: "a3\characters_f\civil\c_poloshirt.p3d";]
Deinitialized shape [Class: "C_man_polo_1_F"; Shape: "a3\characters_f\civil\c_poloshirt.p3d";]
c:\w\stable\futura\lib\network\networkserver.cpp ClearNetServer:NOT IMPLEMENTED - briefing!
Extensions:
  extDB2 (C:\Users\Chris\Desktop\Webseite Pixels\SERVeR\steamapps\common\Arma 3 Server\@extDB2\extDB2.dll) [63.0.0.0] [63.0.0.0]

Alles anzeigen

Code: EXTDB-CONF.ini

[Main]
Version = 5




;Threads = 0  
; Default Value is the number of CPU Cores Detected (max value is 6, min value is 2)




Randomize Config File = false
;This is a legacy option to randomize config file for Arma2 Servers. Only for Windows Builds







[Rcon]
;; This is functional, should be working fine. Just needs abit of testing on a $
;; Allow for changing Address for those running server in a VM environment.
IP = 127.0.0.1
Port = 2302




;; Rcon Password i.e Battleye/beserver.cfg
Password = sqa8dADH8d




;; Bad Player Name Checks
;;		This will only work if your mission / mod has started extDB2 Rcon. i.e 9:START_RCON:RCON
Bad Playername Enable = false
Bad Playername Kick Message = Bad Player Name




;; By default : is a bad character (used as seperator for extDB2 Calls (this is hardcoded in)
;;Bad Playername Strings = (:):{:}
;;Bad Playername Regex_1 = [:alnum:]
;;Bad Playername Regex_2 = [:alnum:]
;;Bad Playername Regex_3 = [:alnum:]







;; Whitelisting / Reserve Slots
;;		This will only work if your mission / mod has started extDB2 Rcon. i.e 9:START_RCON:RCON
Whitelist Enable = false
Whitelist Kick Message = Only Reserved Slots Left




Whitelist Public Slots = 999




;; Database settings to use (Optional)
Whitelist Database = MySQL_Example
Whitelist SQL Prepared Statement = SELECT CASE WHEN EXISTS(SELECT UID FROM PlayerInfo WHERE BattlEyeGUID=? AND Whitelisted=1) THEN 1 ELSE 0 END
Whitelist Kick on SQL Query Failed = false




;; Hardcoded BEGuids for whitelisted players
;Whitelist BEGuids = xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx : yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy







[RemoteAccess]
;; Remote TCP Access to extDB2
Enable = false




Port = 2300
MaxThreads = 4
MaxQueued = 4
IdleTime = 120




Password = password







[Steam]
;; This is for VAC Protocol for VAC Bans + Steam Friends.
;; https://steamcommunity.com/dev/apikey
API Key = xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx







[VAC]
;; This feature requires Steam + Rcon to be enabled.
;; Also this feature is called via SQF Code atm, i.e it doesn't auto detect players joining server yet....
Auto Ban = true




;; For Player to get banned ( their total VAC Bans => NumberOfVACBans)  AND ( Days Since their Last Ban was <= DaysSinceLastBan)
;; This is also used extDB Protocol VAC:VACBanned returned results




NumberOfVACBans = 1
DaysSinceLastBan = 999999999
BanDuration = 0
;; 0 = Forever, otherwise its x Minutes
BanMessage = Steam VAC Banned







[Log]
;; Flush Logs after each write, more work on Harddrive
Flush = true




[Database2]
;; Example of MySQL
;; 	AtlisLifeRPG uses Database2 by default
Type = MySQL
Name = arma3life




Username = root
Password = admin
IP = 127.0.0.1
Port = 3306




minSessions = 1
;maxSessions = 4
idleTime = 60




compress = false
; Should only use this if MySQL server is external. Also only for MySQL




Secure Auth = true
; Recommend you turn this on




[SQLite_Example]
Type = SQLite
Name = sqlite.db




minSessions = 1
; minSession Default Value = 1




;maxSessions = 4
; maxSession Default Value = number of Main->Threads
; 	You really should leave this value alone
idleTime = 60
; idleTime no Default Value yet, needs to be defined.
; 	idleTime is the time before a database session is stopped if not used. 
;	If Database Sessions are greater than minSessions







[HTTP_Example]
Type = HTTP




Host = 127.0.0.1
Port = 80




; Username = user
; Password = password

Alles anzeigen

SBuserhy

Zitat von Rene Wachter

"[lexicon]extDB[/lexicon]: Version: 63"
"[lexicon]extDB[/lexicon]: Error with Database Connection"

Zitat von Rene Wachter

[Database2]
;; Example of MySQL
;; AtlisLifeRPG uses Database2 by default
Type = MySQL
Name = arma3life

[Database2] ist je nach verwendeter Altis Life Version unterschiedlich. Welche Altis Life Version hast du? 3x, 4x, 4.3x ?

[lexicon]ExtDB[/lexicon] Log wäre hilfreich

MILLER-CONTROLS

geklärt ich horst hab keinen Exdb Ordner drin

Azoni

Moin,
bei mir kommt das in den [lexicon]extDB[/lexicon] Logs:

Code

[08:22:20:441 +02:00] [Thread 2124] extDB2: No Config Option Found: ArmaLife

Muss ich die Config von AltisLife zu ArmaLife umbenennen oder wie kann ich diesen Fehler beheben?
MfG Azoni

Xylometachlorid

Exakt

xonex

ich weiß nicht was ich falsch mache habe alles so gemacht wie beschrieben
bei mir kommt im test
extDB2: {0,"Error Invalid Massage"

Airwolf003

2016/06/11, 9:58:07 "[lexicon]extDB[/lexicon]: Still Connected to the Database"
2016/06/11, 9:58:07 Error in expression <if(!_multiarr) then {
_return = _return select 0;
};

_return;
>
2016/06/11, 9:58:07 Error position: <select 0;
};

_return;
>
2016/06/11, 9:58:07 Error Generic error in expression
2016/06/11, 9:58:07 File life_server\Functions\MySQL\fn_asyncCall.sqf, line 58
2016/06/11, 9:58:19 Client: Local object 2:2401 not found
2016/06/11, 9:58:19 Server: Object info 2:2401 not found during Changing Owner
2016/06/11, 9:59:22 Ragdoll - loading of ragdoll source "Soldier" started.
2016/06/11, 9:59:22 Ragdoll - loading of ragdoll source "Soldier" finished successfully.

B4v4r!4n_Str!k3r

[lexicon]extDB[/lexicon] Log?

Lassi262612

Ich habe bei mir das Problem das er sagt Setting up Client. Soweit so gut doch gucke ich im extdb2 log steht da folgendes

Spoiler anzeigen

Code

[19:31:39:881 +02:00] [Thread 3628] extDB2: Database Type: MySQL
[19:31:39:923 +02:00] [Thread 3628] extDB2: Database Session Pool Started
[19:31:40:017 +02:00] [Thread 3628] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\server\A3Master\@extDB2\extDB\sql_custom_v2\altis-life-rpg-4.ini
[19:31:40:018 +02:00] [Thread 3628] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[13:18:10:009 +02:00] [Thread 3628] extDB2: Stopping ...

Spoiler anzeigen

Code

[Main]
Version = 5




;Threads = 0  
; Default Value is the number of CPU Cores Detected (max value is 6, min value is 2)




Randomize Config File = false
;This is a legacy option to randomize config file for Arma2 Servers. Only for Windows Builds







[Rcon]
;; This is functional, should be working fine. Just needs abit of testing on a $
;; Allow for changing Address for those running server in a VM environment.
IP = 127.0.0.1
Port = 2302




;; Rcon Password i.e Battleye/beserver.cfg
Password = sqa8dADH8d




;; Bad Player Name Checks
;;		This will only work if your mission / mod has started extDB2 Rcon. i.e 9:START_RCON:RCON
Bad Playername Enable = false
Bad Playername Kick Message = Bad Player Name




;; By default : is a bad character (used as seperator for extDB2 Calls (this is hardcoded in)
;;Bad Playername Strings = (:):{:}
;;Bad Playername Regex_1 = [:alnum:]
;;Bad Playername Regex_2 = [:alnum:]
;;Bad Playername Regex_3 = [:alnum:]







;; Whitelisting / Reserve Slots
;;		This will only work if your mission / mod has started extDB2 Rcon. i.e 9:START_RCON:RCON
Whitelist Enable = false
Whitelist Kick Message = Only Reserved Slots Left




Whitelist Public Slots = 999




;; Database settings to use (Optional)
Whitelist Database = MySQL_Example
Whitelist SQL Prepared Statement = SELECT CASE WHEN EXISTS(SELECT UID FROM PlayerInfo WHERE BattlEyeGUID=? AND Whitelisted=1) THEN 1 ELSE 0 END
Whitelist Kick on SQL Query Failed = false




;; Hardcoded BEGuids for whitelisted players
;Whitelist BEGuids = xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx : yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy







[RemoteAccess]
;; Remote TCP Access to extDB2
Enable = false




Port = 2300
MaxThreads = 4
MaxQueued = 4
IdleTime = 120




Password = password







[Steam]
;; This is for VAC Protocol for VAC Bans + Steam Friends.
;; https://steamcommunity.com/dev/apikey
API Key = xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx







[VAC]
;; This feature requires Steam + Rcon to be enabled.
;; Also this feature is called via SQF Code atm, i.e it doesn't auto detect players joining server yet....
Auto Ban = true




;; For Player to get banned ( their total VAC Bans => NumberOfVACBans)  AND ( Days Since their Last Ban was <= DaysSinceLastBan)
;; This is also used extDB Protocol VAC:VACBanned returned results




NumberOfVACBans = 1
DaysSinceLastBan = 999999999
BanDuration = 0
;; 0 = Forever, otherwise its x Minutes
BanMessage = Steam VAC Banned







[Log]
;; Flush Logs after each write, more work on Harddrive
Flush = true




[AltisLife]
;; Example of MySQL
;; 	AtlisLifeRPG uses Database2 by default
Type = MySQL
Name = arma3life




Username = root
Password = zensiert eingegeben.
IP = 127.0.0.1
Port = 3306




minSessions = 1
;maxSessions = 4
idleTime = 60




compress = false
; Should only use this if MySQL server is external. Also only for MySQL




Secure Auth = true
; Recommend you turn this on




[SQLite_Example]
Type = SQLite
Name = sqlite.db




minSessions = 1
; minSession Default Value = 1




;maxSessions = 4
; maxSession Default Value = number of Main->Threads
; 	You really should leave this value alone
idleTime = 60
; idleTime no Default Value yet, needs to be defined.
; 	idleTime is the time before a database session is stopped if not used. 
;	If Database Sessions are greater than minSessions







[HTTP_Example]
Type = HTTP




Host = 127.0.0.1
Port = 80




; Username = user
; Password = password

Alles anzeigen

ich hoffe jemand weiß da was woran es liegt.
gz Lassi

Alala

Âuch das problem mit setting up client aber bei mir steht

Code

extDB2: Version: 64
extDB2: https://github.com/Torndeco/extDB2
extDB2: Windows Debug Version




extDB2: Found extdb-conf.ini
extDB2: Detected 1 Cores, Setting up 2 Worker Threads







[00:54:56:681 +02:00] [Thread 3376] extDB2: Extension Input from Server: 1:SQL:TEST1:testing
[00:54:56:681 +02:00] [Thread 3376] extDB2: Extension Output to Server: [1]
[00:54:56:682 +02:00] [Thread 3376] extDB2: Extension Input from Server: 1:SQL:TEST2:testing
[00:54:56:682 +02:00] [Thread 3376] extDB2: Extension Output to Server: [1]
[00:54:56:682 +02:00] [Thread 3376] extDB2: Extension Input from Server: 1:SQL:TEST3:testing
[00:54:56:682 +02:00] [Thread 3376] extDB2: Extension Output to Server: [1]
[00:54:56:682 +02:00] [Thread 3376] extDB2: Extension Input from Server: 1:SQL:TEST4:testing
[00:54:56:682 +02:00] [Thread 3376] extDB2: Extension Output to Server: [1]
[00:54:56:682 +02:00] [Thread 3376] extDB2: Extension Input from Server: 1:SQL:TEST5:testing
[00:54:56:682 +02:00] [Thread 3376] extDB2: Extension Output to Server: [1]
[00:54:56:683 +02:00] [Thread 3376] extDB2: Extension Input from Server: 1:SQL:TEST1:testing
[00:54:56:683 +02:00] [Thread 3376] extDB2: Extension Output to Server: [1]
[00:54:56:683 +02:00] [Thread 3376] extDB2: Extension Input from Server: 1:SQL:TEST2:testing
[00:54:56:683 +02:00] [Thread 3376] extDB2: Extension Output to Server: [1]
[00:54:56:683 +02:00] [Thread 3376] extDB2: Extension Input from Server: 1:SQL:TEST3:testing
[00:54:56:683 +02:00] [Thread 3376] extDB2: Extension Output to Server: [1]
[00:54:56:683 +02:00] [Thread 3376] extDB2: Extension Input from Server: 1:SQL:TEST4:testing
[00:54:56:683 +02:00] [Thread 3376] extDB2: Extension Output to Server: [1]
[00:54:56:683 +02:00] [Thread 3376] extDB2: Extension Input from Server: 1:SQL:TEST5:testing

Alles anzeigen

extDB2 Einrichten - so geht's richtig

Ähnliche Themen

ArmA 3: Dedicated Server einrichten unter Windows (mit extDB3 & 64bit) (Altis Life & Tanoa Life) [2025 Tutorial / Guide]

Skins für Cops

Fehler in der Stringstable

server probleme hoffe ihr könnt mir helfen.

extDB2 Fehler (schon wieder -.-)

Tags