[GUIDE] Allods 4.0.02.42 server setup (start local game server)

[XeonNull]

Запустил , добавил новые карты, шард полетел

en:
Start server,add new maps, shard crashes.

To view the content, you need to sign in or register

Кто-нибудь может полностью расписать структуру сервера(где изменять для добавления карт, вещей,изменения механик)

Anybody can explain how server works(add new items,maps etc)?

This code get error

      long l1 = localDataInputStream.readLong();
      
      l3 = System.currentTimeMillis();
      long l4 = Math.abs(l1 - l3);
      if (l4 >= TimeUnit.SECONDS.toMillis(20L))

idk how this emu ever works

l1 - time sended by emu

after if server send error

UPD:

Fixed server emu

To view the content, you need to sign in or register

Spoiler

To view the content, you need to sign in or register

Hi,

Thank you very much for this topic. What do I get an error in the text of the picture. I would appreciate if you can help.

i clean bd allods_online_rc_4_0_02
on mysql.

 

[ae5140]

Невозможно обработать. База данных в недопустимом состоянии!
прикрепите server.log файл:
(server/server_bin/accountServer/out/xx-xx.xx_xx_xx.rev_xxxxxx/logs/server.log)

===en=translate===

Can't process. Database in invalid state!
attach server.log file:
(server/server_bin/accountServer/out/xx-xx.xx_xx_xx.rev_xxxxxx/logs/server.log)

I apologize for not for log messages. Here's server logs.

 

[s1eeper]

I apologize for not for log messages. Here's server logs.

from logs:

[06-01 08:03:43,518, 77808] main - ERROR verify : Datababase check fail: table hash_algorithms not equals in database and in config.
Reasons: Column id serэal doesn't exists
Column constraэnt `idx_hash_algorithms_name` doesn't exists

check postgres database for existence of the table 'hash_algorithms'.
Or execute sql file for creation and updating 'hash_algorithms':

 

[ae5140]

from logs:

check postgres database for existence of the table 'hash_algorithms'.
Or execute sql file for creation and updating 'hash_algorithms':

I'm new to this. How to perform this operation.

 

[s1eeper]

I'm new to this. How to perform this operation.

I use Navicat Premium - powerful soft for administration of databases.

 

[ae5140]

I use Navicat Premium - powerful soft for administration of databases.

I just found out I could connect with Navicat Thank you. But I get the following error when installing SQL.

[Err] ERROR: table "hash_algorithms" does not exist

[Err] /*
Navicat PGSQL Data Transfer


Source Server : ao
Source Server Version : 90400
Source Host : localhost:5432
Source Database : allods_account_rc_4_0_02
Source Schema : public


Target Server Type : PGSQL
Target Server Version : 90400
File Encoding : 65001


Date: 2015-06-03 03:37:27
*/




-- ----------------------------
-- Table structure for "public"."hash_algorithms"
-- ----------------------------
DROP TABLE "public"."hash_algorithms";
[Msg] Finished - Unsuccessfully
--------------------------------------------------

 

[s1eeper]

But I get the following error when installing SQL.

Try to execute two commands manually:
INSERT INTO "public"."hash_algorithms" VALUES ('1', 'SHA-1', 'f', 'UTF-8');
INSERT INTO "public"."hash_algorithms" VALUES ('2', 'MD5', 't', 'UTF-8');
or lead the table to the following look:

 

[ae5140]

Try to execute two commands manually:
INSERT INTO "public"."hash_algorithms" VALUES ('1', 'SHA-1', 'f', 'UTF-8');
INSERT INTO "public"."hash_algorithms" VALUES ('2', 'MD5', 't', 'UTF-8');
or lead the table to the following look:

Thank you for your help. I created the table but did not.

 

[matheusbalan]

Hello,


I have a little Problem when starting the "startAccountServer_local".

server_log:
View attachment 152184

I tried to edit the file, as suggested in comment # 16, however, the error continues.




anyone know what it Could be?


Thank you.

 

[s1eeper]

Thank you for your help. I created the table but did not.

Postgres database has to have these tables:

account
account_editions
account_shard_info
collection_editions
hardware_ban
hash_algorithms
operator_algorithms
params
relogin
sanction
scheme_patches
shard
subscription_history

These tables have to be created automatically at the first installation of the server.
On a screenshot at you only two tables.
Try to reinstall the server anew.

 

[ae5140]

Postgres database has to have these tables:

These tables have to be created automatically at the first installation of the server.
On a screenshot at you only two tables.
Try to reinstall the server anew.

I am setting the table, but do not occur as described in the Guide. Can you give the backup of SQL statements?

Os: Windows 8.1 64 bit.

 

[fido67]

hi ; why my phpadmin is not here ? when i click on there are nothing



hi my problem was settle but where I make the etape 4 ?



and how i edit the RAM ? pls

 

[s1eeper]

Can you give the backup of SQL statements?

View attachment base.zip

and how i edit the RAM ? pls

edit server_bin\shard\startServerDefault.bat:

startServerCustom.bat cfg/shard.xml maps.cfg your ram in megabytes

 

[fido67]

startServerCustom.bat cfg/shard.xml maps.cfg your ram in megabytes ; for this how I config the RAM in megabyte ?

 

[ae5140]

View attachment 152206

You're very good. After trying them again I will write here the result. Thank you.

----------------------------------------

Is it possible to be able to give .backup or .xml backup of this database? I get an error at all.

Example errors;

[Err] ERROR:  table "hardware_ban" does not exist

[Err] /*
Navicat PGSQL Data Transfer


Source Server         : ao
Source Server Version : 90400
Source Host           : localhost:5432
Source Database       : allods_account_rc_4_0_02
Source Schema         : public


Target Server Type    : PGSQL
Target Server Version : 90400
File Encoding         : 65001


Date: 2015-06-07 18:09:44
*/




-- ----------------------------
-- Table structure for "public"."hardware_ban"
-- ----------------------------
DROP TABLE "public"."hardware_ban";
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[Err] ERROR:  column "id" referenced in foreign key constraint does not exist

[Err] -- ----------------------------
-- Foreign Key structure for table "public"."account_editions"
-- ----------------------------
ALTER TABLE "public"."account_editions" ADD FOREIGN KEY ("edition_id") REFERENCES "public"."collection_editions" ("id") ON DELETE RESTRICT ON UPDATE CASCADE;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

 

[s1eeper]

You're very good. After trying them again I will write here the result. Thank you.

try to create manually that it turned out such:

 

[ae5140]

try to create manually that it turned out such:

All I get an error even though I create with my hands. this way is it possible to get a replacement with pgAdmin 3? I was able to install a separate database seamlessly pick up spare myself in this way.

 

[k0d0k]

thank for advanced tutorial friend,
i try worked.
but where tools for edit client.

 

[fido67]

hi ; I havent got unederstand you s1eeper; you can make screenshot pls ?

 

[s1eeper]

All I get an error even though I create with my hands. this way is it possible to get a replacement with pgAdmin 3? I was able to install a separate database seamlessly pick up spare myself in this way.

I don't know. I don't use pgAdmin 3.

hi ; I havent got unederstand you s1eeper; you can make screenshot pls ?