[Problem]Mam problem z odpaleniem serwer'a VPS

[Arojzer]

Więc tak mam problem. Dokładnie opiszę go tutaj w tym temacie.

A więc kiedy wpisuje komendę na uruchomienie serwer'a Metin2

To wyskakuje mi takie coś

 

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)
./game: 1: Syntax error: "(" unexpected
./game99: 1: Syntax error: "(" unexpected
./game22: 1: Syntax error: "(" unexpected
./auth: 1: Syntax error: "(" unexpected

 

A w tym problem że podmieniłem i wszystkie znaczki tam pozmieniałem to jest KROK 5 "

Musimy usunąć kilka niepotrzebnie dodanych rzeczy w plikach Sherera&Masticka "

Link do poradnika:

http://www.mpcforum.pl/topic/501837-mega-tutorial-serwer-od-podstaw-na-32-bitowym-freebsd-82/

 

I co mam w takim razie zrobić?

[Lexor]

Podaj zawartość pliku start.sh

[Kusicielka]

Uruchomiła się baza ale nie odnalazł w skrypcie ścieżki wychodzącej z db i docierającej do auth uruchamiając je, ścieżka jest nieprawidłowa.

 

/usr/home/game/

 

masz plik jak start.sh

 

Edytujesz go... i tam masz np starting auth i pod spodem jest do niego ścieżka... i wystarczy odszukać plik auth zmienić ścieżkę do niego... i będzie czytać...

[Arojzer]

Proszę oto zawartość pliki start.sh

 

#!/bin/sh
cd db && ./db &
sleep 2
cd ./game && ./game &
sleep 2
cd ./game99 && ./game99 &
sleep 2
cd ./game22 && ./game22 &
sleep 2
cd ./auth  && ./auth &
sleep 2
cd ..

[Lexor]

Jake masz pliki ? skąd pobrałeś

[Arojzer]

no z tego tam tuta co dałem do niego linka pliki 2k10 czy 2k11

[Arojzer]

Proszę o odpowiedź bo mi na tym bardzo zależy a za

bardzo nie mam czasu

[Arojzer]

No i czekam na odpowiedź, pomocy szukam wśród was

[Remotion]

Domyslam się co to za błąd ale nie jestem pewien ,podaj zawartosc sysser (folder game,db,auth)

i daj tutaj

[Arojzer]

Dobra dobra oto one:

 

-Zawartość db

SYSERR: Feb  2 13:45:43 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Feb  2 13:45:43 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'skill_vnum2' in 'field list'
query: SELECT vnum, name, gb2312name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4 , sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive  FROM mob_proto ORDER BY vnum
SYSERR: Feb  2 13:45:43 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.id
SYSERR: Feb  2 13:45:43 :: 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: Feb  2 13:53:10 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Feb  2 13:53:10 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'skill_vnum2' in 'field list'
query: SELECT vnum, name, gb2312name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4 , sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive  FROM mob_proto ORDER BY vnum
SYSERR: Feb  2 13:53:10 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.id
SYSERR: Feb  2 13:53:10 :: 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: Feb  2 13:53:10 :: socket_bind: bind: Address already in use
SYSERR: Feb  2 19:42:35 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Feb  2 19:42:35 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'skill_vnum2' in 'field list'
query: SELECT vnum, name, gb2312name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4 , sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive  FROM mob_proto ORDER BY vnum
SYSERR: Feb  2 19:42:35 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.id
SYSERR: Feb  2 19:42:35 :: 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: Feb  2 19:42:35 :: socket_bind: bind: Address already in use
SYSERR: Feb  2 19:56:11 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Feb  2 19:56:11 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'skill_vnum2' in 'field list'
query: SELECT vnum, name, gb2312name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4 , sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive  FROM mob_proto ORDER BY vnum
SYSERR: Feb  2 19:56:11 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.id
SYSERR: Feb  2 19:56:11 :: 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: Feb  2 19:56:11 :: socket_bind: bind: Address already in use
SYSERR: Feb  2 20:03:09 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Feb  2 20:03:19 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Feb  2 20:03:19 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'skill_vnum2' in 'field list'
query: SELECT vnum, name, gb2312name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4 , sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive  FROM mob_proto ORDER BY vnum
SYSERR: Feb  2 20:03:19 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.id
SYSERR: Feb  2 20:03:19 :: 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: Feb  2 20:41:40 :: 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: Feb  2 20:41:45 :: 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: Feb  2 20:41:45 :: ChildLoop: AsyncSQL: retrying
SYSERR: Feb  2 20:41:47 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Feb  3 10:49:39 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Feb  3 10:49:39 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'skill_vnum2' in 'field list'
query: SELECT vnum, name, gb2312name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4 , sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive  FROM mob_proto ORDER BY vnum
SYSERR: Feb  3 10:49:39 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.id
SYSERR: Feb  3 10:49:39 :: 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

 

A w Folderach

game, game22, game99 i auth

nie posiadam tam plików o nazwie syserr

[Equalex]

Tibia najlepsza.

 

heh

[Lexor]

a Spróbuj ręcznie włączyć

[Arojzer]

a czyli jak to włączyć?

[Lexor]

cd ścieżka do folderu game

 

i ./game

 

i tak wszystkie

[Arojzer]

to samo. A jak podawałem ścieżkę i wpisywałem ./game i tak dalej

wyskakiwało mi

./game: Exec format error. Binary file not executable

[Remotion]

z tego co podałes to błąd jest tutaj

./game: 1: Syntax error: "(" unexpected
./game99: 1: Syntax error: "(" unexpected
./game22: 1: Syntax error: "(" unexpected
./auth: 1: Syntax error: "(" unexpected

nieoczekiwany błąd składni

tak tylko , masz wgrane game do folderów ? i ponadpisywane że w folderze game99 , nazwa game99 itp

(chociaz mysle ze wtedy pisalo by ....not found....)

[Lexor]

@Remotion

 

do chaneli nie wgrywa się pliko game tylko powiązania

[Arojzer]

@Remotion

 

Za bardzo nie rozumiem jak mam mieć wgrane game.

game

Tak jak w np: w folderze db?

[Lexor]

@UP

Bo to taki znawca plików ....

 

spróbuj zmieniać plik start.sh na ten

to chyba z plików "Badar" powinien działać

http://wklej.to/6Y11y

 

Ps tylko musisz go edytować ścieżki plików

[Arojzer]

Ej spoko znawca plików, ale pomożecie mi z tym moim wielkim niezniszczalnym dla mnie problemem?

[Lexor]

Masz w folderze game utworzone skróty

masz ss do wglądu

 

http://imageshack.us/photo/my-images/802/gameee.jpg/

[Arojzer]

no mam, od samego początku i co teraz mam uczynić?

[Lexor]

próbowałeś odpalić tym skryptem co ci wysłałem ?

[Arojzer]

Za bardzo cię nie rozumiem. wysłałeś mi samo zdjęcie a myślę że to nie skrypt tylko zdjęcie. Owszem mam tam te skróty więc teraz co z nimi mam zrobić?

[Lexor]

u góry wysłałem ci linka 6 postów temu

 

http://wklej.to/6Y11y