Originally Posted by madmaxsrb (Post 8938008)

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 ^_^

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.

Originally Posted by archknup (Post 8806568)

Original Guide:

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

Originally Posted by Bigbears (Post 8807795)

omg FAIL


HIS TUTORIAL DONT WORK :)

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


HAHAHA

Originally Posted by Bigbears (Post 8807795)

omg FAIL


HIS TUTORIAL DONT WORK :)

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


HAHAHA

Originally Posted by Bigbears (Post 8807795)

omg FAIL


HIS TUTORIAL DONT WORK :)

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


HAHAHA