[RELEASE]Manequin English Server/DB + Client Ready to use in one link

xD im going to try and get a laptop for stuff like this, but I'm only using my computer for testing, I have dedicated servers.
how do I add more RAM?

Ok, solved ACCserver crashing. However now I get these two additional problems. The MsgServ closes itself, and the ACCserver now displays this error. I've tried inserting the command:

Code:

---

SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('test');
ALTER TABLE `account`.`account` MODIFY COLUMN `password` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
insert into account.account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now());
grant all on account.* to 'ODBC'@'localhost';
grant all on my.* to 'ODBC'@'localhost';

---

Sorry, I know my general way around a computer usually using logic, I'm just not very familiar with making a server. I've had several failed attempts at a MapleStory server, and one semi-successful one.


I read that I can ignore the ACCserver error, but the MsgServ not running seems to make the client say "The server is down." :?:

umm why did you do that? theres no need to insert this kind of query at all
i see on your screenie that it cant connect to db
mm just make sure your database accept login root test its ready made database theres nothing to edit just run

@wesman dont only host eo on lappy it will die fast ;)

it say using password no that means the db dont connect with server becasue of password and i mean
ist messed up the root - test
user and pass. your navicat works? if works then the server can work too just relook inis or read other posts we explain the fix for taht i dont want to multiple post solves. but its nothing serious.
about RAM to commandcom said more above i strongly suggest 2GB at least so server can run easylly in home computers and HDD with sata2 cinnection no IDE. if you can get also HDD with 10200 cycles and no 7200 its way better idk alaso how expensive are in your country so just try the best if you want a good pc for server..

Quote:

---

Originally Posted by commandcom

@wesman dont only host eo on lappy it will die fast ;)

---

xD what?
laptop will be my new test computer when I get it, so I dont have to be on the family comp 24/7 xD
when everything is ready, I shall switch the files over to the dedicateds.

Ok well I can connect to navicat using root/test/my database stuff.

I dont see anything wrong with my inis...unless I have a blind spot.

account.ini

Code:

---

[Account1]
SERVERNAME=TEST
LOGINNAME=root
PASSWORD=test
FREE_DEBUG=3

---

config.ini (acc server)

Code:

---

[System]
LOGINLISTENPORT        = 9958
POINTLISTENPORT = 9865
SERVER_FULL_DELAY_SECS        = 5000
SERVER_BUSY_DELAY_SECS        = 3000
SERVERNAME =TEST
LOGINNAME =root
PASSWORD =test
SERVERIP =127.0.0.1
[Database]
DBHOSTNAME=127.0.0.1
DATABASENAME=my
DBUSER=root
DBPASSWORD=test

---

config.ini (game server)
[CODE];

xD im sure the whole DB is in "my" so edit the script you tried to use, and use this one :

Code:

---

SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('test');
ALTER TABLE `my`.`account` MODIFY COLUMN `password` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
insert into my.account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now());
grant all on my.* to 'ODBC'@'localhost';

---

How do I make my server public ?
I tyed following the instructions at How to make EO Server Online | So that ur Friends can Join :D

changed all ips bt database to an dyndns alias of the same machine I was using when the ip was 127.0.0.1

then I cant even fire all servers npc.exe saays it can log on account server

Thanks in advance,
JEx

P.S.
Anyone cacn point me to a sample phpsite for tthe server. Notthing fancyis needed. The server will not be public just a bunch of friend will be playng,

Allso points of full translated client and server messages would be great, portuguese if possible, if notenglishs is ok.

use hamatchi then it will work smooth
i did mess 2 days and same problem
is msgserver keep connecting or npcserver... no solution yet i need to test more ^^

so I setup hamatchi onall machines, crate a network and leavve all ini pointed to 127.0.0.1 on the sever folders and same at client ?

nop. you need to use hamatchi ip there

Edit: o_O i got over 1k posts in ragezone :D

I must be dumb....

accserver's config.ini

Code:

---

[System]
LOGINLISTENPORT        = 9958
POINTLISTENPORT = 9865
SERVER_FULL_DELAY_SECS        = 5000
SERVER_BUSY_DELAY_SECS        = 3000
SERVERNAME = eo_ace
LOGINNAME = root
PASSWORD = test
SERVERIP =my_hamachiip
[Database]
DBHOSTNAME=127.0.0.1
DATABASENAME=my
DBUSER=root
DBPASSWORD=test

---

Gameserver's config.ini
[CODE]
;

shell.dat aswell with hamatchi ip and you need to do it only with hex editor if you do it with notepad
file loose its formatting and server wont start
also accountserver account.ini theres only servername to change

account.ini was already changed

used the tool posted in other thread to create a shell.dat

now all servers work fine

the client, hhowever, is not connecting, says it cant find server or its under maitenance

I edited oem.ini to includde my server's himachi ip do I need to cchange something else there?

Thanks in advance,ad sorry to bother,
JEx

By the way, oem.dat was also changed, msg is now server down

its oem.dat now they changed it awhile ago
also
go to accserver folder open AuthorizeDB.cfg

Code:

---

127.0.0.1 root test my account name password id
count_stat server_name status
127.0.0.1 test 4871344843773d3d111 my

---

change it to

Code:

---

127.0.0.1 root test my account name password id
count_stat server_name status
127.0.0.1 root 4871344843773d3d111 my

---