Habe vor ein paar tagen max yang eingebaut. klappt auch alles. Jetzt hab ich aber das problem, dass der server abstürtzt, wenn man sich einloggt, oder ihn über nacht anlässt.
putty:
PUBLIC_IP: 178.251.228.122 interface vtnet0
HOSTNAME: auth
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: core db: common
cannot start server while no common sql connected
auth is not running
PUBLIC_IP: 178.251.228.122 interface vtnet0
HOSTNAME: auth
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: core db: common
cannot start server while no common sql connected
Mysql error datei:
170511 18:55:49 mysqld_safe Logging to '/var/db/mysql/Corania2.err'.
170511 18:55:49 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2017-05-11 18:55:50 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-05-11 18:55:50 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.35) starting as process 18648 ...
2017-05-11 18:55:50 18648 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/libexec/mysqld: Table 'mysql.plugin' doesn't exist
2017-05-11 18:55:50 18648 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-05-11 18:55:50 18648 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-05-11 18:55:50 18648 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-11 18:55:50 18648 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-11 18:55:50 18648 [Note] InnoDB: Memory barrier is not used
2017-05-11 18:55:50 18648 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-05-11 18:55:50 18648 [Note] InnoDB: Using CPU crc32 instructions
2017-05-11 18:55:50 18648 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-05-11 18:55:50 18648 [Note] InnoDB: Completed initialization of buffer pool
2017-05-11 18:55:50 18648 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2017-05-11 18:55:50 18648 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2017-05-11 18:55:50 18648 [Note] InnoDB: Database physically writes the file full: wait...
2017-05-11 18:56:06 18648 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2017-05-11 18:56:19 18648 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2017-05-11 18:56:20 18648 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2017-05-11 18:56:20 18648 [Warning] InnoDB: New log files created, LSN=45781
2017-05-11 18:56:20 18648 [Note] InnoDB: Doublewrite buffer not found: creating new
2017-05-11 18:56:20 18648 [Note] InnoDB: Doublewrite buffer created
2017-05-11 18:56:20 18648 [Note] InnoDB: 128 rollback segment(s) are active.
2017-05-11 18:56:20 18648 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-05-11 18:56:20 18648 [Note] InnoDB: Foreign key constraint system tables created
2017-05-11 18:56:20 18648 [Note] InnoDB: Creating tablespace and datafile system tables.
2017-05-11 18:56:20 18648 [Note] InnoDB: Tablespace and datafile system tables created.
2017-05-11 18:56:20 18648 [Note] InnoDB: Waiting for purge to start
2017-05-11 18:56:20 18648 [Note] InnoDB: 5.6.35 started; log sequence number 0
/usr/local/libexec/mysqld: Error on delete of './auto.cnf' (Errcode: 2 - No such file or directory)
2017-05-11 18:56:20 18648 [Warning] World-writable config file './auto.cnf' has been removed.
2017-05-11 18:56:20 18648 [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: c213f6c4-366a-11e7-bb08-007ff6b55e80.
2017-05-11 18:56:20 18648 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2017-05-11 18:56:20 18648 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2017-05-11 18:56:20 18648 [Note] Server hostname (bind-address): '*'; port: 3306
2017-05-11 18:56:20 18648 [Note] IPv6 is available.
2017-05-11 18:56:20 18648 [Note] - '::' resolves to '::';
2017-05-11 18:56:20 18648 [Note] Server socket created on IP: '::'.
2017-05-11 18:56:21 18648 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
2017-05-11 18:56:21 18648 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2017-05-11 18:56:21 18648 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50092, now running 50635. Please use mysql_upgrade to fix this error.
2017-05-11 18:56:21 18648 [ERROR] Cannot open mysql.event
2017-05-11 18:56:21 18648 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2017-05-11 18:56:21 18648 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.35' socket: '/tmp/mysql.sock' port: 3306 Source distribution
Syssr ch1 core 1:
SYSERR: May 11 18:59:04 :: LoadPackageCryptInfo: [PackageCryptInfo] Failed to load package/cshybridcrypt_metin2_patch_w20_sound.dat
SYSERR: May 11 18:59:04 :: LoadPackageCryptInfo: [PackageCryptInfo] Failed to load package/cshybridcrypt_metin2_patch_w21_etc.dat
SYSERR: May 11 18:59:04 :: LoadPackageCryptInfo: [PackageCryptInfo] Failed to load package/cshybridcrypt_metin2_patch_ds.dat
SYSERR: May 11 18:59:04 :: LoadPackageCryptInfo: [PackageCryptInfo] Failed to load package/cshybridcrypt_metin2_patch_dss_box.dat
SYSERR: May 11 19:01:51 :: heart_idle: losing 143 seconds. (lag occured)
Syssr Loginserver:
SYSERR: May 11 18:59:12 :: LoadPackageCryptInfo: [PackageCryptInfo] Failed to load package/cshybridcrypt_metin2_patch_w20_sound.dat
SYSERR: May 11 18:59:12 :: LoadPackageCryptInfo: [PackageCryptInfo] Failed to load package/cshybridcrypt_metin2_patch_w21_etc.dat
SYSERR: May 11 18:59:12 :: LoadPackageCryptInfo: [PackageCryptInfo] Failed to load package/cshybridcrypt_metin2_patch_ds.dat
SYSERR: May 11 18:59:12 :: LoadPackageCryptInfo: [PackageCryptInfo] Failed to load package/cshybridcrypt_metin2_patch_dss_box.dat
SYSERR: May 11 19:01:51 :: heart_idle: losing 143 seconds. (lag occured)
SYSERR: May 11 19:01:53 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT mAccount FROM common.gmlist
DB Syssr:
SYSERR: May 11 19:08:04 :: pid_init:
Start of pid: 19366
SYSERR: May 11 19:08:04 :: Start: TABLE_POSTFIX not configured use default
SYSERR: May 11 19:08:05 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: May 11 19:08:04 :: Start: TABLE_POSTFIX not configured use default
SYSERR: May 11 19:08:05 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: May 11 19:10:44 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 19:10:44 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 19:10:49 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 19:10:49 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 19:08:04 :: Start: TABLE_POSTFIX not configured use default
SYSERR: May 11 19:08:05 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: May 11 19:10:44 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 19:10:44 :: ChildLoop: AsyncSQL: retrying