Create your own Private Server Tutorial.

Page 1 of 99

01/23/2011 20:41 Mike0505 ∞#1

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

Notes
- Tested on Windows XP Pro SP.3
- Does not work on Windows 7 or Windows Vista ( Oracle compatibility problems )
- I will not give out my MSN, Or help beyond this Tutorial.

Downloads

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

Celestia Archlord - Server Files Update package
[Only registered and activated users can see links. Click Here To Register...]

PLSQL_Developer_7.0.1中文版
[Only registered and activated users can see links. Click Here To Register...]

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

Orcale9i Disk 1
[Only registered and activated users can see links. Click Here To Register...]
Orcale9i Disk 2
[Only registered and activated users can see links. Click Here To Register...]
Orcale9i Disk 3
[Only registered and activated users can see links. Click Here To Register...]

Oracle 9i mirror:

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

Oracle 9i mirror:

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

Update.

GM Tools, Server files, ECT.:
[Only registered and activated users can see links. Click Here To Register...]

Other Downloads.

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

Tutorial

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

01/23/2011 20:43 Mike0505 ∞#2

[ Reserved ]

Username: system
Password: password
Host: account

create user alef IDENTIFIED BY password;

-- Grant/Revoke role privileges
grant connect to alef;
grant resource to alef;
-- Grant/Revoke system privileges
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;

@c:\sql\account.sql;

--------------------------------------------------------------------------
For Tutorial sake, I used a VirtualPC, So I could not run the server, Or even get it to run properly..
So in the tutorial I show how to install Oracle, And use SQL Plus, and set up PLSQL_Developer_7.0.1中文版 and what files to edit..

There is Music, on the video, Make sure you dont blow your system. ( may be loud )

Thank you to Madmaxsrb, Be sure to press thanks button.

Quote:

Originally Posted by madmaxsrb

as I promised here's what still needs to be changed for the server started working:
1: the file:
[Only registered and activated users can see links. Click Here To Register...]
have to be here
2: go to the folder xxxxxx/INI/DatabaseInit....
[Only registered and activated users can see links. Click Here To Register...]
3:and edit the Database.ini and DBSERVERINFO.ini as shown on image(those ini files must be first decrypted and again after ecrypted)
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
and now that the server should start without problems, but not my case I have to turn off my internet connection, and that the server starts without errors .....

Now create acc for the game can login into the game without any problems, can move, mobs here and everything is ok, until im log out of the game, is it my problem occurs when a log out of the game no longer can not login, I get a message "can not access login server"
then have to clean the entire database, i should delete a character from the database, and when the All Clear from the database then can be re-login to server...

ps:
I apologize for my terrible English .. I used Google Translate ^_^

======================

Quote:

Originally Posted by Feldunost

Softwares used and approved : [Windows XP isn't the same way)

Install the following there:

Windows 2003 x86 Enterprise Edition R2 SP2
Oracle9i version
Navicat Premium (Recommended for easiest modifications)
Java JDK (It installs automatically JRE)
Visual C++ redistributable 2008 x86
Visual C++ redistributable 2010 x86
Visual C++ Express 2010 (It will install .NET Framework 4.0)
Download any old server files available with password if told: [Only registered and activated users can see links. Click Here To Register...]
Download Celestia Update Server Files

1: Oracle Installation

Available Products
Full installation of the first selection
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: (Copy theses files before on C:\)

@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 with :
Username: alef
Password: password
SID: account

Change thoses attributes for SERVERCONFIG table:
Section 1 and 201, WORLD attribute is Grayheon.
Section 1 and 201 and 401, ADDRESS attribute is not 127.0.0.1 but the ip adress of the server.
Section 1000, ADDRESS attribute is 127.0.0.1:99999

All sections, DBUSER + LOGDBUSER attribute is alef
All sections, DBPWD + LOGDBPWD attribute is password
All sections, DBDSN + LOGDBDSN attribute is account

Change thoses attributes for RPGWT table:
All SERVERID, change it to Grayheon.

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)
)
)

DON'T FORGET TO ERASE DEDICATED SERVER LINE ! (Not on Windows XP)

For INST1_HTTP specify host for 127.0.0.1 ! In TNSNAMES.ORA also.

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

Changed INI/DatabaseInit/Database.ini (user: alef, password is password, SID is account)
Changed INI/DatabaseInit/DBSERVERINFO.ini (user: alef, password is password, SID is account)

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. (Can be also Chinese Taiwan)

Account creation: (It can be added manually with Navicat easily)
Connect to SQL Plus with alef user and write the following:

Insert into ALEF.AMT_ACCOUNT (ACCOUNTID,PASSWORD) values ('minera','test');

Insert into ALEF.AMT_MASTER (ACCOUNTID,EMAIL,SOCIALNO,CREATION_DATE,LAST_DATE, MODIFY_DATE,PHONE,MOBILE,ZIPCODE,ADDR1,ADDR2,SMS_Y N,EMAIL_YN,PENALTY_GBN,PAUSE_DATE,IP,LOGINCNT,NOMI NATOR,RPG_LEVEL,LONEY_AGREEYN,LONEY_CHARGEYN,SEX) values ('minera','[Only registered and activated users can see links. Click Here To Register...]','18',to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),null,null,null,null,null,'N','N',' 0',null,null,null,null,null,null,null,null);

Start CAL_LoginServer.exe, wait until it finishes.
Start CAL_RelayServer.exe, wait until it finishes.
Start CAL_WorldServer.exe, wait until it finishes.

Wait 2 minutes after launching in order to allow sockets and communication between them.

Go to archlord folder, in my case it's : C:\Program Files (x86)\F-Archlord
Create text file and add: alefclient.exe /L192.168.1.xxx:11002 (ip adress of the server in LAN)
Rename it in .bat, make shortcut in desktop and launch !

YOU MUST HAVE THE CORRECT CLIENT !

If you need really help, call me
For Windows XP it is almost the same way but i kept on Server 2003 for most stability.

01/23/2011 21:56 archknup#3

nice guide ^^

01/23/2011 22:07 Mike0505 ∞#4

Quote:

Originally Posted by archknup

Original Guide:

Code:

[B]1: Oracle Installation [/B]
文件定位 File Location 

Select all the available products to install the first 

Enterprise Edition installation type selection 

General database configuration options 

Mts recovery service configuration options default port 2030 

global database name [B]account[/B]
 
Sid [B]account[/B] 

Database file location of your choice 

Database character set to use the default character set 

Start the installation 

Set sys password and system password 

Restart the machine end of the installation 

[B]Open [url]http://127.0.0.1/isqlplus/[/url] [/B]


[B]2.Start SQLPLUS, enter the following command [/B]

Create User:
 
create user alef IDENTIFIED BY password; 

Set role permissions 

-- Grant/Revoke role privileges -  
grant connect to alef;  
grant resource to alef;  
-- Grant/Revoke system privileges  
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;  

[B]
Import Database[/B] 

SQLPLUS to run 

@D:\sql\account.sql; \ \ path to your right can be a SQL 


[B]Database Guide[/B] 
modify SERVERCONFIG table after the server name, password. IP address for your server IP! 

客户端安装Oracle 9i 客户端，选管理员那个。 Oracle 9i client installation client, the election administrator that. 装完后把下面内容放到数据库安装目录和客户端安装目录下文件，路径是D:\oracle\ora92\network\admin\tnsnames.ora ，改成以下内容！ Bahrain the following content into the database and the client installation directory under the installation directory file path is D: \ oracle \ ora92 \ network \ admin \ tnsnames.ora, change the following! 


# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora # TNSNAMES.ORA Network Configuration File: D: \ oracle \ ora92 \ NETWORK \ ADMIN \ tnsnames.ora 
# Generated by Oracle configuration tools. # Generated by Oracle configuration tools. 

ACCOUNT = ACCOUNT = 
(DESCRIPTION = (DESCRIPTION = 
(ADDRESS_LIST = (ADDRESS_LIST = 
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.88)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.88) (PORT = 1521)) 
) ) 
(CONNECT_DATA = (CONNECT_DATA = 
(SERVICE_NAME = account) (SERVICE_NAME = account) 
) ) 
) ) 


启动服务端即可。 You can start the server.
Create New shortcut to the client, start the parameter bit [B]/L192.168.1.200: 11002 [/B]

As you see the original guide is a bit confusing, im stuck at Server step 2 intiate this server from the game server running process

Please if anyone can help me to run this server will be appreciated

I have the database propely installed and the oracle client is running, i have tried this in a Windows Xp Pro x86 and a Windows Server 2008 x64 and same results with both systems.

Im ok sharnig my files to anyone which want to help me to make this running.

Thanks for reading

Step 2 Is you open SQL Plus,Log in with alef, password, account, And Do the commands :

Create user alef IDENTIFIED BY passowrd;

ETC.

Where did you get this tut?
its not Complete.

01/23/2011 22:08 Mustlord59#5

Lol good thing you pointed that out i was about to follow it

01/23/2011 22:14 archknup#6

i dont mean to step 2 of the guide, i mean when you run the gameserver process the console say step 4 complete step 3 complete and step 2 (crash) thats my point.

Screen:

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

I have copy/paste the full guide so i dont know why you say its not full.

Do you have an expensive guide than this?

If yes would be great to share it with us please :)

Note that this is not my guide and my intention its to help not to confuse anyone

01/23/2011 22:22 Mike0505 ∞#7

yeah, I have my own Guide..
I'm going off memory..
But This guide is not Full..

01/23/2011 22:22 Mustlord59#8

First you have to run Cal_loginserver Cal_relayserver and Cal_worldserver and you had to delete all obj and obs files in the ini folder, and if that does not work Mike said its not complete so there are missing components of the server just wait till next week:D

And mike the first part of your tutorial should be how to install the database so we can have a foundation to work with

01/23/2011 22:22 Mike0505 ∞#9

If its Crashing Use The Celestia Archlord - Server Files Update package

01/23/2011 22:28 archknup#10

I used both of it same results :P

I removed the obs and obj files when using celestia and same result

Also i edited the dbserverinfo.ini and database.ini with my data and encrypted again

Any ideas? :P

01/23/2011 22:30 Mike0505 ∞#11

Wait for my Guide..
I'm not sure where you went wrong sorry.

Heading out to visit my mother.
be back in a few hours guys.

01/23/2011 23:33 .Monster!#12

omg FAIL

HIS TUTORIAL DONT WORK :)

SO GOOD LUCK WITH WINDOWS XP NEVER CAN RUN ON IT :)

HAHAHA

01/23/2011 23:57 darkneika#13

Quote:

Originally Posted by Bigbears

omg FAIL

HIS TUTORIAL DONT WORK :)

SO GOOD LUCK WITH WINDOWS XP NEVER CAN RUN ON IT :)

HAHAHA

fail...

all files is exe or bat: windows extensions

01/24/2011 00:56 xnvidia#14

Quote:

Originally Posted by Bigbears

omg FAIL

HIS TUTORIAL DONT WORK :)

SO GOOD LUCK WITH WINDOWS XP NEVER CAN RUN ON IT :)

HAHAHA

Go back to your Nlgames server retard.

01/24/2011 12:14 Ne(da)#15

Quote:

Originally Posted by Bigbears

omg FAIL

HIS TUTORIAL DONT WORK :)

SO GOOD LUCK WITH WINDOWS XP NEVER CAN RUN ON IT :)

HAHAHA

can i request a ban for this idiot
reason: for being an idiot lol

Page 1 of 99

Last »