Prosíme přihlašte se nebo zaregistrujte.

Přihlašte se svým uživatelským jménem a heslem.
Vaše pomoc je stále potřeba!

Autor Téma: Pokus o hack?  (Přečteno 2334 krát)

mr.p

  • Návštěvník
  • Příspěvků: 89
Pokus o hack?
« kdy: 22 Prosince 2014, 16:54:16 »
Zdravim,

před chvílí mi spadlo mysql a v error logu se objevila nějaká IP adresa z číny. Jen nevím jestli informace v logu dokážou říct více o tom co se stalo. Můžete mi prosím říct více?

PHP se pak nemohl připojit do db a vyhazoval tuto hlášku:
Kód: [Vybrat]
PDOException: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
Mysql.log
Kód: [Vybrat]
141222 13:12:04 [Warning] IP address '222.186.56.15' could not be resolved: Name or service not known
141222 16:22:49 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
141222 16:22:49 [Note] Plugin 'FEDERATED' is disabled.
141222 16:22:49 InnoDB: The InnoDB memory heap is disabled
141222 16:22:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141222 16:22:49 InnoDB: Compressed tables use zlib 1.2.3.4
141222 16:22:49 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
141222 16:22:49 InnoDB: Completed initialization of buffer pool
141222 16:22:49 InnoDB: Fatal error: cannot allocate memory for the buffer pool
141222 16:22:49 [ERROR] Plugin 'InnoDB' init function returned error.
141222 16:22:49 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
141222 16:22:49 [ERROR] Unknown/unsupported storage engine: InnoDB
141222 16:22:49 [ERROR] Aborting

141222 16:22:49 [Note] /usr/sbin/mysqld: Shutdown complete

141222 16:22:50 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
141222 16:22:50 [Note] Plugin 'FEDERATED' is disabled.
141222 16:22:50 InnoDB: The InnoDB memory heap is disabled
141222 16:22:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141222 16:22:50 InnoDB: Compressed tables use zlib 1.2.3.4
141222 16:22:50 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
141222 16:22:50 InnoDB: Completed initialization of buffer pool
141222 16:22:50 InnoDB: Fatal error: cannot allocate memory for the buffer pool
141222 16:22:50 [ERROR] Plugin 'InnoDB' init function returned error.
141222 16:22:50 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
141222 16:22:50 [ERROR] Unknown/unsupported storage engine: InnoDB
141222 16:22:50 [ERROR] Aborting

141222 16:22:50 [Note] /usr/sbin/mysqld: Shutdown complete

141222 16:22:51 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
141222 16:22:51 [Note] Plugin 'FEDERATED' is disabled.
141222 16:22:51 InnoDB: The InnoDB memory heap is disabled
141222 16:22:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141222 16:22:51 InnoDB: Compressed tables use zlib 1.2.3.4
141222 16:22:51 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
141222 16:22:51 InnoDB: Completed initialization of buffer pool
141222 16:22:51 InnoDB: Fatal error: cannot allocate memory for the buffer pool
141222 16:22:51 [ERROR] Plugin 'InnoDB' init function returned error.
141222 16:22:51 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
141222 16:22:51 [ERROR] Unknown/unsupported storage engine: InnoDB
141222 16:22:51 [ERROR] Aborting

141222 16:22:51 [Note] /usr/sbin/mysqld: Shutdown complete

141222 16:33:19 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
141222 16:33:19 [Note] Plugin 'FEDERATED' is disabled.
141222 16:33:19 InnoDB: The InnoDB memory heap is disabled
141222 16:33:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141222 16:33:19 InnoDB: Compressed tables use zlib 1.2.3.4
141222 16:33:19 InnoDB: Initializing buffer pool, size = 128.0M
141222 16:33:19 InnoDB: Completed initialization of buffer pool
141222 16:33:19 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
141222 16:33:19  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
141222 16:33:21  InnoDB: Waiting for the background threads to start
141222 16:33:22 InnoDB: 5.5.40 started; log sequence number 488762029
141222 16:33:22 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141222 16:33:22 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141222 16:33:22 [Note] Server socket created on IP: '0.0.0.0'.
141222 16:33:22 [Note] Event Scheduler: Loaded 0 events
141222 16:33:22 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.40-0ubuntu0.12.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)

Díky zabližší info

Armus69

  • Aktivní člen
  • *
  • Příspěvků: 297
    • http://www.netlancers.cz
Re:Pokus o hack?
« Odpověď #1 kdy: 22 Prosince 2014, 17:46:39 »
Citace
141222 16:22:49 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12

tipnu si nějaký problém s alokací paměti ? co říká top a prostor na disku ? Nějaké úpravy mysql.ini ?


EDIT GdH: Zrušil jsem ty špatně zadané prasárny s fontem.
« Poslední změna: 22 Prosince 2014, 18:59:05 od GdH »
jabber:  Armus69@jabber.cz

mr.p

  • Návštěvník
  • Příspěvků: 89
Re:Pokus o hack?
« Odpověď #2 kdy: 23 Prosince 2014, 01:38:07 »
No byla to chyba, kterou vyřešil restart mysql. Jen mě zajímá jak k tomu došlo, že mělo mysql najednou problém s alokací paměti. Může to nějak souviset s faktem, že se jedná o VPS?

 

Provoz zaštiťuje spolek OpenAlt.