How to setup the famous Shaiya server without problems

[skater_1997]

ugh come dude this is my last question i will never ask u for problems i am gonna make it by my own and i search but i still don't found and still searching about my error PLEASE PLEASE I beg u to help me this error and i hope i will never need your help about server if you want to help me



P.S u tell me once cuz u gonna help me to make and i have just this little error so come on dude

[Polypropylen]

skater1997:
your picture with the error isn't available!the browser is loading a long time, after that it breaks the connection

and, i'm sorry, i have to report you because of your doublepost!

[baldracca]

hmm... i deleted all table, deleted server folder and reinstalled all (yes, 10-15min about)... the problem remains "name already in use" tried with ep3 (v40) and ep4 (v51). I tried to reinstall 3 times.
First time i ran game i got only "easy mode" and "normal mode" available, second time "hard mode" too but not "ultimate mode". This happened before reinstallation too.
I tried to install on a Virtual Machine (vmware) but when i do "ok" on "select server" screen it show me: "failed to connect to game server!!!" and on VM all run (no error in log file). Im only unlucky i think...
Im stuck and angry eheh.
Can u tell me how to insert directly in db a new char? I have no idea, i know a bit mysql but nothing about mssql.

Tyvm anyway

P.S.
i found this

GO TO

SQL Database - PS_GameData - CHAR - design table and change Maketime in varchar

Tried but problem remains

[skater_1997]

k thank you and sorry for double post im just want to ask how i can slove that problem

[claudeD]

[hi my name is claude and i have problems to find subfolder shaiya it is not there pls help me 2 months im bussy for thise server and nothings works what i do wrong plsss QUOTE=Danco1990;2966759]Hey all,

It took me a while myself to know all the errors that this thing can bring up, so i thought of making my own tutorial to make sure everyone is possible to create a server, without any problems. If u still got problems, just post it here, and i look if i recognize them, if not, i will help you fix them. I gave up my ep4 server, and deleted all the files, because there was too much whining about my core, so Final Destiny Shaiya is discontinued!

Let's get started, here is what you will need for OPTIMAL performance:

-Windows XP SP3 updated to the max (I know that XP works, i dont give support for other operating systems!) Make sure ur working on a useraccount named Shaiya with as password shaiya123.

-ISS (This is requered for some extra options with the SQL program we are going to use: go to configuration screen, press add and remove programs, go to 3d tab, and make sure ISS is checked! You will need the XP cdrom if u install it from here)

-M$ SQL 2005 STANDARD! No express! you can get a copy here:
This is a 180-day trial, this will be enough to play around with, for now, we use this. Some people cant download it from here due to land specific search rules, so find ur own copy here:

The server files:

You will also need a D:\ drive, if you dont have one, look here: Dont ask about this in here...

Lets get started

First of all, install all the programs listen above, should not be hard, if you cant do this, give up... With the SQL installation, make sure u use Mixed Mode Authentication Win NT & SQL Authentication with as password "shaiya123". also make sure that in the configuration the connection is set to both tcpip and named pipes! When u activated these things, restart the SQL services to activate the changes.

Forward these ports on your router if u have one:

1433 - SQL (for remote connections like link server used by session)
30800 - ps_login.exe
30810 - ps_game.exe
30900 - ps_session.exe
30901 - ps_userLog.exe, ps_userLog.exe, ps_userLog.exe
30911 - ps_dbAgent.exe
30912 - ps_gameLog.exe
40900 - PSM_Agent.exe

Extract the server files with an archive unpacker, and copy the files to "D:\SHAIYA_SERVER\SERVER". Make sure u use this path, otherwise it wont work! (to check if u have the right path, look in D:\SHAIYA_SERVER\SERVER and see if u have the files in there, and not the folders u just extracted)

Run Install_Server.bat in the subfolder SHAIYA.
Press space at times when asked, no errors are allowed to show up!
If there are any errors, post some screenshots here, and ill take a look at it!

When its done and u have the server patch config, go to Server Setup and press Apply to Windows Registry. When this is done, close the screen, the prompt will tell you to reboot, press space.

After your computer has rebooted, go to your D drive, the shaiya server folder, then shaiya then PSM_Server and open PSM_ServiceMgr.exe in there (copy the shortcut to your desktop for easier maintanance) close it, and open it again. This should give you all green crosses. In the menu Server Setup press on Service Install All. Wait, this could take a while.

When it its done, it should show all services "paused". In the menu Control Service press on Start All Server Service. Wait again. if all services stay on "play" ur server should be running, if not, make sure all config files are right, in psm_client/bin/logs. When it all stays on "play" press right mouse button on Login01 and click on command. Insert the command /vchkoff and press enter. Close this screen now. now do the same with Game in gamegroups, but then with the command /nprotectoff. In here, u can also do /exp2xenable [x] where x is the number of the multiplier of the experience rate ingame.

Congratiolations! your server is up and running and ready for connections. Make sure you use the fully updated client from aeriagames, and patch it with an ep3 client, google the web!.

For people who want to make the game.exe too for the client, open the game in HxD (free download, just google) find ip 72.55.177.194, and replace it for your ip adress. Use local (192.168.X.X) for local connections only, and your WAN ip to play over the internet too.

If you want your server to be public, ONLY change the public ip in the server patch config!, press apply, and restart it.

Once again, if something doesnt work, post here, and ill try to help!

Credits go to the chineze dude who got these files, and all people on here who helped me too

Thank you for reading and good day


P.S.
If u like my help, please thank me [/QUOTE]

[N4ZB34T]

Ok, got everything running to "play", except for session. And after a few secs, everything goes back to "pause". Help please?

[baldracca]

Did u check if there r errors in logsession file?
Sometimes is enough to restart manually but if all goes in pause maybe u got some problem in db.

Anyone can tell me how to insert a new toon directly by db?
INSERT INTO what_table (what_Column…)
VALUES (what_values…)
or something like this?

[Radioz]

Okay I'm having some issues getting SQL server 2005 to work...<_<.

Will post screenshots in about 8hours XD

[claudeD]

my server works 4 houres and now not more what do i wrong i restart pc and al gone pfff


2009-09-18 08:30:41 PS_USERLOG__system log start (UserLog)

2009-09-18 08:30:41 connect

2009-09-18 08:30:44 connect

2009-09-18 08:30:50 connect

2009-09-18 08:52:13 1 1 SAgent:isconnect: (4, 64)

2009-09-18 08:52:13 1 1 T=000:21:00:000, RC=5,RCS=0, RB=53,RBS=0, SC=4,SCS=0, SB=16,SBS=0

2009-09-18 08:52:13 disconnect




2009-09-18 08:30:41 PS_SESSION__system log start (Session)

2009-09-18 08:30:45 connect login

2009-09-18 08:30:50 connect game

2009-09-18 08:52:13 1 1 SAgent:isconnect: (4, 64)

2009-09-18 08:52:13 1 1 T=000:21:00:000, RC=134,RCS=0, RB=1105,RBS=0, SC=8,SCS=0, SB=131,SBS=0

2009-09-18 08:52:13 disconnect login



2009-09-18 08:30:44 PS_LOGIN__system log start (Login01)

2009-09-18 08:33:21 <Console input> /help

2009-09-18 08:33:21 <Console output> /h /help /quit /exit /shutdown/CrashDump

/mem(0) /uc(0) /sl(0) /adminopen(0) /adminclose(0) /vchkon(0) /vchkoff(0) /cstop(0) /cstart(0) /vchg(1) /si(0) /setmaxuser(1) /hide1svr(0) /show1svr(0) /showallsvr(0)

2009-09-18 08:33:48 <Console input> /mem

2009-09-18 08:33:48 <Console output> SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=0(1024/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=0(1024/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(0/0)

2009-09-18 08:34:05 <Console input> /uc

2009-09-18 08:34:05 <Console output> cmd User count : 0 (0/10)

2009-09-18 08:52:13 3 1 SERVICE_CONTROL_STOP

2009-09-18 08:52:13 1 1 SAgent:isconnect: (3, 64)

2009-09-18 08:52:13 1 1 T=000:21:00:000, RC=8,RCS=0, RB=131,RBS=0, SC=134,SCS=0, SB=1105,SBS=0

2009-09-18 08:52:13 mgr server disconnection

2009-09-18 08:52:13 1 1 SAgent:isconnect: (3, 64)

2009-09-18 08:52:13 1 1 T=000:21:00:000, RC=4,RCS=0, RB=16,RBS=0, SC=5,SCS=0, SB=53,SBS=0

2009-09-18 08:52:13 log system server disconnection

2009-09-18 08:52:13 PS_LOGIN__system log end (Login01)

2009-09-18 08:52:13 3 1 SService::ServiceCtrlDispatcher(): service shutdown





2009-09-18 08:30:44 PS_GAME__system log start (Game01)

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/sorp1

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/croco1

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/croco2

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/Troll1

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/Spink1

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/GoldenPig

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/Sorp3

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/SorpNamed1

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/SorpNamed2

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/Sorp2

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/CrocoNamed1

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/CrocoNamed2

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/CrocoNamed3

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/OrcNamed1

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/OrcNamed2

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/OrcNamed3

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/TrollNamed1

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/Deinos

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/Parridalis

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/Alcarian

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/ZinAlcaria

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/Belizabeth

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/Kirhiross

2009-09-18 08:30:44 Loaded Behavior In Factory : data/ai/CrypticOne

2009-09-18 08:30:49 CItemDrop::InitSequenceItemCreate SequenceItemCreate open 0

2009-09-18 08:30:50 connect mgr 724

2009-09-18 08:30:50 connect dbagent 732

2009-09-18 08:30:50 connect gamelog 760

2009-09-18 08:30:51 map 0, zone 2 mob count = 905

2009-09-18 08:30:51 map 1, zone 3 mob count = 1747

2009-09-18 08:30:51 map 2, zone 4 mob count = 1811

2009-09-18 08:30:51 map 3, zone 5 mob count = 294

2009-09-18 08:30:51 map 4, zone 6 mob count = 47

2009-09-18 08:30:51 map 5, zone 7 mob count = 173

2009-09-18 08:30:51 map 6, zone 8 mob count = 45

2009-09-18 08:30:51 map 7, zone 9 mob count = 162

2009-09-18 08:30:51 map 8, zone 10 mob count = 37

2009-09-18 08:30:51 map 9, zone 11 mob count = 334

2009-09-18 08:30:51 map 10, zone 12 mob count = 234

2009-09-18 08:30:51 map 11, zone 13 mob count = 176

2009-09-18 08:30:51 map 12, zone 14 mob count = 233

2009-09-18 08:30:51 map 13, zone 15 mob count = 245

2009-09-18 08:30:51 map 14, zone 16 mob count = 202

2009-09-18 08:30:51 map 15, zone 17 mob count = 206

2009-09-18 08:30:51 map 16, zone 18 mob count = 205

2009-09-18 08:30:51 map 17, zone 19 mob count = 155

2009-09-18 08:30:51 map 18, zone 20 mob count = 172

2009-09-18 08:30:51 map 19, zone 21 mob count = 1105

2009-09-18 08:30:51 map 20, zone 22 mob count = 1142

2009-09-18 08:30:51 map 21, zone 23 mob count = 160

2009-09-18 08:30:51 map 22, zone 24 mob count = 93

2009-09-18 08:30:51 map 23, zone 25 mob count = 143

2009-09-18 08:30:51 map 24, zone 26 mob count = 157

2009-09-18 08:30:51 map 25, zone 27 mob count = 478

2009-09-18 08:30:51 map 26, zone 28 mob count = 234

2009-09-18 08:30:51 map 27, zone 29 mob count = 62

2009-09-18 08:30:51 map 28, zone 30 mob count = 1077

2009-09-18 08:30:51 map 29, zone 31 mob count = 1107

2009-09-18 08:30:51 map 30, zone 32 mob count = 246

2009-09-18 08:30:51 map 31, zone 33 mob count = 93

2009-09-18 08:30:51 map 32, zone 34 mob count = 94

2009-09-18 08:30:51 map 33, zone 35 mob count = 136

2009-09-18 08:30:51 map 34, zone 36 mob count = 121

2009-09-18 08:30:51 map 35, zone 37 mob count = 0

2009-09-18 08:30:51 map 36, zone 38 mob count = 0

2009-09-18 08:30:51 map 37, zone 39 mob count = 190

2009-09-18 08:30:51 map 38, zone 40 mob count = 228

2009-09-18 08:30:51 map 39, zone 41 mob count = 0

2009-09-18 08:30:51 map 40, zone 42 mob count = 0

2009-09-18 08:30:51 map 41, zone 43 mob count = 0

2009-09-18 08:30:51 map 42, zone 44 mob count = 0

2009-09-18 08:30:51 map 43, zone 45 mob count = 922

2009-09-18 08:30:51 map 44, zone 46 mob count = 852

2009-09-18 08:55:50 <Console input> /help

2009-09-18 08:55:50 <Console output> /h /help /quit /exit /shutdown/CrashDump

/mem(0) /si(0) /quitt(1) /allout(0) /uc(0) /nt(1) /cstop(0) /cstart(0) /setmaxuser(1) /kickun(1) /kickuid(1) /kickcn(1) /kickcid(1) /nprotecton(0) /nprotectoff(0) /chktimeout(0) /exp2xdisable(0) /exp2xenable(1) /enableshop(0) /disableshop(0) /disablenshop(0) /enablekill(0) /disablekill(0) /ticktime(0) /inszonecnt(0) /initpl(0)



//PS_DBAGENT__charsave log start (DBAgent01)

//PS_DBAGENT__charsave log start (DBAgent01)

[claudeD]

server runs again lol

[Morpheus1200]

Ok The Server Works and i can log in as Admin after i choose Dark Side the loading Screen comes up after 5 minutes the Game close or it come up a Message Character loading error (or something like this)

Can someone help me to fix that?

I Use MSSQL 2008 and the newest US Gameclient an the Bypass from this Forum

[Morpheus1200]

Ok Fixed the Problem on my own

Now the next problem when i try to create a char it says "name already in use"

i look into the PS_DBAgent logfile an see there a Problem the Charname was not writen into the database

Heres my Log (sorry i user german version ^^)

2009-09-19 14:09:08 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2009-09-19 14:09:08 ::CreateCharacter 93 hallo retVal=-1, qerr=-1, {?=call Usp_Save_Char_Item_Add_E(93,2767147819931336704, 0,5, 5006,5,6, 2400, 0,0,0,0,0,0, '',1,'2009-09-19 14:09:08','S')}

2009-09-19 14:09:08 err=0, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

Someone know how to fix that?

[claudeD]

how can i link my game to my server if i use hex find and replace ip and i use game exe i come on the shaiya us server not my server can somone help plss

[FalconR]

The server name or address could not be resolved

This is the error i'm getting.. i'm sure i did something wrong with my ip.. i'm confused on that part. I'm trying to run the game only in my pc. lets say i wont be having internet always, and i dont have router. So what is exactly my ip address will be?? please help me on this part.

[Morpheus1200]

st all Ip´s from your Shaiya Server to 127.0.0.1 or localhost be sure your config is change too