firefly2442

It's not an error, just an information message. It closes the connection to the server because there were problems with keeping it open for extended periods of time and crashes. This way, it closes it down and then reopens it when another request is made.

What do you mean by "issue command"?

Have you checked both the appdata and root Arma2/3 directory for logs? There should be a log assuming it's setup correctly.

Hmm, I'm not sure sorry. You might want to try creating a new thread with this question, it probably would get more views. Somebody should have an idea. :)

https://community.bistudio.com/wiki/player

Try checking if "player" is nil or not defined. That may be making your "_pid" variable nil.

I would start with the regular non async version first for testing. The way you have it setup won't work for the async version. See the readme for details. Also the SQL statement can possibly return more than one row and depending on the structure more than one column. I'm not sure how you have the database setup but I think it will need some additional "cleaning" before you do the comparison check on line 11.

Is '_pid' nil? Have you looked at this for an example? https://github.com/firefly2442/Arma2NetMySQLPlugin-Arma3-ExampleMission/blob/master/as_loadouts/server_events.sqf

You're missing a single quote. It should be SELECT * FROM instructors WHERE pid='123xyz'

You just need the dependency listed above. You don't need to setup a SQLite server if you're only using MySQL.

You need to install the SQLite dependency version 1.0.89.0. http://system.data.sqlite.org/index.html/artifact/d15406bb51f93db2?ln http://arma2netmysqlplugin.readthedocs.org/en/latest/#requirements

I'm not sure, I don't do any development with it, sorry. You might try asking in the other forum thread.

The MySQL server can be on Linux if you want, the Arma 3 server cannot be currently on Linux because the callExtension method isn't supported by the Linux server. We need to petition BIS to add this.

It won't work on Linux. callExtension isn't supported by Linux, we need to petition BIS to add this.

I'm guessing it's having trouble finding one of the dependencies. Can you post the log files?

The current setup should work. Both systems can use the same Databases.txt file. You can have multiple databases defined in this file. Then you can have one database for Arma2 and one database for Arma3.

I'm not sure I follow. If you're already running two separate servers, you're running two separate instances of Arma2NET and the plugin. I'm not sure how this is any different.

I think that should be OK. I've never actually tried it though. If you try it, let me know how it goes.

One solution is to use the asynchronous call. This will return back to the server immediately as you mentioned preventing it from locking the server waiting for the return. There is currently no way to make multiple query calls from the server before they return, and return results to the correct person. Even if you could do this, I don't think it would result in any speed improvements since it all has to go through the server anyway. My only suggestions would be: 1) Make sure the SQL server is on the same machine as the game server. 2) Use the asynchronous method 3) Try to combine multiple queries into one. If you have suggestions or improvements for the existing system I would love to hear them. I've done my best to try to keep decent performance but if there is a way to speed it up, I would certainly like to improve it. At the current level though, I can't think of anything that would help.

http://forums.bistudio.com/showthread.php?168139-Altis-Life-RPG&p=2552484&viewfull=1#post2552484

http://system.data.sqlite.org/index.html/artifact/d15406bb51f93db2?ln Yeah, you can't use 1.0.91.0. You need to install this specific version. Or, compile it yourself if you absolutely want to use the latest version.

Yep, as explained in the readme you need both dependencies, even if you're using just MySQL. http://arma2netmysqlplugin.readthedocs.org/en/latest/#requirements

http://arma2netmysqlplugin.readthedocs.org/en/latest/#troubleshooting they are empty?

I was not able to replicate your problem. Here is the code I copied into the initialization of a unit. idval = "12345"; uid = "123"; query = format ["INSERT INTO users (id, uid) VALUES ('%1','%2')", idval, uid]; hint(query); run = "Arma2Net.Unmanaged" callExtension format ["Arma2NETMySQLCommand ['weaponsArma3', '%1']", query]; hint(run); I'm honestly not quite sure... it looks the same as yours. Are you trying to insert any data with commas in them? ---------- Post added at 01:40 ---------- Previous post was at 01:36 ---------- I'm not able to replicate your problem. Can you provide any other details? ---------- Post added at 01:41 ---------- Previous post was at 01:40 ---------- Please provide Arma2NETMySQL log files.

You're sure there are no logs here when you run the game? C:\Users\Yourname\AppData\Local\Arma2NET\ But they do show up here when you run Arma2NETExplorer? Where do you have Arma2NET located? Is it in the root Arma2 OA folder? If so, try copying it to the beta folder directory. Perhaps it's not getting loaded in because of that?...