Support Topic - Zenaris Source

[bvpt2010]

Since the people try to bypass the topic saying thx and other spam stuff I created this topic related to this files:
 

 

Quest part fix for FreeBSD servers running Zenaris Source:
This fix addresses issues with certain quests not working as intended. If you're running your server on FreeBSD 13.1-RELEASE 64 bits and have encountered quest-related problems, this might be the solution you're looking for.

**Download Quest Fix:**
[Download New Germany Quest Fix](

This is the hidden content, please

• Sign In
• or
• Sign Up

)

 

**Applying the Quest Fix:**
Follow these steps to apply the quest fix:
1. Stop the server.
2. Change germany folder to germany_old.
3. Upload the new germany folder.
4. Start the server.


pkg info from .ova file:

Quote

binutils-2.37_4,1              GNU binary tools
boost-all-1.82.0               The "meta-port" for boost libraries
boost-docs-1.80.0              Documentation for libraries from boost.org
boost-jam-1.80.0               Build tool from the boost.org
boost-libs-1.80.0              Free portable C++ libraries (without Boost.Python)
ca_root_nss-3.83               Root certificate bundle from the Mozilla Project
cryptopp-8.7.0                 Free C++ class library of Cryptographic Primitives
curl-7.86.0                    Command line tool and library for transferring data with URLs
cyrus-sasl-2.1.28              RFC 2222 SASL (Simple Authentication and Security Layer)
devil-1.8.0_2,1                Cross-platform image library
expat-2.4.9                    XML 1.0 parser written in C
freeglut-3.2.1                 Open source implementation of GLUT library
gcc-11_4                       Meta-port for the default version of the GNU Compiler Collection
gcc10-10.4.0                   GNU Compiler Collection 10
gcc11-11.3.0_1                 GNU Compiler Collection 11
gdb-12.1_1                     GNU Project Debugger
gettext-runtime-0.21           GNU gettext runtime libraries and programs
gmake-4.3_2                    GNU version of 'make' utility
gmp-6.2.1                      Free library for arbitrary precision arithmetic
groff-1.22.4_4                 Software typesetting package
hidapi-0.12.0                  Library to access USB HID-class devices
htop-3.2.2_1                   Better top(1) - interactive process viewer
icu-71.1,1                     International Components for Unicode (from IBM)
indexinfo-0.3.1                Utility to regenerate the GNU info page index
jasper-4.0.0                   Implementation of the codec specified in the JPEG-2000 standard
jbigkit-2.1_1                  Lossless compression for bi-level images such as scanned pages, faxes
jpeg-turbo-2.1.4               SIMD-accelerated JPEG codec which replaces libjpeg
lcms-1.19_6,1                  Light Color Management System -- a color management library
lcms2-2.13.1                   Accurate, fast, and small-footprint color management engine
libGLU-9.0.2_1                 OpenGL utility library
libICE-1.0.10,1                Inter Client Exchange library for X11
libSM-1.2.3,1                  Session Management library for X11
libX11-1.7.2,1                 X11 library
libXau-1.0.9                   Authentication Protocol library for X11
libXdmcp-1.1.3                 X Display Manager Control Protocol library
libXext-1.3.4,1                X11 Extension library
libXfixes-6.0.0                X Fixes extension library
libXi-1.8,1                    X Input extension library
libXmu-1.1.3,1                 X Miscellaneous Utilities libraries
libXrandr-1.5.2                X Resize and Rotate extension library
libXrender-0.9.10_2            X Render extension library
libXt-1.2.1,1                  X Toolkit library
libXxf86vm-1.1.4_3             X Vidmode Extension
libcbor-0.9.0                  CBOR protocol implementation for C and others
libcjson-1.7.15                Ultralightweight JSON parser in ANSI C
libdeflate-1.14                Fast, whole-buffer DEFLATE-based compression library
libedit-3.1.20210910,1         Command line editor library
libevent-2.1.12                API for executing callback functions on events or timeouts
libffi-3.4.2                   Foreign Function Interface
libfido2-1.11.0                Provides library functionality for FIDO 2.0
libglvnd-1.4.0_2               GL Vendor-Neutral Dispatch library
libiconv-1.17                  Character set conversion library
libidn2-2.3.3                  Implementation of IDNA2008 internationalized domain names
liblz4-1.9.4,1                 LZ4 compression library, lossless and very fast
libmng-1.0.10_3                Multiple-image Network Graphics (MNG) reference library
libnghttp2-1.48.0              HTTP/2.0 C Library
libpaper-1.1.28                Library providing routines for paper size management
libpsl-0.21.1_4                C library to handle the Public Suffix List
libpthread-stubs-0.4           Weak aliases for pthread functions
libssh2-1.10.0,3               Library implementing the SSH2 protocol
libunistring-1.0               Unicode string library
libunwind-20211201_1           Generic stack unwinding library
libxcb-1.15                    The X protocol C-language Binding (XCB) library
llvm-15,1                      Meta-port for the default version of the LLVM Toolchain
llvm15-15.0.7_7                LLVM and Clang
lua53-5.3.6                    Powerful, efficient, lightweight, embeddable scripting language
makedepend-1.0.6,1             Dependency generator for makefiles
mpc-1.2.1                      Library of complex numbers with arbitrarily high precision
mpdecimal-2.5.1                C/C++ arbitrary precision decimal floating point libraries
mpfr-4.1.0_1                   Library for multiple-precision floating-point computations
mysql57-client-5.7.40          Multithreaded SQL database (client)
mysql57-server-5.7.40          Multithreaded SQL database (server)
nano-7.2                       Nano's ANOther editor, an enhanced free Pico clone
openldap26-client-2.6.3        Open source LDAP client implementation
perl5-5.32.1_3                 Practical Extraction and Report Language
pkg-1.20.8                     Package manager
png-1.6.37_1                   Library for manipulating PNG images
protobuf-3.21.9,1              Data interchange format library
psutils-1.17_5                 Utilities for manipulating PostScript documents
python-3.9_3,2                 "meta-port" for the default version of Python interpreter
python2-2_3                    Meta-port for the Python interpreter 2.7
python27-2.7.18_2              Interpreted object-oriented programming language
python3-3_3                    Meta-port for the Python interpreter 3.x
python39-3.9.16                Interpreted object-oriented programming language
readline-8.1.2                 Library for editing command lines as they are typed
source-highlight-3.1.9_3       C/C++ and Java sources to HTML converter
squish-1.15                    Open source DXT compression library
tiff-4.4.0_1                   Tools and library routines for working with TIFF images
uchardet-0.0.7                 Universal charset detection library
xorgproto-2022.1               X Window System unified protocol definitions
zstd-1.5.2_1                   Fast real-time compression algorithm

Happy gaming, and may your quests be bug-free!

porexemplo

 

Edited January 21 by bvpt2010

[xpro]

This is the hidden content, please

• Sign In
• or
• Sign Up

This is the hidden content, please

• Sign In
• or
• Sign Up

 you must do SSH Tunnel

Username: metin2

Password: ASSBDAS!#FSABFASI!#JYXYXKAFAF

 

To compile sources use

This is the hidden content, please

• Sign In
• or
• Sign Up

then write 888

[Podrick]

This was useful for me too, thank you

[bvpt2010]

This is the hidden content, please

• Sign In
• or
• Sign Up

Same error again, even after a new compile like you said.

[xpro]

you use that vdi or you use other vps? i never got that

[bvpt2010]

2 minutes ago, xpro said:

you use that vdi or you use other vps? i never got that

Im using the Ova file you gived on files.

[Alex]

Wow

[covfefe]

Can someone who compiled the game and DB of Zenaris please upload it for us here I have an ancient machine it's taking forever to compile for me and I'm running out of memory

[bvpt2010]

 

7 minutes ago, covfefe said:

Can someone who compiled the game and DB of Zenaris please upload it for us here I have an ancient machine it's taking forever to compile for me and I'm running out of memory

I dont know if its working but, there you have 

This is the hidden content, please

• Sign In
• or
• Sign Up

Edited December 30, 2023 by bvpt2010

[Daniel]

am instalat serverfiles zenaris , am compilat sursa dar primesc urmatoartea eroare cand vreau sa il pornesc :

Log Offmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
   failed, retrying in 5 secondsPUBLIC_IP: XXXX.XXXXX.XXXX.XXX interface vtnet0
HOSTNAME: game-auth
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
cannot open direct sql connection to host: localhost user: metin2 db: common
cannot start server while no common sql connected
 

[bvpt2010]

8 minutes ago, Daniel said:

am instalat serverfiles zenaris , am compilat sursa dar primesc urmatoartea eroare cand vreau sa il pornesc :

Log Offmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
   failed, retrying in 5 secondsPUBLIC_IP: XXXX.XXXXX.XXXX.XXX interface vtnet0
HOSTNAME: game-auth
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
cannot open direct sql connection to host: localhost user: metin2 db: common
cannot start server while no common sql connected
 

Looks like mysql errors too.

[Daniel]

5 minutes ago, bvpt2010 said:

Looks like mysql errors too.

This is the hidden content, please

• Sign In
• or
• Sign Up

 

[bvpt2010]

Dec 30 19:14:10 :: 
Start of pid: 2051

Dec 30 19:14:10 :: LOCALE set to latin1
Dec 30 19:14:10 :: CONFIG: DISABLE_HOTBACKUP
Dec 30 19:14:10 :: TABLE_POSTFIX not configured use default
Dec 30 19:14:10 :: connecting to MySQL server (player)
Dec 30 19:14:10 :: CREATING DIRECT_SQL
Dec 30 19:14:10 :: AsyncSQL: locale latin1
Dec 30 19:14:10 :: CREATING MAIN_SQL
Dec 30 19:14:10 :: AsyncSQL: locale latin1
Dec 30 19:14:10 :: CREATING ASYNC_SQL
Dec 30 19:14:10 :: AsyncSQL: locale latin1
Dec 30 19:14:10 ::    OK
Dec 30 19:14:10 :: connecting to MySQL server (account)
Dec 30 19:14:10 :: CREATING DIRECT_SQL
Dec 30 19:14:10 :: AsyncSQL: locale latin1
Dec 30 19:14:10 :: CREATING MAIN_SQL
Dec 30 19:14:10 :: AsyncSQL: locale latin1
Dec 30 19:14:10 :: CREATING ASYNC_SQL
Dec 30 19:14:10 :: AsyncSQL: locale latin1
Dec 30 19:14:10 ::    OK
Dec 30 19:14:10 :: connecting to MySQL server (common)
Dec 30 19:14:10 :: CREATING DIRECT_SQL
Dec 30 19:14:10 :: AsyncSQL: locale latin1
Dec 30 19:14:10 :: CREATING MAIN_SQL
Dec 30 19:14:10 :: AsyncSQL: locale latin1
Dec 30 19:14:10 :: CREATING ASYNC_SQL
Dec 30 19:14:10 :: AsyncSQL: locale latin1
Dec 30 19:14:10 ::    OK
Dec 30 19:14:10 :: connecting to MySQL server (hotbackup)
Dec 30 19:14:10 :: CREATING DIRECT_SQL
Dec 30 19:14:10 :: AsyncSQL: locale latin1
Dec 30 19:14:10 :: CREATING MAIN_SQL
Dec 30 19:14:10 :: AsyncSQL: locale latin1
Dec 30 19:14:10 :: CREATING ASYNC_SQL
Dec 30 19:14:10 :: AsyncSQL: locale latin1
Dec 30 19:14:10 ::    OK
Dec 30 19:14:10 :: ClientManager initialization.. 
Dec 30 19:14:10 :: InitializeLocalization() - LoadLocaleTable(count:13)
Dec 30 19:14:10 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE0)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec 30 19:14:10 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE1)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec 30 19:14:10 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE2)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec 30 19:14:10 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE3)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec 30 19:14:10 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE4)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec 30 19:14:10 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE5)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec 30 19:14:10 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE6)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec 30 19:14:10 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE7)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec 30 19:14:10 :: locale[LOCALE] = germany
Dec 30 19:14:10 :: Changed g_stLocale latin1 to euckr
Dec 30 19:14:10 :: SetLocale start latin1
Dec 30 19:14:10 ::     --mysql_set_character_set(latin1)
Dec 30 19:14:10 ::     --mysql_set_character_set(latin1)
Dec 30 19:14:10 ::     --mysql_set_character_set(latin1)
Dec 30 19:14:10 ::     --mysql_set_character_set(latin1)
Dec 30 19:14:10 ::     --mysql_set_character_set(latin1)
Dec 30 19:14:10 ::     --mysql_set_character_set(latin1)
Dec 30 19:14:10 ::     --mysql_set_character_set(latin1)
Dec 30 19:14:10 ::     --mysql_set_character_set(latin1)
Dec 30 19:14:10 ::     --mysql_set_character_set(latin1)
Dec 30 19:14:10 ::     --mysql_set_character_set(latin1)
Dec 30 19:14:10 ::     --mysql_set_character_set(latin1)
Dec 30 19:14:10 ::     --mysql_set_character_set(latin1)
Dec 30 19:14:10 :: SetLocale end latin1
Dec 30 19:14:10 :: locale[DB_NAME_COLUMN] = locale_name
Dec 30 19:14:10 :: locale[UNKNOWN_KEY(SKILL_DAMAGE_BY_LEVEL_UNDER_90)] = 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Dec 30 19:14:10 :: locale[UNKNOWN_KEY(SKILL_DAMAGE_BY_LEVEL_UNDER_45)] = 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Dec 30 19:14:10 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec 30 19:14:11 :: GetParam 100000000
Dec 30 19:14:11 :: GetParam 200000000
Dec 30 19:14:11 :: ItemRange From File 100000000 ~ 200000000 
Dec 30 19:14:11 :: ItemIDRange: Build: 100000000 ~ 200000000 start:100000000
Dec 30 19:14:11 ::  Init Success Start 100000000 End 200000000 Now 100000000|




SYSERR: Dec 30 19:14:28 :: socket_connect: HOST 192.168.1.79:30000, could not connect.
SYSERR: Dec 30 19:14:31 :: socket_connect: HOST 192.168.1.79:30000, could not connect.
SYSERR: Dec 30 19:14:34 :: socket_connect: HOST 192.168.1.79:30000, could not connect.
SYSERR: Dec 30 19:14:37 :: socket_connect: HOST 192.168.1.79:30000, could not connect.
SYSERR: Dec 30 19:14:40 :: socket_connect: HOST 192.168.1.79:30000, could not connect.
SYSERR: Dec 30 19:14:43 :: socket_connect: HOST 192.168.1.79:30000, could not connect.
SYSERR: Dec 30 19:14:46 :: socket_connect: HOST 192.168.1.79:30000, could not connect.
SYSERR: Dec 30 19:14:49 :: socket_connect: HOST 192.168.1.79:30000, could not connect.
SYSERR: Dec 30 19:14:52 :: socket_connect: HOST 192.168.1.79:30000, could not connect.
SYSERR: Dec 30 19:14:55 :: socket_connect: HOST 192.168.1.79:30000, could not connect.
 

[Alex]

If I can't connect to Navicat, what can I do? I tried to put the user ip and password in SSH but it doesn't connect. Do I need to update to mysql 5.7?

Edited December 30, 2023 by Alex

[SFX]

nice

[bvpt2010]

1 minute ago, Alex said:

If I can't connect to Navicat, what can I do? I tried to put the user ip and password in SSH but it doesn't connect. Do I need to update to mysql 5.7?

We all are facing mysql issues for now.

[bvpt2010]

pkg info from ova file

 

This is the hidden content, please

• Sign In
• or
• Sign Up

 

[canyorulmaz]

tnx fore share 

[Daniel]

am reusit ca sa trec de etapa de mai sus si m am conectat si la navicat dar primesc :

connect: Connection refused
connect: Connection refused
____________________________________________________________________________________________________
SYSERR: Dec 30 21:45:00 :: socket_connect: HOST 127.0.0.1:30000, could not connect.
SYSERR: Dec 30 21:45:03 :: socket_connect: HOST 127.0.0.1:30000, could not connect.
 

[Alex]

Cum ai reusit sa treci de partea cu conectatul la baza de date?

[Daniel]

3 minutes ago, Alex said:

Cum ai reusit sa treci de partea cu conectatul la baza de date?

Am folosit skip tables la resetat parola MySQL . Revin cu edit când îl pornesc . 
 

in MySQL - user sau db lipsește coloana password , de aceea nu merge resetat normal 

[Alex]

Dar cand l-ai instalat la tine a pornit baza de date ca la mine inca sta pe off

[Daniel]

3 minutes ago, Alex said:

Dar cand l-ai instalat la tine a pornit baza de date ca la mine inca sta pe off

Nu , a pornit abia după ce am reușit sa ii bag o parola la MySQL 

[Daniel]

6 minutes ago, Alex said:

Dar cand l-ai instalat la tine a pornit baza de date ca la mine inca sta pe off

Login without a password, the --skip-grant-tables basically disables authentication/authorization. Allowing you to login without a password.

The whole thing:

Code:

service mysql-server stop
sysrc mysql_args="--skip-grant-tables"
mysql -u root
> ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword';
> exit
service mysql-server stop
sysrc -x mysql_args
service mysql-server start

 

pe mine m a ajutat asta .

 

o sa pun eu link de download la serverfiles daca reusesc sa il pornesc

[Alex]

Si la Mysql te referea in folderul var/db/mysql unde mai exact trebuie sa bagi coloana de password?