Syreldar

April 16, 2014

did you already try DB_ADDR: localhost ?

The default db port is 15000

DB_ADDR is localhost for every core

Yes, but i put BIND_PORT = 14099 that should change the db port in 14099.

April 16, 2014

I always receive that error, curious is that if i put in game99 CONFIG:

P2P_PORT: 14099

DB_PORT: 14099

i receive no error.

But if i change one of them i receive the error.

April 16, 2014

BIND_PORT ( db ) = 14099

DB_ADDR (every core) = 14099

P2P game new = 15000

I practically inverted those two, can i do it?

April 16, 2014

And you should change BIND_PORT = 15000 to BIND_PORT = 14099

I've already think about this, but can i do it even if 14099 it's already a used port? ( game99's p2p )

April 16, 2014

etc/hosts:

# $FreeBSD: release/9.2.0/etc/hosts 109997 2003-01-28 21:29:23Z dbaker $
#
# Host Database
#
# This file should contain the addresses and aliases for local hosts that
# share this file.  Replace 'my.domain' below with the domainname of your
# machine.
#
# In the presence of the domain name service or NIS, this file may
# not be consulted at all; see /etc/nsswitch.conf for the resolution order.
#
#
::1 localhost localhost.my.domain
127.0.0.1 localhost localhost.my.domain
#
# Imaginary network.
#10.0.0.2 myname.my.domain myname
#10.0.0.3 myfriend.my.domain myfriend
#
# According to RFC 1918, you can use the following IP networks for
# private nets which will never be connected to the Internet:
#
# 10.0.0.0 -   10.255.255.255
# 172.16.0.0 -   172.31.255.255
# 192.168.0.0 -   192.168.255.255
#
# In case you want to be able to connect to the Internet, you need
# real official assigned numbers.  Do not try to invent your own network
# numbers but instead get one from your network provider (if any) or
# from your regional registry (ARIN, APNIC, LACNIC, RIPE NCC, or AfriNIC.)
#

ifconfig:

April 16, 2014

Channel1 syslog:

Apr 16 15:33:40.128246 :: InputDB::MapLocations 1
Apr 16 15:33:40.128268 :: MapLocation::Insert : 12 0 13099
Apr 16 15:33:40.128291 :: MapLocation::Insert : 81 0 13099
Apr 16 15:33:40.128307 :: MapLocation::Insert : 110 0 13099
Apr 16 15:33:40.128327 :: MapLocation::Insert : 111 0 13099
Apr 16 15:33:40.128342 :: MapLocation::Insert : 113 0 13099
Apr 16 15:33:40.128360 :: MapLocation::Insert : 114 0 13099
Apr 16 15:33:40.128376 :: MapLocation::Insert : 118 0 13099
Apr 16 15:33:40.128390 :: MapLocation::Insert : 119 0 13099
Apr 16 15:33:40.128405 :: MapLocation::Insert : 120 0 13099
Apr 16 15:33:40.128421 :: MapLocation::Insert : 121 0 13099
Apr 16 15:33:40.128439 :: MapLocation::Insert : 122 0 13099
Apr 16 15:33:40.128455 :: MapLocation::Insert : 123 0 13099
Apr 16 15:33:40.128470 :: MapLocation::Insert : 124 0 13099
Apr 16 15:33:40.128488 :: MapLocation::Insert : 125 0 13099
Apr 16 15:33:40.128503 :: MapLocation::Insert : 126 0 13099
Apr 16 15:33:40.128518 :: MapLocation::Insert : 127 0 13099
Apr 16 15:33:40.128533 :: MapLocation::Insert : 128 0 13099
Apr 16 15:33:40.128551 :: MapLocation::Insert : 181 0 13099
Apr 16 15:33:40.128567 :: MapLocation::Insert : 182 0 13099
Apr 16 15:33:40.128581 :: MapLocation::Insert : 183 0 13099
Apr 16 15:33:40.128599 :: MapLocation::Insert : 184 0 13099
Apr 16 15:33:40.128615 :: MapLocation::Insert : 185 0 13099
Apr 16 15:33:40.128629 :: MapLocation::Insert : 186 0 13099
Apr 16 15:33:40.128644 :: MapLocation::Insert : 187 0 13099
Apr 16 15:33:40.128662 :: MapLocation::Insert : 188 0 13099
Apr 16 15:33:40.128678 :: MapLocation::Insert : 189 0 13099
Apr 16 15:33:40.128695 :: MapLocation::Insert : 198 0 13099
Apr 16 15:33:40.128720 :: InputDB:P2P 0:14099
Apr 16 15:33:40.129577 :: SYSTEM: Trying to connect to 0:14099
SYSERR: Apr 16 15:33:40.129694 :: socket_connect: HOST 0:14099, could not connect.
Apr 16 15:33:40.129890 :: P2P Connector opened (host 0)

I think i found the problem..

He can't find the server host, it shouldn't be 0 (?)

April 16, 2014

It should be 127.0.0.1 or are you using an external mysql server?

You're right, i was mistaking, i left that modify for my old testserver that was using an external mysql server.

But this don't solve the problem.

I checked Game99's syserr.

It says this:

SYSERR: Apr 16 15:21:07.702179 :: pid_init: 
Start of pid: 7114
 
SYSERR: Apr 16 15:21:10.141437 :: Show: cannot find sectree by 506781x921383 mapindex 1
SYSERR: Apr 16 15:21:10.141465 :: Show: cannot find sectree by 506896x919815 mapindex 1
SYSERR: Apr 16 15:21:10.141485 :: Show: cannot find sectree by 506873x922693 mapindex 1
SYSERR: Apr 16 15:21:10.141501 :: Show: cannot find sectree by 503999x919800 mapindex 1
SYSERR: Apr 16 15:21:10.141518 :: Show: cannot find sectree by 504039x922681 mapindex 1
SYSERR: Apr 16 15:21:10.141539 :: Show: cannot find sectree by 506898x919967 mapindex 1
SYSERR: Apr 16 15:21:10.141557 :: Show: cannot find sectree by 506877x922521 mapindex 1
SYSERR: Apr 16 15:21:10.141573 :: Show: cannot find sectree by 504163x919799 mapindex 1
SYSERR: Apr 16 15:21:10.141592 :: Show: cannot find sectree by 504218x922677 mapindex 1
SYSERR: Apr 16 15:21:10.141613 :: Show: cannot find sectree by 506899x920135 mapindex 1
SYSERR: Apr 16 15:21:10.141632 :: Show: cannot find sectree by 504323x919808 mapindex 1
SYSERR: Apr 16 15:21:10.141653 :: Show: cannot find sectree by 506900x920304 mapindex 1
SYSERR: Apr 16 15:21:10.141676 :: Show: cannot find sectree by 506881x920473 mapindex 1
SYSERR: Apr 16 15:21:10.141695 :: Show: cannot find sectree by 506899x920674 mapindex 1
SYSERR: Apr 16 15:21:10.141712 :: Show: cannot find sectree by 506884x920820 mapindex 1
SYSERR: Apr 16 15:21:10.141728 :: Show: cannot find sectree by 506886x920973 mapindex 1
SYSERR: Apr 16 15:21:10.141744 :: Show: cannot find sectree by 506868x921131 mapindex 1
SYSERR: Apr 16 15:21:10.141761 :: Show: cannot find sectree by 506726x922696 mapindex 1
SYSERR: Apr 16 15:21:10.141777 :: Show: cannot find sectree by 506876x922381 mapindex 1
SYSERR: Apr 16 15:21:10.141793 :: Show: cannot find sectree by 506897x922221 mapindex 1
SYSERR: Apr 16 15:21:10.141810 :: Show: cannot find sectree by 506898x922060 mapindex 1
SYSERR: Apr 16 15:21:10.141826 :: Show: cannot find sectree by 506892x921873 mapindex 1
SYSERR: Apr 16 15:21:10.141845 :: Show: cannot find sectree by 506881x921667 mapindex 1
SYSERR: Apr 16 15:21:10.141861 :: Show: cannot find sectree by 503992x922508 mapindex 1
SYSERR: Apr 16 15:21:10.141877 :: Show: cannot find sectree by 504492x919823 mapindex 1
SYSERR: Apr 16 15:21:10.141897 :: Show: cannot find sectree by 504638x919817 mapindex 1
SYSERR: Apr 16 15:21:10.141922 :: Show: cannot find sectree by 504826x919821 mapindex 1
SYSERR: Apr 16 15:21:10.141950 :: Show: cannot find sectree by 504999x919831 mapindex 1
SYSERR: Apr 16 15:21:10.141966 :: Show: cannot find sectree by 505153x919810 mapindex 1
SYSERR: Apr 16 15:21:10.141982 :: Show: cannot find sectree by 505307x919814 mapindex 1
SYSERR: Apr 16 15:21:10.141999 :: Show: cannot find sectree by 505441x919826 mapindex 1
SYSERR: Apr 16 15:21:10.142015 :: Show: cannot find sectree by 505585x919816 mapindex 1
SYSERR: Apr 16 15:21:10.142031 :: Show: cannot find sectree by 505751x919837 mapindex 1
SYSERR: Apr 16 15:21:10.142047 :: Show: cannot find sectree by 505903x919811 mapindex 1
SYSERR: Apr 16 15:21:10.142063 :: Show: cannot find sectree by 506069x919830 mapindex 1
SYSERR: Apr 16 15:21:10.142079 :: Show: cannot find sectree by 506213x919820 mapindex 1
SYSERR: Apr 16 15:21:10.142095 :: Show: cannot find sectree by 506422x919827 mapindex 1
SYSERR: Apr 16 15:21:10.142112 :: Show: cannot find sectree by 506654x919827 mapindex 1
SYSERR: Apr 16 15:21:10.142128 :: Show: cannot find sectree by 506577x922689 mapindex 1
SYSERR: Apr 16 15:21:10.142144 :: Show: cannot find sectree by 506409x922690 mapindex 1
SYSERR: Apr 16 15:21:10.142160 :: Show: cannot find sectree by 506246x922689 mapindex 1
SYSERR: Apr 16 15:21:10.142177 :: Show: cannot find sectree by 506041x922695 mapindex 1
SYSERR: Apr 16 15:21:10.142193 :: Show: cannot find sectree by 505885x922671 mapindex 1
SYSERR: Apr 16 15:21:10.142209 :: Show: cannot find sectree by 505714x922689 mapindex 1
SYSERR: Apr 16 15:21:10.142225 :: Show: cannot find sectree by 505502x922677 mapindex 1
SYSERR: Apr 16 15:21:10.142247 :: Show: cannot find sectree by 505291x922672 mapindex 1
SYSERR: Apr 16 15:21:10.142281 :: Show: cannot find sectree by 505089x922668 mapindex 1
SYSERR: Apr 16 15:21:10.142298 :: Show: cannot find sectree by 504908x922698 mapindex 1
SYSERR: Apr 16 15:21:10.142314 :: Show: cannot find sectree by 504730x922685 mapindex 1
SYSERR: Apr 16 15:21:10.142330 :: Show: cannot find sectree by 504392x922683 mapindex 1
SYSERR: Apr 16 15:21:10.142370 :: Show: cannot find sectree by 504557x922699 mapindex 1
SYSERR: Apr 16 15:21:10.142390 :: Show: cannot find sectree by 503980x919951 mapindex 1
SYSERR: Apr 16 15:21:10.142406 :: Show: cannot find sectree by 504014x922342 mapindex 1
SYSERR: Apr 16 15:21:10.142422 :: Show: cannot find sectree by 503997x920115 mapindex 1
SYSERR: Apr 16 15:21:10.142438 :: Show: cannot find sectree by 503963x920269 mapindex 1
SYSERR: Apr 16 15:21:10.142457 :: Show: cannot find sectree by 503961x922166 mapindex 1
SYSERR: Apr 16 15:21:10.142473 :: Show: cannot find sectree by 503998x920423 mapindex 1
SYSERR: Apr 16 15:21:10.142489 :: Show: cannot find sectree by 504003x922011 mapindex 1
SYSERR: Apr 16 15:21:10.142505 :: Show: cannot find sectree by 504013x920620 mapindex 1
SYSERR: Apr 16 15:21:10.142521 :: Show: cannot find sectree by 504006x921809 mapindex 1
SYSERR: Apr 16 15:21:10.142542 :: Show: cannot find sectree by 503962x920789 mapindex 1
SYSERR: Apr 16 15:21:10.142561 :: Show: cannot find sectree by 503931x921662 mapindex 1
SYSERR: Apr 16 15:21:10.142581 :: Show: cannot find sectree by 503948x920923 mapindex 1
SYSERR: Apr 16 15:21:10.142598 :: Show: cannot find sectree by 503940x921527 mapindex 1
SYSERR: Apr 16 15:21:10.142614 :: Show: cannot find sectree by 994112x214380 mapindex 41
SYSERR: Apr 16 15:21:10.142633 :: Show: cannot find sectree by 992254x213259 mapindex 41
SYSERR: Apr 16 15:21:10.142649 :: Show: cannot find sectree by 992685x213252 mapindex 41
SYSERR: Apr 16 15:21:10.142667 :: Show: cannot find sectree by 993079x213246 mapindex 41
SYSERR: Apr 16 15:21:10.142686 :: Show: cannot find sectree by 992308x215351 mapindex 41
SYSERR: Apr 16 15:21:10.142707 :: Show: cannot find sectree by 992672x215333 mapindex 41
SYSERR: Apr 16 15:21:10.142729 :: Show: cannot find sectree by 993042x215326 mapindex 41
SYSERR: Apr 16 15:21:10.142746 :: Show: cannot find sectree by 994215x215061 mapindex 41
SYSERR: Apr 16 15:21:10.142763 :: Show: cannot find sectree by 994196x213760 mapindex 41
SYSERR: Apr 16 15:21:10.142779 :: Show: cannot find sectree by 994799x212818 mapindex 41
SYSERR: Apr 16 15:21:10.142795 :: Show: cannot find sectree by 994568x212822 mapindex 41
SYSERR: Apr 16 15:21:10.142811 :: Show: cannot find sectree by 994343x212822 mapindex 41
SYSERR: Apr 16 15:21:10.142830 :: Show: cannot find sectree by 994113x212830 mapindex 41
SYSERR: Apr 16 15:21:10.142846 :: Show: cannot find sectree by 993874x212855 mapindex 41
SYSERR: Apr 16 15:21:10.142861 :: Show: cannot find sectree by 993644x212885 mapindex 41
SYSERR: Apr 16 15:21:10.142878 :: Show: cannot find sectree by 993400x212891 mapindex 41

I'm not an expert in map errors, what's that? :/

April 16, 2014

What's in DB_ADDR in channel1?

server's ip.

DB_ADDR: 178.32.42.164

April 16, 2014

Oh guys i'm so sorry, i've already solved database problem, i just forgot to edit :/

But the real problem is this:

Channel1:

SYSERR: Apr 15 20:53:16.444970 :: pid_init: 
Start of pid: 2472
 
 
SYSERR: Apr 15 20:53:24.325560 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.327205 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.327416 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.327519 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.327584 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.640284 :: socket_connect: HOST 0:14099, could not connect.

And the could not connect problem it's due to this problem, i'm pretty sure of it, the ip in database config it's correct and it works on another server that runs on 2089m.

I wanted to upgrade that server to 40250 and i've added some my own files that worked perfectly on my testserver, i changed even map folder with mine, wtf is wrong with this problem?

conf.txt(db):

WELCOME_MSG = "DB Server has been started"
 
SQL_ACCOUNT = "178.32.42.164 account root *PASSWORD 0"
SQL_PLAYER = "178.32.42.164 player root *PASSWORD 0"
SQL_COMMON = "178.32.42.164 common root *PASSWORD 0"
SQL_HOTBACKUP = "178.32.42.164 hotbackup root *PASSWORD 0" 
 
TABLE_POSTFIX = ""
 
BIND_PORT               = 15000
DB_SLEEP_MSEC           = 10
CLIENT_HEART_FPS        = 10
HASH_PLAYER_LIFE_SEC    = 600
BACKUP_LIMIT_SEC        = 3600
PLAYER_ID_START = 100
PLAYER_DELETE_LEVEL_LIMIT = 99
PLAYER_DELETE_CHECK_SIMPLE = 1
 
ITEM_ID_RANGE = 2000000000 2100000000
 
MIN_LENGTH_OF_SOCIAL_ID = 6
 
#NAME_COLUMN = "locale_name"
#LOCALE = "italy"
SIMPLE_SOCIALID = 1

April 15, 2014

I will use this gamefile once it will have less bug(s) than it has.

It has bug(s) that a normal 40250 gamefile hasn't,

But it's a very great job, impressive i suppose, once the bug will have gone, this will be a lot better than gf or sg's gamefiles, but for now it's not viable in a public server.

April 15, 2014

since your yang got resetted to 4,2kkk I guess there's some more behind that since it's the length of unsigned int. The command allows you to set such high values, but somewhere in the game source there's a restriction you seem to not have noticed yet.

I'm not sure about it but maybe you can check the dbcache too. And look for syserr/syslog, maybe they'll provide you overflow-messages.

ah, pretty what he said before me, didn't noticed.

April 15, 2014

That seems to be an unsigned-int limit, 2^32-1

You must check length.h, and check syserr too, to be sure it's not recognized as overflow.

April 15, 2014

Would appreciate some assistance

40k revision:

auth:

SYSERR: Apr 15 20:53:14.434429 :: pid_init: 
Start of pid: 2469

db:

SYSERR: Apr 15 20:53:12 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Apr 15 20:53:12 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'size' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (101, "??", "Wildhund", 0, 0, 0, 1, 0, 0, 1, 0,

(it repeats the "Data truncated error" for every mob in my mob_proto.txt)

channel1:

SYSERR: Apr 15 20:53:16.444970 :: pid_init: 
Start of pid: 2472
 
 
SYSERR: Apr 15 20:53:24.325560 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.327205 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.327416 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.327519 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.327584 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.640284 :: socket_connect: HOST 0:14099, could not connect.

April 15, 2014

Hello,

title says all, i didn't find anything about it.

April 14, 2014

Hello,

I've already checked RBY code in questlib.lua, and it's okay, why they return a white text like say(text)?

April 12, 2014

You mistake, the position of the war should change after putting a sword, despite of see it or not, you mistake something, and i'm pretty sure the query is the problem.

Better if you check the compression type.

April 12, 2014

The first problem i see is the query serverside, very bad query maker or very bad query-creator? :asd:

Okay, uhm make sure the compression type is < 2 and make sure you pack new things well, for testing, re-unpack it and try to open the weapon model.

April 11, 2014

Hello Guys,

i've got the questionmark problem after character select in the loading screens my client gives me this error.

I only extract the hole pack folder and repacked it. I created every .xml with a python script. I used the extractor from tim66613.

And the 34669 binary.

I've got no syserr clientside so i don't know what i can post so thats way easier to understand.

Kind regards

Marvin

log.txt , not syserr.txt

April 10, 2014

Bump, need metin2_patch_pet2

April 10, 2014

Metin2 pack maker wont make you the dat (iv) file. Ill try to unpack it for you

Thank u very much, i noticed :/

The problem is that i don't want to be dependent, i want to learn how to do it by myself.

April 9, 2014

It appears in syslog inside the "db" folder

Apr 9 17:22:22 :: [     1850] return 0/0/0 async 0/0/0

Apr 9 17:22:27 :: [     1900] return 0/0/0 async 0/0/0

Apr 9 17:22:32 :: [     1950] return 0/0/0 async 0/0/0

Apr 9 17:22:37 :: [     2000] return 0/0/0 async 0/0/0

Apr 9 17:22:42 :: [     2050] return 0/0/0 async 0/0/0

Apr 9 17:22:47 :: [     2100] return 0/0/0 async 0/0/0

Apr 9 17:22:52 :: [     2150] return 0/0/0 async 0/0/0

Apr 9 17:22:57 :: [     2200] return 0/0/0 async 0/0/0

Apr 9 17:23:02 :: [     2250] return 0/0/0 async 0/0/0

Apr 9 17:23:07 :: [     2300] return 0/0/0 async 0/0/0

Apr 9 17:23:12 :: [     2350] return 0/0/0 async 0/0/0

Apr 9 17:23:17 :: [     2400] return 0/0/0 async 0/0/0

Apr 9 17:23:22 :: [     2450] return 0/0/0 async 0/0/0

message like this appears every 5 seconds during the server is started (without anyone logged in)

is there any way to remove this ?

thanks in advance

every 5 seconds the number increase of "+50"

it's only a timer of a daemon that every 5 seconds checks the server.

April 9, 2014

The problem isn't the .net framework package, the problem is that the application isn't compiled for 32-bit running systems, and i expect that this problem will be solved.

April 9, 2014

Hey there,

1st)

EDIT: 1st problem solved by myself.

2nd)

Metin2 released a new patch: metin2_patch_pet2, i was searching for that patch's serverside-package, i heard about a "package-maker" but i can't find it.

April 6, 2014

http://www.inforge.net/community/metin2-howto-and-addon-server-privati/386967-release-cambia-equip-professionale.html

I think this is the equipment system

Yep, it is.

April 3, 2014

You are not qualified to use dragon soul system as well as using item command with dragon soul items.
quest ds_give_qualification begin
	state start begin
		when login begin
			ds.give_qualification()
		end
	end
end

Do what he says, it's your solution, or you can complete the quest the alchemist gives to you, 10 stones and he will qualify you.

Sign In

Forums

Store

Third Party - Providers Directory

Feature Plan

Release Notes

Docs

Events

Posts posted by Syreldar

Important Information