[ PROBLEM ] mysql.sock' (61)

[JonyNawa1ony]

Witam,

krótko i na temat:

po restarcie VPSa wystąpił problem:

failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

Do FTP mogę się połączyć, wyciąg z syserr db:

 

 

SYSERR: Jul 15 19:34:24 :: Start: TABLE_POSTFIX not configured use default

Jul 15 19:34:24 :: connecting to MySQL server (player)

Jul 15 19:34:24 :: CREATING DIRECT_SQL

Jul 15 19:34:24 :: AsyncSQL: locale euckr

Jul 15 19:34:24 :: failed, retrying in 5 seconds

Jul 15 19:34:29 :: CREATING DIRECT_SQL

Jul 15 19:34:29 :: AsyncSQL: locale euckr

Jul 15 19:34:29 :: failed, retrying in 5 seconds

Jul 15 19:34:34 :: CREATING DIRECT_SQL

Jul 15 19:34:34 :: AsyncSQL: locale euckr

Jul 15 19:34:34 :: failed, retrying in 5 seconds

Jul 15 19:34:39 :: CREATING DIRECT_SQL

Jul 15 19:34:39 :: AsyncSQL: locale euckr

Jul 15 19:34:39 :: failed, retrying in 5 seconds

Jul 15 19:34:44 :: CREATING DIRECT_SQL

Jul 15 19:34:44 :: AsyncSQL: locale euckr

Jul 15 19:34:44 :: failed, retrying in 5 seconds

Jul 15 19:34:49 :: CREATING DIRECT_SQL

Jul 15 19:34:49 :: AsyncSQL: locale euckr

Jul 15 19:34:49 :: failed, retrying in 5 seconds

Jul 15 19:34:54 :: connecting to MySQL server (account)

Jul 15 19:34:54 :: CREATING DIRECT_SQL

Jul 15 19:34:54 :: AsyncSQL: locale euckr

Jul 15 19:34:54 :: failed, retrying in 5 seconds

Jul 15 19:34:59 :: CREATING DIRECT_SQL

Jul 15 19:34:59 :: AsyncSQL: locale euckr

Jul 15 19:34:59 :: failed, retrying in 5 seconds

Jul 15 19:35:04 :: CREATING DIRECT_SQL

Jul 15 19:35:04 :: AsyncSQL: locale euckr

Jul 15 19:35:04 :: failed, retrying in 5 seconds

Jul 15 19:35:09 :: CREATING DIRECT_SQL

Jul 15 19:35:09 :: AsyncSQL: locale euckr

Jul 15 19:35:09 :: failed, retrying in 5 seconds

Jul 15 19:35:14 :: CREATING DIRECT_SQL

Jul 15 19:35:14 :: AsyncSQL: locale euckr

Jul 15 19:35:14 :: failed, retrying in 5 seconds

Jul 15 19:35:19 :: CREATING DIRECT_SQL

Jul 15 19:35:19 :: AsyncSQL: locale euckr

Jul 15 19:35:19 :: failed, retrying in 5 seconds

Jul 15 19:35:24 :: connecting to MySQL server (common)

Jul 15 19:35:24 :: CREATING DIRECT_SQL

Jul 15 19:35:24 :: AsyncSQL: locale euckr

Jul 15 19:35:24 :: failed, retrying in 5 seconds

Jul 15 19:35:29 :: CREATING DIRECT_SQL

Jul 15 19:35:29 :: AsyncSQL: locale euckr

Jul 15 19:35:29 :: failed, retrying in 5 seconds

Jul 15 19:35:34 :: CREATING DIRECT_SQL

Jul 15 19:35:34 :: AsyncSQL: locale euckr

Jul 15 19:35:34 :: failed, retrying in 5 seconds

Jul 15 19:35:39 :: CREATING DIRECT_SQL

Jul 15 19:35:39 :: AsyncSQL: locale euckr

Jul 15 19:35:39 :: failed, retrying in 5 seconds

Jul 15 19:35:44 :: CREATING DIRECT_SQL

Jul 15 19:35:44 :: AsyncSQL: locale euckr

Jul 15 19:35:44 :: failed, retrying in 5 seconds

Jul 15 19:35:49 :: CREATING DIRECT_SQL

Jul 15 19:35:49 :: AsyncSQL: locale euckr

Jul 15 19:35:49 :: failed, retrying in 5 seconds

Jul 15 19:35:54 :: connecting to MySQL server (hotbackup)

Jul 15 19:35:54 :: CREATING DIRECT_SQL

Jul 15 19:35:54 :: AsyncSQL: locale euckr

Jul 15 19:35:54 :: failed, retrying in 5 seconds

Jul 15 19:35:59 :: CREATING DIRECT_SQL

Jul 15 19:35:59 :: AsyncSQL: locale euckr

Jul 15 19:35:59 :: failed, retrying in 5 seconds

Jul 15 19:36:04 :: CREATING DIRECT_SQL

Jul 15 19:36:04 :: AsyncSQL: locale euckr

Jul 15 19:36:04 :: failed, retrying in 5 seconds

Jul 15 19:36:09 :: CREATING DIRECT_SQL

Jul 15 19:36:09 :: AsyncSQL: locale euckr

Jul 15 19:36:09 :: failed, retrying in 5 seconds

Jul 15 19:36:14 :: CREATING DIRECT_SQL

Jul 15 19:36:14 :: AsyncSQL: locale euckr

Jul 15 19:36:14 :: failed, retrying in 5 seconds

Jul 15 19:36:19 :: CREATING DIRECT_SQL

Jul 15 19:36:19 :: AsyncSQL: locale euckr

Jul 15 19:36:19 :: failed, retrying in 5 seconds

Jul 15 19:36:24 :: ClientManager initialization..

 

 

Jednak do Bazy danych nie.

Pilnie proszę o pomoc!

[AdminFreeBSD]

Nie działa ci mysql. Pewnie prawa dostępu do plików bazy są złe. Zrób chown -r mysql:mysql /var/db/mysql potem /usr/local/etc/rc.d/mysql-server start jak ci dalej nie wstanie mysql to znaczy ze jest baza uszkodzona musisz ją przywrócić z kopii.

[JonyNawa1ony]

Niestety:

 

 

Za chwilę wgram tą samą bazę, z tego tematu:

http://www.mpcforum.pl/topic/282576-tutserwer-na-plikach-2010/

Jak temu zapobiedz?

Może masz jakąś czystą bazę danych.

 

Dodatkowo udało mi się takie coś utworzyć:

Próbowałem również cd /usr/ports/databases/mysql51-server/ a potem make deinstall clean, ale wyskakuje: make: command not found.

[AdminFreeBSD]

Sorki literówka z mojej strony chown -R mysql:mysql /var/db/mysql Jeśli masz komunikaty że nieznajduje ci make to albo masz coś pokombinowane z path lub uwaliłeś system - skasowałeś ważne pliki systemowe. Daj screen z wynikiem:

whereis make

i

whereis su

[JonyNawa1ony]

Reinstalacja całego systemu -- z każdym restartem było jeszcze gorzej.

 

//Proszę o zamknięcie tematu.