mTw

up!

fixed it. 

close the topic.

Hey, Metin2Dev community.

I've recently started to work on a metin2 server project and Im facing issues on my mysql server.

when i use  service mysql-server restart 

and then check the status it says mysql is not runnning.

here is the .err file details:- 

 

190104 06:40:47 mysqld_safe Logging to '/var/db/mysql/librion.metin2.err'.
190104 06:40:48 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2019-01-04 06:40:49 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-01-04 06:40:49 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.42) starting as process 13071 ...
2019-01-04 06:40:49 13071 [Note] Plugin 'FEDERATED' is disabled.
2019-01-04 06:40:49 13071 [Note] InnoDB: Using atomics to ref count buffer pool pages
2019-01-04 06:40:49 13071 [Note] InnoDB: The InnoDB memory heap is disabled
2019-01-04 06:40:49 13071 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-01-04 06:40:49 13071 [Note] InnoDB: Memory barrier is not used
2019-01-04 06:40:49 13071 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-01-04 06:40:49 13071 [Note] InnoDB: Not using CPU crc32 instructions
2019-01-04 06:40:49 13071 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2019-01-04 06:40:49 13071 [Note] InnoDB: Completed initialization of buffer pool
2019-01-04 06:40:49 13071 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2019-01-04 06:40:49 13071 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2019-01-04 06:40:49 13071 [Note] InnoDB: Database physically writes the file full: wait...
2019-01-04 06:40:49 13071 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2019-01-04 06:40:49 13071 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2019-01-04 06:40:49 13071 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2019-01-04 06:40:49 13071 [Warning] InnoDB: New log files created, LSN=45781
2019-01-04 06:40:49 13071 [Note] InnoDB: Doublewrite buffer not found: creating new
2019-01-04 06:40:49 13071 [Note] InnoDB: Doublewrite buffer created
2019-01-04 06:40:49 13071 [Note] InnoDB: 128 rollback segment(s) are active.
2019-01-04 06:40:49 13071 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-01-04 06:40:49 13071 [Note] InnoDB: Foreign key constraint system tables created
2019-01-04 06:40:49 13071 [Note] InnoDB: Creating tablespace and datafile system tables.
2019-01-04 06:40:49 13071 [Note] InnoDB: Tablespace and datafile system tables created.
2019-01-04 06:40:49 13071 [Note] InnoDB: Waiting for purge to start
2019-01-04 06:40:49 13071 [Note] InnoDB: 5.6.42 started; log sequence number 0
Warning: World-writable config file './auto.cnf' is ignored
2019-01-04 06:40:49 13071 [Warning] World-writable config file './auto.cnf' has been removed.

2019-01-04 06:40:49 13071 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 4ab1eb51-0fe3-11e9-8a76-000434b359f3.
2019-01-04 06:40:49 13071 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2019-01-04 06:40:49 13071 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2019-01-04 06:40:49 13071 [Note] Server hostname (bind-address): '*'; port: 3306
2019-01-04 06:40:49 13071 [Note] IPv6 is available.
2019-01-04 06:40:49 13071 [Note]   - '::' resolves to '::';
2019-01-04 06:40:49 13071 [Note] Server socket created on IP: '::'.
2019-01-04 06:40:49 13071 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2019-01-04 06:40:49 13071 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-01-04 06:40:49 13071 [ERROR] Aborting

2019-01-04 06:40:49 13071 [Note] Binlog end
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'partition'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_METRICS'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_CMPMEM'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_CMP'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_LOCKS'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'INNODB_TRX'
2019-01-04 06:40:49 13071 [Note] Shutting down plugin 'InnoDB'
2019-01-04 06:40:49 13071 [Note] InnoDB: FTS optimize thread exiting.
2019-01-04 06:40:49 13071 [Note] InnoDB: Starting shutdown...
2019-01-04 06:40:50 13071 [Note] InnoDB: Shutdown completed; log sequence number 1600607
2019-01-04 06:40:50 13071 [Note] Shutting down plugin 'BLACKHOLE'
2019-01-04 06:40:50 13071 [Note] Shutting down plugin 'ARCHIVE'
2019-01-04 06:40:50 13071 [Note] Shutting down plugin 'MRG_MYISAM'
2019-01-04 06:40:50 13071 [Note] Shutting down plugin 'MyISAM'
2019-01-04 06:40:50 13071 [Note] Shutting down plugin 'MEMORY'
2019-01-04 06:40:50 13071 [Note] Shutting down plugin 'CSV'
2019-01-04 06:40:50 13071 [Note] Shutting down plugin 'sha256_password'
2019-01-04 06:40:50 13071 [Note] Shutting down plugin 'mysql_old_password'
2019-01-04 06:40:50 13071 [Note] Shutting down plugin 'mysql_native_password'
2019-01-04 06:40:50 13071 [Note] Shutting down plugin 'binlog'
2019-01-04 06:40:50 13071 [Note] /usr/local/libexec/mysqld: Shutdown complete

190104 06:40:50 mysqld_safe mysqld from pid file /var/db/mysql/librion.metin2.pid ended

to see what's already listening on the port 3306 I used the command  sudo lsof -i TCP:3306 and got 

COMMAND   PID  USER   FD   TYPE             DEVICE SIZE/OFF NODE NAME
mysqld  12565 mysql   10u  IPv6 0xfffff8005115f000      0t0  TCP *:mysql (LISTEN)
 

then I killed this process id using 

kill 12565 

and then again tried to start the mysql by using 

service mysql-server start 

and this time it gave :- 

mysql is running as pid 13318.

but now when I tried to start my game by using 

/usr/game 

sh start.sh 

and then again tried to check the status of my mysql it wasn't running, it gave

mysql is not running.

I've tried everything to fix thing thing but couldn't 

any help would be greatly appreciated.

 

 

 

 

Hey, I've recently set up a server when i click on the trading option the trade window doesn't shows up but if you try to unequip something it says you can't unequip items while trading. Please help.

can you remove the refine_set2 column from your converter? that messes up my whole item_proto

As the topic itself says I need a Item_proto.txt to Item_proto.xml converter I have looked everywhere on internet but didn't find any. 

Yeah solved thanks.

 

Hey, Metin2dev community.

So recently, I opened up a server and the game was in full german language so I began the translation part I replaced all the  locale_name on item_proto table with English names and when I exported it as .sql the values were different and interchanged also when I checked the specular table on my item_proto table everyvalue on it is set as 0 which makes exporting the table useless unless I make changes to the specular column I want to replace all +7 - +9 values to their specific specular values what do I need to do for that or is there any fix for it ? cauz it took me hours to translate the item_proto manually... and I don't wanna do it again for client side.....  please help.

Hello, Metin2Dev community.

I'm searching for a partner who can work with me on my server, my server is clean and we envisage to make it a great server the serverfiles are 40k. I want someone who knows to work on db can add new stuffs and has some exp as a server admin before. 

thanks.

Hey, Metin2Dev community.

I just want to know the steps of how to setup a server and what goes through In creating a server from scratch, if you could help it would be much appreciated.