Support Topic - Zenaris Source

[Ancient 122]

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](https://www.mediafire.com/file/oom2xzf0meceeb2/NewGermanyQuestFix.tgz/file)

 

**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, 2024 by Ancient

[xpro 2,407]

Navicat:

Zenaris Work - Edit Connection (MySQL) (gyazo.com) you must do SSH Tunnel

Username: metin2

Password: ASSBDAS!#FSABFASI!#JYXYXKAFAF

 

To compile sources use

cd /home && sh admin_panel.sh

then write 888

[Podrick 0]

This was useful for me too, thank you

[Ancient 122]

PROTO_FROM_DB: Disabled
MIRROR2DB: Enabled
terminate called after throwing an instance of 'std::length_error'
  what():  vector::_M_default_append

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

[xpro 2,407]

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

[Ancient 122]

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 0]

Wow

[covfefe 0]

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 122]

 

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 

https://drive.google.com/file/d/1woOWR5HJFcO7eCyUnYKmRvDfny-faM1s/view?usp=drive_link

Edited December 30, 2023 by bvpt2010

[Daniel 4]

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 122]

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 4]

5 minutes ago, bvpt2010 said:

Looks like mysql errors too.

2023-12-30T18:19:49.6NZ mysqld_safe Logging to '/var/db/mysql/metin2.err'.
2023-12-30T18:19:49.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2023-12-30T18:19:49.926489Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-12-30T18:19:49.927314Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2023-12-30T18:19:49.935878Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.42) starting as process 895 ...
2023-12-30T18:19:49.971594Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-12-30T18:19:49.971633Z 0 [Note] InnoDB: Uses event mutexes
2023-12-30T18:19:49.971649Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2023-12-30T18:19:49.971658Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2023-12-30T18:19:49.974488Z 0 [Note] InnoDB: Number of pools: 1
2023-12-30T18:19:49.978579Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2023-12-30T18:19:49.986572Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2023-12-30T18:19:50.024960Z 0 [Note] InnoDB: Completed initialization of buffer pool
2023-12-30T18:19:50.056773Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2023-12-30T18:19:50.165590Z 0 [Warning] InnoDB: Resizing redo log from 2*16384 to 2*3072 pages, LSN=23548115
2023-12-30T18:19:50.276181Z 0 [Warning] InnoDB: Starting to delete and rewrite log files.
2023-12-30T18:19:50.276723Z 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2023-12-30T18:19:50.985691Z 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2023-12-30T18:19:51.958078Z 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2023-12-30T18:19:51.958184Z 0 [Warning] InnoDB: New log files created, LSN=23548115
2023-12-30T18:19:51.961942Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-12-30T18:19:51.962015Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-12-30T18:19:52.167502Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-12-30T18:19:52.168917Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2023-12-30T18:19:52.168934Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2023-12-30T18:19:52.169488Z 0 [Note] InnoDB: Waiting for purge to start
2023-12-30T18:19:52.221159Z 0 [Note] InnoDB: 5.7.42 started; log sequence number 23548106
2023-12-30T18:19:52.221876Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool
2023-12-30T18:19:52.230558Z 0 [Note] Plugin 'FEDERATED' is disabled.
2023-12-30T18:19:52.411089Z 0 [Note] InnoDB: Buffer pool(s) load completed at 231230 20:19:52
2023-12-30T18:19:52.431161Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2023-12-30T18:19:52.431182Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2023-12-30T18:19:52.431199Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2023-12-30T18:19:52.431213Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2023-12-30T18:19:52.443192Z 0 [Warning] CA certificate ca.pem is self signed.
2023-12-30T18:19:52.445860Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2023-12-30T18:19:52.447695Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2023-12-30T18:19:52.448222Z 0 [Note] IPv6 is available.
2023-12-30T18:19:52.448252Z 0 [Note]   - '::' resolves to '::';
2023-12-30T18:19:52.448340Z 0 [Note] Server socket created on IP: '::'.
2023-12-30T18:19:52.450655Z 0 [ERROR] Can't start server : Bind on unix socket: Address already in use
2023-12-30T18:19:52.450682Z 0 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
2023-12-30T18:19:52.450698Z 0 [ERROR] Aborting

2023-12-30T18:19:52.450719Z 0 [Note] Binlog end
2023-12-30T18:19:52.454273Z 0 [Note] Shutting down plugin 'ngram'
2023-12-30T18:19:52.454311Z 0 [Note] Shutting down plugin 'partition'
2023-12-30T18:19:52.454322Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2023-12-30T18:19:52.454333Z 0 [Note] Shutting down plugin 'ARCHIVE'
2023-12-30T18:19:52.454342Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-12-30T18:19:52.454448Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2023-12-30T18:19:52.454470Z 0 [Note] Shutting down plugin 'MyISAM'
2023-12-30T18:19:52.455497Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2023-12-30T18:19:52.455513Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-12-30T18:19:52.455523Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-12-30T18:19:52.455532Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-12-30T18:19:52.455541Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-12-30T18:19:52.455551Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-12-30T18:19:52.455560Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-12-30T18:19:52.455569Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-12-30T18:19:52.455578Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-12-30T18:19:52.455587Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-12-30T18:19:52.455597Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-12-30T18:19:52.455606Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-12-30T18:19:52.455615Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-12-30T18:19:52.455624Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-12-30T18:19:52.455634Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-12-30T18:19:52.455643Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-12-30T18:19:52.455652Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2023-12-30T18:19:52.455661Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2023-12-30T18:19:52.455671Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-12-30T18:19:52.455680Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-12-30T18:19:52.455689Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-12-30T18:19:52.455698Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-12-30T18:19:52.455707Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-12-30T18:19:52.455716Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-12-30T18:19:52.455726Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-12-30T18:19:52.455735Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-12-30T18:19:52.455744Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2023-12-30T18:19:52.455753Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-12-30T18:19:52.455762Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-12-30T18:19:52.455771Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2023-12-30T18:19:52.455781Z 0 [Note] Shutting down plugin 'InnoDB'
2023-12-30T18:19:52.455975Z 0 [Note] InnoDB: FTS optimize thread exiting.
2023-12-30T18:19:52.456206Z 0 [Note] InnoDB: Starting shutdown...
2023-12-30T18:19:52.558595Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/db/mysql/ib_buffer_pool
2023-12-30T18:19:52.558970Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 231230 20:19:52
2023-12-30T18:19:53.523850Z 0 [Note] InnoDB: Shutdown completed; log sequence number 23548447
2023-12-30T18:19:53.524713Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-12-30T18:19:53.524740Z 0 [Note] Shutting down plugin 'MEMORY'
2023-12-30T18:19:53.524756Z 0 [Note] Shutting down plugin 'CSV'
2023-12-30T18:19:53.524767Z 0 [Note] Shutting down plugin 'sha256_password'
2023-12-30T18:19:53.524776Z 0 [Note] Shutting down plugin 'mysql_native_password'
2023-12-30T18:19:53.524926Z 0 [Note] Shutting down plugin 'binlog'
2023-12-30T18:19:53.525218Z 0 [Note] /usr/local/libexec/mysqld: Shutdown complete

2023-12-30T18:19:53.6NZ mysqld_safe mysqld from pid file /var/db/mysql/metin2.pid ended

 

[Ancient 122]

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 0]

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 306]

nice

[Ancient 122]

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 122]

pkg info from ova file

 

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

 

[canyorulmaz 0]

tnx fore share 

[Daniel 4]

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 0]

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

[Daniel 4]

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 0]

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

[Daniel 4]

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 4]

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 0]

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