Create your own Private Server Tutorial.

Quote:

Originally Posted by arionne sorry i maybe miss something (i dont read the thread) but why not emulate (vmware on .iso linux) with a second network card ? so u can have virtualy 2 computers with 2 different connections.

Emulate, you can emulate but not with vmware workstation, i tried directly ESXi and XEN, it works but it's very powerful and eats all the memory usage ...
I don't need to spend all the useless time to remake this solution, i directly installed on another server. (quite more simple)

Quote:

Originally Posted by Mustlord @Feldenfost what do you mean? Where is the uni code lanuguage?

The server doesn't support unicode language, so u need to change unicode support in languages regional options, set it up to Chinese Republica !!! damn.



When i am trying to use the update CAL_***, login server duplicate himself and crash everytime. Same than others CAL_ ...

If i am using normal files, only ALefserver.exe crash and show me the crash message after restart ...




EDIT: something weird.

I changed in SERVERCONFIG table from account SID all ip were on 192.168.1.***, i changed it to 127.0.0.1 (oracle is on the same machine than the server)

And when i changed it, AlefLoginServer, AlefRelayServer and AlefServer crashed themselves without word ... xD

TNSnames.ora i put also 127.0.0.1, it changes nothing ...


I missed something but what ? ...

IF somebody start the server without erors please hellp us.Tell us what software you have instaled in pc,what os you use,what net framework we need,what visual studio we need etc.Regards.

i think i start properly world server and loginserver but i got problems with relay server

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

Quote:

Originally Posted by tomi-cro i think i start properly world server and loginserver but i got problems with relay server [Only registered and activated users can see links. Click Here To Register...]

It seems, it works fine for you ...

What have you installed ?

Visualstudio 2010 or 2008 ?
Java JDK ?

;)

Quote:

Originally Posted by Feldunost It seems, it works fine for you ... What have you installed ? Visualstudio 2010 or 2008 ? Java JDK ? ;)

hm i didnt install nothing special!! but i do some other things i changed ip on oracle on more spots and deleted obj and obs and files in ini folder.

Thanks man, it works ^^


To all others: i recommend to use directly Celestia Updates, it's very simple:


1/ Delete all files in /ini/ folder of the server
2/ copy / paste INI folder of CA updates
3/ modify DatabaseInit (Database.ini and DBSERVERINFO.ini) to put alef user and password
4/ Run it directly ;)


The alone problem now is account creation, it don't create any user so i cannot login properly ... :/
But it receives perfectly my client query ...

You delete all files in the ini folder or just obj/obs?

Personally, i deleted all files ... and i copy/paste Update Celestia Server Files (INI)


I tried to execute the file Database_coupons_tbl.sql but it doesn't works because of STORAGE error ? ...



I changed ip adress in oracle table SERVERCONFIG, i didn't put 127.0.0.1 but the ip adress of the computer in 192.168.1.xxx ...

TNSNAMES.ora, i left it with 127.0.0.1.



ATM i am still not able to create account ... but server receives perfectly the connection query ...

Quote:

Originally Posted by Feldunost Personally, i deleted all files ... and i copy/paste Update Celestia Server Files (INI) I tried to execute the file Database_coupons_tbl.sql but it doesn't works because of STORAGE error ? ... I changed ip adress in oracle table SERVERCONFIG, i didn't put 127.0.0.1 but the ip adress of the computer in 192.168.1.xxx ... TNSNAMES.ora, i left it with 127.0.0.1. ATM i am still not able to create account ... but server receives perfectly the connection query ...

Use the account you made in the beginning of the server

User:alef
password:********

and about the steps you mentioned above, i deleted ini
copied and pasted Celestia update into old server files
Modified Database.ini and DBSERVERINFO.ini
but when i run CAL_loginserver, it says Failed this application will now close in [10000ms]

Quote:

Originally Posted by Feldunost Thanks man, it works ^^ To all others: i recommend to use directly Celestia Updates, it's very simple: 1/ Delete all files in /ini/ folder of the server 2/ copy / paste INI folder of CA updates 3/ modify DatabaseInit (Database.ini and DBSERVERINFO.ini) to put alef user and password 4/ Run it directly ;) The alone problem now is account creation, it don't create any user so i cannot login properly ... :/ But it receives perfectly my client query ...

for me login and world server is working but relay not and when i try to type username and pass in client it say user id wrong something like that

This is all that i have done:



Softwares used:
Windows2003 x86 Enterprise Edition R2 SP2
Oracle9i version


1: Oracle Installation

Available Products
Full installation of the first election
Installation Type
Select Enterprise
Database Configuration
General election
Mts recovery service configuration
Select the default port 2030
Database ID
Global database name: account
Sid: account
Location of database files
Choose
Database character set
Use the default character set

--- Start the installation
Set sys password and system password
Restart the machine end of the installation




Open SQL Plus in:
All programs => Oracle -OraHome92 => Application Development => SQL Plus

Username: SYSTEM
Password: password
SID: account

Press OK.



Copy SQL files on C:\ (download it at the first post)

Modify RPGWT.sql: change all names rpgwt by RPGWT
Modify SERVERCONFIG.sql: change all names serverconfig by SERVERCONFIG




Write on SQL Plus:
create user alef IDENTIFIED BY password;
grant connect to alef;
grant resource to alef;
grant alter session to alef;
grant create cluster to alef;
grant create database link to alef;
grant create sequence to alef;
grant create session to alef;
grant create synonym to alef;
grant create table to alef;
grant create view to alef;
grant dba to alef;
exit;



Re-open SQL Plus but with:

Username: alef
Password: password
SID: account



Write still on SQL Plus:

@C:\ACCOUNT.sql;
@C:\RPGWT.sql;
@C:\SERVERCONFIG.sql;
exit;



Use Navicat:
Specify in Tools => Options => OCI => Oci library: C:\oracle\ora92\bin\oci.dll



Create connection and change ip adress for Serverconfig table: not 127.0.0.1 but the ip of the computer. (execute cmd.exe and type ipconfig.


I changed name WORLD of the 1 and 201 section by Grayheon, changed also in RPGWT table SERVERID by Grayheon (all SERVERID)

I changed all null cases (alef - password - account - alef - password - account) in SERVERCONFIG table for: DBUSER, DBPWD, DBDSN, LOGDBUSER, LOGDBPWD, LOGDBDSN)



Changed that file:
C: \ oracle \ ora92 \ network \ admin \ tnsnames.ora.


# TNSNAMES.ORA Network Configuration File: D: \ oracle \ ora92 \ NETWORK \ ADMIN \ tnsnames.ora
# Generated by Oracle configuration tools.
ACCOUNT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = account)
)
)



Removed the INI folder and replaced INI folder from Update Celestia files.

Changed INI/DatabaseInit/Database.ini
Changed INI/DatabaseInit/DBSERVERINFO.ini



Changed in Configuration panel of windows: Regional and linguistic Options, i added in Languages languages for complex scripts and languages for oriental country.
In advanced options, i changed non-unicode programs language: Chinese Republic popular language.




You can start the server. New shortcut to the client, start the parameter bit / L192.168.1.200: 11002




Don't forget to disable firewall of windows for the testing purpose ! :mofo:

Quote:

Originally Posted by Feldunost This is all that i have done: Softwares used: Windows2003 x86 Enterprise Edition R2 SP2 Oracle9i version 1: Oracle Installation Available Products Full installation of the first election Installation Type Select Enterprise Database Configuration General election Mts recovery service configuration Select the default port 2030 Database ID Global database name: account Sid: account Location of database files Choose Database character set Use the default character set --- Start the installation Set sys password and system password Restart the machine end of the installation Open SQL Plus in: All programs => Oracle -OraHome92 => Application Development => SQL Plus Username: SYSTEM Password: password SID: account Press OK. Copy SQL files on C:\ (download it at the first post) Modify RPGWT.sql: change all names rpgwt by RPGWT Modify SERVERCONFIG.sql: change all names serverconfig by SERVERCONFIG Write on SQL Plus: create user alef IDENTIFIED BY password; grant connect to alef; grant resource to alef; grant alter session to alef; grant create cluster to alef; grant create database link to alef; grant create sequence to alef; grant create session to alef; grant create synonym to alef; grant create table to alef; grant create view to alef; grant dba to alef; exit; Re-open SQL Plus but with: Username: alef Password: password SID: account Write still on SQL Plus: @C:\ACCOUNT.sql; @C:\RPGWT.sql; @C:\SERVERCONFIG.sql; exit; Use Navicat: Specify in Tools => Options => OCI => Oci library: C:\oracle\ora92\bin\oci.dll Create connection and change ip adress for Serverconfig table: not 127.0.0.1 but the ip of the computer. (execute cmd.exe and type ipconfig. I changed name WORLD of the 1 and 201 section by Grayheon, changed also in RPGWT table SERVERID by Grayheon (all SERVERID) I changed all null cases (alef - password - account - alef - password - account) in SERVERCONFIG table for: DBUSER, DBPWD, DBDSN, LOGDBUSER, LOGDBPWD, LOGDBDSN) Changed that file: C: \ oracle \ ora92 \ network \ admin \ tnsnames.ora. # TNSNAMES.ORA Network Configuration File: D: \ oracle \ ora92 \ NETWORK \ ADMIN \ tnsnames.ora # Generated by Oracle configuration tools. ACCOUNT = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = account) ) ) Removed the INI folder and replaced INI folder from Update Celestia files. Changed INI/DatabaseInit/Database.ini Changed INI/DatabaseInit/DBSERVERINFO.ini Changed in Configuration panel of windows: Regional and linguistic Options, i added in Languages languages for complex scripts and languages for oriental country. In advanced options, i changed non-unicode programs language: Chinese Republic popular language. You can start the server. New shortcut to the client, start the parameter bit / L192.168.1.200: 11002 Don't forget to disable firewall of windows for the testing purpose ! :mofo:

server works or you have error ?

Server works but i cannot create account for play ... (maybe it must be done manually ... ?)

:'(

I forgot, i installed visual C++ 2010 express and redistributable 2008 + 2010.


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

Quote:

Originally Posted by Feldunost Server works but i cannot create account for play ... (maybe it must be done manually ... ?) :'( I forgot, i installed visual C++ 2010 express and redistributable 2008 + 2010. [Only registered and activated users can see links. Click Here To Register...]

lol u didnt start the server because your relayserver is not working :(

ah shit, you mean loginserver doesn't receive answer from gameserver because relayserver doesn't works ?


Grumph, then it should be an very little thing who is missing ...