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

[XeonNull]

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

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

You must be registered to see links

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

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

You must be registered to see links

Spoiler

You must be registered to see links

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 ?