商店页面
Arma 3
全部 讨论 截图 艺术作品 实况直播 视频 创意工坊 新闻 指南 评测
Arma 3 >  创意工坊 > Xeno 的创意工坊 > co40 Domination! Blufor [4.70] > 讨论
co40 Domination! Blufor [4.70]
描述 讨论102 留言3752 改动说明
Satanic Warhamster 2020 年 11 月 8 日 下午 12:40
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 编辑于; 2020 年 11 月 8 日 下午 12:47
< >
正在显示第 1 - 15 条，共 20 条留言
Satanic Warhamster 2020 年 11 月 9 日 下午 1:16 
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 编辑于; 2020 年 11 月 15 日 上午 6:44
#1
facetti 2020 年 11 月 12 日 上午 8:39 
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 编辑于; 2020 年 11 月 12 日 上午 9:17
#2
Xeno  [开发者] 2020 年 11 月 15 日 上午 12:18 
Check your database logs in the extDB3 folder
#3
Xeno  [开发者] 2020 年 11 月 15 日 上午 12:19 
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 2020 年 11 月 15 日 上午 6:42 
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 2020 年 11 月 18 日 上午 4:03 
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  [开发者] 2020 年 11 月 19 日 上午 8:14 
Execute the DAddColumn_d_vrespawn_vecs_4_39.sql in Heidi (from the 4.39 download)
#7
Vill 2020 年 11 月 21 日 上午 1:40 
引用自 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 编辑于; 2020 年 11 月 21 日 上午 1:41
#8
Xeno  [开发者] 2020 年 11 月 21 日 上午 5:01 
An empty array
[]
#9
Satanic Warhamster 2020 年 11 月 25 日 上午 11:17 
引用自 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 2021 年 4 月 25 日 上午 1:51 
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  [开发者] 2021 年 4 月 29 日 上午 7:21 
Have you donwloaded extDB3 itself and copied it into the extDB3 folder and root folder?

#12
Ravenger2709 2021 年 4 月 29 日 上午 8:28 
Yup, it works, thx
#13
LogicSix 2021 年 7 月 15 日 下午 5:36 
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  [开发者] 2021 年 8 月 3 日 上午 7:01 
LogicSix, just follow the readme and ask if you have problems
#15
< >
正在显示第 1 - 15 条，共 20 条留言
每页显示数： 1530 50