tompack: noob friendly. easy server setup 2.3.3

Results 1 to 25 of 25
  1. #1

    tompack: noob friendly. easy server setup 2.3.3

    Introduction
    This is an old repack that I have been working on for a while. It is a mangos driven repack, and one of the first noob friendly ones. I made it so you do not need to install a bunch of things like previous repacks in the past have. If you notice, a lot of repacks are like this now.

    Anyway, I try to make this repack easy to use, noob friendly, and stable. Give some feedback on it to make it better.

    Current version
    tompack 4.99 beta
    In this release:
    MaNGOS revision 5650
    ScriptDev2 revision 344
    UDB 0.10.0.346
    DBC files from client 2.3.3

    supports WoW TBC 2.3.3

    Changes
    This version now starts properly. There was a problem in the database, mostly in the characters table. I have now fixed it and it should run rather smoothly now.

    Currently supports WoW TBC client 2.3.3

    Download
    tompack 4.97

    tompack homepage
    check for updates and stuff

    Guide
    Before installing, make sure that you uninstall all other versions of tompack just to ensure that it works fine.

    other than that, the newer versions now dont require you run any registry changes or do anything else with any other program. Just make sure you follow the instructions

    1. Download the tompack. Start up the installer (double click on tompack.exe). Choose the install directory and hit install. Wait patiently until it finishes.
    2. As soon as the install is finished, the post-installer should pop up in a command prompt window. Just read the instructions to extract the maps and continue. In this release I was able to get you guys the DBC files for 2.3.3 enUS, so you dont need to worry about extracting that. When another installer comes up, tell it where you world of warcraft install directory is and hit install. Then ad.exe should start doing its job. When it is done, go to the world of warcraft install directory, and you should see a folder in there called maps. Move it to the install directory of the tompack.
    3. Now then, you should be all set. I already pre-configured the configuration files for a basic server, but if you want to customize it, feel free to open up the .conf files and fix it to what you want, given you know what you are doing. Otherwise, go to the next step.
    4. Now then, go to the tompack folder and double click on either "start background.bat" or "start mysql console.bat" It doesnt matter which one you choose. If you want to see the mysql output and/or need to debug, use the console batch, but otherwise, you can use the background one. If you use the console on, make sure you do NOT close the window after, you must keep it open for the server to run. With the background batch, you just need to give if about 5 seconds to initialize, then you can close it if you want.
    5. After you start up the mysql server, you can now start up the rest of the server. Just double click on realmd.exe and wait for it to finish up (should take around 1-10 seconds) then start up mangosd.exe and wait until that finishes. It should beep when it is done, and/or give you a Mangos> prompt. Make sure you keep the windows open.
    6. then to play on your server, change you realmlist.wtf file in you world of warcraft install directory. Change it so it says "set realmlist 127.0.0.1" you dont need to worry about the other line.
    7. Now that you have you server up, you need to make some accounts. Just go to the mangosd.exe window and type in "create USERNAME PASSWORD" where USERNAME is the username you want, and PASSWORD is the password you want for your account. To set GM type in "setgm USERNAME #" where USERNAME is the username you want to give privileges to and # is the number 0,1, 2, or 3, where 0=normal player, 1=moderator, 2=game master, and 3=administrator. To enable all TBC features, type in "setbc USERNAME #" where USERNAME is the username u want to give tbc to and # is 1 or 0 where 1 enables TBC and 0 is normal wow. After you have an account, start wow, login and enjoy!


    NOTE TO SHUT DOWN THE SERVER to shutdown your server, close mangosd.exe and realmd.exe and run "shutdwon mysql.bat" in the tompack folder. When it asks to enter the password, enter "root" and press enter.


    [*] once everything is done change the realmlist.wtf in your wow directory to 127.0.0.1


    I will be making patches periodically, so check back often for updates! Please post feedback!

    Optional step! Making your server public the easy way with Hamachi!:
    1. Download and install Hamachi from http://www.hamachi.cc (go to the bottom of the download page to download without registering.
    2. If you want follow or skip the tutorial. Press the green power button in the left-hand corner of the hamachi window. Wait until hamachi is done starting up the network.
    3. press the button with a triangle in it in the right hand corner of the hamachi window. Select create new network. Think of a name for your network (this will not be the name of your realm/server, so it can be a crappy name as long as you can remember it.) and make a password. Write both these down so you do not forget. Note the number that hamachi give you at the top of the window (eg: 5.123.456.78), and write that down as well.
    4. Start the mysql sever with "start mysql.bat" or "start background.bat" but do not start up the server, and open up your database with a mysql gui such as navicat or sqlyog. To do this, create a new connection in navicat or sqlyog and use these settings:
      connection name: this can be anything you want
      host: 127.0.0.1
      username: root
      password: root
      and keep everything else default
    5. Now assuming you have done that successfully, start the connection and click on the realmd database in the connection and open up the realmlist table. You should see an entry in the table. Scroll all the way over to the ip address column and change it from 127.0.0.1 to your hamachi ip address you wrote down earlier. Now close the mysql gui and fire up hamachi then your server (in that order) and you should be good to go. Now just get some people to join your hamachi network and make some accounts for them, and you should have a small server up in no time.

    * Troubleshooting step: If for some reason, you and other people are unable to connect to your server, please make sure it is properly up and running. If it is up and running (properly and you are 100% sure of it) refer to step2 in the repack installation section of this guide, and edit the "realmlist" table in the "realmd" database and replace 127.0.0.1 with your hamachi IP address.

    if a tompack patch has a database patch (it will tell you) to backup your characters:
    1. First off, download the patch
    2. Before installing the patch, start mysql server (if it isnt already up) and go to the characters folder in the tompack directory and run "backup characters.bat" It should make a file called "characters.sql"
    3. Wait until it is done and then shutdown the server.
    4. After the server is down, run the patch installer
    5. When the it is done patching, go back and start the server up and go back to the character folder. Run "restore characters.bat" and wait until it finishes.
    6. When its done (correctly) you should be done and your tompack repack should be up-to-date!
    7. If you experience problems, post them here


    OPTIONAL!! MAKING YOUR SERVER PUBLIC WITHOUT HAMACHI (DYNAMIC IP)


    INDEX:

    • I. CREATING A DYNAMIC DOMAIN NAME.
    • II. MANGOS PREPERATION.
    • III. ROUTER CONFIGURATIONS
    • IV. SETTING UP YOUR CLIENT TO CONNECT TO YOUR SERVER.
    • V. COMMON Q&A


    DLink Router users : I do not know how to configure your routers becuase they have too many conflicting port configuration applications on it.

    If you have a Static IP from your ISP simply choose Static DNS instead and you do not need to download the updater. Then proceed with the rest of the guide.

    I. Creating a Dynamic Domain Name:
    1. Goto DynDNS.com and register an account. 2. Once your able to log in, goto the Tab 'Services' ontop. 3. A short way down the middle of the page you'll see Dynamic DNS, click that. 4. To your right you'll see 'Create Host', click that.
      • Host Name: Can be whatever you want b. IP Address: Usually auto populated but if not, goto Myipaddress.com and copy that here. c. Check enable wildcard. d. Mail Exchanger: I doubt you have this considering your looking at this guide for help. Leave blank. e. Click on 'Add Host'
    2. Now click this link and download DynDNS Updater I would set it up as as a service, but it doesn't matter.
    3. If you have issues setting up DynDNS Update post what you dont' get in detail and I will help you.
    II. MANGOS Preperation:
    1. Goto \system32\drivers\etc\ and open the file called 'host' with notepad. (replace with the location of your windows folder.. i.e. c:\windows\system32\drivers \etc\)

      • At the end of the file (after all the text you see) insert this into it's own line:

      127.0.0.1 (Not sure if this is necassary, but mines working smile.gif )
      127.0.0.1
      example: 127.0.0.1wowjunkies.servegame.org b. Save and close
    2. Download Navicat HERE, install. (just get the lite version, not the trial)
      • Click on Connection

      Connection Name: (Whatever you want)
      Host name/IP address: locahost (unless you have it hosted on a server elsewhere us it's address)
      Port: Leave it as is unless you know you need something different which i doubt.
      User name: User name of your Mysql mangos DB
      Password: Password of your Mysql mangos DB
      Test your connection, if it doesn't work your username and password are wrong or you don't have your mangos DB running. b. Click OK and your done with setting up Navicat!
    3. In Navicat look in the Connections window and click the name of the connectoin you just made so it expands.

      a. Click on realmd b. In the right window double click realmlist c. Now change the field 'address' from 127.0.0.1 to d. At the bottom of the window click on the check mark to save or hit enter. e. Close that window and close Navicat
    4. This will also help solve Realm Looping if your having that, but realm looping is also caused by port forwarding if you don't know what your doing.

    III. Router configurations;

    If you have some generic router that for some reason only allows you to forward one port i can't help you. Throw it away and get a good router. And don't try to do this stuff wirelessly, because that's a whole nother set of issues and why you'd want to do that is beyond me.
    1. Disable Port Trigerring if you have the option. If not, just don't use it becuase it's an advanced feature that you need to know what it's for in order for it to work properly. Not necessary for your wow server to go public without hamanchi. 2. The following ports need to be opened and pointing to your servers router assinged IP address.

      - 3724 TCP (Enables you to connect to the Realmd DB) This port will give you the "Unable to connect" Message if not forwarded to your server. - 8085 TCP (Enables you to connect to the WorldServer?) This port is what causes realm looping if not pointing to your server IP and has the wrong protocol. Simply because you can't log into the mangos server so it kicks you back to the realmd server (realm list). - 80 TCP (This is only needed if your hosting a website frontend on the same server) - 3306 TCP (This allows connection to your DB in MySQL! Only open this if you need remote connection into your DB) BE SURE TO CHANGE THE PASSWORD OF ALL THE ACCOUNTS THAT HAVE ACCESS TO YOUR DB. WITH REPAKS THERE ARE ABOUT 4 ROOT/POWER USERS SETUP WITH THE PASSWORD MANGOS! CHANGE IT IMMEDIATELY!
    2. Make sure your servers router assigned IP address is the Default DMZ server. (Only put your server in the DMZ zone if your still having issues, if you have correctly configured the ports as stated above you should be good to go without having to do this step.)
    IMPORTANT!!!!! Antivirus applications and your firewall will also cause connection issues. Disable both to make sure you can connect, then enable if you can connect and see if it still connects. If not you will need to forward the same ports in your firewall. Sorry not gonna go through that or antivirus blocking issues.

    IV. Setting up your client to connect to your server:
    1. Go into your World of Warcraft game directory. Example c:\World of warcraft\ 2. Open the file realmlist.wtf with notepad. 3. Replace us.logon.worldofwarcraft.com with so it should look like this:

      set realmlist wowjunkies.servegame.org (or course entering your own domain name there)
    2. Save and close
    V. Q&A

    Q. What is my DB username and password?
    A. Depends on what repak your using and how you set up mysql. If your using repaks that come with mysql then it's usually mangos, mangos by default. If you setup mysql yourself, well then I couldn't tell ya.

    Q. I have a static IP address from my ISP, how do i get it to work with that?
    A. Use the Static host name instead of Dynamic and you do not need dynamic updater.

    Q. Does this work with a DLINK router?
    A. Not from my experience.

    Q. Its possible my antivirus blocking my ports?
    A. Yes some antivirus programs can do that.

    Q. Do i need to configure my firewall as well by forwarding the same ports?
    A. Most firewalls will automatically set this up for you the first time you use the app and try to access the net or access it from another computer. But if it hasn't then yes you do.

    Q. Which IP should you use with forwarding ports your static, lan, or wan ip? or dns server ip ?
    A. LAN

    Q. What if i can't get access to my router to forward the ports?
    A. Then you'll need to use Hamachi.

    THATS IT! You should have no issues connecting! Again if you have issues, please be detailed.. things like: Doesn't work.. This sucks.. Wont connect.. Still isn't working Or crying it's not detailed enough ...

    Tell me what steps you've takin and where your stuck and what exactly is happening.

    credits for dynamic ip goto jinxer (hs)
    Last edited by tomch; 21-04-08 at 09:59 PM. Reason: updated guide


  2. #2
    Account Upgraded | Title Enabled! Juggalo90 is offline
    MemberRank
    May 2007 Join Date
    MinnesotaLocation
    940Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    Very nice =]
    I perfer ascent still =]

  3. #3

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    well, i might add a version for ascent soon.

  4. #4
    Account Upgraded | Title Enabled! ovidel is offline
    MemberRank
    Nov 2007 Join Date
    RomaniaLocation
    232Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    Nice work i like it !

  5. #5
    Apprentice st6mm is offline
    MemberRank
    Mar 2008 Join Date
    7Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    Is it very buggy? in % please:)

  6. #6
    Apprentice st6mm is offline
    MemberRank
    Mar 2008 Join Date
    7Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3


  7. #7
    Apprentice st6mm is offline
    MemberRank
    Mar 2008 Join Date
    7Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    DBC extraction doesn't work, any ideas?

  8. #8

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    thanks for feedback ans stuff.
    sorry i didnt get to test this out myself.
    ill work on fixin that stuff.

  9. #9

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    k now i fixed it
    the dbc files are in there too, you dont need to extract them
    you just need to get the maps.
    it runs smoothly now, read the main post for details.

  10. #10
    Apprentice tasatir is offline
    MemberRank
    May 2007 Join Date
    9Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    I just tried setting up a server this way, but I had the same problem as the person above me who posted the screen shot. I downloaded this just 10 minutes ago so i should have the fixed file you mentioned yesterday

  11. #11
    Novice infirit is offline
    MemberRank
    Mar 2008 Join Date
    1Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    ▄ ▄▄░░▐
    ─────────────── ▐░▄▄▄░░▀▀▀
    [LorD TOm] ▐░░░▀▀
    ─────────────── ▀▀▀
    080322 19:02:19 InnoDB: Started; log sequence number 0 43655
    Can't start server: Bind on TCP/IP port: No such file or directory
    080322 19:02:19 [ERROR] Do you already have another mysqld server running on por
    t: 3306 ?
    080322 19:02:19 [ERROR] Aborting
    080322 19:02:19 InnoDB: Starting shutdown...

    That's all that happens when I try to start the batch folder from the file. Any suggestions?

  12. #12
    Apprentice themang is offline
    MemberRank
    Mar 2008 Join Date
    12Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    everything worked but when i opened wow and typed in my user name and password i got this error
    If you cant see the image it says "Unable to validate game version. This may be caused by file corruption or interference of another program. Please visit http://us.blizzard.com/support/artic...rticleid=21370 for more information and possible solutions to this issue"[IMG]file:///C:/Documents%20and%20Settings/Yoni/My%20Documents/My%20Pictures/world%20of%20warcraft%20file%20corruption.bmp[/IMG]
    [IMG]file:///C:/DOCUME%7E1/Yoni/LOCALS%7E1/Temp/moz-screenshot.jpg[/IMG][IMG]file:///C:/DOCUME%7E1/Yoni/LOCALS%7E1/Temp/moz-screenshot-1.jpg[/IMG]

  13. #13
    You don't know me. Paco44 is offline
    MemberRank
    Apr 2006 Join Date
    IllinoisLocation
    1,777Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    I thought this was for Ascent. Anyway, good job on your guide for those MaNGOS users out there.

  14. #14
    Apprentice themang is offline
    MemberRank
    Mar 2008 Join Date
    12Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    hum disregard that last post i figured it out but for anyone having the same problem its because you have the wrong version (patch) of wow but im having a new problem it wont load the characters and when i try to make a new character it wont work at all it says that it was made but then nothings there i checked the console and it said that it was because the file is missing or something like that it sounds like the problem you fixed maybe you posted the wrong file for download or something like that

  15. #15
    Novice WoodyB is offline
    MemberRank
    Apr 2008 Join Date
    1Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    Tried the new 4.95 repack and everthing appeared to work on install and setup. The error began when I tried to create characters for users. As above post mentioned. It says it creates it (even logs in Char.log), but nothing happens.

    Looking through Console I get repeated errors for every *.frm in the character subfolder at launch. (I can make it go away by deleting all *.frm files in that folder with no other behavioural changes)

    080409 17:09:38080409 17:09:38 [ERROR] Cannot find table 'character/*'
    from the internal data dictionary of InnoDB though the .frm file for the table exists.

    Looking in DBErrors.log any reference to the Character Table fails with:
    query ERROR: Table 'characters.*' doesn't exist.

    Same goes for the Server.log

    Everything seems to point to a corrupt or missing Tables\DB for Characters...
    Only Object in Characters Table is Bugreport
    Last edited by WoodyB; 10-04-08 at 06:25 AM.

  16. #16

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    hey guys
    sorry about the extra buggy releases
    i accidentally kept deleting important files in the repack
    this time i made sure i didnt do the same thing, and double checked.
    the new release includes some bug fixes and updates, and actually works this time.
    check the site for details
    enjoy

  17. #17
    Omega Loxx is offline
    MemberRank
    Apr 2006 Join Date
    CroatiaLocation
    5,386Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    Moved to mangos subsection

  18. #18
    Apprentice humster is offline
    MemberRank
    Apr 2006 Join Date
    LatvianLocation
    16Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    how i can put a SPORA website for this server, with AppServ i can'`t, becouse both need this MySQL, how i can put the SPORA WEB ?

  19. #19
    Novice Tanjitsu is offline
    MemberRank
    Apr 2008 Join Date
    1Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    Hey Tom looks like a nice package but i cant get it running.

    I used 4.97 and followed your guide.
    I have wow bc 2.3.3 installed.
    It extracted the maps fine and i moved them to the tompack dir.
    I run the sql service and its in taskmanager all fine.

    But when i goto the next step of running the realmd.exe it just pops a box up saying,

    The application failed to initialise properly (0xc0150002)

    Any idea whats causing it to not even start the server ?

  20. #20
    Apprentice saben is offline
    MemberRank
    Apr 2006 Join Date
    WisconsinLocation
    9Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    Quote Originally Posted by Tanjitsu View Post
    Hey Tom looks like a nice package but i cant get it running.

    I used 4.97 and followed your guide.
    I have wow bc 2.3.3 installed.
    It extracted the maps fine and i moved them to the tompack dir.
    I run the sql service and its in taskmanager all fine.

    But when i goto the next step of running the realmd.exe it just pops a box up saying,

    The application failed to initialise properly (0xc0150002)

    Any idea whats causing it to not even start the server ?
    I have the same issue :(

  21. #21
    Apprentice humster is offline
    MemberRank
    Apr 2006 Join Date
    LatvianLocation
    16Posts

    Help Me!

    i have problem with new patch! 2.4.1 !



    HELP ME

  22. #22
    Novice chrise112 is offline
    MemberRank
    Mar 2008 Join Date
    2Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    Hi all im new i got your 2.1.3 repack working easily but i cannot get this one working when i go to start it up in mangosd.exe it says
    characters.character table doesnt exsist..
    this is my error log
    2008-05-04 20:02:33 SQL: UPDATE characters SET online = 0
    2008-05-04 20:02:33 SQL ERROR: Table 'characters.characters' doesn't exist
    2008-05-04 20:02:34 SQL: SELECT MAX(guid) FROM characters
    2008-05-04 20:02:34 query ERROR: Table 'characters.characters' doesn't exist
    2008-05-04 20:02:34 SQL: SELECT MAX(guid) FROM item_instance
    2008-05-04 20:02:34 query ERROR: Table 'characters.item_instance' doesn't exist
    2008-05-04 20:02:34 SQL: SELECT MAX(id) FROM auctionhouse
    2008-05-04 20:02:34 query ERROR: Table 'characters.auctionhouse' doesn't exist
    2008-05-04 20:02:34 SQL: SELECT MAX(id) FROM mail
    2008-05-04 20:02:34 query ERROR: Table 'characters.mail' doesn't exist
    2008-05-04 20:02:34 SQL: SELECT MAX(id) FROM item_text
    2008-05-04 20:02:34 query ERROR: Table 'characters.item_text' doesn't exist
    2008-05-04 20:02:34 SQL: SELECT MAX(guid) FROM corpse
    2008-05-04 20:02:34 query ERROR: Table 'characters.corpse' doesn't exist
    please help on how to fix it



    these errors prevent me from creating characters...
    1) i log in [ Logs in fine i can see realm(s) ]
    2) I get into the character select [Fine]
    3) I click create character and create a character nothing appears [ Not so fine ] :(

  23. #23
    Apprentice spriggan is offline
    MemberRank
    Dec 2003 Join Date
    THAILANDLocation
    9Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    i have problem when i click mangosd.exe
    my pc had install dotnet 2.0 in windows xp sp2

    this error massages
    ---------------------------
    mangosd.exe - Application Error
    ---------------------------
    The application failed to initialize properly (0xc0150002). Click on OK to terminate the application.
    ---------------------------

  24. #24
    Enthusiast AT-XE is offline
    MemberRank
    Feb 2008 Join Date
    39Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    One only problem with the versions, how can I allow all versions?

  25. #25
    Apprentice Irineos is offline
    MemberRank
    Aug 2008 Join Date
    Trikala, GreeceLocation
    13Posts

    Re: [repack] [guide] tompack: noob friendly. easy server setup 2.3.3

    I have one question. Can I play it with newer versions???
    And something else. When will you create a newer version of tompack? Because I like new patches.
    I have only one suggestion:
    A Read me inside the topack achive with pictures of creating the server because I am stuck in how creating a gm account.
    And a graphic enviroment (perhaps) and not a command line.
    Last edited by Irineos; 08-08-08 at 01:35 PM. Reason: Wanted to add more.



Advertisement