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

There's a beta version up on dropbox (Arma2NETMySQLPlugin_v0.2.0.0-beta1.zip). This uses the new (under development) version of Arma2NET and is Windows only (at this time). There are some interface changes so you will need to make adjustments to existing missions that use the current stable 0.1 version. There is updated documentation in the zip folder itself. You should not need to install the MySQL or SQLite dependencies as they are already provided. There are also some minor security improvements and the example mission is updated to reflect this. I'm working on a Linux port but have been quite busy lately so it might be awhile. As always, testing is most appreciated.

Share this post

Link to post
Share on other sites

hannibal2210    1

hannibal2210
Posted

Hey Firefly, just want to primarily say thanks for working on this project and that we have been using the AS loadout system and your plugin for over 2 years now (since Arma2).

Today I updated to your latest beta version on dropbox and found there is an error inside one of the mission scripts (using the mission that came in the zip).

2014/06/17,  3:04:12 Error in expression <"Arma2NETMySQLCommandAsync getresult";

sleep 0.5;  
};
serverRunningQuery = fal>
2014/06/17,  3:04:12   Error position: <sleep 0.5;  
};
serverRunningQuery = fal>
2014/06/17,  3:04:12   Error Generic error in expression
2014/06/17,  3:04:12 File mpmissions\__cur_mp.Stratis\as_loadouts\server_events.sqf, line 95
2014/06/17,  3:04:12 Suspending not allowed in this context

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

Hmm, that's interesting. I haven't seen that one before. Thanks for testing, I'll check it out.

Hey Firefly, just want to primarily say thanks for working on this project and that we have been using the AS loadout system and your plugin for over 2 years now (since Arma2).

Today I updated to your latest beta version on dropbox and found there is an error inside one of the mission scripts (using the mission that came in the zip).

2014/06/17,  3:04:12 Error in expression <"Arma2NETMySQLCommandAsync getresult";

sleep 0.5;  
};
serverRunningQuery = fal>
2014/06/17,  3:04:12   Error position: <sleep 0.5;  
};
serverRunningQuery = fal>
2014/06/17,  3:04:12   Error Generic error in expression
2014/06/17,  3:04:12 File mpmissions\__cur_mp.Stratis\as_loadouts\server_events.sqf, line 95
2014/06/17,  3:04:12 Suspending not allowed in this context

Share this post

Link to post
Share on other sites

infection    1

infection
Posted

Excuse me, I'm having some issues compiling. Whenever I try compile I get these errors.

Warning 24 The referenced component 'Arma2Net' could not be found. Arma2NETMySQLPlugin
Warning 18 Could not resolve this reference. Could not locate the assembly "Arma2Net". Check to make sure the assembly exists on disk. If this reference is required by your code, you may get compilation errors. Arma2NETMySQLPlugin

I've added @arma2net in the reference path and the arma 2 OA folder even, no luck.

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

You need to reference the Arma2Net.dll file. Not the folder.

Excuse me, I'm having some issues compiling. Whenever I try compile I get these errors.

I've added @arma2net in the reference path and the arma 2 OA folder even, no luck.

Share this post

Link to post
Share on other sites

infection    1

infection
Posted (edited)
You need to reference the Arma2Net.dll file. Not the folder.

The Arma2Net.Managed.dll? I've tried all of them, does not work.

And if you literally mean Arma2Net.dll there is no such file in my folder, I feel like I'm being an idiot here. haha :D

I've managed to fix it by compiling the latest version of Arma2Net, I guess I was kinda being an idiot! Haha, anyways thanks for your help.

Edited by Infection

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

Ahh sorry, yeah this file: @Arma2NET\Arma2Net.AddInProxy.dll

The Arma2Net.Managed.dll? I've tried all of them, does not work.

And if you literally mean Arma2Net.dll there is no such file in my folder, I feel like I'm being an idiot here. haha :D

I've managed to fix it by compiling the latest version of Arma2Net, I guess I was kinda being an idiot! Haha, anyways thanks for your help.

Share this post

Link to post
Share on other sites

infection    1

infection
Posted
Ahh sorry, yeah this file: @Arma2NET\Arma2Net.AddInProxy.dll

That didn't work when I tried it, the only thing that worked was by compiling the latest Arma2NET from github and using the Arma2Net.dll

I'm using the latest dev version aswell, I forgot to mention that.

Share this post

Link to post
Share on other sites

UK431-Soul    10

UK431-Soul
Posted

@firefly2442:

Have you taken a look at the HiveExt.dll from dayz on how they handle with the comma's?

There is no problem using them the only thing is currently the child node for custom queries has been removed

cause they found it to be unsecure forcing scripters to use secondary methods to achieve what we want.

I've struck the comma problem and wished id have read that part sooner, i've fixed it by replacing the , with a `

and now it works fine still i find it a serious "annoyance".

anyway this an amazing dll extension to say the least :p and happy to use it on our dayz servers.

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

Oh, the dev version, yeah, there ya go.

That didn't work when I tried it, the only thing that worked was by compiling the latest Arma2NET from github and using the Arma2Net.dll

I'm using the latest dev version aswell, I forgot to mention that.

---------- Post added at 23:32 ---------- Previous post was at 23:28 ----------

Is that code public? Yeah, it's definitely something I want to fix/change. I'll take a look again.

@firefly2442:

Have you taken a look at the HiveExt.dll from dayz on how they handle with the comma's?

There is no problem using them the only thing is currently the child node for custom queries has been removed

cause they found it to be unsecure forcing scripters to use secondary methods to achieve what we want.

I've struck the comma problem and wished id have read that part sooner, i've fixed it by replacing the , with a `

and now it works fine still i find it a serious "annoyance".

anyway this an amazing dll extension to say the least :p and happy to use it on our dayz servers.

Share this post

Link to post
Share on other sites

infection    1

infection
Posted (edited)
Oh, the dev version, yeah, there ya go.

---------- Post added at 23:32 ---------- Previous post was at 23:28 ----------

Is that code public? Yeah, it's definitely something I want to fix/change. I'll take a look again.

Yes I believe it's public, I think https://github.com/DayZMod/Hive-Binaries is what you're looking for.

The way I got around it though was making whatever array I was doing into a string then using Toarray to make it a single array with numbers then tostring to make it back to the array, any downside about this since single arrays and commas work fine?

Last edit: Been testing dev version but I can't get it to work any way, when I get ingame it just dosn't seem to be able to call the commands. But maybe this is to be expected since in dev? Are there any major advantages of using dev version atm? :p

Edited by Infection

Share this post

Link to post
Share on other sites

davidjjdj    10

davidjjdj
Posted (edited)

I cannot get any missions working, whether I use SQL Life, PersistentDB, or even the example mission, nothing saves to any databases. Is this addon still working?

Edit:

Something happened to my ArmA 2 NET, now that I have fixed it I got a new error. When clicking create loadout in the example mission, it crashes the server and client gets no message recieved.

From ArmA2NET

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].

07/21/2014 15:27:56 Arma2Net.Unmanaged loaded successfully

07/21/2014 15:27:57 Fatal unhandled exception of type System.IO.FileNotFoundException

07/21/2014 15:27:57 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)

I have now unblocked all DLL files in ArmA2NET, still nothing. The game no longer locks up but it still does not communicate with databases.

Updated Log File

http://pastebin.com/4GyvRug5

Edited by davidjjdj

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

What does the Arma2NETMySQL log say?

I cannot get any missions working, whether I use SQL Life, PersistentDB, or even the example mission, nothing saves to any databases. Is this addon still working?

Edit:

Something happened to my ArmA 2 NET, now that I have fixed it I got a new error. When clicking create loadout in the example mission, it crashes the server and client gets no message recieved.

From ArmA2NET

I have now unblocked all DLL files in ArmA2NET, still nothing. The game no longer locks up but it still does not communicate with databases.

Updated Log File

http://pastebin.com/4GyvRug5

Share this post

Link to post
Share on other sites

davidjjdj    10

davidjjdj
Posted
What does the Arma2NETMySQL log say?

I found the problem, sorry I forgot to post back before you replied, the DLL's were blocked in windows server 2008.

Share this post

Link to post
Share on other sites

tomeek    10

tomeek
Posted

Hi, I have a following errors in .rpt file when trying to run a mission:

2014/07/22, 15:00:52 "############################# Start LifeRemake-master #############################"
2014/07/22, 15:00:59 [8643,190.541,0,"XEH: PreInit Started. v1.0.0.189. MISSINIT: missionName=LifeRemake-master, worldName=chernarus, isMultiplayer=true, isServer=true, isDedicated=true"]
2014/07/22, 15:00:59 [8643,190.643,0,"XEH: PreInit Finished. CACHE DISABLED? (Disable caching with cba_disable_cache.pbo): SLX_XEH_RECOMPILE=false, CBA_COMPILE_RECOMPILE=false, CBA_FUNC_RECOMPILE=false"]
2014/07/22, 15:01:01 [8645,191.908,0,"XEH: PostInit Started"]
2014/07/22, 15:01:01 [8645,191.923,0,"CBA_VERSIONING: cba=1.0.0.190, cba_a2=1.0.0.8, cba_oa=1.0.0.6, ace=1.14.0.597, acex=1.14.0.373, acex_ru=1.14.0.77, acex_usnavy=1.14.0.79, "]
2014/07/22, 15:01:01 [8645,192.195,0,"XEH: PostInit Finished. State: _isClient=false, _isJip=false, _isDedClient=false, _isServer=true, _isDedServer=true, _playerCheckDone=true, _sp=false, _startInitDone=true, _postInitDone=true, _mpRespawn=true, _machineType=0, _sessionId=2, _level=0, _timeOut=false, _game=1, BIS_functions=L 3-2-D:1, group=L 3-2-D"]
2014/07/22, 15:01:07 Error in expression <old<NULL-object> = objnull>
2014/07/22, 15:01:07   Error position: <= objnull>
2014/07/22, 15:01:07   Error Invalid number in expression
2014/07/22, 15:01:07 Error in expression <old<NULL-object> = objnull>
2014/07/22, 15:01:07   Error position: <= objnull>
2014/07/22, 15:01:07   Error Invalid number in expression
2014/07/22, 15:01:26 Error in expression <System.IO.FileNotFoundException: Could not fin>
2014/07/22, 15:01:26   Error position: <.IO.FileNotFoundException: Could not fin>
2014/07/22, 15:01:26   Error Missing ;
2014/07/22, 15:01:26 Error in expression <System.IO.FileNotFoundException: Could not fin>
2014/07/22, 15:01:26   Error position: <.IO.FileNotFoundException: Could not fin>
2014/07/22, 15:01:26   Error Missing ;

Result of this is that the saving doesn't work at all.

And no other logs are created (for Arma2NET or Arma2NETMySQL), folders are empty.

-OS is a Windows server 2012 r2

-MySQL version 5.6.19

-Both dependencies are installed (mysql-connector-net-6.7.4.msi and sqlite-netFx40-setup-bundle-x86-2010-1.0.89.0.exe)

-Arma2 version 1.62.95251

However, when I enter a following command into Arma2NETExplorer.exe:

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

The Arma2NET and Arma2NETMySQL logs are created.

Arma2NET.2014-7-22.log:

07/22/2014 15:29:50 Arma2NET 2.3.0.0 running on CLR 4.0.30319.34003
07/22/2014 15:29:50 Loaded into process Arma2NetExplorer
07/22/2014 15:29:50 Loading add-ins
07/22/2014 15:29:50 Domain                        Name                Version   Publisher           Description
07/22/2014 15:29:50 Arma2NetExplorer.exe          Arma2NETMySQL       0.1.0.0   firefly2442         Runs MySQL procedure commands.
07/22/2014 15:29:50 Arma2NetExplorer.exe          Arma2NETMySQLCommand0.1.0.0   firefly2442         Runs raw MySQL/SQLite commands
07/22/2014 15:29:50 Arma2NetExplorer.exe          Arma2NETMySQLCommandAsync0.1.0.0   firefly2442         Runs asynchronous raw MySQL/SQLite commands
07/22/2014 15:29:50 Arma2NetExplorer.exe          ClrVersion          2.0.0.0   Scott_NZ            Retrieves the version of the Common Language Runtime.
07/22/2014 15:29:50 Arma2NetExplorer.exe          CompareVersion      2.0.0.0   Scott_NZ            Compares two version strings and returns an integer indicating how they compare.
07/22/2014 15:29:50 Arma2NetExplorer.exe          Version             2.0.0.0   Scott_NZ            Returns the version of Arma2NET.
07/22/2014 15:29:50 Arma2NetExplorer.exe          GetClipboardText    1.0.0.0   Scott_NZ            Gets the clipboard text value.
07/22/2014 15:29:50 Arma2NetExplorer.exe          SetClipboardText    1.0.0.0   Scott_NZ            Sets the clipboard to a text value.
07/22/2014 15:29:50 Arma2NetExplorer.exe          CommandLine         2.0.0.0   Scott_NZ            Returns the command line used to start the application.
07/22/2014 15:29:50 Arma2NetExplorer.exe          DateTime            2.0.0.0   Scott_NZ            Returns the current date and time.
07/22/2014 15:29:50 Arma2NET initialized in 00:00:00.0284466
07/22/2014 15:29:50 function: Arma2NETMySQLCommand ['life', 'SELECT * FROM users LIMIT 3']
07/22/2014 15:29:50 maxResultSize: 4095
07/22/2014 15:29:50 Result size: 4
07/22/2014 15:29:50 Result: [[]]

07-22-2014_15-29-50.log:

Info: 15:29:50 - Logging started in directory: C:\Users\Administrator\AppData\Local\Arma2NETMySQL/logs/
Info: 15:29:50 - Arma2NETMySQL Plugin Started.
Info: 15:29:50 - Version number: 0.1.0.0
Info: 15:29:50 - Loading databases...
Warning: 15:29:50 - Unable to find the Databases.txt file here: C:\TCAFiles\Users\accmisja\2\@Arma2NET\Databases.txt
Info: 15:29:50 - Databases.txt file loading in from: C:\Users\Administrator\AppData\Local\Arma2NETMySQL/Databases.txt
Info: 15:29:50 - Type: mysql Database: weaponsarma3 IPAddress: 127.0.0.1 Port: 3306 Username: arma Password: NotShownForSecurityReasons
Info: 15:29:50 - Type: mysql Database: life IPAddress: 127.0.0.1 Port: 3306 Username: arma Password: NotShownForSecurityReasons
Info: 15:29:50 - Type: mysql Database: arma3life IPAddress: 127.0.0.1 Port: 3306 Username: arma3 Password: NotShownForSecurityReasons
Info: 15:29:50 - Received - Database: life SQL Query: SELECT * FROM users LIMIT 3

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

It looks like it's working to me. Is there anything in the database?

Hi, I have a following errors in .rpt file when trying to run a mission:

2014/07/22, 15:00:52 "############################# Start LifeRemake-master #############################"
2014/07/22, 15:00:59 [8643,190.541,0,"XEH: PreInit Started. v1.0.0.189. MISSINIT: missionName=LifeRemake-master, worldName=chernarus, isMultiplayer=true, isServer=true, isDedicated=true"]
2014/07/22, 15:00:59 [8643,190.643,0,"XEH: PreInit Finished. CACHE DISABLED? (Disable caching with cba_disable_cache.pbo): SLX_XEH_RECOMPILE=false, CBA_COMPILE_RECOMPILE=false, CBA_FUNC_RECOMPILE=false"]
2014/07/22, 15:01:01 [8645,191.908,0,"XEH: PostInit Started"]
2014/07/22, 15:01:01 [8645,191.923,0,"CBA_VERSIONING: cba=1.0.0.190, cba_a2=1.0.0.8, cba_oa=1.0.0.6, ace=1.14.0.597, acex=1.14.0.373, acex_ru=1.14.0.77, acex_usnavy=1.14.0.79, "]
2014/07/22, 15:01:01 [8645,192.195,0,"XEH: PostInit Finished. State: _isClient=false, _isJip=false, _isDedClient=false, _isServer=true, _isDedServer=true, _playerCheckDone=true, _sp=false, _startInitDone=true, _postInitDone=true, _mpRespawn=true, _machineType=0, _sessionId=2, _level=0, _timeOut=false, _game=1, BIS_functions=L 3-2-D:1, group=L 3-2-D"]
2014/07/22, 15:01:07 Error in expression <old<NULL-object> = objnull>
2014/07/22, 15:01:07   Error position: <= objnull>
2014/07/22, 15:01:07   Error Invalid number in expression
2014/07/22, 15:01:07 Error in expression <old<NULL-object> = objnull>
2014/07/22, 15:01:07   Error position: <= objnull>
2014/07/22, 15:01:07   Error Invalid number in expression
2014/07/22, 15:01:26 Error in expression <System.IO.FileNotFoundException: Could not fin>
2014/07/22, 15:01:26   Error position: <.IO.FileNotFoundException: Could not fin>
2014/07/22, 15:01:26   Error Missing ;
2014/07/22, 15:01:26 Error in expression <System.IO.FileNotFoundException: Could not fin>
2014/07/22, 15:01:26   Error position: <.IO.FileNotFoundException: Could not fin>
2014/07/22, 15:01:26   Error Missing ;

Result of this is that the saving doesn't work at all.

And no other logs are created (for Arma2NET or Arma2NETMySQL), folders are empty.

-OS is a Windows server 2012 r2

-MySQL version 5.6.19

-Both dependencies are installed (mysql-connector-net-6.7.4.msi and sqlite-netFx40-setup-bundle-x86-2010-1.0.89.0.exe)

-Arma2 version 1.62.95251

However, when I enter a following command into Arma2NETExplorer.exe:

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

The Arma2NET and Arma2NETMySQL logs are created.

Arma2NET.2014-7-22.log:

07/22/2014 15:29:50 Arma2NET 2.3.0.0 running on CLR 4.0.30319.34003
07/22/2014 15:29:50 Loaded into process Arma2NetExplorer
07/22/2014 15:29:50 Loading add-ins
07/22/2014 15:29:50 Domain                        Name                Version   Publisher           Description
07/22/2014 15:29:50 Arma2NetExplorer.exe          Arma2NETMySQL       0.1.0.0   firefly2442         Runs MySQL procedure commands.
07/22/2014 15:29:50 Arma2NetExplorer.exe          Arma2NETMySQLCommand0.1.0.0   firefly2442         Runs raw MySQL/SQLite commands
07/22/2014 15:29:50 Arma2NetExplorer.exe          Arma2NETMySQLCommandAsync0.1.0.0   firefly2442         Runs asynchronous raw MySQL/SQLite commands
07/22/2014 15:29:50 Arma2NetExplorer.exe          ClrVersion          2.0.0.0   Scott_NZ            Retrieves the version of the Common Language Runtime.
07/22/2014 15:29:50 Arma2NetExplorer.exe          CompareVersion      2.0.0.0   Scott_NZ            Compares two version strings and returns an integer indicating how they compare.
07/22/2014 15:29:50 Arma2NetExplorer.exe          Version             2.0.0.0   Scott_NZ            Returns the version of Arma2NET.
07/22/2014 15:29:50 Arma2NetExplorer.exe          GetClipboardText    1.0.0.0   Scott_NZ            Gets the clipboard text value.
07/22/2014 15:29:50 Arma2NetExplorer.exe          SetClipboardText    1.0.0.0   Scott_NZ            Sets the clipboard to a text value.
07/22/2014 15:29:50 Arma2NetExplorer.exe          CommandLine         2.0.0.0   Scott_NZ            Returns the command line used to start the application.
07/22/2014 15:29:50 Arma2NetExplorer.exe          DateTime            2.0.0.0   Scott_NZ            Returns the current date and time.
07/22/2014 15:29:50 Arma2NET initialized in 00:00:00.0284466
07/22/2014 15:29:50 function: Arma2NETMySQLCommand ['life', 'SELECT * FROM users LIMIT 3']
07/22/2014 15:29:50 maxResultSize: 4095
07/22/2014 15:29:50 Result size: 4
07/22/2014 15:29:50 Result: [[]]

07-22-2014_15-29-50.log:

Info: 15:29:50 - Logging started in directory: C:\Users\Administrator\AppData\Local\Arma2NETMySQL/logs/
Info: 15:29:50 - Arma2NETMySQL Plugin Started.
Info: 15:29:50 - Version number: 0.1.0.0
Info: 15:29:50 - Loading databases...
Warning: 15:29:50 - Unable to find the Databases.txt file here: C:\TCAFiles\Users\accmisja\2\@Arma2NET\Databases.txt
Info: 15:29:50 - Databases.txt file loading in from: C:\Users\Administrator\AppData\Local\Arma2NETMySQL/Databases.txt
Info: 15:29:50 - Type: mysql Database: weaponsarma3 IPAddress: 127.0.0.1 Port: 3306 Username: arma Password: NotShownForSecurityReasons
Info: 15:29:50 - Type: mysql Database: life IPAddress: 127.0.0.1 Port: 3306 Username: arma Password: NotShownForSecurityReasons
Info: 15:29:50 - Type: mysql Database: arma3life IPAddress: 127.0.0.1 Port: 3306 Username: arma3 Password: NotShownForSecurityReasons
Info: 15:29:50 - Received - Database: life SQL Query: SELECT * FROM users LIMIT 3

Share this post

Link to post
Share on other sites

tomeek    10

tomeek
Posted (edited)
It looks like it's working to me. Is there anything in the database?

There's only an untouched DB schema that needed to be created manually in the first place. Users table where player stats are saved has 0 rows.

Edited by tomeek

Share this post

Link to post
Share on other sites

biggles2206    10

biggles2206
Posted

I have setup today a Altis Life server, on a windows 2008 R2 VDS (Virtual Dedicated Server). When I try and join it, I get stuck on the 'Sending request to Server for Player UID (76561198059037263). When this happened (and after a load of googling) I looked at the Arma2Net log. This is what it had, but about 50+ times:

07/22/2014 19:00:35 Caught exception of type Arma2Net.Managed.FunctionNotFoundException
07/22/2014 19:00:35 Arma2Net.Managed.FunctionNotFoundException: The specified add-in was not found: Arma2NETMySQLCommandAsync
  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)
07/22/2014 19:00:35 function: Arma2NETMySQLCommandAsync ['arma3life', 'SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear FROM players WHERE playerid='76561198059037263'']
07/22/2014 19:00:35 maxResultSize: 10239

Im not sure where to find other logs, as I am a complete idiot at making arma servers :/

Thanks for Help in advanced

- Thomas

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

Are you expecting that the SELECT statement will return something else? I guess I'm not sure what the problem is. Can you provide more details? What are you expecting?

There's only an untouched DB schema that needed to be created manually in the first place. Users table where player stats are saved has 0 rows.

---------- Post added at 18:59 ---------- Previous post was at 18:58 ----------

I'm guessing the plugin probably isn't there. Check the Addins folder and make sure it matches that provided by the instructions. I bet you're missing the .DLL.

I have setup today a Altis Life server, on a windows 2008 R2 VDS (Virtual Dedicated Server). When I try and join it, I get stuck on the 'Sending request to Server for Player UID (76561198059037263). When this happened (and after a load of googling) I looked at the Arma2Net log. This is what it had, but about 50+ times:

07/22/2014 19:00:35 Caught exception of type Arma2Net.Managed.FunctionNotFoundException
07/22/2014 19:00:35 Arma2Net.Managed.FunctionNotFoundException: The specified add-in was not found: Arma2NETMySQLCommandAsync
  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)
07/22/2014 19:00:35 function: Arma2NETMySQLCommandAsync ['arma3life', 'SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear FROM players WHERE playerid='76561198059037263'']
07/22/2014 19:00:35 maxResultSize: 10239

Im not sure where to find other logs, as I am a complete idiot at making arma servers :/

Thanks for Help in advanced

- Thomas

Share this post

Link to post
Share on other sites

tomeek    10

tomeek
Posted
Are you expecting that the SELECT statement will return something else? I guess I'm not sure what the problem is. Can you provide more details? What are you expecting?

The SELECT command was only for testing purposes, to see if the plugin can connect to the DB. The thing is, that with Arma2NETExplorer.exe everything works flawlessly, even I could put an INSERT and it would work.

But when I am trying to save something in the mission (Modified Cherno Life) it doesn't work (see .rpt file in my first post) and no Arma2NET and Arma2NETMySQL logs are created so I don't know where the problem is.

Even I tried to run Altis Life on my ArmA3 server and the same thing happens:

2014/07/22, 15:01:07 Error in expression <old<NULL-object> = objnull>
2014/07/22, 15:01:07   Error position: <= objnull>
2014/07/22, 15:01:07   Error Invalid number in expression
2014/07/22, 15:01:07 Error in expression <old<NULL-object> = objnull>
2014/07/22, 15:01:07   Error position: <= objnull>
2014/07/22, 15:01:07   Error Invalid number in expression
2014/07/22, 15:01:26 Error in expression <System.IO.FileNotFoundException: Could not fin>
2014/07/22, 15:01:26   Error position: <.IO.FileNotFoundException: Could not fin>
2014/07/22, 15:01:26   Error Missing ;
2014/07/22, 15:01:26 Error in expression <System.IO.FileNotFoundException: Could not fin>
2014/07/22, 15:01:26   Error position: <.IO.FileNotFoundException: Could not fin>
2014/07/22, 15:01:26   Error Missing ;

I hope you understand :) Ask me anything that comes to your mind so I could provide more details.

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

Well, that System.IO.FileNotFound is troubling. What's your folder structure setup look like? Where are the DLLs and so on?

The SELECT command was only for testing purposes, to see if the plugin can connect to the DB. The thing is, that with Arma2NETExplorer.exe everything works flawlessly, even I could put an INSERT and it would work.

But when I am trying to save something in the mission (Modified Cherno Life) it doesn't work (see .rpt file in my first post) and no Arma2NET and Arma2NETMySQL logs are created so I don't know where the problem is.

Even I tried to run Altis Life on my ArmA3 server and the same thing happens:

2014/07/22, 15:01:07 Error in expression <old<NULL-object> = objnull>
2014/07/22, 15:01:07   Error position: <= objnull>
2014/07/22, 15:01:07   Error Invalid number in expression
2014/07/22, 15:01:07 Error in expression <old<NULL-object> = objnull>
2014/07/22, 15:01:07   Error position: <= objnull>
2014/07/22, 15:01:07   Error Invalid number in expression
2014/07/22, 15:01:26 Error in expression <System.IO.FileNotFoundException: Could not fin>
2014/07/22, 15:01:26   Error position: <.IO.FileNotFoundException: Could not fin>
2014/07/22, 15:01:26   Error Missing ;
2014/07/22, 15:01:26 Error in expression <System.IO.FileNotFoundException: Could not fin>
2014/07/22, 15:01:26   Error position: <.IO.FileNotFoundException: Could not fin>
2014/07/22, 15:01:26   Error Missing ;

I hope you understand :) Ask me anything that comes to your mind so I could provide more details.

Share this post

Link to post
Share on other sites

tomeek    10

tomeek
Posted
Well, that System.IO.FileNotFound is troubling. What's your folder structure setup look like? Where are the DLLs and so on?

MySQL Server:

C:\Program Files (x86)\MySQL\MySQL Server 5.6

MySQL Connector:

C:\Program Files (x86)\MySQL\MySQL Connector Net 6.7.4

SQLite Connector:

C:\Program Files (x86)\System.Data.SQLite\2010

Arma2NET logs:

C:\Users\Administrator\AppData\Local\Arma2NET

Arma2NETMySQL: (with databases.txt inside)

C:\Users\Administrator\AppData\Local\Arma2NETMySQL

@Arma2NET:

C:\TCAFiles\Users\accmisja\2\@Arma2NET

[spoiler][url=http://i.imgur.com/y35tPGu.jpg?1]http://i.imgur.com/y35tPGu.jpg?1[/url] (109 kB) [/spoiler]

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

SQLite version: 1.0.89.0?

What's inside the @Arma2NET/AddIns folder?

MySQL Server:

C:\Program Files (x86)\MySQL\MySQL Server 5.6

MySQL Connector:

C:\Program Files (x86)\MySQL\MySQL Connector Net 6.7.4

SQLite Connector:

C:\Program Files (x86)\System.Data.SQLite\2010

Arma2NET logs:

C:\Users\Administrator\AppData\Local\Arma2NET

Arma2NETMySQL: (with databases.txt inside)

C:\Users\Administrator\AppData\Local\Arma2NETMySQL

@Arma2NET:

C:\TCAFiles\Users\accmisja\2\@Arma2NET

[spoiler][url=http://i.imgur.com/y35tPGu.jpg?1]http://i.imgur.com/y35tPGu.jpg?1[/url] (109 kB) [/spoiler]

Share this post

Link to post
Share on other sites

tomeek    10

tomeek
Posted
SQLite version: 1.0.89.0?

Yep

What's inside the @Arma2NET/AddIns folder?

AddIns folder:

hdRbGa3.jpg?1

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
×