Servus,
ich möchte mich in meinem Wissen in Arma 3 .sqf und Modding bereich erweitern.
Nur ich habe das Problem was mich schon früher mehrere Stunden unnötigen Aufwand gekostet hat.
Wie man es im Titel schon lesen kann geht es um extDB2. Ich benutze die [lexicon]Tanoa[/lexicon] Life Version die hier im Forum als Download angeboten wird und auch die mitgelieferte .sql und extDB2.
Ich habe meine Daten in der ini datei geänder etc...
Ich benutze nicht MYSQL sprich das Offizelle sondern ich benutze XAMPP finde ich persönlich schöner und einfacher.
Nun kommen wir mal zu der Ini datei:
Spoiler anzeigen
[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 = password
;; 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
[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
[Databse2] ( AlitsLife geht ebenfalls nicht )
Type = MySQL
Name = altislife ( da ich meine datenbank selber hoste kann ich alles selbst einstelle habe einen extra benutzer für arma 3 erstellt falls es für Verwirrung sorgen sollte. )
Username = altislife
Password = 123456
IP = localhost ( 127.0.0.1 geht auch nicht. )
Port = 3306
;minSessions = 2
idleTime = 60
compress = false
; Really should only use this if MySQL server is external. Also only for MySQL
Secure Auth = true
; Recommend you turn this on @@16a2a5572b592480231defd062ecb787fd3d3b38@@
[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
Das stimmt alles soweit, ja ich weiß sehr nützliches Passwort.
Kommen wir nun zu den Logs die TADST auspuckt:..
Spoiler anzeigen
2016/11/28, 1:32:06 No speaker given for Vasilis Karmanlis
2016/11/28, 1:32:06 No speaker given for Evripidis Karmanlis
2016/11/28, 1:32:06 No speaker given for Michalis Mastori
2016/11/28, 1:32:06 No speaker given for Vasilis Zenon
2016/11/28, 1:32:06 No speaker given for Kouris Manelia
2016/11/28, 1:32:06 No speaker given for Angelos Nicolau
2016/11/28, 1:32:06 No speaker given for Michalis Petridis
2016/11/28, 1:32:06 No speaker given for Samaras Athanasiadis
2016/11/28, 1:32:06 No speaker given for Biton Christou
2016/11/28, 1:32:06 No speaker given for Fotini Dimitriadis
2016/11/28, 1:32:06 No speaker given for Militiadis Manelia
2016/11/28, 1:32:06 No speaker given for Sotiris Gikas
2016/11/28, 1:32:06 No speaker given for Thanos Kammenou
2016/11/28, 1:32:06 No speaker given for Sotiris Stanis
2016/11/28, 1:32:06 No speaker given for Evripidis Manetta
2016/11/28, 1:32:06 No speaker given for Nicolo Nicolau
2016/11/28, 1:32:06 No speaker given for Costa Stanis
2016/11/28, 1:32:06 No speaker given for Militiadis Papadopoulos
2016/11/28, 1:32:06 No speaker given for Thamos Malas
2016/11/28, 1:32:06 No speaker given for Panos Ioannou
2016/11/28, 1:32:06 No speaker given for Thanos Ioannou
2016/11/28, 1:32:06 No speaker given for Vasilis Elias
2016/11/28, 1:32:06 No speaker given for Gamba Achebe
2016/11/28, 1:32:06 No speaker given for Patterson Newton
2016/11/28, 1:32:06 No speaker given for Greer Walker
2016/11/28, 1:32:06 Strange convex component70 in a3\structures_f_exp\commercial\multistorybuilding_01\multistorybuilding_01_f.p3d:geometryFire
2016/11/28, 1:32:06 Strange convex component75 in a3\structures_f_exp\commercial\multistorybuilding_01\multistorybuilding_01_f.p3d:geometryFire
2016/11/28, 1:32:06 Strange convex component76 in a3\structures_f_exp\commercial\multistorybuilding_01\multistorybuilding_01_f.p3d:geometryFire
2016/11/28, 1:32:06 Strange convex component77 in a3\structures_f_exp\commercial\multistorybuilding_01\multistorybuilding_01_f.p3d:geometryFire
2016/11/28, 1:32:06 Strange convex component78 in a3\structures_f_exp\commercial\multistorybuilding_01\multistorybuilding_01_f.p3d:geometryFire
2016/11/28, 1:32:07 Connected to Steam servers
2016/11/28, 1:32:07 Error: Object(2 : 750) not found
2016/11/28, 1:32:07 Error: Object(2 : 755) not found
2016/11/28, 1:32:07 Error: Object(2 : 757) not found
2016/11/28, 1:32:07 Error: Object(2 : 759) not found
2016/11/28, 1:32:07 Error: Object(2 : 870) not found
2016/11/28, 1:32:07 c:\w\stable\futura\lib\network\networkserver.cpp NetworkServer::OnClientStateChanged:NOT IMPLEMENTED - briefing!
2016/11/28, 1:32:07 Mission id: bfa47f5e6ba3003924762b069a51a49802df9134
2016/11/28, 1:32:07 "extDB2: Error with Database Connection"
P.s Ich habe die SuFu benutzt bin jedoch auf keine wirklich Hilfreiche Lösung gestoßen.
Habe das Lexikon durchgeschaut jedoch gehen dort einige Verlinkungen nicht mehr zu meinem Problem.
Hoffe wie gesagt auf #latenighthelp. Werde sobald ich eine Lösung gefunden habe alleine / oder mich euch. Den Lösungsweg hier posten.