a3wasteland extdb

a3wasteland extdb

« posted: Jun 29, 2016, 12:13 AM »
I tried setting up extdb i downloaded the A3W_extDB_pack changed all the settings imported the sql file into the database put all username and passwords in etc but it's not writing any info into the columns i did select Name FROM PlayerInfo;
but it says empty

Also i replaced the A3Wasteland_settings/main_config.sqf into the mission pbo server/default cfg but still no difference i can join but it's just not running the mysql it might be because i need to remove profiles from
command line...

-config=config.cfg -cfg=basic.cfg -profiles=@Profiles -name=server -port=2302 -nosplash -exThreads=8


extdb-conf

Code: [Select]
[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


;################################################################################################################################
;##                                                                                                                            ##
;##    A3WASTELAND DATABASE                                                                                                    ##
;##                                                                                                                            ##

[A3W]
Type = MySQL
Name = a3wasteland

Username = arma3
Password = password

IP = 127.0.0.1
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  http://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html#option_mysql_secure-auth

;##                                                                                                                            ##
;##                                                                                                                            ##
;################################################################################################################################


[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


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

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


[MySQL_Example]
Type = MySQL
Name = Database_Name

Username = arma3
Password = password

IP = 127.0.0.1
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  http://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html#option_mysql_secure-auth


[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

Re: a3wasteland extdb

« Reply #1 posted: Jul 01, 2016, 07:45 PM »
im sure your missing a server launch parameter

To solve this problem, you simply need to add -filePatching to your arma3server command line, and allowedFilePatching = 1; to your server.cfg.

it needs that so it can read the files in A3Wasteland_settings in the root of your arma directory


look at this post
http://forums.a3wasteland.com/index.php?topic=2153.0

hope this helps