Support Topic - Zenaris Source

Ancient · December 30, 2023

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!

Ancient

Edited November 11 by Ancient

xpro · December 30, 2023

This is the hidden content, please

you must do SSH Tunnel

Username: metin2

Password: ASSBDAS!#FSABFASI!#JYXYXKAFAF

To compile sources use

This is the hidden content, please

then write 888

Podrick · December 30, 2023

This was useful for me too, thank you

Ancient · December 30, 2023

This is the hidden content, please

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

xpro · December 30, 2023

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

Ancient · December 30, 2023

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 · December 30, 2023

Wow

covfefe · December 30, 2023

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

Ancient · December 30, 2023

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

Edited December 30, 2023 by bvpt2010

Daniel · December 30, 2023

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

Ancient · December 30, 2023

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 · December 30, 2023

5 minutes ago, bvpt2010 said:

Looks like mysql errors too.

This is the hidden content, please

Ancient · December 30, 2023

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 · December 30, 2023

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 · December 30, 2023

nice

Ancient · December 30, 2023

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.

Ancient · December 30, 2023

pkg info from ova file

This is the hidden content, please

canyorulmaz · December 30, 2023

tnx fore share

Daniel · December 30, 2023

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 · December 30, 2023

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

Daniel · December 30, 2023

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 · December 30, 2023

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

Daniel · December 30, 2023

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 · December 30, 2023

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 · December 30, 2023

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

Sign In

Support Topic - Zenaris Source

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

Ancient

xpro

Ancient

Posted Images

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information

Write what you are looking for and press enter or click the search icon to begin your search