Hi, I installed this plugin on my servers but the database file isn't getting created. Is there some other requirement for that besides just putting a path like "C:\\ArkCluster\\_common\\DiscordChat\\data\\ASACrossChat.db"? I see the plugin is loaded correctly because chat is getting modified according to the settings I have set in the plugin (like including platform name). But no db file even though cross chat is enabled.
Ok, progress. The default config file uses the old format, before MySQL support was added. I found the new config file format on Github. Note the "Database" key.
"Crosschat": {
"Enable": true,
"ClearInterval": 10,
"ClearMessages": true,
"ShowMapname": true,
"ShowTribeName": true,
"ShowSteamName": true,
"ShowIcons": true,
"ShowPlatform": true,
"MapnameColor": "0.3,0.3,0.3,1",
"SenderNameColor": "0.5,1,0.5,1",
"TribeNameColor": "0.5,1,0.5,1",
"SteamNameColor": "0.5,1,0.5,1",
"MessageColor": "0.4,0.3,0.1,1",
"Database": {
"MysqlDB": "myDb",
"MysqlHost": "127.0.0.1",
"MysqlPass": "snipsnip",
"MysqlPort": 3306,
"MysqlUser": "myuser",
"UseMysql": true,
"DbPathOverride": "C:\\ASACrossChat.db"
},
"CurrentServer": "TI",
"Servers": "SE,Event"
}
However, when using MySQL, something odd is happening. First, the AsaApi log spams this message every time a player sends a chat message:
09/04/24 11:29 [DiscordChat][error] (C:\Users\ohmco\Documents\GitHub\AsaApi.Plugins.DiscordChatDev\src\Database\ChatTmpSqlLiteDB.h ChatSqlLite::ClearDBMessages) UpdateDBMessage Unexpected DB error database is locked
Second, the plugin CAN connect to the MySQL database--I can see that because it created a table in the database--however if it is not writing any rows to that database.
Any ideas?