How to setup the famous Shaiya server without problems

Danco1990 · 09/08/2009, 08:12

/No support on ePvPers

Danco1990 · 09/08/2009, 08:17

/No support on ePvPers

N4ZB34T · 09/08/2009, 08:26

wow...i was not using my computer's ip :O. Thx a lot

But, here comes another question. How do i change it to my computer's ip?? =/

Danco1990 · 09/08/2009, 09:35

/No support on ePvPers

N4ZB34T · 09/08/2009, 10:04

omg, it worked :O TY sooooooooo much

Danco1990 · 09/08/2009, 12:54

/No support on ePvPers

hopeloz · 09/08/2009, 13:28

to me, didnt worked out..
I discovered a big problem, with the ports...

my mssql was setted to dynamic ports, i setted the default port to mssql (1433) and it worked (in the scripts)...

i did this one to try out the server...

Code:

<?php

echo "----------------------/-///--------------------------<br />";

$con = mssql_connect( '127.0.0.1', 'Shaiya', 'Shaiya123' );

if( $con === FALSE ) {
        echo 'Not Connected';
} else {
        echo 'Connected: ' . gettype( $con );
}

?>

Before i set my ports to fixed, i was having to use instead of '127.0.0.1' -> 'Server\Shaiya'

well, now its working fine with 127.0.0.1 and my local ip, even if i put localhost it work... i get connected...
but i get the same thing in the Shaiya Serv.

--> PS_SESSION*.log

Code:

2009-09-04 00:20:05 PS_SESSION__system log start (Session)
2009-09-04 00:20:06 userlog connect failed
2009-09-04 00:20:06 initserver() failed
2009-09-04 00:20:06 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2009-09-04 00:20:06 PS_SESSION__system log end (Session)
2009-09-04 00:20:06 3 1 SService::ServiceCtrlDispatcher(): service shutdown

--> PS_USERLOG*.log

Code:

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

Oh and btw, the pass that comes with the server is "Shaiya123" and no "shaiya123" (S in Capital Letter)

Danco1990 · 09/08/2009, 16:54

/No support on ePvPers

skater_1997 · 09/08/2009, 17:34

danco i have a rellly big problem when i install server and after tell me to reset pc i cant enter again in SQL please help

Randomnizer · 09/08/2009, 18:00

How come you people get this much problems? i just read the tutorial, and did what it said, and it all worked! :S

Danco1990 · 09/08/2009, 18:02

/No support on ePvPers

hopeloz · 09/08/2009, 18:14

i've setted again my ports to dynamic and like was before...
now i cant connect tru my php script it says:

Code:

mssql_connect(): Unable to connect to server:  127.0.0.1 in index.php on line 3
--> $con = mssql_connect( '127.0.0.1', 'Shaiya', 'Shaiya123' );

if i change the code to:

Code:

$con = mssql_connect( 'SERVIDOR/SHAIYA', 'Shaiya', 'Shaiya123' );

SERVIDOR -> My computer name
SHAIYA -> my sql instance

i get connected.
and tcp ip is still allowed, the only thing i did was change the ports to dynamic back and restarted the server.
and in the server, still having the same prob.

Code:

2009-09-08 12:19:22 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=Shaiya, Pass=Shaiya123

Btw, do you have msn? if yes, send me via PM and when we get to a solution, i post in here.

is up to u.

Thank you

skater_1997 · 09/08/2009, 18:40

Quote:

Originally Posted by Danco1990

Ok, this is where most people stop, dont worry, this is easy to fix. Make sure u have not only local connections on in the config of SQL, and test and verify this by logging in locally as i explained before, if this is the case, forward your ports, this should help, let me know if it worked

good luck

Please help me i rellly duno how to make this answer me

skater_1997 · 09/08/2009, 19:40

It dont work

( or idk btu wat i try dont works

Danco1990 · 09/08/2009, 20:47

/No support on ePvPers