Serwer VPS, błąd łączenia z serwerem...

Janu · 11 Października 2014

Witam, postawiłem swój własny serwer na vpsie. Wszystko fajnie się odpala i powinno działać ale kiedy odpalam klienta pisze mi bład podczas łaczenia sie z serwerem. Do bazy mogę się zalogować, root w kliencie zmieniony itp. Powiem jeszcze ze wcześniej robiłem serwer identycznie i wszystko działało. Nie mam pojęcia co jest nie tak bo nie wyświetla się żaden błąd, Wszystko teoretycznie gra.

tak to wygląda w putty:

Ile channeli chcesz uruchomic? Max 4.
1
Odpalanie db ..
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)
AsyncSQL: connected to localhost (reconnect 1)
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)
socket: Address already in use

Odpalanie auth ..
PUBLIC_IP: 176.122.226.27 interface em0
HOSTNAME: auth
AsyncSQL: connected to localhost (reconnect 1)
CommonSQL connected
Setting Locale "poland" (Path: locale/poland)
Setting DB to locale latin2
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
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
AsyncSQL: connected to localhost (reconnect 1)
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
AUTH_SERVER: I am the master
log_file_delete_old: stat: No such file or directory
socket_tcp_bind: tcp_socket: Address already in use

Odpalanie ch1 ..
PUBLIC_IP: 176.122.226.27 interface em0
HOSTNAME: channel1
AsyncSQL: connected to localhost (reconnect 1)
CommonSQL connected
Setting Locale "poland" (Path: locale/poland)
Setting DB to locale latin2
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
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
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
MAP ALLOW 1
MAP ALLOW 3
MAP ALLOW 4
MAP ALLOW 5
MAP ALLOW 10
MAP ALLOW 11
MAP ALLOW 12
MAP ALLOW 13
MAP ALLOW 14
MAP ALLOW 15
MAP ALLOW 21
MAP ALLOW 23
MAP ALLOW 24
MAP ALLOW 25
MAP ALLOW 41
MAP ALLOW 43
MAP ALLOW 44
MAP ALLOW 45
MAP ALLOW 61
MAP ALLOW 63
MAP ALLOW 64
MAP ALLOW 65
MAP ALLOW 66
MAP ALLOW 67
MAP ALLOW 68
MAP ALLOW 69
MAP ALLOW 70
MAP ALLOW 71
MAP ALLOW 72
MAP ALLOW 73
MAP ALLOW 87
MAP ALLOW 88
MAP ALLOW 89
MAP ALLOW 193
MAP ALLOW 208
MAP ALLOW 209
PLAYER_MAX_LEVEL: 250LocaleService locale/poland/locale_string.txt
log_file_delete_old: stat: No such file or directory
socket_tcp_bind: tcp_socket: Address already in use

Odpalanie game ..
PUBLIC_IP: 176.122.226.27 interface em0
HOSTNAME: channel99
AsyncSQL: connected to localhost (reconnect 1)
CommonSQL connected
Setting Locale "poland" (Path: locale/poland)
Setting DB to locale latin2
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
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
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
MAP ALLOW 5
MAP ALLOW 9
MAP ALLOW 73
MAP ALLOW 81
MAP ALLOW 88
MAP ALLOW 89
MAP ALLOW 100
MAP ALLOW 103
MAP ALLOW 105
MAP ALLOW 110
MAP ALLOW 111
MAP ALLOW 112
MAP ALLOW 113
MAP ALLOW 181
MAP ALLOW 182
MAP ALLOW 183
MAP ALLOW 184
MAP ALLOW 185
MAP ALLOW 186
MAP ALLOW 187
MAP ALLOW 188
MAP ALLOW 189
MAP ALLOW 190
MAP ALLOW 191
MAP ALLOW 192
MAP ALLOW 193
MAP ALLOW 194
MAP ALLOW 200
MAP ALLOW 208
MAP ALLOW 209
MAP ALLOW 210
PLAYER_MAX_LEVEL: 250LocaleService locale/poland/locale_string.txt
log_file_delete_old: stat: No such file or directory
socket_tcp_bind: tcp_socket: Address already in use

Ups... · 11 Października 2014

W syserr db, ch, auth brak błędów?

Pokaż ss z komendy ps.

Janu · 11 Października 2014

syserr z auth

SYSERR: Oct 11 19:10:43 :: socket_bind: bind: Address already in use

ch1

SYSERR: Oct 11 19:09:53 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:09:55 :: SpawnMob: SpawnMob: no mob data for vnum 20382
SYSERR: Oct 11 19:09:55 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:10:39 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:10:39 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:10:39 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:10:40 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:10:42 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:10:44 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:10:45 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:10:45 :: socket_bind: bind: Address already in use
SYSERR: Oct 11 19:10:47 :: SpawnMob: SpawnMob: no mob data for vnum 10103
SYSERR: Oct 11 19:10:47 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:10:50 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:10:51 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:10:52 :: SpawnMob: SpawnMob: no mob data for vnum 10101
SYSERR: Oct 11 19:10:53 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:10:55 :: SpawnMob: SpawnMob: no mob data for vnum 20382
SYSERR: Oct 11 19:10:55 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:11:39 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:11:39 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:11:39 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:11:40 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:11:42 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:11:44 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:11:45 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:11:47 :: SpawnMob: SpawnMob: no mob data for vnum 10103
SYSERR: Oct 11 19:11:47 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:11:50 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:11:51 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:11:52 :: SpawnMob: SpawnMob: no mob data for vnum 10101
SYSERR: Oct 11 19:11:53 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:11:55 :: SpawnMob: SpawnMob: no mob data for vnum 20382
SYSERR: Oct 11 19:11:55 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:12:39 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:12:39 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:12:39 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:12:40 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:12:42 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:12:44 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:12:45 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:12:47 :: SpawnMob: SpawnMob: no mob data for vnum 10103
SYSERR: Oct 11 19:12:47 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:12:50 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:12:51 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:12:52 :: SpawnMob: SpawnMob: no mob data for vnum 10101
SYSERR: Oct 11 19:12:53 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:12:55 :: SpawnMob: SpawnMob: no mob data for vnum 20382
SYSERR: Oct 11 19:12:55 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:13:39 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:13:39 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:13:39 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:13:40 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:13:42 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:13:44 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:13:45 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:13:47 :: SpawnMob: SpawnMob: no mob data for vnum 10103
SYSERR: Oct 11 19:13:47 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:13:50 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:13:51 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:13:52 :: SpawnMob: SpawnMob: no mob data for vnum 10101
SYSERR: Oct 11 19:13:53 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:13:55 :: SpawnMob: SpawnMob: no mob data for vnum 20382
SYSERR: Oct 11 19:13:55 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:14:39 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:14:39 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 11 19:14:39 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:14:40 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 11 19:14:42 :: SpawnMob: SpawnMob: no mob data for vnum 20374

db

SYSERR: Oct 11 19:10:41 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 11 19:10:41 :: 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 11 19:10:41 :: socket_bind: bind: Address already in use

game

SYSERR: Oct 11 19:10:47 :: socket_bind: bind: Address already in use

ss z komendy ps

MrDevarion · 11 Października 2014

Sprawdź pong game -- binka, porty w root i CONFIG czy są takie same.

Ups... · 11 Października 2014

Procesy działają, serwer wywala ci przez resp mobów których prawdopodobnie nie masz (id w syserr)

Poker Face. · 11 Października 2014

Procesy działają, serwer wywala ci przez resp mobów których prawdopodobnie nie masz (id w syserr)

lol wiesz co ty mowisz ?? nie wywala mu serwera bo serwer dziala a to co mu nasypalo nie ma nic do znaczenia bo nie moze mobow zrespic sprawdz dokladnie porty w serverinfo oraz czy dobrze adres wpisales poza tym co ktos up pisal wina pongu odpada bo gdby byl zly pong to mialby ciagle laczenie z serverem pozdro

Ups... · 11 Października 2014

lol wiesz co ty mowisz ?? nie wywala mu serwera bo serwer dziala a to co mu nasypalo nie ma nic do znaczenia bo nie moze mobow zrespic sprawdz dokladnie porty w serverinfo oraz czy dobrze adres wpisales poza tym co ktos up pisal wina pongu odpada bo gdby byl zly pong to mialby ciagle laczenie z serverem pozdro

Ja wiem co mówię, zasadnicza rzeczą jest to iż na game 34k nie ma pongu, więc zastanów się co mówisz. A resp mobów może spokojnie wywalić serwer...

Poza tym działa mu proces nie serwer.

@top

Nie działa ci proces ch1 właśnie przez ten resp.

Janu · 11 Października 2014

Wszystko jest sprawdzone i jest ok a mimo to dalej nie działa. Pojawił mi sie w syserr game i ch1 dodatkowy wpis:

SYSERR: Oct 12 00:29:04 :: socket_connect: HOST ip serwa:14002, could not connect.

MrDevarion · 11 Października 2014

zmień bind_port w db na 15000 w auth i db nie ma żadnych sysser tylko game to co podałeś?

Ups... · 12 Października 2014

Czekaj ale od kiedy to mysql używa portu 14002? Zmień w configu sql port na 14000.

Janu · 12 Października 2014

Sprawdzałem wszystko i nie działa dalej. Wcześniej miałem wszystko identycznie na poprzednim vps i działało.Tak to wygląda po właczeniu ch1:

Ile channeli chcesz uruchomic? Max 4.
1
Odpalanie db ..
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)
AsyncSQL: connected to localhost (reconnect 1)
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)

Odpalanie auth ..
PUBLIC_IP: 176.(moje ip).11 interface em0
HOSTNAME: auth
AsyncSQL: connected to localhost (reconnect 1)
CommonSQL connected
Setting Locale "poland" (Path: locale/poland)
Setting DB to locale latin2
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
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
AsyncSQL: connected to localhost (reconnect 1)
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
AUTH_SERVER: I am the master
log_file_delete_old: stat: No such file or directory
socket_tcp_bind: tcp_socket: Address already in use
socket: Address already in use

Odpalanie ch1 ..
PUBLIC_IP: 176.(moje ip).11 interface em0
HOSTNAME: channel1
AsyncSQL: connected to localhost (reconnect 1)
CommonSQL connected
Setting Locale "poland" (Path: locale/poland)
Setting DB to locale latin2
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
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 1
MAP ALLOW 3
MAP ALLOW 4
MAP ALLOW 5
MAP ALLOW 10
MAP ALLOW 11
MAP ALLOW 12
MAP ALLOW 13
MAP ALLOW 14
MAP ALLOW 15
MAP ALLOW 21
MAP ALLOW 23
MAP ALLOW 24
MAP ALLOW 25
MAP ALLOW 41
MAP ALLOW 43
MAP ALLOW 44
MAP ALLOW 45
MAP ALLOW 61
MAP ALLOW 63
MAP ALLOW 64
MAP ALLOW 65
MAP ALLOW 66
MAP ALLOW 67
MAP ALLOW 68
MAP ALLOW 69
MAP ALLOW 70
MAP ALLOW 71
MAP ALLOW 72
MAP ALLOW 73
MAP ALLOW 87
MAP ALLOW 88
MAP ALLOW 89
MAP ALLOW 193
MAP ALLOW 208
MAP ALLOW 209
PLAYER_MAX_LEVEL: 250LocaleService locale/poland/locale_string.txt
log_file_delete_old: stat: No such file or directory
socket_tcp_bind: tcp_socket: Address already in use

Odpalanie game ..
PUBLIC_IP: 176.(moje ip).11 interface em0
HOSTNAME: channel99
AsyncSQL: connected to localhost (reconnect 1)
CommonSQL connected
Setting Locale "poland" (Path: locale/poland)
Setting DB to locale latin2
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
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 5
MAP ALLOW 9
MAP ALLOW 73
MAP ALLOW 81
MAP ALLOW 88
MAP ALLOW 89
MAP ALLOW 100
MAP ALLOW 103
MAP ALLOW 105
MAP ALLOW 110
MAP ALLOW 111
MAP ALLOW 112
MAP ALLOW 113
MAP ALLOW 181
MAP ALLOW 182
MAP ALLOW 183
MAP ALLOW 184
MAP ALLOW 185
MAP ALLOW 186
MAP ALLOW 187
MAP ALLOW 188
MAP ALLOW 189
MAP ALLOW 190
MAP ALLOW 191
MAP ALLOW 192
MAP ALLOW 193
MAP ALLOW 194
MAP ALLOW 200
MAP ALLOW 208
MAP ALLOW 209
MAP ALLOW 210
PLAYER_MAX_LEVEL: 250LocaleService locale/poland/locale_string.txt
log_file_delete_old: stat: No such file or directory
socket_tcp_bind: tcp_socket: Address already in use
root@vps26768:/usr/home/mt2 #

Ups... · 12 Października 2014

Spróbuj edytować configi localhost na ip serwera mt2 na root i mt2!@!(jakoś tak) na hasło do mysql. Jeżeli nie ruszy pokaz syserr ch.

Janu · 12 Października 2014

Spróbuj edytować configi localhost na ip serwera mt2 na root i mt2!@!(jakoś tak) na hasło do mysql. Jeżeli nie ruszy pokaz syserr ch.

Zrobiłem tak i teraz syserr wygląda tak:

ch1

SYSERR: Oct 12 13:14:18 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct 12 13:16:48 :: LoadGroup: CTextFileLoader::LoadGroup : must have a value (filename: locale/poland/mob_drop_item.txt line: 4556 key: 24)
game

SYSERR: Oct 12 13:14:18 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct 12 13:16:48 :: LoadGroup: CTextFileLoader::LoadGroup : must have a value (filename: locale/poland/mob_drop_item.txt line: 4556 key: 24)

db

SYSERR: Oct 12 13:14:04 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 1317)
SYSERR: Oct 12 13:14:10 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Oct 12 13:14:10 :: ChildLoop: AsyncSQL: retrying
SYSERR: Oct 12 13:14:14 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Oct 12 13:14:14 :: ChildLoop: AsyncSQL: retrying
SYSERR: Oct 12 13:14:14 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Oct 12 13:14:14 :: ChildLoop: AsyncSQL: retrying
SYSERR: Oct 12 13:14:18 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct 12 13:16:30 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 12 13:16: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 12 13:16:42 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='176.122.226.27')
SYSERR: Oct 12 13:16:42 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='176.122.226.27')

auth

SYSERR: Oct 12 13:14:18 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

Coś mi się chyba nie łączy z bazą. Problem się pojawił od momentu kiedy musiałem zacząć stosować ten tut: http://www.mpcforum.pl/topic/1290718-poprawna-instalacja-mysql-bez-nowych-bledow/#entry11022130

Ups... · 12 Października 2014

Syserr ch1 wskazuje na drop itemów prawdopodobnie linia 4556 (coś jest w niej źle).

Natomiast syserr db wywala ci tak jakby źle zainstalowane sql, jakiej komendy użyłeś do instalacji?

Janu · 12 Października 2014

Syserr ch1 wskazuje na drop itemów prawdopodobnie linia 4556 (coś jest w niej źle).

Natomiast syserr db wywala ci tak jakby źle zainstalowane sql, jakiej komendy użyłeś do instalacji?

Instalowałem serwer według tego tuta: http://www.mpcforum.pl/topic/458444-serwer-na-dedyku-sf2011-freebsd-74-32-bity/

Plus tego bo od jakiegos czasu pojawił się problem przy instalcji mysql: http://www.mpcforum.pl/topic/1290718-poprawna-instalacja-mysql-bez-nowych-bledow/#entry11022130

Alkoholic · 12 Października 2014

mob_drop_item.txt line: 4556 key: 24

zjebałeś TAB albo coś w ten deseń, popraw.

Ups... · 12 Października 2014

Dam ci inny poradnik tylko powiedz mi swoją wersję freebsd.

Janu · 12 Października 2014

mob_drop_item.txt line: 4556 key: 24
zjebałeś TAB albo coś w ten deseń, popraw.

Wszystko jest dobrze, nawet jeżeli jest jakiś bład to nie ma wpływu na odpalanie serwera...

Dam ci inny poradnik tylko powiedz mi swoją wersję freebsd.

FreeBSD 9.2 32 bit

Alkoholic · 12 Października 2014

Wszystko jest dobrze, nawet jeżeli jest jakiś bład to nie ma wpływu na odpalanie serwera...

FreeBSD 9.2 32 bit

jest dobrze z tym, ale drop jest wyłączony. (jak juz oczywiscie uda Ci sie wejsc )

Ups... · 12 Października 2014

Wszystko jest dobrze, nawet jeżeli jest jakiś bład to nie ma wpływu na odpalanie serwera...

FreeBSD 9.2 32 bit

Drop to najczęstszy crash który wywala serwer, a ludzie z nastawieniem "to nie ma wpływu na serwer" najczęściej nie dają sobie z nim rady.

Łap:

Instalacja MySQL

Po zainstalowaniu się portów wpisujemy (każdą linijkę zatwierdzamy enterem)

cd /usr/ports/databases/

cd mysql55-server

make WITH_XCHARSET=all install

po chwili (5-10min) pojawi się komunikat

Options for MySQL-Server 5.5.X

używamy kombinacji "Strzałka w Prawo, Strzałka w Lewo, Enter"

po około 30min pojawi się następny komunikat

Options for MySQL-Client 5.5.X

używamy kombinacji "Strzałka w Prawo, Strzałka w Lewo, Enter"

Czekamy aż zainstaluje się MySQL.. (około 30min-1h)

po instalacji wpisujemy w Putty

ee /etc/rc.conf

zjeżdżamy na sam dół (strzałkami) robimy nową linie enterem i wklejamy tam

mysql_enable="YES"

po wklejeniu wychodzimy z edytora wciskając po kolei na klawiaturze

ESCAPE -> A -> A

po wyjściu z edytora restartujemy serwer

shutdown -r now

Janu · 12 Października 2014

ok spróbujemy z tym, pod wieczór dam znać czy zadziałało.

Nie działa, wgrałem inną baze mysql i to samo z tym że mamy jeszcze coś takiego w syserr auth:

SYSERR: Oct 12 22:08:16 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'time' at row 1 (query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'auth', 1) errno: 1264)

tidu · 12 Października 2014

jaka baza jakie game z jakich plików

wyłącz serwer usun syserr i syslog z auth ch1 db

i wklej mi je tu + config z auth

Janu · 12 Października 2014

Pliki terenzo

Baze nie pamiętam z ka miałem ale możliwe że stąd: http://www.mpcforum.pl/topic/458444-serwer-na-dedyku-sf2011-freebsd-74-32-bity/

syserr

ch1

SYSERR: Oct 12 22:58:12 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:58:15 :: SpawnMob: SpawnMob: no mob data for vnum 20382
SYSERR: Oct 12 22:58:15 :: SpawnMob: SpawnMob: no mob data for vnum 10101
SYSERR: Oct 12 22:58:16 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:58:17 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:58:17 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:58:17 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:58:18 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:58:20 :: SpawnMob: SpawnMob: no mob data for vnum 10103
SYSERR: Oct 12 22:58:20 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:58:21 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'time' at row 1 (query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'channel1', 1) errno: 1264)
SYSERR: Oct 12 22:58:21 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:58:21 :: socket_bind: bind: Address already in use
SYSERR: Oct 12 22:58:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:58:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:58:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:58:28 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:59:12 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:59:15 :: SpawnMob: SpawnMob: no mob data for vnum 20382
SYSERR: Oct 12 22:59:15 :: SpawnMob: SpawnMob: no mob data for vnum 10101
SYSERR: Oct 12 22:59:16 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:59:17 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:59:17 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:59:17 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:59:18 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:59:20 :: SpawnMob: SpawnMob: no mob data for vnum 10103
SYSERR: Oct 12 22:59:20 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:59:21 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:59:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:59:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:59:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:59:28 :: SpawnMob: SpawnMob: no mob data for vnum 20373

game

SYSERR: Oct 12 22:58:24 :: socket_bind: bind: Address already in use
SYSERR: Oct 12 22:58:24 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'time' at row 1 (query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'channel99', 99) errno: 1264)

auth

SYSERR: Oct 12 22:58:20 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'time' at row 1 (query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'auth', 1) errno: 1264)
SYSERR: Oct 12 22:58:21 :: ChildLoop: AsyncSQL: query failed: Table 'account.string' doesn't exist (query: SELECT name, text FROM string errno: 1146)
SYSERR: Oct 12 22:58:21 :: socket_bind: bind: Address already in use

db

puste

syslog

ch1

SYSERR: Oct 12 22:58:12 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:58:15 :: SpawnMob: SpawnMob: no mob data for vnum 20382
SYSERR: Oct 12 22:58:15 :: SpawnMob: SpawnMob: no mob data for vnum 10101
SYSERR: Oct 12 22:58:16 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:58:17 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:58:17 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:58:17 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:58:18 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:58:20 :: SpawnMob: SpawnMob: no mob data for vnum 10103
SYSERR: Oct 12 22:58:20 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:58:21 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'time' at row 1 (query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'channel1', 1) errno: 1264)
SYSERR: Oct 12 22:58:21 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:58:21 :: socket_bind: bind: Address already in use
SYSERR: Oct 12 22:58:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:58:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:58:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:58:28 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:59:12 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:59:15 :: SpawnMob: SpawnMob: no mob data for vnum 20382
SYSERR: Oct 12 22:59:15 :: SpawnMob: SpawnMob: no mob data for vnum 10101
SYSERR: Oct 12 22:59:16 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:59:17 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:59:17 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:59:17 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:59:18 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:59:20 :: SpawnMob: SpawnMob: no mob data for vnum 10103
SYSERR: Oct 12 22:59:20 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 22:59:21 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:59:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:59:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:59:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 22:59:28 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 23:00:12 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 23:00:15 :: SpawnMob: SpawnMob: no mob data for vnum 20382
SYSERR: Oct 12 23:00:15 :: SpawnMob: SpawnMob: no mob data for vnum 10101
SYSERR: Oct 12 23:00:16 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 23:00:17 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 23:00:17 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 23:00:17 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 23:00:18 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 23:00:20 :: SpawnMob: SpawnMob: no mob data for vnum 10103
SYSERR: Oct 12 23:00:20 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 23:00:21 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 23:00:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 23:00:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 23:00:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 23:00:28 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 23:01:12 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 23:01:15 :: SpawnMob: SpawnMob: no mob data for vnum 20382
SYSERR: Oct 12 23:01:15 :: SpawnMob: SpawnMob: no mob data for vnum 10101
SYSERR: Oct 12 23:01:16 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 23:01:17 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 23:01:17 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 23:01:17 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 23:01:18 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 23:01:20 :: SpawnMob: SpawnMob: no mob data for vnum 10103
SYSERR: Oct 12 23:01:20 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 23:01:21 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 23:01:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 23:01:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 23:01:22 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 23:01:28 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 23:02:12 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 23:02:15 :: SpawnMob: SpawnMob: no mob data for vnum 20382
SYSERR: Oct 12 23:02:15 :: SpawnMob: SpawnMob: no mob data for vnum 10101
SYSERR: Oct 12 23:02:16 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 23:02:17 :: SpawnMob: SpawnMob: no mob data for vnum 20374
SYSERR: Oct 12 23:02:17 :: SpawnMob: SpawnMob: no mob data for vnum 20373
SYSERR: Oct 12 23:02:17 :: SpawnMob: SpawnMob: no mob data for vnum 20374

game

SYSERR: Oct 12 22:58:24 :: socket_bind: bind: Address already in use
SYSERR: Oct 12 22:58:24 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'time' at row 1 (query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'channel99', 99) errno: 1264)

auth

SYSERR: Oct 12 22:58:20 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'time' at row 1 (query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'auth', 1) errno: 1264)
SYSERR: Oct 12 22:58:21 :: ChildLoop: AsyncSQL: query failed: Table 'account.string' doesn't exist (query: SELECT name, text FROM string errno: 1146)
SYSERR: Oct 12 22:58:21 :: socket_bind: bind: Address already in use

db syslog nie wrzuce bo jest tak długie ze nie moge tego tu nawet zamieścić.

fragment:

Oct 12 22:57:57 :: [ 30300] return 0/0/0 async 0/0/0
Oct 12 22:58:02 :: [ 30350] return 0/0/0 async 0/0/0
Oct 12 22:58:07 :: [ 30400] return 0/0/0 async 0/0/0
Oct 12 22:58:12 :: [ 30450] return 0/0/0 async 0/0/0
SYSERR: Oct 12 22:58:13 :: Start: TABLE_POSTFIX not configured use default
Oct 12 22:58:13 :: connecting to MySQL server (player)
Oct 12 22:58:13 :: CREATING DIRECT_SQL
Oct 12 22:58:13 :: AsyncSQL: locale euckr
Oct 12 22:58:14 :: --mysql_set_character_set(euckr)
Oct 12 22:58:14 :: CREATING MAIN_SQL
Oct 12 22:58:14 :: AsyncSQL: locale euckr
Oct 12 22:58:14 :: CREATING ASYNC_SQL
Oct 12 22:58:14 :: AsyncSQL: locale euckr
Oct 12 22:58:14 :: OK
Oct 12 22:58:14 :: connecting to MySQL server (account)
Oct 12 22:58:14 :: CREATING DIRECT_SQL
Oct 12 22:58:14 :: AsyncSQL: locale euckr
Oct 12 22:58:15 :: --mysql_set_character_set(euckr)
Oct 12 22:58:15 :: CREATING MAIN_SQL
Oct 12 22:58:15 :: AsyncSQL: locale euckr
Oct 12 22:58:15 :: CREATING ASYNC_SQL
Oct 12 22:58:15 :: AsyncSQL: locale euckr
Oct 12 22:58:15 :: OK
Oct 12 22:58:15 :: connecting to MySQL server (common)
Oct 12 22:58:15 :: CREATING DIRECT_SQL
Oct 12 22:58:15 :: AsyncSQL: locale euckr
Oct 12 22:58:15 :: --mysql_set_character_set(euckr)
Oct 12 22:58:15 :: --mysql_set_character_set(euckr)
Oct 12 22:58:15 :: --mysql_set_character_set(euckr)
Oct 12 22:58:15 :: CREATING MAIN_SQL
Oct 12 22:58:15 :: AsyncSQL: locale euckr
Oct 12 22:58:15 :: CREATING ASYNC_SQL
Oct 12 22:58:15 :: AsyncSQL: locale euckr
Oct 12 22:58:15 :: OK
Oct 12 22:58:15 :: connecting to MySQL server (hotbackup)
Oct 12 22:58:15 :: CREATING DIRECT_SQL
Oct 12 22:58:15 :: AsyncSQL: locale euckr
Oct 12 22:58:16 :: --mysql_set_character_set(euckr)
Oct 12 22:58:16 :: --mysql_set_character_set(euckr)
Oct 12 22:58:16 :: --mysql_set_character_set(euckr)
Oct 12 22:58:16 :: CREATING MAIN_SQL
Oct 12 22:58:16 :: AsyncSQL: locale euckr
Oct 12 22:58:16 :: CREATING ASYNC_SQL
Oct 12 22:58:16 :: AsyncSQL: locale euckr
Oct 12 22:58:16 :: OK
Oct 12 22:58:16 :: ClientManager initialization..
Oct 12 22:58:17 :: InitializeLocalization() - LoadLocaleTable(count:13)
Oct 12 22:58:17 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE0)] = 0 5 6 8 10 12 14 16 18 20 22 24
Oct 12 22:58:17 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE1)] = 0 5 6 8 10 12 14 16 18 20 22 24
Oct 12 22:58:17 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE2)] = 0 5 6 8 10 12 14 16 18 20 22 24
Oct 12 22:58:17 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE3)] = 0 5 6 8 10 12 14 16 18 20 22 24
Oct 12 22:58:17 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE4)] = 0 5 6 8 10 12 14 16 18 20 22 24
Oct 12 22:58:17 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE5)] = 0 5 6 8 10 12 14 16 18 20 22 24
Oct 12 22:58:17 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE6)] = 0 5 6 8 10 12 14 16 18 20 22 24
Oct 12 22:58:17 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE7)] = 0 5 6 8 10 12 14 16 18 20 22 24
Oct 12 22:58:17 :: locale[LOCALE] = poland
Oct 12 22:58:17 :: Changed g_stLocale euckr to euckr
Oct 12 22:58:17 :: SetLocale start
Oct 12 22:58:17 :: End setlocale latin2
Oct 12 22:58:17 :: locale[DB_NAME_COLUMN] = locale_name
Oct 12 22:58:17 :: locale[UNKNOWN_KEY(SKILL_DAMAGE_BY_LEVEL_UNDER_90)] = 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Oct 12 22:58:17 :: locale[UNKNOWN_KEY(SKILL_DAMAGE_BY_LEVEL_UNDER_45)] = 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Oct 12 22:58:17 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL)] = 0 5 6 8 10 12 14 16 18 20 22 24
Oct 12 22:58:17 :: GetParam 2000000000
Oct 12 22:58:17 :: GetParam 2100000000
Oct 12 22:58:17 :: ItemRange From File 2000000000 ~ 2100000000
Oct 12 22:58:17 :: [ 30500] return 0/0/0 async 0/0/0
Oct 12 22:58:17 :: ItemIDRange: Build: 2000000000 ~ 2100000000 start:2000000000
Oct 12 22:58:17 :: Init Success Start 2000000000 End 2100000000 Now 2000000000

Oct 12 22:58:18 :: --mysql_set_character_set(latin2)
Oct 12 22:58:18 :: --mysql_set_character_set(latin2)
Oct 12 22:58:18 :: --mysql_set_character_set(latin2)
Oct 12 22:58:19 :: --mysql_set_character_set(latin2)

MrDevarion · 12 Października 2014

podmień sobie tabelki account_sting i boot_log

Janu · 14 Października 2014

podmień sobie tabelki account_sting i boot_log

Tego account.sting wogóle nie mam w bazie, no chyba ze to jest to normalne account ale wted jest to tam gdzie należy czyli a account w mysql.

Zaloguj się

👋 Witaj na MPCForum!

Serwer VPS, błąd łączenia z serwerem...

Rekomendowane odpowiedzi

Zarchiwizowany