Проблема С Сервером

[Foolk 0]

В вообщем ситуация следующая.

 

Установил на удаленном VDS сервере (ОС Linux / OpenVZ) сборку L2jC3server. Соответственно залил сам серв на ftp, создал и залил базу данных (при помощи ДБ инсталлера). Очень долго мучился с запуском ЛС и ГС (то ошибки в скрипте были то с кодировкой проблемы) в итоге нашел рабочие СХашки ЛС и ГС от Грации.

 

Перезалил их и все запустилось, проверяю через терминал - процессы висят в списке среди прочих. Вроде все норм.

 

Скачал клиент С3 с другого работающего серва, изменил IP в l2.ini. В настройках сервера стоит авторегистрация.

 

Запускаю клиент у себя на компе, ввожу лоин и пароль и на этом все, к выбору сервера не выводит, сообщений клиент никаких не пишет, даже не задумывается ни на секунду, как-будто я не пытаюсь зайти.

 

Кто может подсказать в чем может быть проблема? а может даже и посоветует что-нибудь))

[sharp1k 321]

может с портами что-то в конфигах?

 

проверь логи, может оно и не запустилось

[Foolk 0]

Да смотрю в логах где-то на восьмой строчке закралась ошибка?

 

Вот что в логе пишет:

./LoginServer_loop.sh: line 8: java: command not found

 

Вот сам скрипт файла "LoginServer_loop.sh":

 

 

#!/bin/bash

 

err=1

until [ $err == 0 ];

do

[ -f log/java0.log.0 ] && mv log/java0.log.0 "log/`date +%Y-%m-%d_%H-%M-%S`_java.log"

[ -f log/stdout.log ] && mv log/stdout.log "log/`date +%Y-%m-%d_%H-%M-%S`_stdout.log"

java -Xms128m -Xmx128m -cp javolution.jar:c3p0-0.9.0.jar:mysql-connector-java-3.1.10-bin.jar:l2jserver.jar net.sf.l2j.loginserver.LoginServer > log/stdout.log 2>&1

err=$?

# /etc/init.d/mysql restart

sleep 10;

done

 

 

Что тут не так с восьмой строчкой? Выделил эту строчку)

Изменено 2 июня, 2014 пользователем Foolk

[rooti 764]

java: command not found

 

Яву ставили ведь?

[Foolk 0]

Блин, думал что поставил))) установится отпишу

[Foolk 0]

Да всем спасибо, запустилось. ГС тоже запустился, захожу на серв в окно персонажей и опять на этом все. На кнопку создать персонажа не реагирует. Кто сталкивался с таким?

[rooti 764]

Глядите в логах, должно что-то быть

[Broke 5]

Да всем спасибо, запустилось. ГС тоже запустился, захожу на серв в окно персонажей и опять на этом все. На кнопку создать персонажа не реагирует. Кто сталкивался с таким?

Оперативной памяти добавьте в .sh файле. Вообще, файлы запуска брать нежелательно с другой сборки, там же загрузка ядер идет...

[Foolk 0]

Да я пути к ядрам и имена самих ядер на правильные поменял.

По ГСу в логах ппц какой-то

Вот:

loading gameserver config

Say Filter: Loaded 11 filter words.

MLog clients using java 1.4+ standard logging.

Initializing c3p0-0.9.0 [built 08-РђРІРіСѓСЃС‚-2005 15:47:30 +0400; debug? false; trace: 5]

Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@1b83048 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@121fd61 [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> true, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 121fd61, idleConnectionTestPeriod -> 0, initialPoolSize -> 1, maxIdleTime -> 0, maxPoolSize -> 10, maxStatements -> 100, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@118cb3a [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 118cb3a, jdbcUrl -> jdbc:mysql://localhost/l2jdb?useUnicode=true&characterEncoding=UTF-8, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ], factoryClassLocation -> null, identityToken -> 1b83048, numHelperThreads -> 3 ]

L2J Server Version: ${l2jvn.revision}

L2J Server Build Date: 20091004_1553

Updated characters online status.

Cleaned 0 elements from database.

IDFactory: 102912 id's avaliable.

data error on item:

java.sql.SQLException: Table 'l2jdb.etcitem' doesn't exist

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:102)

at net.sf.l2j.gameserver.ItemTable.(ItemTable.java:198)

at net.sf.l2j.gameserver.ItemTable.getInstance(ItemTable.java:168)

at net.sf.l2j.gameserver.GameServer.(GameServer.java:229)

at net.sf.l2j.gameserver.GameServer.main(GameServer.java:500)

 

Error get item data for item 2506(Wolf's Leather Armor)

 

at net.sf.l2j.gameserver.GameServer.main(GameServer.java:500)

 

error while creating henna table java.sql.SQLException: Table 'l2jdb.henna' doesn't exist

java.sql.SQLException: Table 'l2jdb.henna' doesn't exist

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:102)

at net.sf.l2j.gameserver.HennaTable.RestoreHennaData(HennaTable.java:72)

at net.sf.l2j.gameserver.HennaTable.(HennaTable.java:57)

at net.sf.l2j.gameserver.HennaTable.getInstance(HennaTable.java:49)

at net.sf.l2j.gameserver.GameServer.(GameServer.java:260)

at net.sf.l2j.gameserver.GameServer.main(GameServer.java:500)

error while creating teleport table java.sql.SQLException: Table 'l2jdb.teleport' doesn't exist

error while creating Lvl up data table java.sql.SQLException: Table 'l2jdb.lvlupgain' doesn't exist

L2World: Setting up World Regions

L2World: (40 by 80) World Region Grid set up.

Zone: Loaded 4 Arena

Zone: Loaded 4 Peace

Zone: Loaded 4 Clan Hall

Zone: Loaded 6 Castle Defender Spawn

Zone: Loaded 6 Siege Battlefield

Zone: Loaded 8 Underground

Zone: Loaded 17 Town

Zone: Loaded 7 Castle Area

Zone: Loaded 1 Water

Zone: Loaded 17 Town Spawn

Zone: Loaded 1 No Landing

Zone: Loaded 4 Arena Spawn

SpawnTable: Spawn could not be initialized: java.sql.SQLException: Table 'l2jdb.spawnlist' doesn't exist

SpawnTable: Loaded 0 Npc Spawn Locations. Total NPCs: 0

Announcements: Loaded 3 Announcements.

error while creating map region data: java.sql.SQLException: Table 'l2jdb.mapregion' doesn't exist

DoorTable: Loaded 138 Door Templates.

StaticObject: Loaded 27 StaticObject Templates.

SevenSigns: Currently in the Competition (Quest Event) period!

SevenSigns: The Seal of Avarice remains unclaimed.

SevenSigns: The Seal of Gnosis remains unclaimed.

SevenSigns: The Seal of Strife remains unclaimed.

SevenSigns: The Lords of Dawn are in the lead this week.

SevenSigns: Next period begins in 6 days, 5 hours and 25 mins.

SevenSignsFestival: The first Festival of Darkness cycle begins in 2 minute(s).

AutoChatHandler: Loaded 0 handlers in total.

AutoSpawnHandler: Loaded 1 handlers in total.

Loaded: 0 Mercenary Tickets

ItemHandler: Loaded 1193 handlers.

SkillHandler: Loaded 48 handlers.

AdminCommandHandler: Loaded 278 handlers.

UserCommandHandler: Loaded 4 handlers.

VoicedCommandHandler: Loaded 1 handlers.

Event ID: (Valentines Event) has passed... Ignored.

Event ID: (Medals Event) has passed... Ignored.

Event ID: (L2 Day Event) has passed... Ignored.

 

importing quests ...

importing quests: 1: Letters Of Love1

importing quests: 2: What Women Want

importing quests: 3: Release Darkelf Elder1

importing quests: 4: Long Live Lord Of Flame

importing quests: 5: Miners Favor

importing quests: 6: Step Into the Future

importing quests: 7: A Trip Begins

importing quests: 8: An Adventure Begins

importing quests: 9: Into the City of Humans

importing quests: 10: Into The World

importing quests: 45: To Talking Island

importing quests: 46: Once More In The Arms of the Mother Tree

importing quests: 47: Into the Dark Forest

importing quests: 48: To the Immortal Plateau

importing quests: 49: The Road Home

importing quests: 101: Sword Of Solidarity Quest

importing quests: 102: Fungus Fever

importing quests: 103: Spirit Of Craftsman

importing quests: 104: Spirit Of Mirror

importing quests: 105: Skirmish With Orcs

importing quests: 106: Forgotten Truth

importing quests: 107: Show No Mercy

importing quests: 108: Diamond Gambit

importing quests: 151: Save My Sister1

importing quests: 152: Shards Of Golem

importing quests: 153: Wharf Oldtimers Favor

importing quests: 154: Sacrifice To Sea

importing quests: 155: Find Sir Windawood

importing quests: 156: Millennium Love

importing quests: 157: Recover Smuggled

importing quests: 158: Seed Of Evil

importing quests: 159: Protect Headsprings

importing quests: 160: Nerupas Favor

importing quests: 161: Fruits Of Mothertree

importing quests: 162: Curse Of Fortress

importing quests: 163: Legacy Of Poet

importing quests: 164: Blood Fiend

importing quests: 165: Wild Hunt

importing quests: 166: Dark Mass

importing quests: 168: Deliver Supplies

importing quests: 169: Nightmare Children

importing quests: 170: Dangerous Allure

importing quests: 211: Trial Of Challenger

importing quests: 212: Trial Of Duty

importing quests: 213: Trial Of Seeker

importing quests: 214: Trial Of Scholar

importing quests: 215: Trial Of Pilgrim

importing quests: 216: Trial Of Guildsman

importing quests: 217: Testimony Of Trust

importing quests: 218: Testimony Of Life

importing quests: 219: Testimony Of Fate

importing quests: 220: Testimony Of Glory

importing quests: 221: Testimony Of Prosperity

importing quests: 222: Test Of Duelist

importing quests: 223: Test Of Champion

importing quests: 224: Test Of Sagittarius

importing quests: 225: Test Of Searcher

importing quests: 226: Test Of Healer

importing quests: 227: Test Of Reformer

importing quests: 228: Test Of Magus

importing quests: 229: Test Of Witchcraft

importing quests: 230: Test Of Summoner

importing quests: 231: Test Of Maestro

importing quests: 232: Test Of Lord

importing quests: 233: Test Of Warspirit

importing quests: 257: Guard Is Busy1

importing quests: 258: Bring Wolf Pelt1

importing quests: 259: Ranchers Plea

importing quests: 260: Hunt For Orcs1

importing quests: 261: Dream Of Moneylender1

importing quests: 262: Bring Me Mushrooms1

importing quests: 263: Kill All Sylphs1

importing quests: 264: Keen Claws

importing quests: 265: Chains Of Slavery

importing quests: 266: Plea Of Pixies

importing quests: 267: Wrath Of Verdure

importing quests: 271: Proof Of Valor

importing quests: 272: Wrath Of Ancestors

importing quests: 273: Invaders Of Holyland

importing quests: 274: Against Wolf Men

importing quests: 276: Hestui Totem

importing quests: 277: Gatekeepers Offering

importing quests: 291: Red Bonnets Revenge

importing quests: 292: Crush Brigands

importing quests: 293: Hidden Vein

importing quests: 294: Covert Business

importing quests: 295: Dreams Of Flight

importing quests: 296: Silk Of Tarantula

importing quests: 297: Gatekeepers Favor

importing quests: 303: Collect Arrowheads

importing quests: 306: Crystal Of Fireice

importing quests: 313: Collect Spores

importing quests: 316: Destroy Plaguebringers

importing quests: 317: Catch The Wind

importing quests: 319: Scent Of Death

importing quests: 320: Bones Tell Future

importing quests: 324: Sweetest Venom

importing quests: 325: Grim Collector

importing quests: 326: Vanquish Remnants

importing quests: 327: Reclaim The Land

importing quests: 328: Sense For Business

importing quests: 329: Curiosity Of Dwarf

importing quests: 330: Adept Of Taste

importing quests: 331: Arrow For Vengeance

importing quests: 333: BlackLionHunt

importing quests: 347: Go Get The Calculator

importing quests: 350: Enhance Your Weapon

importing quests: 358: Illegitimate Child Of A Goddess

importing quests: 359: For Sleepless Deadmen

importing quests: 362: Bards Mandolin

importing quests: 363: Sorrowful Sound of Flute

importing quests: 364: Jovial Accordion

importing quests: 372: Legacy of Insolence

importing quests: 373: Supplier of Reagents

importing quests: 374: Whisper of Dreams, part 1

importing quests: 375: Whisper of Dreams, part 2

importing quests: 376: Exploration of Giants Cave, part 1

importing quests: 377: Exploration of Giants Cave, part 2

importing quests: 385: Yoke of the Past

importing quests: 386: Stolen Dignity

importing quests: 401: Path To Warrior

importing quests: 402: Path To Knight

importing quests: 403: Path To Rogue

importing quests: 404: Path To Wizard

importing quests: 405: Path To Cleric

importing quests: 406: Path To Elven Knight

importing quests: 407: Path To Elven Scout

importing quests: 408: Path To Elvenwizard

importing quests: 409: Path To Oracle

importing quests: 410: Path To Palus Knight

importing quests: 411: Path To Assassin

importing quests: 412: Path To Darkwizard

importing quests: 413: Path To Shillien Oracle

importing quests: 414: Path To Orc Raider

importing quests: 415: Path To Orc Monk

importing quests: 416: Path To Orc Shaman

importing quests: 417: Path To Scavenger

importing quests: 418: Path To Artisan

importing quests: 419: Get a Pet

importing quests: 420: Little Wings

importing quests: 421: Little Wing's Big Adventures

importing quests: 431: Wedding March

importing quests: 432: Birthday Party Song

importing quests: 501: Proof of Clan Alliance

importing quests: 999: C3 Tutorial

... done

 

importing luxury_shop ...

importing 5001: luxury_shop : Loaded 15 item(s)

importing 5002: luxury_shop : Loaded 6 item(s)

importing 5003: luxury_shop : Loaded 2 item(s)

importing 5004: luxury_shop : Loaded 15 item(s)

importing 6001: luxury_shop : Loaded 15 item(s)

importing 6002: luxury_shop : Loaded 3 item(s)

importing 6003: luxury_shop : Loaded 2 item(s)

importing 6004: luxury_shop : Loaded 9 item(s)

... done

 

importing blacksmith data ...

importing blacksmith data: 1000_topduals

importing blacksmith data: 1001_dual swords

importing blacksmith data: 1002_unseal

importing blacksmith data: 1003_reseal

importing blacksmith data: 1004_create

importing blacksmith data: 1005_unseal

importing quests: 1006: Blacksmith

importing blacksmith data: 1007_enhance

importing blacksmith data: 1008_enhance_mammon

importing blacksmith data: 1009_remove_mammon

importing blacksmith data: 1010_enchange_mammon ...

... done

 

importing custom data ...

importing custom data: 1006_tattoos

importing custom: 3995: echo: 7 item(s) ...done

importing custom: 3996: echoc: 10 item(s) ...done

importing 5000: custom : Loaded 24 item(s)

importing 5005: custom : Loaded 4 item(s)

importing custom: 5011: l2day: 3 item(s) importing custom data: AA

... done

 

 

importing items exchange ...

importing 6001: exchange : Loaded 4 item(s)

importing 6002: exchange : Loaded 15 item(s)

importing 6003: exchange : Loaded 14 item(s)

importing 6004: exchange : Loaded 18 item(s)

importing 6005: exchange : Loaded 6 item(s)

importing 6006: exchange : Loaded 16 item(s)

importing 6007: exchange : Loaded 10 item(s)

importing 6008: exchange : Loaded 5 item(s)

importing 6009: exchange : Loaded 9 item(s)

importing 6010: exchange : Loaded 8 item(s)

importing 6011: exchange : Loaded 2 item(s)

importing 6012: exchange : Loaded 8 item(s)

importing 6013: exchange : Loaded 7 item(s)

importing 6014: exchange : Loaded 5 item(s)

importing 6101: exchange : Loaded 2 item(s)

... done

 

importing teleport data ...

importing teleport data: 1101_teleport_to_race_track

... done

 

 

importing seven_signs data ...

importing seven signs data: 2004_mammerch

... done

 

 

importing village master data ...

importing village master data: Talking Island Village ...done

importing village master data: Ivory Tower ...done

importing village master data: Heine ...done

importing village master data: Elven Village ...done

importing village master data: Gludin Village ...done

importing village master data: Gludio Castle Town ...done

importing village master data: Dark Elven Temple ...done

importing village master data: Dion Castle Town ...done

importing village master data: Giran Castle Town ...done

importing village master data: Town of Oren ...done

importing village master data: Hunters Village ...done

importing village master data: Tower of Aden ...done

importing village master data: Dwarven Village ...done

importing village master data: Orc Village ...done

importing village master data: Clan ...done

importing village master data: Alliance ...done

... done

 

Loaded: 223 quests

Loaded: 7 castles

Siege of Gludio: Sat Jun 07 20:00:00 MSK 2014

Siege of Dion: Sat Jun 07 20:00:00 MSK 2014

Siege of Giran: Sun Jun 15 16:00:00 MSK 2014

Siege of Oren: Sun Jun 15 16:00:00 MSK 2014

Siege of Aden: Sat Jun 07 20:00:00 MSK 2014

Siege of Innadril: Sun Jun 15 16:00:00 MSK 2014

Siege of Goddard: Sun Jun 15 16:00:00 MSK 2014

IdFactory: Free ObjectID's remaining: 1879047957

GameServer Started, free memory 474 Mb of 494 Mb

Connecting to login on 81.176.229.170:9014

Maximum Numbers of Connected Players: 100

Telnet server is currently disabled.

GameServer listening on IP: 81.176.229.170 Port 7777

 

java.net.BindException: Address already in use

at sun.nio.ch.Net.bind0(Native Method)

at sun.nio.ch.Net.bind(Net.java:174)

at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:139)

at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:77)

at net.sf.l2j.gameserver.SelectorThread.run(SelectorThread.java:227)

 

SIGTERM received. Shutting down NOW!

Data saved. All players disconnected, shutting down.

 

 

[Foolk 0]

Весь лог естественно добавить не получилось))

[Broke 5]

Это нормальный лог; ошибки видны некоторые: таблицы etcitem не хватает в базе, во-1 (из-за этого и проблема с созданием перса).

 

Во-2, пишет, что порт занят. Закройте/убейте все приложения Java, проверьте настройки запуска и повторите попытку запуска снова.

Изменено 2 июня, 2014 пользователем Broke

[Foolk 0]

Да сборка конечно попалась, сижу таблицы ДБ правлю, синтаксические ошибки в некоторых, вот и не залились)) пока помогает. посмотрим что в итоге получится

[Foolk 0]

Все заходит, решил проблему откорректировав sql файлы сборки и перезалив их в базу, пока все работает как надо. Всем спасибо, всем плюсую)

 

Тему можно закрывать

Изменено 2 июня, 2014 пользователем Foolk