[Video Tutorials] Shaiya EP4 Private Server By Omega

who help me instaled on server private with teamwiver pls?!

I checked twice game.exe ip. it is correct. all services is fine. but when i tried to log in game via admin | admin123. it says account doesnt exist. any1 met this error before? how can i solve this

edit: i found this on ps_LOGIN_system.ini

2011-04-09 10:34:52 PS_LOGIN__system log start (Login01)

2011-04-09 10:35:21 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@useruid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2011-04-09 10:39:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@useruid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2011-04-09 11:21:32 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@useruid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2011-04-09 11:21:37 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@useruid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2011-04-09 11:35:02 cmd_auto server info log

user = 0 (0/5000)

2011-04-09 11:35:02 T=001:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=3,CReq=3,CCnt=3,DCCnt=3, CTimeT=000:01:00:000,CTimeAvg=000:00:00:000, RBT=637,RBS=0,RBSC=9,SBT=701,SBS=0,SBSC=10

2011-04-09 11:35:02 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

here are my screen shots

i have this problem pls one help me :(:confused:

Hello there first of all i want to say thanks to you for a ACE TUT........I was just wondering if anyone has came accross this problem...Click server Patch Config..

Once i start all my servers.... They start and then they go back to pause can someone please give me some advice thanks

Hello there Ive just done all the steps.....I log in as admin then i click my server and it says failed to connect to game server.... Any ideas ?

make sure your ini files are properly edited.
C:\ShaiyaServer\SERVER\PSM_Client\Bin\Config
located somewhere around there

I found out what was wrong i needed to add all ports to my router works fine now thanks Omega you are a legend Mate i look forward to your TUTS.......

If you ever decide to make a TUT About makeing a user database website where people can sign up tell me....

I don't want to make like a massive private server just a shit thing i can mess with and test stuff and learn and maby a few close friends.......PS YOU ROCK

Error :
PS_USERLOG

Quote:

2011-04-12 11:59:53 PS_USERLOG__system log start (UserLog) 2011-04-12 12:00:09 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=Shaiya, Pass=Shaiya123 2011-04-12 12:00:09 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init() 2011-04-12 12:00:09 PS_USERLOG__system log end (UserLog) 2011-04-12 12:00:09 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_SESSION

Quote:

2011-04-12 12:10:52 PS_SESSION__system log start (Session) 2011-04-12 12:10:53 userlog connect failed 2011-04-12 12:10:53 initserver() failed 2011-04-12 12:10:53 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init() 2011-04-12 12:10:53 PS_SESSION__system log end (Session) 2011-04-12 12:10:53 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_DBAGENT

Quote:

//PS_DBAGENT__charsave log start (DBAgent01) //PS_DBAGENT__charsave log start (DBAgent01)

PS_LOGIN

Quote:

2011-04-12 12:11:02 PS_LOGIN__system log start (Login01) 2011-04-12 12:11:17 DB userdata connect error, id=Shaiya, pass=Shaiya123 2011-04-12 12:11:17 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init() 2011-04-12 12:11:17 PS_LOGIN__system log end (Login01) 2011-04-12 12:11:17 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_GAME

Quote:

2011-04-12 12:11:00 PS_GAME__system log start (Game01) [KR] 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/sorp1 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/croco1 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/croco2 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/Troll1 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/Spink1 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/GoldenPig 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/Sorp3 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/SorpNamed1 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/SorpNamed2 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/Sorp2 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/CrocoNamed1 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/CrocoNamed2 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/CrocoNamed3 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/OrcNamed1 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/OrcNamed2 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/OrcNamed3 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/TrollNamed1 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/HellTouthNamed1 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/Deinos 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/Parridalis 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/Alcarian 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/ZinAlcaria 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/Belizabeth 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/Kirhiross 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/CrypticOne 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/Haruhion 2011-04-12 12:11:00 Loaded Behavior In Factory : data/ai/Freezing 2011-04-12 12:11:15 DB gamedef connect error 2011-04-12 12:11:15 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init() 2011-04-12 12:11:15 Call save all waiting... 2011-04-12 12:11:15 Call save all failed dbagent disconnected(user count = 0)... 2011-04-12 12:11:15 server shutdown Connection INFO : T=000:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0 2011-04-12 12:11:15 Save Shaiya.SData 0 2011-04-12 12:11:15 PS_GAME__system log end (Game01) 2011-04-12 12:11:15 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_DBAGENT.SYS

Quote:

2011-04-12 12:10:57 PS_DBAGENT__system log start (DBAgent01) 2011-04-12 12:11:13 DB gamedata connect error 2011-04-12 12:11:13 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init() 2011-04-12 12:11:13 DBKillCountSave db alloc failed 2011-04-12 12:11:13 SAVE kill count ERROR 2011-04-12 12:11:13 CKeepObeliskMgr::DBSave db alloc failed 2011-04-12 12:11:13 SAVE g_KeepObeliskMgr ERROR 2011-04-12 12:11:13 GuildMgrSave::DBSave db alloc failed 2011-04-12 12:11:13 SAVE g_GuildMgrSave ERROR 2011-04-12 12:11:13 PS_DBAGENT__system log end (DBAgent01) 2011-04-12 12:11:13 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_Charsave

Quote:

//PS_DBAGENT__charsave log start (DBAgent01) //PS_DBAGENT__charsave log start (DBAgent01)

I need to figure out what this is. if anyone has any idea
please tell, I need help with my shaiya server

Im using windows 7 and when i run Install_Server.bat as administrator this is what i get.
Restore Database
The system cannot find the file batch\shaiya_db_restore.
The system cannot find the file batch\config_database.bat.
Start MSTDC and set to auto.
[SC] ChangeServiceConfig SUCCESS
[SC] StartService FAILED 1056:

An instance of the service is already running.

Shaiya Services
The system cannot find the file batch\shaiya_svc_register.bat.
Agent Install
The system cannot find the file PSM_Server\PSMServer_Mgr.exe.
This will now restart Windows.
Press any key to continue . . .

The system cannot find the file batch\shaiya_svc_register.bat.
Agent Install
The system cannot find the file PSM_Server\PSMServer_Mgr.exe

You are missing these files.

you rock. this is easy when you just know how. mye server works like a sharm. but i use the us client. and i get error on skills and this is lvl 60. might be that i have tried 70 times + to get db up to full 5. but nothing works like this.

if and when you get full ep 5 will you please make anotherone? or working db files? i have tried it all i can think of..

there is 70+ topics with working ep5 and all that. i need someone to help me to update this to ep5 and working please..

mail: [Only registered and activated users can see links. Click Here To Register...] or svinseladden on skype. add me if you can help me with this error on lvl cap 60 and skills all messed up LOL

Quote:

Originally Posted by dbenderboy Im using windows 7 and when i run Install_Server.bat as administrator this is what i get. Restore Database The system cannot find the file batch\shaiya_db_restore. The system cannot find the file batch\config_database.bat. Start MSTDC and set to auto. [SC] ChangeServiceConfig SUCCESS [SC] StartService FAILED 1056: An instance of the service is already running. Shaiya Services The system cannot find the file batch\shaiya_svc_register.bat. Agent Install The system cannot find the file PSM_Server\PSMServer_Mgr.exe. This will now restart Windows. Press any key to continue . . .

are you sure i running this without UAC? if not turn it off under users in your control panel push it all the way down.

*************

Quote:

Originally Posted by Xx.LaMin.xX The system cannot find the file batch\shaiya_svc_register.bat. Agent Install The system cannot find the file PSM_Server\PSMServer_Mgr.exe You are missing these files.

sure you have UAC off?