If you are a complete virgin and don't have a platform in place to run the server yet:
MySQL Community Edition: Download Page link
SQLyog: Download Page link
This is all you should need to get a basic server running.
[/SIZE]---------------------------------------------------------------------
Installation, step-by-step:
1) [First-Timers Only] Install MySQL 5.0 Essentials and SQLyog.
If you already have these tools on your machine (for a previous MaNGOS installation, or otherwise) you do not need to reinstall them. SQLyog itself is optional if you are comfortable with the command-line syntax for MySQL, but it's recommended anyway just for its visual presentation of very large tables.
Follow the basic default setup for both programs -- no special options are needed. To be excruciatingly specific:
- You want a Typical installation, not Complete or Custom.
- Agree to start the configuration wizard when it asks.
- You want a Standard configuration, not a Detailed configuration.
- You want to Install As Windows Service.
- You do not want root access from remote machines, and you do not want an Anonymous Account.
If you really need a more in-depth configuration of your MySQL server, chances are you already know how to do it.
2) [First-Timers Only] Create a new SQL user.
The importance of this step cannot be understated. It does make things complicated, but you cannot let programs connect as root to your database. The root user's privileges supercede all others; with access to this account, anyone could destroy everything, and if that happens, there will be nothing you can do. The only place that you should ever have your root password is in your head -- not sitting as plain text in a .conf file.
In SQLyog, go to the 'Tools' menu at the top, and then go to 'User Manager' -> 'Add User.' Create a username and password; these will be the username and password that you place in the .conf files later on. Change the host to 'localhost', and under the Global Privileges, check the boxes for 'Select,' 'Insert,' 'Update,' and 'Delete.' Press the 'Create' button at the bottom, and you are done.
3) Create a blank database for Antrix.
This part is fairly simple: create a new, empty database to keep the data for Antrix. A realm database (such as the one MaNGOS uses) is not necessary.
If you have a previous installation, using Gospel's DB, you are best off blowing it away completely and starting from scratch. That specific database was shown to have a number of crippling problems.
To "empty out" a database in SQLyog, right-click on the 'antrix' database and select 'Empty Database.'
To create a new database SQLyog ('DB' menu -> 'Create Database', and then entering 'antrix' as the name), or by executing the query "create database antrix".
You should know better, at this point, than to include the quotes in any of those statements.
4) Extract the packages.
Extract the core server (antrix120-2.1.0-jerks.rar) into its own directory (e.g., c:\wowserver\antrix\). Next, extract the database (antrix_db.rar) into the sql\ folder that was created there.
If you are updating from a previoius version, it should be OK to simply overwrite all of the files. Make sure you either save a copy of your existing .conf files, or be prepared to edit the new ones though!
It is not necessary to place the antrix.sql file in your installation's sql/ folder, though it can prove useful in the event that everything goes horribly wrong and you need to start from scratch again. If you're comfortable backing up your own data, you can simply extract the .sql file to your desktop, use it from there, and delete it when you're done.
5) Populate the antrix database.
Now we will restore the sql dump to put data into the empty database. Former MaNGOS users will be familiar with this process; simply right-click on the database "antrix" in SQLyog, click "Restore from SQL Dump," and direct it to the spot where you extracted antrix.sql (e.g., c:\wowserver\antrix\sql\antrix.sql).
This can also be done from the commandline, if you have access to the MySQL commandline tools, with the following:
mysql -u root -p antrix < c:\path\to\name_of_file.sql
Either way, once execution completes, this step is finished.
6) Edit your configuration files
This part is straightforward -- you have three files to configure, in the main Antrix directory:
- logonserver.conf
- realms.conf
- antrix.conf
These files are well-documented, and resemble the MaNGOS configuration files. Just read through them and change values as needed until you are done, then save and exit.
If you are updating a previous configuration, just copy your backups straight over these files.
One note on configuration: The realms.conf file is a little confusing when it comes to distinguishing between the world server, realm list, and login server. When you get to the section where you are configuring LoginServer1.Port, do not change it from the default of 8093. This is the port that the world server uses to communicate back and forth with the login server, and it is hard-coded at the moment.
7) Extract maps and DBCs.
While there are map- and dbc-packs available for download in various places, I really prefer extracting them myself, to ensure that they are the correct version. Tools for doing this, as well as instructions, are enclosed in the binary package -- under maps\mapExtractor and dbc\dbcExtractor, respectively.
Follow the instructions in the README files for each of these utilities, and copy the appropriate .map and .dbc files that are generated over to the maps/ and dbc/ folders in your main Antrix directory.
This will guarantee that you have the right ones to run with Antrix. As is the case with a few supposed 2.1.0 dbc downloads, it won't work if you have them from a 2.0.12 install!
If you already have working maps and dbcs from a previous install, you may skip this step. It may be worth it to pull new maps, as the core package now includes Yamachi's rebuilt map extractor (which ensures that all 2.1.0 content such as the Black Temple will be extracted).
8) Start the server.
[INDENT][SIZE=2]At this point, Antrix is ready to use. Start logonserver.exe, and then start antrix.exe. Assuming you didn't confuse any port numbers in your configuration files, everything should be up and ready to rock. Errors, crashes, or other problems can be posted in this thread -- I will do my best to address and answer them.
---------------------------------------------------------------------
GM System notes:
Antrix's GM system works on a flag-based system, instead of a level-based one. This means that you can give specific access to certain types of commands to specific user accounts. If you want GM Danny to be able to create NPCs and teleport himself, but you don't want him to go around handing out free levels and gold to himself and everyone else, this is now possible.
As there are no standalone account-administration utilities at this time, you'll have to grant GM powers the old-fashioned way. Go to the 'accounts' table in your 'antrix' database, click the tab marked 'Table Data', and find the column labeled 'gm'. Put the desired GM flags in the cell that is on the row of the user account that you wish to modify. Once you have entered what you need, save that table (blue disk icon) and have that account log in.
For "full" GM powers (level 3 in MaNGOS) simply type 'az' (without the quotes) in that cell. For better control over specific permissions, see the guide posted here. A list of GM commands can be found in the Documentation\ folder of your Antrix install.
---------------------------------------------------------------------------------
Installation guide credits goto jerkstore... thanks buddy.