Skocz do zawartości
  • 👋 Witaj na MPCForum!

    Przeglądasz forum jako gość, co oznacza, że wiele świetnych funkcji jest jeszcze przed Tobą! 😎

    • Pełny dostęp do działów i ukrytych treści
    • Możliwość pisania i odpowiadania w tematach
    • System prywatnych wiadomości
    • Zbieranie reputacji i rozwijanie swojego profilu
    • Członkostwo w jednej z największych społeczności graczy

    👉 Dołączenie zajmie Ci mniej niż minutę – a zyskasz znacznie więcej!

    Zarejestruj się teraz

Pliki isaric Problem z mysql


Rekomendowane odpowiedzi

Opublikowano

mam problem taki że  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES) 

 

zmieniłem hasła w confingach ch1/ch2/ch3/ch4/auth/game   / nawet zmieniłem hasło w navi na nowe i nadal to samo pomoże ktoś ? 

 

 

 

 

jeszcze mam taki problem ze naprawiłem tabelki i ciągle pisze connect connection refused-tabelki są ok  jak to naprawić ?

 

daje +

zmieniłem porty ale to nic nie dało

 

 

syseer z auth/ch1/ch2/ch3/ch4/game jest taki sam ja ten nie może  sie połączyć :(

 

 


SYSERR: Apr 23 17:58:27 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:30 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:33 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:36 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:39 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:42 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:45 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:48 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:51 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:54 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:57 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:00 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:03 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:06 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:09 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:12 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:15 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:18 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:21 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:24 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:27 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:30 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:33 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:36 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:39 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:42 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:45 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:48 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:51 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:54 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:57 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:00 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:03 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:06 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:09 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:12 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:15 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:18 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:21 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:24 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:27 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:30 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:33 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:36 :: socket_connect: HOST localhost:15000, could not connect.
 

 

 

                                                                                                                                                     kot-i-pilnik-do-paznokci.gif

 

                                                                                            Milordzie poczęstuj papierosem...

Opublikowano

Zmień jeszcze w folderze db w pliku conf.txt i powinno działać.

Opublikowano

mam problem taki że  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES) 

 

zmieniłem hasła w confingach ch1/ch2/ch3/ch4/auth/game   / nawet zmieniłem hasło w navi na nowe i nadal to samo pomoże ktoś ? 

 

 

 

 

jeszcze mam taki problem ze naprawiłem tabelki i ciągle pisze connect connection refused-tabelki są ok  jak to naprawić ?

 

daje +

zmieniłem porty ale to nic nie dało

 

 

syseer z auth/ch1/ch2/ch3/ch4/game jest taki sam ja ten nie może  sie połączyć :(

 

 

SYSERR: Apr 23 17:58:27 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:30 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:33 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:36 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:39 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:42 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:45 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:48 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:51 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:54 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:58:57 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:00 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:03 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:06 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:09 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:12 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:15 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:18 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:21 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:24 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:27 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:30 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:33 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:36 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:39 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:42 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:45 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:48 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:51 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:54 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 17:59:57 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:00 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:03 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:06 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:09 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:12 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:15 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:18 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:21 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:24 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:27 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:30 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:33 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 23 18:00:36 :: socket_connect: HOST localhost:15000, could not connect.
 

 

 

Daj config z db i kanału i skrypt do odpalania sf :)

Opublikowano

Daj config z db i kanału i skrypt do odpalania sf :)

 

 

@1361622928-U485574.pngNertiaMT2 to ?

 

 

chodzi o ten start.th 

 

 

 

#!/bin/sh
 
echo -e "\033[31m Ile channeli chcesz uruchomic? Max 4. \033[0m"
 
read select
case $select in 
4*)
echo -e "\033[31m Odpalanie db ..\033[0m"
cd ./db/
./db &
sleep 2
echo -e "\033[31m \n Odpalanie auth ..\033[0m"
cd /usr/home/mt2/auth
./auth &
sleep 2
echo -e "\033[31m \n Odpalanie ch1 Duengony..\033[0m"
cd /usr/home/mt2/channel1/duengony
env LD_32_PRELOAD=/usr/home/mt2/share/lib/kostiumy.so ./game &
sleep 2
echo -e "\033[31m \n Odpalanie ch1 Miasta ..\033[0m"
cd /usr/home/mt2/channel1/miasta
env LD_32_PRELOAD=/usr/home/mt2/share/lib/kostiumy.so ./game &
sleep 2
echo -e "\033[31m \n Odpalanie ch2 Duengony..\033[0m"
cd /usr/home/mt2/channel2/duengony
env LD_32_PRELOAD=/usr/home/mt2/share/lib/kostiumy.so ./game &
sleep 2
echo -e "\033[31m \n Odpalanie ch2 Miasta ..\033[0m"
cd /usr/home/mt2/channel2/miasta
env LD_32_PRELOAD=/usr/home/mt2/share/lib/kostiumy.so ./game &
sleep 2
echo -e "\033[31m \n Odpalanie ch3 Duengony..\033[0m"
cd /usr/home/mt2/channel3/duengony
env LD_32_PRELOAD=/usr/home/mt2/share/lib/kostiumy.so ./game &
sleep 2
echo -e "\033[31m \n Odpalanie ch3 Miasta ..\033[0m"
cd /usr/home/mt2/channel3/miasta
env LD_32_PRELOAD=/usr/home/mt2/share/lib/kostiumy.so ./game &
sleep 2
echo -e "\033[31m \n Odpalanie ch4 Duengony..\033[0m"
cd /usr/home/mt2/channel4/duengony
env LD_32_PRELOAD=/usr/home/mt2/share/lib/kostiumy.so ./game &
sleep 2
echo -e "\033[31m \n Odpalanie ch41 Miasta ..\033[0m"
cd /usr/home/mt2/channel4/miasta
env LD_32_PRELOAD=/usr/home/mt2/share/lib/kostiumy.so ./game &
sleep 2
echo -e "\033[31m \n Odpalanie game ..\033[0m"
cd /usr/home/mt2/game
env LD_32_PRELOAD=/usr/home/mt2/share/lib/kostiumy.so ./game &
sleep 2
clear
;;
esac

 
conf.txt
 

WELCOME_MSG = "Mysql odpalone"
 
SQL_ACCOUNT = "localhost account mt2 mt2!@# 0"
SQL_PLAYER = "localhost player mt2 mt2!@# 0"
SQL_COMMON = "localhost common mt2 mt2!@# 0"
SQL_HOTBACKUP = "localhost hotbackup mt2 mt2!@# 0"
 
TABLE_POSTFIX = ""
 
BIND_PORT               = 35000
DB_SLEEP_MSEC           = 10
CLIENT_HEART_FPS        = 10
HASH_PLAYER_LIFE_SEC    = 600
BACKUP_LIMIT_SEC        = 3600
PLAYER_ID_START = 100
PLAYER_DELETE_LEVEL_LIMIT = 100
PLAYER_DELETE_CHECK_SIMPLE = 1
 
ITEM_ID_RANGE = 2000000000 2100000000
 
MIN_LENGTH_OF_SOCIAL_ID = 6
 
SIMPLE_SOCIALID = 1
LIMIT_CONNECT: 1000

 
ch1_1
 

HOSTNAME: channel1_1
CHANNEL: 1
PORT: 13000
P2P_PORT: 14050
DB_PORT: 15050
DB_ADDR: localhost
MAP_ALLOW: 4 5 24 25 44 45 46 47 61 62 63 64 65 66 67 68 69 70 71 72 73 80 82 83 104 206 84 85
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
LOCALE_SERVICE: poland
#TEST_SERVER: 1
#NO_PK: 1
MALL_URL: localhost
adminpage_ip0: localhost
adminpage_ip1: localhost
adminpage_ip2: localhost
adminpage_ip3: localhost
adminpage_password: 00000
VIEW_RANGE: 20000
CHECK_MULTIHACK: 1
MAX_LEVEL: 120
 

 
ch1
 

HOSTNAME: channel1
CHANNEL: 1
PORT: 13000
P2P_PORT: 14000
DB_PORT: 15000
DB_ADDR: localhost
MAP_ALLOW: 1 3 12 21 23 41 43 162 84 85
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
LOCALE_SERVICE: poland
#TEST_SERVER: 1
#NO_PK: 1
MALL_URL: localhost
adminpage_ip0: localhost
adminpage_ip1: localhost
adminpage_ip2: localhost
adminpage_ip3: localhost
adminpage_password: 000000
VIEW_RANGE: 20000
CHECK_MULTIHACK: 1
MAX_LEVEL: 120
USER_LIMIT: 2000
 
 

 
 
@edit; znikło to z mysql password ale ciągle mam ten connect Connection refused - tabelki naprawione w navi i freebsd jak to naprawić inaczej 

 

 

dałem do naprawienia tabelki z mysql w navi i mam cos takiego to może być to ?

 

 

 

19063660929118026649.png

 

 

 

 

                                                                                                                                                     kot-i-pilnik-do-paznokci.gif

 

                                                                                            Milordzie poczęstuj papierosem...

Zarchiwizowany

Ten temat przebywa obecnie w archiwum. Dodawanie nowych odpowiedzi zostało zablokowane.

×
×
  • Dodaj nową pozycję...