Shaiya Private Server - Instructions - English

Quote:

Originally Posted by ImortalPain im sorry Zero but the list you post here is useless totally because 90% of command on list dont explain what need type after, and most of them seems dont work, im pretty sure some of you know much more than you post on those 2 forum, I can understand if a programmer will take secret all things but this is a forum and it mean not all are hacker or programmer, my personal opinion come out now after you and someother "expert" wont answer or help at who really need help and nice signature when you say " im not nub support " congratulations for it maybe you are a great hacker but im curious to know how you fell in real life without your bites and tool, open a hacker / programmer forum and accept on it only expert if you are here mean you want help all and for easy things too but it never happen if not by Twilight in other forum none get good answer, have a fun with your server till a real server maded by NUB come out without your help

I have taken out many hours (perhaps hundreds) to provide for the community clear instructions plus an optimised Database with many Stored Procedures modified, plus many Tools such as the Client Resource Extractor, and the SData Extractor which took quite a bit of binary file reverse engineering.

If Twilight decides to help people who barely even know what they are doing themselves that is his decision. however I'm not interested in wasting my time on those who will most likely not contribute anything back to the Shaiya Server Development Scene.

I have seen ALLOT of my work being used, but I have had very little contributions back with the exception of Twilight which I have a great deal of respect for. I even tried to setup a team to work on creating an Ep4 Server built from the ground up and no-one was really interested in helping only leeching off my achievements and not sharing any of there own.

You try sitting there looking at hexadecimal patterns in files and write the code to extract the data into human translatable files if you ever get that far and only then come back and tell me how selfish I really am.

You only say it to me because you know I will not help you and u would b correct. So excuse me if u can't take 10 minutes of your time to write a "hello world" program!

Hello Zero. I've tried several days to set up a server. I did everything as in the tutarial. When starting server using "Start All service", services go back to pause after several seconds. When I checked the log i got this:

2009-07-19 16:53:02 PS_SESSION__system log start (Session)

2009-07-19 16:53:03 userlog connect failed

2009-07-19 16:53:03 initserver() failed

2009-07-19 16:53:03 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2009-07-19 16:53:03 PS_SESSION__system log end (Session)

2009-07-19 16:53:03 3 1 SService::ServiceCtrlDispatcher(): service shutdown

I guess that means the Server Patch Config could not connect to the database or SQL server? I've tried log in to SQL server using Shaiya and the password and it worked fine.

Maybe it's the ip adress? I use 127.0.0.1 everywhere.

It is not mentioned where I point Server Patch Config to SQL server instance, maybe thats the problem?

Thanks for any help. I think if i could connect the Server Patch Config to SQL server instance then all will be solved.

Check that you can connect to the Database via your Game Server link.

uM...i'm not sure how i can test that...I just tested [Only registered and activated users can see links. Click Here To Register...] computer/my server and that did not work, neither with the 127.0.0.1. I don't know what is the "Game Server link" and how to test it...Please enlighten me :)

EDIT: I tried to ping 127.0.0.1 1433, work fine.
Ping 127.0.0.1/game 1433, the host could not be found (game is my SQL instance which is running)

In SQL 2005 server, I can connect the mystation/game and access the database.

What is the "Game server link" and how to connect to it without via SQL server?

yea i think i have the same problem as linusji, and i ran the game server link and if its the one i think your talking about, that connects fine.

Look in all the log files produced by the PSM_Client in
.\PSM_Client\Bin\Log\*.log
The star above means a wildcard filename not an actual filename.

If it's the connection to the Database that is the issue look in the PS_DBAGENT log file.

If there is allot of logs, stop all Shaiya Server services, then remove all logs from:
.\PSM_Client\Bin\Log\*.log
Then re-try, then look in all logs to see where the issue may be.

If you don't learn how to diagnose issues properly you'll b stuck again if another issue comes along, Which is very likely that it will occur.

ok so this is my log file
im not fully sure where to find these things to fix.
I looked through the DB and didnt find them in there.

So far I got some progress:

Now I can get everything exept ps_game running. The error was that when updating server, It put 127.0.0.1 everywhere, but it was not the true IP to the server database. As my database instance is called "Game", it should be (f.ex in ps_dbAgent.ini) :
[DB]
GameData=127.0.0.1\Game, PS_GameData,

And in [CONNECTION] tag the 127.0.0.1 won't work, I had to put the PC name in it instead, and it worked fine.

Now my last error is that ps_game cannot connect to PS_GameData. I got connection error all the time, and I already applied same fix as for other [DB] tags. I suspect that the database is corrupt in some sense, but i haven't tried to reinstall yet.

I'm almost there :)

yea i have tried what you are doing, but still stuck

EDIT:
ok i redid it (i used / instead of \ >.<)

now i just get this

anyone know how to register the SQLOLEDB?

You shouldn't relly be modifying the ini files directly unless in The Server Patch Config you have changed the Game instance name (It does not correctly update the name).

On all my Servers I have:
And they have all ran fine, and I have configured many Shaiya Servers. Check in SQL Server Conifguration if you have enabled Named Pipes.

Rather than getting to technical backtrack and see if there is something simple you have missed. Check in the Database that you have a Game Linked Server, and that it has the correct Username and Password. Check that all the Databases were correctly restored. Use all default settings and don't try and change anything until you know you can confidently get a Server up and running. It's very fiddly I know it was allot worse when I had to configured my first, everything was very manually labor intensive.

The trade off with automating allot of it is it can't possibly be fully tested for every user configuration, and something may go wrong.

well its not the named pipelines, i have that working
but it seems like the sql service provider SQLOLEDB needs to be registered
i googled it and found a fix, and it ran just fine, but still says its a problem
so im not sure about that

Hi Zero! Well I did not change the instance name, I named it "Game" when I installed the SQL server. When I connect to the server I could not use 127.0.0.1 but only 127.0.0.1\Game, that's why I tried to modify .ini files. If I write 127.0.0.1\Game in Server Patch Config it will only display a red cross.

If you can use 127.0.0.1 that must mean that you can use it as server name when you log in to the SQL server? I really don't understand how cause you need to specify the instance name? Or do you have a default name on instance thats the reason? So maybe I should recreate the instance?

As for Ps_game.ini, it seems that the server could not be connected or the access was denied. I doubt if it's the database problem, I think it's more a connection problem. As the password is encrypted I can not know if it's correct. It should work as all other connections worked. I will continue dig in that.

I really wish that the server could run without modification though :)

walkerboh1: Seems you got pass the DB connection error then. The OLEDB I think is the type of the link server. Check your link server if it is there and have the right type (should be called "game"), otherwise you need to create it, the command line is in the script Zero pasted in the beginning of this thread.

yea i am hitting the same brick wall linuji

=/ i will be messing with it more later

EDIT:
Yea i have the game linked server
with proper user and password
so idk

Quote:

Originally Posted by ZeroSignal I have taken out many hours (perhaps hundreds) to provide for the community clear instructions plus an optimised Database with many Stored Procedures modified, plus many Tools such as the Client Resource Extractor, and the SData Extractor which took quite a bit of binary file reverse engineering. If Twilight decides to help people who barely even know what they are doing themselves that is his decision. however I'm not interested in wasting my time on those who will most likely not contribute anything back to the Shaiya Server Development Scene. I have seen ALLOT of my work being used, but I have had very little contributions back with the exception of Twilight which I have a great deal of respect for. I even tried to setup a team to work on creating an Ep4 Server built from the ground up and no-one was really interested in helping only leeching off my achievements and not sharing any of there own. You try sitting there looking at hexadecimal patterns in files and write the code to extract the data into human translatable files if you ever get that far and only then come back and tell me how selfish I really am. You only say it to me because you know I will not help you and u would b correct. So excuse me if u can't take 10 minutes of your time to write a "hello world" program!

I know as well all your job, the guide for instal server is pretty nice, but so many time when i read your answer to peaple and i mean not expert peaple I saw not nice answer, for this I have to say this is not forum of expert user only, if you look for it should you open a new one reserved for an expert, when peaple noticed you and twilight are good programmer is normal for them ask to you, good and easy question because you got different parameter , i mean maybe for you is an easy question but for the user is big problem.
Personally I miss only 2 things on server for the rest fortunately my head and my time have made all very good without lots of help, but i noticed in those 2 forum some users are asking same question more than 1 time and none of you answer at them, and this is not because you dont know wich answer doing but is only for keep it for you.
For finish you tell me " So excuse me if u can't take 10 minutes of your time to write a "hello world" program! " ermm I work on comp for around 15 hours every days, offcourse i got a real life too and for certain things i dont have basic knowldge and MAYBE for dont lose 2 days or so I try to ask here.
Another thing, tell me the sense of post command list if 90% of them dont have explained what we need type for make it working and for what they are, post something when is complete please or dont post nothing.
I can give you a BIG feedback for instruction in english for the server, if you want i can update server files with some bug fixed, but it mean you change mind and stop you to answer rude and call nub other ppl ? ummm :pimp:

Some more progress. Now i get the server running (meaning that all progress are green triangles). What I found is that since my SQL database does not have the default name, so is the linked server. I change the property of the linked server to 127.0.0.1/game and ps_game connected fine.

So my next problem is to get the game running. I do find the IP stated in the beginning of this thread, and changed to my IP. When I started game it just crached. I guess there is more i need to do to make this work, so i will keep digging.

BTW this is a good chance for me to get more knowledge about SQL server, it took time though :)

EDIT: this time when I started game it says :Game hack has been found lol