|
You last visited: Today at 01:26
Advertisement
[Problem]MySQL Fehler - Yasumari Files
Discussion on [Problem]MySQL Fehler - Yasumari Files within the Metin2 Private Server forum part of the Metin2 category.
10/18/2013, 21:42
|
#1
|
elite*gold: 0 
Join Date: Aug 2012
Posts: 406
Received Thanks: 75
|
[Problem]MySQL Fehler - Yasumari Files
Nabend Leute,
folgender Fehler kommt bei den Yasumari Files, wenn man den Server starten möchte:
PHP Code:
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: mt2 db: common
cannot start server while no common sql connected
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsSuccess PLAYER
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
Könnt ihr helfen?
|
|
|
|
10/18/2013, 22:04
|
#2
|
elite*gold: 84
Join Date: May 2013
Posts: 479
Received Thanks: 235
|
ja. du musst den Mysql-User mt2 anpassen
Schau in deinen Configs nach welchen user die brauch und dann richte dir den halt ein
|
|
|
|
|
10/18/2013, 22:13
|
#3
|
elite*gold: 0
Join Date: Aug 2012
Posts: 406
Received Thanks: 75
|
PHP Code:
HOSTNAME: auth
CHANNEL: 1
PORT: 11002
P2P_PORT: 65100
DB_PORT: 15000
DB_ADDR: localhost
TABLE_POSTFIX:
ITEM_ID_RANGE: 000000001 000000002
PASSES_PER_SEC: 25
SAVE_EVENT_SECOND_CYCLE: 180
PING_EVENT_SECOND_CYCLE: 180
AUTH_SERVER: master
PLAYER_SQL: localhost mt2 mt2pw account
COMMON_SQL: localhost mt2 mt2pw common
LOG_SQL: localhost mt2 mt2pw log
LOCALE_SERVICE: GERMANY
adminpage_ip0: 178.63.145.28
adminpage_password: SHOWMETHEMONEY
Ich nehme an, ich muss nun bei PLAYER_SQL und COMMON_SQL was ändern. Müssen da die Datenbank daten hin anstatt das mt2 und mt2pw?
|
|
|
|
|
10/18/2013, 22:40
|
#4
|
elite*gold: 84
Join Date: May 2013
Posts: 479
Received Thanks: 235
|
ja du erstellst einen user:
GRANT ALL PRIVILEGES ON *.* TO 'mt2'@'localhost'
IDENTIFIED BY 'mt2pw' WITH GRANT OPTION;
Also einen user:
Host: localhost
User: mt2
Password: mt2pw <- musste halt hashen
alle rechte alt und es geht!
|
|
|
|
|
10/19/2013, 00:02
|
#5
|
elite*gold: 1000
Join Date: Mar 2009
Posts: 1,408
Received Thanks: 1,007
|
Quote:
|
IDENTIFIED BY 'mt2pw' WITH GRANT OPTION;
|
OMG wer hat dir ins Hirn ************ xD gib NIEMALS einem Acc Grant Rechte, welcher es nicht wirklich zu 100% braucht Oo Alles Andere ist "fahrlässig dumm" (Zitat by Tim66613)
|
|
|
|
|
10/19/2013, 00:32
|
#6
|
elite*gold: 0
Join Date: Jul 2013
Posts: 465
Received Thanks: 264
|
Du kannst mich auch gerne in Skype adden, dort kann ich dir dann auch helfen.
|
|
|
|
|
10/19/2013, 16:18
|
#7
|
elite*gold: 0
Join Date: Aug 2012
Posts: 406
Received Thanks: 75
|
Nun taucht folgendes Problem auf, dass egal ob die Daten richtig sind, er mir sagt das der Accountname oder das Passwort falsch ist, obwohl ich alles zu 100% richtig eingegeben habe.
|
|
|
|
|
10/20/2013, 06:45
|
#8
|
elite*gold: 84
Join Date: May 2013
Posts: 479
Received Thanks: 235
|
Quote:
Originally Posted by Coniesan
OMG wer hat dir ins Hirn ************ xD gib NIEMALS einem Acc Grant Rechte, welcher es nicht wirklich zu 100% braucht Oo Alles Andere ist "fahrlässig dumm" (Zitat by Tim66613)
|
Da muss ich dir Recht geben.
Ich weiß aber nicht zu 100% welche Rechte der locale User haben darf.
b2t: Poste mal deine Syserr von der db.
Ich tippe jetz schon auf Connection Fehler.
|
|
|
|
|
10/20/2013, 11:01
|
#9
|
elite*gold: 0
Join Date: Aug 2012
Posts: 406
Received Thanks: 75
|
Syserr ab gestern:
PHP Code:
SYSERR: Oct 19 10:44:04 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 19 10:44:05 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Oct 19 10:47:04 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 19 10:47:04 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Oct 19 10:47:04 :: socket_bind: bind: Address already in use
SYSERR: Oct 19 10:50:27 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Oct 19 10:50:29 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Oct 19 10:50:31 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Oct 19 10:53:55 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 19 10:53:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Oct 19 10:53:55 :: socket_bind: bind: Address already in use
SYSERR: Oct 19 10:56:09 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct 19 10:58:34 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 19 10:58:34 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Oct 19 13:27:04 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct 19 13:28:30 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 19 13:28:30 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Oct 19 13:29:56 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Oct 19 13:29:58 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Oct 19 13:30:00 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Oct 19 13:30:02 :: Process: FDWATCH: peer null in event: ident 24
SYSERR: Oct 19 13:30:04 :: Process: FDWATCH: peer null in event: ident 25
SYSERR: Oct 19 13:30:06 :: Process: FDWATCH: peer null in event: ident 26
SYSERR: Oct 19 13:30:20 :: Process: FDWATCH: peer null in event: ident 27
SYSERR: Oct 19 13:30:21 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct 19 13:30:34 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 19 13:30:34 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Oct 19 13:48:05 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Oct 19 13:48:07 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Oct 19 13:48:09 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Oct 19 13:48:11 :: Process: FDWATCH: peer null in event: ident 24
SYSERR: Oct 19 13:48:13 :: Process: FDWATCH: peer null in event: ident 25
SYSERR: Oct 19 13:48:15 :: Process: FDWATCH: peer null in event: ident 26
SYSERR: Oct 19 13:48:29 :: Process: FDWATCH: peer null in event: ident 27
SYSERR: Oct 19 13:48:31 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct 19 13:48:47 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 19 13:48:48 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Oct 19 13:52:03 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Oct 19 13:52:05 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Oct 19 13:52:07 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Oct 19 13:52:09 :: Process: FDWATCH: peer null in event: ident 24
SYSERR: Oct 19 13:52:12 :: Process: FDWATCH: peer null in event: ident 25
SYSERR: Oct 19 13:52:14 :: Process: FDWATCH: peer null in event: ident 26
SYSERR: Oct 19 13:52:28 :: Process: FDWATCH: peer null in event: ident 27
SYSERR: Oct 19 13:52:29 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct 19 13:53:04 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 19 13:53:04 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Oct 19 14:05:36 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct 19 14:07:30 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 19 14:07:31 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Oct 19 14:16:39 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Oct 19 14:16:41 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Oct 19 14:16:43 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Oct 19 14:16:45 :: Process: FDWATCH: peer null in event: ident 24
SYSERR: Oct 19 14:16:47 :: Process: FDWATCH: peer null in event: ident 25
SYSERR: Oct 19 14:16:49 :: Process: FDWATCH: peer null in event: ident 26
SYSERR: Oct 19 14:17:03 :: Process: FDWATCH: peer null in event: ident 27
SYSERR: Oct 19 14:17:04 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct 19 14:17:13 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 19 14:17:13 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Oct 20 08:51:51 :: DirectQuery: MySQL connection was reconnected. querying locale set
SYSERR: Oct 20 08:51:51 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Oct 20 08:51:53 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Oct 20 08:51:55 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Oct 20 08:51:57 :: Process: FDWATCH: peer null in event: ident 24
SYSERR: Oct 20 08:51:59 :: Process: FDWATCH: peer null in event: ident 25
SYSERR: Oct 20 08:52:01 :: Process: FDWATCH: peer null in event: ident 26
SYSERR: Oct 20 08:52:15 :: Process: FDWATCH: peer null in event: ident 27
SYSERR: Oct 20 08:52:17 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct 20 08:52:32 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 20 08:53:45 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 20 08:53:45 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Oct 20 08:53:50 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct 20 08:53:51 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Oct 20 08:53:51 :: socket_bind: bind: Address already in use
SYSERR: Oct 20 08:54:06 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 20 08:54:06 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Oct 20 08:54:06 :: socket_bind: bind: Address already in use
|
|
|
|
 |
Similar Threads
|
Daroo Files MySQL Problem
07/09/2013 - Metin2 Private Server - 3 Replies
Ich kann nicht zur Datenbank Connecten bei den Daroo Files habe schon mit und ohne 100 am ende versucht aber geht beides nicht Hilfe bitte was soll ich tun.
|
Openntpd fehler und mysql problem
10/22/2012 - Metin2 Private Server - 0 Replies
Hallo
Woran liegt der fehler auf dem Screenshot?
Und wie kann ich Zeit in einer tabelle loggen per mysql_query?
|
MySQL Fehler bei Daroo Files
09/26/2012 - Metin2 Private Server - 1 Replies
Hey brauche dringend Hilfe...^^
Undzwar wir haben Daroo Files & ein klitze kleines Problem was uns derbe abfuckt...
Mal ein paar Hintergrund informationen
Wir haben unsere HP auf dem Root liegen, soweit kein Problem. Jedoch wenn ich z.B. das Design von Sora & Ownii nehme, dann läd sie schweine lange.
Zum root: Es ist ein Windows Server 2008 sprich wir haben ne Portmap die läuft aber einwandfrei, startet sich gelegentlich mal neu & das ist nicht das Problem, außerdm hält die extrem...
|
Daroo Files, MYSQL Fehler in PuTTY? HÄ?
02/19/2012 - Metin2 Private Server - 2 Replies
Hey Com,
ich habe daroo files drauf und habe sie in
/usr/home/game
Aber, wenn ich es starte erscheint:
Server# cd /usr/home/game
Server# sh start.sh
Wie viele Channels möchtest du starten?
1
Starte DB-Server...
|
HP Problem MySql Fehler
02/22/2011 - Metin2 Private Server - 2 Replies
Closen Pls
|
All times are GMT +1. The time now is 01:28.
|
|
![[Problem]MySQL Fehler - Yasumari Files](https://www.elitepvpers.com/forum/iconimages/metin2-private-server/problem-mysql-fehler-yasumari-files_ltr.gif){kind=small}
