Forum :: EOSERV :: How to set up a local and public EOserv Detailed !!

Ok first off you need to download MySQL

doesnt really matter what version you have,

you can download 5.0 from here.

When installing MySQL make sure that you choose

the complete install

(this will make you the include folder some people are missing )

you will only need the include folder if you are planning on making

your server public. when you are installing MySQL it will ask you

to put apasswordmakeitsomething easy to remember like your

name or just qwerty you will need to remember this for later.

When it askes you what port you would like leave it as 3306.

 Next download heidiSQL you can download it from here

when you have installed HeidiSQL you then need to download

the latest version of EOserv from the download section or just

click here to save time.

When you have downloaded Eoserv make a folder on your desktop

and name it what ever you want e.g. Eoserv then you need to

extract the files from the Eoserv.rar to your folder on your desktop

when you have extracted the files you then need to open the Install file

you should get a box like this  



The boxes circled red you must leave depending on how

you set up MySQL this should be the same on yours.

You user name will be root and you password will be the

same password you used when installing MySQL e.g. you name or just qwerty.

when you press connect you then need to go to Tools and then new database like this


you must call the database Eoserv if you dont then you cant run it.

now select you new database from the server selection




and go across to query you should see this



Make sure that you highlight all the code. this -----/


CREATE TABLE IF NOT EXISTS `accounts`
(
    `username`   VARCHAR(16) NOT NULL,
    `password`   CHAR(64)    NOT NULL,
    `fullname`   VARCHAR(64) NOT NULL,
    `location`   VARCHAR(64) NOT NULL,
    `email`      VARCHAR(64) NOT NULL,
    `computer`   VARCHAR(64) NOT NULL,
    `hdid`       CHAR(10)    NOT NULL,
    `regip`      VARCHAR(15) NOT NULL,
    `lastip`     VARCHAR(15)          DEFAULT NULL,
    `created`    INTEGER     NOT NULL,
    `lastused`   INTEGER              DEFAULT NULL,

    PRIMARY KEY (`username`)
);

CREATE TABLE IF NOT EXISTS `characters`
(
    `name`        VARCHAR(12) NOT NULL,
    `account`     VARCHAR(16)          DEFAULT NULL,
    `title`       VARCHAR(32)          DEFAULT NULL,
    `home`        VARCHAR(32)          DEFAULT NULL,
    `partner`     VARCHAR(16)          DEFAULT NULL,
    `admin`       INTEGER     NOT NULL DEFAULT 0,
    `class`       INTEGER     NOT NULL DEFAULT 0,
    `gender`      INTEGER     NOT NULL DEFAULT 0,
    `race`        INTEGER     NOT NULL DEFAULT 0,
    `hairstyle`   INTEGER     NOT NULL DEFAULT 0,
    `haircolor`   INTEGER     NOT NULL DEFAULT 0,
    `map`         INTEGER     NOT NULL DEFAULT 192,
    `x`           INTEGER     NOT NULL DEFAULT 7,
    `y`           INTEGER     NOT NULL DEFAULT 6,
    `direction`   INTEGER     NOT NULL DEFAULT 2,
    `spawnmap`    INTEGER     NOT NULL DEFAULT 192,
    `spawnx`      INTEGER     NOT NULL DEFAULT 7,
    `spawny`      INTEGER     NOT NULL DEFAULT 6,
    `level`       INTEGER     NOT NULL DEFAULT 0,
    `exp`         INTEGER     NOT NULL DEFAULT 0,
    `hp`          INTEGER     NOT NULL DEFAULT 10,
    `tp`          INTEGER     NOT NULL DEFAULT 10,
    `str`         INTEGER     NOT NULL DEFAULT 0,
    `int`         INTEGER     NOT NULL DEFAULT 0,
    `wis`         INTEGER     NOT NULL DEFAULT 0,
    `agi`         INTEGER     NOT NULL DEFAULT 0,
    `con`         INTEGER     NOT NULL DEFAULT 0,
    `cha`         INTEGER     NOT NULL DEFAULT 0,
    `statpoints`  INTEGER     NOT NULL DEFAULT 0,
    `skillpoints` INTEGER     NOT NULL DEFAULT 0,
    `karma`       INTEGER     NOT NULL DEFAULT 1000,
    `sitting`     INTEGER     NOT NULL DEFAULT 0,
    `bankmax`     INTEGER     NOT NULL DEFAULT 20,
    `goldbank`    INTEGER     NOT NULL DEFAULT 0,
    `usage`       INTEGER     NOT NULL DEFAULT 0,
    `inventory`   TEXT        NOT NULL,
    `bank`        TEXT        NOT NULL,
    `paperdoll`   TEXT        NOT NULL,
    `spells`      TEXT        NOT NULL,
    `guild`       CHAR(3)              DEFAULT NULL,
    `guild_rank`  INTEGER              DEFAULT NULL,
   
    PRIMARY KEY (`name`)
);

CREATE TABLE IF NOT EXISTS `guilds`
(
    `tag`         CHAR(3)     NOT NULL,
    `name`        VARCHAR(32) NOT NULL,
    `description` TEXT        NOT NULL,
    `created`     INTEGER     NOT NULL,
    `ranks`       TEXT        NOT NULL,
    `bank`        INTEGER     NOT NULL DEFAULT 0,

    PRIMARY KEY (`tag`),
    UNIQUE      (`name`)
);

CREATE INDEX `character_account_index` ON `characters` (`account`);
CREATE INDEX `character_guild_index` ON `characters` (`guild`);

and then press the little bule arrow (the one with a red circle

arround it) If you get a error then you need to make sure

that you have click the server you make on the side also circled in red.

if you do this and get no errors then look in the bottom

corner for the green light if you have this then your almost done.


Now you need to open the config.ini in your folder on your desktop.

and change the settings to these..


### LOGGING ###

## stdout
# Filename to log normal output
# Use - for console output
LogOut = -

## stdout
# Filename to log errors
# Use - for console output
LogErr = error.log


### SERVER ###

## Host
# The IP address the server should listen on
# 0.0.0.0 = all
Host = 0.0.0.0

## Port
# The port the server should listen on
Port = 8078

## MaxConnections
# The maximum number of connections the server will open
MaxConnections = 300

## ListenBacklog
# The maximum number of half-open connections that can be queued up
ListenBacklog = 50

## MaxPlayers
# The maximum number of players who can be online
MaxPlayers = 200

## MaxConnectionsPerIp
# The maximum numbers of connections one IP address can open
MaxConnectionsPerIP = 2

## PasswordSalt
# Enter any large amount of random characters here
# WARNING: Changing this will break any existing users' passwords.
PasswordSalt = ChangeMe


### DATABASE ###

## DBType
# Database type (mysql or sqlite)
DBType = mysql

## DBHost
# MySQL hostname / SQLite filename
DBHost = 127.0.0.1 <make sure that its 127.0.0.1 not localhost

## DBUser
# Database username (MySQL only)
DBUser = Root <-- change to Root

## DBPass
# Database password (MySQL only)
DBPass = Password (what you made you password for MySQL)

## DBName
# Database name (MySQL only)
DBName = eoserv <-- do not change this

now save the changes and then open eoserv-debug when this is open dont close it.

you will get this error

Could not load file: ./data/maps/00080.emf
Could not load file: ./data/maps/00081.emf
Could not load file: ./data/maps/00185.emf
Could not load file: ./data/maps/00223.emf
Could not load file: ./data/maps/00264.emf
Could not load file: ./data/maps/00271.emf
Could not load file: ./data/maps/00272.emf
Could not load file: ./data/maps/00276.emf

as the maps are missing but this doesnt matter.

now open eo and make your accounts and login!!

how to make yourself / others a Admin


ok now your database should be set up go to

you database on heidiSQL and connect then go

to database on the tabs and click characters and

then use the search box to find your name change

the Admin from "0" to what ever admin you wish to be or you want other people to be

# 0 = Player
# 1 = Light Guide
# 2 = Guardian
# 3 = Game Master
# 4 = High Game Master

now press the ok button and it should change.

if you change anything else such as hairstyles you must not be logged in to eo.

Now you have your own server to play on and you have admin powers.

#---- Make your server Public ----#

i will do this tomorro i did the 1st part late last night.

hey it works... sorta when i get to the debug it doesnt say the error it just says terminated. that's all do you know why this is?

go to the error log.txt and then look what the error is and post it here then i can help if you get the error

Database_OpenFailed: Access denied for user 'Root'@'localhost' (using password: YES)

then you are not using the same password as you used for the MySQL install

Zettz posted: (4th Apr 2009 01:04 am)

hey it works... sorta when i get to the debug it doesnt say the error it just says terminated. that's all do you know why this is?

look when edit the config u prolly need to change it like this

### DATABASE ###

## DBType
# Database type (mysql or sqlite)
DBType = mysql

## DBHost
# MySQL hostname / SQLite filename
DBHost = 127.0.0.1

## DBUser
# Database username (MySQL only)
DBUser = root

## DBPass
# Database password (MySQL only)
DBPass = passwordhere

## DBName
# Database name (MySQL only)
DBName = mysql    <<<that is what hung me up for soo long cause  when u set up mysql thats the default so try that.

ive got it to work. its just it wont go public the host ip is 0.0.0.0 i have to have it on there. if not i open eoserv and it just shuts right away not saying anything, Why is this happening?

look in the error.txt text document and tell us what it says

Socket_BindFailed: The requested address is not valid in its context.

HeidiSQL process doesnt work when i try to duplicate that text it says (SQL error: duplicate key name 'Character_account_index') How can i avoid it?

nick posted: (6th Apr 2009 08:04 am)

HeidiSQL process doesnt work when i try to duplicate that text it says (SQL error: duplicate key name 'Character_account_index') How can i avoid it?

 

 

/* SQL Error: Duplicate key name 'character_account_index' */, How do i fix this.

On HeidiSQL, I type in the pass and clicked connect but then it says

Could not establish connection details:

SQL Error: Cannot connect to MySQL server on 127.0.0.1 (10061)

can you put a pic of where it is cause i cant find it

Two One problem,

First : When i highlight the code then press the blue arrow,i get SQL Error : Can't create table '.eoservaccounts.frm' (errno : 121)

Second : Database_OpenFailed: Access denied for user 'Root'@'localhost' (using password: YES)

Even though,i set all the passwords to QWERTY i get the same error.. RESOLVED

Help would be greatly appreciated

I did all the steps correct, 'till I got to the EOSERV-DEBUG, it does nothing. Also there's a new file called error and it says "Database_OpenFailed: Access denied for user 'Root'@'localhost' (using password: YES)" Help?