|
You last visited: Today at 12:03
Advertisement
Metin2 Putty Mysql
Discussion on Metin2 Putty Mysql within the Metin2 Private Server forum part of the Metin2 category.
03/09/2014, 21:06
|
#1
|
elite*gold: 0
Join Date: Apr 2009
Posts: 237
Received Thanks: 52
|
Metin2 Putty Mysql
Hallo,
PHP Code:
Starte die Datenbank .. Real Server Log Offmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) failed, retrying in 5 seconds Starte Channel 1 Kern1 .. PUBLIC_IP: zensiert interface em0 HOSTNAME: channel1 mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) cannot open direct sql connection to host: localhost user: m2user db: common cannot start server while no common sql connected mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) failed, retrying in 5 seconds Starte Channel 1 Kern2 .. PUBLIC_IP: zensiert interface em0 HOSTNAME: kern2 mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) cannot open direct sql connection to host: localhost user: m2user db: common cannot start server while no common sql connected Starte Channel 1 Kern3 .. PUBLIC_IP: zensiert interface em0 HOSTNAME: kern3 mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) cannot open direct sql connection to host: localhost user: m2user db: common cannot start server while no common sql connected mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) failed, retrying in 5 seconds Starte Channel 1 Kern4 .. PUBLIC_IP: zensiert interface em0 HOSTNAME: kern4 mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) cannot open direct sql connection to host: localhost user: m2user db: common cannot start server while no common sql connected mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) failed, retrying in 5 seconds Starte Channel 2 Kern1 .. PUBLIC_IP: zensiert interface em0 HOSTNAME: channel2 mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) cannot open direct sql connection to host: localhost user: m2user db: common cannot start server while no common sql connected ^Cmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) failed, retrying in 5 seconds root@zensiert:/usr/home/game # mysql_real_connect: Can't connect to local MySQL server through socket '/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 socket '/tmp/mysql.sock' (2) failed, retrying in 5 secondsmysql_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 socket '/tmp/mysql.sock' (2) failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) failed, retrying in 5 seconds root@zensiert:/usr/home/game # mysql_real_connect: Can't connect to local MySQL server through socket '/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 socket '/tmp/mysql.sock' (2) failed, retrying in 5 secondsmysql_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 socket '/tmp/mysql.sock' (2) failed, retrying in 5 seconds root@szensiert:/usr/home/game # 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 socket '/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 socket '/tmp/mysql.sock' (2) failed, retrying in 5 secondsmysql_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 socket '/tmp/mysql.sock' (2) failed, retrying in 5 seconds
Das kommt wenn ich den Server Starte Mysql und alles installiert.
Danke in vorraus.
MfG
|
|
|
03/10/2014, 03:25
|
#2
|
elite*gold: 0
Join Date: Jul 2013
Posts: 365
Received Thanks: 668
|
Edit: Mach es wie Coniesan geschrieben hat.
@Coniesan: Chill mal ne Runde. Habs kp iwann gestern Nacht besoffen geschrieben. Man komm mal runter und entspann dich.
.ByTe
|
|
|
03/10/2014, 11:14
|
#3
|
elite*gold: 1000
Join Date: Mar 2009
Posts: 1,407
Received Thanks: 1,005
|
WTF sry .ByTe, aber wenn man keine Ahnung hat, sollte man auch nix sagen..!
Auf gut deutsch:
Dein MySQL Server läuft nicht ODER in der mysql.sock steht (dankt Entpacken von irgend welchen MySQL Files während der SQL Server läuft) eine falsche pid!
Fix:
Code:
killall -9 mysqld
service mysql-server start
Sollte dies den Fehler NICHT beheben, guckste am Besten mal nach, was in der MySQL errorfile steht:
Code:
/var/db/mysql/hostname.err
den "hostname" weißt du entweder, oder du gibst einfach "hostname" in Putty ein!
#Edit: im Falle, dass du in die err file guckst, kannst sie ja mal hier rein posten
|
|
|
03/10/2014, 18:42
|
#4
|
elite*gold: 0
Join Date: Apr 2009
Posts: 237
Received Thanks: 52
|
Quote:
Originally Posted by Coniesan
WTF sry .ByTe, aber wenn man keine Ahnung hat, sollte man auch nix sagen..!
Auf gut deutsch:
Dein MySQL Server läuft nicht ODER in der mysql.sock steht (dankt Entpacken von irgend welchen MySQL Files während der SQL Server läuft) eine falsche pid!
Fix:
Code:
killall -9 mysqld
service mysql-server start
Sollte dies den Fehler NICHT beheben, guckste am Besten mal nach, was in der MySQL errorfile steht:
Code:
/var/db/mysql/hostname.err
den "hostname" weißt du entweder, oder du gibst einfach "hostname" in Putty ein!
#Edit: im Falle, dass du in die err file guckst, kannst sie ja mal hier rein posten
|
Der fehler ist immer noch da das ist die mysql.err
PHP Code:
140310 17:42:32 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql /usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 140310 17:42:32 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 140310 17:42:32 InnoDB: The InnoDB memory heap is disabled 140310 17:42:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140310 17:42:32 InnoDB: Compressed tables use zlib 1.2.7 /usr/local/libexec/mysqld: Can't create/write to file '/tmp/ibgxF1j0' (Errcode: 2) 140310 17:42:32 InnoDB: Error: unable to create temporary file; errno: 2 140310 17:42:32 [ERROR] Plugin 'InnoDB' init function returned error. 140310 17:42:32 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140310 17:42:32 [ERROR] Unknown/unsupported storage engine: InnoDB 140310 17:42:32 [ERROR] Aborting
140310 17:42:32 [Note] /usr/local/libexec/mysqld: Shutdown complete
140310 17:42:32 mysqld_safe mysqld from pid file /var/db/mysql/name.pid ended
|
|
|
03/10/2014, 23:02
|
#5
|
elite*gold: 5
Join Date: Feb 2014
Posts: 359
Received Thanks: 75
|
777 Rechte = Win.
|
|
|
03/10/2014, 23:13
|
#6
|
elite*gold: 1000
Join Date: Mar 2009
Posts: 1,407
Received Thanks: 1,005
|
mach mal:
Code:
rm -rf /var/db/mysql/mysql
service mysql-server start
danach musste im Grunde nur deine SQL User wieder neu einstellen, und es SOLLTE laufen!
@[nX]ℓυzιƒєя:
1. WAS soll 777 Rechte bekommen?
2. 777 = Evil! gib nichts und niemandem 777 Rechte, der es nicht wirklich nötig hat!
|
|
|
03/11/2014, 13:21
|
#7
|
elite*gold: 0
Join Date: Apr 2009
Posts: 237
Received Thanks: 52
|
Quote:
Originally Posted by Coniesan
mach mal:
Code:
rm -rf /var/db/mysql/mysql
service mysql-server start
danach musste im Grunde nur deine SQL User wieder neu einstellen, und es SOLLTE laufen!
@[nX]ℓυzιƒєя:
1. WAS soll 777 Rechte bekommen?
2. 777 = Evil! gib nichts und niemandem 777 Rechte, der es nicht wirklich nötig hat!
|
PHP Code:
Real Server Log Off/usr/home/game/share/libdb_notxt.so: unsupported file layout log_file_delete_old: SYSTEM_CMD: rm -rf ./log/20140308 20140308:20140308 20140308:20140308 mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) failed, retrying in 5 seconds Starte Channel 1 Kern1 .. PUBLIC_IP: ip interface em0 HOSTNAME: channel1 mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) cannot open direct sql connection to host: localhost user: m2user db: common cannot start server while no common sql connected mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) failed, retrying in 5 seconds Starte Channel 1 Kern2 .. PUBLIC_IP: ip interface em0 HOSTNAME: kern2 mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) cannot open direct sql connection to host: localhost user: m2user db: common cannot start server while no common sql connected Starte Channel 1 Kern3 .. PUBLIC_IP: ip interface em0 HOSTNAME: kern3 mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) cannot open direct sql connection to host: localhost user: m2user db: common cannot start server while no common sql connected mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) failed, retrying in 5 seconds Starte Channel 1 Kern4 .. PUBLIC_IP: ip interface em0 HOSTNAME: kern4 mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) cannot open direct sql connection to host: localhost user: m2user db: common cannot start server while no common sql connected mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) failed, retrying in 5 seconds Starte Channel 2 Kern1 .. PUBLIC_IP: ipinterface em0 HOSTNAME: channel2 mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) cannot open direct sql connection to host: localhost user: m2user db: common cannot start server while no common sql connected ^Cmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) failed, retrying in 5 seconds
nope geht nicht
|
|
|
03/11/2014, 13:24
|
#8
|
elite*gold: 1000
Join Date: Mar 2009
Posts: 1,407
Received Thanks: 1,005
|
und was steht diesmal in der error File?
|
|
|
03/11/2014, 13:36
|
#9
|
elite*gold: 0
Join Date: Apr 2009
Posts: 237
Received Thanks: 52
|
Quote:
Originally Posted by Coniesan
und was steht diesmal in der error File?
|
Die ist leer >_> aber wenn ich mit navicat connecten will kommt Lost connection to mysql server at "reading initial communication packet ", system error :0
|
|
|
03/11/2014, 14:42
|
#10
|
elite*gold: 1000
Join Date: Mar 2009
Posts: 1,407
Received Thanks: 1,005
|
Naja der Fehler kommt entweder, wenn deine Firewall die Connection blockt, oder wenn SSH als Verbindungsoption: "NEIN" sagt
|
|
|
Similar Threads
|
Fehler bei putty mit mysql
05/14/2013 - Metin2 Private Server - 20 Replies
Es kommt immer "cant connect to local mysql server through socket -/tmp/mysql.sock'
Kann mir jemand helfen? ich kriege das nicht geschissen, regt mich alles auf..
€:
Bei schritt 5 kommt : ERROR 1033 (HYOOO) : Incorrect information in file: #./mysql/user.frm'
Was bedeutete das?
|
Putty Mysql installieren
05/08/2011 - Metin2 Private Server - 0 Replies
Hey Leute
ich wollte mal fragen ob mir einer helfen kann über putty mysql zu installieren
auf einen root brauche hilfe vielen dank
Addet mich in skype pls : turonnn
oder schreibt mich hier in
|
All times are GMT +2. The time now is 12:03.
|
|