Arma2MySQL

[firefly2442 6]

@dragon: Yes, make sure the SQLite dependency is installed (see the readme). Make sure it's that specific version, otherwise it won't work.

@FreakJoe: Yep, it's case sensitive. Glad you got it working. :)

[setman 12]

Hi guys,

Seems like when people come back into the server it saves what they are wearing, but it does not save things like food,guns,ect

Did i forget something on setup?

Thanks

Edited January 11, 2014 by setman

[firefly2442 6]

@setman: What mission are you using? If it's Altis Life, you may want to ask in that forum thread.

[fouc 10]

Hi !

I'm trying to set-up an Altis Life server and when I start my server and try to connect on it, it crashes and I have this in my RPT file :

Mods: @Arma2NET

Distribution: 0

Version 1.08.113494

Fault time: 2014/01/06 02:21:44

Fault address: 76934B32 01:00013B32 C:\Windows\SYSTEM32\KERNELBASE.dll

file: Altis_Life_RPG

world: Altis

Prev. code bytes: 20 83 64 24 10 00 8D 04 24 50 FF 15 80 83 9B 76

Fault code bytes: 8B 4C 24 54 33 CC E8 07 72 FF FF 8B E5 5D C2 10

Registers:

EAX:00F9A568 EBX:00000005

ECX:00000005 EDX:00000000

ESI:00F9A634 EDI:00000001

CS:EIP:0023:76934B32

SS:ESP:002B:00F9A568 EBP:00F9A5C4

DS:002B ES:002B FS:0053 GS:002B

Flags:00200212

=======================================================

Do you know how to manage this issue ?

Many thanks in advance !

fouc

[firefly2442 6]

@fouc: Hmm, that's odd. Do you have the .NET framework installed? Also, make sure you have the client profile installed as well (link is in the readme).

[fouc 10]

ok, i'll check this. Thanks.

---------- Post added at 13:18 ---------- Previous post was at 12:54 ----------

So :

- I have .NET 4.0

- I have @Arma2NET (.dll in the racine and in the good folder)

- I have logs/sqlite folders and databases.txt in A3 and in user local

- My databases file is :

# This is a comment

# Any line starting with a "#" is considered a comment

# Make sure each of your database connections doesn't have a "#" in front!

# Put each database connection you want on a separate line

# The databasename MUST be unique!

# For an example, see the following

#databasetype,databasename,ipaddress,port,username,password

#

#mysql,arma,127.0.0.1,3306,armausername,secret

#sqlite,weaponslite

mysql,arma3life,37.187.29.85,3307,XXX,XXX

- my lauchner is :

start arma3server.exe -port=2312 -mod=@life_server;@Arma2NET; -name=cfgdayz -config=cfgdayz\server.cfg -cfg=cfgdayz\arma2.cfg -profiles=cfgdayz

And still have the issue...

[firefly2442 6]

@fouc: If you run the Arma2NETExplorer executable and then run a simple SELECT query, does it work?

[Shizles 10]

Hi, I'm trying to run an Arma 3 altis life on a dedicated machine. I am running MySQL server 5.5, and have everything installed that was said in the readme.

everything loads apart from when a player joins the mission and gets past the role select page and load in, a black screen appears and says "can't set up your session with the server, maximum number tries of 3. Please reconnect"

//Shizles

[firefly2442 6]

Hi, I'm trying to run an Arma 3 altis life on a dedicated machine. I am running MySQL server 5.5, and have everything installed that was said in the readme.

everything loads apart from when a player joins the mission and gets past the role select page and load in, a black screen appears and says "can't set up your session with the server, maximum number tries of 3. Please reconnect"

//Shizles

Please post Arma2NET and Arma2NETMySQL log files.

[Shizles 10]

Please post Arma2NET and Arma2NETMySQL log files.

I am not getting any Arma2NETMySQL log files :/, Arama2NetMySQL is in "C:/users/admin/appdata/local/arma2netmysql/logs" and the file is empty

as for the Aram2Net in the same location it gives the error:

01/15/2014 10:53:17 Log: Unmanaged side loaded

01/15/2014 10:53:17 Log: Fatal unhandled exception of type System.IO.FileNotFoundException

Log: System.IO.FileNotFoundException: Could not load file or assembly 'Arma2Net.Managed, Version=2.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e' or one of its dependencies. The system cannot find the file specified.

File name: 'Arma2Net.Managed, Version=2.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e'

at Arma2Net.Unmanaged.InvokeFunctionImpl(SByte* output, Int32 outputSize, SByte* function)

at Arma2Net.Unmanaged.InvokeFunction(SByte* output, Int32 outputSize, SByte* function)

WRN: Assembly binding logging is turned OFF.

To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.

Note: There is some performance penalty associated with assembly bind failure logging.

To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

---------- Post added at 13:06 ---------- Previous post was at 13:04 ----------

Please post Arma2NET and Arma2NETMySQL log files.

I'm not getting an Arma2NetMySQL Log file the folder is in the appdata.

as for the Arma2Net i get this error:

01/15/2014 10:53:17 Log: Unmanaged side loaded

01/15/2014 10:53:17 Log: Fatal unhandled exception of type System.IO.FileNotFoundException

Log: System.IO.FileNotFoundException: Could not load file or assembly 'Arma2Net.Managed, Version=2.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e' or one of its dependencies. The system cannot find the file specified.

File name: 'Arma2Net.Managed, Version=2.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e'

at Arma2Net.Unmanaged.InvokeFunctionImpl(SByte* output, Int32 outputSize, SByte* function)

at Arma2Net.Unmanaged.InvokeFunction(SByte* output, Int32 outputSize, SByte* function)

WRN: Assembly binding logging is turned OFF.

To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.

Note: There is some performance penalty associated with assembly bind failure logging.

To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

[firefly2442 6]

@Shizles: Hmm, ok. Try this. Sometimes the DLL files get blocked on Windows. Right click on the relevant DLL files for Arma2NET and go into the security tab and unblock them. See if that helps.

[Shizles 10]

Seems everything is working apart from the server crashed on load with this error:

Problem signature:

Problem Event Name: CLR20r3

Problem Signature 01: arma3server.exe

Problem Signature 02: 1.8.113.494

Problem Signature 03: 52a81b97

Problem Signature 04: mscorlib

Problem Signature 05: 4.0.30319.34003

Problem Signature 06: 522ebe04

Problem Signature 07: 675

Problem Signature 08: 68

Problem Signature 09: System.OutOfMemoryException

OS Version: 6.3.9600.2.0.0.272.7

Locale ID: 1033

Additional Information 1: 5861

Additional Information 2: 5861822e1919d7c014bbb064c64908b2

Additional Information 3: 01d7

Additional Information 4: 01d7340064827245f2249cd1f1a7c264

Read our privacy statement online:

http://go.microsoft.com/fwlink/?linkid=280262

If the online privacy statement is not available, please read our privacy statement offline:

C:\Windows\system32\en-US\erofflps.txt

Also the arma2net says this:

01/16/2014 19:10:47 Arma2Net.Unmanaged loaded successfully

01/16/2014 19:10:47 Info Successfully loaded into process arma3server

01/16/2014 19:10:47 Info Arma2NET 2.0.0.0 initializing on CLR 4.0.30319.34003

01/16/2014 19:10:47 Info Loading addins

01/16/2014 19:10:47 Info FILENAME NAME VERSION PUBLISHER DESCRIPTION

Thanks for the help, any ideas on this server crash? (im giving the server 16gb of ram in the launch)

//Shizles

[Shizles 10]

That worked thanks!

01/16/2014 19:10:47 Arma2Net.Unmanaged loaded successfully

01/16/2014 19:10:47 Info Successfully loaded into process arma3server

01/16/2014 19:10:47 Info Arma2NET 2.0.0.0 initializing on CLR 4.0.30319.34003

01/16/2014 19:10:47 Info Loading addins

01/16/2014 19:10:47 Info FILENAME NAME VERSION PUBLISHER DESCRIPTION

Also now I have a new problem ;)

When I start the server it just crashed, I'm running 16gb of ram for the server

Problem Event Name: CLR20r3

Problem Signature 01: arma3server.exe

Problem Signature 02: 1.8.113.494

Problem Signature 03: 52a81b97

Problem Signature 04: mscorlib

Problem Signature 05: 4.0.30319.34003

Problem Signature 06: 522ebe04

Problem Signature 07: 675

Problem Signature 08: 68

Problem Signature 09: System.OutOfMemoryException

OS Version: 6.3.9600.2.0.0.272.7

Locale ID: 1033

Additional Information 1: 5861

Additional Information 2: 5861822e1919d7c014bbb064c64908b2

Additional Information 3: 01d7

Additional Information 4: 01d7340064827245f2249cd1f1a7c264

[Shizles 10]

Thanks, Arma2Net is now working and reporting:

01/16/2014 19:54:37 Arma2Net.Unmanaged loaded successfully

01/16/2014 19:54:38 Info Successfully loaded into process arma3server

01/16/2014 19:54:38 Info Arma2NET 2.0.0.0 initializing on CLR 4.0.30319.34003

01/16/2014 19:54:38 Info Loading addins

01/16/2014 19:54:38 Info FILENAME NAME VERSION PUBLISHER DESCRIPTION

But now when I run the server It crashes :/

It says:

Problem signature:

Problem Event Name: CLR20r3

Problem Signature 01: arma3server.exe

Problem Signature 02: 1.8.113.494

Problem Signature 03: 52a81b97

Problem Signature 04: mscorlib

Problem Signature 05: 4.0.30319.34003

Problem Signature 06: 522ebe04

Problem Signature 07: 675

Problem Signature 08: 68

Problem Signature 09: System.OutOfMemoryException

OS Version: 6.3.9600.2.0.0.272.7

Locale ID: 1033

Additional Information 1: 5861

Additional Information 2: 5861822e1919d7c014bbb064c64908b2

Additional Information 3: 01d7

Additional Information 4: 01d7340064827245f2249cd1f1a7c264

Not sure why I'm giving the server 16GB in the launch...

//Shizles

[fouc 10]

@fouc: If you run the Arma2NETExplorer executable and then run a simple SELECT query, does it work?

Si I tried it and here is the result :

> Reload

> AddIns

["Arma2NETMySQL", "Arma2NETMySQLCommand", "Arma2NETMySQLCommandAsync", "ClrVersion", "CompareVersion", "Version", "GetClipboardText", "SetClipboardText", "CommandLine", "DateTime"]

> SELECT * FROM arma3life.vehicles;

throw "Arma2Net.Managed.FunctionNotFoundException"

Maybe I'm not using the good expression in my request... Do you have a working request for me ?

---------- Post added at 10:25 ---------- Previous post was at 10:21 ----------

And here is the log :

01/17/2014 11:18:30 Arma2NET 2.3.0.0 running on CLR 4.0.30319.18408

01/17/2014 11:18:30 Loaded into process Arma2NetExplorer

01/17/2014 11:18:30 Loading add-ins

01/17/2014 11:18:31 Caught exception of type System.Reflection.TargetInvocationException while loading add-in Arma2NetExplorer.exe

01/17/2014 11:18:31 System.Reflection.TargetInvocationException: Une exception a été levée par la cible d'un appel. ---> System.IO.FileLoadException: Impossible de charger le fichier ou l'assembly 'System.Data.SQLite, Version=1.0.89.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' ou une de ses dépendances. Tentative de chargement d'un exécutable non vérifiable avec des corrections (table IAT avec plus de 2***sections ou une section TLS.) (Exception de HRESULT : 0x80131019) ---> System.IO.FileLoadException: Tentative de chargement d'un exécutable non vérifiable avec des corrections (table IAT avec plus de 2***sections ou une section TLS.) (Exception de HRESULT : 0x80131019)

--- Fin de la trace de la pile d'exception interne ---

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

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

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

--- Fin de la trace de la pile d'exception interne ---

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

à System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

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

à Arma2Net.Managed.AddInManager.DomainDoCallback()

à System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)

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

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

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

01/17/2014 11:18:31 Domain Name Version Publisher Description

01/17/2014 11:18:31 Arma2NetExplorer.exe Arma2NETMySQL 0.1.0.0 firefly2442 Runs MySQL procedure commands.

01/17/2014 11:18:31 Arma2NetExplorer.exe Arma2NETMySQLCommand0.1.0.0 firefly2442 Runs raw MySQL/SQLite commands

01/17/2014 11:18:31 Arma2NetExplorer.exe Arma2NETMySQLCommandAsync0.1.0.0 firefly2442 Runs asynchronous raw MySQL/SQLite commands

01/17/2014 11:18:31 Arma2NetExplorer.exe ClrVersion 2.0.0.0 Scott_NZ Retrieves the version of the Common Language Runtime.

01/17/2014 11:18:31 Arma2NetExplorer.exe CompareVersion 2.0.0.0 Scott_NZ Compares two version strings and returns an integer indicating how they compare.

01/17/2014 11:18:31 Arma2NetExplorer.exe Version 2.0.0.0 Scott_NZ Returns the version of Arma2NET.

01/17/2014 11:18:31 Arma2NetExplorer.exe GetClipboardText 1.0.0.0 Scott_NZ Gets the clipboard text value.

01/17/2014 11:18:31 Arma2NetExplorer.exe SetClipboardText 1.0.0.0 Scott_NZ Sets the clipboard to a text value.

01/17/2014 11:18:31 Arma2NetExplorer.exe CommandLine 2.0.0.0 Scott_NZ Returns the command line used to start the application.

01/17/2014 11:18:31 Arma2NetExplorer.exe DateTime 2.0.0.0 Scott_NZ Returns the current date and time.

01/17/2014 11:18:31 Arma2NET initialized in 00:00:00.8627359

01/17/2014 11:18:31 Caught exception of type Arma2Net.Managed.FunctionNotFoundException

01/17/2014 11:18:31 Arma2Net.Managed.FunctionNotFoundException: The specified add-in was not found: SELECT

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

à Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(String function, Int32 maxResultSize)

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

01/17/2014 11:18:31 function: SELECT * FROM arma3life.vehicles;

01/17/2014 11:18:31 maxResultSize: 4095

01/17/2014 11:18:37 function: Load

01/17/2014 11:18:37 maxResultSize: 4095

01/17/2014 11:18:37 Result size: 0

01/17/2014 11:18:37 Result: <null>

01/17/2014 11:18:39 Caught exception of type Arma2Net.Managed.FunctionNotFoundException

01/17/2014 11:18:39 Arma2Net.Managed.FunctionNotFoundException: The specified add-in was not found: SELECT

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

à Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(String function, Int32 maxResultSize)

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

01/17/2014 11:18:39 function: SELECT * FROM arma3life.vehicles;

01/17/2014 11:18:39 maxResultSize: 4095

01/17/2014 11:18:43 Unloading add-ins

01/17/2014 11:18:43 Loading add-ins

01/17/2014 11:18:43 Caught exception of type System.Reflection.TargetInvocationException while loading add-in Arma2NetExplorer.exe

01/17/2014 11:18:43 System.Reflection.TargetInvocationException: Une exception a été levée par la cible d'un appel. ---> System.IO.FileLoadException: Impossible de charger le fichier ou l'assembly 'System.Data.SQLite, Version=1.0.89.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' ou une de ses dépendances. Tentative de chargement d'un exécutable non vérifiable avec des corrections (table IAT avec plus de 2***sections ou une section TLS.) (Exception de HRESULT : 0x80131019) ---> System.IO.FileLoadException: Tentative de chargement d'un exécutable non vérifiable avec des corrections (table IAT avec plus de 2***sections ou une section TLS.) (Exception de HRESULT : 0x80131019)

--- Fin de la trace de la pile d'exception interne ---

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

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

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

--- Fin de la trace de la pile d'exception interne ---

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

à System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

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

à Arma2Net.Managed.AddInManager.DomainDoCallback()

à System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)

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

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

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

01/17/2014 11:18:43 Domain Name Version Publisher Description

01/17/2014 11:18:43 Arma2NetExplorer.exe Arma2NETMySQL 0.1.0.0 firefly2442 Runs MySQL procedure commands.

01/17/2014 11:18:43 Arma2NetExplorer.exe Arma2NETMySQLCommand0.1.0.0 firefly2442 Runs raw MySQL/SQLite commands

01/17/2014 11:18:43 Arma2NetExplorer.exe Arma2NETMySQLCommandAsync0.1.0.0 firefly2442 Runs asynchronous raw MySQL/SQLite commands

01/17/2014 11:18:43 Arma2NetExplorer.exe ClrVersion 2.0.0.0 Scott_NZ Retrieves the version of the Common Language Runtime.

01/17/2014 11:18:43 Arma2NetExplorer.exe CompareVersion 2.0.0.0 Scott_NZ Compares two version strings and returns an integer indicating how they compare.

01/17/2014 11:18:43 Arma2NetExplorer.exe Version 2.0.0.0 Scott_NZ Returns the version of Arma2NET.

01/17/2014 11:18:43 Arma2NetExplorer.exe GetClipboardText 1.0.0.0 Scott_NZ Gets the clipboard text value.

01/17/2014 11:18:43 Arma2NetExplorer.exe SetClipboardText 1.0.0.0 Scott_NZ Sets the clipboard to a text value.

01/17/2014 11:18:43 Arma2NetExplorer.exe CommandLine 2.0.0.0 Scott_NZ Returns the command line used to start the application.

01/17/2014 11:18:43 Arma2NetExplorer.exe DateTime 2.0.0.0 Scott_NZ Returns the current date and time.

01/17/2014 11:18:43 function: Reload

01/17/2014 11:18:43 maxResultSize: 4095

01/17/2014 11:18:43 Result size: 0

01/17/2014 11:18:43 Result: <null>

01/17/2014 11:18:44 function: AddIns

01/17/2014 11:18:44 maxResultSize: 4095

01/17/2014 11:18:44 Result size: 180

01/17/2014 11:18:44 Result: ["Arma2NETMySQL", "Arma2NETMySQLCommand", "Arma2NETMySQLCommandAsync", "ClrVersion", "CompareVersion", "Version", "GetClipboardText", "SetClipboardText", "CommandLine", "DateTime"]

01/17/2014 11:18:56 Caught exception of type Arma2Net.Managed.FunctionNotFoundException

01/17/2014 11:18:56 Arma2Net.Managed.FunctionNotFoundException: The specified add-in was not found: SELECT

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

à Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(String function, Int32 maxResultSize)

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

01/17/2014 11:18:56 function: SELECT * FROM arma3life.vehicles;

01/17/2014 11:18:56 maxResultSize: 4095

01/17/2014 11:22:27 function: Load

01/17/2014 11:22:27 maxResultSize: 4095

01/17/2014 11:22:27 function: Load

01/17/2014 11:22:27 maxResultSize: 4095

01/17/2014 11:22:27 Result size: 0

01/17/2014 11:22:27 Result: <null>

01/17/2014 11:22:27 Result size: 0

01/17/2014 11:22:27 Result: <null>

01/17/2014 11:22:27 Caught exception of type Arma2Net.Managed.FunctionNotFoundException

01/17/2014 11:22:27 Unloading add-ins

01/17/2014 11:22:27 function: AddIns

01/17/2014 11:22:27 maxResultSize: 4095

01/17/2014 11:22:27 Result size: 180

01/17/2014 11:22:27 Result: ["Arma2NETMySQL", "Arma2NETMySQLCommand", "Arma2NETMySQLCommandAsync", "ClrVersion", "CompareVersion", "Version", "GetClipboardText", "SetClipboardText", "CommandLine", "DateTime"]

01/17/2014 11:22:27 Arma2Net.Managed.FunctionNotFoundException: The specified add-in was not found: SELECT

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

à Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(String function, Int32 maxResultSize)

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

01/17/2014 11:22:27 function: SELECT * FROM arma3life.vehicles;

01/17/2014 11:22:27 maxResultSize: 4095

01/17/2014 11:22:27 Caught exception of type Arma2Net.Managed.FunctionNotFoundException

01/17/2014 11:22:27 Arma2Net.Managed.FunctionNotFoundException: The specified add-in was not found: SELECT

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

à Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(String function, Int32 maxResultSize)

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

01/17/2014 11:22:27 function: SELECT * FROM arma3life.vehicles;

01/17/2014 11:22:27 maxResultSize: 4095

01/17/2014 11:22:27 Caught exception of type Arma2Net.Managed.FunctionNotFoundException

01/17/2014 11:22:27 Loading add-ins

01/17/2014 11:22:27 Arma2Net.Managed.FunctionNotFoundException: The specified add-in was not found: SELECT

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

à Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(String function, Int32 maxResultSize)

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

01/17/2014 11:22:27 function: SELECT * FROM arma3life.vehicles;

01/17/2014 11:22:27 maxResultSize: 4095

01/17/2014 11:22:27 Caught exception of type System.Reflection.TargetInvocationException while loading add-in Arma2NetExplorer.exe

01/17/2014 11:22:27 System.Reflection.TargetInvocationException: Une exception a été levée par la cible d'un appel. ---> System.IO.FileLoadException: Impossible de charger le fichier ou l'assembly 'System.Data.SQLite, Version=1.0.89.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' ou une de ses dépendances. Tentative de chargement d'un exécutable non vérifiable avec des corrections (table IAT avec plus de 2***sections ou une section TLS.) (Exception de HRESULT : 0x80131019) ---> System.IO.FileLoadException: Tentative de chargement d'un exécutable non vérifiable avec des corrections (table IAT avec plus de 2***sections ou une section TLS.) (Exception de HRESULT : 0x80131019)

--- Fin de la trace de la pile d'exception interne ---

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

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

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

--- Fin de la trace de la pile d'exception interne ---

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

à System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

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

à Arma2Net.Managed.AddInManager.DomainDoCallback()

à System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)

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

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

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

01/17/2014 11:22:27 Domain Name Version Publisher Description

01/17/2014 11:22:27 Arma2NetExplorer.exe Arma2NETMySQL 0.1.0.0 firefly2442 Runs MySQL procedure commands.

01/17/2014 11:22:27 Arma2NetExplorer.exe Arma2NETMySQLCommand0.1.0.0 firefly2442 Runs raw MySQL/SQLite commands

01/17/2014 11:22:27 Arma2NetExplorer.exe Arma2NETMySQLCommandAsync0.1.0.0 firefly2442 Runs asynchronous raw MySQL/SQLite commands

01/17/2014 11:22:27 Arma2NetExplorer.exe ClrVersion 2.0.0.0 Scott_NZ Retrieves the version of the Common Language Runtime.

01/17/2014 11:22:27 Arma2NetExplorer.exe CompareVersion 2.0.0.0 Scott_NZ Compares two version strings and returns an integer indicating how they compare.

01/17/2014 11:22:27 Arma2NetExplorer.exe Version 2.0.0.0 Scott_NZ Returns the version of Arma2NET.

01/17/2014 11:22:27 Arma2NetExplorer.exe GetClipboardText 1.0.0.0 Scott_NZ Gets the clipboard text value.

01/17/2014 11:22:27 Arma2NetExplorer.exe SetClipboardText 1.0.0.0 Scott_NZ Sets the clipboard to a text value.

01/17/2014 11:22:27 Arma2NetExplorer.exe CommandLine 2.0.0.0 Scott_NZ Returns the command line used to start the application.

01/17/2014 11:22:27 Arma2NetExplorer.exe DateTime 2.0.0.0 Scott_NZ Returns the current date and time.

01/17/2014 11:22:27 function: Reload

01/17/2014 11:22:27 maxResultSize: 4095

01/17/2014 11:22:27 Result size: 0

01/17/2014 11:22:27 Result: <null>

[firefly2442 6]

@Shizles: That won't be something I'll be able to replicate so I'm not sure what else it could be. I would make sure you have the appropriate .NET framework installed. The other possibility is to compile the plugin yourself on the computer that you will be using it on. Perhaps there is something specific there that doesn't mesh well with how mine is setup. You could also try removing the Arma2NetMySQL plugin and just load Arma2NET and see if it still crashes. This might narrow it down to an issue with Arma2NET vs the plugin itself.

@fouc: Yes, that's not correct for testing in Arma2NETExplorer. See the Readme for more details. It will be something like this:

Arma2NETMySQLCommand ['weapons', 'SELECT * FROM users LIMIT 3']

. Obviously change the database name and query to something appropriate for whatever database structure you're using. Also, it looks like the log file says you're missing the SQLite dependency so make sure to install that (and the specific version that's listed).

[S.Schmidt 10]

I have some problems. acc connect to mysql but it write nothing

Arma2NETMySQL

Arma2NET

rpt

Edited January 17, 2014 by SSchmidt

[firefly2442 6]

I have some problems. acc connect to mysql but it write nothing

Arma2NETMySQL

Arma2NET

rpt

You need to install the SQLite dependency. See the readme for the link. Make sure you install version 1.0.89.0.

[S.Schmidt 10]

So and now ?

Arma2NETlog

[firefly2442 6]

So and now ?

Arma2NETlog

I'm guessing the Databases.text file is not setup properly. Can you post this (remember to remove the password).

[S.Schmidt 10]

Database.txt

[firefly2442 6]

Database.txt

That looks OK to me. Can you post your new Arma2NETMySQL log as well.

[colinm9991 20]

I had something similar, put "AddIns" with MySQL plugin in to expansion\beta.

Put databases.txt in to the arma 2 main folder, and in to ArmA2NET & ArmA2NETMySQL

[S.Schmidt 10]

colin the arma user is connectecd to mysql but he cant read and write i think. wrong mysql version? Server is 5.6.15 and connector is 6.7.4

ARMA2NETMySQL log

ARMA2NET log

[firefly2442 6]

colin the arma user is connectecd to mysql but he cant read and write i think. wrong mysql version? Server is 5.6.15 and connector is 6.7.4

ARMA2NETMySQL log

ARMA2NET log

I wonder if you're using an older version of Arma2NET and this plugin... I'm not sure if MSO is still in active development or not...