MySQL-Fehler bei ./start.sh

[YoriNeko]

So, an all euch "allwissende" Elitepvpler:
Hier ist für die, die sich für ach so schlau halten die Chance,
sich zu beweisen.

Wir hatten gestern 2mal Folgenden Fehler, nach Ausführen der
start.sh:

 Spoiler

fgg2# ./start.sh
Real Server
Log Offlog_file_delete_old: stat: No such file or directory
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mys ql.sock' (2)
failed, retrying in 5 secondsPUBLIC_IP: 208.79.81.210 interface re0
HOSTNAME: first
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mys ql.sock' (2)
cannot open direct sql connection to host: localhost user: mt2 db: common
cannot start server while no common sql connected
PUBLIC_IP: 208.79.81.210 interface re0
HOSTNAME: game99
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mys ql.sock' (61)
cannot open direct sql connection to host: localhost user: mt2 db: common
cannot start server while no common sql connected
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mys ql.sock' (61)
failed, retrying in 5 secondsPUBLIC_IP: 208.79.81.210 interface re0
HOSTNAME: game100
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mys ql.sock' (2)
cannot open direct sql connection to host: localhost user: mt2 db: common
cannot start server while no common sql connected
PUBLIC_IP: 208.79.81.210 interface re0
HOSTNAME: auth
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mys ql.sock' (2)
cannot open direct sql connection to host: localhost user: mt2 db: common
cannot start server while no common sql connected
fgg2# mysql_real_connect: Can't connect to local MySQL server through socket '/t mp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsSuccess PLAYER
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (61)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsSuccess ACCOUNT
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsSuccess COMMON
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (61)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through s ocket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsSuccess HOTBACKUP

Beim 1. mal gings nach 'ner weile wieder weg, und ich konnte normal
starten. Jetzt aber is bisschen Zeitdruck, da 'ne Menge leute
suchten wollen ^_^.

Die Geschichte is folgende:

 Spoiler

Als ich den Server nachm 1. mal wieder hochgefahren
bekam, wurde es durch irgendjemand Mysteriöses
immer Hell/Dunkel, ich hab mir den command_log
angeschaut, aber keine Einträge von /x bzw. /x 1.
danach hat jemand in Rufchat geschrieben:

"Ihr Wunder euch warums immer Hell und Dunkel wird?
ICH BIN MARCEL DAVIS UND HABE EUREN SERVER GEHACKT,
WEIL ICH IHN HASSE!! NEUER LEITER FÜR KUNDEN-
UNZUFRIEDENHEIT!!"

Danach hab ich ihm geantwortet:

"Hey du WannaBe Hacker mit deinem api-tool,
halt die Fresse sonst ergehts dir ganz schnell extrem mies".

Danach war der Server down, weil die P2P-Ports belegt waren.
Ich hab neue geschrieben, dann schien alles zu funktionieren.

Allerdings heute Morgen wieder der Selbe fehler...,
Der Server fuhr nichtmehr hoch, weil:

MySQL Error: too Many Connections.

Dann hab ich den Api-Tool Fix eingebaut
(Fehlerfrei, ohne Zweifel),

hab gerebootet, dass es den Mongo aus meinem MySQL-
Server kickt..,

Und jetzt kam der Fehler, welcher Oben genannt wurde..

[Templer12345]

geb mal das ein
cd /usr/ports/databases/mysql50-server
make deinstall abwarten
make install

[Slank<3]

Ich glaub du hast den localen user "mt2" nicht angelegt

[.Resistance]

mysql -p
SET GLOBAL max_connections=10000;
quit

Sollte klappen

[YoriNeko]

MySQL wurde neuinstalliert, selber fehler.

Dann:
fgg2# mysql -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

und:

fgg2# SET GLOBAL max_connections=10000
SET: Command not found.

[alg0r!thm]

Die Fehlermeldung die du oben hast bedeutet eigentlich nur das der MySQL Server entweder aus ist oder nicht erreichbar.
Man sieht es ya hier.

localhost user: mt2 db: common

Er versucht unter dem Hostnamen "localhost" mit dem Benutzer "mt2" die Datenbank auf dem MySQL Server "common" anzusteuern bzw. verbinden, aber das gelingt ihm nicht.
Wieso? Weil er aus ist.
Versuch ihn mal zu starten.

/usr/local/etc/rc.d/mysql-server start

Wenn es dann immer noch nicht gelingt sag uns bescheid und wir schauen weiter.


So far,
Daniiel'

[NitroHonig]

bei mir kommt dieser fehler :
/libexec/ld-elf.so.1: Shared object "libncurses.so.8" not found, required by "csh"
/usr/local/etc/rc.d/mysql-server: WARNING: failed to start mysql
wenn ich mysql starten möchte