[NA - 2008] Server Files & Guide

[fiestanerd69]

Re: Server Files + Guide

Thank you very much!!!
i have a problem: "server is full ". How to fix ?

Wait for a while (minute or so) after you start the services, this usually happens straight after you start the service and try to enter the game. Also please use the search function next time, this has been answered not so long ago in the help section.

 

[Jules Cornwell]

Re: Server Files + Guide

I can get as far as starting my services and all of them start except for _AccountLog DB Server, _World00 Character DB Server, and _World00 GameLog DB Server. It tells me they start then stop. Cause they aren't being used by a program or service. Anyone know why? :c

 

[sn0wy50]

Re: Server Files + Guide

most likely due to setting up the ODBC info wrong, does the information window look similar to this:

Spoiler

ODBC_INFO "Account",	0,		0,	"DSN=Account;	UID=sa;	PWD=yourpass", "USE Account;		SET LOCK_TIMEOUT 5000"
ODBC_INFO "AccountLog",	1,		0,	"DSN=AccountLog;UID=sa;	PWD=yourpass", "USE AccountLog;		SET LOCK_TIMEOUT 5000"
ODBC_INFO "StatisticsData",	2,		0,	"DSN=StatisticsData;UID=sa;	PWD=yourpass", "USE StatisticsData;	SET LOCK_TIMEOUT 5000"
ODBC_INFO "OperatorTool",	3,		0,	"DSN=OperatorTool;	UID=sa;	PWD=yourpass", "USE OperatorTool;	SET LOCK_TIMEOUT 5000"
ODBC_INFO "World00_Character",	10,		0,	"DSN=World00_Character;	UID=sa;	PWD=yourpass", "USE World00_Character;	SET LOCK_TIMEOUT 5000"
ODBC_INFO "World00_GameLog",	11,		0,	"DSN=World00_GameLog;	UID=sa;	PWD=yourpass", "USE World00_GameLog;	SET LOCK_TIMEOUT 5000"

the DSN section should be the same as in the ODBC

 

[NextIdea]

Re: Server Files + Guide

I can get as far as starting my services and all of them start except for _AccountLog DB Server, _World00 Character DB Server, and _World00 GameLog DB Server. It tells me they start then stop. Cause they aren't being used by a program or service. Anyone know why? :c

Read before posting! + Common errors.

 

[Panderz]

Re: Server Files + Guide

all of it looks the same as that but they still won't start. I've read through all the other posts about this problem and tried all the fixes but it doesn't seem to wanna work for me. I dun get why :c

 

[Generic]

Re: Server Files + Guide

can anyone help me i get the same error as Jules, my config is listed below with dsn pic

DEFINE WORLD_NAME <INTEGER> ; World No
<STRING> ; Name
<STRING> ; Data path
#ENDDEFINE

#DEFINE SERVER_INFO ; Listen socket information
<STRING> ; Name
<INTEGER> ; Server ID
<INTEGER> ; Server World No
<INTEGER> ; Server Zone No
<INTEGER> ; From Server ID
<INTEGER> ; IP Address == '127.0.0.1' then Use my IP Address
<INTEGER> ; Port Number
<INTEGER> ; Backlog Count == 0 then Use SOMAXCONN
<INTEGER> ; Maximum of accept socket
#ENDDEFINE


#DEFINE ODBC_INFO
<STRING> ; DB Name
<INTEGER> ; DB ID
<INTEGER> ; World No
<STRING> ; ODBC Connection info
<STRING> ; DB Startup command
#ENDDEFINE


;-----------------------------------------------------------------------------------
; Server ID
;-----------------------------------------------------------------------------------


; 0 SERVER_ID_DB_ACCOUNT
; 1 SERVER_ID_DB_ACCOUNTLOG
; 2 SERVER_ID_DB_CHARACTER
; 3 SERVER_ID_DB_GAMELOG

; 4 SERVER_ID_LOGIN
; 5 SERVER_ID_WORLDMANAGER
; 6 SERVER_ID_ZONE

; 7 SERVER_ID_PATCH
; 8 SERVER_ID_OPTOOL
; 9 SERVER_ID_WEB
; 10 SERVER_ID_UNKNOWN

; 19 SERVER_ID_LAUNCHER
; 20 SERVER_ID_CLIENT


;-----------------------------------------------------------------------------------
; DB ID
;-----------------------------------------------------------------------------------


;define DB_ID_ACCOUNT 0
;define DB_ID_ACCOUNTLOG 1
;define DB_ID_STATICSTICS 2
;define DB_ID_OPTOOL_LOG 3
;define DB_ID_CHARACTER 10
;define DB_ID_GAMELOG 11


;-----------------------------------------------------------------------------------
; DEFINE WORLD NAME
;-----------------------------------------------------------------------------------


WORLD_NAME 0, "Beta-Server", "../_CONF/Data"


;-----------------------------------------------------------------------------------
; CJC SERVER INFO
;-----------------------------------------------------------------------------------


;
; [ID] = Server ID, [W] = World No, [Z] = Zone No, [F] = From Server ID
;
; [Name] [ID, W, Z, F] [IP] [Port] [Backlog] [Maximum of accept socket]
;
; DB Login server ------------------------------------------------------------
SERVER_INFO "PG_Account_DB", 0, 0, 0, 0, "0.0.0.0", 9000, 1, 100 ; From ALL
SERVER_INFO "PG_AccountLog_DB", 1, 0, 0, 0, "0.0.0.0", 9005, 1, 100 ; From ALL


SERVER_INFO "PG_Login_Server", 4, 0, 0,20, "0.0.0.0", 9010, 10, 2000 ; From Client
SERVER_INFO "PG_Login_Server", 4, 0, 0, 5, "0.0.0.0", 9015, 1, 50 ; From World manager
SERVER_INFO "PG_Login_Server", 4, 0, 0, 8, "0.0.0.0", 9016, 1, 30 ; From OPTOOL


; World #0 -------------------------------------------------------------------
SERVER_INFO "PG_Char_DB", 2, 0, 0, 0, "0.0.0.0", 9100, 1, 100 ; From ALL
SERVER_INFO "PG_GameLog_DB", 3, 0, 0, 0, "0.0.0.0", 9101, 1, 100 ; From ALL


SERVER_INFO "PG_World_Manager_Server", 5, 0, 0,20, "0.0.0.0", 9110, 10, 2000 ; From Client
SERVER_INFO "PG_World_Manager_Server", 5, 0, 0, 6, "0.0.0.0", 9115, 1, 100 ; From Zone
SERVER_INFO "PG_World_Manager_Server", 5, 0, 0, 8, "0.0.0.0", 9116, 1, 30 ; From OPTOOL


SERVER_INFO "PG_Zone_00", 6, 0, 0,20, "0.0.0.0", 9120, 10, 2000 ; From Client
SERVER_INFO "PG_Zone_00", 6, 0, 0, 8, "0.0.0.0", 9121, 1, 30 ; From OPTOOL


SERVER_INFO "PG_Zone_01", 6, 0, 1,20, "0.0.0.0", 9122, 10, 2000 ; From Client
SERVER_INFO "PG_Zone_01", 6, 0, 1, 8, "0.0.0.0", 9123, 1, 30 ; From OPTOOL


SERVER_INFO "PG_Zone_02", 6, 0, 2,20, "0.0.0.0", 9124, 10, 2000 ; From Client
SERVER_INFO "PG_Zone_02", 6, 0, 2, 8, "0.0.0.0", 9125, 1, 30 ; From OPTOOL




;-----------------------------------------------------------------------------------
; ODBC INFO
;-----------------------------------------------------------------------------------
; NAME nDBID nWorldNoConnection INFO Startup Command
ODBC_INFO "Account", 0, 0, "DSN=Account; UID=sa; PWD=yourpass", "USE Account; SET LOCK_TIMEOUT 5000"
ODBC_INFO "AccountLog", 1, 0, "DSN=AccountLog;UID=sa; PWD=yourpass", "USE AccountLog; SET LOCK_TIMEOUT 5000"
ODBC_INFO "StatisticsData", 2, 0, "DSN=StatisticsData;UID=sa; PWD=yourpass", "USE StatisticsData; SET LOCK_TIMEOUT 5000"
ODBC_INFO "OperatorTool", 3, 0, "DSN=OperatorTool; UID=sa; PWD=yourpass", "USE OperatorTool; SET LOCK_TIMEOUT 5000"
ODBC_INFO "World00_Character", 10, 0, "DSN=World00_Character; UID=sa; PWD=yourpass", "USE World00_Character; SET LOCK_TIMEOUT 5000"
ODBC_INFO "World00_GameLog", 11, 0, "DSN=World00_GameLog; UID=sa; PWD=yourpass", "USE World00_GameLog; SET LOCK_TIMEOUT 5000"


#END

 

[NextIdea]

Re: Server Files + Guide

can anyone help me i get the same error as Jules, my config is listed below with dsn pic

First read this!
Read before posting! + Common errors.

Your IP-s are invalid.

 

[Generic]

Re: Server Files + Guide

Your IP-s are invalid.

Explain more? im trying to host this on localhost so if you could modify to localhost please do so.

 

[Panderz]

Re: Server Files + Guide

I am Jules. I have read that and the other ones about service errors and i can't figure it out. my config is changed to how this guide says and my pws are all right. I'm at a loss :c

 

[Generic]

Re: Server Files + Guide

I fixed my ips and now login and manager wont startup

and both accounts dont work either

Not sure what this means but this is what i get when i start the account services.

000002 2013-11-17 09:50:11 Launching the server.....000003 2013-11-17 09:50:11 Local Time 11/17/2013 9:50:11 AM
000004 2013-11-17 09:50:11 System Time(UTC) 11/17/2013 2:50:11 PM
000005 2013-11-17 09:50:11 <SUCCESSED SCRIPTOR READ> config.txt
000006 2013-11-17 09:50:11 <I AM THE _Account DB Server, SERVER_ID_DB_ACCOUNT, WorldNo=0, ZoneNo=0>
000007 2013-11-17 09:50:11 Service upload failed.
000008 2013-11-17 09:50:13 < END OF MAIN = -2 >
000000 2013-11-17 09:56:20 C:\Fiesta\Server\Account

 

[sn0wy50]

Re: Server Files + Guide

I fixed my ips and now login and manager wont startup

and both accounts dont work either

Not sure what this means but this is what i get when i start the account services.

Localhost means all IP's should be 127.0.0.1, did you run the .exe's as admin? Also are you sure you used the correct ODBC? (and that they're set up correctly)

 

[Myth]

Re: Server Files + Guide

If your login/world manager or zones fail it's a sign you've bound to an incorrect IP, your database services are a sign that it's failing to connect to your database.

Look for help in the help section, pretty sure these two issues have been covered five-thousand times or more.

And like the previous post, disable your UAC (google it if you don't know how), unless you don't mind running everything as administrator via right-click.

 

[Melwin]

Re: Server Files + Guide

Thankyou , But how can use register.php ? :O

 

[sn0wy50]

Re: Server Files + Guide

I'm not exactly the best person to answer this, but you could host it on a web server created by a program such as xampp or wamp and storing it in the htdocs folder, depending on how you want to use it. If you don't now how to use either programs i suggest googeling it.

 

[txie2k8]

Re: Server Files + Guide

Explain more? im trying to host this on localhost so if you could modify to localhost please do so.

always use 127.0.0.1 as your localhost IP address. 0.0.0.0 is an invalid IP address that will not even resolve to your localhost. Try ping'ing 0.0.0.0 from your machine, you will get errors because 0.0.0.0 cannot be resolved

 

[kevinolaybal]

Re: Server Files + Guide

Try no-ip