ArmA2 Persistent Database Scripts - WIP

[[kh]jman 49]

The failure is in your executable path. It needs to be D:\ArmA 2\Expansion\beta\

It is not enough to just use -mod=expansion\beta;expansion\beta\expansion;

Working directory should remain pointing to the root however.

Don't forget to edit Databases.txt and copy it to the Arma2 root too.

Edited June 14, 2012 by [KH]Jman

[Noc1337 1]

Okay, got it... sometimes i don't know what i'm doing.. ;)

But still got issues with Arma2Net..

2012/06/14, 17:27:24 Error in expression <throw "System.IO.FileNotFoundException">

2012/06/14, 17:27:24 Error position: <throw "System.IO.FileNotFoundException">

2012/06/14, 17:27:24 Error

[[kh]jman 49]

whole rpt please!

System.IO.FileNotFoundException, sounds to me like the Arma2NETMySQLPlugin.dll addin cannot be located.

Copy Arma2NETMySQLPlugin.dll into the @Arma2NET/Addins/Arma2NETMySQLPlugin/ folder

Edited June 14, 2012 by [KH]Jman

[Noc1337 1]

http://pastebin.com/dRzeJxJi

Ok, here is the RPT. You are great, thanks for your help!

and another one:

http://pastebin.com/6wV9wTS0

Edited June 14, 2012 by Noc1337

[[kh]jman 49]

Yes see my previous post re: System.IO.FileNotFoundException

[firefly2442 6]

Make sure the Databases.txt file exists as well.

[Noc1337 1]

Okay, checked both files...

databases.txt located in d:\arma 2\databases.txt

mysqlplugin located in d:\arma 2\@Arma2NET\Addins\Arma2NETMySQLPlugin

seems to be fine.. Any other hints? I think arma2net still isn't running, because i could not find any log folder...

Edited June 15, 2012 by Noc1337

[Scott_NZ 10]

Your previous error seems to suggest that Arma2NET is running - 'throw "System.IO.FileNotFoundException"' is only generated by Arma2NET. Arma2NET logs should be in the system's Local AppData folder.

[Noc1337 1]

Hmmm, okay... But what is missing? Somebody have a working @arma2net folder including all files (MySql.Data.dll and Arma2NETMySQLPlugin.dll) so i can try it with a "fresh install" ?

i dont't know where to search .. Trying to fix this issue for 3 days now.. ;(

---------- Post added at 07:49 ---------- Previous post was at 07:40 ----------

I thinks mysql plugin is located in right folder. Output from arma2net explorer:

[[kh]jman 49]

Stick with it. I see that you are not running the latest version on Arma2NET. You MUST make sure of your versions.

Download 1.10 here and then use the Arma2NETMySQLPlugin.dll from the persistentDB archive here

On another note, Tupolov of MSO fame has joined the PDB team has has been working hard on improving the code and adding some new functionality. PDB will be integrated into future versions of MSO so many thanks to him for his hard work on the project. Once we have tested the new code we will take the PDB project out of beta and make a version 1 release.

We are also planning a PDB version for Arma 3.

Edited June 15, 2012 by [KH]Jman

[Noc1337 1]

OMG... Got a new issue... I'm feeling soooooo stupid...

Server RPT

[[kh]jman 49]

Can you locate the Arma2NET log?

[Noc1337 1]

Info: 13:40:14 - Arma2NETMySQL Plugin Started.

Info: 13:40:14 - Version number: 0.1

Info: 13:40:14 - Compiled with Arma2NET Version: 1.10.0.0

Info: 13:40:14 - Loading databases...

Info: 13:40:14 - Database: arma IPAddress: 127.0.0.1 Port: 3306 Username: arma Password: NotShownForSecurityReasons

Yes, logging is up and running

[[kh]jman 49]

Is that all the log?

[Noc1337 1]

Yes, it stops there... And the RPT is growing realy fast with this error:

162.

2012/06/15, 13:22:35 Error in expression <throw "System.Reflection.TargetInvocatio>

163.

2012/06/15, 13:22:35 Error position: <throw "System.Reflection.TargetInvocatio>

164.

2012/06/15, 13:22:35 Error

---------- Post added at 12:29 ---------- Previous post was at 12:28 ----------

Maybe you have some time to talk via teamspeak or something?

[[kh]jman 49]

No sorry I'm at work.

The Arma2NET log is what I'm interested in at this point not the server rpt. Please pastebin the Arma2NET log to clarify.

It appears your addin is crashing out when invoked by Arma2NET. Please confirm that you are using the Arma2NETMySQLPlugin.dll addin datestamped 14/06/2012 @ 10:18

Edited June 15, 2012 by [KH]Jman

[Noc1337 1]

I posted the whole ARMA2NET log... There is no more to copy from it.. :(

It stops right there... And the Player stuck at the loading screen (loading mission database or something like that)...

[[kh]jman 49]

Yes the client will not go any further since it is waiting for a mysql request result that it never receives from the server. Ctrl-Alt-Del and end task on it.

Please confirm that you are using the Arma2NETMySQLPlugin.dll addin datestamped 14/06/2012 @ 10:18 on the server

Arma2NET's nlog is not outputting the error. I'm taking to Scott_NZ right now to try and debug this further. Scott_NZ has had this error reported by another person but was not able to reproduce it at all.

Edited June 15, 2012 by [KH]Jman

[Noc1337 1]

Yes i can confirm the timestamp.

---------- Post added at 13:03 ---------- Previous post was at 12:58 ----------

Maybe Something with the dB. Layout to do?

[tupolov 520]

I've got a couple of people getting this error too:

Warning: 20:42:43 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): There is already an open DataReader associated with this Connection which must be closed first.

Any ideas?

EDIT - Fixed. The guys testing had the incorrect SQL import file.

Edited June 15, 2012 by Tupolov

[Noc1337 1]

Seems that nobody can help? Or sombody have some Good News or ideas?

[firefly2442 6]

@Noc: So, what's the current error at this point? Still the System.IO problem?

[Noc1337 1]

No, New issue.. :-(

http://pastebin.com/P2gmxXBN

[firefly2442 6]

Try this mission instead. It doesn't do much at this point but creating the weapons loadout works. Make sure you edit the Databases.txt file with the appropriate information and add the SQL file for the database procedures.

https://github.com/firefly2442/Arma2NetMySQLPlugin-ExampleMission

[Noc1337 1]

Which SQL file do you mean?