Search the Community

Showing results for tags 'extdb2'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Exile
    • Changelogs
    • Feedback
  • Exile Community
    • General Discussion
    • New Feature Voting
    • Problems & Bugs
    • Cat Walk
    • Recruitment
    • Small Talk
  • Exile Mod XM8 App
    • XM8 Server Administration
    • XM8 Android App
    • XM8 Discord Bot
  • Exile Mod Server Administration
    • Ask a Game Server Provider
    • Hosting
    • Operating Systems
    • Installation
    • Database
    • Security
    • Maintenance
  • Exile Mod Customization
    • Downloads & Releases
    • Content
    • Environment
    • Gameplay
    • Look & Feel
    • Tech Talk
  • Exile Life Mod
    • Visit forum on exilelifemod.com

Categories

  • Knowledge Base
  • Items
  • Constructions
  • Traders
  • Vehicles

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Homepage

Found 22 results

  1. SpaceWeed

    extDB2 could not be found

    Hello, I am trying to run a dedicated server on the same machine I game on. But now I ran into something, and I can't figure it out. I posted a pastebin with the lastest serverlog (rpt). And the second link is something interesting from the log. Link 1: Full log Link 2: Interesting part of the log. https://pastebin.com/2XSBMWLE https://pastebin.com/rZMUxe5Z EDIT: I forgot to tell my problem, lol. I can load into the server, but then I look into the grass. After some time, I get kicked. EDIT 2: I checked the folder in ExileServer. The extDB logs, the server said I should check there to see what went wrong. The problem is, there are no logs in there.
  2. HexicGaming

    cant load extdb2 but using extbd3

    After trying to add Exad and AVS to my server i encountered this launch parameters (my Mods)
  3. When i start the server it loads "normally" up until it gives me this error. however i am able to connect to the server but i am stuck in the ground and unable to hit esc to bring the menu up to respawn until the server eventually crashes.
  4. My server has really long restart times. From all of the other threads I've looked at, everyone suggests that it is related to the mods/addons/scripts being used, but I am convinced that it is related to the database, specifically the Constructions and Containers tables. I have a test server that is identical to my main server in terms of addons, extra scripts, etc. and that server can fully boot within 1-3min, but the main server still takes 10-15min. The only difference between the two is that the test server has a blank database. After reviewing the RPTs over several restarts, I've noticed that the main culprits seem to be the Construction and Container tables within the database. Families, Territories, Vehicles, and World Spawn Vehicles all take about 20-30sec each, but Constructions takes about 7min and Containers takes about 4-6min every restart. My territory size has a maximum construction limit of 300 pieces (which is less than other servers I've played on that boot quickly). The only thing that I can think of is maybe it's got something to do with loading non-Exile buildings from Extended Base Mod? Same for containers maybe? There are some giant cargo containers that hold about 5x more than Safes...but I wonder if having 5 Safes that are full would make any difference compared to 1 Cargo Container that is full...I don't really know too much about databases, so I was hoping someone can help me out. Any ideas on how to improve this? I'm also running the server on 32bit, do you think upgrading it to 64bit would improve this a lot? I feel like it might, but like I said there are plenty of other servers that seem more heavily modded and/or have bigger construction limits than mine and they've all been able to restart quickly on 32bit all this time...I just don't get it. I'll list the mods/addons below, but I'm still 90% sure it's related to the database, but maybe I'm wrong? Hopefully someone here knows a solution...
  5. I'm trying to continue the work done by airtonix etc in making a docker friendly exile setup. My new arma 3 docker image is working great, but when I wire up the volumes with exile files and connect, I spawn in the grass and no keybinds work, similar to this post . I suspect this is a DB issue, though I am able to connect from arma container to the mysql db container on the cli, and all of the tables are created, it seems that extDB2 is never initialized (no logs etc). I also turned off strict mode in mysql - see docker-compose.yml RPT - https://ghostbin.com/paste/zjz22 To replicate: this works to connect to the db from the server container, where db is the hostname of mysql container server_1 | 14:39:31 Player Blah connected (id=). server_1 | 14:39:31 BattlEye Server: Verified GUID () of player #0 blah server_1 | Unaccessible server_1 | 14:39:36 Server: Object 4:62 not found (message Type_121) server_1 | 14:39:36 Server: Object 4:51 not found (message Type_121) server_1 | 14:39:36 Server: Object 4:52 not found (message Type_121) server_1 | 14:39:36 Server: Object 4:53 not found (message Type_121) etc I did an `ldd extDB2.so` and all of the needed libs were loaded ok
  6. Demon95

    HElP

    5 times I created a clean server Exile(1.0.3) still this error, the server starts but when connecting says "connecting..." Version of ARMA 3 1.70 32 and 64 bit no difference
  7. HAND COCK

    Update 1.68 extDB2 not work ! on 64bit

    Can not load data from mysql.
  8. Hello, I'm turning nuts with the installation because i'm totally unable to connect to the DB !! I'm webdev so i don't forgot the basics (and it's fucking simple to connect to a DB), but I am using windows 10 and I usually work on Debian so maybe I'm wrong with some security settings. So: I've installed the A3 server from the Steam\Library\Tools installer I've created the DB and executed the .sql file I've set the @ExileServer\config.cfg hostname, password, passwordAdmin, serverCommandPassword values I've set the @ExileServer\extdb-conf.ini [Rcon]password, [exile]Name, [exile]Username, [exile]password values I've set the sql-mode="" in the my.ini file I've checked the local database connection with phpmyadmin and command line (I've tried with the user root and I've created another user) I've set arma3server.exe to be executed as admin I've authorized the arma3server.exe to do some modifications I've authorized the connections on the firewall (but the server is local, on the same machine) I've launched the server with this .bat: ::START SERVER echo Demarrage du Serveur ping 127.0.0.1 -n 2 >NUL G: cd "G:\Serveurs\A3 exile server\" cls echo Serveur Exile... Actif ! start "Arma3" /HIGH /min /wait arma3server.exe "-mod=@exile;kart;heli;mark;" "-servermod=@exileserver;" "-config=G:\Serveurs\A3 exile server\@ExileServer\config.cfg" -port=2302 "-profiles=SC" "-cfg=G:\Serveurs\A3 exile server\@ExileServer\basic.cfg" -name=SC -autoinit ping 127.0.0.1 -n 1 >NUL echo Le serveur Exile est arrete! cls And I continuously have this error: 11:48:42 "ExileServer - MySQL connection error!" 11:48:42 "ExileServer - Please have a look at @ExileServer/extDB/logs/ to find out what went wrong." 11:48:42 "ExileServer - MySQL Error: Unable to locate extDB2 extension!" The rep @ExileServer/extDB/logs/ doesn't exists, so I'm unable to see what happened. But why the server is unable to locate the extDB2.dll ? This really turn me nuts !! So, if you have any idea to fix this problem ? It's vanilla Exile 1.0.0 (with no mods).
  9. OhBenja

    extDB2 ERROR?

    [02:33:50:409592 +02:00] [Thread 2508] extDB2: Database Type: MySQL [02:33:50:415592 +02:00] [Thread 2508] extDB2: Database Session Pool Started [02:33:50:418592 +02:00] [Thread 2508] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Users\Benny\Desktop\Exile\steamapps\common\Arma 3 Server\@ExileServer\extDB\sql_custom_v2\exile.ini [02:33:50:418592 +02:00] [Thread 2508] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available [02:36:19:993148 +02:00] [Thread 2508] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: Field 'assigned_items' doesn't have a default value [mysql_stmt_errno]: 1364 [mysql_stmt_sqlstate]: HY000 [statemnt]: INSERT INTO player SET account_uid = ?, name = ? [02:36:19:993148 +02:00] [Thread 2508] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session [02:36:19:993148 +02:00] [Thread 2508] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:xxxxxxxxxxxxxxxxxx:Player name [02:49:25:095053 +02:00] [Thread 2508] extDB2: Stopping ... what is wrong? exile.ini [Default] Version = 12 Number of Inputs = 0 Sanitize Input Value Check = false Sanitize Output Value Check = false Prepared Statement Cache = true Return InsertID = false Strip = true Strip Chars Action = STRIP Strip Chars = \/\|;{}<>\' Strip Custom Chars = \/\|;{}<>\' ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Account related queries ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [isKnownAccount] SQL1_1 = SELECT CASE WHEN EXISTS(SELECT uid FROM account WHERE uid = ?) THEN 'true' ELSE 'false' END Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 [createAccount] SQL1_1 = INSERT INTO account SET uid = ?, name = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [startAccountSession] SQL1_1 = UPDATE account SET name = ?, last_connect_at = NOW(), total_connections = total_connections + 1 WHERE uid = ? Number Of Inputs = 2 SQL1_INPUTS = 2,1 [endAccountSession] SQL1_1 = UPDATE account SET last_disconnect_at = NOW() WHERE uid = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [getAccountStats] SQL1_1 = SELECT score, kills, deaths, clan_id, locker FROM account WHERE uid = ? Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2,3,4,5 [addAccountKill] SQL1_1 = UPDATE account SET kills = kills + 1 WHERE uid = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [addAccountDeath] SQL1_1 = UPDATE account SET deaths = deaths + 1 WHERE uid = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [getAccountScore] SQL1_1 = SELECT score FROM account WHERE uid = ? Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 [setAccountScore] SQL1_1 = UPDATE account SET score = ? WHERE uid = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [modifyAccountScore] SQL1_1 = UPDATE account SET score = score + ? WHERE uid = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [updateLocker] SQL1_1 = UPDATE account SET locker = ? WHERE uid = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [getLocker] SQL1_1 = SELECT locker FROM account WHERE uid = ? Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Player related queries ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [hasAlivePlayer] SQL1_1 = SELECT CASE WHEN EXISTS(SELECT account_uid FROM player WHERE account_uid = ? AND damage < 1) THEN 'true' ELSE 'false' END Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 [createPlayer] SQL1_1 = INSERT INTO player SET account_uid = ?, name = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 Return InsertID = true [insertPlayerHistory] SQL1_1 = INSERT INTO player_history SET account_uid = ?, name = ?, position_x = ?, position_y = ?, position_z = ? Number Of Inputs = 5 SQL1_INPUTS = 1,2,3,4,5 [deletePlayer] SQL1_1 = DELETE FROM player WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [loadPlayer] SQL1_1 = SELECT p.id, SQL1_2 = p.name, SQL1_3 = p.account_uid, SQL1_4 = p.damage, SQL1_5 = p.hunger, SQL1_6 = p.thirst, SQL1_7 = p.alcohol, SQL1_8 = p.oxygen_remaining, SQL1_9 = p.bleeding_remaining, SQL1_10 = p.hitpoints, SQL1_11 = p.direction, SQL1_12 = p.position_x, SQL1_13 = p.position_y, SQL1_14 = p.position_z, SQL1_15 = p.assigned_items, SQL1_16 = p.backpack, SQL1_17 = p.backpack_items, SQL1_18 = p.backpack_magazines, SQL1_19 = p.backpack_weapons, SQL1_20 = p.current_weapon, SQL1_21 = p.goggles, SQL1_22 = p.handgun_items, SQL1_23 = p.handgun_weapon, SQL1_24 = p.headgear, SQL1_25 = p.binocular, SQL1_26 = p.loaded_magazines, SQL1_27 = p.primary_weapon, SQL1_28 = p.primary_weapon_items, SQL1_29 = p.secondary_weapon, SQL1_30 = p.secondary_weapon_items, SQL1_31 = p.uniform, SQL1_32 = p.uniform_items, SQL1_33 = p.uniform_magazines, SQL1_34 = p.uniform_weapons, SQL1_35 = p.vest, SQL1_36 = p.vest_items, SQL1_37 = p.vest_magazines, SQL1_38 = p.vest_weapons, SQL1_39 = p.money, SQL1_40 = a.score, SQL1_41 = a.kills, SQL1_42 = a.deaths, SQL1_43 = c.id, SQL1_44 = c.name, SQL1_45 = p.temperature, SQL1_46 = p.wetness, SQL1_47 = a.locker SQL1_48 = FROM player p SQL1_49 = INNER JOIN account a SQL1_50 = ON a.uid = p.account_uid SQL1_51 = LEFT JOIN clan c SQL1_52 = ON c.id = a.clan_id SQL1_53 = WHERE p.account_uid = ? Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2-STRING,3-STRING,4,5,6,7,8,9,10,11,12,13,14,15,16-STRING,17,18,19,20-STRING,21-STRING,22,23-STRING,24-STRING,25-STRING,26,27-STRING,28,29-STRING,30,31-STRING,32,33,34,35-STRING,36,37,38,39,40,41,42,43,44-STRING,45,46,47 [updatePlayer] SQL1_1 = UPDATE player SET SQL1_2 = name = ?, SQL1_3 = damage = ?, SQL1_4 = hunger = ?, SQL1_5 = thirst = ?, SQL1_6 = alcohol = ?, SQL1_7 = oxygen_remaining = ?, SQL1_8 = bleeding_remaining = ?, SQL1_9 = hitpoints = ?, SQL1_10 = direction = ?, SQL1_11 = position_x = ?, SQL1_12 = position_y = ?, SQL1_13 = position_z = ?, SQL1_14 = assigned_items = ?, SQL1_15 = backpack = ?, SQL1_16 = backpack_items = ?, SQL1_17 = backpack_magazines = ?, SQL1_18 = backpack_weapons = ?, SQL1_19 = current_weapon = ?, SQL1_20 = goggles = ?, SQL1_21 = handgun_items = ?, SQL1_22 = handgun_weapon = ?, SQL1_23 = headgear = ?, SQL1_24 = binocular = ?, SQL1_25 = loaded_magazines = ?, SQL1_26 = primary_weapon = ?, SQL1_27 = primary_weapon_items = ?, SQL1_28 = secondary_weapon = ?, SQL1_29 = secondary_weapon_items = ?, SQL1_30 = uniform = ?, SQL1_31 = uniform_items = ?, SQL1_32 = uniform_magazines = ?, SQL1_33 = uniform_weapons = ?, SQL1_34 = vest = ?, SQL1_35 = vest_items = ?, SQL1_36 = vest_magazines = ?, SQL1_37 = vest_weapons = ?, SQL1_38 = temperature = ?, SQL1_39 = wetness = ? SQL1_40 = WHERE id = ? Number Of Inputs = 39 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Vehicle related queries ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [insertVehicle] SQL1_1 = INSERT INTO vehicle SET SQL1_2 = class = ?, SQL1_3 = account_uid = ?, SQL1_4 = is_locked = ?, SQL1_5 = position_x = ?, SQL1_6 = position_y = ?, SQL1_7 = position_z = ?, SQL1_8 = direction_x = ?, SQL1_9 = direction_y = ?, SQL1_10 = direction_z = ?, SQL1_11 = up_x = ?, SQL1_12 = up_y = ?, SQL1_13 = up_z = ?, SQL1_14 = pin_code = ? Number of Inputs = 13 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13 Return InsertID = true [deleteVehicle] SQL1_1 = DELETE FROM vehicle WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [loadVehicleIdPage] SQL1_1 = SELECT id FROM vehicle WHERE deleted_at IS NULL LIMIT ?,? Number Of Inputs = 2 SQL1_INPUTS = 1,2 OUTPUT = 1 [loadVehicle] SQL1_1 = SELECT id,class,spawned_at,account_uid,is_locked,fuel,damage,hitpoints,position_x,position_y,position_z,direction_x,direction_y,direction_z,up_x,up_y,up_z,cargo_items,cargo_magazines,cargo_weapons,pin_code,vehicle_texture,deleted_at,money FROM vehicle WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2-STRING,3-STRING,4-STRING,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21-STRING,22,23,24 [loadVehicleContainer] SQL1_1 = SELECT cargo_container FROM vehicle WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 [updateVehicle] SQL1_1 = UPDATE vehicle SET SQL1_2 = is_locked = ?, SQL1_3 = fuel = ?, SQL1_4 = damage = ?, SQL1_5 = hitpoints = ?, SQL1_6 = position_x = ?, SQL1_7 = position_y = ?, SQL1_8 = position_z = ?, SQL1_9 = direction_x = ?, SQL1_10 = direction_y = ?, SQL1_11 = direction_z = ?, SQL1_12 = up_x = ?, SQL1_13 = up_y = ?, SQL1_14 = up_z = ?, SQL1_15 = cargo_items = ?, SQL1_16 = cargo_magazines = ?, SQL1_17 = cargo_weapons = ?, SQL1_18 = cargo_container = ?, SQL1_19 = money = ? SQL1_20 = WHERE id = ? Number of Inputs = 19 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19 [updateVehicleSkin] SQL1_1 = UPDATE vehicle SET vehicle_texture = ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [vehicleSetPinCode] SQL1_1 = UPDATE vehicle SET pin_code = ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Construction related queries ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [insertConstruction] SQL1_1 = INSERT INTO construction SET SQL1_2 = class = ?, SQL1_3 = account_uid = ?, SQL1_4 = position_x = ?, SQL1_5 = position_y = ?, SQL1_6 = position_z = ?, SQL1_7 = direction_x = ?, SQL1_8 = direction_y = ?, SQL1_9 = direction_z = ?, SQL1_10 = up_x = ?, SQL1_11 = up_y = ?, SQL1_12 = up_z = ?, SQL1_13 = territory_id = $CUSTOM_1$ Number of Inputs = 11 Number of Custom Inputs = 1 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11 Return InsertID = true [deleteConstruction] SQL1_1 = DELETE FROM construction WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [loadConstructionIdPage] SQL1_1 = SELECT id FROM construction WHERE deleted_at IS NULL LIMIT ?,? Number Of Inputs = 2 SQL1_INPUTS = 1,2 OUTPUT = 1 [loadConstruction] SQL1_1 = SELECT id,class,account_uid,spawned_at,position_x,position_y,position_z,direction_x,direction_y,direction_z,up_x,up_y,up_z,is_locked,pin_code,territory_id,deleted_at,damage FROM construction WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2-STRING,3-STRING,4-STRING,5,6,7,8,9,10,11,12,13,14,15-STRING,16,17,18 [countConstruction] SQL1_1 = SELECT COUNT(*) FROM construction Number Of Inputs = 0 OUTPUT = 1 [constructionSetPinCode] SQL1_1 = UPDATE construction SET pin_code= ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [upgradeObject] SQL1_1 = UPDATE construction SET class=? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [addDoorLock] SQL1_1 = UPDATE construction SET pin_code = ?,is_locked = -1 WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [updateLock] SQL1_1 = UPDATE construction SET is_locked = ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [updateConstructionTerritoryIDs] SQL1_1 = UPDATE construction SET territory_id = ? WHERE id IN(?) Number of Inputs = 2 SQL1_INPUTS = 1,2 [updateDamage] SQL1_1 = UPDATE construction SET damage = ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Containers related queries ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [insertContainer] SQL1_1 = INSERT INTO container SET SQL1_2 = class = ?, SQL1_3 = account_uid = ?, SQL1_4 = position_x = ?, SQL1_5 = position_y = ?, SQL1_6 = position_z = ?, SQL1_7 = direction_x = ?, SQL1_8 = direction_y = ?, SQL1_9 = direction_z = ?, SQL1_10 = up_x = ?, SQL1_11 = up_y = ?, SQL1_12 = up_z = ?, SQL1_13 = cargo_items = ?, SQL1_14 = cargo_magazines = ?, SQL1_15 = cargo_weapons = ?, SQL1_16 = cargo_container = ?, SQL1_17 = money = ?, SQL1_18 = pin_code = ?, SQL1_19 = territory_id = $CUSTOM_1$ Number of Inputs = 17 Number of Custom Inputs = 1 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17 Return InsertID = true [deleteContainer] SQL1_1 = DELETE FROM container WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [loadContainerIdPage] SQL1_1 = SELECT id FROM container WHERE deleted_at IS NULL LIMIT ?,? Number Of Inputs = 2 SQL1_INPUTS = 1,2 OUTPUT = 1 [loadContainer] SQL1_1 = SELECT id,class,account_uid,is_locked,position_x,position_y,position_z,direction_x,direction_y,direction_z,up_x,up_y,up_z,cargo_items,cargo_magazines,cargo_weapons,pin_code,territory_id,abandoned,deleted_at,money FROM container WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2-STRING,3-STRING,4,5,6,7,8,9,10,11,12,13,14,15,16,17-STRING,18,19-STRING,20,21 [loadContainerCargo] SQL1_1 = SELECT cargo_container FROM container WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 [updateContainer] SQL1_1 = UPDATE container SET SQL1_2 = is_locked = ?, SQL1_3 = position_x = ?, SQL1_4 = position_y = ?, SQL1_5 = position_z = ?, SQL1_6 = direction_x = ?, SQL1_7 = direction_y = ?, SQL1_8 = direction_z = ?, SQL1_9 = up_x = ?, SQL1_10 = up_y = ?, SQL1_11 = up_z = ?, SQL1_12 = cargo_items = ?, SQL1_13 = cargo_magazines = ?, SQL1_14 = cargo_weapons = ?, SQL1_15 = cargo_container = ?, SQL1_16 = territory_id = $CUSTOM_1$, SQL1_17 = money = ? SQL1_18 = WHERE id = ? Number of Inputs = 16 Number of Custom Inputs = 1 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16 [containerSetPinCode] SQL1_1 = UPDATE container SET pin_code= ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [updateContainerTerritoryIDs] SQL1_1 = UPDATE container SET territory_id = ? WHERE id IN(?) Number of Inputs = 2 SQL1_INPUTS = 1,2 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Clan related queries ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [createClan] SQL1_1 = INSERT INTO clan SET leader_uid = ?, name = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 Return InsertID = true [setAccountClanLink] SQL1_1 = UPDATE account SET clan_id = ? WHERE uid = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [unLinkClanLink] SQL1_1 = UPDATE account SET clan_id = NULL WHERE uid = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [updateClanLeader] SQL1_1 = UPDATE clan SET leader_uid = ? WHERE id = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [deleteClan] SQL1_1 = DELETE FROM clan WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [loadClansIdPage] SQL1_1 = SELECT id FROM clan LIMIT ?,? Number Of Inputs = 2 SQL1_INPUTS = 1,2 OUTPUT = 1 [getClanInfo] SQL1_1 = SELECT name,leader_uid FROM clan WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1-STRING,2-STRING [getClanMembers] SQL1_1 = SELECT uid,name FROM account WHERE clan_id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1-STRING,2-STRING [getClanMarkers] SQL1_1 = SELECT id,markerType,positionArr,color,icon,iconSize,label,labelSize FROM clan_map_marker WHERE clan_id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2,3,4,5-STRING,6,7-STRING,8 [addMarker] SQL1_1 = INSERT INTO clan_map_marker SET clan_id = ?, markerType = 0, positionArr = ?, color = ?, icon = ?, iconSize = ?, label = ?, labelSize = ? Number Of Inputs = 7 SQL1_INPUTS = 1,2,3,4,5,6,7 Return InsertID = true [addPoly] SQL1_1 = INSERT INTO clan_map_marker SET clan_id = ?, markerType = 1, positionArr = ?, color = ? Number Of Inputs = 3 SQL1_INPUTS = 1,2,3 Return InsertID = true [deleteMarker] SQL1_1 = DELETE FROM clan_map_marker WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Territory related queries ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [createTerritory] SQL1_1 = INSERT INTO territory SET owner_uid = ?, name = ?, position_x = ? , position_y = ? , position_z = ?, radius = ? , level = ? , flag_texture = ? , flag_stolen = ? , flag_stolen_by_uid =$CUSTOM_1$ , build_rights = ? , moderators = ? Number Of Inputs = 11 Number Of Custom Inputs = 1 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11 Return InsertID = true [loadTerriotryIdPage] SQL1_1 = SELECT id FROM territory WHERE deleted_at IS NULL LIMIT ?,? Number Of Inputs = 2 SQL1_INPUTS = 1,2 OUTPUT = 1 [loadTerritory] SQL1_1 = SET @connector = ?; SQL2_1 = SELECT id,owner_uid,name,position_x,position_y,position_z,radius, level,flag_texture,flag_stolen,flag_stolen_by_uid,last_paid_at,build_rights,moderators,deleted_at,(SELECT COUNT(*)FROM construction c WHERE c.territory_id = @connector) FROM territory WHERE id = @connector Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2-STRING,3-STRING,4,5,6,7,8,9-STRING,10,11-STRING,12-DateTime_ISO8601,13,14,15,16 [setTerritoryLevel] SQL1_1 = UPDATE territory SET level = ? WHERE id = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [setTerritorySize] SQL1_1 = UPDATE territory SET radius = ? WHERE id = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [updateTerritoryBuildRights] SQL1_1 = UPDATE territory SET build_rights = ? WHERE id = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [updateTerritoryModerators] SQL1_1 = UPDATE territory SET moderators = ? WHERE id = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [maintainTerritory] SQL1_1 = UPDATE territory SET last_paid_at = NOW(),xm8_protectionmoney_notified = 0 WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [deleteTerritory] SQL1_1 = DELETE FROM territory WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [flagStolen] SQL1_1 = UPDATE territory SET flag_stolen = 1, flag_stolen_by_uid = ?, flag_stolen_at = NOW() WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [flagRestore] SQL1_1 = UPDATE territory SET flag_stolen = 0, flag_stolen_by_uid = NULL, flag_stolen_at = NULL WHERE id = ? Number of Inputs = 1 SQL1_INPUTS = 1 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Garbage Collector ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ; Marks for deletion containers outside territories that were not accessed within ? days [markDeleteOldContainers] SQL1_1 = UPDATE container SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL AND deleted_at IS NULL Number Of Inputs = 1 SQL1_INPUTS = 1 ; Removes containers outside territories that were not accessed within ? days [deleteOldContainers] SQL1_1 = DELETE FROM container WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL Number Of Inputs = 1 SQL1_INPUTS = 1 ; Marks contructions outside territories deleted after ? days [markDeleteOldConstructions] SQL1_1 = UPDATE construction SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL AND deleted_at IS NULL Number Of Inputs = 1 SQL1_INPUTS = 1 ; Removes contructions outside territories after ? days [deleteOldConstructions] SQL1_1 = DELETE FROM construction WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL Number Of Inputs = 1 SQL1_INPUTS = 1 ; Marks for deletion vehicles that were not used within ? days [markDeleteOldVehicles] SQL1_1 = UPDATE vehicle SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND deleted_at IS NULL Number Of Inputs = 1 SQL1_INPUTS = 1 ; Removes vehicles that were not used within ? days [deleteOldVehicles] SQL1_1 = DELETE FROM vehicle WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) Number Of Inputs = 1 SQL1_INPUTS = 1 ; Marks territories (and all containers/constructions) that were not paid within ? days as deleted [markDeleteUnpaidTerritories] SQL1_1 = UPDATE territory SET deleted_at = NOW() WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND deleted_at IS NULL SQl2_1 = UPDATE construction SET deleted_at = (select deleted_at from territory where territory.id=construction.territory_id and territory.deleted_at IS NOT NULL) SQL3_1 = UPDATE container SET deleted_at = (select deleted_at from territory where territory.id=container.territory_id and territory.deleted_at IS NOT NULL) Number Of Inputs = 1 SQL1_INPUTS = 1 ; Removes territories (and all containers/constructions) that were not paid within ? days [deleteUnpaidTerritories] SQL1_1 = DELETE FROM territory WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) Number Of Inputs = 1 SQL1_INPUTS = 1 [addAbandonedSafes] SQL1_1 = UPDATE container SET abandoned = NOW(), pin_code = '0000' WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND class = "Exile_Container_Safe" AND territory_id IS NULL Number Of Inputs = 1 SQL1_INPUTS = 1 [deleteBaseFlagStolen] SQL1_1 = DELETE FROM territory WHERE flag_stolen_at < DATE_SUB(NOW(), INTERVAL ? DAY) Number Of Inputs = 1 SQL1_INPUTS = 1 ; Unlock doors and mark safes as abandoned if flag stolen for X days [setAbandonedUnlocked] SQL1_1 = UPDATE container SET abandoned = NOW(), pin_code = '0000' WHERE (SELECT flag_stolen_at from territory WHERE territory.id=container.territory_id AND territory.flag_stolen_at < DATE_SUB(NOW(), INTERVAL ? DAY)); SQL2_1 = UPDATE construction SET pin_code = '0000' WHERE (SELECT flag_stolen_at from territory WHERE territory.id = construction.territory_id AND territory.flag_stolen_at < DATE_SUB(NOW(), INTERVAL ? DAY)) AND pin_code != '000000' Number Of Inputs = 1 SQL1_INPUTS = 1 SQL2_INPUTS = 1 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Moneh moneh moneh ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [setPlayerMoney] SQL1_1 = UPDATE player SET money = ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [getPlayerMoney] SQL1_1 = SELECT money FROM player WHERE id = ? Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 [setContainerMoney] SQL1_1 = UPDATE container SET money = ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [setVehicleMoney] SQL1_1 = UPDATE vehicle SET money = ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; XM8 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [getAllNotifTerritory] SQL1_1 = SELECT id FROM territory WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? - 1 DAY) and xm8_protectionmoney_notified = 0 Number of Inputs = 1 SQL1_INPUTS = 1 [setTerritoryNotified] SQL1_1 = UPDATE territory SET xm8_protectionmoney_notified = ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2
  10. im getting this error like a lot of other people 11:18:27 "ExileServer - MySQL connection error!" 11:18:27 "ExileServer - Please have a look at @ExileServer/extDB/logs/ to find out what went wrong." 11:18:27 "ExileServer - MySQL Error: Unable to locate extDB2 extension!" 11:18:27 "ExileServer - Server will shutdown now :(" i have the latest files installed but no luck. Im using vilayer as a host btw.
  11. LangeBlonds

    SQL CUSTOM V2

    Hello !! someone there you had this problem ?? [01:03:52 +00:00] [Thread 7845] extDB2: Database Type: MySQL [01:03:52 +00:00] [Thread 7845] extDB2: Database Session Pool Started [01:03:52 +00:00] [Thread 7845] extDB2: SQL_CUSTOM_V2: Loading Template Filename: /home/dd192148-ovh/12972/arma3/@exileserver/extDB/sql_custom_v2/exile.ini [01:03:52 +00:00] [Thread 7845] extDB2: SQL_CUSTOM_V2: Version 8 Detected, Latest Version 12 Available [01:04:27 +00:00] [Thread 7845] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: Field 'assigned_items' doesn't have a default value [mysql_stmt_errno]: 1364 [mysql_stmt_sqlstate]: HY000 [statemnt]: INSERT INTO player SET account_uid = ?, name = ? [01:04:27 +00:00] [Thread 7845] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session [01:04:27 +00:00] [Thread 7845] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561197972519305:Major Lynx.D
  12. Hello, I am having an issue where all my players are getting black screen when loading into map. Here is the error I am getting in MySQL and not sure if that has anything to do with it. [13:48:57:430755 --7:00] [Thread 1208] extDB2: Database Type: MySQL [13:48:57:435700 --7:00] [Thread 1208] extDB2: Database Session Pool Started [13:48:57:438925 --7:00] [Thread 1208] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Arma\Server\@ExileServer\extDB\sql_custom_v2\exile.ini [13:48:57:439214 --7:00] [Thread 1208] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available [13:48:57:445042 --7:00] [Thread 1208] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Arma\Server\@ExileServer\extDB\sql_custom_v2\avs.ini [13:48:57:445079 --7:00] [Thread 1208] extDB2: SQL_CUSTOM_V2: Version 8 Detected, Latest Version 12 Available [13:50:03:804599 --7:00] [Thread 1208] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'ammo' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT ammo FROM vehicle WHERE id = ? [13:50:03:804690 --7:00] [Thread 1208] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session [13:50:03:804719 --7:00] [Thread 1208] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: getVehicleAmmo:1 Here is the server logs, it's big so I made it a spoiler. Not sure how to fix this. Any help appreciated.
  13. I've seen this answered by many other people, however none of their fixes work. 18:29:25 "ExileServer - MySQL connection error!" 18:29:25 "ExileServer - Please have a look at @ExileServer/extDB/logs/ to find out what went wrong." 18:29:25 "ExileServer - MySQL Error: Unable to locate extDB2 extension!" 18:29:25 "ExileServer - Server will shutdown now :(" I'm running an Arma 3 server hosted by ggservers https://ggservers.com with Exile installed. Their support has not yet been able to help me. Full RPT: http://pastebin.com/n70ba1rp VC++ Redistributable is installed extdb-conf.ini is configured extDB2.dll is in the @ExileServer folder, tbbmalloc.dll is in the server folder.
  14. Hey I was recently making an exile server and came across an error when making the database, "foreign key constraint", in MySQL workbench. The error also came up for extDB2 when I started the server (check spoiler). If someone knows how I can fix this, it would be great! Some details that may come in handy: Server hosted on a dedicated server MySQL server is hosted by XAMPP Hosted using windows server 2012 R2 any help is greatly appreciated!
  15. Ghostyy

    Error: Bambi Creation Timeout

    I have been having this problem for the past hour and can't seem to work it out. As the title suggests... I have checked the other threads and tried the other fixes suggested. I ran a server a few months ago and didn't have this issue. Everything went smooth. RPT Log - http://pastebin.com/rqy44mJC Mostly worried about this particular section of the RPT Log. The rest seems normal. 8:54:04 "ExileServer - Starting session for '[FRAC]Ghostyy' with ID 'zpXvqhIf'..." 8:54:53 Error in expression <llExtension _query); (_result select 1) select 0> 8:54:53 Error position: <select 0> 8:54:53 Error Generic error in expression 8:54:53 File exile_server\code\ExileServer_system_database_query_insertSingle.sqf, line 16 8:54:53 Error in expression <llExtension _query); (_result select 1) select 0> 8:54:53 Error position: <select 0> 8:54:53 Error Generic error in expression 8:54:53 File exile_server\code\ExileServer_system_database_query_insertSingle.sqf, line 16 The above comes up every time I try to join. So about 1min after picking a spawn location it comes up with the error. I tried turning Strict mode off first. Didn't work. (my.ini and my_default.ini) I made sure I was using the latest exile.ini and even replaced the whole file with the one out of the original download rar. I am also deleting myself from the database every time this happens to make sure that isn't the issue. Below is the latest extDB2 log file too, incase that might hold some significance. [09:36:11:770325 +01:00] [Thread 14120] extDB2: Database Type: MySQL [09:36:11:782084 +01:00] [Thread 14120] extDB2: Database Session Pool Started [09:36:11:783953 +01:00] [Thread 14120] extDB2: SQL_CUSTOM_V2: Loading Template Filename: G:\Servers\ArmA3\A3Exile\@ExileServer\extDB\sql_custom_v2\exile.ini [09:36:11:784111 +01:00] [Thread 14120] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available [09:41:09:359017 +01:00] [Thread 14120] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: Field 'assigned_items' doesn't have a default value [mysql_stmt_errno]: 1364 [mysql_stmt_sqlstate]: HY000 [statemnt]: INSERT INTO player SET account_uid = ?, name = ? [09:41:09:359475 +01:00] [Thread 14120] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session [09:41:09:359500 +01:00] [Thread 14120] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198124384523:[FRAC]Ghostyy Running on Windows with WAMP (MySQL 5.7.9) Latest version of Exile with Emergency fixes added. Just to clarify, brand new install (No previous versions ever run on this PC.) and fresh installs of MySQL and all other components. No mods other than Infistar and Exile. Along with BEC. Any help would be appreciated. Regards,
  16. DattoSSS

    extDB2: No Config Option Found: exile

    Hello everyone I have rented a server from Wombat and have added the latest Exile files. I am new to modding servers so I have used the forums extensively to solve the incoming issues. My goal is to start with exile.altis as a learning curve, add AI and other addons, then find another custom map thats a bit different to use once I have my head around the script. Anyway I am to the point where the server hangs on 'receiving server version'. Wombat have been very helpful. Management (Javed) actually sat up past 2.30am emailing me and loading the latest C++ redistributable on my database to assist and making sure strict mode was turned off. I have set up the database using exile sql and updated to the latest version. I have also checked the scripts as has Wombat and no connectivity errors could be found with the [exile] section. I have basically tried every fix I could find in the forums. Wombat have suggested there may be an error in the script above [exile] affecting connection. Could you please have a look at the logs and files and see if you could find the error? Any assistance is greatly appreciated. Server is Windows and the DB is Linux if that makes a difference. Thanks Command Line: -ip=43.245.163.200 -port=2382 -noPause -noSound -cpuCount=4 -maxMem=2048 -exThreads=7 -cfg=A3DS\basic.cfg -config=A3DS\server.cfg -profiles=A3DS\Profiles -world=empty -mod=@Exile -servermod=@ExileServer Log: extDB2: Version: 70 extDB2: https://github.com/Torndeco/extDB2 extDB2: Windows 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 8 Cores, Setting up 6 Worker Threads [01:18:29:256675 +00:-1] [Thread 65268] extDB2: No Config Option Found: exile [01:18:29:256675 +00:-1] [Thread 65268] extDB2: Sending Shutdown to Armaserver @ExileServer\extdb-conf.ini: [Main] Version = 5 ;Threads = 0 ; Default Value is the number of CPU Cores Detected (max value is 6, min value is 2) Randomize Config File = false ;This is a legacy option to randomize config file for Arma2 Servers. Only for Windows Builds [Rcon] ;; This is functional, should be working fine. Just needs abit of testing on a $ ;; Allow for changing Address for those running server in a VM environment. IP = 103.231.91.30 Port = 3306 ;; Rcon Password i.e Battleye/beserver.cfg Password = *** ;; Bad Player Name Checks ;; This will only work if your mission / mod has started extDB2 Rcon. i.e 9:START_RCON:RCON Bad Playername Enable = true Bad Playername Kick Message = Bad Player Name ;; By default : is a bad character (used as seperator for extDB2 Calls (this is hardcoded in) Bad Playername Strings = (:):{:} ;;Bad Playername Regex_1 = [:alnum:] ;;Bad Playername Regex_2 = [:alnum:] ;;Bad Playername Regex_3 = [:alnum:] ;; Whitelisting / Reserve Slots ;; This will only work if your mission / mod has started extDB2 Rcon. i.e 9:START_RCON:RCON Whitelist Enable = false Whitelist Kick Message = Only Reserved Slots Left Whitelist Public Slots = 999 ;; Database settings to use (Optional) Whitelist Database = exile Whitelist SQL Prepared Statement = SELECT CASE WHEN EXISTS(SELECT UID FROM PlayerInfo WHERE BattlEyeGUID=? AND Whitelisted=1) THEN 1 ELSE 0 END Whitelist Kick on SQL Query Failed = false ;; Hardcoded BEGuids for whitelisted players ;Whitelist BEGuids = xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx : yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy [Steam] ;; This is for VAC Protocol for VAC Bans + Steam Friends. ;; https://steamcommunity.com/dev/apikey API Key = xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx [VAC] ;; This feature requires Steam + Rcon to be enabled. ;; Also this feature is called via SQF Code atm, i.e it doesn't auto detect players joining server yet.... Auto Ban = false ;; For Player to get banned ( their total VAC Bans => NumberOfVACBans) AND ( Days Since their Last Ban was <= DaysSinceLastBan) ;; This is also used extDB Protocol VAC:VACBanned returned results NumberOfVACBans = 1 DaysSinceLastBan = 999999999 BanDuration = 1 ;; 0 = Forever, otherwise its x Minutes BanMessage = Steam VAC Banned [Log] ;; Flush Logs after each write, more work on Harddrive Flush = true [exile] Type = MySQL Name = BradH1_1 Username = BradH1 Password = *** IP = 103.231.91.30 Port = 3306 minSessions = 2 idleTime = 60 ; Really should only use this if MySQL server is external. Also only for MySQL compress = false ; Recommend you turn this on http://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html#option_mysql_secure-auth Secure Auth = true [SQLite_Example] Type = SQLite Name = sqlite.db minSessions = 1 ; minSession Default Value = 1 ;maxSessions = 4 ; maxSession Default Value = number of Main->Threads ; You really should leave this value alone idleTime = 60 ; idleTime no Default Value yet, needs to be defined. ; idleTime is the time before a database session is stopped if not used. ; If Database Sessions are greater than minSessions
  17. SurvivalZ

    extDB2 Problem Debian 7

    Hey dudes, first: sorry for my Bad Englisch skills ;/ a view months ago i install a exile Server on my debian 7 root Server an it works fine ! now use the latest exile Updates the extDB2 version 69 or higher... this version dont work on my root ;( ldd extDB2.so says: libtbbmalloc.so.2 => not found ideas ? thx dudes ! and merry Christmas !
  18. I think I may have found an issue with the following exile.ini cleanup commands: deleteOldContainers deleteOldConstructions deleteOldVehicles deleteUnpaidTerritories I have tested this on the territory table using the deleteUnpaidTerritories command. (I have a territory last_paid_at set to 2015-01-01 for testing purposes) Adapted to be a select instead of a delete (I removed the DELETE keyword and added SELECT * so i could see what was being returned/wht would have been deleted): SELECT * FROM territory WHERE last_paid_at < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 14 DAY)) Produces the following warning and returns no results: "Incorrect datetime value: '1448678464' for column 'last_paid_at' at row 1" Modifying the query to remove the UNIX_TIMESTAMP() block fixes this and I get the 1 result I was expecting: SELECT * FROM territory WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL 14 DAY) With the original query, territories are not being deleted. Original: DELETE FROM territory WHERE last_paid_at < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ? DAY)) Modified to work: DELETE FROM territory WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? DAY) This testing was performed on a MySQL server with version 5.6.17
  19. Butzei

    SQLite

    Hi all, I tryed to use SQLite *.db file instead of installing an whole MySql server. Sadly it doesn't work. It showed extDB2: Database Exception Error: Connection attempt failed: Unable to open the database file: Unable to open the database file in the extDB2 log files. So: Is it possible to use SQLite DBfiles? extDB2 would Support SQLite. Thanks, Butzei PS: My extdb-conf.ini db-part:
  20. - VJ -

    Saving Kill Log To The DB

    How can i add the Kill log to the mysql database. I'm not any good with extDB2 Thanks.
  21. All players are generated, even saved correctly to the database, but when they leave and join back from the lobby they spawn in a peculiar way (That is, on a random island, with no character model, with a messed up view (sorta like first person prone, but at all positions and even in 3pp), and no items.). I guarentee this is an Exile/Database bug. I have tried all other options available, but none seem to relate or work. Video and/or specific log files available upon request. I have followed the installation tutorials for MySQL and extDB2 thoroughly and cant figure this one out.