Pliki terenzo problem z hasłami

[buleczka232xd]

Gdy włączam serwer w start.log występuje taki błąd

PUBLIC_IP: ***.***.***.** interface em0
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
HOSTNAME: channel41

Jak to naprawić?Tworzyłem usera mysql mt2 tylko jakie jest hasło?Czy mógłby mi ktoś wskazać w którym miejscu je edytowac ?

HOSTNAME: channel41
CHANNEL: 4
PORT: 13003
P2P_PORT: 14003
DB_PORT: 15000
DB_ADDR: localhost
MAP_ALLOW: 1 21 41 3 23 43 4 24 44 5 25 45 108 109 215 216 217 218
TABLE_POSTFIX: 
PASSES_PER_SEC: 25
SAVE_EVENT_SECOND_CYCLE: 180
PING_EVENT_SECOND_CYCLE: 180
PLAYER_SQL: localhost mt2 mt2!@# player
COMMON_SQL: localhost mt2 mt2!@# common
LOG_SQL: localhost mt2 mt2!@# log
SERVER_KEY: fIFjs5S47kdhsMUxsgjSrisTfGRB79PN4qi/D4U6yCX1LYUqBDQOxleqtAxp+cFteti2gp6fnnQ9Td2QFUWjpSuwLX/XDfCTgkCwoxYzb0P20YgIraXKDrN5FHbKYUvOl0Y69NcHUpGo+xU+Tbs2O6AEJYLrqW0BW3ggL6JeVUM*
MALL_URL: localhost
ADMINPAGE_IP: localhost
ADMINPAGE_IP1: localhost
ADMINPAGE_IP2: localhost
ADMINPAGE_IP3: localhost
ADMINPAGE_PASSWORD: @)BV<gvfdzRK_)3b
VIEW_RANGE: 20000
CHECK_MULTIHACK: 0
MAX_LEVEL: 105
TEST_SERVER: 0
XTRAP_ENABLE: 0

Osoba która mi pomoże dostanie w chuy lajków

[harnaś]

tu masz hasło

 

PLAYER_SQL: localhost mt2 mt2!@# player
COMMON_SQL: localhost mt2 mt2!@# common
LOG_SQL: localhost mt2 mt2!@# log

 

 

a dokładnie to mt2!@#  a jak nie to bez kratki

[buleczka232xd]

Dobra dzięki,tamten błąd weliminowany lajk a co znaczy ten?

SYSERR: Feb  6 22:09:36 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Feb  6 22:09:43 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Feb  6 22:09:46 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Feb  6 22:09:49 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Feb  6 22:09:52 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Feb  6 22:09:55 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Feb  6 22:09:58 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Feb  6 22:10:01 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Feb  6 22:10:04 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Feb  6 22:10:07 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Feb  6 22:10:10 :: socket_connect: HOST localhost:15000, could not connect.

[harnaś]

Jeżeli stawiasz serwer na hamachi, to to olej. Wina parametrów sprzętu. A jeżeli nie możesz się przez to do gry zalogować, to sprawdz czy aby na pewno w dobrej kolejnosci wszystko odpalasz.

[buleczka232xd]

Stawiam na vpsie,chwila już sprawdzam czy da rade zalogowac

[buleczka232xd]

DB się nie odpala jakieś rady na to?

[harnaś]

DB się nie odpala jakieś rady na to?

 

No skoro DB sie nie odpala, to coś musiałem majstrować przy plikach.

[buleczka232xd]

Właśnie o to chodzi że nic :c

Wgrałem pliki edytowałem te configi dodałem user i tyle.

[harnaś]

Właśnie o to chodzi że nic :c

Wgrałem pliki edytowałem te configi dodałem user i tyle.

 

edytowałeś configi.

 

a dokładnie?

a na standardowym Ci działało?

[buleczka232xd]

Configi ch11,ch12,ch99 hasła tam edytowałem i tyle.

[Terenzo.]

może nie wrzuciłeś libów? http://www.mpcforum.pl/topic/898096-tut-instalacja-libw/

 

jeżeli wgrałeś to podaj start.log i syserr z db

[buleczka232xd]

Z start.log wynika że złe hasło

eal Server
Log Offmysql_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 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)
   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 ACCOUNT
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 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 COMMON
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 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 HOTBACKUP

Syser:

SYSERR: Feb  6 22:27:45 :: pid_init: 
Start of pid: 4912

SYSERR: Feb  6 22:27:45 :: Start: TABLE_POSTFIX not configured use default

Syslog:

Feb  6 22:29:16 :: AsyncSQL: closing mysql connection.
Feb  6 22:29:16 ::    failed, retrying in 5 seconds
Feb  6 22:29:21 :: CREATING DIRECT_SQL
Feb  6 22:29:21 :: AsyncSQL: locale euckr
Feb  6 22:29:21 :: AsyncSQL: closing mysql connection.
Feb  6 22:29:21 ::    failed, retrying in 5 seconds
Feb  6 22:29:26 :: CREATING DIRECT_SQL
Feb  6 22:29:26 :: AsyncSQL: locale euckr
Feb  6 22:29:26 :: AsyncSQL: closing mysql connection.
Feb  6 22:29:26 ::    failed, retrying in 5 seconds
Feb  6 22:29:31 :: CREATING DIRECT_SQL
Feb  6 22:29:31 :: AsyncSQL: locale euckr
Feb  6 22:29:31 :: AsyncSQL: closing mysql connection.
Feb  6 22:29:31 ::    failed, retrying in 5 seconds
Feb  6 22:29:36 :: CREATING DIRECT_SQL
Feb  6 22:29:36 :: AsyncSQL: locale euckr
Feb  6 22:29:36 :: AsyncSQL: closing mysql connection.
Feb  6 22:29:36 ::    failed, retrying in 5 seconds
Feb  6 22:29:41 :: CREATING DIRECT_SQL
Feb  6 22:29:41 :: AsyncSQL: locale euckr
Feb  6 22:29:41 :: AsyncSQL: closing mysql connection.
Feb  6 22:29:41 ::    failed, retrying in 5 seconds
Feb  6 22:29:46 :: ClientManager initialization.. 

[Terenzo.]

mi to wygląda na błędne hasło dla usera 'mt2', wg configu powinno być 'mt2!@#' (*1DA96A411E1563FF227A913C4E3161211DD564F4)

[buleczka232xd]

Ok ok dzięki za pomoc już prawie wszystko działa(tylko jak próbuje utworzyć nową postać to czarne tło wywala,ale to jutro zrobię)