Jump to content
Bohemia Interactive Forums
Sign in to follow this  
Followers 0
firefly2442

Arma2MySQL

By firefly2442, in ARMA 2 & OA : MISSIONS - Editing & Scripting

Recommended Posts

firefly2442    6

firefly2442
Posted

In the installer, I think there are some checkboxes for options to install or not install some things for Visual Studio and/or the Global Assembly Cache. I can't remember what exactly but make sure all the checkboxes are checked. Try that.

Downloaded: http://system.data.sqlite.org/blobs/1.0.89.0/sqlite-netFx40-setup-bundle-x86-2010-1.0.89.0.exe

Installed... Same error in log...

Command will execute in the Arma2NET Explorer.... but it doesnt seem to load when i run it as a mod in Arma 2

Share this post

Link to post
Share on other sites

blckeagls    12

blckeagls
Posted

Ok no error on the Arma2NET Explorer... But it still didn't run inside the server.... No logs created when ran as a mod....

From Add/Remove programs I:

Uninstalled all .NET packages..

Uninstalled all visual c++ packages...

Uninstalled SqlLite...

Then I:

Installed http://download.microsoft.com/download/1/B/E/1BE39E79-7E39-46A3-96FF-047F95396215/dotNetFx40_Full_setup.exe

Installed http://system.data.sqlite.org/blobs/1.0.89.0/sqlite-netFx40-setup-bundle-x86-2010-1.0.89.0.exe (clicked the check boxes install assemblies into global cache & designer components)

Installed http://download.microsoft.com/download/1/1/1/1116b75a-9ec3-481a-a3c8-1777b5381140/vcredist_x86.exe (c++ redist 2008)

Then I checked Add/Remove programs and here is what is installed:

Microsoft .NET Framework 4 Client Profile

Microsoft .NET Framework 4 Extended

Microsoft .NET Framework 4.5 Multi-Targeting Pack

Microsoft .NET Framework 4.5 SDK

Microsoft .NET Framework Multi-Targeting Pack

Microsoft .NET Framework Multi-Targeting Pack (ENU)

Microsoft .NET Framework SDK

Microsoft Visual C++ 2008 Redistributable - x85 9.0.21022

Microsoft Visual C++ 2010 x86 Redistributable - 10.0.40219

System.Data.SQLite v1.0.89.0

---------- Post added at 20:38 ---------- Previous post was at 20:37 ----------

Here is log from Arma2NET Explorer
01/30/2014 14:31:40 Arma2NET 2.3.0.0 running on CLR 4.0.30319.1
01/30/2014 14:31:40 Loaded into process Arma2NetExplorer
01/30/2014 14:31:41 Loading add-ins
01/30/2014 14:31:41 Domain                        Name                Version   Publisher           Description
01/30/2014 14:31:41 Arma2NetExplorer.exe          Arma2NETMySQL       0.1.0.0   firefly2442         Runs MySQL procedure commands.
01/30/2014 14:31:41 Arma2NetExplorer.exe          Arma2NETMySQLCommand0.1.0.0   firefly2442         Runs raw MySQL/SQLite commands
01/30/2014 14:31:41 Arma2NetExplorer.exe          Arma2NETMySQLCommandAsync0.1.0.0   firefly2442         Runs asynchronous raw MySQL/SQLite commands
01/30/2014 14:31:41 Arma2NetExplorer.exe          ClrVersion          2.0.0.0   Scott_NZ            Retrieves the version of the Common Language Runtime.
01/30/2014 14:31:41 Arma2NetExplorer.exe          CompareVersion      2.0.0.0   Scott_NZ            Compares two version strings and returns an integer indicating how they compare.
01/30/2014 14:31:41 Arma2NetExplorer.exe          Version             2.0.0.0   Scott_NZ            Returns the version of Arma2NET.
01/30/2014 14:31:41 Arma2NetExplorer.exe          GetClipboardText    1.0.0.0   Scott_NZ            Gets the clipboard text value.
01/30/2014 14:31:41 Arma2NetExplorer.exe          SetClipboardText    1.0.0.0   Scott_NZ            Sets the clipboard to a text value.
01/30/2014 14:31:41 Arma2NetExplorer.exe          CommandLine         2.0.0.0   Scott_NZ            Returns the command line used to start the application.
01/30/2014 14:31:41 Arma2NetExplorer.exe          DateTime            2.0.0.0   Scott_NZ            Returns the current date and time.
01/30/2014 14:31:41 Arma2NET initialized in 00:00:00.0973451
01/30/2014 14:31:41 function: ClrVersion
01/30/2014 14:31:41 maxResultSize: 4095
01/30/2014 14:31:41 Result size: 13
01/30/2014 14:31:41 Result: "4.0.30319.1"

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

Hmm, that all looks correct to me. So, until you run a mission where it connects to the database, there will be no log files for either one. Have you tried the example mission?

Ok no error on the Arma2NET Explorer... But it still didn't run inside the server.... No logs created when ran as a mod....

From Add/Remove programs I:

Uninstalled all .NET packages..

Uninstalled all visual c++ packages...

Uninstalled SqlLite...

Then I:

Installed http://download.microsoft.com/download/1/B/E/1BE39E79-7E39-46A3-96FF-047F95396215/dotNetFx40_Full_setup.exe

Installed http://system.data.sqlite.org/blobs/1.0.89.0/sqlite-netFx40-setup-bundle-x86-2010-1.0.89.0.exe (clicked the check boxes install assemblies into global cache & designer components)

Installed http://download.microsoft.com/download/1/1/1/1116b75a-9ec3-481a-a3c8-1777b5381140/vcredist_x86.exe (c++ redist 2008)

Then I checked Add/Remove programs and here is what is installed:

Microsoft .NET Framework 4 Client Profile

Microsoft .NET Framework 4 Extended

Microsoft .NET Framework 4.5 Multi-Targeting Pack

Microsoft .NET Framework 4.5 SDK

Microsoft .NET Framework Multi-Targeting Pack

Microsoft .NET Framework Multi-Targeting Pack (ENU)

Microsoft .NET Framework SDK

Microsoft Visual C++ 2008 Redistributable - x85 9.0.21022

Microsoft Visual C++ 2010 x86 Redistributable - 10.0.40219

System.Data.SQLite v1.0.89.0

---------- Post added at 20:38 ---------- Previous post was at 20:37 ----------

Here is log from Arma2NET Explorer
01/30/2014 14:31:40 Arma2NET 2.3.0.0 running on CLR 4.0.30319.1
01/30/2014 14:31:40 Loaded into process Arma2NetExplorer
01/30/2014 14:31:41 Loading add-ins
01/30/2014 14:31:41 Domain                        Name                Version   Publisher           Description
01/30/2014 14:31:41 Arma2NetExplorer.exe          Arma2NETMySQL       0.1.0.0   firefly2442         Runs MySQL procedure commands.
01/30/2014 14:31:41 Arma2NetExplorer.exe          Arma2NETMySQLCommand0.1.0.0   firefly2442         Runs raw MySQL/SQLite commands
01/30/2014 14:31:41 Arma2NetExplorer.exe          Arma2NETMySQLCommandAsync0.1.0.0   firefly2442         Runs asynchronous raw MySQL/SQLite commands
01/30/2014 14:31:41 Arma2NetExplorer.exe          ClrVersion          2.0.0.0   Scott_NZ            Retrieves the version of the Common Language Runtime.
01/30/2014 14:31:41 Arma2NetExplorer.exe          CompareVersion      2.0.0.0   Scott_NZ            Compares two version strings and returns an integer indicating how they compare.
01/30/2014 14:31:41 Arma2NetExplorer.exe          Version             2.0.0.0   Scott_NZ            Returns the version of Arma2NET.
01/30/2014 14:31:41 Arma2NetExplorer.exe          GetClipboardText    1.0.0.0   Scott_NZ            Gets the clipboard text value.
01/30/2014 14:31:41 Arma2NetExplorer.exe          SetClipboardText    1.0.0.0   Scott_NZ            Sets the clipboard to a text value.
01/30/2014 14:31:41 Arma2NetExplorer.exe          CommandLine         2.0.0.0   Scott_NZ            Returns the command line used to start the application.
01/30/2014 14:31:41 Arma2NetExplorer.exe          DateTime            2.0.0.0   Scott_NZ            Returns the current date and time.
01/30/2014 14:31:41 Arma2NET initialized in 00:00:00.0973451
01/30/2014 14:31:41 function: ClrVersion
01/30/2014 14:31:41 maxResultSize: 4095
01/30/2014 14:31:41 Result size: 13
01/30/2014 14:31:41 Result: "4.0.30319.1"

Share this post

Link to post
Share on other sites

blckeagls    12

blckeagls
Posted

So here is my sqf that runs:

hint ("HELLO");

sleep 1;

hint ("Arma2Net.Unmanaged" callExtension "ClrVersion");

_insertTest = "Arma2Net.Unmanaged" callExtension "Arma2NETMySQLCommand ['dayz_epoch', 'insert into donor_bank values (555,444444)']";

It performs the hint ("HELLO"); then does nothing. At a minimum... if Arma2NET was working I should get a hint of the version.....

File mpmissions\__CUR_MP.Chernarus\mission.sqm, line 1338: '/Mission/Sensors/Item0.expActiv': Missing ';' at the end of line

File mpmissions\__CUR_MP.Chernarus\mission.sqm, line 1339: '/Mission/Sensors/Item0.expDesactiv': Missing ';' at the end of line

File mpmissions\__CUR_MP.Chernarus\mission.sqm, line 1355: '/Mission/Sensors/Item1.expActiv': Missing ';' at the end of line

File mpmissions\__CUR_MP.Chernarus\mission.sqm, line 1356: '/Mission/Sensors/Item1.expDesactiv': Missing ';' at the end of line

File mpmissions\__CUR_MP.Chernarus\mission.sqm, line 1372: '/Mission/Sensors/Item2.expActiv': Missing ';' at the end of line

File mpmissions\__CUR_MP.Chernarus\mission.sqm, line 1373: '/Mission/Sensors/Item2.expDesactiv': Missing ';' at the end of line

File mpmissions\__CUR_MP.Chernarus\mission.sqm, line 1423: '/Mission/Sensors/Item5.expActiv': Missing ';' at the end of line

File mpmissions\__CUR_MP.Chernarus\mission.sqm, line 1424: '/Mission/Sensors/Item5.expDesactiv': Missing ';' at the end of line

"DayZ Epoch: PRELOAD Functions\init [[L 1-1-A:1 REMOTE],any]"

"DayZ Epoch: MPframework inited"

Warning: no type entry inside class RscDisplayClientGetReady/controls/B_Cancel

Warning: no type entry inside class RscDisplayClientGetReady/controls/B_Continue

"DEBUG: loadscreen guard started."

"DEBUG: loadscreen guard started."

"Res3tting B!S effects..."

"\z\addons\dayz_code\system\REsec.sqf:Monitoring Remote Exe..."

"Running "kh_actions"."

"[AGN] Starting Trader City Safezone Commander!"

"AC_functions version 1.02"

"DAYZ: CLIENT IS RUNNING DAYZ_CODE "1.0.4""

"PLAYER RESULT: true"

Share this post

Link to post
Share on other sites

blckeagls    12

blckeagls
Posted

Any other ideas on why it doesn't run in the mod? am i calling it wrong? Is it not compatible with Dayz_Epoch?

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

I think the comma may be messing it up. Try something simple first.

_selectTest = "Arma2Net.Unmanaged" callExtension "Arma2NETMySQLCommand ['dayz_epoch', 'SELECT * FROM TABLENAME LIMIT 3']";

Any other ideas on why it doesn't run in the mod? am i calling it wrong? Is it not compatible with Dayz_Epoch?

Share this post

Link to post
Share on other sites

drredfox    11

drredfox
Posted

Hi,

I saw this plugin and I had an idea, I just don't know if it's possible (I have no knowledge of programming).

I'm trying to create a database to store the status of some ammoboxes (the ammo count), between missions. Something like a lite MSO.

Let me explain with an hypothetical: I'm playing one mission (call it "mission_one.pbo") and all the players must rearm in one ammobox. The ammocount get's stored on the database.

The second mission ("mission_two.pbo") has an ammobox that loads the ammocount from the database, modified in the last mission, so it has the remaining magazines.

The process it's like: database: new box ---> ammobox: loaded ---> database: gets the ammocount on missions end ----> box: new mission, loaded ammocount...

The idea is to create a campaign where you need to be cautious with the resources.

Just to clarify: I'm not asking someone to do the job for me. Just wondering if it's possible to do this with the plugin.

Thanks in advance.

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

Yes, I think that's possible. In mission one, I would have it reset the database and all the ammo. Then at the resolution/end of the mission, you could save the contents of the ammobox. Then load it and repeat in mission two. This way you don't have to manually make changes to the database, you just play the missions in the appropriate order.

Hi,

I saw this plugin and I had an idea, I just don't know if it's possible (I have no knowledge of programming).

I'm trying to create a database to store the status of some ammoboxes (the ammo count), between missions. Something like a lite MSO.

Let me explain with an hypothetical: I'm playing one mission (call it "mission_one.pbo") and all the players must rearm in one ammobox. The ammocount get's stored on the database.

The second mission ("mission_two.pbo") has an ammobox that loads the ammocount from the database, modified in the last mission, so it has the remaining magazines.

The process it's like: database: new box ---> ammobox: loaded ---> database: gets the ammocount on missions end ----> box: new mission, loaded ammocount...

The idea is to create a campaign where you need to be cautious with the resources.

Just to clarify: I'm not asking someone to do the job for me. Just wondering if it's possible to do this with the plugin.

Thanks in advance.

Share this post

Link to post
Share on other sites

war_lord    934

war_lord
Posted

I can't get MSO with MySQL working because the existing tutorial is either way too vague, or just plain out of date.

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

Yeah, I don't believe MSO is under active development any more. Sorry. You could try the example mission I made that stores weapon/kit loadouts and integrate that into your missions.

I can't get MSO with MySQL working because the existing tutorial is either way too vague, or just plain out of date.

Share this post

Link to post
Share on other sites

xliamz    10

xliamz
Posted (edited)

I must be doing something wrong... I don't know if it's this that I've set up wrong or Altis Life however the players join and just got a black screen saying "Contacting server for player information" what could be the problem?

I have the folders in my servers directory...

@Arma2Net = In Main Area

Arma2NETMySQLPlugin = In Main Area - http://gyazo.com/bcb7edc2ebde668caf0a0d657353f9e2 = In the folder.

I can't think of a reason. Thanks for reading sorry if it's a little brief.

Edited by xLiaMz

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

Can you post log files for Arma2NET and Arma2NETMySQL.

I must be doing something wrong... I don't know if it's this that I've set up wrong or Altis Life however the players join and just got a black screen saying "Contacting server for player information" what could be the problem?

I have the folders in my servers directory...

@Arma2Net = In Main Area

Arma2NETMySQLPlugin = In Main Area - http://gyazo.com/bcb7edc2ebde668caf0a0d657353f9e2 = In the folder.

I can't think of a reason. Thanks for reading sorry if it's a little brief.

Share this post

Link to post
Share on other sites

xliamz    10

xliamz
Posted
Can you post log files for Arma2NET and Arma2NETMySQL.

Thanks for the reply, I cannot find any logs? I've looked in Arma2NETMySQL and there's nothing in the logs folder, and I have no idea where to look for Arma2NET

this is where the two folders are on my gameservers ftp - http://gyazo.com/f811dbfeee535f27b75f84d0ef2014ee

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

Log files are in the appdata folder. See here for details:

http://arma2netmysqlplugin.readthedocs.org/en/latest/#troubleshooting

Thanks for the reply, I cannot find any logs? I've looked in Arma2NETMySQL and there's nothing in the logs folder, and I have no idea where to look for Arma2NET

this is where the two folders are on my gameservers ftp - http://gyazo.com/f811dbfeee535f27b75f84d0ef2014ee

Share this post

Link to post
Share on other sites

xliamz    10

xliamz
Posted (edited)

Thanks for the reply.

UPDATE - You helped me through steam so everything is sorted.

UPDATE 2 - How do you set peoples ranks from the mysql database, for e.g. on Altis Life there's Police etc... Idk if I should be asking this here but It's worth a try I guess :)

Edited by xLiaMz

Share this post

Link to post
Share on other sites

speedshooter    1

speedshooter
Posted

I need some help, I have tried recompiling and using the original ones but nothing seems to work. When it tries to I guess contact the database my RPT gets spammed with this:

12:01:18 Error in expression <throw "System.Reflection.TargetInvocatio>
12:01:18   Error position: <throw "System.Reflection.TargetInvocatio>
12:01:18   Error 
12:01:18 Error in expression <throw "System.Reflection.TargetInvocatio>
12:01:18   Error position: <throw "System.Reflection.TargetInvocatio>
12:01:18   Error 
12:01:18 Error in expression <throw "System.Reflection.TargetInvocatio>
12:01:18   Error position: <throw "System.Reflection.TargetInvocatio>
12:01:18   Error 
12:01:18 Error in expression <throw "System.Reflection.TargetInvocatio>
12:01:18   Error position: <throw "System.Reflection.TargetInvocatio>
12:01:18   Error 
12:01:18 Error in expression <throw "System.Reflection.TargetInvocatio>
12:01:18   Error position: <throw "System.Reflection.TargetInvocatio>
12:01:18   Error 
12:01:18 Error in expression <throw "System.Reflection.TargetInvocatio>
12:01:18   Error position: <throw "System.Reflection.TargetInvocatio>
12:01:18   Error 
12:01:18 Error in expression <throw "System.Reflection.TargetInvocatio>
12:01:18   Error position: <throw "System.Reflection.TargetInvocatio>
12:01:18   Error 
12:01:18 Error in expression <throw "System.Reflection.TargetInvocatio>
12:01:18   Error position: <throw "System.Reflection.TargetInvocatio>
12:01:18   Error 
12:01:18 Error in expression <throw "System.Reflection.TargetInvocatio>
12:01:18   Error position: <throw "System.Reflection.TargetInvocatio>
12:01:18   Error 
12:01:18 Error in expression <throw "System.Reflection.TargetInvocatio>
12:01:18   Error position: <throw "System.Reflection.TargetInvocatio>
12:01:18   Error 
12:01:18 Error in expression <throw "System.Reflection.TargetInvocatio>
12:01:18   Error position: <throw "System.Reflection.TargetInvocatio>
12:01:18   Error 
12:01:18 Error in expression <throw "System.Reflection.TargetInvocatio>
12:01:18   Error position: <throw "System.Reflection.TargetInvocatio>
12:01:18   Error 
12:01:18 Error in expression <throw "System.Reflection.TargetInvocatio>
12:01:18   Error position: <throw "System.Reflection.TargetInvocatio>
12:01:18   Error 
12:01:18 Error in expression <throw "System.Reflection.TargetInvocatio>
12:01:18   Error position: <throw "System.Reflection.TargetInvocatio>
12:01:18   Error

And when I open the ArmA2NetExplorer And Load the Addins this appears in the log:

02/08/2014 12:44:53 Arma2NET 2.3.0.0 running on CLR 4.0.30319.1008
02/08/2014 12:44:53 Loaded into process Arma2NetExplorer
02/08/2014 12:44:53 Loading add-ins
02/08/2014 12:44:53 Caught exception of type System.Reflection.TargetInvocationException while loading add-in Arma2NetExplorer.exe
02/08/2014 12:44:53 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.89.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)
02/08/2014 12:44:53 Domain                        Name                Version   Publisher           Description
02/08/2014 12:44:53 Arma2NetExplorer.exe          Arma2NETMySQL       0.1.0.0   firefly2442         Runs MySQL procedure commands.
02/08/2014 12:44:53 Arma2NetExplorer.exe          Arma2NETMySQLCommand0.1.0.0   firefly2442         Runs raw MySQL/SQLite commands
02/08/2014 12:44:53 Arma2NetExplorer.exe          Arma2NETMySQLCommandAsync0.1.0.0   firefly2442         Runs asynchronous raw MySQL/SQLite commands
02/08/2014 12:44:53 Arma2NetExplorer.exe          ClrVersion          2.0.0.0   Scott_NZ            Retrieves the version of the Common Language Runtime.
02/08/2014 12:44:53 Arma2NetExplorer.exe          CompareVersion      2.0.0.0   Scott_NZ            Compares two version strings and returns an integer indicating how they compare.
02/08/2014 12:44:53 Arma2NetExplorer.exe          Version             2.0.0.0   Scott_NZ            Returns the version of Arma2NET.
02/08/2014 12:44:53 Arma2NetExplorer.exe          GetClipboardText    1.0.0.0   Scott_NZ            Gets the clipboard text value.
02/08/2014 12:44:53 Arma2NetExplorer.exe          SetClipboardText    1.0.0.0   Scott_NZ            Sets the clipboard to a text value.
02/08/2014 12:44:53 Arma2NetExplorer.exe          CommandLine         2.0.0.0   Scott_NZ            Returns the command line used to start the application.
02/08/2014 12:44:53 Arma2NetExplorer.exe          DateTime            2.0.0.0   Scott_NZ            Returns the current date and time.
02/08/2014 12:44:53 Arma2NET initialized in 00:00:00.0564219
02/08/2014 12:44:53 function: Load
02/08/2014 12:44:53 maxResultSize: 4095
02/08/2014 12:44:53 Result size: 0
02/08/2014 12:44:53 Result: <null>

Any help would be great :)

---------- Post added at 14:07 ---------- Previous post was at 13:49 ----------

Never Mind, Just found the solution in this thread :| Sorry for the post

---------- Post added at 14:12 ---------- Previous post was at 14:07 ----------

EDIT: Sqlite error fixed but not the rpt

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

Yes, it should. As long as MySQL is setup to allow connections.

Hey Guys,

Will this work on Xampp?

Share this post

Link to post
Share on other sites

Paski    1

Paski
Posted

I've got a few questions.

When using this which method of sending the query is best? My server would be local so it should be fast to send data to and from the two servers.

What is the best way to send an array over to the database from game and vice versa?

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

The asynchronous method is the best because it's not a blocking call. It's more complicated to setup on the SQF side but it's faster and better for servers with large numbers of players. I would recommend using asynchronous. You can look at the Arma3 example mission for details in the implementation.

I've got a few questions.

When using this which method of sending the query is best? My server would be local so it should be fast to send data to and from the two servers.

What is the best way to send an array over to the database from game and vice versa?

Share this post

Link to post
Share on other sites

mastrom    10

mastrom
Posted
I must be doing something wrong... I don't know if it's this that I've set up wrong or Altis Life however the players join and just got a black screen saying "Contacting server for player information" what could be the problem?

I have the folders in my servers directory...

@Arma2Net = In Main Area

Arma2NETMySQLPlugin = In Main Area - http://gyazo.com/bcb7edc2ebde668caf0a0d657353f9e2 = In the folder.

I can't think of a reason. Thanks for reading sorry if it's a little brief.

I have exactly the same problem and I believe that the SQL server isn't communicating with the altis life server. Can anyone direct me in the right direction? Thanks

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

Do you have any log files? That might provide some clues.

I have exactly the same problem and I believe that the SQL server isn't communicating with the altis life server. Can anyone direct me in the right direction? Thanks

Share this post

Link to post
Share on other sites

mastrom    10

mastrom
Posted
Do you have any log files? That might provide some clues.

Arma Net log

02/14/2014 20:34:53 function: Arma2NETMySQLCommand ['arma3life', 'CALL deleteDeadVehicles();']

02/14/2014 20:34:53 maxResultSize: 10239

02/14/2014 20:35:00 Caught exception of type System.Reflection.TargetInvocationException

02/14/2014 20:35:00 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.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(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(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)

02/14/2014 20:35:00 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, coplevel, cop_licenses, cop_gear, adminlevel, blacklist, donatorlvl FROM players WHERE playerid=76561197980555426']

02/14/2014 20:35:00 maxResultSize: 10239

02/14/2014 20:52:43 Arma2NET 2.3.0.0 running on CLR 4.0.30319.18052

02/14/2014 20:52:43 Loaded into process arma3server

02/14/2014 20:52:43 Loading add-ins

02/14/2014 20:52:43 Caught exception of type System.Reflection.TargetInvocationException while loading add-in DefaultDomain

02/14/2014 20:52:43 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.89.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.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(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(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)

02/14/2014 20:52:43 Domain Name Version Publisher Description

02/14/2014 20:52:43 DefaultDomain Arma2NETMySQL 0.1.0.0 firefly2442 Runs MySQL procedure commands.

02/14/2014 20:52:43 DefaultDomain Arma2NETMySQLCommand0.1.0.0 firefly2442 Runs raw MySQL/SQLite commands

02/14/2014 20:52:43 DefaultDomain Arma2NETMySQLCommandAsync0.1.0.0 firefly2442 Runs asynchronous raw MySQL/SQLite commands

02/14/2014 20:52:43 DefaultDomain ClrVersion 2.0.0.0 Scott_NZ Retrieves the version of the Common Language Runtime.

02/14/2014 20:52:43 DefaultDomain CompareVersion 2.0.0.0 Scott_NZ Compares two version strings and returns an integer indicating how they compare.

02/14/2014 20:52:43 DefaultDomain Version 2.0.0.0 Scott_NZ Returns the version of Arma2NET.

02/14/2014 20:52:43 DefaultDomain GetClipboardText 1.0.0.0 Scott_NZ Gets the clipboard text value.

02/14/2014 20:52:43 DefaultDomain SetClipboardText 1.0.0.0 Scott_NZ Sets the clipboard to a text value.

02/14/2014 20:52:43 DefaultDomain CommandLine 2.0.0.0 Scott_NZ Returns the command line used to start the application.

02/14/2014 20:52:43 DefaultDomain DateTime 2.0.0.0 Scott_NZ Returns the current date and time.

02/14/2014 20:52:43 Arma2NET initialized in 00:00:00.0298429

02/14/2014 20:52:43 Caught exception of type System.Reflection.TargetInvocationException

02/14/2014 20:52:43 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.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(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(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)

02/14/2014 20:52:43 function: Arma2NETMySQLCommand ['arma3life', 'CALL resetLifeVehicles();']

02/14/2014 20:52:43 maxResultSize: 10239

02/14/2014 20:52:44 Caught exception of type System.Reflection.TargetInvocationException

02/14/2014 20:52:44 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.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(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(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)

02/14/2014 20:52:44 function: Arma2NETMySQLCommand ['arma3life', 'CALL deleteDeadVehicles();']

02/14/2014 20:52:44 maxResultSize: 10239

02/14/2014 20:52:50 Caught exception of type System.Reflection.TargetInvocationException

02/14/2014 20:52:50 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.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(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(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)

02/14/2014 20:52:50 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, coplevel, cop_licenses, cop_gear, adminlevel, blacklist, donatorlvl FROM players WHERE playerid=76561197980555426']

02/14/2014 20:52:50 maxResultSize: 10239

02/14/2014 20:53:06 Caught exception of type System.Reflection.TargetInvocationException

02/14/2014 20:53:06 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.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(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(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)

02/14/2014 20:53:06 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197980555426']

02/14/2014 20:53:06 maxResultSize: 10239

02/14/2014 20:53:21 Caught exception of type System.Reflection.TargetInvocationException

02/14/2014 20:53:21 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.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(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(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)

02/14/2014 20:53:21 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197980555426']

02/14/2014 20:53:21 maxResultSize: 10239

sql log

Info: 20:52:43 - Logging started in directory: I:\Steam\SteamApps\common\Arma 3\logs\

Info: 20:52:43 - Arma2NETMySQL Plugin Started.

Info: 20:52:43 - Version number: 0.1.0.0

Info: 20:52:43 - Loading databases...

Info: 20:52:43 - Databases.txt file loading in from: I:\Steam\SteamApps\common\Arma 3\Databases.txt

Info: 20:52:43 - Type: mysql Database: arma3life IPAddress: 127.0.0.1 Port: 3306 Username: mastrom Password: NotShownForSecurityReasons

Info: 20:52:44 - Logging started in directory: I:\Steam\SteamApps\common\Arma 3\logs\

Info: 20:52:44 - Arma2NETMySQL Plugin Started.

Info: 20:52:44 - Version number: 0.1.0.0

Info: 20:52:44 - Loading databases...

Info: 20:52:44 - Databases.txt file loading in from: I:\Steam\SteamApps\common\Arma 3\Databases.txt

Info: 20:52:44 - Type: mysql Database: arma3life IPAddress: 127.0.0.1 Port: 3306 Username: mastrom Password: NotShownForSecurityReasons

Info: 20:52:50 - Logging started in directory: I:\Steam\SteamApps\common\Arma 3\logs\

Info: 20:52:50 - Arma2NETMySQL Plugin Started.

Info: 20:52:50 - Version number: 0.1.0.0

Info: 20:52:50 - Loading databases...

Info: 20:52:50 - Databases.txt file loading in from: I:\Steam\SteamApps\common\Arma 3\Databases.txt

Info: 20:52:50 - Type: mysql Database: arma3life IPAddress: 127.0.0.1 Port: 3306 Username: mastrom Password: NotShownForSecurityReasons

Info: 20:53:06 - Logging started in directory: I:\Steam\SteamApps\common\Arma 3\logs\

Info: 20:53:06 - Arma2NETMySQL Plugin Started.

Info: 20:53:06 - Version number: 0.1.0.0

Info: 20:53:06 - Loading databases...

Info: 20:53:06 - Databases.txt file loading in from: I:\Steam\SteamApps\common\Arma 3\Databases.txt

Info: 20:53:06 - Type: mysql Database: arma3life IPAddress: 127.0.0.1 Port: 3306 Username: mastrom Password: NotShownForSecurityReasons

Info: 20:53:21 - Logging started in directory: I:\Steam\SteamApps\common\Arma 3\logs\

Info: 20:53:21 - Arma2NETMySQL Plugin Started.

Info: 20:53:21 - Version number: 0.1.0.0

Info: 20:53:21 - Loading databases...

Info: 20:53:21 - Databases.txt file loading in from: I:\Steam\SteamApps\common\Arma 3\Databases.txt

Info: 20:53:21 - Type: mysql Database: arma3life IPAddress: 127.0.0.1 Port: 3306 Username: mastrom Password: NotShownForSecurityReasons

Share this post

Link to post
Share on other sites

BlackHawk3000    1

BlackHawk3000
Posted

Hello,

I have a problem, I hope you can help me.

Every time I try to launch the mission, it loads then there's a black screen that says "can't setup your session with the server. you have reached the maximum tries of 3. please reconnect".

What can I do ?

Thx

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

You're missing the MySQL dependency. See the readme for details. Make sure to install the appropriate version number.

http://arma2netmysqlplugin.readthedocs.org/en/latest/

Arma Net log

02/14/2014 20:34:53 function: Arma2NETMySQLCommand ['arma3life', 'CALL deleteDeadVehicles();']

02/14/2014 20:34:53 maxResultSize: 10239

02/14/2014 20:35:00 Caught exception of type System.Reflection.TargetInvocationException

02/14/2014 20:35:00 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.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(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(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)

02/14/2014 20:35:00 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, coplevel, cop_licenses, cop_gear, adminlevel, blacklist, donatorlvl FROM players WHERE playerid=76561197980555426']

02/14/2014 20:35:00 maxResultSize: 10239

02/14/2014 20:52:43 Arma2NET 2.3.0.0 running on CLR 4.0.30319.18052

02/14/2014 20:52:43 Loaded into process arma3server

02/14/2014 20:52:43 Loading add-ins

02/14/2014 20:52:43 Caught exception of type System.Reflection.TargetInvocationException while loading add-in DefaultDomain

02/14/2014 20:52:43 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.89.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.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(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(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)

02/14/2014 20:52:43 Domain Name Version Publisher Description

02/14/2014 20:52:43 DefaultDomain Arma2NETMySQL 0.1.0.0 firefly2442 Runs MySQL procedure commands.

02/14/2014 20:52:43 DefaultDomain Arma2NETMySQLCommand0.1.0.0 firefly2442 Runs raw MySQL/SQLite commands

02/14/2014 20:52:43 DefaultDomain Arma2NETMySQLCommandAsync0.1.0.0 firefly2442 Runs asynchronous raw MySQL/SQLite commands

02/14/2014 20:52:43 DefaultDomain ClrVersion 2.0.0.0 Scott_NZ Retrieves the version of the Common Language Runtime.

02/14/2014 20:52:43 DefaultDomain CompareVersion 2.0.0.0 Scott_NZ Compares two version strings and returns an integer indicating how they compare.

02/14/2014 20:52:43 DefaultDomain Version 2.0.0.0 Scott_NZ Returns the version of Arma2NET.

02/14/2014 20:52:43 DefaultDomain GetClipboardText 1.0.0.0 Scott_NZ Gets the clipboard text value.

02/14/2014 20:52:43 DefaultDomain SetClipboardText 1.0.0.0 Scott_NZ Sets the clipboard to a text value.

02/14/2014 20:52:43 DefaultDomain CommandLine 2.0.0.0 Scott_NZ Returns the command line used to start the application.

02/14/2014 20:52:43 DefaultDomain DateTime 2.0.0.0 Scott_NZ Returns the current date and time.

02/14/2014 20:52:43 Arma2NET initialized in 00:00:00.0298429

02/14/2014 20:52:43 Caught exception of type System.Reflection.TargetInvocationException

02/14/2014 20:52:43 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.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(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(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)

02/14/2014 20:52:43 function: Arma2NETMySQLCommand ['arma3life', 'CALL resetLifeVehicles();']

02/14/2014 20:52:43 maxResultSize: 10239

02/14/2014 20:52:44 Caught exception of type System.Reflection.TargetInvocationException

02/14/2014 20:52:44 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.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(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(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)

02/14/2014 20:52:44 function: Arma2NETMySQLCommand ['arma3life', 'CALL deleteDeadVehicles();']

02/14/2014 20:52:44 maxResultSize: 10239

02/14/2014 20:52:50 Caught exception of type System.Reflection.TargetInvocationException

02/14/2014 20:52:50 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.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(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(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)

02/14/2014 20:52:50 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, coplevel, cop_licenses, cop_gear, adminlevel, blacklist, donatorlvl FROM players WHERE playerid=76561197980555426']

02/14/2014 20:52:50 maxResultSize: 10239

02/14/2014 20:53:06 Caught exception of type System.Reflection.TargetInvocationException

02/14/2014 20:53:06 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.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(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(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)

02/14/2014 20:53:06 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197980555426']

02/14/2014 20:53:06 maxResultSize: 10239

02/14/2014 20:53:21 Caught exception of type System.Reflection.TargetInvocationException

02/14/2014 20:53:21 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.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(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(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)

02/14/2014 20:53:21 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197980555426']

02/14/2014 20:53:21 maxResultSize: 10239

sql log

Info: 20:52:43 - Logging started in directory: I:\Steam\SteamApps\common\Arma 3\logs\

Info: 20:52:43 - Arma2NETMySQL Plugin Started.

Info: 20:52:43 - Version number: 0.1.0.0

Info: 20:52:43 - Loading databases...

Info: 20:52:43 - Databases.txt file loading in from: I:\Steam\SteamApps\common\Arma 3\Databases.txt

Info: 20:52:43 - Type: mysql Database: arma3life IPAddress: 127.0.0.1 Port: 3306 Username: mastrom Password: NotShownForSecurityReasons

Info: 20:52:44 - Logging started in directory: I:\Steam\SteamApps\common\Arma 3\logs\

Info: 20:52:44 - Arma2NETMySQL Plugin Started.

Info: 20:52:44 - Version number: 0.1.0.0

Info: 20:52:44 - Loading databases...

Info: 20:52:44 - Databases.txt file loading in from: I:\Steam\SteamApps\common\Arma 3\Databases.txt

Info: 20:52:44 - Type: mysql Database: arma3life IPAddress: 127.0.0.1 Port: 3306 Username: mastrom Password: NotShownForSecurityReasons

Info: 20:52:50 - Logging started in directory: I:\Steam\SteamApps\common\Arma 3\logs\

Info: 20:52:50 - Arma2NETMySQL Plugin Started.

Info: 20:52:50 - Version number: 0.1.0.0

Info: 20:52:50 - Loading databases...

Info: 20:52:50 - Databases.txt file loading in from: I:\Steam\SteamApps\common\Arma 3\Databases.txt

Info: 20:52:50 - Type: mysql Database: arma3life IPAddress: 127.0.0.1 Port: 3306 Username: mastrom Password: NotShownForSecurityReasons

Info: 20:53:06 - Logging started in directory: I:\Steam\SteamApps\common\Arma 3\logs\

Info: 20:53:06 - Arma2NETMySQL Plugin Started.

Info: 20:53:06 - Version number: 0.1.0.0

Info: 20:53:06 - Loading databases...

Info: 20:53:06 - Databases.txt file loading in from: I:\Steam\SteamApps\common\Arma 3\Databases.txt

Info: 20:53:06 - Type: mysql Database: arma3life IPAddress: 127.0.0.1 Port: 3306 Username: mastrom Password: NotShownForSecurityReasons

Info: 20:53:21 - Logging started in directory: I:\Steam\SteamApps\common\Arma 3\logs\

Info: 20:53:21 - Arma2NETMySQL Plugin Started.

Info: 20:53:21 - Version number: 0.1.0.0

Info: 20:53:21 - Loading databases...

Info: 20:53:21 - Databases.txt file loading in from: I:\Steam\SteamApps\common\Arma 3\Databases.txt

Info: 20:53:21 - Type: mysql Database: arma3life IPAddress: 127.0.0.1 Port: 3306 Username: mastrom Password: NotShownForSecurityReasons

---------- Post added at 16:28 ---------- Previous post was at 16:26 ----------

Please post log files.

Hello,

I have a problem, I hope you can help me.

Every time I try to launch the mission, it loads then there's a black screen that says "can't setup your session with the server. you have reached the maximum tries of 3. please reconnect".

What can I do ?

Thx

Share this post

Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
Sign in to follow this  
Followers 0
Go To Topic Listing ARMA 2 & OA : MISSIONS - Editing & Scripting
×