Register for your free account! | Forgot your password?

You last visited: Today at 16:38

  • Please register to post and access all features, it's quick, easy and FREE!

 

Metin2 MySQL Problem

Reply
 
Old   #1
 
elite*gold: 5
Join Date: Feb 2014
Posts: 359
Received Thanks: 75
Exclamation Metin2 MySQL Problem

Heho

erstens folgendes Problem :

Code:
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/mysql.sock' (2)
zweitens, wenn ich MySQL starten möchte kommt erst "MySQL ist already running?" und nach 2-3 Sekunden kommt "failed to connection to MySQL not found" MySQL war allerdings installiert.

Quote:
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 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 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 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 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 secondsSuccess HOTBACKUP
FreeBSD 8.3 64Bit ...



[nX]ℓυzιƒєя is offline  
Old   #2

 
elite*gold: 100
Join Date: Sep 2009
Posts: 8,094
Received Thanks: 2,729
Wie sehen deine Config dateien aus ? Poste die mal hier... er kann nicht zum MySQL Server Verbinden...


.Marcel' is offline  
Old   #3
 
elite*gold: 5
Join Date: Feb 2014
Posts: 359
Received Thanks: 75
Die von den Core's oder die von MySQL ? Sorry, frage lieber bevor ich etwas falsches Poste ^^

Core Config's falls du die des MySQL's meinst korrigiere ich es gerne :
Attached Files
File Type: rar Configdateien.rar (3.0 KB, 49 views)
[nX]ℓυzιƒєя is offline  
Old   #4
 
elite*gold: 5
Join Date: Feb 2014
Posts: 359
Received Thanks: 75
Push, selbes Problem besteht weiterhin^^


[nX]ℓυzιƒєя is offline  
Old   #5
 
elite*gold: 5
Join Date: Feb 2014
Posts: 359
Received Thanks: 75
Problem besteht immernoch,

Code:
PUBLIC_IP: 93.186.***.** interface re0
HOSTNAME: game99
mysql_real_connect: Access denied for user 'm2user'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: m2user db: common
cannot start server while no common sql connected
mysql_real_connect: Access denied for user 'm2user'@'localhost' (using password: YES)
Was ich bereits versucht habe

-Libs alle draufgespielt
-Home Ordner neu entpackt
-MySQL neu installiert
-Alle Ordner mit 777 versehn
-User angelegt
[nX]ℓυzιƒєя is offline  
Old   #6

 
elite*gold: 100
Join Date: Sep 2009
Posts: 8,094
Received Thanks: 2,729
Quote:
Originally Posted by [nX]ℓυzιƒєя View Post
Problem besteht immernoch,

Code:
PUBLIC_IP: 93.186.***.** interface re0
HOSTNAME: game99
mysql_real_connect: Access denied for user 'm2user'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: m2user db: common
cannot start server while no common sql connected
mysql_real_connect: Access denied for user 'm2user'@'localhost' (using password: YES)
Was ich bereits versucht habe

-Libs alle draufgespielt
-Home Ordner neu entpackt
-MySQL neu installiert
-Alle Ordner mit 777 versehn
-User angelegt
Steht doch ganz klar da die Fehlermeldung: Der User mt2 hat keine Berechtigungen. mt2 User anlegen -> Rechte anpassen -> Done.
.Marcel' is offline  
Old   #7
 
elite*gold: 5
Join Date: Feb 2014
Posts: 359
Received Thanks: 75
Ich wäre dir sehr dankbar über deinen Beitrag wenn ich das nicht schon getan hätte, steht ja oben bereits... hier nochmal ein Bild dazu :



bin mit meinem Latein langsam echt am ende, versuche es nun schon 4 Tage..
[nX]ℓυzιƒєя is offline  
Old   #8
 
elite*gold: 0
Join Date: Jun 2010
Posts: 42
Received Thanks: 2
sieht nach einem core fehler aus
moldhenr is offline  
Old   #9
 
elite*gold: 1000
Join Date: Mar 2009
Posts: 1,405
Received Thanks: 997
Das hat nix mit den Cores zu tun! Es ist ein einfacher MySQL Error, der besagt:
1. User existiert nicht
2. Wenn User existiert, dann ist das PW falsch!
3. Wenn User existiert, und PW richtig ist, hat er keine Berechtigung!

User und passwort findest idr. in deinen CONFIG files!
Coniesan is offline  
Old   #10
 
elite*gold: 5
Join Date: Feb 2014
Posts: 359
Received Thanks: 75
Das Problem ist gelöst aber nun ist ein neues da... wenn ich mich einloggen möchte mit den Daten, Server ist gestartet :

Quote:
[*] Module "Costume system" loaded.[*] Module "Hooks" loaded.
Init hooks count: 1
UseItem hooks count: 1

PUBLIC_IP: 93.186.196.12 interface re0
HOSTNAME: channel1_core5
AsyncSQL: connected to localhost (reconnect 1)
CommonSQL connected
Setting Locale "germany" (Path: locale/germany)
Setting DB to locale latin1
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
PlayerSQL connected
LogSQL connected
SKILL_POWER_BY_LEVEL 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
AsyncSQL: connected to localhost (reconnect 1)
SKILL_POWER_BY_JOB 0 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 1 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 2 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 3 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 4 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 5 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 6 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 7 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
MAP ALLOW 184
MAP ALLOW 185
MAP ALLOW 186
MAP ALLOW 187
MAP ALLOW 188
MAP ALLOW 189
MAP ALLOW 190
PLAYER_MAX_LEVEL: 105LocaleService locale/germany/locale_string.txt
socket_tcp_bind: tcp_socket: Address already in use
Channel 1 Core 5 wurde gestartet.



Channel Gestartet
[nX]Luzifer#
wird nur angezeigt; "Du wirst mit dem Server verbunden"

in Mysql usw ist alles korrekt..
[nX]ℓυzιƒєя is offline  
Old   #11
 
elite*gold: 1000
Join Date: Mar 2009
Posts: 1,405
Received Thanks: 997
Stimmen die Ports mit den CONFIG's überein?

Edit: serverinfo.py und intrologin.py (falls vorhanden) bearbeitet?
Coniesan is offline  
Old   #12
 
elite*gold: 5
Join Date: Feb 2014
Posts: 359
Received Thanks: 75
serverinfo, ja - intrologin, nein..

Intrologin überarbeiten ?


[nX]ℓυzιƒєя is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
metin2 mysql problem
Hallo, habe das Problem, das wenn ich den server starte mit sh start.sh die Fehlermeldung: failed, retrying in 5 secondsmysql_real_connect: ...
5 Replies - Metin2 PServer - Discussions / Questions
Metin2 Mysql problem
Hallo com, Welche dateien muss ich der mysql "entziehen" damit es kein passwort mehr hat? Brauche hilfe.
0 Replies - Metin2 PServer - Discussions / Questions
Metin2 Mysql Problem
Hi ich habe das problem das mein Server immer auf den Mysql User Name RootZ zugreifen wegen einer alten db, wie kann ich das wieder auf root ändern?...
12 Replies - Metin2 PServer - Discussions / Questions



All times are GMT +1. The time now is 16:38.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.