Popular Post bvpt2010 Posted December 30, 2023 Popular Post Share Posted December 30, 2023 (edited) 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 75 14 3 2 2 Quote Link to comment Share on other sites More sharing options...
Administrator Popular Post xpro Posted December 30, 2023 Administrator Popular Post Share Posted December 30, 2023 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 50 10 2 1 3 Quote Link to comment Share on other sites More sharing options...
Podrick Posted December 30, 2023 Share Posted December 30, 2023 This was useful for me too, thank you Quote Link to comment Share on other sites More sharing options...
bvpt2010 Posted December 30, 2023 Author Share Posted December 30, 2023 This is the hidden content, please Sign In or Sign Up Same error again, even after a new compile like you said. 2 Quote Link to comment Share on other sites More sharing options...
Administrator xpro Posted December 30, 2023 Administrator Share Posted December 30, 2023 you use that vdi or you use other vps? i never got that 1 Quote Link to comment Share on other sites More sharing options...
bvpt2010 Posted December 30, 2023 Author Share Posted 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. Quote Link to comment Share on other sites More sharing options...
Alex Posted December 30, 2023 Share Posted December 30, 2023 Wow Quote Link to comment Share on other sites More sharing options...
covfefe Posted December 30, 2023 Share Posted 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 Quote Link to comment Share on other sites More sharing options...
bvpt2010 Posted December 30, 2023 Author Share Posted December 30, 2023 (edited) 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 3 Quote Link to comment Share on other sites More sharing options...
Daniel Posted December 30, 2023 Share Posted 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 Quote Link to comment Share on other sites More sharing options...
bvpt2010 Posted December 30, 2023 Author Share Posted 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. Quote Link to comment Share on other sites More sharing options...
Daniel Posted December 30, 2023 Share Posted December 30, 2023 5 minutes ago, bvpt2010 said: Looks like mysql errors too. This is the hidden content, please Sign In or Sign Up Quote Link to comment Share on other sites More sharing options...
bvpt2010 Posted December 30, 2023 Author Share Posted 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. Quote Link to comment Share on other sites More sharing options...
Alex Posted December 30, 2023 Share Posted December 30, 2023 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Premium SFX Posted December 30, 2023 Premium Share Posted December 30, 2023 nice Quote Link to comment Share on other sites More sharing options...
bvpt2010 Posted December 30, 2023 Author Share Posted 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. Quote Link to comment Share on other sites More sharing options...
bvpt2010 Posted December 30, 2023 Author Share Posted December 30, 2023 pkg info from ova file This is the hidden content, please Sign In or Sign Up 2 Quote Link to comment Share on other sites More sharing options...
canyorulmaz Posted December 30, 2023 Share Posted December 30, 2023 tnx fore share Quote Link to comment Share on other sites More sharing options...
Daniel Posted December 30, 2023 Share Posted 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. Quote Link to comment Share on other sites More sharing options...
Alex Posted December 30, 2023 Share Posted December 30, 2023 Cum ai reusit sa treci de partea cu conectatul la baza de date? Quote Link to comment Share on other sites More sharing options...
Daniel Posted December 30, 2023 Share Posted 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 Quote Link to comment Share on other sites More sharing options...
Alex Posted December 30, 2023 Share Posted December 30, 2023 Dar cand l-ai instalat la tine a pornit baza de date ca la mine inca sta pe off Quote Link to comment Share on other sites More sharing options...
Daniel Posted December 30, 2023 Share Posted 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 Quote Link to comment Share on other sites More sharing options...
Daniel Posted December 30, 2023 Share Posted 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 Quote Link to comment Share on other sites More sharing options...
Alex Posted December 30, 2023 Share Posted December 30, 2023 Si la Mysql te referea in folderul var/db/mysql unde mai exact trebuie sa bagi coloana de password? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.