Forum :: EOSERV :: How To Set Up EOServ Rev103 using MySQL

Hello,

It seems a lot of people are having issues setting up EOServ and Seose. I'll cover Seose in a different tutorial. If you follow the step's below you shouldn't have a problem at all. I will be using Revision 103 with MySQL.

Step 1: Download all the necessary software/tools.

    * MySQL: http://dev.mysql.com/downloads/ (Community Edition)
    * EOServ Revision 103: http://www.mediafire.com/file/2rwqnvdemyy/Revision103.zip (Brought to you by xsepx)
    * HeidiSQL: http://www.heidisql.com/download.php
    * DynDNS Update Client: http://cdn.dyndns.com/windows/DynUpSetup.exe (Only required if you do not have a static IP or just wish to use a hostname)


Step 2: Install MySQL
1. Launch the installer.
2. Choose "Typical" setup type, click "Next", click "Install", click "Next" two more times, and finally click "Finish". (Be sure to leave "Configure the MySQL Server now" box checked)
3. You should know see a "MySQL Server Instance Configuration Wizard" window. Click "Next", then slect "Standard Configuration" and click "Next" once more, Click "Next" again, You now need to set a root MySQL password, enter the password you choose twice and click"Next"(We will use root pass forthis tutorial), finally click "Execute", and then click "Finish". (If all went well you should see the following message before clicking "Finish": Configuration file created, Windows service MySQL installed, Service start successfully, Securitysettingsapplied.

Step 3: Install HeidiSQL
1. Launch the installer.
2. Click "Next", Read the "License Agreement" and then select the "I accept the agreement" bubble, then click "Next", click "Next" three times, click "Install", and finally click "Finish". (Minimize HeidiSQL once it launches)

Step 4: Configure EOServ Rev. 103
1. Open the ZIP File called "Revision103.zip", click "Extract all files", Change the "Files will be extracted to this folder:" path to the location you wish to run EOServ from (We will choose the "Desktop" as the location).
2. Open the folder which contains the EOServ files, Open the folder called "Trunk".
3. Maximize HeidiSQL, Use the connection settings below, then click "Connect"
Hostname/IP: 127.0.0.1
User: root
Password: (The password you chose for root)
Port: 3306
4. Select "Tools" and click "Create database", Type "eoserv" into the "Name:" field, and click "Ok".
5. Select "Import" and click "Load SQL file", Navigate to the directory to which you extracted the EOServ files, select "install.sql" and click "Open", then press F9.
6. Close HeidiSQL.
7. Open the "config.ini", change the "Port" setting if you wish, change the "PasswordSalt" settings to a random string of characters, under the "Database" section of the file change the "DBUser" to "root" and the "DBPass" to the password you set up for the root account.
8. Either save and close the file or minimize the text editor.
9. Follow the first 3 steps at: http://www.dyndns.com/services/dns/dyndns/howto.html (You will need to install the "DynDNS Update Client" you downloaded in Step 1), Login in the Update Client with the account you signed up for and select your "hostname" to update, Click "Ok".
10. Reopen or Maximize the "config.ini" file, go the "SLN" section, change "SLNHost" to the "hostname" you set up at DynDNS, change the "SLNSite" option to your website (not required), and change the "ServerName" to the name of your server, and finally save the file.
11. Change any other setting in "config.ini" and "admin.ini" to your liking. (No other changes are required though.)
12. At this point you should be able to launch "eoserv.exe" and login after changing your Endless Online Client's IP/Hostname and Port (if applicable), if "eoserv.exe" immediately closes or Endless Online doesn't login/register you have not completed something correctly.

Step 5: Portforward
 1. You know can locally play, but if you have a router, anyone that is not on your local network cannot play.
 2. Go to: http://www.portforward.com/english/routers/port_forwarding/routerindex.htm and find your router. You can use any guide for that router basically, as long as you choose TCP and use the correct port and local IP address.
 3. You should be good to go! Enjoy playing!


Thanks for reading this tutorial, would it be helpful if I created a tutorial for Seose as well?

Also, I don't quite understand the formatting on here... Mods feel free to fix... Lol.

EDIT BY SORDIE: Formatting fixed =]

Note: I am not responsible if you harm your computer in any way, shape, or form.

Nice guide, and thanks for giving credits to me for compiling the Rev 103.

Don't you just love it when everyone shares!? :D

Any idea what is wrong with my formatting?

I'm not understanding what is the problem everyone is having, mine works perfectly fine with mysql.

This isn't a tutorial on how to compile it... It's a complete tutorial on how to set it up...

Great Guide Scott, Keep up the good work

P.s: I cant be assed to fight anymore, Can we just make up and be friends again?

Fixed the formatting for you Scott. =]

EDIT: Woo! This is my 300th post!

---
http://sordie.co.uk
http://twitter.com/@SordieEO

Nice Sordie :)

Thank you Sordie..

Wow thanks for that, and i have a problem though everytime i run the server my firewall comes up and after i click unblock and an error comes up. Then it closes out any suggestions?

Can you post a link to the screen shot of the error?

Thank you for the guide i had already did these steps withought it yet i still get some error.  I start it up and it loads every thing and withen about 5 seconds i get an error that it has to close the program.  I have tried using sqlyog but still same problem.  

Roach posted: (14th May 2009 10:48 pm)

Thank you for the guide i had already did these steps withought it yet i still get some error.  I start it up and it loads every thing and withen about 5 seconds i get an error that it has to close the program.  I have tried using sqlyog but still same problem.  

Here is a screen of my prob.

[IMG]http://i40.tinypic.com/5x1qg2.jpg[/IMG]

Your port is not correct. Why are you running EOServ on port 3306? That's the MySQL port... It should be something else. The default is 8078.

followed it to the letter except for port forwarding because i wanted to just go on myself first and it doesn't work!  I have heidisql running, i start either eoserv.exew or eoserv-debug.exe and then everything comes up, it looks fine, butthen in about 4 seconds it crashes and closes. i looked in error log and there is no error.

rariyokuu posted: (15th May 2009 11:35 pm)

followed it to the letter except for port forwarding because i wanted to just go on myself first and it doesn't work!  I have heidisql running, i start either eoserv.exew or eoserv-debug.exe and then everything comes up, it looks fine, butthen in about 4 seconds it crashes and closes. ilookedin error log and there is no error.

Hi, I've checked the guide for errors, and I did not find any. I completed the guide on a virtual machine and it succeeded fine. If you will add me on Windows Live Messenger, I'll help you. My WLM account is: [removed]

I think I may know the problem, but I would need to remotely connect and check for myself. If I'm not online or am away just leave me a message.