Forum :: EOSERV :: Exile's Eoserv Setup Guide [Newb Proof]

Requirements

Mysql -> Download

Codeblocks -> Download

Eoserv Rev 112 -> Download

Winrar -> Download

Required Files -> Download

Navicat -> Download

Instructions

Part 1a:

   Run "mysql-essential-5.1.34-win32.msi"

   Press Next

   Click Custom

   Press Next

   Click the arrow on "C Include Files / Lib Files"

   Change it to "This feature will be installed on local hard drive."

   Find where it says "Install to:"
   Press the "Change..." button across from it
   Change "C:\Program Files\MySQL\MySQL Server 5.1\" to "C:\MySQL\"
   Press Ok
   Press Next
   Press Install
   Make sure configure now is checked
   Press Finish

Part 1b:
   Press Next
   Press Next
   Press Next
   Press Next
   Press Next
   Press Next
   Check "Add firewall exception for this port"
   Press Next
   Press Next
   Press Next
   Enter a password and remember it
   Check "Enable root access from remote machines"
   Press Execute
   (If you get a error post it here because ive gotten many during this step)

Part 2a:
   If you have a router go find it and find the model number.
   Find it here
   And follow the guide to portforwarding
   If you do this successfully you should forward these ports (8078 & 3306)
   (If you cant portforward skip this step and move on to Part 2b)

Part 2b:
   This part is for those of you who cant port forward. This is annoying and if you dont like it then
   you shouldnt have a server because this is your last resort.
   Hamachi -> Download
   Click download on the window's one
   (Note: Anyone who wants to connect to your server will require hamachi)
   Run "HamachiSetup-1.0.3.0-en.exe"
   Press Next
   Click "I accept the agreement"
   Click Next
   Click Next
   Click Next
   Click Next
   Click Install
   Click Next
   Click Finish
   Click the Power button (Its on the bottom left corner of hamachi)
   Create a nickname
   Click the triangle (Its the first button to the right of the power button)
   Click "Create a new network"
   Create a network name (Generally this would be the name of your server)
   Create a network password (What ever you wish)
   (For anyone to connect they must have hamachi and must login to you server using the
   "networkname" & "network password" you created)

Part 3:
   Run "codeblocks-8.02mingw-setup.exe"
   Press Next
   Press I agree
   Press Next
   Press Install
   Press No
   Press Next
   Press Finish

Part 4a:
   Run "wrar380.exe"
   Press Install
   Press Ok
   Press Done
   Close the window that pops up

Part 4b:
   Open "eoserv-trunk-r112.tar.gz" (It should now open with winrar)
   Click on "trunk"
   Click & Drag it to your desktop (It should automaticly extract itself to your desktop)
   Close winrar
   Open the folder that you just extracted ("trunk")
   Double click on "config.ini"
   Scroll down until you find "### DATABASE ###"
   Change "DBUser = eoserv" to "DBUser = root"
   Change "DBPass = eoserv" to "DBPass = ThePasswordYouSet" (Make sure you replace
   "ThePasswordYouSet with the actual password you set during the mysql installation)
   Now press Ctrl & S at the same time
   Close notepad (config.ini)

Part 4c:
   Open "Required.rar"
   Extract it to your desktop the same way you did eoserv-trunk-r112.tar.gz
   Close winrar
   Open the folder "Required"
   Move "Include" to your trunk folder
   Move "libmySQL.dll", "pthreadGC2.dll", & "sqlite3.dll" to your trunk folder
   Move the folder data to your trunk folder
   Click Yes to all

Part 4d:
   Press the start button on the taskbar (The bar on the bottom of your screen)
   Click My Computer
   Double click on Local Disk (C:)
   Double click on the folder "Mysql"
   Click on the folder "include"
   Press Ctrl & C
   Goto your trunk folder and press Ctrl & V
   Press Yes to all

Part 5a:
   Go into your trunk folder
   Go to the project folder
   Double click on "mingw.cbp" (Codeblocks will open)
   Click Settings
   Click "Compiler and Debugger..."
   Click the tab called "Search directories"
   Click the button "Add"
   Click the "..."
   Navigate to your trunk folder and select the include folder then press "OK"
   Highlight everything in the box (Ex. "C:\Documents and Settings\Exile\Desktop\tutorial\trunk
   \include")
   Press Ctrl & C
   Press "OK"
   Click the Linker tab
   Press "Add"
   Press Ctrl & V
   Press "Ok"
   Click the Resource compiler tab
   Press "Add"
   Press Ctrl & V
   Press "Ok"
   Click the Linker settings tab
   Press the "Add" button
   Press the "..." button
   Navigate to your trunk folder
   Go into the include folder
   Click on "libmysql.lib"
   Hold ctrl & click on "libpthreadGC2.a"
   Press "Open"
   Press "Ok"

Part 5b:
   Find where it says "Build target:"
   Change it from "Debug" to "Release"
   Click the gear to compile "The button all the way to the left of the "Build target:""
   You shouldnt get any errors if you followed this tutorial step by step.
   It should have compiled

Part 5c:
   Run "navicat8_mysql_en.exe"
   Press Next
   Click "I accept the agreement"
   Press Next
   Press Next
   Press Next
   Press Next
   Press Install
   Press Finish
   Now run Navicat (Eaither run it from Start->Programfiles or from the shortcut on your
   desktop)
   Deal with the trial for now or go buy it navicat is a great program
   Double click on the "localhost" thing on the left of navicat
   Enter your password you chose during the mysql setup and press ok
   Right click on the "localhost" thing on the left of navicat
   Click "New Database"
   Name it "eoserv"
   Press Ok
   Double click on the database "eoserv"
   Right click on the database "eoserv"
   Press "Execute batch file..."
   Press the "..." button
   Navigate to your trunk folder
   Double click on the install.sql file
   Press "Start" and it should be successful
   Press "Close"
   Right click on the database "eoserv"
   Click "Close database"
   Double blick on the database "eoserv"
   All the tables should be in there.
   Now run "Eoserv.exe"
   It will say "Redirecting errors to 'error.log'..." thats normal its because it cant find all the
   map files.
   You should be able to connect to your server by changing eo's ip to your ip(you can get it
   at ipchicken.com) or if you used hamachi you use your hamachi ip.

Also related to the mysql execute try doing the portforwarding or hamachi before doing the mysql.

-Request to sticky or set as main installation guide-
I spent over 2 hours making this please show respect for me taking my time to create this.

Credits
Created by: Exile(Aka: Deathx)
Owner of Exile Studios

---
¨°º¤ø„º°¨ Exile Studios ¨°º„ø¤º°¨

Good idea.  Helped me get a few bugs out of the way.  Thanks.

No prob, i mainly did it so the newbs would leave sausage alone so i tried making it newb proof and tried covering everything.

---
¨°º¤ø„º°¨ Exile Studios ¨°º„ø¤º°¨

Great guide. Although, There is no need to portforward the MySQL port (3306) or enable remote root access. It's actually a security risk. The only time you'd need to forward the port would be if you are using a WebCP/etc. thats on a remote machine. I would recommend you create another user if you're doing that. 

If you can't figure out portforwarding, Feel free to add me on MSN, and I'll fix it. (ONLY PORTFORWARDING!)

I might also add, some routers have a built in firewall, such as mine, and portforwarding with it, doesn't always necessarily add an exception to the firewall list, and sometimes it won't allow you to do it manually. for cases such as this the user should enable Demilitarized Zone('DMZ')

Also, I believe the hamachi part isn't the only option of getting someone on your server if you can't portforward. iirc if only one machine is connected to the internet, and you open up the port, they should be able to connect to the Wan IP. I'm probably wrong on this, but I think it's when I only had one computer with no router. It's been a while.

As for stickying the topic... Can't (let you) do that, Starfox. if it becomes the main guide, then so be it. many other people took time to make guides, but it's really directly dependent on how many people post in the guide, and continue bumping it with questions and whatnot.

Thank God... No. Actually, thank you!

Every time I get an IM, "How did you fix your problems?" I don't have to help them. I can just send them this link xD

Another thing, it helped out little tiny bugs that I just assumed were EOServ :o Woot!

I threw in the extra stuff like "add an exception to the firewall list" to avoid listening to newbs complaining about not being able to connect cause of windows firewall blocking it. Also i threw in the port forwarding for mysql cause xD i have my own webserver on my computer also so i didnt really know if it was needed or not for only eoserv. But overall i belive i did a pretty good job its just a lil rough around a few edges. Not bad for doing it in 2 hours without going back over and revising and editing.

---
¨°º¤ø„º°¨ Exile Studios ¨°º„ø¤º°¨

Oh, I have one more thing to add. XD

Some modems have a firewall as well. It took me over 30 minutes to fiugre out the problem with one guy's computer. The solution was to open all ports (DMZ) to the router. Then the router firewall is all that matters.

Okay. iv tried this. but with mysql it cant apply security settings. i get this error.

This is really starting to get at me. i cant make scotts precompiled rev112 to work on easywamp. and mysql wont actually install for me. any help is MUCH appreciated.

Edited By Scott: Please scale your images. They break the layout if they're so big.

Nerrevar posted: (6th Jun 2009 01:47 pm)

Okay. iv tried this. but with mysql it cant apply security settings. i get this error.

This is really starting to get at me. i cant make scotts precompiled rev112 to work on easywamp. and mysql wont actually install for me. any help is MUCH appreciated.

That would be because you didn't uninstall MySQL completely and now you can't set it up without knowing the old root password.

Whe I press the build button on codeblocks I got this in the message box

"eoserv - Release" uses an invalid compiler. Skipping...
Nothing to be done.

If you get the invalid compiler error, just follow these instructions:

1. On the top of codeblocks, click the "Settings" menu

2. Select "Compiler and Debugger"

3. On the taps that start with "Compiler Settings", click the "Toolchain executables" tab

4. Find where it says "Auto-detect", click it.

5. After it detects it, click okay to exit the compiler's settings.

You should then be able to compile.

I was working on the MySQL Setup, and manage to mess up step 1, go me!

1- Before.

2- After.

well Lens you keep trying the same thing again and again until it works xD

Lens you have another program that is using the mysql port.  End that program and try again.