หน้าร้านค้า
Arma 3
ทั้งหมด กระดานสนทนา ภาพหน้าจอ อาร์ตเวิร์ก ถ่ายทอดสด วิดีโอ เวิร์กชอป ข่าวสาร คู่มือ บทวิจารณ์
Arma 3 >  เวิร์กชอป > เวิร์กชอปของ Xeno > co40 Domination! Blufor [4.70] > กระดานสนทนา
co40 Domination! Blufor [4.70]
คำอธิบาย กระดานสนทนา102 ความเห็น3752 หมายเหตุการเปลี่ยนแปลง
Satanic Warhamster 8 พ.ย. 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?
แก้ไขล่าสุดโดย Satanic Warhamster; 8 พ.ย. 2020 @ 12: 47pm
< >
กำลังแสดง 1-15 จาก 20 ความเห็น
Satanic Warhamster 9 พ.ย. 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?
แก้ไขล่าสุดโดย Satanic Warhamster; 15 พ.ย. 2020 @ 6: 44am
#1
facetti 12 พ.ย. 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?
แก้ไขล่าสุดโดย facetti; 12 พ.ย. 2020 @ 9: 17am
#2
Xeno  [ผู้พัฒนา] 15 พ.ย. 2020 @ 12: 18am 
Check your database logs in the extDB3 folder
#3
Xeno  [ผู้พัฒนา] 15 พ.ย. 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 พ.ย. 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 พ.ย. 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  [ผู้พัฒนา] 19 พ.ย. 2020 @ 8: 14am 
Execute the DAddColumn_d_vrespawn_vecs_4_39.sql in Heidi (from the 4.39 download)
#7
Vill 21 พ.ย. 2020 @ 1: 40am 
โพสต์ดั้งเดิมโดย 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 ?
แก้ไขล่าสุดโดย Vill; 21 พ.ย. 2020 @ 1: 41am
#8
Xeno  [ผู้พัฒนา] 21 พ.ย. 2020 @ 5: 01am 
An empty array
[]
#9
Satanic Warhamster 25 พ.ย. 2020 @ 11: 17am 
โพสต์ดั้งเดิมโดย 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 เม.ย. 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  [ผู้พัฒนา] 29 เม.ย. 2021 @ 7: 21am 
Have you donwloaded extDB3 itself and copied it into the extDB3 folder and root folder?

#12
Ravenger2709 29 เม.ย. 2021 @ 8: 28am 
Yup, it works, thx
#13
LogicSix 15 ก.ค. 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  [ผู้พัฒนา] 3 ส.ค. 2021 @ 7: 01am 
LogicSix, just follow the readme and ask if you have problems
#15
< >
กำลังแสดง 1-15 จาก 20 ความเห็น
ต่อหน้า: 1530 50