Arma2MySQL

[firefly2442 6]

Do i need the SQLite dependency even though i'm using a MySQL Database?

Yes, you need it even if you're just using MySQL. (sorry, as far as I know there's no easy way to split this out)

[Beldum 3]

Do i need a SqLite DB installed for it to work 'cause i host my server through ViLayer and i have a SQL Server setup for it but i can't get a SqLite DB setup on the ArmA 3 servers Local machine.

[firefly2442 6]

No, the database itself does not need to be setup. Just run the installer. This installs the necessary .DLL file that it's looking for (and cannot find).

[Beldum 3]

That may be a stupid question but, Does the .DLL file get installed in the @ArmA2Net or somewhere in the system?

I'm just wondering 'cause if it's installed to the system, i'll have to ask ViLayer to run it.

Edit-

now i'm getting a new error. This one gives me a ingame "Hint" with a bunch of text and the ArmA2Net log file says this

11/13/2013 Result: System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

I have installed mysql-connector-net-6.7.4.msi as specified in the ReadMe.html

Edit-

Do i need to have the dependency installed on the computer that the SQL Server is being ran on, or do i need it installed on the computer that ArmA 3 is being ran on?

Edited November 13, 2013 by nick103

[firefly2442 6]

The DLL for MySQL and SQLite should be installed system wide. Note that these are different than the plugin DLL that is in @Arma2NET. Both dependencies need to be installed on the computer running Arma3. The MySQL server can be on a remote computer if you wish, or it can be on the same machine as Arma.

[Beldum 3]

Yes, i have installed both of the dependencies on the ArmA 3 Server but i still get the "Could not load file or assembly 'MySql.Data" error in the log file.

My SQL Server is on a remote computer and i have changed the IP and Port in the Databases text file.

I followed your tutorial video you have in your drop box but i can't seem to get it to work.

Would it be possible to have your Skype to speed up this process? If not, that's fine though.

My skype name is nick10319

edit-

Here's a screenshot of the Ingame error i'm getting.

https://www.dropbox.com/s/b2mhw1ngj265d59/2013-11-13_00001.jpg

edit -

Ok, i fixed the error of ArmA2Net not being able to find the MySql.Data file by copying MySql.Data.dll directly into @ArmA2Net but i'm still getting one last error.

11/13/2013 22:39:45 function: Arma2NETMySQLCommandAsync ['weaponsArma3', 'SELECT name FROM users WHERE uid = '76561198085735088'']

11/13/2013 22:39:45 maxResultSize: 10239

11/13/2013 22:39:45 Result size: 0

11/13/2013 22:39:45 Result: <null>

That's the only thing in the log and it's just repeated.

Edit again -

Fixed that.

In the Database.txt, the line of code was mysql,weapons,119.252.190.185,5000,ArmA3Test,*password* but the Database was named weaponsArma3, not just weapons

Edited November 13, 2013 by nick103

[Beldum 3]

Would you be able to tell me why this isn't working and give me a few pointers on how to fix it?

SaveScript1

_UID = getPlayerUID player;

_magazines = magazines player;

_Weapons = weapons player;

_items = items player;

_assignedItems = assignedItems player;

_headgear = headgear player;

_goggles = goggles player;

_vest = vest player;

_vestItems = vestItems player;

_uniform = uniform player;

_uniformItems = uniformItems player;

_backpack = backpack player;

_backpackItems = backpackItems player;

_handgunItems = handgunItems player;

_primaryWeaponItems = primaryWeaponItems player;

_secondaryWeaponItems = secondaryWeaponItems player;

_dir = getDir player;

_pos = getPosASL player;

_dammage = getDammage player;

hint "Vars Set";

[[[_UID, _magazines, _Weapons, _items, _assignedItems, _headgear, _goggles, _vest, _vestItems, _uniform, _uniformItems, _backpack, _backpackItems, _handgunItems, _primaryWeaponItems, _secondaryWeaponItems, _dir, _pos, _dammage],"ServerStats\PlayerSave.sqf"],"BIS_fnc_execVM",false,false] spawn BIS_fnc_MP;

hint "Stats Sent";

PlayerSave.sqf

_UID = _this select 0;

_magazines = _this select 1;

_Weapons = _this select 2;

_items = _this select 3;

_assignedItems = _this select 4;

_headgear = _this select 5;

_goggles = _this select 6;

_vest = _this select 7;

_vestItems = _this select 8;

_uniform = _this select 9;

_uniformItems = _this select 10;

_backpack = _this select 11;

_backpackItems = _this select 12;

_handgunItems = _this select 13;

_primaryWeaponItems = _this select 14;

_secondaryWeaponItems = _this select 15;

_dir = _this select 16;

_pos = _this select 17;

_dammage = _this select 18;

hint "Stats Recieved";

_query = format ["INSERT into playerstats (uid, ammo, weapons, items, assignitems, headgear, goggles, vest, vestitems, uniform, uniformitems, backpack, packitems, handgunitems, primarywep, secondarywep, Direction, Position, Damage) VALUES ('%1', '%2', '%3', '%4', '%5', '%6', '%7', '%8', '%9', '%10', '%11', '%12', '%13', '%14', '%15', '%16', '%17', '%18')", _UID, _magazines, _Weapons, _items, _assignedItems, _headgear, _goggles, _vest, _vestItems, _uniform, _uniformItems, _backpack, _backpackItems, _handgunItems, _primaryWeaponItems, _secondaryWeaponItems, _dir, _pos, _dammage];

hint "Sending Stats to SQL";

_return = "Arma2Net.Unmanaged" callExtension format ["Arma2NETMySQLCommandAsync ['altislife', '%1']", _query];

hint "Stats Successfully sent";

It returns this in the ArmA2Net.log file

11/14/2013 00:37:51 function: Arma2NETMySQLCommandAsync ['altislife', 'INSERT into playerstats (uid, ammo, weapons, items, assignitems, headgear, goggles, vest, vestitems, uniform, uniformitems, backpack, packitems, handgunitems, primarywep, secondarywep, Direction, Position, Damage) VALUES ('76561198085735088', '["30Rnd_65x39_caseless_mag","30Rnd_65x39_caseless_mag","30Rnd_65x39_caseless_mag","30Rnd_65x39_caseless_mag","30Rnd_65x39_caseless_mag","30Rnd_65x39_caseless_mag","30Rnd_65x39_caseless_mag","30Rnd_65x39_caseless_mag","30Rnd_65x39_caseless_mag","16Rnd_9x21_Mag","16Rnd_9x21_Mag","SmokeShell","SmokeShellGreen","Chemlight_green","Chemlight_green","HandGrenade","HandGrenade"]', '["arifle_MX_ACO_pointer_F","hgun_P07_F"]', '["FirstAidKit"]', '["ItemMap","ItemCompass","ItemWatch","ItemRadio","NVGoggles"]', 'H_HelmetB', 'G_Tactical_Black', 'V_PlateCarrier1_rgr', '["30Rnd_65x39_caseless_mag","30Rnd_65x39_caseless_mag","30Rnd_65x39_caseless_mag","30Rnd_65x39_caseless_mag","30Rnd_65x39_caseless_mag","30Rnd_65x39_caseless_mag","16Rnd_9x21_Mag","16Rnd_9x21_Mag","SmokeShell","SmokeShellGreen","Chemlight_green","Chemlight_green","HandGrenade","HandGrenade"]', 'U_B_CombatUniform_mcam', '["FirstAidKit","30Rnd_65x39_caseless_mag","30Rnd_65x39_caseless_mag","30Rnd_65x39_caseless_mag"]', '', '[]', '["","",""]', '["","acc_pointer_IR","optic_Aco"]', '[]', '227.413', '[1873.47,5893.59,5.50144]')']

11/14/2013 00:37:51 maxResultSize: 10239

11/14/2013 00:37:51 Result size: 0

11/14/2013 00:37:51 Result: <null>

[firefly2442 6]

I believe the issue is you're trying to use commas in the actual data itself. When the plugin parses this giant string, it needs some way to split them up into the appropriate variables (I picked a comma). This means that you will need to replace the commas in the actual data that you are trying to send with something else. In the example mission, I used "`" marks. See here:

https://github.com/firefly2442/Arma2NetMySQLPlugin-Arma3-ExampleMission/blob/master/as_loadouts/formatArray.sqf

Remember, because you are using the asynchronous command, you will need to call it again (I put mine in a while loop) to eventually get the result back from the database. See here:

https://github.com/firefly2442/Arma2NetMySQLPlugin-Arma3-ExampleMission/blob/master/as_loadouts/server_events.sqf

[Beldum 3]

I pretty much copied your script exactly but i'm still getting an Error.

Would you be able to have a look at my scripts and see if you can find an error?

I included a .sql file to setup the Database i'm using.

www.dropbox.com/s/9i0uu7ap96nercv/SQL%2520Test.Stratis.rar

edit-

Fixed that problem.

Could you suggest a way to check if a player is already saved to MySQL and if they are, make it load their stats and if they aren't in the DB, make it create a DB for them?

Edited November 14, 2013 by nick103

[Adeadlymen 10]

I am trying to setup a server(i am using mysql for it) but somehow it keeps saying that i am missing System.Data.SQLite. I moved both files into the @Arma2NET folder and they are also in addins/Arma2netMySQLPlugin folder. I included the log error it gave me. Does anyone know how i can fix it? Also when i launch my server and try to connect the game just freezes and the server says it is reading the mission and does nothing else.

11/13/2013 16:27:59 Caught exception of type System.Reflection.TargetInvocationException while loading add-in DefaultDomain

11/13/2013 16:27:59 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.88.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. Attempt to load an unverifiable executable with fixups (IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019) ---> System.IO.FileLoadException: Attempt to load an unverifiable executable with fixups (IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019)

--- End of inner exception stack trace ---

at System.Reflection.RuntimeAssembly.nLoadImage(Byte[] rawAssembly, Byte[] rawSymbolStore, Evidence evidence, StackCrawlMark& stackMark, Boolean fIntrospection, SecurityContextSource securityContextSource)

at System.Reflection.Assembly.Load(Byte[] rawAssembly)

at Arma2Net.Managed.AddInManager.DomainLoadAddIn(String assemblyFile)

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)

at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)

at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at Arma2Net.Managed.AddInManager.DomainDoCallback()

at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)

at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDomain domain, Delegate func, Object arg)

at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)

at Arma2Net.Managed.AddInManager.LoadAddIn(String assemblyFile)

11/13/2013 16:27:59 Domain Name Version Publisher Description

11/13/2013 16:27:59 DefaultDomain Arma2NETMySQL 0.1.0.0 firefly2442 Runs MySQL procedure commands.

11/13/2013 16:27:59 DefaultDomain Arma2NETMySQLCommand0.1.0.0 firefly2442 Runs raw MySQL/SQLite commands

11/13/2013 16:27:59 DefaultDomain Arma2NETMySQLCommandAsync0.1.0.0 firefly2442 Runs asynchronous raw MySQL/SQLite commands

11/13/2013 16:27:59 DefaultDomain ClrVersion 2.0.0.0 Scott_NZ Retrieves the version of the Common Language Runtime.

11/13/2013 16:27:59 DefaultDomain CompareVersion 2.0.0.0 Scott_NZ Compares two version strings and returns an integer indicating how they compare.

11/13/2013 16:27:59 DefaultDomain Version 2.0.0.0 Scott_NZ Returns the version of Arma2NET.

11/13/2013 16:27:59 DefaultDomain GetClipboardText 1.0.0.0 Scott_NZ Gets the clipboard text value.

11/13/2013 16:27:59 DefaultDomain SetClipboardText 1.0.0.0 Scott_NZ Sets the clipboard to a text value.

11/13/2013 16:27:59 DefaultDomain CommandLine 2.0.0.0 Scott_NZ Returns the command line used to start the application.

11/13/2013 16:27:59 DefaultDomain DateTime 2.0.0.0 Scott_NZ Returns the current date and time.

11/13/2013 16:27:59 Arma2NET initialized in 00:00:00.0533490

[Beldum 3]

Did you install the SqLite dependency?

I was having this issue the other day.

[firefly2442 6]

Could you suggest a way to check if a player is already saved to MySQL and if they are, make it load their stats and if they aren't in the DB, make it create a DB for them?

I would use a SELECT or COUNT statement combined with a check against their player UID. Something like, "SELECT * FROM tablename WHERE uid = '123xyz'" This will tell you if the entry exists, then you'll have to do a conditional check in SQF to see if you need to add an entry. Remember, a database is just a collection of tables with a structure that you specify. You will not need to create a new entire database for each user. (just a clarification based on the wording you used)

Hope that helps.

[Adeadlymen 10]

Alright i installed it and now it is working

[Beldum 3]

Yep, i got one working.

It checks if there's an existing profile and if it returns nil, it creates a new one.

[Beldum 3]

Can you suggest a way for me to Load everything from a DB into the Server on Server start?

I'm trying to make it save Vehicles and Objects (Like H-Barriers, Sand Bags, etc)

Edit-

I figured out a way :)

Edited November 15, 2013 by nick103

[silentkiller* 11]

I setted up a database (Oracle 5.5.32), loaded schema, created user etc. (assured auth was unchecked during installation wizard).

So i setted up the Databases file for Arma2NET.

I get this error(s?) in logs:

11/14/2013 21:25:24 Arma2NET 2.3.0.0 running on CLR 4.0.30319.18010

11/14/2013 21:25:24 Loaded into process arma3server

11/14/2013 21:25:24 Loading add-ins

11/14/2013 21:25:24 Caught exception of type System.Reflection.TargetInvocationException while loading add-in DefaultDomain

11/14/2013 21:25:24 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.88.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. Attempt to load an unverifiable executable with fixups (IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019) ---> System.IO.FileLoadException: Attempt to load an unverifiable executable with fixups (IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019)

--- End of inner exception stack trace ---

at System.Reflection.RuntimeAssembly.nLoadImage(Byte[] rawAssembly, Byte[] rawSymbolStore, Evidence evidence, StackCrawlMark& stackMark, Boolean fIntrospection, SecurityContextSource securityContextSource)

at System.Reflection.Assembly.Load(Byte[] rawAssembly)

at Arma2Net.Managed.AddInManager.DomainLoadAddIn(Stri ng assemblyFile)

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeIn ternal(Object obj, Object[] parameters, Object[] arguments)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at Arma2Net.Managed.AddInManager.DomainDoCallback()

at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)

at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDo main domain, Delegate func, Object arg)

at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)

at Arma2Net.Managed.AddInManager.LoadAddIn(String assemblyFile)

11/14/2013 21:25:24 Domain Name Version Publisher Description

11/14/2013 21:25:24 DefaultDomain Arma2NETMySQL 0.1.0.0 firefly2442 Runs MySQL procedure commands.

11/14/2013 21:25:24 DefaultDomain Arma2NETMySQLCommand0.1.0.0 firefly2442 Runs raw MySQL/SQLite commands

11/14/2013 21:25:24 DefaultDomain Arma2NETMySQLCommandAsync0.1.0.0 firefly2442 Runs asynchronous raw MySQL/SQLite commands

11/14/2013 21:25:24 DefaultDomain ClrVersion 2.0.0.0 Scott_NZ Retrieves the version of the Common Language Runtime.

11/14/2013 21:25:24 DefaultDomain CompareVersion 2.0.0.0 Scott_NZ Compares two version strings and returns an integer indicating how they compare.

11/14/2013 21:25:24 DefaultDomain Version 2.0.0.0 Scott_NZ Returns the version of Arma2NET.

11/14/2013 21:25:24 DefaultDomain GetClipboardText 1.0.0.0 Scott_NZ Gets the clipboard text value.

11/14/2013 21:25:24 DefaultDomain SetClipboardText 1.0.0.0 Scott_NZ Sets the clipboard to a text value.

11/14/2013 21:25:24 DefaultDomain CommandLine 2.0.0.0 Scott_NZ Returns the command line used to start the application.

11/14/2013 21:25:24 DefaultDomain DateTime 2.0.0.0 Scott_NZ Returns the current date and time.

11/14/2013 21:25:24 Arma2NET initialized in 00:00:00.0786089

11/14/2013 21:25:24 Caught exception of type System.Reflection.TargetInvocationException

11/14/2013 21:25:24 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

at Arma2NETMySQLPlugin.MySQL.OpenConnection(String connectionString)

at Arma2NETMySQLPlugin.DatabaseObject..ctor(String[] values)

at Arma2NETMySQLPlugin.Databases..ctor()

at Arma2NETMySQLPlugin.Startup.StartupConnection()

at Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Inv oke(String args, Int32 maxResultSize)

at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(Ad dInArguments args)

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeIn ternal(Object obj, Object[] parameters, Object[] arguments)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at Arma2Net.Managed.AddInManager.DomainDoCallback()

at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)

at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDo main domain, Delegate func, Object arg)

at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)

at Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(Strin g function, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize)

11/14/2013 21:25:24 function: Arma2NETMySQLCommand ['arma3life', 'CALL resetLifeVehicles();']

11/14/2013 21:25:24 maxResultSize: 10239

11/14/2013 21:25:34 Caught exception of type System.Reflection.TargetInvocationException

11/14/2013 21:25:34 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

at Arma2NETMySQLPlugin.MySQL.OpenConnection(String connectionString)

at Arma2NETMySQLPlugin.DatabaseObject..ctor(String[] values)

at Arma2NETMySQLPlugin.Databases..ctor()

at Arma2NETMySQLPlugin.Startup.StartupConnection()

at Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Inv oke(String args, Int32 maxResultSize)

at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(Ad dInArguments args)

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeIn ternal(Object obj, Object[] parameters, Object[] arguments)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at Arma2Net.Managed.AddInManager.DomainDoCallback()

at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)

at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDo main domain, Delegate func, Object arg)

at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)

at Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(Strin g function, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize)

11/14/2013 21:25:34 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid=76561198040330551']

11/14/2013 21:25:34 maxResultSize: 10239

11/14/2013 21:50:02 Arma2NET 2.3.0.0 running on CLR 4.0.30319.18010

11/14/2013 21:50:02 Loaded into process arma3server

11/14/2013 21:50:02 Loading add-ins

11/14/2013 21:50:03 Caught exception of type System.Reflection.TargetInvocationException while loading add-in DefaultDomain

11/14/2013 21:50:03 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.88.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. Attempt to load an unverifiable executable with fixups (IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019) ---> System.IO.FileLoadException: Attempt to load an unverifiable executable with fixups (IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019)

--- End of inner exception stack trace ---

at System.Reflection.RuntimeAssembly.nLoadImage(Byte[] rawAssembly, Byte[] rawSymbolStore, Evidence evidence, StackCrawlMark& stackMark, Boolean fIntrospection, SecurityContextSource securityContextSource)

at System.Reflection.Assembly.Load(Byte[] rawAssembly)

at Arma2Net.Managed.AddInManager.DomainLoadAddIn(Stri ng assemblyFile)

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeIn ternal(Object obj, Object[] parameters, Object[] arguments)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at Arma2Net.Managed.AddInManager.DomainDoCallback()

at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)

at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDo main domain, Delegate func, Object arg)

at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)

at Arma2Net.Managed.AddInManager.LoadAddIn(String assemblyFile)

11/14/2013 21:50:03 Domain Name Version Publisher Description

11/14/2013 21:50:03 DefaultDomain Arma2NETMySQL 0.1.0.0 firefly2442 Runs MySQL procedure commands.

11/14/2013 21:50:03 DefaultDomain Arma2NETMySQLCommand0.1.0.0 firefly2442 Runs raw MySQL/SQLite commands

11/14/2013 21:50:03 DefaultDomain Arma2NETMySQLCommandAsync0.1.0.0 firefly2442 Runs asynchronous raw MySQL/SQLite commands

11/14/2013 21:50:03 DefaultDomain ClrVersion 2.0.0.0 Scott_NZ Retrieves the version of the Common Language Runtime.

11/14/2013 21:50:03 DefaultDomain CompareVersion 2.0.0.0 Scott_NZ Compares two version strings and returns an integer indicating how they compare.

11/14/2013 21:50:03 DefaultDomain Version 2.0.0.0 Scott_NZ Returns the version of Arma2NET.

11/14/2013 21:50:03 DefaultDomain GetClipboardText 1.0.0.0 Scott_NZ Gets the clipboard text value.

11/14/2013 21:50:03 DefaultDomain SetClipboardText 1.0.0.0 Scott_NZ Sets the clipboard to a text value.

11/14/2013 21:50:03 DefaultDomain CommandLine 2.0.0.0 Scott_NZ Returns the command line used to start the application.

11/14/2013 21:50:03 DefaultDomain DateTime 2.0.0.0 Scott_NZ Returns the current date and time.

11/14/2013 21:50:03 Arma2NET initialized in 00:00:01.4353059

11/14/2013 21:50:03 Caught exception of type System.Reflection.TargetInvocationException

11/14/2013 21:50:03 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

at Arma2NETMySQLPlugin.MySQL.OpenConnection(String connectionString)

at Arma2NETMySQLPlugin.DatabaseObject..ctor(String[] values)

at Arma2NETMySQLPlugin.Databases..ctor()

at Arma2NETMySQLPlugin.Startup.StartupConnection()

at Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Inv oke(String args, Int32 maxResultSize)

at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(Ad dInArguments args)

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeIn ternal(Object obj, Object[] parameters, Object[] arguments)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at Arma2Net.Managed.AddInManager.DomainDoCallback()

at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)

at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDo main domain, Delegate func, Object arg)

at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)

at Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(Strin g function, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize)

11/14/2013 21:50:03 function: Arma2NETMySQLCommand ['arma3life', 'CALL resetLifeVehicles();']

11/14/2013 21:50:03 maxResultSize: 10239

11/14/2013 21:50:11 Caught exception of type System.Reflection.TargetInvocationException

11/14/2013 21:50:11 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

at Arma2NETMySQLPlugin.MySQL.OpenConnection(String connectionString)

at Arma2NETMySQLPlugin.DatabaseObject..ctor(String[] values)

at Arma2NETMySQLPlugin.Databases..ctor()

at Arma2NETMySQLPlugin.Startup.StartupConnection()

at Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Inv oke(String args, Int32 maxResultSize)

at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(Ad dInArguments args)

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeIn ternal(Object obj, Object[] parameters, Object[] arguments)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at Arma2Net.Managed.AddInManager.DomainDoCallback()

at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)

at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDo main domain, Delegate func, Object arg)

at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)

at Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(Strin g function, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize)

11/14/2013 21:50:11 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid=76561198040330551']

11/14/2013 21:50:11 maxResultSize: 10239

11/14/2013 22:28:59 Arma2NET 2.3.0.0 running on CLR 4.0.30319.18010

11/14/2013 22:28:59 Loaded into process arma3server

11/14/2013 22:28:59 Loading add-ins

11/14/2013 22:29:01 Caught exception of type System.Reflection.TargetInvocationException while loading add-in DefaultDomain

11/14/2013 22:29:01 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.88.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. Attempt to load an unverifiable executable with fixups (IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019) ---> System.IO.FileLoadException: Attempt to load an unverifiable executable with fixups (IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019)

--- End of inner exception stack trace ---

at System.Reflection.RuntimeAssembly.nLoadImage(Byte[] rawAssembly, Byte[] rawSymbolStore, Evidence evidence, StackCrawlMark& stackMark, Boolean fIntrospection, SecurityContextSource securityContextSource)

at System.Reflection.Assembly.Load(Byte[] rawAssembly)

at Arma2Net.Managed.AddInManager.DomainLoadAddIn(Stri ng assemblyFile)

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeIn ternal(Object obj, Object[] parameters, Object[] arguments)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at Arma2Net.Managed.AddInManager.DomainDoCallback()

at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)

at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDo main domain, Delegate func, Object arg)

at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)

at Arma2Net.Managed.AddInManager.LoadAddIn(String assemblyFile)

11/14/2013 22:29:01 Domain Name Version Publisher Description

11/14/2013 22:29:01 DefaultDomain Arma2NETMySQL 0.1.0.0 firefly2442 Runs MySQL procedure commands.

11/14/2013 22:29:01 DefaultDomain Arma2NETMySQLCommand0.1.0.0 firefly2442 Runs raw MySQL/SQLite commands

11/14/2013 22:29:01 DefaultDomain Arma2NETMySQLCommandAsync0.1.0.0 firefly2442 Runs asynchronous raw MySQL/SQLite commands

11/14/2013 22:29:01 DefaultDomain ClrVersion 2.0.0.0 Scott_NZ Retrieves the version of the Common Language Runtime.

11/14/2013 22:29:01 DefaultDomain CompareVersion 2.0.0.0 Scott_NZ Compares two version strings and returns an integer indicating how they compare.

11/14/2013 22:29:01 DefaultDomain Version 2.0.0.0 Scott_NZ Returns the version of Arma2NET.

11/14/2013 22:29:01 DefaultDomain GetClipboardText 1.0.0.0 Scott_NZ Gets the clipboard text value.

11/14/2013 22:29:01 DefaultDomain SetClipboardText 1.0.0.0 Scott_NZ Sets the clipboard to a text value.

11/14/2013 22:29:01 DefaultDomain CommandLine 2.0.0.0 Scott_NZ Returns the command line used to start the application.

11/14/2013 22:29:01 DefaultDomain DateTime 2.0.0.0 Scott_NZ Returns the current date and time.

11/14/2013 22:29:01 Arma2NET initialized in 00:00:01.5955515

11/14/2013 22:29:01 Caught exception of type System.Reflection.TargetInvocationException

11/14/2013 22:29:01 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

at Arma2NETMySQLPlugin.MySQL.OpenConnection(String connectionString)

at Arma2NETMySQLPlugin.DatabaseObject..ctor(String[] values)

at Arma2NETMySQLPlugin.Databases..ctor()

at Arma2NETMySQLPlugin.Startup.StartupConnection()

at Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Inv oke(String args, Int32 maxResultSize)

at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(Ad dInArguments args)

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeIn ternal(Object obj, Object[] parameters, Object[] arguments)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at Arma2Net.Managed.AddInManager.DomainDoCallback()

at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)

at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDo main domain, Delegate func, Object arg)

at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)

at Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(Strin g function, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize)

11/14/2013 22:29:01 function: Arma2NETMySQLCommand ['arma3life', 'CALL resetLifeVehicles();']

11/14/2013 22:29:01 maxResultSize: 10239

11/14/2013 22:29:08 Caught exception of type System.Reflection.TargetInvocationException

11/14/2013 22:29:08 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

at Arma2NETMySQLPlugin.MySQL.OpenConnection(String connectionString)

at Arma2NETMySQLPlugin.DatabaseObject..ctor(String[] values)

at Arma2NETMySQLPlugin.Databases..ctor()

at Arma2NETMySQLPlugin.Startup.StartupConnection()

at Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Inv oke(String args, Int32 maxResultSize)

at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(Ad dInArguments args)

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeIn ternal(Object obj, Object[] parameters, Object[] arguments)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at Arma2Net.Managed.AddInManager.DomainDoCallback()

at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)

at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDo main domain, Delegate func, Object arg)

at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)

at Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(Strin g function, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize)

11/14/2013 22:29:08 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid=76561198040330551']

11/14/2013 22:29:08 maxResultSize: 10239

11/14/2013 22:38:02 Caught exception of type System.Reflection.TargetInvocationException

11/14/2013 22:38:02 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

at Arma2NETMySQLPlugin.MySQL.OpenConnection(String connectionString)

at Arma2NETMySQLPlugin.DatabaseObject..ctor(String[] values)

at Arma2NETMySQLPlugin.Databases..ctor()

at Arma2NETMySQLPlugin.Startup.StartupConnection()

at Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Inv oke(String args, Int32 maxResultSize)

at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(Ad dInArguments args)

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeIn ternal(Object obj, Object[] parameters, Object[] arguments)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at Arma2Net.Managed.AddInManager.DomainDoCallback()

at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)

at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDo main domain, Delegate func, Object arg)

at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)

at Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(Strin g function, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize)

11/14/2013 22:38:02 function: Arma2NETMySQLCommand ['arma3life', 'CALL resetLifeVehicles();']

11/14/2013 22:38:02 maxResultSize: 10239

11/14/2013 22:38:11 Caught exception of type System.Reflection.TargetInvocationException

11/14/2013 22:38:11 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

at Arma2NETMySQLPlugin.MySQL.OpenConnection(String connectionString)

at Arma2NETMySQLPlugin.DatabaseObject..ctor(String[] values)

at Arma2NETMySQLPlugin.Databases..ctor()

at Arma2NETMySQLPlugin.Startup.StartupConnection()

at Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Inv oke(String args, Int32 maxResultSize)

at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(Ad dInArguments args)

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeIn ternal(Object obj, Object[] parameters, Object[] arguments)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at Arma2Net.Managed.AddInManager.DomainDoCallback()

at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)

at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDo main domain, Delegate func, Object arg)

at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)

at Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(Strin g function, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize)

11/14/2013 22:38:11 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid=76561198040330551']

11/14/2013 22:38:11 maxResultSize: 10239

11/14/2013 22:43:29 Caught exception of type System.Reflection.TargetInvocationException

11/14/2013 22:43:29 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

at Arma2NETMySQLPlugin.MySQL.OpenConnection(String connectionString)

at Arma2NETMySQLPlugin.DatabaseObject..ctor(String[] values)

at Arma2NETMySQLPlugin.Databases..ctor()

at Arma2NETMySQLPlugin.Startup.StartupConnection()

at Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Inv oke(String args, Int32 maxResultSize)

at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(Ad dInArguments args)

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeIn ternal(Object obj, Object[] parameters, Object[] arguments)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at Arma2Net.Managed.AddInManager.DomainDoCallback()

at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)

at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDo main domain, Delegate func, Object arg)

at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)

at Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(Strin g function, Int32 maxResultSize)

at Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize)

11/14/2013 22:43:29 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, coplevel, cop_licenses, cop_gear, adminlevel, blacklist FROM players WHERE playerid=76561198040330551']

11/14/2013 22:43:29 maxResultSize: 10239

What i did wrong? How to fix it?

[firefly2442 6]

Please be aware that this plugin will only work for MySQL and SQLite databases. As far as I'm aware, it will NOT work for an Oracle Database: https://en.wikipedia.org/wiki/Oracle_Database

Oracle did buy MySQL though so make sure you're running a MySQL database: http://www.oracle.com/us/products/mysql/overview/index.html

System.IO.FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.88.0

As it mentions, you need to install the SQLite dependency (see the readme for the link). Hope this helps.

[silentkiller* 11]

Here the database is called "MySQL 5.5", can i suppose it's right to think it's MySQL?

[SCE_The Fuzz 10]

I'm trying to set it up with the Altis Life server mission file and I keep hitting the same error. Arma2Net.Managed.FunctionNotFoundException

I'm running a Mysql server on the same box as the server is hosted. My only guess is to take out the sqlite stuff?

I used the auto installer for the Arma2Net files, I used your pre made plugin files for the rest.

My folders look like this:

C:\Games\arma3\a3master\@Arma2NET\AddIns\Arma2NETMySQLPlugin\ (the 3 dll files given)
C:\Games\arma3\a3master\@Arma2NET\Arma2Net.Managed.dll
C:\Games\arma3\a3master\@Arma2NET\Arma2Net.Unmanaged.dll
C:\Games\arma3\a3master\@Arma2NET\Arma2Net.AddInProxy.dll
C:\Games\arma3\a3master\@Arma2NET\Arma2Net.Unmanaged.Mono.dll (not used)
C:\Games\arma3\a3master\@Arma2NET\MonoPaths.txt (not used)

C:\Games\arma3\a3master\logs
C:\Games\arma3\a3master\mysql
C:\Games\arma3\a3master\sqlite
C:\Games\arma3\a3master\Databases.txt

Below I will post my logs maybe you can see what I'm doing wrong / missing?

Arma RPT log

=====================================================================
== C:\Games\arma3\a3master\arma3server.exe
== "C:\Games\arma3\a3master\arma3server.exe"  -port=2302 "-config=C:\Games\arma3\a3master\TADST\ServerAdmin\TADST_config.cfg" "-cfg=C:\Games\arma3\a3master\TADST\ServerAdmin\TADST_basic.cfg" "-profiles=C:\Games\arma3\a3master\TADST\ServerAdmin" -name=ServerAdmin -netlog -pid=pid.log "-mod=@Arma2NET;@life_server" -cpuCount=6 -exThreads=7

Exe timestamp: 2013/11/01 15:12:49
Current time:  2013/11/15 11:05:24

Type: Public
Branch: Stable
Version: 1.04.111745

Allocator: C:\Games\arma3\a3master\dll\tbb4malloc_bi.dll
=====================================================================
...
11:06:49 c:\w\c_branch\poseidon\futura_stable\lib\network\networkserver.cpp NetworkServer::OnClientStateChanged:NOT IMPLEMENTED - briefing!
11:06:49 "Server Time: Jip Var set and synced"
11:06:57 String STR_EVAL_UNHANDLED_EXCEPTION not found
11:06:57 Error in expression <throw "System.Reflection.TargetInvocatio>
11:06:57   Error position: <throw "System.Reflection.TargetInvocatio>
11:06:57   Error 
11:06:57 Error in expression <throw "System.Reflection.TargetInvocatio>
11:06:57   Error position: <throw "System.Reflection.TargetInvocatio>
11:06:57   Error 

Arma2NET:

11/15/2013 11:06:49 Arma2NET 2.3.0.0 running on CLR 4.0.30319.1008
11/15/2013 11:06:49 Loaded into process arma3server
11/15/2013 11:06:49 Loading add-ins
11/15/2013 11:06:49 Caught exception of type System.Reflection.TargetInvocationException while loading add-in DefaultDomain
11/15/2013 11:06:49 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.88.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. Attempt to load an unverifiable executable with fixups (IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019) ---> System.IO.FileLoadException: Attempt to load an unverifiable executable with fixups (IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019)
  --- End of inner exception stack trace ---
  at System.Reflection.RuntimeAssembly.nLoadImage(Byte[] rawAssembly, Byte[] rawSymbolStore, Evidence evidence, StackCrawlMark& stackMark, Boolean fIntrospection, SecurityContextSource securityContextSource)
  at System.Reflection.Assembly.Load(Byte[] rawAssembly)
  at Arma2Net.Managed.AddInManager.DomainLoadAddIn(String assemblyFile)
  --- End of inner exception stack trace ---
  at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
  at System.Delegate.DynamicInvokeImpl(Object[] args)
  at Arma2Net.Managed.AddInManager.DomainDoCallback()
  at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
  at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDomain domain, Delegate func, Object arg)
  at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)
  at Arma2Net.Managed.AddInManager.LoadAddIn(String assemblyFile)
11/15/2013 11:06:49 Domain                        Name                Version   Publisher           Description
11/15/2013 11:06:49 DefaultDomain                 Arma2NETMySQL       0.1.0.0   firefly2442         Runs MySQL procedure commands.
11/15/2013 11:06:49 DefaultDomain                 Arma2NETMySQLCommand0.1.0.0   firefly2442         Runs raw MySQL/SQLite commands
11/15/2013 11:06:49 DefaultDomain                 Arma2NETMySQLCommandAsync0.1.0.0   firefly2442         Runs asynchronous raw MySQL/SQLite commands
11/15/2013 11:06:49 DefaultDomain                 ClrVersion          2.0.0.0   Scott_NZ            Retrieves the version of the Common Language Runtime.
11/15/2013 11:06:49 DefaultDomain                 CompareVersion      2.0.0.0   Scott_NZ            Compares two version strings and returns an integer indicating how they compare.
11/15/2013 11:06:49 DefaultDomain                 Version             2.0.0.0   Scott_NZ            Returns the version of Arma2NET.
11/15/2013 11:06:49 DefaultDomain                 GetClipboardText    1.0.0.0   Scott_NZ            Gets the clipboard text value.
11/15/2013 11:06:49 DefaultDomain                 SetClipboardText    1.0.0.0   Scott_NZ            Sets the clipboard to a text value.
11/15/2013 11:06:49 DefaultDomain                 CommandLine         2.0.0.0   Scott_NZ            Returns the command line used to start the application.
11/15/2013 11:06:49 DefaultDomain                 DateTime            2.0.0.0   Scott_NZ            Returns the current date and time.
11/15/2013 11:06:49 Arma2NET initialized in 00:00:00.1635737
11/15/2013 11:06:49 Caught exception of type System.Reflection.TargetInvocationException
11/15/2013 11:06:49 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.
  at Arma2NETMySQLPlugin.MySQL.OpenConnection(String connectionString)
  at Arma2NETMySQLPlugin.DatabaseObject..ctor(String[] values)
  at Arma2NETMySQLPlugin.Databases..ctor()
  at Arma2NETMySQLPlugin.Startup.StartupConnection()
  at Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Invoke(String args, Int32 maxResultSize)
  at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(AddInArguments args)
  --- End of inner exception stack trace ---
  at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
  at System.Delegate.DynamicInvokeImpl(Object[] args)
  at Arma2Net.Managed.AddInManager.DomainDoCallback()
  at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
  at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDomain domain, Delegate func, Object arg)
  at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)
  at Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize)
  at Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(String function, Int32 maxResultSize)
  at Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize)
11/15/2013 11:06:49 function: Arma2NETMySQLCommand ['arma3life', 'CALL resetLifeVehicles();']
11/15/2013 11:06:49 maxResultSize: 10239
11/15/2013 11:06:57 Caught exception of type System.Reflection.TargetInvocationException
11/15/2013 11:06:57 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.
  at Arma2NETMySQLPlugin.MySQL.OpenConnection(String connectionString)
  at Arma2NETMySQLPlugin.DatabaseObject..ctor(String[] values)
  at Arma2NETMySQLPlugin.Databases..ctor()
  at Arma2NETMySQLPlugin.Startup.StartupConnection()
  at Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Invoke(String args, Int32 maxResultSize)
  at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(AddInArguments args)
  --- End of inner exception stack trace ---
  at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
  at System.Delegate.DynamicInvokeImpl(Object[] args)
  at Arma2Net.Managed.AddInManager.DomainDoCallback()
  at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
  at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDomain domain, Delegate func, Object arg)
  at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)
  at Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize)
  at Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(String function, Int32 maxResultSize)
  at Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize)
11/15/2013 11:06:57 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid='76561197992362385'']
11/15/2013 11:06:57 maxResultSize: 10239

The 4 Files from the mysql plugin.

Info: 11:06:49 - Logging started in directory: C:\Games\arma3\a3master\logs\
Info: 11:06:49 - Arma2NETMySQL Plugin Started.
Info: 11:06:49 - Version number: 0.1.0.0
Info: 11:06:49 - Loading databases...
Info: 11:06:49 - Databases.txt file loading in from: C:\Games\arma3\a3master\Databases.txt
Info: 11:06:49 - Type: mysql Database: arma3life IPAddress: 127.0.0.1 Port: 3306 Username: root Password: NotShownForSecurityReasons
Info: 11:06:57 - Logging started in directory: C:\Games\arma3\a3master\logs\
Info: 11:06:57 - Arma2NETMySQL Plugin Started.
Info: 11:06:57 - Version number: 0.1.0.0
Info: 11:06:57 - Loading databases...
Info: 11:06:57 - Databases.txt file loading in from: C:\Games\arma3\a3master\Databases.txt
Info: 11:06:57 - Type: mysql Database: arma3life IPAddress: 127.0.0.1 Port: 3306 Username: root Password: NotShownForSecurityReasons

[2013-11-15 11:05:29] Log session started

[2013-11-15 11:05:29] [0,0] SetSteamID( [A:1:0:0] )
[2013-11-15 11:05:29] [1,2] Connect() starting connection (eNetQOSLevelLow, 103.28.54.10:27017, UDP)

[2013-11-15 11:05:29] [1,2] ConnectionCompleted() (72.165.61.175:27017, UDP)
[2013-11-15 11:05:29] [1,2] RecvMsgClientLogOnResponse() : [A:1:609542145:3773] 'OK'
[2013-11-15 11:07:53] [3,2] LogOff()
[2013-11-15 11:07:53] [2,2] AsyncDisconnect()

[2013-11-15 11:05:28] Loaded 0 apps from 1 install folders.

[2013-11-15 11:07:53] Log session started

[2013-11-15 11:07:53] [2,0] Log session ended

[firefly2442 6]

@SilentKiller: Yes, that should be correct.

@SCE_TheFuzz: Try copying the SQLite and MySQL DLL files from here: @Arma2NET\AddIns\Arma2NETMySQLPlugin\ to here: @Arma2NET\ If this works, I'll fix the zip. Clearly they're not working in that spot since multiple people have been having trouble.

[SCE_The Fuzz 10]

@SilentKiller: Yes, that should be correct.

@SCE_TheFuzz: Try copying the SQLite and MySQL DLL files from here: @Arma2NET\AddIns\Arma2NETMySQLPlugin\ to here: @Arma2NET\ If this works, I'll fix the zip. Clearly they're not working in that spot since multiple people have been having trouble.

This did not work sad to say. Its a repeat of the same errors as before.

[ballou 10]

ok i'm having some issues with this let me explain what i have done, maybe you can point me in the direction

in my a3 server i have installed @arma2net

have made a sqlite folder

already have a logs folder

have downloaded the map and installed it @life_server

Have setup my mysql database and imported the arma3life.sql and its populated the database called arma3life with tables

have edited database.txt file with " mysql,arma3life,127.0.0.1,3306,****,**** and is in the root directory of the game

( mysql database is on the same server as game files )

my command line to start the game is loading the 2 folders@arma2net;@life_server

server i can find, enter and it hangs without entering the lobby

can anyone help me please

*** edit ***

have managed to get this running

Edited November 16, 2013 by ballou

[SCE_The Fuzz 10]

Keep an eye out on my post with firefly sounds like the same issue I'm having. Also check your log files to see what the errors are in both arma2NET and arma2netMysql

[firefly2442 6]

@ballou: Glad you got it working. :)

@SCE_TheFuzz: OK, hmm. Try installing the SQLite and MySQL dependencies. There are installers for each of them (you need both) in the readme file.

[SCE_The Fuzz 10]

Confirmed I installed (http://dev.mysql.com/downloads/connector/net/) & (sqlite-netFx40-setup-bundle-x64-2010-1.0.89.0.exe) As 1.0.88.0 is not offered.