alexandru1992 0 Posted January 4, 2016 Share Posted January 4, 2016 Ok man you are awesome you worth your grade , i will try but i have a little question, if i do this way i will block myself? I mean i will still be capable to login from internal network?? Because i think that will happen Link to comment Share on other sites More sharing options...
Premium masodikbela 1506 Posted January 4, 2016 Premium Share Posted January 4, 2016 No, you won't. (I mean for me its working perfect both on windows and BSD) The one and only UI programming guideline Something New Link to comment Share on other sites More sharing options...
alexandru1992 0 Posted January 4, 2016 Share Posted January 4, 2016 And can i ask you sure if only i don't bother you if i have to portforward the p2p_ports or not,because i know i don't have to portforward them , only the channel/cores ports need to be forwarded, from my knowledge p2p_ports are accesed only internaly and acces from outsite the internal network should be block on them ,am I right? Link to comment Share on other sites More sharing options...
Premium masodikbela 1506 Posted January 4, 2016 Premium Share Posted January 4, 2016 Yes, you are. The p2p ports used only by the cores to communicate with each other on the LAN network. The one and only UI programming guideline Something New Link to comment Share on other sites More sharing options...
alexandru1992 0 Posted January 12, 2016 Share Posted January 12, 2016 Hi guys,i promised i will be back with the confirmation if masodikbela's suggestion with game will work,today i finally have time to test the method and guess what it really works ,it solved my problem,thank you very much masodikblea,but at first i get some connection refused i looked at my syserror on channels and it seems like only problem was that i have to port forward some p2p_ports on external ip ,more precise channel99 port and core2_channel1 port ,i don't really know why i have to port forward these but that solved the problem with connection refused,so i have one question ,i follow your tutorial and replace both in strlcpy,and memcpy with my external ip and now i have to portforward those p2p_ports, what do i have to do to have more security on those p2p_ports?use pf ?or ipfw? and what rule i have to set to pass all outcoming or incoming packets,because i think i have to pass only out packet? Link to comment Share on other sites More sharing options...
Premium masodikbela 1506 Posted January 17, 2016 Premium Share Posted January 17, 2016 On 2016. 01. 12. at 5:09 PM, alexandru1992 said: Hi guys,i promised i will be back with the confirmation if masodikbela's suggestion with game will work,today i finally have time to test the method and guess what it really works ,it solved my problem,thank you very much masodikblea,but at first i get some connection refused i looked at my syserror on channels and it seems like only problem was that i have to port forward some p2p_ports on external ip ,more precise channel99 port and core2_channel1 port ,i don't really know why i have to port forward these but that solved the problem with connection refused,so i have one question ,i follow your tutorial and replace both in strlcpy,and memcpy with my external ip and now i have to portforward those p2p_ports, what do i have to do to have more security on those p2p_ports?use pf ?or ipfw? and what rule i have to set to pass all outcoming or incoming packets,because i think i have to pass only out packet? Well on BSD you have to wait some minutes after starting the core to establish the local connection (IDK why...) In this time, you probably will see some connection refused "operation timed out" message (about 5-10 pcs), but don't panic! Just wait ~2 minutes, then try to connect. You don't have to portforward the p2p ports. Edit: Hmm... its quite interesting, for me I didn't have to portforward the p2p_ports, they was closed, and I got only operation timed out, as I mentioned it before. The one and only UI programming guideline Something New Link to comment Share on other sites More sharing options...
shishishi 0 Posted March 3, 2016 Share Posted March 3, 2016 (edited) does anyone know how to fix this? the server is working but this warning is so boring Edited August 20, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Premium masodikbela 1506 Posted March 3, 2016 Premium Share Posted March 3, 2016 (edited) 6 hours ago, shishishi said: does anyone know how to fix this? the server is working but this warning is so boring Its not the best way, but if you build it in release mode (not debug) probably will solve the problem. Also if you use vs13 probably you won't get this problem. (Btw the best way would be debug the core properly to see what's causes this problem...) Edited August 20, 2022 by Metin2 Dev Core X - External 2 Internal 1 1 The one and only UI programming guideline Something New Link to comment Share on other sites More sharing options...
shishishi 0 Posted March 3, 2016 Share Posted March 3, 2016 40 minutes ago, masodikbela said: Its not the best way, but if you build it in release mode (not debug) probably will solve the problem. Also if you use vs13 probably you won't get this problem. (Btw the best way would be debug the core properly to see what's causes this problem...) if I build the source in release mode it gives me a lot of errors... and if I convert the project in vs13 it gives me more and more errors Link to comment Share on other sites More sharing options...
Wonder 0 Posted March 11, 2016 Share Posted March 11, 2016 Hey, i have Problem with the Compile..linking ../game_r_32..../usr/bin/ld: cannot find -lILMakefile:138: recipe for target '../game_r_32' failedgmake: *** [../game_r_32] Error 1 Link to comment Share on other sites More sharing options...
Mr.Oz J. 5 Posted March 20, 2016 Share Posted March 20, 2016 guys i followed sanchez's guide *Trying to block OTHER GROUP MEMBER CAN PICKUP my items , if i am the owner, and if i have full inventory. also i would like to add a syschat (unable to pickup other player items, this item belong to ---read the name of the owner of item i m trying to pick up -.. ) _______ Just replace this in char_item.cpp: LPCHARACTER owner = funcFindOwnership.owner; With this: LPCHARACTER owner = funcFindOwnership.owner; // Owner does not exist, so don't allow to run remaining codes. if (!owner) return false; The next line of the code will set me as owner of the item if the owner is currently nobody. And sure, it's nobody because no one is the owner of the item from my group. but unfortunatly it didnt blocked the process Link to comment Share on other sites More sharing options...
TekkForCeAD2 174 Posted April 18, 2016 Share Posted April 18, 2016 (edited) Hello, Who i can Change the Start Up Message in the Source ?? Edited August 20, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
TRBizeps 56 Posted June 19, 2016 Share Posted June 19, 2016 Here it is Dude !! Holy shit STRG+A open All with n++ STRG F KoriDev Link to comment Share on other sites More sharing options...
socressor 1 Posted August 2, 2016 Share Posted August 2, 2016 Hello, I've got a Question. I try to write a C# Client...but I fail at the login . Anyboy knows how to do the tcp login? In which way it works? I have debugged the C++ Source for Days...but I can't find the right way. Link to comment Share on other sites More sharing options...
Nero 21 Posted March 11, 2017 Share Posted March 11, 2017 Hello, how can I set a Weapon Costume to work only on a specific weapon. For example : Let's say that I have a coloured level 1 sword (costume), how can I set this costume unequipable unless I equiped level 1 sword too. Anyone knows? Ps : If you didn't understand, but you want to help me, tell me and I'll explain it clearly. Ps2: Sorry for my english mistakes. Link to comment Share on other sites More sharing options...
Active Member Volvox 1682 Posted September 13, 2021 Active Member Share Posted September 13, 2021 look at bool CHARACTER::EquipItem(LPITEM item, int iCandidateCell) bool CHARACTER::EquipItem(LPITEM item, int iCandidateCell) Then maybe something like that; if (item->GetVnum() == 1234 && GetWear(PART_WEAPON) != NULL) { if (GetWear(PART_WEAPON)->GetVnum() != 4321) { ChatPacket(CHAT_TYPE_INFO, "NOT_VNUM_4321_EQUIPPED")); return false; } } I there are more, you can filter for type/subtype or do a array of vnum Link to comment Share on other sites More sharing options...
antrikos91 2 Posted September 23, 2022 Share Posted September 23, 2022 Hello guys, after install the server its all works good and when i start the game i have too many connection refused. I dont know why. Can you help me guys? please This is my mysql .err : Spoiler 2022-09-21T12:02:25.6NZ mysqld_safe Logging to '/var/db/mysql/omikron.err'. 2022-09-21T12:02:25.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 2022-09-21T12:02:26.160290Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-09-21T12:02:26.162143Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.38) starting as process 1726 ... 2022-09-21T12:02:26.165146Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2022-09-21T12:02:26.165165Z 0 [Note] InnoDB: Uses event mutexes 2022-09-21T12:02:26.165173Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2022-09-21T12:02:26.165180Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 2022-09-21T12:02:26.165453Z 0 [Note] InnoDB: Number of pools: 1 2022-09-21T12:02:26.165536Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-09-21T12:02:26.166796Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-09-21T12:02:26.181937Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-09-21T12:02:26.196146Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-09-21T12:02:26.205148Z 0 [Note] InnoDB: Creating tablespace and datafile system tables. 2022-09-21T12:02:26.209492Z 0 [Note] InnoDB: Tablespace and datafile system tables created. 2022-09-21T12:02:26.210718Z 0 [Warning] InnoDB: Upgrading redo log: 2*3072 pages, LSN=1600088 2022-09-21T12:02:26.314729Z 0 [Warning] InnoDB: Starting to delete and rewrite log files. 2022-09-21T12:02:26.315801Z 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2022-09-21T12:02:26.379245Z 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2022-09-21T12:02:26.441469Z 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2022-09-21T12:02:26.441537Z 0 [Warning] InnoDB: New log files created, LSN=1600088 2022-09-21T12:02:26.441732Z 0 [Note] InnoDB: Successfully reset 32 pre-5.7.2 rseg slots. 2022-09-21T12:02:26.441750Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-09-21T12:02:26.441787Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-09-21T12:02:26.458459Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-09-21T12:02:26.459221Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-09-21T12:02:26.459231Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-09-21T12:02:26.459505Z 0 [Note] InnoDB: Creating sys_virtual system tables. 2022-09-21T12:02:26.459917Z 0 [Note] InnoDB: sys_virtual table created 2022-09-21T12:02:26.460024Z 0 [Note] InnoDB: Waiting for purge to start 2022-09-21T12:02:26.513220Z 0 [Note] InnoDB: 5.7.38 started; log sequence number 0 2022-09-21T12:02:26.513597Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-09-21T12:02:26.516282Z 0 [Warning] System table 'plugin' is expected to be transactional. mysqld: Error on delete of './auto.cnf' (Errcode: 2 - No such file or directory) 2022-09-21T12:02:26.516659Z 0 [Warning] World-writable config file './auto.cnf' has been removed. 2022-09-21T12:02:26.516693Z 0 [Note] Salting uuid generator variables, current_pid: 1726, server_start_time: 1663761746, bytes_sent: 0, 2022-09-21T12:02:26.516722Z 0 [Note] Generated uuid: '426ccd5e-39a5-11ed-827b-62520285d11e', server_start_time: 1663763472, bytes_sent: 921683968 2022-09-21T12:02:26.516733Z 0 [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: 426ccd5e-39a5-11ed-827b-62520285d11e. 2022-09-21T12:02:26.517037Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool 2022-09-21T12:02:26.517189Z 0 [ERROR] InnoDB: Cannot open '/var/db/mysql/ib_buffer_pool' for reading: No such file or directory 2022-09-21T12:02:26.517368Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2022-09-21T12:02:27.505561Z 0 [Note] Auto generated SSL certificates are placed in data directory. 2022-09-21T12:02:27.505883Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. 2022-09-21T12:02:27.505892Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. 2022-09-21T12:02:27.506444Z 0 [Warning] CA certificate ca.pem is self signed. 2022-09-21T12:02:27.936190Z 0 [Note] Auto generated RSA key files are placed in data directory. 2022-09-21T12:02:27.937236Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-09-21T12:02:27.937273Z 0 [Note] IPv6 is available. 2022-09-21T12:02:27.937285Z 0 [Note] - '::' resolves to '::'; 2022-09-21T12:02:27.937307Z 0 [Note] Server socket created on IP: '::'. 2022-09-21T12:02:27.937329Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2022-09-21T12:02:27.937335Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2022-09-21T12:02:27.937345Z 0 [ERROR] Aborting 2022-09-21T12:02:27.937360Z 0 [Note] Binlog end 2022-09-21T12:02:27.937396Z 0 [Note] Shutting down plugin 'ngram' 2022-09-21T12:02:27.937403Z 0 [Note] Shutting down plugin 'partition' 2022-09-21T12:02:27.937409Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-09-21T12:02:27.937416Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-09-21T12:02:27.937421Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-09-21T12:02:27.937465Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-09-21T12:02:27.937472Z 0 [Note] Shutting down plugin 'MyISAM' 2022-09-21T12:02:27.937484Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2022-09-21T12:02:27.937491Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2022-09-21T12:02:27.937497Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2022-09-21T12:02:27.937503Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2022-09-21T12:02:27.937509Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2022-09-21T12:02:27.937514Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2022-09-21T12:02:27.937520Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2022-09-21T12:02:27.937526Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2022-09-21T12:02:27.937532Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2022-09-21T12:02:27.937538Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2022-09-21T12:02:27.937543Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-09-21T12:02:27.937549Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-09-21T12:02:27.937555Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2022-09-21T12:02:27.937561Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-09-21T12:02:27.937567Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2022-09-21T12:02:27.937573Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-09-21T12:02:27.937578Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2022-09-21T12:02:27.937584Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-09-21T12:02:27.937590Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-09-21T12:02:27.937596Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-09-21T12:02:27.937602Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-09-21T12:02:27.937608Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-09-21T12:02:27.937615Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-09-21T12:02:27.937622Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-09-21T12:02:27.937628Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2022-09-21T12:02:27.937634Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2022-09-21T12:02:27.937639Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2022-09-21T12:02:27.937645Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2022-09-21T12:02:27.937651Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2022-09-21T12:02:27.937656Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2022-09-21T12:02:27.937662Z 0 [Note] Shutting down plugin 'InnoDB' 2022-09-21T12:02:27.937867Z 0 [Note] InnoDB: FTS optimize thread exiting. 2022-09-21T12:02:27.938048Z 0 [Note] InnoDB: Starting shutdown... 2022-09-21T12:02:28.044531Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/db/mysql/ib_buffer_pool 2022-09-21T12:02:28.045018Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220921 14:02:28 2022-09-21T12:02:28.883439Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1603681 2022-09-21T12:02:28.884335Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-09-21T12:02:28.884350Z 0 [Note] Shutting down plugin 'MEMORY' 2022-09-21T12:02:28.884358Z 0 [Note] Shutting down plugin 'CSV' 2022-09-21T12:02:28.884365Z 0 [Note] Shutting down plugin 'sha256_password' 2022-09-21T12:02:28.884371Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-09-21T12:02:28.884489Z 0 [Note] Shutting down plugin 'binlog' 2022-09-21T12:02:28.884606Z 0 [Note] /usr/local/libexec/mysqld: Shutdown complete 2022-09-21T12:02:28.6NZ mysqld_safe mysqld from pid file /var/db/mysql/omikron.pid ended 2022-09-21T12:04:50.6NZ mysqld_safe mysqld from pid file /var/db/mysql/omikron.pid ended 2022-09-21T12:05:29.6NZ mysqld_safe Logging to '/var/db/mysql/omikron.err'. 2022-09-21T12:05:29.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 2022-09-21T12:05:29.823654Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-09-21T12:05:29.826960Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.38) starting as process 863 ... 2022-09-21T12:05:29.836557Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2022-09-21T12:05:29.836577Z 0 [Note] InnoDB: Uses event mutexes 2022-09-21T12:05:29.836584Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2022-09-21T12:05:29.836591Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 2022-09-21T12:05:29.837305Z 0 [Note] InnoDB: Number of pools: 1 2022-09-21T12:05:29.838197Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-09-21T12:05:29.840019Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-09-21T12:05:29.856404Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-09-21T12:05:29.877622Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-09-21T12:05:29.887885Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-09-21T12:05:29.887936Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-09-21T12:05:29.905221Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-09-21T12:05:29.906069Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-09-21T12:05:29.906084Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-09-21T12:05:29.906289Z 0 [Note] InnoDB: Waiting for purge to start 2022-09-21T12:05:29.959487Z 0 [Note] InnoDB: 5.7.38 started; log sequence number 1603681 2022-09-21T12:05:29.959930Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool 2022-09-21T12:05:29.960184Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-09-21T12:05:29.960607Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220921 14:05:29 2022-09-21T12:05:29.964643Z 0 [Warning] System table 'plugin' is expected to be transactional. 2022-09-21T12:05:29.966271Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2022-09-21T12:05:29.970026Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-09-21T12:05:29.970037Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-09-21T12:05:29.970045Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. 2022-09-21T12:05:29.970052Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. 2022-09-21T12:05:29.971632Z 0 [Warning] CA certificate ca.pem is self signed. 2022-09-21T12:05:29.972105Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-09-21T12:05:29.973097Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-09-21T12:05:29.973134Z 0 [Note] IPv6 is available. 2022-09-21T12:05:29.973145Z 0 [Note] - '::' resolves to '::'; 2022-09-21T12:05:29.973164Z 0 [Note] Server socket created on IP: '::'. 2022-09-21T12:05:29.973791Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/db/mysql' in the path is accessible to all OS users. Consider choosing a different directory. 2022-09-21T12:05:29.973876Z 0 [Warning] Failed to open optimizer cost constant tables 2022-09-21T12:05:29.977471Z 0 [Warning] System table 'time_zone_leap_second' is expected to be transactional. 2022-09-21T12:05:29.977480Z 0 [Warning] System table 'time_zone_name' is expected to be transactional. 2022-09-21T12:05:29.977486Z 0 [Warning] System table 'time_zone' is expected to be transactional. 2022-09-21T12:05:29.977492Z 0 [Warning] System table 'time_zone_transition_type' is expected to be transactional. 2022-09-21T12:05:29.977497Z 0 [Warning] System table 'time_zone_transition' is expected to be transactional. 2022-09-21T12:05:29.978865Z 0 [Warning] System table 'servers' is expected to be transactional. 2022-09-21T12:05:29.980479Z 0 [ERROR] Column count of performance_schema.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error. 2022-09-21T12:05:29.980673Z 0 [ERROR] Column count of performance_schema.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error. 2022-09-21T12:05:29.980872Z 0 [ERROR] Column count of performance_schema.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error. 2022-09-21T12:05:29.980918Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure 2022-09-21T12:05:29.981298Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11). 2022-09-21T12:05:29.981335Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure 2022-09-21T12:05:29.981362Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure 2022-09-21T12:05:29.981963Z 0 [ERROR] Column count of performance_schema.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error. 2022-09-21T12:05:29.982180Z 0 [ERROR] Column count of performance_schema.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error. 2022-09-21T12:05:29.982213Z 0 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure 2022-09-21T12:05:29.982409Z 0 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11). 2022-09-21T12:05:29.982438Z 0 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure 2022-09-21T12:05:29.982860Z 0 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11). 2022-09-21T12:05:29.982889Z 0 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure 2022-09-21T12:05:29.983293Z 0 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure 2022-09-21T12:05:29.983510Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure 2022-09-21T12:05:29.983535Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure 2022-09-21T12:05:29.983564Z 0 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure 2022-09-21T12:05:29.983741Z 0 [ERROR] Column count of performance_schema.threads is wrong. Expected 17, found 3. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error. 2022-09-21T12:05:29.983781Z 0 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure 2022-09-21T12:05:29.983804Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure 2022-09-21T12:05:29.983832Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure 2022-09-21T12:05:29.983856Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure 2022-09-21T12:05:29.983882Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure 2022-09-21T12:05:29.983905Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure 2022-09-21T12:05:29.983934Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure 2022-09-21T12:05:29.983960Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure 2022-09-21T12:05:29.983996Z 0 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure 2022-09-21T12:05:29.984019Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure 2022-09-21T12:05:29.984055Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure 2022-09-21T12:05:29.984082Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure 2022-09-21T12:05:29.984110Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure 2022-09-21T12:05:29.984138Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure 2022-09-21T12:05:29.984164Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure 2022-09-21T12:05:29.984194Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure 2022-09-21T12:05:29.984222Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure 2022-09-21T12:05:29.984245Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_program' has the wrong structure 2022-09-21T12:05:29.984273Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_current' has the wrong structure 2022-09-21T12:05:29.984298Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history' has the wrong structure 2022-09-21T12:05:29.984323Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history_long' has the wrong structure 2022-09-21T12:05:29.984346Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_thread_by_event_name' has the wrong structure 2022-09-21T12:05:29.984372Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_account_by_event_name' has the wrong structure 2022-09-21T12:05:29.984395Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_user_by_event_name' has the wrong structure 2022-09-21T12:05:29.984418Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_host_by_event_name' has the wrong structure 2022-09-21T12:05:29.984445Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_global_by_event_name' has the wrong structure 2022-09-21T12:05:29.984470Z 0 [ERROR] Native table 'performance_schema'.'users' has the wrong structure 2022-09-21T12:05:29.984493Z 0 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure 2022-09-21T12:05:29.984520Z 0 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure 2022-09-21T12:05:29.984551Z 0 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure 2022-09-21T12:05:29.984576Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure 2022-09-21T12:05:29.984598Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure 2022-09-21T12:05:29.984622Z 0 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure 2022-09-21T12:05:29.984647Z 0 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure 2022-09-21T12:05:29.984673Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_global_by_event_name' has the wrong structure 2022-09-21T12:05:29.984695Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_account_by_event_name' has the wrong structure 2022-09-21T12:05:29.984720Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_host_by_event_name' has the wrong structure 2022-09-21T12:05:29.984743Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_thread_by_event_name' has the wrong structure 2022-09-21T12:05:29.984773Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_user_by_event_name' has the wrong structure 2022-09-21T12:05:29.984801Z 0 [ERROR] Native table 'performance_schema'.'table_handles' has the wrong structure 2022-09-21T12:05:29.984823Z 0 [ERROR] Native table 'performance_schema'.'metadata_locks' has the wrong structure 2022-09-21T12:05:29.984848Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_configuration' has the wrong structure 2022-09-21T12:05:29.984870Z 0 [ERROR] Native table 'performance_schema'.'replication_group_members' has the wrong structure 2022-09-21T12:05:29.984895Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_status' has the wrong structure 2022-09-21T12:05:29.984932Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_configuration' has the wrong structure 2022-09-21T12:05:29.984957Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status' has the wrong structure 2022-09-21T12:05:29.984983Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_coordinator' has the wrong structure 2022-09-21T12:05:29.985005Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_worker' has the wrong structure 2022-09-21T12:05:29.985032Z 0 [ERROR] Native table 'performance_schema'.'replication_group_member_stats' has the wrong structure 2022-09-21T12:05:29.985058Z 0 [ERROR] Native table 'performance_schema'.'prepared_statements_instances' has the wrong structure 2022-09-21T12:05:29.985084Z 0 [ERROR] Native table 'performance_schema'.'user_variables_by_thread' has the wrong structure 2022-09-21T12:05:29.985114Z 0 [ERROR] Native table 'performance_schema'.'status_by_account' has the wrong structure 2022-09-21T12:05:29.985136Z 0 [ERROR] Native table 'performance_schema'.'status_by_host' has the wrong structure 2022-09-21T12:05:29.985158Z 0 [ERROR] Native table 'performance_schema'.'status_by_thread' has the wrong structure 2022-09-21T12:05:29.985188Z 0 [ERROR] Native table 'performance_schema'.'status_by_user' has the wrong structure 2022-09-21T12:05:29.985212Z 0 [ERROR] Native table 'performance_schema'.'global_status' has the wrong structure 2022-09-21T12:05:29.985234Z 0 [ERROR] Native table 'performance_schema'.'session_status' has the wrong structure 2022-09-21T12:05:29.985260Z 0 [ERROR] Native table 'performance_schema'.'variables_by_thread' has the wrong structure 2022-09-21T12:05:29.985283Z 0 [ERROR] Native table 'performance_schema'.'global_variables' has the wrong structure 2022-09-21T12:05:29.985311Z 0 [ERROR] Native table 'performance_schema'.'session_variables' has the wrong structure 2022-09-21T12:05:29.985386Z 0 [ERROR] Incorrect definition of table mysql.db: expected column 'User' at position 2 to have type char(32), found type char(16). 2022-09-21T12:05:29.985426Z 0 [ERROR] mysql.user has no `Event_priv` column at position 28 2022-09-21T12:05:29.985868Z 0 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 2022-09-21T12:05:29.985968Z 0 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.7.38' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2022-09-21T12:06:44.147004Z 2 [Note] Access denied for user 'root'@'localhost' (using password: YES) 2022-09-21T12:07:53.267501Z 4 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2022-09-21T12:08:19.187639Z 5 [ERROR] /usr/local/libexec/mysqld: Column count of mysql.user is wrong. Expected 45, found 42. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error. 2022-09-21T12:08:38.562141Z 5 [ERROR] /usr/local/libexec/mysqld: Column count of mysql.user is wrong. Expected 45, found 42. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error. 2022-09-21T12:09:05.460488Z 5 [Note] Aborted connection 5 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-09-21T12:09:06.892739Z 6 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2022-09-21T12:09:17.747755Z 0 [Note] Giving 0 client threads a chance to die gracefully 2022-09-21T12:09:17.747770Z 0 [Note] Shutting down slave threads 2022-09-21T12:09:17.748018Z 0 [Note] Forcefully disconnecting 0 remaining clients 2022-09-21T12:09:17.748178Z 0 [Note] Binlog end 2022-09-21T12:09:17.748378Z 0 [Note] Shutting down plugin 'ngram' 2022-09-21T12:09:17.748385Z 0 [Note] Shutting down plugin 'partition' 2022-09-21T12:09:17.748392Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-09-21T12:09:17.748398Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-09-21T12:09:17.748404Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-09-21T12:09:17.748433Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-09-21T12:09:17.748440Z 0 [Note] Shutting down plugin 'MyISAM' 2022-09-21T12:09:17.748451Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2022-09-21T12:09:17.748470Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2022-09-21T12:09:17.748476Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2022-09-21T12:09:17.748482Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2022-09-21T12:09:17.748488Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2022-09-21T12:09:17.748493Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2022-09-21T12:09:17.748499Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2022-09-21T12:09:17.748505Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2022-09-21T12:09:17.748511Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2022-09-21T12:09:17.748517Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2022-09-21T12:09:17.748523Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-09-21T12:09:17.748529Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-09-21T12:09:17.748534Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2022-09-21T12:09:17.748540Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-09-21T12:09:17.748546Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2022-09-21T12:09:17.748552Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-09-21T12:09:17.748558Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2022-09-21T12:09:17.748564Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-09-21T12:09:17.748570Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-09-21T12:09:17.748576Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-09-21T12:09:17.748581Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-09-21T12:09:17.748587Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-09-21T12:09:17.748593Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-09-21T12:09:17.748599Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-09-21T12:09:17.748605Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2022-09-21T12:09:17.748687Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2022-09-21T12:09:17.748694Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2022-09-21T12:09:17.748700Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2022-09-21T12:09:17.748705Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2022-09-21T12:09:17.748711Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2022-09-21T12:09:17.748717Z 0 [Note] Shutting down plugin 'InnoDB' 2022-09-21T12:09:17.748795Z 0 [Note] InnoDB: FTS optimize thread exiting. 2022-09-21T12:09:17.748949Z 0 [Note] InnoDB: Starting shutdown... 2022-09-21T12:09:17.855517Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/db/mysql/ib_buffer_pool 2022-09-21T12:09:17.855790Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220921 14:09:17 2022-09-21T12:09:18.913650Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1603709 2022-09-21T12:09:18.914447Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-09-21T12:09:18.914464Z 0 [Note] Shutting down plugin 'MEMORY' 2022-09-21T12:09:18.914472Z 0 [Note] Shutting down plugin 'CSV' 2022-09-21T12:09:18.914479Z 0 [Note] Shutting down plugin 'sha256_password' 2022-09-21T12:09:18.914485Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-09-21T12:09:18.914603Z 0 [Note] Shutting down plugin 'binlog' 2022-09-21T12:09:18.914808Z 0 [Note] /usr/local/libexec/mysqld: Shutdown complete 2022-09-21T12:09:18.6NZ mysqld_safe mysqld from pid file /var/db/mysql/omikron.pid ended 2022-09-21T12:10:16.6NZ mysqld_safe Logging to '/var/db/mysql/omikron.err'. 2022-09-21T12:10:16.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 2022-09-21T12:10:16.904875Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-09-21T12:10:16.907645Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.38) starting as process 1290 ... 2022-09-21T12:10:16.911148Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2022-09-21T12:10:16.911166Z 0 [Note] InnoDB: Uses event mutexes 2022-09-21T12:10:16.911173Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2022-09-21T12:10:16.911180Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 2022-09-21T12:10:16.911448Z 0 [Note] InnoDB: Number of pools: 1 2022-09-21T12:10:16.911530Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-09-21T12:10:16.913706Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-09-21T12:10:16.930551Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-09-21T12:10:16.945744Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-09-21T12:10:16.953877Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-09-21T12:10:16.953921Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-09-21T12:10:16.970432Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-09-21T12:10:16.971201Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-09-21T12:10:16.971219Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-09-21T12:10:16.971469Z 0 [Note] InnoDB: Waiting for purge to start 2022-09-21T12:10:17.024768Z 0 [Note] InnoDB: 5.7.38 started; log sequence number 1603709 2022-09-21T12:10:17.025116Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-09-21T12:10:17.028447Z 0 [Warning] System table 'plugin' is expected to be transactional. 2022-09-21T12:10:17.028917Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2022-09-21T12:10:17.030368Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-09-21T12:10:17.030379Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-09-21T12:10:17.030386Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. 2022-09-21T12:10:17.030404Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. 2022-09-21T12:10:17.031091Z 0 [Warning] CA certificate ca.pem is self signed. 2022-09-21T12:10:17.031142Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-09-21T12:10:17.032142Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-09-21T12:10:17.032190Z 0 [Note] IPv6 is available. 2022-09-21T12:10:17.032205Z 0 [Note] - '::' resolves to '::'; 2022-09-21T12:10:17.032229Z 0 [Note] Server socket created on IP: '::'. 2022-09-21T12:10:17.032553Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool 2022-09-21T12:10:17.032915Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220921 14:10:17 2022-09-21T12:10:17.033628Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/db/mysql' in the path is accessible to all OS users. Consider choosing a different directory. 2022-09-21T12:10:17.033737Z 0 [Warning] Failed to open optimizer cost constant tables 2022-09-21T12:10:17.034764Z 0 [Warning] System table 'time_zone_leap_second' is expected to be transactional. 2022-09-21T12:10:17.034775Z 0 [Warning] System table 'time_zone_name' is expected to be transactional. 2022-09-21T12:10:17.034780Z 0 [Warning] System table 'time_zone' is expected to be transactional. 2022-09-21T12:10:17.034786Z 0 [Warning] System table 'time_zone_transition_type' is expected to be transactional. 2022-09-21T12:10:17.034791Z 0 [Warning] System table 'time_zone_transition' is expected to be transactional. 2022-09-21T12:10:17.035317Z 0 [Warning] System table 'servers' is expected to be transactional. 2022-09-21T12:10:17.035632Z 0 [ERROR] Column count of performance_schema.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error. 2022-09-21T12:10:17.035703Z 0 [ERROR] Column count of performance_schema.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error. 2022-09-21T12:10:17.035775Z 0 [ERROR] Column count of performance_schema.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error. 2022-09-21T12:10:17.035807Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure 2022-09-21T12:10:17.035948Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11). 2022-09-21T12:10:17.035989Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure 2022-09-21T12:10:17.036034Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure 2022-09-21T12:10:17.036289Z 0 [ERROR] Column count of performance_schema.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error. 2022-09-21T12:10:17.036386Z 0 [ERROR] Column count of performance_schema.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error. 2022-09-21T12:10:17.036419Z 0 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure 2022-09-21T12:10:17.036487Z 0 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11). 2022-09-21T12:10:17.036527Z 0 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure 2022-09-21T12:10:17.036649Z 0 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11). 2022-09-21T12:10:17.036683Z 0 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure 2022-09-21T12:10:17.036823Z 0 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure 2022-09-21T12:10:17.036913Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure 2022-09-21T12:10:17.036935Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure 2022-09-21T12:10:17.036956Z 0 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure 2022-09-21T12:10:17.037025Z 0 [ERROR] Column count of performance_schema.threads is wrong. Expected 17, found 3. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error. 2022-09-21T12:10:17.037060Z 0 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure 2022-09-21T12:10:17.037081Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure 2022-09-21T12:10:17.037108Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure 2022-09-21T12:10:17.037129Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure 2022-09-21T12:10:17.037154Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure 2022-09-21T12:10:17.037175Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure 2022-09-21T12:10:17.037203Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure 2022-09-21T12:10:17.037227Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure 2022-09-21T12:10:17.037258Z 0 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure 2022-09-21T12:10:17.037279Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure 2022-09-21T12:10:17.037302Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure 2022-09-21T12:10:17.037327Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure 2022-09-21T12:10:17.037353Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure 2022-09-21T12:10:17.037379Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure 2022-09-21T12:10:17.037403Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure 2022-09-21T12:10:17.037425Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure 2022-09-21T12:10:17.037450Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure 2022-09-21T12:10:17.037471Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_program' has the wrong structure 2022-09-21T12:10:17.037498Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_current' has the wrong structure 2022-09-21T12:10:17.037521Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history' has the wrong structure 2022-09-21T12:10:17.037544Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history_long' has the wrong structure 2022-09-21T12:10:17.037566Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_thread_by_event_name' has the wrong structure 2022-09-21T12:10:17.037591Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_account_by_event_name' has the wrong structure 2022-09-21T12:10:17.037612Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_user_by_event_name' has the wrong structure 2022-09-21T12:10:17.037640Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_host_by_event_name' has the wrong structure 2022-09-21T12:10:17.037667Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_global_by_event_name' has the wrong structure 2022-09-21T12:10:17.037690Z 0 [ERROR] Native table 'performance_schema'.'users' has the wrong structure 2022-09-21T12:10:17.037712Z 0 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure 2022-09-21T12:10:17.037732Z 0 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure 2022-09-21T12:10:17.037759Z 0 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure 2022-09-21T12:10:17.037782Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure 2022-09-21T12:10:17.037803Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure 2022-09-21T12:10:17.037827Z 0 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure 2022-09-21T12:10:17.037850Z 0 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure 2022-09-21T12:10:17.037874Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_global_by_event_name' has the wrong structure 2022-09-21T12:10:17.037895Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_account_by_event_name' has the wrong structure 2022-09-21T12:10:17.037919Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_host_by_event_name' has the wrong structure 2022-09-21T12:10:17.037942Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_thread_by_event_name' has the wrong structure 2022-09-21T12:10:17.037994Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_user_by_event_name' has the wrong structure 2022-09-21T12:10:17.038032Z 0 [ERROR] Native table 'performance_schema'.'table_handles' has the wrong structure 2022-09-21T12:10:17.038060Z 0 [ERROR] Native table 'performance_schema'.'metadata_locks' has the wrong structure 2022-09-21T12:10:17.038088Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_configuration' has the wrong structure 2022-09-21T12:10:17.038108Z 0 [ERROR] Native table 'performance_schema'.'replication_group_members' has the wrong structure 2022-09-21T12:10:17.038131Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_status' has the wrong structure 2022-09-21T12:10:17.038157Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_configuration' has the wrong structure 2022-09-21T12:10:17.038179Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status' has the wrong structure 2022-09-21T12:10:17.038203Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_coordinator' has the wrong structure 2022-09-21T12:10:17.038224Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_worker' has the wrong structure 2022-09-21T12:10:17.038246Z 0 [ERROR] Native table 'performance_schema'.'replication_group_member_stats' has the wrong structure 2022-09-21T12:10:17.038269Z 0 [ERROR] Native table 'performance_schema'.'prepared_statements_instances' has the wrong structure 2022-09-21T12:10:17.038290Z 0 [ERROR] Native table 'performance_schema'.'user_variables_by_thread' has the wrong structure 2022-09-21T12:10:17.038317Z 0 [ERROR] Native table 'performance_schema'.'status_by_account' has the wrong structure 2022-09-21T12:10:17.038337Z 0 [ERROR] Native table 'performance_schema'.'status_by_host' has the wrong structure 2022-09-21T12:10:17.038357Z 0 [ERROR] Native table 'performance_schema'.'status_by_thread' has the wrong structure 2022-09-21T12:10:17.038388Z 0 [ERROR] Native table 'performance_schema'.'status_by_user' has the wrong structure 2022-09-21T12:10:17.038411Z 0 [ERROR] Native table 'performance_schema'.'global_status' has the wrong structure 2022-09-21T12:10:17.038430Z 0 [ERROR] Native table 'performance_schema'.'session_status' has the wrong structure 2022-09-21T12:10:17.038460Z 0 [ERROR] Native table 'performance_schema'.'variables_by_thread' has the wrong structure 2022-09-21T12:10:17.038481Z 0 [ERROR] Native table 'performance_schema'.'global_variables' has the wrong structure 2022-09-21T12:10:17.038500Z 0 [ERROR] Native table 'performance_schema'.'session_variables' has the wrong structure 2022-09-21T12:10:17.038572Z 0 [ERROR] Incorrect definition of table mysql.db: expected column 'User' at position 2 to have type char(32), found type char(16). 2022-09-21T12:10:17.038591Z 0 [ERROR] mysql.user has no `Event_priv` column at position 28 2022-09-21T12:10:17.038750Z 0 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 2022-09-21T12:10:17.038848Z 0 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.7.38' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2022-09-21T12:10:23.225699Z 2 [Warning] System table 'servers' is expected to be transactional. 2022-09-21T12:10:36.311345Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2022-09-21T12:20:19.942294Z 0 [Note] Giving 0 client threads a chance to die gracefully 2022-09-21T12:20:19.942309Z 0 [Note] Shutting down slave threads 2022-09-21T12:20:19.942317Z 0 [Note] Forcefully disconnecting 0 remaining clients 2022-09-21T12:20:19.942443Z 0 [Note] Binlog end 2022-09-21T12:20:19.943960Z 0 [Note] Shutting down plugin 'ngram' 2022-09-21T12:20:19.943973Z 0 [Note] Shutting down plugin 'partition' 2022-09-21T12:20:19.943981Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-09-21T12:20:19.943990Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-09-21T12:20:19.943996Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-09-21T12:20:19.944025Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-09-21T12:20:19.944032Z 0 [Note] Shutting down plugin 'MyISAM' 2022-09-21T12:20:19.944045Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2022-09-21T12:20:19.944052Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2022-09-21T12:20:19.944058Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2022-09-21T12:20:19.944064Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2022-09-21T12:20:19.944069Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2022-09-21T12:20:19.944075Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2022-09-21T12:20:19.944081Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2022-09-21T12:20:19.944086Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2022-09-21T12:20:19.944092Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2022-09-21T12:20:19.944098Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2022-09-21T12:20:19.944104Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-09-21T12:20:19.944109Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-09-21T12:20:19.944115Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2022-09-21T12:20:19.944121Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-09-21T12:20:19.944127Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2022-09-21T12:20:19.944132Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-09-21T12:20:19.944138Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2022-09-21T12:20:19.944144Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-09-21T12:20:19.944150Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-09-21T12:20:19.944155Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-09-21T12:20:19.944161Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-09-21T12:20:19.944167Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-09-21T12:20:19.944173Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-09-21T12:20:19.944178Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-09-21T12:20:19.944184Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2022-09-21T12:20:19.944190Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2022-09-21T12:20:19.944195Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2022-09-21T12:20:19.944201Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2022-09-21T12:20:19.944219Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2022-09-21T12:20:19.944225Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2022-09-21T12:20:19.944231Z 0 [Note] Shutting down plugin 'InnoDB' 2022-09-21T12:20:19.944274Z 0 [Note] InnoDB: FTS optimize thread exiting. 2022-09-21T12:20:19.944335Z 0 [Note] InnoDB: Starting shutdown... 2022-09-21T12:20:20.046133Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/db/mysql/ib_buffer_pool 2022-09-21T12:20:20.046342Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220921 14:20:20 2022-09-21T12:20:20.900318Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2674426 2022-09-21T12:20:20.901318Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-09-21T12:20:20.901338Z 0 [Note] Shutting down plugin 'MEMORY' 2022-09-21T12:20:20.901348Z 0 [Note] Shutting down plugin 'CSV' 2022-09-21T12:20:20.901357Z 0 [Note] Shutting down plugin 'sha256_password' 2022-09-21T12:20:20.901365Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-09-21T12:20:20.901535Z 0 [Note] Shutting down plugin 'binlog' 2022-09-21T12:20:20.901945Z 0 [Note] /usr/local/libexec/mysqld: Shutdown complete 2022-09-21T12:20:20.6NZ mysqld_safe mysqld from pid file /var/db/mysql/omikron.pid ended 2022-09-21T12:21:04.6NZ mysqld_safe Logging to '/var/db/mysql/omikron.err'. 2022-09-21T12:21:04.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 2022-09-21T12:21:04.865887Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-09-21T12:21:04.868721Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.38) starting as process 861 ... 2022-09-21T12:21:04.877586Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2022-09-21T12:21:04.877606Z 0 [Note] InnoDB: Uses event mutexes 2022-09-21T12:21:04.877614Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2022-09-21T12:21:04.877621Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 2022-09-21T12:21:04.878258Z 0 [Note] InnoDB: Number of pools: 1 2022-09-21T12:21:04.879160Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-09-21T12:21:04.881238Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-09-21T12:21:04.898024Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-09-21T12:21:04.916696Z 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2022-09-21T12:21:04.981429Z 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2022-09-21T12:21:05.074148Z 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2022-09-21T12:21:05.074220Z 0 [Warning] InnoDB: New log files created, LSN=2674426 2022-09-21T12:21:05.075276Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-09-21T12:21:05.075894Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2674700 2022-09-21T12:21:05.075905Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2674709 2022-09-21T12:21:05.075913Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-09-21T12:21:05.075919Z 0 [Note] InnoDB: Starting crash recovery. 2022-09-21T12:21:05.206010Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-09-21T12:21:05.206089Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-09-21T12:21:05.223188Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-09-21T12:21:05.224050Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-09-21T12:21:05.224061Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-09-21T12:21:05.224272Z 0 [Note] InnoDB: Waiting for purge to start 2022-09-21T12:21:05.277503Z 0 [Note] InnoDB: 5.7.38 started; log sequence number 2674709 2022-09-21T12:21:05.278058Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool 2022-09-21T12:21:05.278291Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-09-21T12:21:05.280386Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220921 14:21:05 2022-09-21T12:21:05.289935Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-09-21T12:21:05.289948Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-09-21T12:21:05.289954Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. 2022-09-21T12:21:05.289961Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. 2022-09-21T12:21:05.291543Z 0 [Warning] CA certificate ca.pem is self signed. 2022-09-21T12:21:05.291918Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-09-21T12:21:05.292829Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-09-21T12:21:05.292862Z 0 [Note] IPv6 is available. 2022-09-21T12:21:05.292872Z 0 [Note] - '::' resolves to '::'; 2022-09-21T12:21:05.292890Z 0 [Note] Server socket created on IP: '::'. 2022-09-21T12:21:05.293665Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/db/mysql' in the path is accessible to all OS users. Consider choosing a different directory. 2022-09-21T12:21:05.320465Z 0 [Note] Event Scheduler: Loaded 0 events 2022-09-21T12:21:05.320587Z 0 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.7.38' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2022-09-21T12:22:39.6NZ mysqld_safe mysqld restarted 2022-09-21T12:22:40.071178Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-09-21T12:22:40.073676Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.38) starting as process 987 ... 2022-09-21T12:22:40.081911Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2022-09-21T12:22:40.081929Z 0 [Note] InnoDB: Uses event mutexes 2022-09-21T12:22:40.081937Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2022-09-21T12:22:40.081944Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 2022-09-21T12:22:40.082367Z 0 [Note] InnoDB: Number of pools: 1 2022-09-21T12:22:40.083062Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-09-21T12:22:40.084950Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-09-21T12:22:40.100624Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-09-21T12:22:40.122103Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-09-21T12:22:40.122975Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2674728 2022-09-21T12:22:40.122987Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2674737 2022-09-21T12:22:40.122995Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-09-21T12:22:40.123002Z 0 [Note] InnoDB: Starting crash recovery. 2022-09-21T12:22:40.252749Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-09-21T12:22:40.252767Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-09-21T12:22:40.252811Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-09-21T12:22:40.269793Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-09-21T12:22:40.270644Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-09-21T12:22:40.270656Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-09-21T12:22:40.270879Z 0 [Note] InnoDB: Waiting for purge to start 2022-09-21T12:22:40.324091Z 0 [Note] InnoDB: 5.7.38 started; log sequence number 2674737 2022-09-21T12:22:40.324509Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool 2022-09-21T12:22:40.324990Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-09-21T12:22:40.326986Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220921 14:22:40 2022-09-21T12:22:40.339405Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-09-21T12:22:40.339432Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-09-21T12:22:40.339459Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. 2022-09-21T12:22:40.339465Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. 2022-09-21T12:22:40.342070Z 0 [Warning] CA certificate ca.pem is self signed. 2022-09-21T12:22:40.342487Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-09-21T12:22:40.343900Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-09-21T12:22:40.344185Z 0 [Note] IPv6 is available. 2022-09-21T12:22:40.344198Z 0 [Note] - '::' resolves to '::'; 2022-09-21T12:22:40.344216Z 0 [Note] Server socket created on IP: '::'. 2022-09-21T12:22:40.345187Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/db/mysql' in the path is accessible to all OS users. Consider choosing a different directory. 2022-09-21T12:22:40.372021Z 0 [Note] Event Scheduler: Loaded 0 events 2022-09-21T12:22:40.372135Z 0 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.7.38' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2022-09-21T12:28:34.540166Z 2 [Warning] IP address '755.647.155.34' could not be resolved: Name does not resolve 2022-09-21T12:29:16.748869Z 0 [Note] Giving 16 client threads a chance to die gracefully 2022-09-21T12:29:16.749028Z 0 [Note] Shutting down slave threads 2022-09-21T12:30:18.6NZ mysqld_safe Logging to '/var/db/mysql/omikron.err'. 2022-09-21T12:30:18.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 2022-09-21T12:30:18.566588Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-09-21T12:30:18.569642Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.38) starting as process 884 ... 2022-09-21T12:30:18.578895Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2022-09-21T12:30:18.578916Z 0 [Note] InnoDB: Uses event mutexes 2022-09-21T12:30:18.578924Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2022-09-21T12:30:18.578931Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 2022-09-21T12:30:18.579607Z 0 [Note] InnoDB: Number of pools: 1 2022-09-21T12:30:18.580626Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-09-21T12:30:18.582527Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-09-21T12:30:18.598197Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-09-21T12:30:18.621596Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-09-21T12:30:18.626060Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2674756 2022-09-21T12:30:18.626070Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2674765 2022-09-21T12:30:18.626079Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-09-21T12:30:18.626085Z 0 [Note] InnoDB: Starting crash recovery. 2022-09-21T12:30:19.142612Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-09-21T12:30:19.142628Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-09-21T12:30:19.142667Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-09-21T12:30:19.164534Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-09-21T12:30:19.171851Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-09-21T12:30:19.171866Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-09-21T12:30:19.172097Z 0 [Note] InnoDB: Waiting for purge to start 2022-09-21T12:30:19.225342Z 0 [Note] InnoDB: 5.7.38 started; log sequence number 2674765 2022-09-21T12:30:19.225814Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool 2022-09-21T12:30:19.226103Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-09-21T12:30:19.228148Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220921 14:30:19 2022-09-21T12:30:19.235372Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-09-21T12:30:19.235384Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-09-21T12:30:19.235391Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. 2022-09-21T12:30:19.235397Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. 2022-09-21T12:30:19.236436Z 0 [Warning] CA certificate ca.pem is self signed. 2022-09-21T12:30:19.236859Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-09-21T12:30:19.237786Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-09-21T12:30:19.237820Z 0 [Note] IPv6 is available. 2022-09-21T12:30:19.237830Z 0 [Note] - '::' resolves to '::'; 2022-09-21T12:30:19.237847Z 0 [Note] Server socket created on IP: '::'. 2022-09-21T12:30:19.238538Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/db/mysql' in the path is accessible to all OS users. Consider choosing a different directory. 2022-09-21T12:30:19.264903Z 0 [Note] Event Scheduler: Loaded 0 events 2022-09-21T12:30:19.265017Z 0 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.7.38' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2022-09-21T12:30:52.6NZ mysqld_safe mysqld restarted 2022-09-21T12:30:53.154957Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-09-21T12:30:53.157851Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.38) starting as process 980 ... 2022-09-21T12:30:53.166608Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2022-09-21T12:30:53.166624Z 0 [Note] InnoDB: Uses event mutexes 2022-09-21T12:30:53.166632Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2022-09-21T12:30:53.166640Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 2022-09-21T12:30:53.167038Z 0 [Note] InnoDB: Number of pools: 1 2022-09-21T12:30:53.167800Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-09-21T12:30:53.169893Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-09-21T12:31:04.6NZ mysqld_safe mysqld from pid file /var/db/mysql/omikron.pid ended Link to comment Share on other sites More sharing options...
Tracer 1 Posted June 30, 2023 Share Posted June 30, 2023 (edited) Hi, what is SECTREE responsible for? What is it for? Edited June 30, 2023 by Tracer Link to comment Share on other sites More sharing options...
Stadi 16 Posted July 12, 2023 Share Posted July 12, 2023 hello, can someone help me why the character doesn't have a weapon in his hand? I did everything accordingly.----> Link to comment Share on other sites More sharing options...
Lemes 0 Posted March 8, 2024 Share Posted March 8, 2024 Pessoal, eu preciso de ajuda. Comprei uma Vps Freebsd, mas não sei como acessar, já tenho o Ip, login e senha, mas não sei como ter acesso para upar meu servidor. vocês podem me ensinar como entrar? a Vps é comprada, no YouTube só mostra como criar uma freebsd, mas eu preciso saber como conectar a uma comprada. desde já agradeço profundamente se alguém puder me dar essa ajuda. abraço. Guys, I need help. I bought a Freebsd Vps, but I don't know how to access it, I already have the IP, login and password, but I don't know how to access it to upload my server. Can you teach me how to enter? the Vps is purchased, YouTube only shows how to create a freebsd, but I need to know how to connect to a purchased one. I would be very grateful in advance if anyone could give me this help. hug. Link to comment Share on other sites More sharing options...
bimax999 0 Posted December 29, 2024 Share Posted December 29, 2024 Hi .. i have a problems with teleport ring i use this serverfile [40250] Reference Serverfile + Client + Src [15 Available Languages] ...have a limit on teleports...i dont know where is it on this serverfile this quest..teleport ring ... i try another quest but don t wont to work .. any quest with teleport... anyone ? sorry for my bad english 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