Nie odpala DB

[Ymek19]

Cześć wgrałem na vps pliki rykox z tego tematu http://www.mpcforum.pl/topic/998343-pliki-v2-by-rykox-na-serwer-dedykowany/

jak odpalam serwer nie odpala baza danych , auth,game odpala przez co jest komunikat Connection refused

 Starting Database ..
Real Server
Log Offlog_file_delete_old: stat: No such file or directory
AsyncSQL: connected to localhost (reconnect 1)
Success PLAYER
AsyncSQL: connected to localhost (reconnect 1)
Success ACCOUNT
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Success COMMON
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Success HOTBACKUP
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)

 Starting Auth ..
PUBLIC_IP: 185.25.148.73 interface re0
HOSTNAME: auth
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)
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
AUTH_SERVER: I am the master
log_file_delete_old: stat: No such file or directory
connect: Connection refused
MasterAuth 6

 Starting CH 1 ..
PUBLIC_IP: 185.25.148.73 interface re0
HOSTNAME: channel1
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)
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
MAP ALLOW 1
MAP ALLOW 2
MAP ALLOW 3
MAP ALLOW 4
MAP ALLOW 5
MAP ALLOW 6
MAP ALLOW 7
MAP ALLOW 8
MAP ALLOW 9
MAP ALLOW 10
MAP ALLOW 11
MAP ALLOW 12
MAP ALLOW 13
MAP ALLOW 14
MAP ALLOW 15
MAP ALLOW 16
MAP ALLOW 17
MAP ALLOW 18
MAP ALLOW 19
MAP ALLOW 20
MAP ALLOW 21
MAP ALLOW 22
MAP ALLOW 23
MAP ALLOW 24
MAP ALLOW 25
MAP ALLOW 26
MAP ALLOW 27
MAP ALLOW 28
MAP ALLOW 29
MAP ALLOW 30
MAP ALLOW 41
MAP ALLOW 43
PLAYER_MAX_LEVEL: 250LocaleService locale/germany/locale_string.txt
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
connect: Connection refused
connect: Connection refused

 Starting CH99 ..
PUBLIC_IP: 185.25.148.73 interface re0
HOSTNAME: channel99
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)
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
MAP ALLOW 31
MAP ALLOW 32
MAP ALLOW 33
MAP ALLOW 34
MAP ALLOW 35
MAP ALLOW 36
MAP ALLOW 37
MAP ALLOW 38
MAP ALLOW 39
MAP ALLOW 40
MAP ALLOW 42
MAP ALLOW 66
MAP ALLOW 81
MAP ALLOW 110
MAP ALLOW 111
MAP ALLOW 113
MAP ALLOW 114
MAP ALLOW 118
MAP ALLOW 119
MAP ALLOW 120
MAP ALLOW 121
MAP ALLOW 122
MAP ALLOW 123
MAP ALLOW 124
MAP ALLOW 125
MAP ALLOW 126
MAP ALLOW 127
MAP ALLOW 128
MAP ALLOW 181
MAP ALLOW 182
MAP ALLOW 183
PLAYER_MAX_LEVEL: 250LocaleService locale/germany/locale_string.txt
connect: Connection refused
connect: Connection refused
connect: Connection refused

wie ktoś jak to rozwiązać , conf mam dobrze skonfigurowany 

 

jak to naprawić ? 

SYSERR: Jun  4 13:51:26 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jun  4 13:51:26 :: InitializeItemTable: query error: SELECT vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag+0, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 FROM item_proto ORDER BY vnum
SYSERR: Jun  4 13:51:26 :: InitializeTables: InitializeItemTable FAILED
SYSERR: Jun  4 13:51:26 :: Initialize: Table Initialize FAILED

[Noresta]

Brak inicjacji z item_proto. Posiadasz w ogóle tą tabele? Jeśli tak sprawdź czy nie masz jej popsutej.

[Ymek19]

zauważyłem że tabelki sie psują cały czas , nawet jak naprawiam

[Noresta]

zauważyłem że tabelki sie psują cały czas , nawet jak naprawiam

 

Wgraj tabele, które Ci się psują na wyłączonym serwerze po czym zrestartuj maszynę i spróbuj włączyć serwer.

[mlipski09]

SYSERR: Jun  4 13:51:26 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jun  4 13:51:26 :: InitializeItemTable: query error: SELECT vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag+0, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 FROM item_proto ORDER BY vnum
SYSERR: Jun  4 13:51:26 :: InitializeTables: InitializeItemTable FAILED
SYSERR: Jun  4 13:51:26 :: Initialize: Table Initialize FAILED

uszkodzone tabelki

spróbuj dać prawym na item proto i daj Napraw jeśli to nie pomoze to musisz wgrać od nowa tabelke

 

[Ymek19]

@mlipski09

robiłem już tak i nadal tabelki się psują

[Gość]

@mlipski09

robiłem już tak i nadal tabelki się psują

Skopiuj tabele item_proto usuń tą co skopiowałeś a kopi zmień nazwe na item_proto, jak inne też się psują to je wymień.