How to setup the famous Shaiya server without problems

09/08/2009 08:12 Danco1990#16
/No support on ePvPers
09/08/2009 08:17 Danco1990#17
/No support on ePvPers
09/08/2009 08:26 N4ZB34T#18
wow...i was not using my computer's ip :O. Thx a lot :D
But, here comes another question. How do i change it to my computer's ip?? =/
09/08/2009 09:35 Danco1990#19
/No support on ePvPers
09/08/2009 10:04 N4ZB34T#20
omg, it worked :O TY sooooooooo much :D :D :D :D
09/08/2009 12:54 Danco1990#21
/No support on ePvPers
09/08/2009 13:28 hopeloz#22
to me, didnt worked out..
I discovered a big problem, with the ports...

[Only registered and activated users can see links. Click Here To Register...]

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)
09/08/2009 16:54 Danco1990#23
/No support on ePvPers
09/08/2009 17:34 skater_1997#24
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
[Only registered and activated users can see links. Click Here To Register...]
09/08/2009 18:00 Randomnizer#25
How come you people get this much problems? i just read the tutorial, and did what it said, and it all worked! :S
09/08/2009 18:02 Danco1990#26
/No support on ePvPers
09/08/2009 18:14 hopeloz#27
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
09/08/2009 18:40 skater_1997#28
Quote:
Originally Posted by Danco1990 View Post
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
09/08/2009 19:40 skater_1997#29
It dont work :(( or idk btu wat i try dont works :(
09/08/2009 20:47 Danco1990#30
/No support on ePvPers