Terror_Nova
Member-
Content count
13 -
Donations
0.00 EUR -
Joined
-
Last visited
Content Type
Profiles
Forums
Wiki
Servers
Devblog
Everything posted by Terror_Nova
-
Folks - should be an easy question: Where do I change the the parameters to lower the range of Titan (and other default Arma) missiles? I've de-pbo'ed (new word?) the pbos under @Exile but I don't think that is where they are... Suggestions? Thanks!
-
We have set a server under 2016 and in the process of moving to another server running 2016. I also have set up a number of test Exile servers under 2016. My observations: 1. If you are using a hosted service (e.g. OVH) you get their stock install (e.g., software mirrored disks). Only the base 2016 GUI install is used. You don't have to unlock the DLLs with the most recent 64-bit fixes. I don't find the Windows 10 GUI any more of a problem than 2012's (Windows 8 - which sucked). 2. If you are "rolling your own" when you install Server 2016 make sure you select the GUI version (unless you really like doing everything from the command line - if that's the case maybe you want to go Linux :-) ). Don't add any unnecessary roles (e.g., Domain Controller, Terminal Server, etc.) Think about a second disk for putting backups of your configs and databases on a different disk (if you have two partitions on one un-mirrored disk you could lose everything. We had mirrored SSD fail on us too). If possible back up your configs and database to an offsite location on a regular basis (I do every 12 hours to off site). Generally (day job is partially IT security), disable anything that you don't need (this will also help with performance). Set up the firewall - don't leave it wide open. If you have a physical firewall - set up your server in a DMZ (if possible) and only open the right ports/port ranges to that server (you need a more sophisticated firewall for a proper DMZ - not the foolishness Linksys, Netgear call a DMZ on their home firewalls - the SMB/SoHo firewalls often have the features but that will cost you $500+). If you only have one person on the server console consider using two-factor authentication. There are a couple of free solutions out there (Google is your friend). And make sure your patch, patch, patch...
-
IT thoughts (day job): - RAM doesn't seem to be an Arma/Exile problem - Take a look at how much CPU usage is occurring - don't forget to take a look at the speed the CPU is running (e.g., at 4.0 GHz) as it seems speed is more important than load - Add an HC and review RAM/CPU - one thing to check here is how many page faults are occurring. Windows generally page faults quite a bit (VMS heritage) but Linux shouldn't page fault much. If you are page faulting you are a swapping to disk and that will slow things down even with an SSD - Check your disk usage - make sure that your disk queues are filling up. Even an SSD has limits (plus the bus, etc.) - Make sure hyperthreading is enabled. HT is NOT a 100% core but it is better than nothing (on the other hand I've seen applications that slow down with HT but I don't think this is the case with Arma) - Not sure on this one - take a good look at how you set up your database (I'm assuming your database is on the same server - if not, network needs to be looked at too as it isn't local loopback). You don't want your queue depth to get too deep - that would be wait states Basically, I'd add an HC and monitor it. If things are good, added another HC. Rinse and repeat. -- Terror_Nova
-
Thought: Make sure that you run all the extDB3 update scripts. Once you update the database connectors (Declan Ireland's torndeco https://bitbucket.org/torndeco/extdb3/downloads/ - I used extDB3-1031.7z) make sure you follow BrettNordin's (https://github.com/BrettNordin/Exile) instructions. Specifically: In your extdb-3.ini, you misses the step of changing [Default] to [exile] This is kind of "weird" - the "[Default]" needs to be the name of your database schema which is most of time called "exile" - so "[exile]". If all comes to all - I'd delete the exile schema from the database and then run the default (32-bit) Exile script and then the extDB3 update scripts. -- Terror_Nova
-
I think hectorPlusPlus is pointing you in the right direction. XM8 is now included in the most recent Exile Mod update. ExAD developer seems to have indicated that he is taking a break from development because of incompatibilities with Exile XM8 and ExAD. I think you have to chose one or the other (e.g., disable Exile XM8). That said, while Exile XM8 isn't as functional as ExAD I'd go with Exile (so nothing breaks on updates, etc.). I could be wrong here! -- Terror_Nova
-
I'm no expert in this but here is my experience (I've spent most all my time with Arma x64 and extDB3 - so extDB2 is a little foreign): 1. Your RPT file seems pretty "normal" (lots of info and a few "normal" errors) 2. The DB log seem to hold the clues - You are getting a database connection - good - The first error line in the DB log [18:14:28:138861 +02:00] [Thread 7704] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Table 'exile.container' doesn't exist [mysql_stmt_errno]: 1146 [mysql_stmt_sqlstate]: 42S02 [statemnt]: 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)); seems to indicate that the database schema (e.g. the exile schema) is not correctly set up. What I would do is delete the exile schema and then rerun the exile SQL schema creation script again. One thing I will note is sometimes if you are the first person to log in you may not get into the game and will be kicked. If you log in again, things will be okay (seems like the database is "warming up" :-) ) HTH -- Terror_Nova Join us on the DoD servers - Exile Altis Militarised, Exile Lythium Militarised and Exile Altis Epoch
-
Strange problem here: The 8G network in the XM8 stopped working a couple of days ago. I tried the suggested fix - delete the Exile database (with re-creating the Exile schema, adding the 64-bit patch) and restore the database - but that did not fix it. Any suggestions? Thanks! -- Terror_Nova
-
-
I'm no expert but it seems Exile and mods end up with cascading errors that don't make sense. i.e. error is in mod 1 but the problem seems to be with mod 8. Check that you are putting NULL in instead of zero (with Heidi use the insert NULL option). Of course, I could be dead wrong - ymmv.
-
Logging Sales to Database (related to Extra logging for trades/territories/poptabs)
Terror_Nova posted a topic in Scripts
Folks - this may have already been covered and my searches have not found it (sorry!). Is there a way to log player sales to the Exile database? I have touched base with torndeco (extDB3 author) and he stated that the API can do this and I need to check with the Exile Mod community. What I would like to do is to log all player selling to the database (instead of the text file) so that I can more write a procedure to easily report sales. Most people would guess that I am trying to find an easier way of reviewing and reporting duping. Thanks! Cheers Terror_Nova -
You apparently need to place the traders IN the editor.
- 86 replies
-
- moving traders
- traders
-
(and 2 more)
Tagged with:
-
Trying Isla Abramia out but the traders are not showing up. Well, they are showing up but they are under the terrain, out in the ocean... Suggestions?
- 14 replies
-
- 2
-
Logging Sales to Database (related to Extra logging for trades/territories/poptabs)
Terror_Nova replied to Terror_Nova's topic in Scripts
Just found that out myself. I am relearning SQL to deal with multiple databases as it is a hive...