ArmA2 Persistent Database Scripts - WIP

[Noc1337 1]

Please be sure to lad cba before arma2net!

[gerarddude5100 1]

Sorry whats LAD? Do you mean Load. Because if u did i only load them at the sam time

---------- Post added at 17:02 ---------- Previous post was at 16:11 ----------

I have loaded all the available mods on the dedicated server that i was said to in the readme.

I have uploaded the phpmyadmin.sql file to my server database.

I have set true to the Arma2Net system.yaml

i have installed MysqlNet connecter 6.4.5

I have put the correct information into the database.txt and installed it in my root directory

However my server still can not launch the addin Arma2NETMySQLPlugin.dll

And i am not totally stuck on what to do.

Edited June 22, 2012 by gerarddude5100

[Noc1337 1]

Lad = load

[firefly2442 6]

Would you please provide a copy of your Databases.txt file? MAKE SURE YOU REMOVE YOUR PASSWORD. :)

My Databases.txt file looks like this:

# 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
# For an example, see the following
#databasename,ipaddress,port,username,password
#
#arma,127.0.0.1,3306,armausername,secret

weapons,192.168.1.105,3306,arma,123

Sorry whats LAD? Do you mean Load. Because if u did i only load them at the sam time

---------- Post added at 17:02 ---------- Previous post was at 16:11 ----------

I have loaded all the available mods on the dedicated server that i was said to in the readme.

I have uploaded the phpmyadmin.sql file to my server database.

I have set true to the Arma2Net system.yaml

i have installed MysqlNet connecter 6.4.5

I have put the correct information into the database.txt and installed it in my root directory

However my server still can not launch the addin Arma2NETMySQLPlugin.dll

And i am not totally stuck on what to do.

[gerarddude5100 1]

# Put each database connection you want on a separate line

# For an example, see the following

#databasename,ipaddress,port,username,password

#

arma,127.0.0.1,3306,root,******

---------- Post added at 08:46 ---------- Previous post was at 07:48 ----------

I just can not get the Arma2NETMysqlPlugin To start.

---------- Post added at 09:21 ---------- Previous post was at 08:46 ----------

should i reinstall arma and try the whole thing again. See if it works.

[armatech 8]

is there any chance of adding non-procedure call in for them who cannot add procedures due to hosting restrictions

E.G.

_response = "Arma2Net.Unmanaged" callExtension format ["Arma2NETMySQL ['%1','%2']", _databaseName,"SELECT * FROM users"];

_response = "Arma2Net.Unmanaged" callExtension format ["Arma2NETMySQL ['%1','%2']", _databaseName,"SELECT col1, col2 FROM users"];

_response = "Arma2Net.Unmanaged" callExtension format ["Arma2NETMySQL ['%1','%2']", _databaseName,"UPDATE users SET col2='22' WHERE col1='testuser'"];

[[kh]jman 49]

Arma2NETMySQLPlugin.dll updated in Dev-heaven repo and PersistentDB.7z

- Arma2NETMySQLPlugin.dll Fixed duplicate entries in database issue. [Firefly2442]

[gerarddude5100 1]

I still can not get Arma2NETMysql to start. I have reinstalled arma and set it up again and still nothing

Any ideas on what to do?

Someone reply with what i could do to help u fix this problem because i am completly stuck and have no idear on what to do

Edited June 23, 2012 by gerarddude5100

[Scott_NZ 10]

Here's an idea,

Open Arma2NET Explorer, click the Evaluator tab, type 'functions' into the textbox and then press Enter. What's the output?

That reminds me, I should make the output actually copyable...

[gerarddude5100 1]

The ouput is "Activate','IsFunction","Deactivate","_Empty","VersionOfAddIn", 'CompareVersion","ClrVersion"," Version","Functions"

Which one should i use?

Edited June 23, 2012 by gerarddude5100

[Scott_NZ 10]

What happens if you type Activate 'Arma2NETMySQL'?

[firefly2442 6]

Sure, I can add that in. I guess I didn't think that some hosts would restrict it. Interesting.

is there any chance of adding non-procedure call in for them who cannot add procedures due to hosting restrictions

E.G.

[gerarddude5100 1]

when i type it in like this "ActivateArma2NETMysql" it produces "Throw "Arma2Net.Managed.FunctionNotException

When i type it in like this "Activate Arma2NETMysql" it produces "throw "Syestem.FormatException"

What else could i try?

Is there a certain way i have to type it? and should i type it when the servers on?

Edited June 23, 2012 by gerarddude5100

[Scott_NZ 10]

The addin name must be within quotes.

Activate 'Arma2NETMySQL'

[armatech 8]

Sure, I can add that in. I guess I didn't think that some hosts would restrict it. Interesting.

That would be fantastic

Sent from my LT18i using Tapatalk 2

[gerarddude5100 1]

Do i have to have the server on or off when i type that line?

because i put that line in and i got this Throw "Syestem.Reflection.TargetInvocationException"

Edited June 23, 2012 by gerarddude5100

[Scott_NZ 10]

That shouldn't happen - check your Arma2NET log.

[gerarddude5100 1]

http://pastebin.com/fvc7KJUF

This is what i get.

I have read it and does that mean that the databases file should be in here

C:\Program Files (x86)\Bohemia Interactive\ArmA 2

Or here

C:\Program Files (x86)\Bohemia Interactive\ArmA 2\@Arma2NET

---------- Post added at 18:34 ---------- Previous post was at 17:49 ----------

Now im getting this in my arma2NET Log

http://pastebin.com/KALw8iEb

Edited June 23, 2012 by gerarddude5100

[firefly2442 6]

It should be in:

C:\Program Files (x86)\Bohemia Interactive\ArmA 2\

Actually, I've been testing this with Operation Arrowhead. Do you have that? Perhaps that's the problem?

I have a separate Operation Arrowhead folder (not sure how that's setup for you, I have Steam version) like so:

E:\Program Files\Steam\steamapps\common\arma 2 operation arrowhead\

[gerarddude5100 1]

i have operation arrow head there just all in the same folder, which is called Arma2. I have the retail arma x anniversary edition (BOXED)

But whats happening is i have been checking some logs which say that mysql can not connect to my database as it is the wrong name. but i have been looking in php myadmin and i am not sure what is my database name. as I thought it was called "arma". Because when i imported the sql file thats what it made.

This is the Mysqlplugin log i am getting

Info: 20:19:56 - Arma2NETMySQL Plugin Started.

Info: 20:19:56 - Version number: 0.1

Info: 20:19:56 - Compiled with Arma2NET Version: 1.10.0.0

Info: 20:19:56 - Loading databases...

Info: 20:19:56 - Database: arma IPAddress: 127.0.0.1 Port: 3306 Username: root Password: NotShownForSecurityReasons

Info: 20:19:56 - Unable to open connection to database, trying again in 10 seconds.MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown database 'arma'

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.AuthenticateNew(Boolean reset)

at MySql.Data.MySqlClient.NativeDriver.Authenticate(Boolean reset)

at MySql.Data.MySqlClient.NativeDriver.Open()

at MySql.Data.MySqlClient.Driver.Open()

at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

at MySql.Data.MySqlClient.MySqlPool.GetConnection()

at MySql.Data.MySqlClient.MySqlConnection.Open()

at Arma2NETMySQLPlugin.MySQL.OpenConnection(String connectionString)

Edited June 23, 2012 by gerarddude5100

[firefly2442 6]

OK, so this is good. It shows that the plugin is loading appropriately. You just need to fix the database portion. Unknown database means the database probably doesn't exist or has a different name. When you login to phpmyadmin, look on the left hand side and it should list all the databases that are available.

[gerarddude5100 1]

Ok in phpadmin i have seen the databases at the side and the one called arma is the database that was created because of the phpadmin.sql that i imported into phpadmin

[firefly2442 6]

Please post the SQL file that you ran. You may want to read up a little on MySQL and how databases and user permissions work. There are many tutorials on the Internet.

[gerarddude5100 1]

here is the sql file that i uploaded to phpmyadmin

http://www.mediafire.com/?9t7sf75uc86thid

And i will read up on it to see what i can do. As imkind of new to databases and i thought it was that simple to just upload the file and connect. I guess its not

[firefly2442 6]

Hmm, well, that SQL file does create a database. So it should work. You could try dropping the database and re-running the SQL file again. Were there any errors when you ran it?

It should be relatively straightforward in terms of uploading the file and connecting but you do need to understand what is happening otherwise things can get messed up.