[kh]jman

Mentioned before many times ;)

As of right now, no. It's not supported by Battleye yet :j: Edit. It's being added right now.

Arma2NETMySQLPlugin.dll updated in Dev-heaven repo and PersistentDB.7z - fix build for Arma2NET 1.9 [firefly2442]

Wait for Battleye to support it. It's a manual process.

$able, I've noticed that BERcon disconnects quite regularly on busy servers with high jip dysync. Is there any chance an auto reconnect can be added? Thx.

Will do and thanks I don't have alot of time to spend on the project these days!. Some of my scripts maybe a little long winded! I'll try to get ArmA2MYSQL Dev-Heaven project (now legacy) ungrouped from https://dev-heaven.net/projects/a2-sql-persistent-db and move the repo here: https://dev-heaven.net/projects/a2-sql-persistent-db/repository to: https://dev-heaven.net/projects/persistent-db

Yay!!! Well done Tupolov I'm very happy to see you've got it working. Feel free to fix any issues, add MSO support and make improvements to my code, I can add you to the Dev-heaven project if you like so so can create an MSO branch or whatever :) I've added point 15. to the install procedure here and 'un-aced' the steps :) I've also just updated the readme.html to include the installation steps https://dev-heaven.net/projects/a2-sql-persistent-db/repository/revisions/ccb347b5c5a7b241bb71f6d3deaba41ff1e952aa Direct link to PDBReadme.html

Tupolov, you seem to keep editing and changing your question after I reply. Please could you be clear about exactly what issues you are having now and what issues have now been resolved and how ;)

The database file should contain the database connection string for example: Database name, Database IP address, Database MYSQL Port, Database username, Database password so for a localhost server it would be something like: arma,127.0.0.1,3306,mydbUsername,mydbPassword The database.txt file should be copied to the server's root Arma2 folder. Have you created the database table structure and stored proceedures? The scripts should create the mission name in the mysql missions table if it does not exist as per my rpt example. As a test try manually creating the mission name in the missions table before running the mission. You'd only need to do this once. The name needs to be the same as the pdb_fullmissionName set in the pdbSetup.php file. On my server the scripts do insert the mission name into the missions table so I'm not sure why yours would be different. Do try manually inserting the missionname in the db and see if that fixes it. If it does I'd like to see your missions db table. Check that field name na is field type VARCHAR, Size: 255, NOT NULL and default ''

http://forums.bistudio.com/showthread.php?103871-CBA-Community-Base-Addons-for-A2-OA-and-CO&p=2135819&viewfull=1#post2135819 My server is A2 + OA (CO) and I run all 3 cba as do I on my client via Six. If you do not have an Arma2NET log (location previously mentioned) then Arma2NET is not loading. Your rpt indicates to me that Arma2NET is not loading. My scripts are designed to only work on dedicated. Ok here are my server RPT, server Arma2NET log and clientside rpt files for the non-ace demo Hopefully this will help you. Server RPT: ===================================================================== == E:\Programs\ArmA2\Expansion\beta\arma2oaserver.exe == E:\Programs\ArmA2\Expansion\beta\arma2oaserver.exe -arma2netdev -port=2302 -mod=expansion\beta;expansion\beta\expansion;E:\Programs\ArmA2\@CBA;E:\Programs\ArmA2\@CBA_A2;E:\Programs\ArmA2\@CBA_OA;@Arma2NET -name=Server-test -config=E:\Server-test\Server-test.cfg -cfg=E:\Server-test\Arma2-test.cfg -profiles=E:\Server-test ===================================================================== Exe timestamp: 2012/05/11 09:21:24 Current time: 2012/05/14 20:33:03 Version 1.60.92614 2012/05/14, 20:33:03 ca\missions\MPScenarios\MP_Deathmatch.chernarus: string @str_mpdeathmatch_subname cannot be localized client-side - move to global stringtable 2012/05/14, 20:33:07 ca\missions\MPScenarios\MP_Deathmatch.chernarus: string @str_mpdeathmatch_subname cannot be localized client-side - move to global stringtable 2012/05/14, 20:33:40 [14376,271.048,0,"XEH: PreInit Started. v1.0.0.179. MISSINIT: missionName=Co18_PDB_ConvoyHell_v1-5-100, worldName=Takistan, isMultiplayer=true, isServer=true, isDedicated=true"] 2012/05/14, 20:33:41 [14376,271.924,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"] 2012/05/14, 20:33:54 [14568,284.621,0,"XEH: PostInit Started"] 2012/05/14, 20:33:54 [14568,284.634,0,"CBA_VERSIONING: cba=1.0.0.182, cba_a2=1.0.0.8, cba_oa=1.0.0.6, "] 2012/05/14, 20:33:54 [14568,285.123,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=1, _level=0, _timeOut=false, _game=1, BIS_functions=L 1-1-B:1, group=L 1-1-B"] 2012/05/14, 20:33:55 ["PersistentDB: pdb settings loaded"] 2012/05/14, 20:33:55 "############################# Co18 PDB Convoy Hell #############################" 2012/05/14, 20:33:55 "--------------------------------" 2012/05/14, 20:33:55 "UPSMON started" 2012/05/14, 20:34:19 "SERVER MSG: count MISSIONDATA, 0" 2012/05/14, 20:34:25 "SERVER MSG: MissionName: Co18 PDB Convoy Hell not found" 2012/05/14, 20:34:29 ["setdate: _thisMissionDate: ",[2011,6,7,6,1]] 2012/05/14, 20:34:29 "SERVER MSG: Database mission id: 33" 2012/05/14, 20:34:29 "SERVER MSG: Database mission name selected: Co18 PDB Convoy Hell" 2012/05/14, 20:34:29 "SERVER MSG: Mission ID (SELECTED) is 33" 2012/05/14, 20:34:29 "SERVER MSG: Database mission date selected: [2011,6,7,6,1]" 2012/05/14, 20:34:29 ["PASS: _player: ",S1] 2012/05/14, 20:34:29 ["PASS: _puid: ","727809"] 2012/05/14, 20:34:29 ["PASS: _pname: ","[KH]Jman"] 2012/05/14, 20:34:29 ["PASS: _playerSide: ",WEST] 2012/05/14, 20:34:29 "SERVER MSG: Mission ID (ARRAY) is 33" 2012/05/14, 20:34:29 "SERVER MSG: Player connected [KH]Jman, puid 727809" 2012/05/14, 20:34:30 "SERVER MSG: Adding score 1832 to [KH]Jman, playerObject, S1 puid, 727809" 2012/05/14, 20:34:30 ["PersistentDB: SERVER PV - PDB_ACTIVATEPLAYER: ",[s1,"[KH]Jman",false]] 2012/05/14, 20:34:30 ["PersistentDB: UPDATESCORES, time: ",2.983] 2012/05/14, 20:35:31 "SERVER MSG: Player [KH]Jman, is leaving the server, frame Number: 17948, Tick: 382.041, Time: 63.864" 2012/05/14, 20:35:31 "SERVER MSG: Loop. 727809" 2012/05/14, 20:35:31 "SERVER MSG: Loop break. 727809" 2012/05/14, 20:35:31 ["_loadedPlayerScore: ",0,"SCALAR"] 2012/05/14, 20:35:31 ["_globalPlayerScore: ",1832,"SCALAR"] 2012/05/14, 20:35:31 ["_pscore: ",0,"SCALAR"] 2012/05/14, 20:35:31 ["player is kneeling"] 2012/05/14, 20:35:31 ["pdb_ace_enabled:",true,"BOOL"] 2012/05/14, 20:35:31 ["_aceruckweapons:",<null>,string] 2012/05/14, 20:35:31 ["_aceruckmagazines:",<null>,string] 2012/05/14, 20:35:31 "SERVER MSG: SQL output: [tsc=0,tpos=7984.17|2011.08|296.036,tdam=0,tdhe=0,tdbo=0,tdha=0,tdle=0,tdir=140.375,tsta=Crouch,tsid=WEST,tveh=,tsea=,tpid=727809,tna=[KH]Jman,tmid=33]" 2012/05/14, 20:35:31 "SERVER MSG: SQL output: [twea="SCAR_L_STD_EGLM_RCO"|"NVGoggles"|"Binocular_Vector"|"ItemMap"|"ItemCompass"|"ItemWatch"|"ItemRadio"|"ItemGPS",tmag="30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"IR_Strobe_Target"|"SmokeShellRed"|"HandGrenade_West"|"HandGrenade_West"|"1Rnd_HE_M203"|"1Rnd_HE_M203"|"1Rnd_HE_M203"|"1Rnd_HE_M203"|"1Rnd_Smoke_M203"|"1Rnd_Smoke_M203"|"1Rnd_SmokeRed_M203"|"1Rnd_SmokeRed_M203",tpid=727809,tna=[KH]Jman,tmid=33]" 2012/05/14, 20:35:31 "SERVER MSG: SQL output: [tawb=,taw=,tarm=,tpid=727809,tna=[KH]Jman,tmid=33]" 2012/05/14, 20:35:32 "SERVER MSG: Player __SERVER__, is leaving the server, frame Number: 17975, Tick: 383.101, Time: 64.864" 2012/05/14, 20:35:32 "SERVER MSG: SQL output: [tda=2011|6|7|6|2,tmid=33]" 2012/05/14, 20:35:32 "SERVER MSG: __SERVER__ exiting, frame Number: 17975, Tick: 383.105, Time: 64.864" Arma2NET log: 05/14/2012 20:34:23 Arma2Net.Managed.Bridge INFO 05/14/2012 20:34:23 Arma2Net.Managed.Bridge INFO Arma2NET 1.8.0.0 (Developer mode: True), CLR 4.0.30319.1 05/14/2012 20:34:23 Arma2Net.Managed.AddIns.AddInManager INFO Rebuilding addins 05/14/2012 20:34:24 Arma2Net.Managed.AddIns.AddInManager INFO Finding addins 05/14/2012 20:34:24 Arma2Net.Managed.AddIns.AddInManager INFO Activated Activate from BaseFunctionsPlugin.Activate, BaseFunctionsPlugin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e (Sandboxed: False) 05/14/2012 20:34:24 Arma2Net.Managed.AddIns.AddInManager INFO Activated IsFunction from BaseFunctionsPlugin.IsFunction, BaseFunctionsPlugin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e (Sandboxed: False) 05/14/2012 20:34:24 Arma2Net.Managed.AddIns.AddInManager INFO Activated Deactivate from BaseFunctionsPlugin.Deactivate, BaseFunctionsPlugin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e (Sandboxed: False) 05/14/2012 20:34:24 Arma2Net.Managed.AddIns.AddInManager INFO Activated _Empty from BaseFunctionsPlugin._Empty, BaseFunctionsPlugin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e (Sandboxed: False) 05/14/2012 20:34:24 Arma2Net.Managed.AddIns.AddInManager INFO Activated VersionOfAddIn from BaseFunctionsPlugin.VersionOfAddIn, BaseFunctionsPlugin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e (Sandboxed: False) 05/14/2012 20:34:24 Arma2Net.Managed.AddIns.AddInManager INFO Activated CompareVersion from BaseFunctionsPlugin.CompareVersion, BaseFunctionsPlugin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e (Sandboxed: False) 05/14/2012 20:34:24 Arma2Net.Managed.AddIns.AddInManager INFO Activated ClrVersion from BaseFunctionsPlugin.ClrVersion, BaseFunctionsPlugin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e (Sandboxed: False) 05/14/2012 20:34:24 Arma2Net.Managed.AddIns.AddInManager INFO Activated Version from BaseFunctionsPlugin.Arma2NetVersion, BaseFunctionsPlugin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e (Sandboxed: False) 05/14/2012 20:34:24 Arma2Net.Managed.AddIns.AddInManager INFO Activated Functions from BaseFunctionsPlugin.Functions, BaseFunctionsPlugin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e (Sandboxed: False) 05/14/2012 20:34:24 Arma2Net.Managed.AddIns.AddInManager INFO Activated CommandLine from CommandLinePlugin.CommandLine, CommandLinePlugin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e (Sandboxed: False) 05/14/2012 20:34:24 Arma2Net.Managed.AddIns.AddInManager INFO Activated DateTime from DateTimePlugin.DateTime, DateTimePlugin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e (Sandboxed: False) 05/14/2012 20:34:24 Arma2Net.Managed.AddIns.AddInManager INFO Activated GetWeather from WeatherPlugin.Weather, WeatherPlugin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e (Sandboxed: False) 05/14/2012 20:34:24 Arma2Net.Managed.AddIns.AddInManager INFO Activated Dict from UtilitiesPlugin.DictionaryUtility, UtilitiesPlugin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e (Sandboxed: False) 05/14/2012 20:34:24 Arma2Net.Managed.AddIns.AddInManager INFO Activated Str from UtilitiesPlugin.StringUtility, UtilitiesPlugin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=8762987cc8e6095e (Sandboxed: False) 05/14/2012 20:34:24 Arma2Net.Managed.Bridge INFO Initialized 05/14/2012 20:34:24 Arma2Net.Managed.AddIns.AddInManager INFO Activated Arma2NETMySQL from Arma2NETMySQLPlugin.Arma2NETMySQLPlugin, Arma2NETMySQLPlugin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null (Sandboxed: False) Clientside RPT: ===================================================================== == C:\Program Files\Bohemia Interactive\ArmA 2\Expansion\beta\arma2oa.exe == "C:\Program Files\Bohemia Interactive\ArmA 2\Expansion\beta\arma2oa.exe" -nosplash -showscripterrors -skipintro "-cpucount=4" "-exthreads=7" "-world=empty" "-name=[KH]Jman" "-mod=expansion\beta;expansion\beta\expansion;@CBA;@CBA_A2;@CBA_OA" ===================================================================== Exe timestamp: 2012/05/11 17:39:14 Current time: 2012/05/14 20:36:26 Version 1.60.92612 [8929,133.167,0,"XEH: PreInit Started. v1.0.0.179. MISSINIT: missionName=Co18_PDB_ConvoyHell_v1-5-100, worldName=Takistan, isMultiplayer=true, isServer=false, isDedicated=false"] [8929,134.263,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"] [9379,144.161,0,"XEH: PostInit Started"] [9379,144.2,0,"CBA_VERSIONING: cba=1.0.0.182, cba_a2=1.0.0.8, cba_oa=1.0.0.6, "] [9379,144.434,0,"XEH: PostInit Finished. State: _isClient=true, _isJip=false, _isDedClient=true, _isServer=false, _isDedServer=false, _playerCheckDone=true, _sp=false, _startInitDone=true, _postInitDone=true, _mpRespawn=true, _machineType=2, _sessionId=1, _level=0, _timeOut=false, _game=1, BIS_functions=L 1-1-B:1 REMOTE, group=L 1-1-B, player=S1, _playerType="US_Soldier_TL_EP1", _playerGroup=B 1-1-A"] [9379,144.435,0,"CBA_VERSIONING_SERVER: cba=1.0.0.182, cba_a2=1.0.0.8, cba_oa=1.0.0.6, "] ["PersistentDB: pdb settings loaded"] "############################# Co18 PDB Convoy Hell #############################" ["PersistentDB: SPAWN"] ["PersistentDB: PDB_FNC_SERVER_LOADERSTATUS: ","Mission: Co18 PDB Convoy Hell"] ["PersistentDB: PDB_FNC_SERVER_LOADERSTATUS: ","Mission: Co18 PDB Convoy Hell not found..."] ["PersistentDB: FINISHED MISSION INIT, time: ",5.437] ["PersistentDB: PDB_FNC_SERVER_LOADERSTATUS: ","Mission: Co18 PDB Convoy Hell created an entry..."] ["PersistentDB: PDB_FNC_SERVER_LOADERSTATUS: ","Reading: Co18 PDB Convoy Hell..."] ["PersistentDB: PLAYER READY"] ["PersistentDB: PDB_FNC_CLIENT_LOADERSTATUS: ","Creating player entry in database..."] ["PersistentDB: PDB_FNC_CLIENT_LOADERSTATUS: ","Loading player global score..."] ["PersistentDB: PDB_FNC_CLIENT_LOADERSTATUS: ","Activating player: [KH]Jman ..."] ["PersistentDB: MISSIONDATE: ",[2011,6,7,6,1]] ["PersistentDB: ACTIVATE PLAYER"] ["PersistentDB: PLAYER READY: ","[KH]Jman"] ["PersistentDB: PLAYER CONNECTED"] ["PersistentDB: _seen: ",false,"BOOL"] ["PersistentDB: New player: ","[KH]Jman","STRING"] Note: You don't actually need cba clientside since all the cba calls are done by the server (unless of course you're running a mission with an addon that requires it clientside). Example clientside rpt without cba loaded (notice it has loaded my previous saved data) ===================================================================== == C:\Program Files\Bohemia Interactive\ArmA 2\Expansion\beta\arma2oa.exe == "C:\Program Files\Bohemia Interactive\ArmA 2\Expansion\beta\arma2oa.exe" -nosplash -showscripterrors -skipintro "-cpucount=4" "-exthreads=7" "-world=empty" "-name=[KH]Jman" "-mod=expansion\beta;expansion\beta\expansion" ===================================================================== Exe timestamp: 2012/05/11 17:39:14 Current time: 2012/05/14 21:00:03 Version 1.60.92612 ["PersistentDB: pdb settings loaded"] "############################# Co18 PDB Convoy Hell #############################" ["PersistentDB: SPAWN"] ["PersistentDB: PDB_FNC_SERVER_LOADERSTATUS: ","Mission: Co18 PDB Convoy Hell"] ["PersistentDB: PDB_FNC_SERVER_LOADERSTATUS: ","Reading: Co18 PDB Convoy Hell..."] ["PersistentDB: FINISHED MISSION INIT, time: ",3.161] ["PersistentDB: PLAYER READY"] ["PersistentDB: PDB_FNC_CLIENT_LOADERSTATUS: ","Loading player weapons..."] ["PersistentDB: _thispdamage:",-1,"SCALAR"] ["PersistentDB: _this_pdamage_head_hit:",-1,"SCALAR"] ["PersistentDB: _this_pdamage_body:",-1,"SCALAR"] ["PersistentDB: _this_pdamage_hands:",-1,"SCALAR"] ["PersistentDB: _this_pdamage_legs:",-1,"SCALAR"] ["PersistentDB: _thisPosition:",[7984.17,2011.08,296.036],"ARRAY"] ["PersistentDB: _thisweapons:",["SCAR_L_STD_EGLM_RCO","NVGoggles","Binocular_Vector","ItemMap","ItemCompass","ItemWatch","ItemRadio","ItemGPS"],"ARRAY"] ["PersistentDB: _thismagazines:",["30Rnd_556x45_Stanag","30Rnd_556x45_Stanag","30Rnd_556x45_Stanag","30Rnd_556x45_Stanag","30Rnd_556x45_Stanag","30Rnd_556x45_Stanag","30Rnd_556x45_Stanag","30Rnd_556x45_Stanag","IR_Strobe_Target","SmokeShellRed","HandGrenade_West","HandGrenade_West","1Rnd_HE_M203","1Rnd_HE_M203","1Rnd_HE_M203","1Rnd_HE_M203","1Rnd_Smoke_M203","1Rnd_Smoke_M203","1Rnd_SmokeRed_M203","1Rnd_SmokeRed_M203"],"ARRAY"] ["PersistentDB: _thispdirection:",140.375,"SCALAR"] ["PersistentDB: _thispstance:","Crouch","STRING"] ["PersistentDB: _thispside:","WEST","STRING"] ["PersistentDB: _thispvehicle:","","STRING"] ["PersistentDB: _thispseat:","","STRING"] ["PersistentDB: PDB_FNC_CLIENT_LOADERSTATUS: ","Loading player global score..."] ["PersistentDB: PDB_FNC_CLIENT_LOADERSTATUS: ","Activating player: [KH]Jman ..."] ["PersistentDB: MISSIONDATE: ",[2011,6,7,6,2]] ["PersistentDB: ACTIVATE PLAYER"] ["PersistentDB: PLAYER READY: ","[KH]Jman"] ["PersistentDB: PLAYER CONNECTED"] ["PersistentDB: _seen: ",true,"BOOL"] ["PersistentDB: Existing player: ","[KH]Jman","STRING"] ["PersistentDB: (teleportPlayer) _player:",S1,"OBJECT"] ["PersistentDB: (teleportPlayer) teleportToLocation:",1,"SCALAR"] And here is the related server RPT: ===================================================================== == E:\Programs\ArmA2\Expansion\beta\arma2oaserver.exe == E:\Programs\ArmA2\Expansion\beta\arma2oaserver.exe -arma2netdev -port=2302 -mod=expansion\beta;expansion\beta\expansion;E:\Programs\ArmA2\@CBA;E:\Programs\ArmA2\@CBA_A2;E:\Programs\ArmA2\@CBA_OA;@Arma2NET -name=Server-test -config=E:\Server-test\Server-test.cfg -cfg=E:\Server-test\Arma2-test.cfg -profiles=E:\Server-test ===================================================================== Exe timestamp: 2012/05/11 09:21:24 Current time: 2012/05/14 20:54:03 Version 1.60.92614 2012/05/14, 20:56:57 [77714,1667.84,0,"XEH: PreInit Started. v1.0.0.179. MISSINIT: missionName=Co18_PDB_ConvoyHell_v1-5-100, worldName=Takistan, isMultiplayer=true, isServer=true, isDedicated=true"] 2012/05/14, 20:56:57 [77714,1667.92,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"] 2012/05/14, 20:57:04 [77846,1674.75,0,"XEH: PostInit Started"] 2012/05/14, 20:57:04 [77846,1674.75,0,"CBA_VERSIONING: cba=1.0.0.182, cba_a2=1.0.0.8, cba_oa=1.0.0.6, "] 2012/05/14, 20:57:04 [77846,1675.21,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 1-1-B:1, group=L 1-1-B"] 2012/05/14, 20:57:05 ["PersistentDB: pdb settings loaded"] 2012/05/14, 20:57:05 "############################# Co18 PDB Convoy Hell #############################" 2012/05/14, 20:57:05 "--------------------------------" 2012/05/14, 20:57:05 "UPSMON started" 2012/05/14, 20:57:44 "SERVER MSG: count MISSIONDATA, 0" 2012/05/14, 20:57:44 ["setdate: _thisMissionDate: ",[2011,6,7,6,2]] 2012/05/14, 20:57:44 "SERVER MSG: Database mission id: 33" 2012/05/14, 20:57:44 "SERVER MSG: Database mission name selected: Co18 PDB Convoy Hell" 2012/05/14, 20:57:44 "SERVER MSG: Mission ID (SELECTED) is 33" 2012/05/14, 20:57:44 "SERVER MSG: Database mission date selected: [2011,6,7,6,2]" 2012/05/14, 20:57:48 ["PASS: _player: ",S1] 2012/05/14, 20:57:48 ["PASS: _puid: ","727809"] 2012/05/14, 20:57:48 ["PASS: _pname: ","[KH]Jman"] 2012/05/14, 20:57:48 ["PASS: _playerSide: ",WEST] 2012/05/14, 20:57:48 "SERVER MSG: Mission ID (ARRAY) is 33" 2012/05/14, 20:57:48 "SERVER MSG: Player connected [KH]Jman, puid 727809" 2012/05/14, 20:57:48 "SERVER MSG: Welcome back, [KH]Jman" 2012/05/14, 20:57:48 "SERVER MSG: Database player: [KH]Jman id: 562" 2012/05/14, 20:57:48 "SERVER MSG: Database player: [KH]Jman puid: 727809" 2012/05/14, 20:57:48 "SERVER MSG: Database player: [KH]Jman name: [KH]Jman" 2012/05/14, 20:57:48 "SERVER MSG: Database player: [KH]Jman score: 0" 2012/05/14, 20:57:48 "SERVER MSG: Database player: [KH]Jman mission id: 33" 2012/05/14, 20:57:48 "SERVER MSG: Database player: [KH]Jman weapons: ["SCAR_L_STD_EGLM_RCO","NVGoggles","Binocular_Vector","ItemMap","ItemCompass","ItemWatch","ItemRadio","ItemGPS"]" 2012/05/14, 20:57:48 "SERVER MSG: Database player: [KH]Jman magazines: ["30Rnd_556x45_Stanag","30Rnd_556x45_Stanag","30Rnd_556x45_Stanag","30Rnd_556x45_Stanag","30Rnd_556x45_Stanag","30Rnd_556x45_Stanag","30Rnd_556x45_Stanag","30Rnd_556x45_Stanag","IR_Strobe_Target","SmokeShellRed","HandGrenade_West","HandGrenade_West","1Rnd_HE_M203","1Rnd_HE_M203","1Rnd_HE_M203","1Rnd_HE_M203","1Rnd_Smoke_M203","1Rnd_Smoke_M203","1Rnd_SmokeRed_M203","1Rnd_SmokeRed_M203"]" 2012/05/14, 20:57:48 "SERVER MSG: Database player: [KH]Jman teleported to coords, [7984.17,2011.08,296.036]" 2012/05/14, 20:57:48 "SERVER MSG: Database player: [KH]Jman direction: 140.375" 2012/05/14, 20:57:48 "SERVER MSG: Database player: [KH]Jman stance: Crouch" 2012/05/14, 20:57:48 "SERVER MSG: Database player: [KH]Jman side: WEST" 2012/05/14, 20:57:48 "SERVER MSG: Adding score 1832 to [KH]Jman, playerObject, S1 puid, 727809" 2012/05/14, 20:57:49 ["PersistentDB: SERVER PV - PDB_ACTIVATEPLAYER: ",[s1,"[KH]Jman",true]] 2012/05/14, 20:57:49 ["PersistentDB: UPDATESCORES, time: ",4.941] 2012/05/14, 20:58:09 "SERVER MSG: Player [KH]Jman, is leaving the server, frame Number: 80758, Tick: 1739.65, Time: 24.759" 2012/05/14, 20:58:09 "SERVER MSG: Loop. 727809" 2012/05/14, 20:58:09 "SERVER MSG: Loop break. 727809" 2012/05/14, 20:58:09 ["_loadedPlayerScore: ",0,"SCALAR"] 2012/05/14, 20:58:09 ["_globalPlayerScore: ",1832,"SCALAR"] 2012/05/14, 20:58:09 ["_pscore: ",0,"SCALAR"] 2012/05/14, 20:58:09 ["player is kneeling"] 2012/05/14, 20:58:09 ["pdb_ace_enabled:",true,"BOOL"] 2012/05/14, 20:58:09 ["_aceruckweapons:",<null>,string] 2012/05/14, 20:58:09 ["_aceruckmagazines:",<null>,string] 2012/05/14, 20:58:09 "SERVER MSG: SQL output: [tsc=0,tpos=7984.31|2010.89|296.036,tdam=0,tdhe=0,tdbo=0,tdha=0,tdle=0,tdir=143.772,tsta=Crouch,tsid=WEST,tveh=,tsea=,tpid=727809,tna=[KH]Jman,tmid=33]" 2012/05/14, 20:58:09 "SERVER MSG: SQL output: [twea="SCAR_L_STD_EGLM_RCO"|"NVGoggles"|"Binocular_Vector"|"ItemMap"|"ItemCompass"|"ItemWatch"|"ItemRadio"|"ItemGPS",tmag="30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"IR_Strobe_Target"|"SmokeShellRed"|"HandGrenade_West"|"HandGrenade_West"|"1Rnd_HE_M203"|"1Rnd_HE_M203"|"1Rnd_HE_M203"|"1Rnd_HE_M203"|"1Rnd_Smoke_M203"|"1Rnd_Smoke_M203"|"1Rnd_SmokeRed_M203"|"1Rnd_SmokeRed_M203",tpid=727809,tna=[KH]Jman,tmid=33]" 2012/05/14, 20:58:09 "SERVER MSG: SQL output: [tawb=,taw=,tarm=,tpid=727809,tna=[KH]Jman,tmid=33]" 2012/05/14, 20:58:10 "SERVER MSG: Player __SERVER__, is leaving the server, frame Number: 80805, Tick: 1741.12, Time: 26.225" 2012/05/14, 20:58:10 "SERVER MSG: SQL output: [tda=2011|6|7|6|2,tmid=33]" 2012/05/14, 20:58:10 "SERVER MSG: __SERVER__ exiting, frame Number: 80805, Tick: 1741.13, Time: 26.225"

"C:\Program Files\Bohemia Interactive\ArmA 2\Expansion\beta\arma2oa.exe" -beta=Expansion\beta;Expansion\beta\Expansion -server -config=Server.cfg -mod=@CBA;@Arma2NET -arma2netdev You're not running the arma2oaserver.exe now. -beta=Expansion\beta;Expansion\beta\Expansion is not a valid switch. You need all 3 cba's. Re-read my previous example here

Same error as in the dll error? Did you check the Arma2NET log? What is in the log. If it's the "File mpmissions\__cur_mp.Chernarus\persistentDB\initPlayerConnection.sqf, line 46" error then I'd suggest you're still not running the beta 64 bit should make no difference. Plz PM me your demo your mission. ---------- Post added at 23:55 ---------- Previous post was at 22:18 ---------- I have created and tested a new non-ace demo mission. You will find it in the example mpmission\NON ACE folder in the PersistentDB.7z file Re-download here The git repo has also been updated here

I'll knock one up asap. It's pretty easy to do, just take any vanilla MP mission and drop the scripts from the 'mission scripts' folder in it. Make sure you turn off ACE support in the pdbSetup.sqf file and edit pdb_fullmissionName, pdb_shortmissionName and pdb_author also.

Good work!

Download dll here Copy it to the server's C:\Windows\System32 directory

You're using Version 1.60.87548 You need beta version 87640 or later. You are not running the required beta. You are not running the required cba's You did not follow my instructions like you said you had ;) Your startup line should be something like: C:\Program Files\Bohemia Interactive\ArmA 2\Expansion\beta\arma2oaserver.exe -arma2netdev -config=Server.cfg -mod=expansion\beta;expansion\beta\expansion;@CBA;@CBA_A2;@CBA_OA;@Arma2NET

Demo is defo working now I've just tested it thoroughly on my dedicated. Are you defo sure that you are running the lastest beta on the server and Arma2NET is loaded with -arma2netdev switch. Please check the Arma2NET log file located on the server. On my server it is in: C:\Documents and Settings\Default User\Local Settings\Application Data\Arma2NET Look for the line: 05/13/2012 16:32:54 Arma2Net.Managed.Bridge INFO Initialized 05/13/2012 16:32:55 Arma2Net.Managed.AddIns.AddInManager INFO Activated Arma2NETMySQL from Arma2NETMySQLPlugin.Arma2NETMySQLPlugin, Arma2NETMySQLPlugin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null (Sandboxed: False)

Looking into it... ---------- Post added at 15:57 ---------- Previous post was at 14:36 ---------- Ok my fault. Apologies. New version is up with bug fixes. Re-download PersistentDB.7z here git changelog here Basically, the new files to replace are: example mpmission/Co30_ACE_KH_PDB_Batfields_2_12.Chernarus.pbo example mpmission/Co30_ACE_KH_PDB_Batfields_2_12.Chernarus/pdbSetup.sqf example mpmission/Co30_ACE_KH_PDB_Batfields_2_12.Chernarus/persistentDB/initPlayerConnection.sqf mission scripts/persistentDB/initPlayerConnection.sqf

Ace really has no bearing over whether PDB works or not. Can you be specific regarding the error that you are getting? The mysql server can be hosted elsewhere providing that you have setup the database.txt file accordingly and the correct 3306 port is open on the database server for traffic. Also may I suggest that you use that thread since this thread is pretty much defunct now since Arma2MySQL has now been superseded by Firefly's new Arma2NET addin.

Ok lets start at the beginning. 1. Download the following archive: http://www.kellys-heroes.eu/files/PersistentDB.7z 2. Install Arma2 beta version 87640 or later and Arma2NET and .NET Framework 4 Client Profile on your server. 3 Install MYSQL and MYSQL Connector on your server. 4. Copy the @Arma2NET folder from the archive to your servers @Arma2NET directory. This contains Firefly's Arma2NET addin for MYSQL. 5. Extract the .sql files from the dbschema directory, pick one that you feel most comfortable with using to create the database tables and stored procedures. 6. Extract the database.txt file and write your server's MYSQL connection settings into it and copy it to your server's Arma2 ROOT folder. 7. Copy the Co18_PDB_ConvoyHell_v1-5-100.Takistan.pbo from the archive's example mpmission/NON ACE folder to your server's MPMissions folder. 8. Create a launch bat file or whatever you use on your server and add the following (you need to do this since at present the addin is not signed) -arma2netdev and -mod=expansion\beta;expansion\beta\expansion;@CBA;@CBA_A2;@CBA_OA;@Arma2NET 9. Launch your server and connect to it with a client. The client does NOT need to run Arma2NET/CBA since all database calls are done by the server. 10. You do not need jayarma2lib on the server or client for this demo. You can turn PDB ACE support on/off by editing the pdbSetup.sqf: pdb_ace_enabled 11. The mission scripts folder in the archive contains the minimum you need to add to a vanilla MP Arma2 mission to make it PDB. 12. You can download updates from here but you'll need to register to access the git repository (you no longer need the Arma2MySQL folder in the repo since that is now legacy i.e old jayarmalib pipe connections) and you can ask questions regarding the demo here. 13. I've left out the www folder from the provided archive. You can grab it from the git archive it you want to. It's not required but contains the webbased php frontend to alter saved PDB data. I'm still developing it so it's pretty rough around the edges at the moment and does not support all features presently. You'll need to be PHP savvy to get it up and running. A tutorial will follow later in it's development. 14. I had an issue on my Windows server which was resolved here. 15. Copy the MySQL.Data.Dll to the ARMA2, ARMA2Net and Arma2NETMySQLPlugin (to cover all bases!)

- Added ability for player to select via dialog whether to teleport to last saved position when joining mission. - Updated example mission accordingly. - Minor improvements. View a screenshot of new dialog Dev-heaven Link

Yes it's working in MP.

PersistentDB is now using Arma2NET (callExtension) and firefly's Arma2NETMySQLPlugin Addin. The repository has been updated accordingly. https://dev-heaven.net/projects/a2-sql-persistent-db/repository

Issue resolved. The Windows Server box was missing a required MSVCR100.dll file from windows/system32 https://dev-heaven.net/issues/31028

I agree Scott but the fact remains that Arm2NET's dll does not seem to load on Windows dedicated server unless someone else can prove otherwise. From my testing, I'm afraid I'm out of ideas right now. Without serverside calls the usefulness becomes quite hadicapped imho. If you consider it as worthwhile overcoming as I do and would like you use our dedicated to run further test builds of your own please do contact me via pm Scott. To those that were vocal in requesting the dedicated test mission I posted, have to tried it yet and what are your results?