- Mesaj
- 442
- Çözümler
- 42
- Beğeni
- 224
- Puan
- 869
- Ticaret Puanı
- 0
local üzerinde mysql 5.5 kullanıyorum ancak vds alıp oyunu kuracağım zaman artık 5.5 kurulumuna izin verilmiyor ve ben de 5.6 kurulumu yapıp veritabanını import ettim ve upgrade yaptım. Bu işlem sonrası oyuna start verdiğim zaman aşağıdaki syserr alıyorum ve mysql açılmıyor.
daha önce karşılaşıp çözebilen var mı?
/var/db/mysql içerisindeki freebsd.err dosyası içeriği şu şekilde;
Kod:
SYSERR: Oct 11 01:36:12.957818 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Oct 11 01:36:12.957825 :: ChildLoop: AsyncSQL: retrying
daha önce karşılaşıp çözebilen var mı?
/var/db/mysql içerisindeki freebsd.err dosyası içeriği şu şekilde;
Kod:
2022-10-11 16:36:24 1677 [Note] Plugin 'FEDERATED' is disabled.
2022-10-11 16:36:24 1677 [Note] InnoDB: Using atomics to ref count buffer pool pages
2022-10-11 16:36:24 1677 [Note] InnoDB: The InnoDB memory heap is disabled
2022-10-11 16:36:24 1677 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-10-11 16:36:24 1677 [Note] InnoDB: Memory barrier is not used
2022-10-11 16:36:24 1677 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-10-11 16:36:24 1677 [Note] InnoDB: Using CPU crc32 instructions
2022-10-11 16:36:24 1677 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2022-10-11 16:36:24 1677 [Note] InnoDB: Completed initialization of buffer pool
2022-10-11 16:36:24 1677 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2022-10-11 16:36:24 1677 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2022-10-11 16:36:24 1677 [Note] InnoDB: Database physically writes the file full: wait...
2022-10-11 16:36:24 1677 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2022-10-11 16:36:24 1677 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2022-10-11 16:36:25 1677 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2022-10-11 16:36:25 1677 [Warning] InnoDB: New log files created, LSN=45781
2022-10-11 16:36:25 1677 [Note] InnoDB: Doublewrite buffer not found: creating new
2022-10-11 16:36:25 1677 [Note] InnoDB: Doublewrite buffer created
2022-10-11 16:36:25 1677 [Note] InnoDB: 128 rollback segment(s) are active.
2022-10-11 16:36:25 1677 [Warning] InnoDB: Creating foreign key constraint system tables.
2022-10-11 16:36:25 1677 [Note] InnoDB: Foreign key constraint system tables created
2022-10-11 16:36:25 1677 [Note] InnoDB: Creating tablespace and datafile system tables.
2022-10-11 16:36:25 1677 [Note] InnoDB: Tablespace and datafile system tables created.
2022-10-11 16:36:25 1677 [Note] InnoDB: Waiting for purge to start
2022-10-11 16:36:25 1677 [Note] InnoDB: 5.6.51 started; log sequence number 0
2022-10-11 16:36:25 1677 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2022-10-11 16:36:25 1677 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2022-10-11 16:36:25 1677 [Note] Server hostname (bind-address): '*'; port: 3306
2022-10-11 16:36:25 1677 [Note] IPv6 is available.
2022-10-11 16:36:25 1677 [Note] - '::' resolves to '::';
2022-10-11 16:36:25 1677 [Note] Server socket created on IP: '::'.
2022-10-11 16:36:25 1677 [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-10-11 16:36:25 1677 [Note] Event Scheduler: Loaded 0 events
2022-10-11 16:36:25 1677 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2022-10-11 16:36:34 1677 [Warning] IP address 'xxx' could not be resolved: Name does not resolve