Archlord Server Error Pls Help me

[dtkostra]

Hi pls help me with my server i dont know where i have error.

All is in this my video here:



I use this tutorial here:

I use normal Win XP SP3 with all netframeworks and full updates.

and files here:


I pls for help very much
I sorry for my bad english.

Thx Kostra.

[Ricks27]

Hi,

You have correctly entered the IP address of the server in the SERVERCONFIG table?
You have changed this file : C:\oracle\ora92\network\admin\tnsnames.ora?

Cordially,

[Havocker]

i use windows 8.1 pro with oracle database 11g x86

everything works fine and faster then windows xp...

Check your IP Config in Database & Server ini Files.

Server Files INI:

INI\DatabaseInit\Databse.ini
INI\DatabaseInit\DBSERVERINFO.ini

INI\Databse.ini
INI\DBSERVERINFO.ini

Connect to your Oracle Database and check your SERVERCONFIG Table for the IP Address:

Example:

192.168.0.14:11008
192.168.0.14:11004
192.168.0.14:11002

OR use this sql Script with Navicat:

!!!!!! change your IP and Your Server Name !!!!!!

insert into SERVERCONFIG (SECTION, MODULEDATA1, WORLD, TYPE, ADDRESS, CONTROLAREA, DBUSER, DBPWD, DBDSN, LOGDBUSER, LOGDBPWD, LOGDBDSN, SHOW, DBVENDER, EXTRA)
values ('1', 'AgsmServerManager2', 'Archlord Server Name', '8', '192.168.0.14:11008', '-2560000,-2560000,2560000,2560000', 'alef', 'password', 'Archlord Server Name', 'alef', 'password', 'Archlord Server Name', 'T','', 'AdultServer=N,NewServer=Y,IniDir=Ini\\Adult,ExpAdjRatio=0.01,DroppAdjRatio=1,AccountAuth=D,AllAdmin=Y');

insert into SERVERCONFIG (SECTION, MODULEDATA1, WORLD, TYPE, ADDRESS, CONTROLAREA, DBUSER, DBPWD, DBDSN, LOGDBUSER, LOGDBPWD, LOGDBDSN, SHOW, DBVENDER, EXTRA)
values ('201', 'AgsmServerManager2', 'Archlord Server Name', '4', '192.168.0.14:11004', '-2560000,-2560000,2560000,2560000', 'alef', 'password', 'Archlord Server Name', 'alef', 'password', 'Archlord Server Name', 'T', '', 'AdultServer=N,NewServer=Y,IniDir=Ini\\Adult,ExpAdjRatio=0.01,DroppAdjRatio=1,AccountAuth=D,AllAdmin=Y');

insert into SERVERCONFIG (SECTION, MODULEDATA1, WORLD, TYPE, ADDRESS, CONTROLAREA, DBUSER, DBPWD, DBDSN, LOGDBUSER, LOGDBPWD, LOGDBDSN, SHOW, DBVENDER, EXTRA)
values ('401', 'AgsmServerManager2', 'Login1', '2', '192.168.0.14:11002', '-2560000,-2560000,2560000,2560000', 'alef', 'password', 'Archlord Server Name', 'alef', 'password', 'Archlord Server Name', 'T', '', 'AdultServer=N,NewServer=Y,IniDir=Ini\\Adult,ExpAdjRatio=0.01,DroppAdjRatio=1,AccountAuth=D,AllAdmin=Y');

insert into SERVERCONFIG (SECTION, MODULEDATA1, WORLD, TYPE, ADDRESS, CONTROLAREA, DBUSER, DBPWD, DBDSN, LOGDBUSER, LOGDBPWD, LOGDBDSN, SHOW, DBVENDER, EXTRA)
values ('1000', 'AgsmServerManager2', 'MASTER', '1', '127.0.0.1:99999', '-2560000,-2560000,2560000,2560000', 'alef', 'password', 'Archlord Server Name', 'alef', 'password', 'Archlord Server Name', 'T', 'T', 'AdultServer=N,NewServer=Y,IniDir=Ini\\Adult,ExpAdjRatio=0.01,DroppAdjRatio=1,AccountAuth=D,AllAdmin=Y');

[dtkostra]

in server config i have all ip adress 127.0.0.1 (localhost right?)

IN TNSNAMES:

# TNSNAMES.ORA Network Configuration File: D:\EMULATOR\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 =
(SERVER = DEDICATED)
(SERVICE_NAME = account)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = )
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

all i have 127.0.0.1

and i muss change all in folder databaseinit as in INI???

INI/database.ini - i have change
INI/DBSERVERINFO.ini - i have change

databaseinit/database.ini - i change this as in INI/database.ini
databaseinit/DBSERVERINFO.ini - i change this as in INI/DBSERVERINFO.ini


I think that all three boot files are repeated over and over the same
it is seen in the fact my video on youtube (google translate)

my database.ini:
[DATABASE]
0=DSN(account)USER(alef)PWD(mypassword)CONNECTION( 3)LIB(OCI)

my DBSERVERINFO.ini:
[DATABASE]
DSN=account
USER=alef
PWD=mypassword

[Ricks27]

Originally Posted by dtkostra

in server config i have all ip adress 127.0.0.1 (localhost right?)

IN TNSNAMES:

# TNSNAMES.ORA Network Configuration File: D:\EMULATOR\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 =
(SERVER = DEDICATED)
(SERVICE_NAME = account)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = )
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

all i have 127.0.0.1

and i muss change all in folder databaseinit as in INI???

INI/database.ini - i have change
INI/DBSERVERINFO.ini - i have change

databaseinit/database.ini - i change this as in INI/database.ini
databaseinit/DBSERVERINFO.ini - i change this as in INI/DBSERVERINFO.ini


I think that all three boot files are repeated over and over the same
it is seen in the fact my video on youtube (google translate)

my database.ini:
[DATABASE]
0=DSN(account)USER(alef)PWD(mypassword)CONNECTION( 3)LIB(OCI)

my DBSERVERINFO.ini:
[DATABASE]
DSN=account
USER=alef
PWD=mypassword

1.

# TNSNAMES.ORA Network Configuration File: D:\EMULATOR\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ACCOUNT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ==> Use your local ip
)
(CONNECT_DATA =
(SERVER = DEDICATED) ==> Remove
(SERVICE_NAME = account)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = )
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


2.

Table SERVERCONFIG , Field ADDRESS, Replace 127.0.0.1 by your local ip.


3.

Restart the VM.

[madmaxsrb]

just use you Lan card ip for example 192.168.0.1 or disable lan card and us 172.0.0.1

[dtkostra]

sec pls

so maybe is all ok but pls see this my video pls and say me if is all ok or not

[Ricks27]

Originally Posted by dtkostra

sec pls

so maybe is all ok but pls see this my video pls and say me if is all ok or not

Everything is Ok for me with the consoles.

What changes have you made​​?

[dtkostra]

this IP i change and remove this server=dedicated and change server name

all server is now ok all run but i have now next small problem

i have normal dynamic VIP IP address so all for server with connection for people is ok all dynamic ports have i forwarded to my PC with this AL server...

i testing now how can i log my friends from internet...
login server and relay is ok, my friend can login to my server and create characters ....
But when he click to Connected for login ingame, so game say "server connection has ended" but server run normaly next...this problem i have from my friend

and my problem from home, where i have this server is:
i can normal loged to server, create characters, login in to world, but when i exit game, so when i wont log in back to game, so server dont know me and in server log server write "character "dtkostra" was deleted..... server normaly deleted me when i loged off,but in table AMT_ACCOUNT im writed but i cant loged this acc (and i muss create new acc in table AMT_ACCOUNT) lol

next help pls:
pls how i can setup my permission as admin server

sorry for my chaotic english

(for setup GMs permision can i use this
) ??????

[Ricks27]

Originally Posted by dtkostra

this IP i change and remove this server=dedicated and change server name

all server is now ok all run but i have now next small problem

i have normal dynamic VIP IP address so all for server with connection for people is ok all dynamic ports have i forwarded to my PC with this AL server...

i testing now how can i log my friends from internet...
login server and relay is ok, my friend can login to my server and create characters ....
But when he click to Connected for login ingame, so game say "server connection has ended" but server run normaly next...this problem i have from my friend

and my problem from home, where i have this server is:
i can normal loged to server, create characters, login in to world, but when i exit game, so when i wont log in back to game, so server dont know me and in server log server write "character "dtkostra" was deleted..... server normaly deleted me when i loged off,but in table AMT_ACCOUNT im writed but i cant loged this acc (and i muss create new acc in table AMT_ACCOUNT) lol

next help pls:
pls how i can setup my permission as admin server

sorry for my chaotic english

(for setup GMs permision can i use this
) ??????

1. How log your friends

- Use Hamachi,
- or Use a static IP,

I don't know if people have already used a dynamic IP to provide access to their servers.


2. Character delete

Use this stored procedure to create an account :


It is not enough to create a record in the table AMT_ACCOUNT to create an account. It should also create a record in the table AMT_MASTER.


3. How have the GM command

You can use this tutorial :


Cordially,

[Docsocso]

Originally Posted by Ricks27

1. How log your friends

- Use Hamachi,
- or Use a static IP,

I don't know if people have already used a dynamic IP to provide access to their servers.


2. Character delete

Use this stored procedure to create an account :


It is not enough to create a record in the table AMT_ACCOUNT to create an account. It should also create a record in the table AMT_MASTER.


3. How have the GM command

You can use this tutorial :


Cordially,

Active manner dynamic DNA with a service?

[dtkostra]

1.)
yes if I want to have a public server must have a public IP (dynamic IP)
I pay for my address extra fee, I can have public servers
I tested with a friend and he could create a character on my server but can not go directly to the game

for information:
my VIP public (dynamic) IP address is: 77.104.238.37
my PC IP address is: 192.168.1.200

in router i have all public ports routed to my PC

for example: i have my private Teamspeak 3 server on my PC and people can normaly connect to my TS3.

Rick pls know u how TCP port is for login directly to game
i say u, my friend can normaly login and create character on my server,but he can not log directly ingame.

for information:
in serverconfig i have this four ip address with ports:

192.168.1.200:11008 - (this is world server port)
192.168.1.200:11004 - (this is relay server port)
192.168.1.200:11002 - (this is login server port)
192.168.1.200:65000 - (I DONT KNOW WHAT THIS IS)
I have all the ports enabled in the router

and next port we have:
2030 maybe this is port for remote login to database - right??
1521 any TCP port I DONT KNOW FOR WHAT IS THIS PORT

I had in the past, wow server, where the server was almost the same as here in Archlord and people are normally connected to a server.

[Ricks27]

Originally Posted by dtkostra

1.)
yes if I want to have a public server must have a public IP (dynamic IP)
I pay for my address extra fee, I can have public servers
I tested with a friend and he could create a character on my server but can not go directly to the game

for information:
my VIP public (dynamic) IP address is: 77.104.238.37
my PC IP address is: 192.168.1.200

in router i have all public ports routed to my PC

for example: i have my private Teamspeak 3 server on my PC and people can normaly connect to my TS3.

Rick pls know u how TCP port is for login directly to game
i say u, my friend can normaly login and create character on my server,but he can not log directly ingame.

for information:
in serverconfig i have this four ip address with ports:

192.168.1.200:11008 - (this is world server port)
192.168.1.200:11004 - (this is relay server port)
192.168.1.200:11002 - (this is login server port)
192.168.1.200:65000 - (I DONT KNOW WHAT THIS IS)
I have all the ports enabled in the router

and next port we have:
2030 maybe this is port for remote login to database - right??
1521 any TCP port I DONT KNOW FOR WHAT IS THIS PORT

I had in the past, wow server, where the server was almost the same as here in Archlord and people are normally connected to a server.

I saw on another post that he had to open the port 4277 does not have the message "Server connection as end".

[dtkostra]

ok i test this with my friend he is now online too - im fast back

[Havocker]

when i use the ip from hamachi in serverconfig so i can start Archlord Server too.

You and your Friend have to use the Client with Archlord.bat like this:
alefclient.exe /L192.168.0.1:11002 << change to Your Hamachi IP