firemandave6024

Addon weapons blank in database

2 posts in this topic

Hello there! I have a strange issue and need some assistance. I've set up a dedicated server running Exile and a few addons (listed below in a spoiler, along with the rpt and database logs). It seems that any item that isn't base ARMA or Exile isn't being saved properly in the database; the entries are being made, but they are blank, like this: 

[["",1]]

When the user logs back in, there is an item in their backpack, but it's just an empty slot. I've read that Exile Occupation can cause issues like this, but removing the addon did not resolve the problem. Here's the RPT starting at the last restart:

Spoiler

 9:07:02 Successfull attempt to execute serverCommand '#lock' by server.
 9:12:09 Successfull attempt to execute serverCommand '#restartserver' by server.
 9:12:09 Successfull attempt to execute serverCommand '#unlock' by server.
 9:12:12
 9:13:12 Dedicated host created.
 9:13:34 Host identity created.
 9:13:34 Game Port: 2302, Steam Query Port: 2303
Arma 3 Console version 1.80.143869 x86 : port 2302
 9:13:34 Mission Exile.Altis read from bank.
 9:13:34 Roles assigned.
 9:13:34 Reading mission ...
 9:13:47 Mission read.
 9:13:48 Successfull attempt to execute serverCommand '#exec users' by server.
 9:13:48 Successfull attempt to execute serverCommand '#exec users' by server.
 9:13:48 Game started.
12:49:57 Assassin Dash uses modified data file
12:49:57 Player Assassin Dash connecting.
12:50:04 Player Assassin Dash connected (id=76561198038219556).
15:07:34 Player Assassin Dash disconnected.
15:08:16 Successfull attempt to execute serverCommand '#lock' by server.
15:13:21 Successfull attempt to execute serverCommand '#restartserver' by server.
15:13:21 Successfull attempt to execute serverCommand '#unlock' by server.
15:13:25
15:14:12 Dedicated host created.
15:14:31 Host identity created.
15:14:31 Game Port: 2302, Steam Query Port: 2303
Arma 3 Console version 1.80.143869 x86 : port 2302
15:14:31 Mission Exile.Altis read from bank.
15:14:31 Roles assigned.
15:14:32 Reading mission ...
15:14:44 Mission read.
15:14:45 Successfull attempt to execute serverCommand '#exec users' by server.
15:14:45 Successfull attempt to execute serverCommand '#exec users' by server.
15:14:45 Game started.

 

Logs from the player who purchased the weapon and lost it after a relog (it's not giving me the particular entry to troubleshoot [or I'm blind and don't see it]):

Spoiler

4:21:22 Ref to nonnetwork object 2cc31cd0c80# 1815520: ig_guerrilla2_1.p3d
 4:21:22 "ExileClient - Downloading character..."
 4:21:23 Warning Message: Embedded skeleton Weapon in 'a3\weapons_f\data\zaslehsdl_proxy.p3d' has different [ bones count ] in different p3d files. Skeleton/model 'exile_assets\model\exile_melee_axe.p3d' will probably not work correctly.
 4:21:23 Warning Message: No entry 'bin\config.bin/CfgWeapons.'.
 4:21:23 Warning Message: No entry '.scope'.
 4:21:23 Warning Message: '/' is not a value
 4:21:23 Warning Message: Error: creating weapon  with scope=private
 4:21:23 Warning Message: No entry '.displayName'.
 4:21:23 Warning Message: '/' is not a value
 4:21:23 Warning Message: No entry '.nameSound'.
 4:21:23 Warning Message: '/' is not a value
 4:21:23 Warning Message: No entry '.type'.
 4:21:23 Warning Message: '/' is not a value
 4:21:23 Warning Message: No entry '.picture'.
 4:21:23 Warning Message: '/' is not a value
 4:21:23 Warning Message: No entry '.Library'.
 4:21:23 Warning Message: No entry '.libTextDesc'.
 4:21:23 Warning Message: '/' is not a value
 4:21:23 Warning Message: No entry '.model'.
 4:21:23 Warning Message: '/' is not a value
 4:21:23 Warning Message: No entry '.simulation'.
 4:21:23 Warning Message: '/' is not a value
 4:21:23 Warning Message: No entry '.fireLightDuration'.
 4:21:23 Warning Message: '/' is not a value
 4:21:23 Warning Message: No entry '.fireLightIntensity'.
 4:21:23 Warning Message: '/' is not a value
 4:21:23 Warning Message: No entry '.fireLightDiffuse'.
 4:21:23 Warning Message: Size: '/' not an array
 4:21:23 Warning Message: Size: '/' not an array
 4:21:23 Warning Message: No entry '.fireLightAmbient'.
 4:21:23 Warning Message: Size: '/' not an array
 4:21:23 Warning Message: Size: '/' not an array
 4:21:23 Warning Message: No entry '.weaponLockDelay'.
 4:21:23 Warning Message: '/' is not a value
 4:21:23 Warning Message: No entry '.weaponLockSystem'.
 4:21:23 Warning Message: '/' is not a value
 4:21:23 Warning Message: No entry '.cmImmunity'.
 4:21:23 Warning Message: '/' is not a value
 4:21:23 Warning Message: No entry '.weight'.
 4:21:23 Warning Message: '/' is not a value
 4:21:23 Warning Message: No entry '.lockingTargetSound'.
 4:21:23 Warning Message: Size: '/' not an array
 4:21:23 Warning Message: No entry '.lockedTargetSound'.
 4:21:23 Warning Message: Size: '/' not an array
 4:21:23 Warning Message: No entry '.detectRange'.
 4:21:23 Warning Message: '/' is not a value
 4:21:23 Warning Message: No entry '.muzzles'.
 4:21:23 Warning Message: Size: '/' not an array
 4:21:24 "ExileClient - Job with handle 10010 added."

 

Trader logs:

Spoiler

[03:15:46 --5:00] [Thread 12531] PLAYER: ( 76561198065893072 ) R The Goon Squad:1 (Falcon X) REMOTE SOLD ITEM optic_Nightstalker FOR 12500 POPTABS AND 1250 RESPECT | PLAYER TOTAL MONEY: 12500
[03:15:47 --5:00] [Thread 12531] PLAYER: ( 76561198065893072 ) R The Goon Squad:1 (Falcon X) REMOTE SOLD ITEM bipod_02_F_blk FOR 500 POPTABS AND 50 RESPECT | PLAYER TOTAL MONEY: 13000
[03:15:49 --5:00] [Thread 12531] PLAYER: ( 76561198065893072 ) R The Goon Squad:1 (Falcon X) REMOTE SOLD ITEM srifle_DMR_02_F FOR 4000 POPTABS AND 400 RESPECT | PLAYER TOTAL MONEY: 17000
[03:16:24 --5:00] [Thread 12531] PLAYER: ( 76561198065893072 ) R The Goon Squad:1 (Falcon X) REMOTE PURCHASED ITEM hlc_rifle_augpara_b FOR 15000 POPTABS | PLAYER TOTAL MONEY: 2000
[03:38:22 --5:00] [Thread 12528] PLAYER: ( 76561198038219556 ) R The Goon Squad:3 (Assassin Dash) REMOTE SOLD ITEM: Exile_Car_Hunter (ID# 214) with Cargo [] FOR 75000 POPTABS AND 7500 RESPECT | PLAYER TOTAL MONEY: 75000
[03:39:00 --5:00] [Thread 12528] PLAYER: ( 76561198038219556 ) R The Goon Squad:3 (Assassin Dash) REMOTE PURCHASED ITEM hlc_rifle_m14sopmod FOR 30000 POPTABS | PLAYER TOTAL MONEY: 45000
[03:39:26 --5:00] [Thread 12531] PLAYER: ( 76561198038219556 ) R The Goon Squad:3 (Assassin Dash) REMOTE SOLD ITEM hlc_rifle_m14sopmod FOR 15000 POPTABS AND 1500 RESPECT | PLAYER TOTAL MONEY: 60000
[04:11:52 --5:00] [Thread 12530] PLAYER: ( 76561198038219556 ) R The Goon Squad:4 (Assassin Dash) REMOTE PURCHASED ITEM hlc_rifle_honeybadger FOR 20000 POPTABS | PLAYER TOTAL MONEY: 25000
[13:10:32 --5:00] [Thread 4772] PLAYER: ( 76561198038219556 ) R The Goon Squad:1 (Assassin Dash) REMOTE SOLD ITEM: Exile_Car_Lada_Green (ID# 220) with Cargo ["Exile_Item_MacasCheese","Exile_Magazine_30Rnd_762x39_AK","Exile_Magazine_30Rnd_762x39_AK","30Rnd_556x45_Stanag","30Rnd_556x45_Stanag","Exile_Magazine_30Rnd_762x39_AK","Exile_Magazine_30Rnd_762x39_AK","Exile_Weapon_AKS_Gold"] FOR 17900 POPTABS AND 1790 RESPECT | PLAYER TOTAL MONEY: 43300
[13:10:59 --5:00] [Thread 4770] PLAYER: ( 76561198038219556 ) R The Goon Squad:1 (Assassin Dash) REMOTE SOLD ITEM optic_Holosight FOR 1000 POPTABS AND 100 RESPECT | PLAYER TOTAL MONEY: 44300
[14:28:47 --5:00] [Thread 4772] PLAYER: ( 76561198038219556 ) R Alpha 2-1:1 (Assassin Dash) REMOTE SOLD ITEM: Exile_Car_UAZ_Open_Green (ID# <null>) with Cargo ["Exile_Weapon_AKS_Gold","Exile_Magazine_30Rnd_762x39_AK"] FOR 20000 POPTABS AND 2000 RESPECT | PLAYER TOTAL MONEY: 20250
[14:30:57 --5:00] [Thread 4770] PLAYER: ( 76561198038219556 ) R Alpha 2-1:1 (Assassin Dash) REMOTE SOLD ITEM: Exile_Car_Tempest (ID# 221) with Cargo ["30Rnd_65x39_caseless_green","30Rnd_65x39_caseless_green","30Rnd_65x39_caseless_green","30Rnd_65x39_caseless_green","30Rnd_65x39_caseless_green","30Rnd_65x39_caseless_green","6Rnd_45ACP_Cylinder","6Rnd_45ACP_Cylinder"] FOR 40700 POPTABS AND 4070 RESPECT | PLAYER TOTAL MONEY: 60950
[14:32:14 --5:00] [Thread 4774] PLAYER: ( 76561198038219556 ) R Alpha 2-1:1 (Assassin Dash) REMOTE SOLD ITEM V_PlateCarrierSpec_mtp FOR 4000 POPTABS AND 400 RESPECT | PLAYER TOTAL MONEY: 64950
[14:32:59 --5:00] [Thread 4770] PLAYER: ( 76561198038219556 ) R Alpha 2-1:1 (Assassin Dash) REMOTE PURCHASED ITEM V_PlateCarrier3_rgr FOR 7000 POPTABS | PLAYER TOTAL MONEY: 57950
[14:33:22 --5:00] [Thread 4772] PLAYER: ( 76561198038219556 ) R Alpha 2-1:1 (Assassin Dash) REMOTE SOLD ITEM U_B_GhillieSuit FOR 3000 POPTABS AND 300 RESPECT | PLAYER TOTAL MONEY: 60950
[14:34:12 --5:00] [Thread 4774] PLAYER: ( 76561198038219556 ) R Alpha 2-1:1 (Assassin Dash) REMOTE PURCHASED ITEM Exile_Uniform_Woodland FOR 4000 POPTABS | PLAYER TOTAL MONEY: 56950
[14:34:58 --5:00] [Thread 4773] PLAYER: ( 76561198038219556 ) R Alpha 2-1:1 (Assassin Dash) REMOTE PURCHASED ITEM NVGoggles_OPFOR FOR 10000 POPTABS | PLAYER TOTAL MONEY: 46950
[15:05:43 --5:00] [Thread 4771] PLAYER: ( 76561198038219556 ) R Alpha 1-6:1 (Assassin Dash) REMOTE SOLD ITEM: Exile_Car_SUV_Black (ID# <null>) with Cargo [] FOR 10000 POPTABS AND 1000 RESPECT | PLAYER TOTAL MONEY: 10125

 

Database initialization log:

Spoiler

extDB2: Version: 71
extDB2: https://github.com/Torndeco/extDB2
extDB2: Linux Version
Message: All development for extDB2 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB2 Development
Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 20/02/15


extDB2: Found extdb-conf.ini
extDB2: Detected 16 Cores, Setting up 6 Worker Threads


[15:14:44 --5:00] [Thread 28303] extDB2: Database Type: MySQL
[15:14:44 --5:00] [Thread 28303] extDB2: Database Session Pool Started
[15:14:44 --5:00] [Thread 28303] extDB2: SQL_CUSTOM_V2: Loading Template Filename: /home/steam/arma3/@ExileServer/extDB/sql_custom_v2/exile.ini
[15:14:44 --5:00] [Thread 28303] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available

 

My launch command:

./arma3server -cfg=@ExileServer/basic.cfg -config=@ExileServer/config.cfg -autoinit -servermod=@ExileServer\;@AdvancedTowing\;@CJTF_IRnoHelmA3\; -mod=@Exile\;@CBA_A3\;@ryanzombies\;@Extended_Base_Mod\;@EnhancedMovement\;@NIArsenal\; >> serverlog.rpt

My server environment:

Spoiler

NAME="Ubuntu"
VERSION="16.04.3 LTS (Xenial Xerus)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 16.04.3 LTS"
VERSION_ID="16.04"
HOME_URL="http://www.ubuntu.com/"
SUPPORT_URL="http://help.ubuntu.com/"
BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/"
VERSION_CODENAME=xenial
UBUNTU_CODENAME=xenial

mysql -u root -p -e'SHOW VARIABLES LIKE "%version%";'
Enter password:
+-------------------------+-------------------------+
| Variable_name           | Value                   |
+-------------------------+-------------------------+
| innodb_version          | 5.7.21                  |
| protocol_version        | 10                      |
| slave_type_conversions  |                         |
| tls_version             | TLSv1,TLSv1.1           |
| version                 | 5.7.21-0ubuntu0.16.04.1 |
| version_comment         | (Ubuntu)                |
| version_compile_machine | x86_64                  |
| version_compile_os      | Linux                   |
+-------------------------+-------------------------+

The player table description:


mysql -u root -p -e'USE exile; DESCRIBE player;'
Enter password:
+------------------------+------------------+------+-----+-------------------+-----------------------------+
| Field                  | Type             | Null | Key | Default           | Extra                       |
+------------------------+------------------+------+-----+-------------------+-----------------------------+
| id                     | int(11) unsigned | NO   | PRI | NULL              | auto_increment              |
| name                   | varchar(64)      | NO   |     | NULL              |                             |
| account_uid            | varchar(32)      | NO   | MUL | NULL              |                             |
| money                  | int(11) unsigned | NO   |     | 0                 |                             |
| damage                 | double unsigned  | NO   |     | 0                 |                             |
| hunger                 | double unsigned  | NO   |     | 100               |                             |
| thirst                 | double unsigned  | NO   |     | 100               |                             |
| alcohol                | double unsigned  | NO   |     | 0                 |                             |
| temperature            | double           | NO   |     | 37                |                             |
| wetness                | double unsigned  | NO   |     | 0                 |                             |
| oxygen_remaining       | double unsigned  | NO   |     | 1                 |                             |
| bleeding_remaining     | double unsigned  | NO   |     | 0                 |                             |
| hitpoints              | varchar(1024)    | NO   |     | []                |                             |
| direction              | double           | NO   |     | 0                 |                             |
| position_x             | double           | NO   |     | 0                 |                             |
| position_y             | double           | NO   |     | 0                 |                             |
| position_z             | double           | NO   |     | 0                 |                             |
| spawned_at             | datetime         | NO   |     | CURRENT_TIMESTAMP |                             |
| assigned_items         | text             | NO   |     | NULL              |                             |
| backpack               | varchar(64)      | NO   |     | NULL              |                             |
| backpack_items         | text             | NO   |     | NULL              |                             |
| backpack_magazines     | text             | NO   |     | NULL              |                             |
| backpack_weapons       | text             | NO   |     | NULL              |                             |
| current_weapon         | varchar(64)      | NO   |     | NULL              |                             |
| goggles                | varchar(64)      | NO   |     | NULL              |                             |
| handgun_items          | text             | NO   |     | NULL              |                             |
| handgun_weapon         | varchar(64)      | NO   |     | NULL              |                             |
| headgear               | varchar(64)      | NO   |     | NULL              |                             |
| binocular              | varchar(64)      | NO   |     | NULL              |                             |
| loaded_magazines       | text             | NO   |     | NULL              |                             |
| primary_weapon         | varchar(64)      | NO   |     | NULL              |                             |
| primary_weapon_items   | text             | NO   |     | NULL              |                             |
| secondary_weapon       | varchar(64)      | NO   |     | NULL              |                             |
| secondary_weapon_items | text             | NO   |     | NULL              |                             |
| uniform                | varchar(64)      | NO   |     | NULL              |                             |
| uniform_items          | text             | NO   |     | NULL              |                             |
| uniform_magazines      | text             | NO   |     | NULL              |                             |
| uniform_weapons        | text             | NO   |     | NULL              |                             |
| vest                   | varchar(64)      | NO   |     | NULL              |                             |
| vest_items             | text             | NO   |     | NULL              |                             |
| vest_magazines         | text             | NO   |     | NULL              |                             |
| vest_weapons           | text             | NO   |     | NULL              |                             |
| last_updated_at        | datetime         | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+------------------------+------------------+------+-----+-------------------+-----------------------------+

 

The arma3 binary is running as a non-privileged user, and the database user has all of the appropriate permissions to read and write the exile database. I am absolutely stumped as to why addon weapons aren't saved properly. I must be missing something simple, considering all of the code I've looked at over the last 3 weeks setting this up, adding the weapons to the vendors, etc. Halp me, Obi-Wan, you're my only hope.

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.