Shahin 223 Posted April 5, 2020 Share Posted April 5, 2020 (edited) Keep in mind: FreeBSD 12.1 64 , mysql 5.6 fresh installed. this problems since day one. CH1 runs well if i open only that channel, but when i attend to open more than one, it closes all auth for even ch1 and none of them are working ch1 autorun: Quote PUBLIC_IP: xx.xxx.xxx.xxx interface vtnet0 PLAYER_MAX_LEVEL: 127 PK_PROTECT_LEVEL: 1LocaleService locale/romania/locale_string.txt HOSTNAME: channel1 AsyncSQL: connected to localhost (reconnect 1) CommonSQL connected Setting Locale "romania" (Path: locale/romania) Setting DB to locale latin2 AsyncSQL: connected to localhost (reconnect 1) PlayerSQL connected LogSQL connected AsyncSQL: connected to localhost (reconnect 1) AsyncSQL: connected to localhost (reconnect 1) SKILL_POWER_BY_LEVEL 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 SKILL_POWER_BY_JOB 0 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 SKILL_POWER_BY_JOB 1 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 AsyncSQL: connected to localhost (reconnect 1) SKILL_POWER_BY_JOB 2 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 SKILL_POWER_BY_JOB 3 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 SKILL_POWER_BY_JOB 4 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 SKILL_POWER_BY_JOB 5 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 SKILL_POWER_BY_JOB 6 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 SKILL_POWER_BY_JOB 7 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 MAP ALLOW 1 MAP ALLOW 3 MAP ALLOW 7 MAP ALLOW 12 MAP ALLOW 13 MAP ALLOW 21 MAP ALLOW 23 MAP ALLOW 25 MAP ALLOW 27 MAP ALLOW 28 MAP ALLOW 41 MAP ALLOW 43 MAP ALLOW 45 MAP ALLOW 47 MAP ALLOW 63 MAP ALLOW 64 MAP ALLOW 65 MAP ALLOW 66 MAP ALLOW 67 MAP ALLOW 68 MAP ALLOW 81 MAP ALLOW 201 MAP ALLOW 202 MAP ALLOW 213 MAP ALLOW 217 STATUS_POINT_SET_MAX_VALUE: 90 SHOUT_LIMIT_LEVEL: 15 Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. ch1 syserr: Quote SYSERR: Apr 5 08:24:28 :: pid_init: Start of pid: 1197 auth config: i have set "x" so i can hide my id, ip and pass, but they are there in my files Quote HOSTNAME: auth CHANNEL: 1 PORT: 11003 P2P_PORT: 12900 DB_PORT: 15000 DB_ADDR: localhost TABLE_POSTFIX: ITEM_ID_RANGE: 000000001 000000002 PASSES_PER_SEC: 25 SAVE_EVENT_SECOND_CYCLE: 180 PING_EVENT_SECOND_CYCLE: 180 AUTH_SERVER: master PLAYER_SQL: localhost x x account COMMON_SQL: localhost x x common LOG_SQL: localhost x x log ADMINPAGE_IP: 127.0.0.1 ADMINPAGE_PASSWORD: BULLSHIT MAINTAIN: 0 TEST_SERVER: 0 PK_SERVER: 0 BIND_IP: xx.xxx.xxx.xxx auth autorun: Quote PUBLIC_IP: xx.xxx.xxx.xxx interface vtnet0 HOSTNAME: auth AsyncSQL: connected to localhost (reconnect 1) CommonSQL connected Setting Locale "romania" (Path: locale/romania) Setting DB to locale latin2 AsyncSQL: connected to localhost (reconnect 1) AsyncSQL: connected to localhost (reconnect 1) AsyncSQL: connected to localhost (reconnect 1) PlayerSQL connected LogSQL connected SKILL_POWER_BY_LEVEL 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 SKILL_POWER_BY_JOB 0 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 SKILL_POWER_BY_JOB 1 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 SKILL_POWER_BY_JOB 2 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 AsyncSQL: connected to localhost (reconnect 1) SKILL_POWER_BY_JOB 3 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 SKILL_POWER_BY_JOB 4 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 SKILL_POWER_BY_JOB 5 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 SKILL_POWER_BY_JOB 6 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 SKILL_POWER_BY_JOB 7 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240 AUTH_SERVER: I am the master ----------------------------------------------- TEST_SERVER ----------------------------------------------- MasterAuth 25 Output : Only CH1 opened PS output and i can login ingame no problems Quote # ps PID TT STAT TIME COMMAND 23 v0 Is+ 0:00.03 sh /etc/rc autoboot 1006 v0 I+ 0:00.00 sh /etc/rc autoboot 1007 v0 I+ 0:00.01 /usr/sbin/sendmail -L sm-mta -bd -q30m -ODaemonPortOptions=Addr=localhost 1015 0 Ss 0:00.01 -sh (sh) 1114 0 S 0:00.01 ./vrunner --daemon --pid-path=pid.db --file=db 1116 0 S 0:00.83 db 1118 0 S 0:00.00 ./vrunner --daemon --pid-path=pid.auth --file=auth 1120 0 S 0:00.10 auth (game) 1122 0 S 0:00.00 ./vrunner --daemon --pid-path=pid.ch1 --file=ch1 1124 0 S 0:07.00 ch1 (game) 1127 0 S 0:00.00 ./vrunner --daemon --pid-path=pid.s_ch1 --file=s_ch1 1129 0 S 0:06.72 s_ch1 (game) 1132 0 S 0:00.00 ./vrunner --daemon --pid-path=pid.special_ch --file=special_ch 1134 0 S 0:01.96 special_ch (game) 1135 0 R+ 0:00.00 ps # service mysql-server status mysql is not running. # So, because of my mysql stopping the connection may cause the rest of channels to drop, maybe. and how can i fix my mysql to be up? If anyone can help me with this, add me on discord please "Revenge Arena#4229".. i'm 28hours awake already pushing on this problem with no solution.. Edited April 5, 2020 by Shahin Link to comment Share on other sites More sharing options...
Premium tierrilopes 452 Posted April 5, 2020 Premium Share Posted April 5, 2020 You need to check mysql.err and .log, it may have some relevant info explaining its crash Also (because you said it works fine with just one ch and when the others are turned on it starts that behavior) it can be a shortage of resources issue, in this case a ram bottleneck. Link to comment Share on other sites More sharing options...
⚡FlasH⚡ 65 Posted April 5, 2020 Share Posted April 5, 2020 40 minutes ago, tierrilopes said: You need to check mysql.err and .log, it may have some relevant info explaining its crash Also (because you said it works fine with just one ch and when the others are turned on it starts that behavior) it can be a shortage of resources issue, in this case a ram bottleneck. how he said "it can be a shortage of resources issue, in this case a ram bottleneck." or u can check SWAP memory and if is 1GB u can add 4GB is better ,or if is 100% that can cause mysql crash Command: for gigabytes swapinfo -g for megabytes swapinfo -m Link to comment Share on other sites More sharing options...
Shahin 223 Posted April 5, 2020 Author Share Posted April 5, 2020 (edited) My host is 2Cores 4gb ram. my.cnf: Quote [mysqld] max_connections = 4000 max_connect_errors=20000 query_cache_type=1 query_cache_limit=20M query_cache_size=256M log-slow-queries=slow.log long_query_time=2 mysql_enable=yes mysql.err: Quote 200405 20:35:22 mysqld_safe Logging to '/var/db/mysql/Metin.err'. 200405 20:35:22 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql Warning: World-writable config file '/var/db/mysql/my.cnf' is ignored Warning: World-writable config file '/var/db/mysql/my.cnf' is ignored 2020-04-05 20:35:23 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-04-05 20:35:23 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.47) starting as process 1321 ... 2020-04-05 20:35:23 1321 [Note] Plugin 'FEDERATED' is disabled. 2020-04-05 20:35:23 1321 [Note] InnoDB: Using atomics to ref count buffer pool pages 2020-04-05 20:35:23 1321 [Note] InnoDB: The InnoDB memory heap is disabled 2020-04-05 20:35:23 1321 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-04-05 20:35:23 1321 [Note] InnoDB: Memory barrier is not used 2020-04-05 20:35:23 1321 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-04-05 20:35:23 1321 [Note] InnoDB: Using CPU crc32 instructions 2020-04-05 20:35:23 1321 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2020-04-05 20:35:23 1321 [Note] InnoDB: Completed initialization of buffer pool 2020-04-05 20:35:23 1321 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2020-04-05 20:35:23 1321 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2020-04-05 20:35:23 1321 [Note] InnoDB: Database physically writes the file full: wait... 2020-04-05 20:35:23 1321 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2020-04-05 20:35:23 1321 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2020-04-05 20:35:23 1321 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2020-04-05 20:35:23 1321 [Warning] InnoDB: New log files created, LSN=45781 2020-04-05 20:35:23 1321 [Note] InnoDB: Doublewrite buffer not found: creating new 2020-04-05 20:35:23 1321 [Note] InnoDB: Doublewrite buffer created 2020-04-05 20:35:23 1321 [Note] InnoDB: 128 rollback segment(s) are active. 2020-04-05 20:35:23 1321 [Warning] InnoDB: Creating foreign key constraint system tables. 2020-04-05 20:35:23 1321 [Note] InnoDB: Foreign key constraint system tables created 2020-04-05 20:35:23 1321 [Note] InnoDB: Creating tablespace and datafile system tables. 2020-04-05 20:35:23 1321 [Note] InnoDB: Tablespace and datafile system tables created. 2020-04-05 20:35:23 1321 [Note] InnoDB: Waiting for purge to start 2020-04-05 20:35:23 1321 [Note] InnoDB: 5.6.47 started; log sequence number 0 2020-04-05 20:35:23 1321 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work. 2020-04-05 20:35:23 1321 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work. 2020-04-05 20:35:23 1321 [Note] Server hostname (bind-address): '*'; port: 3306 2020-04-05 20:35:23 1321 [Note] IPv6 is available. 2020-04-05 20:35:23 1321 [Note] - '::' resolves to '::'; 2020-04-05 20:35:23 1321 [Note] Server socket created on IP: '::'. 2020-04-05 20:35:23 1321 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2020-04-05 20:35:23 1321 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2020-04-05 20:35:23 1321 [ERROR] Aborting 2020-04-05 20:35:23 1321 [Note] Binlog end 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'partition' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_METRICS' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_CMPMEM' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_CMP' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_LOCKS' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_TRX' 2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'InnoDB' 2020-04-05 20:35:23 1321 [Note] InnoDB: FTS optimize thread exiting. 2020-04-05 20:35:23 1321 [Note] InnoDB: Starting shutdown... 2020-04-05 20:35:24 1321 [Note] InnoDB: Shutdown completed; log sequence number 1600607 2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'BLACKHOLE' 2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'ARCHIVE' 2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'MRG_MYISAM' 2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'MyISAM' 2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'MEMORY' 2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'CSV' 2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'sha256_password' 2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'mysql_old_password' 2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'mysql_native_password' 2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'binlog' 2020-04-05 20:35:24 1321 [Note] /usr/local/libexec/mysqld: Shutdown complete 200405 20:35:24 mysqld_safe mysqld from pid file /var/db/mysql/Metin.pid ended Edited April 5, 2020 by Shahin Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now