multiple servers EXTDB

  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

multiple servers EXTDB

« posted: May 11, 2015, 12:50 PM »
If I wanted to open a second server could I link the databases or run off the same database?

Example:
Player joins server #1 leaves the server @8:00am with $25,000 and gear.

Then

Player notices server #1 is full @ 10:00am then joins server #2 with the $25,000 and gear from server #1.

Do I have to take any other steps other than just extdb config to the same database?

Does this cause performance issues?

How does object saving work in this instance?
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!
  • Offline LouD
  • Silent but deadly ;)
  • Moderator
  • Veteran
  • ******
  • Posts: 1415

Re: multiple servers EXTDB

« Reply #1 posted: May 11, 2015, 02:14 PM »
If you set this to 2 and your extdb-conf is the same as server one you will have a hive.
https://github.com/A3Wasteland/Release_Files/blob/master/A3Wasteland_settings/main_config.sqf#L63
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: multiple servers EXTDB

« Reply #2 posted: May 11, 2015, 02:16 PM »
Thanks loud
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!
  • Offline LouD
  • Silent but deadly ;)
  • Moderator
  • Veteran
  • ******
  • Posts: 1415

Re: multiple servers EXTDB

« Reply #3 posted: May 11, 2015, 02:37 PM »
Objects and vehicles are obviously not the same on both servers. Player info and data is.
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: multiple servers EXTDB

« Reply #4 posted: May 11, 2015, 06:23 PM »
Objects and vehicles are obviously not the same on both servers. Player info and data is.

Derp moment :p

Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: multiple servers EXTDB

« Reply #5 posted: May 19, 2015, 09:35 AM »
I have done this and I am having issues with EXTB now

Code: [Select]
2:19:28 "[extDB] ### Database error! [0,"Database Exception Error"]"
 2:19:28 "[extDB] ### ERROR - Startup aborted"
 2:19:28 "[INFO] A3W playerSaving = ON"
 2:19:28 "[INFO] A3W baseSaving = ON"
 2:19:28 "[INFO] A3W vehicleSaving = ON"
 2:19:28 "[INFO] A3W boxSaving = ON"
 2:19:28 "[INFO] A3W staticWeaponSaving = OFF"
 2:19:28 "[INFO] A3W warchestSaving = ON"
 2:19:28 "[INFO] A3W warchestMoneySaving = ON"
 2:19:28 "[INFO] A3W spawnBeaconSaving = OFF"
 2:19:28 Error in expression <eleteExpiredServerObjects:%1:%2:%3:%4", call A3W_extDB_ServerID, call A3W_extDB_>
 2:19:28   Error position: <call A3W_extDB_ServerID, call A3W_extDB_>
 2:19:28   Error call: Type Number, expected code
 2:19:28 File mpmissions\__cur_mp.stratis\persistence\server\world\extDB\getObjects.sqf, line 14
 2:19:30 "[INFO] A3W loot spawning is ENABLED"
 2:19:30 "WASTELAND SERVER - Initializing Server Spawning"
 2:19:31 "-- LOOTSPAWNER initialise ------------------------"
 2:19:31 "-- LOOTSPAWNER spawnBuilding_list ready, d: 0.0620003s"
 2:19:31 C_Heli_Light_01_civil_F: GunL_Revolving - unknown animation source GunL_Revolving
 2:19:31 C_Heli_Light_01_civil_F: GunR_Revolving - unknown animation source GunR_Revolving
 2:19:31 C_Heli_Light_01_civil_F: AddFLIR - unknown animation source AddFLIR
 2:19:31 C_Heli_Light_01_civil_F: AddGunHolder - unknown animation source AddGunHolder
 2:19:31 C_Heli_Light_01_civil_F: hidePG_1 - unknown animation source Missiles_revolving
 2:19:31 C_Heli_Light_01_civil_F: zaslehROT - unknown animation source Muzzle_flash
 2:19:32 Duplicate weapon CMFlareLauncher detected for O_Heli_Light_02_unarmed_F
 2:19:32 Duplicate weapon CMFlareLauncher detected for O_Heli_Light_02_unarmed_F
 2:19:32 B_Heli_Light_01_F: AddDoors - unknown animation source AddDoors
 2:19:32 B_Heli_Light_01_F: GunL_Revolving - unknown animation source GunL_Revolving
 2:19:32 B_Heli_Light_01_F: GunR_Revolving - unknown animation source GunR_Revolving
 2:19:32 B_Heli_Light_01_F: AddFLIR - unknown animation source AddFLIR
 2:19:32 B_Heli_Light_01_F: AddGunHolder - unknown animation source AddGunHolder
 2:19:32 B_Heli_Light_01_F: hidePG_1 - unknown animation source Missiles_revolving
 2:19:32 B_Heli_Light_01_F: zaslehROT - unknown animation source Muzzle_flash
 2:19:33 Duplicate weapon CMFlareLauncher detected for O_Heli_Light_02_unarmed_F
 2:19:33 Duplicate weapon CMFlareLauncher detected for O_Heli_Light_02_unarmed_F
 2:19:34 Strange convex component57 in a3\structures_f\households\house_small03\i_house_small_03_v1_dam_f.p3d:geometryPhys
 2:19:34 "Creating territory capture trigger for 'TERRITORY_AGIA_NORTH'"
 2:19:34 "Creating territory capture trigger for 'TERRITORY_AGIA_SOUTH'"
 2:19:34 "Creating territory capture trigger for 'TERRITORY_AGIOS_CEPHAS'"
 2:19:34 "Creating territory capture trigger for 'TERRITORY_AGIOS_IOANNIS'"
 2:19:34 "Creating territory capture trigger for 'TERRITORY_AIRBASE_NORTH'"
 2:19:34 "Creating territory capture trigger for 'TERRITORY_AIRBASE_SOUTH'"
 2:19:34 "Creating territory capture trigger for 'TERRITORY_AIRSTATION_MIKE'"
 2:19:34 "Creating territory capture trigger for 'TERRITORY_CAMP_MAXWELL'"
 2:19:34 "Creating territory capture trigger for 'TERRITORY_CAMP_ROGAIN'"
 2:19:34 "Creating territory capture trigger for 'TERRITORY_CAMP_TEMPEST'"
 2:19:34 "Creating territory capture trigger for 'TERRITORY_GIRNA'"
 2:19:34 "Creating territory capture trigger for 'TERRITORY_JAY_COVE'"
 2:19:34 Duplicate weapon CMFlareLauncher detected for O_Heli_Light_02_unarmed_F
 2:19:34 "Creating territory capture trigger for 'TERRITORY_KAMINO_FIRING_RANGE'"
 2:19:34 "Creating territory capture trigger for 'TERRITORY_KAMINO_SETTLEMENT'"
 2:19:34 "Creating territory capture trigger for 'TERRITORY_KILL_FARM'"
 2:19:34 "Creating territory capture trigger for 'TERRITORY_LIMERI_BAY'"
 2:19:35 "Creating territory capture trigger for 'TERRITORY_LZ_BALDY'"
 2:19:35 "Creating territory capture trigger for 'TERRITORY_LZ_CONNOR'"
 2:19:35 "Creating territory capture trigger for 'TERRITORY_PYTHOS'"
 2:19:35 "Creating territory capture trigger for 'TERRITORY_RADIO_TOWERS'"
 2:19:35 Warning: Network server received wrong index from client (player role)
 2:19:35 Performance warning: SimpleSerialization::Write 'A3W_serverSetupComplete' is using type of ',CODE' which is not optimized by simple serialization, falling back to generic serialization, use generic type or ask for optimizations for these types
 2:19:35 Performance warning: SimpleSerialization::Read 'A3W_serverSetupComplete' is using type of ,'CODE' which is not optimized by simple serialization, falling back to generic serialization, use generic type or ask for optimizations for these types
 2:19:35 "-- LOOTSPAWNER Buildingpositions_list ready, d: 4.881s"
 2:19:36 "WASTELAND SERVER - 20 Static helis Spawned"
 2:19:36 No owner
 2:19:36 No owner
 2:19:37 No owner
 2:19:37 No owner
 2:19:37 No owner
 2:19:37 No owner
 2:19:37 No owner
 2:19:38 No owner
 2:19:38 No owner
 2:19:38 No owner
 2:19:38 No owner
 2:19:42 No owner
 2:19:42 No owner
 2:19:43 No owner
 2:19:43 No owner
 2:19:43 No owner
 2:19:44 No owner
 2:19:44 "-- LOOTSPAWNER LSusedclass_list ready, d: 8.358s"
 2:19:44 "-- LOOTSPAWNER LSDer started..."
 2:19:44 No owner
 2:19:46 No owner
 2:19:47 No owner
 2:19:48 No owner
 2:19:48 No owner
 2:19:48 No owner
 2:19:48 No owner
 2:19:49 Warning: Wrong data in squad.xml for Player[[FRAC] Mokey], Squad[http://armasquads.com/user/squads/xml/VENJkCGS4JPGNBuRKfS4dVTZSdjmPYwe/squad.xml]
 2:19:50 No owner
 2:19:50 No owner
 2:19:50 No owner
 2:19:51 No owner
 2:19:52 No owner
 2:19:52 No owner
 2:19:52 No owner
 2:19:52 No owner
 2:19:52 No owner
 2:19:54 No owner
 2:19:54 No owner
 2:19:55 No owner
 2:19:55 No owner
 2:19:56 No owner
 2:19:57 No owner
 2:19:59 No owner
 2:20:00 No owner
 2:20:00 "WASTELAND - Vehicle spawning completed - 77 town vehicles spawned in 24.123s"
 2:20:02 "WASTELAND SERVER - 0 Planes Spawned"
 2:20:02 No owner
 2:20:03 No owner
 2:20:03 No owner
 2:20:03 No owner
 2:20:03 No owner
 2:20:03 No owner
 2:20:04 "WASTELAND SERVER - 22 Boats Spawned"
 2:20:08 Warning: Wrong data in squad.xml for Player[[FRAC] Mokey], Squad[http://armasquads.com/user/squads/xml/VENJkCGS4JPGNBuRKfS4dVTZSdjmPYwe/squad.xml]
 2:20:10 "WASTELAND - Object spawning completed - 258 Objects Spawned on Altis"
 2:20:10 Performance warning: SimpleSerialization::Write 'A3W_serverSpawningComplete' is using type of ',CODE' which is not optimized by simple serialization, falling back to generic serialization, use generic type or ask for optimizations for these types
 2:20:10 "[INFO] A3W territory capturing is ENABLED"
 2:20:10 "WASTELAND SERVER - Initializing Missions"
 2:20:10 Performance warning: SimpleSerialization::Read 'A3W_serverSpawningComplete' is using type of ,'CODE' which is not optimized by simple serialization, falling back to generic serialization, use generic type or ask for optimizations for these types
 2:20:10 "WASTELAND SERVER - Started Main Mission Controller"
 2:20:11 "WASTELAND SERVER - Main Mission waiting to run: mission_Coastal_Convoy"
 2:20:11 Performance warning: SimpleSerialization::Write 'messageSystem' is using type of ',TEXT' which is not optimized by simple serialization, falling back to generic serialization, use generic type or ask for optimizations for these types
 2:20:11 Performance warning: SimpleSerialization::Read 'messageSystem' is using type of ,'TEXT' which is not optimized by simple serialization, falling back to generic serialization, use generic type or ask for optimizations for these types
 2:20:16 "WASTELAND SERVER - Started Money Mission Controller"
 2:20:16 "WASTELAND SERVER - Money Mission waiting to run: mission_MoneyShipment"
 2:20:16 Performance warning: SimpleSerialization::Write 'messageSystem' is using type of ',TEXT' which is not optimized by simple serialization, falling back to generic serialization, use generic type or ask for optimizations for these types
 2:20:16 Performance warning: SimpleSerialization::Read 'messageSystem' is using type of ,'TEXT' which is not optimized by simple serialization, falling back to generic serialization, use generic type or ask for optimizations for these types
 2:20:21 "TERRITORY SYSTEM: _realLoopTime was 10.104"
 2:20:21 "WASTELAND SERVER - Started Side Mission Controller"
 2:20:21 "WASTELAND SERVER - Side Mission waiting to run: mission_AirWreck"
 2:20:21 Performance warning: SimpleSerialization::Write 'messageSystem' is using type of ',TEXT' which is not optimized by simple serialization, falling back to generic serialization, use generic type or ask for optimizations for these types
 2:20:21 Performance warning: SimpleSerialization::Read 'messageSystem' is using type of ,'TEXT' which is not optimized by simple serialization, falling back to generic serialization, use generic type or ask for optimizations for these types
 2:20:26 "WASTELAND SERVER - Started Main Mission 2 Controller"
 2:20:26 "WASTELAND SERVER - Main Mission 2 waiting to run: mission_LightArmVeh"
 2:20:26 Performance warning: SimpleSerialization::Write 'messageSystem' is using type of ',TEXT' which is not optimized by simple serialization, falling back to generic serialization, use generic type or ask for optimizations for these types
 2:20:26 Performance warning: SimpleSerialization::Read 'messageSystem' is using type of ,'TEXT' which is not optimized by simple serialization, falling back to generic serialization, use generic type or ask for optimizations for these types
 2:20:31 "WASTELAND SERVER - Started Money Mission 2 Controller"
 2:20:31 "TERRITORY SYSTEM: _realLoopTime was 10.069"
 2:20:31 "WASTELAND SERVER - Money Mission 2 waiting to run: mission_SunkenTreasure"
 2:20:31 Performance warning: SimpleSerialization::Write 'messageSystem' is using type of ',TEXT' which is not optimized by simple serialization, falling back to generic serialization, use generic type or ask for optimizations for these types
 2:20:31 Performance warning: SimpleSerialization::Read 'messageSystem' is using type of ,'TEXT' which is not optimized by simple serialization, falling back to generic serialization, use generic type or ask for optimizations for these types
 2:20:41 "TERRITORY SYSTEM: _realLoopTime was 10.011"
 2:20:51 "TERRITORY SYSTEM: _realLoopTime was 10.033"
 2:21:01 "TERRITORY SYSTEM: _realLoopTime was 10.025"

I don't understand why...

Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!
  • Offline CREAMPIE
  • Armaholic
  • Veteran
  • ******
  • Posts: 1083
  • ^_^;;

Re: multiple servers EXTDB

« Reply #6 posted: Jun 08, 2015, 08:32 AM »
Thanks LouD

All 4 servers working off  the same DB now ;)

Just a quick question here - is there a way to restrict players from ghosting ? put in a 15 min delay on connecting to another server e.g ?

Cheers
CP out

- from the grassy knoll -

Re: multiple servers EXTDB

« Reply #7 posted: Jul 01, 2015, 11:51 PM »
May I also what the solution to this was, as it seems like a post is missing?

Code: [Select]
2015/07/01, 17:51:37 "[extDB] Startup..."
2015/07/01, 17:51:37 "[extDB] ### Database error! [0,"Database Exception Error"]"
2015/07/01, 17:51:37 "[extDB] ### ERROR - Startup aborted"
2015/07/01, 17:51:37 "[INFO] A3W playerSaving = ON"
2015/07/01, 17:51:37 "[INFO] A3W baseSaving = ON"
2015/07/01, 17:51:37 "[INFO] A3W vehicleSaving = ON"
2015/07/01, 17:51:37 "[INFO] A3W boxSaving = ON"
2015/07/01, 17:51:37 "[INFO] A3W staticWeaponSaving = ON"
2015/07/01, 17:51:37 "[INFO] A3W warchestSaving = ON"
2015/07/01, 17:51:37 "[INFO] A3W warchestMoneySaving = ON"
2015/07/01, 17:51:37 "[INFO] A3W spawnBeaconSaving = ON"
2015/07/01, 17:51:37 Error in expression <eleteExpiredServerObjects:%1:%2:%3:%4", call A3W_extDB_ServerID, call A3W_extDB_>
2015/07/01, 17:51:37   Error position: <call A3W_extDB_ServerID, call A3W_extDB_>
2015/07/01, 17:51:37   Error call: Type Number, expected code
2015/07/01, 17:51:37 File mpmissions\__cur_mp.Stratis\persistence\server\world\extDB\getObjects.sqf, line 14
2015/07/01, 17:51:37 "[INFO] A3W loot spawning is ENABLED"
  • Offline AgentRev
  • Developer
  • Veteran
  • ******
  • Posts: 2571

Re: multiple servers EXTDB

« Reply #8 posted: Jul 02, 2015, 12:58 AM »
Look at the extDB error log in extDB\logs\2015\7\01

Re: multiple servers EXTDB

« Reply #9 posted: Jul 02, 2015, 04:52 AM »
Look at the extDB error log in extDB\logs\2015\7\01

Thanks Rev - running great now :)
  • Offline LouD
  • Silent but deadly ;)
  • Moderator
  • Veteran
  • ******
  • Posts: 1415

Re: multiple servers EXTDB

« Reply #10 posted: Jul 06, 2015, 01:47 PM »
Thanks LouD

All 4 servers working off  the same DB now ;)

Just a quick question here - is there a way to restrict players from ghosting ? put in a 15 min delay on connecting to another server e.g ?

Cheers
CP out
Rev created an ati ghosting in 1.2 Beta