Store Page
Arma 3
All Discussions Screenshots Artwork Broadcasts Videos Workshop News Guides Reviews
Arma 3 >  Workshop > Xeno's Workshop > co40 Domination! Blufor [4.69] > Discussions
co40 Domination! Blufor [4.69]
Description Discussions101 Comments3747 Change Notes
Satanic Warhamster 8 Nov, 2020 @ 12:40pm
Can't get database to work
Nothing gets written to the database. What am I doing wrong?
Here's what I did:
  • Installed Maria DB and HeidiSQL
  • Opened HeidiSQL, created a session, ran the domination.sql script, it created the database.
  • Created a new user. name - arma3domination, password - 123123Dd. Gave it permissions on the domination database to select, insert, update, delete and lock tables.
  • Downloaded extDB3, put the @extDB3 folder in C:\Program Files (x86)\Steam\steamapps\common\Arma 3\
  • Copied tbbmalloc.dll and tbbmalloc_x64.dll from C:\Program Files (x86)\Steam\steamapps\common\Arma 3\@extDB3 to C:\Program Files (x86)\Steam\steamapps\common\Arma 3\@extDB3
  • Copied domination-custom.ini from the mission archive's @extDB3\sql_custom to C:\<...>\Arma3\@extDB3\sql_custom and the extdb3-conf.ini file to C:\<...>\Arma3\@extDB3
  • Edited the extdb3-config.ini file so that its contents are like this: https://pastebin.com/xXsLehZG
  • Opened up the Arma launcher, went to PARAMETERS > ALL PARAMETERS > Server-side Mods and typed @extDB3 there (also tried using the directory browser to give it the full location)
    https://i.imgur.com/iyayXTt.png
  • Press PLAY in the launcher. In Arma I go to MULTIPLATER > SERVER BROWSER > HOST GAME, start the mission, mess around a bit
  • I check the domination database in HeidiSQL and see that nothing was inserted: https://i.imgur.com/xCVnZVC.png

Did I miss something? Are there any logs somewhere that I could send you?
Last edited by Satanic Warhamster; 8 Nov, 2020 @ 12:47pm
< >
Showing 1-15 of 19 comments
Satanic Warhamster 9 Nov, 2020 @ 1:16pm 
Ok, so I managed to get it to do something by adding @extDB3 to "Mods" parameter instead of "Server-side Mods". Is this how it should be done?
I also had to disable Battleye as it was blocking one of extDB3's dll file. So saving the mission progress is incompatible with Battleye then? Or is there a way around it?
Also players couldn't connect anymore. I kept seeing "Player NAME connecting" followed immeadiatelly by "Player NAME disconnected". Could this have been caused by using @extDB3 not as a server-side mod? For example, could loading it with -mod parameter make it a required mod for other clients to have and could that be why they couldn't connect?
Last edited by Satanic Warhamster; 15 Nov, 2020 @ 6:44am
#1
facetti 12 Nov, 2020 @ 8:39am 
same problem here - did all the steps above, disabled balltle eye and tested @exDB3 as mod and as server mod.

I've enabled the database log and can't see any interaction from ARMA with the database but chnces using Heidi. So, logging works.

Can't get database running on the ARMA server - any hints?
Last edited by facetti; 12 Nov, 2020 @ 9:17am
#2
Xeno  [developer] 15 Nov, 2020 @ 12:18am 
Check your database logs in the extDB3 folder
#3
Xeno  [developer] 15 Nov, 2020 @ 12:19am 
And be sure that you have created a database user and set the database rights correctly

(and of course that you have downloaded extDB3 itself :) )
#4
Satanic Warhamster 15 Nov, 2020 @ 6:42am 
Hi Xeno. Yeah, I did and eventually even got it to write something into the database, as I've said in the second comment. But there are further questions there.
#5
Vill 18 Nov, 2020 @ 4:03am 
Hello Xeno,

I'm having the same issue. The logs only reports this :

extDB3: Found extdb3-conf.ini
extDB3: Detected 4 Cores, Setting up 4 Worker Threads
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...


[12:45:59:291992 +01:00] [Thread 2196] extDB3: Locked
[13:02:45:933593 +01:00] [Thread 1592] extDB3: SQL: Error MariaDBStatementException1: Field 'd_vrespawn_vecs' doesn't have a default value
[13:02:45:933593 +01:00] [Thread 1592] extDB3: SQL: Error MariaDBStatementException1: Input: missionInsert:d_dom_db_autosave:34:[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,21,22,23,24,25,26,27,28,29,30,31,32,33]:20:15:[20]:[]:[15,47,3,104,23,1,2,43,65,64,50011,101,50021,10,70,18,51,102,105,50003,103,71,41,42,56,50,26,45,38,27,11,50040,66,61,52,0,50020,34,50012,22,35,50032,50001,58,51243,21,50031,19,62,16,48,20,106,63,60,28,44,49,30,53,14,12,25,36,50002,59,51245,74,7,73,31,67,50041,50010,17,29,57,100,50022,24,4,6,50030,32,46,39,8,5,54,69,51244,37,9,68,13,55,72,33,40]:0:[0,0,0,0,0,1,0]:["I_MRAP_03_hmg_F"]:altis:altisd_dom_db_autosave:altisd_dom_db_autosaveco40 domination! blufor [4.38] edited =fob=:[]
[13:02:45:935546 +01:00] [Thread 1592] extDB3: SQL: Error MariaDBStatementException1: Field 'd_vrespawn_vecs' doesn't have a default value
[13:02:45:935546 +01:00] [Thread 1592] extDB3: SQL: Error MariaDBStatementException1: Input: missionInsert:d_dom_db_autosave:34:[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,21,22,23,24,25,26,27,28,29,30,31,32,33]:20:15:[20]:[]:[15,47,3,104,23,1,2,43,65,64,50011,101,50021,10,70,18,51,102,105,50003,103,71,41,42,56,50,26,45,38,27,11,50040,66,61,52,0,50020,34,50012,22,35,50032,50001,58,51243,21,50031,19,62,16,48,20,106,63,60,28,44,49,30,53,14,12,25,36,50002,59,51245,74,7,73,31,67,50041,50010,17,29,57,100,50022,24,4,6,50030,32,46,39,8,5,54,69,51244,37,9,68,13,55,72,33,40]:0:[0,0,0,0,0,1,0]:["I_MRAP_03_hmg_F"]:altis:altisd_dom_db_autosave:altisd_dom_db_autosaveco40 domination! blufor [4.38] edited =fob=:[]
[13:02:45:935546 +01:00] [Thread 1592] extDB3: SQL: Error Max Retrys Reached
[13:02:45:935546 +01:00] [Thread 1592] extDB3: SQL: Error Max Retrys Reached

#6
Xeno  [developer] 19 Nov, 2020 @ 8:14am 
Execute the DAddColumn_d_vrespawn_vecs_4_39.sql in Heidi (from the 4.39 download)
#7
Vill 21 Nov, 2020 @ 1:40am 
Originally posted by Xeno:
Execute the DAddColumn_d_vrespawn_vecs_4_39.sql in Heidi (from the 4.39 download)
Hello Xeno
I've already tried, it says "SQL error (1060): Duplicate column name 'd_vrespawn_vecs'. I can see the column, but it is true there is no default value set. What should it be ?
Last edited by Vill; 21 Nov, 2020 @ 1:41am
#8
Xeno  [developer] 21 Nov, 2020 @ 5:01am 
An empty array
[]
#9
Satanic Warhamster 25 Nov, 2020 @ 11:17am 
Originally posted by Satanic Warhamster:
Ok, so I managed to get it to do something by adding @extDB3 to "Mods" parameter instead of "Server-side Mods". Is this how it should be done?
I also had to disable Battleye as it was blocking one of extDB3's dll file. So saving the mission progress is incompatible with Battleye then? Or is there a way around it?
Also players couldn't connect anymore. I kept seeing "Player NAME connecting" followed immeadiatelly by "Player NAME disconnected". Could this have been caused by using @extDB3 not as a server-side mod? For example, could loading it with -mod parameter make it a required mod for other clients to have and could that be why they couldn't connect?

Anything about this?
#10
Ravenger2709 25 Apr, 2021 @ 1:51am 
Hi Xeno! extDB3 not working for me. I create DB in Heidi wit Domination.sql, create new user with all rights and filled up extDB3-config. I have no logs in my extDB3 folder..
#11
Xeno  [developer] 29 Apr, 2021 @ 7:21am 
Have you donwloaded extDB3 itself and copied it into the extDB3 folder and root folder?

#12
Ravenger2709 29 Apr, 2021 @ 8:28am 
Yup, it works, thx
#13
LogicSix 15 Jul, 2021 @ 5:36pm 
Hello, I'm a returning player. I wish to set up a Domination Public Server. I am hoping I can hire for needed help while setting up the databases. PM if interested.
#14
Xeno  [developer] 3 Aug, 2021 @ 7:01am 
LogicSix, just follow the readme and ask if you have problems
#15
< >
Showing 1-15 of 19 comments
Per page: 1530 50