Starting a private server, how 2?

[RWashi]

Hello, i'm wanting to host a private server, how would i go by doing this?

Is there some sort of guide to setup a server on a SQL server, also what is the best EMU SVN to use?

Ive hosted private server before but not for WoW so i'm a total noob at this :P

[turtleswin]

1. Buy VPS.
2. MySQL.com
3. Heidisql.com
4. Compile TrinityCore.
5. Execute SQLs
6. Win.

[RWashi]

I have a dedicated host so all i need to do is these?

4. Compile TrinityCore.
5. Execute SQLs

Does PUTTY work WoW servers?

[turtleswin]

You need Heidisql and MySQL to execute SQLs, no Putty does not work.

[RWashi]

Noticed your sig .

I'm impatient with idiots, so be careful

In this case im an idiot but also a fast learner so please bare with me

Is there a guide on how do;

1. Buy VPS.
2. MySQL.com
3. Heidisql.com
4. Compile TrinityCore.
5. Execute SQLs
6. Win.

Thank you.

[turtleswin]

Well, a dedicated host is considered a VPS. MySQL.com is a download aswell as Heidisql.com. I wrote a guide on how to compile Trinity with the SQLs. http://www.ownedcore.com/forums/worl...e-scratch.html (How to compile TrinityCore from scratch!)

[RWashi]

Thank you.

[RWashi]

Great guide but when downloading most files i realized this is to host from your own machine.

Is there a guide to setup and host on a dedicated host i purchased from iweb.com

These are my specs, suppose it will be okay to learn the setup, i can always add hardware if required.

4GB RAM
2x 160GB
Linux Entreprise - CentOS
Proc: 2 CELERON DUAL CORE E1400

[turtleswin]

My guide was for windows specifically. I'll get you a CentOS guide.

[RWashi]

Thankyou, much appreciated

[The-Eradicator]

Here's how to compile MaNGOS on any Linux distro, should be pretty much the same for other emulators. Make sure you have appropriate dependencies (cmake, gcc, etc)

mkdir mangos
cd mangos
git clone http://github.com/path/to/repo.git .

### If you need ScriptDev2 ###
cd src/bindings
mkdir scripts
cd scripts
git clone http://github.com/path/to/scriptdev/repo.git .
cd ../..
git apply src/bindings/scripts/patches/(name of patch).patch
### End ScriptDev2 ###

mkdir build
cd build
cmake ../ -DPREFIX=/path/to/where/you/want/the/executables -DPCH=1 -DACE_USE_EXTERNAL=0 -DDEBUG=0 -DTBB_USE_EXTERNAL=0
make && make install

Once that's done, you'll want to rename your config files from .conf.dist to .conf and edit your config files, typically in the etc folder, and then run extractors for vmaps/dbcs/mmaps/maps on your computer. Upload anything the extractors generated, then create your MySQL databases (some or all of: realmd, world, characters, and SD2 depending on your emulator), and restore the appropriate .SQL files for each. Most of that is pretty easy to figure out, just follow a readme from any guide, it's OS independent so you should have no trouble.

[RWashi]

I dont understand this bit;

Ive gone with TrinityCore

### If you need ScriptDev2 ###
cd src/bindings
mkdir scripts
cd scripts
git clone http://github.com/path/to/scriptdev/repo.git .
cd ../..
git apply src/bindings/scripts/patches/(name of patch).patch
### End ScriptDev2 ###

Also;

Once that's done, you'll want to rename your config files from .conf.dist to .conf and edit your config files, typically in the etc folder, and then run extractors for vmaps/dbcs/mmaps/maps on your computer. Upload anything the extractors generated, then create your MySQL databases (some or all of: realmd, world, characters, and SD2 depending on your emulator), and restore the appropriate .SQL files for each. Most of that is pretty easy to figure out, just follow a readme from any guide, it's OS independent so you should have no trouble.

I can not fine a file called .conf.dist or .conf, where is this located?

Also how do i run extractors for vmaps/dbcs/mmaps/maps using PUTTY SSH?

[The-Eradicator]

I get this error when doing this;

That was an example URL, you have to use the URL of the emulator you want...

[turtleswin]

You want TrinityCore - Don't need to compile ScriptDev on Trinity, aswell as its fast.

[RWashi]

Thank you how about this bit?

Once that's done, you'll want to rename your config files from .conf.dist to .conf and edit your config files, typically in the etc folder, and then run extractors for vmaps/dbcs/mmaps/maps on your computer. Upload anything the extractors generated, then create your MySQL databases (some or all of: realmd, world, characters, and SD2 depending on your emulator), and restore the appropriate .SQL files for each. Most of that is pretty easy to figure out, just follow a readme from any guide, it's OS independent so you should have no trouble.

I can not fine a file called .conf.dist or .conf, where is this located?

Also how do i run extractors for vmaps/dbcs/mmaps/maps using PUTTY SSH?