Мануал! Установка ява сервера SF, RT, ST etc.

[ExLite]

Скачал L2jServer rev.9135, распаковал, запустил, все работает. Смотрите что Вы сделали не то.

пруф

[DemonOfTheWh]

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

Код:

log4j:WARN No appenders could be found for logger (l2ft.loginserver.Config).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
Exception in thread "main" java.sql.SQLException: Access denied for user 'root'@'localhost' (using p
assword: NO)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:951)
        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4600)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1328)
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2395)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2428)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2213)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:797)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConn
ectionFactory.java:78)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.ja
va:582)
        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)
        at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
        at l2ft.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:74)
        at l2ft.loginserver.database.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:23)
        at l2ft.loginserver.LoginServer.main(LoginServer.java:73)

Server terminated abnormaly ...


Server terminated ...

Я конечно понимаю что, ошибка говорит "не указан пароль", но я ставил пароль для БД root я везде просмотрел(в пропертисах и батниках) везде стоит(логин/пароль) root/root, не пойму в чем проблема.
Таблицы в БД записались нормально.

[NotSpecified]

DemonOfTheWh, следующая ошибка:

PHP код:

<?php 

Exception in thread "main" java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO) 

[DemonOfTheWh]

все разобрался, все скрипты обращались к ..\loginserver\config
а лежало все погчемуто в ..\loginserver\config\default
переместил файлы все заработало.
зы. извините за беспокойство))

[AdamasX]

Здраствуйте нужна помощь.

Открыть спойлер

'Хелп, зарание спасибо.']
Starting L2J Game Server.

Error while loading Datapack version!
java.io.FileNotFoundException: .\config\l2jdp-version.properties (═х єфрхЄё- эрщ
Єш єърчрээ√щ Їрщы)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at com.l2jserver.Config.load(Config.java:1727)
at com.l2jserver.gameserver.GameServer.main(GameServer.java:456)

L2Properties: Missing property for key - version
Could not load HexID file (./config/hexid.txt). Hopefully login will give us one
.
Loaded 6 Filter Words.
-----------------------------------------------------------------=[ Database ]
Exception in thread "main" java.sql.SQLException: Access denied for user 'root'@
'localhost' (using password: NO)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(My
sqlIO.java:1694)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1244)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2397)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2
430)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2215)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:334)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:119)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:866)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.java:789)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:298)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:312)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:128)
at com.l2jserver.L2DatabaseFactory.<init>(L2DatabaseFactory.java:111)
at com.l2jserver.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:25
3)
at com.l2jserver.gameserver.GameServer.main(GameServer.java:458)

Server terminated abnormally


server terminated

Для продолжения нажмите любую клавишу . . .

[ProDev]

Все проблемы четко указаны в логах

1) Не удается загрузить l2jp-version.properties. Нужно проверить есть ли такой файл и его содержимое
2) Отсутствует файл hexid, не припомню, как он обрабатывается в этих сборках, но запускаться явно должно и без него
3) Не удается авторизоваться на СУБД, неверный логин\пасс.

[widowmaker]

при попытке регистрации серва встретилась единственная ошибка по пути установки серва.

вот такая

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'log
inserver_beta'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:934)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4104)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1299)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2
371)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:305)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:119)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:128)
at com.l2jfrozen.util.database.L2DatabaseFactory_c3p0.<init>(L2DatabaseF
actory_c3p0.java:88)
at com.l2jfrozen.util.database.L2DatabaseFactory.getInstance(L2DatabaseF
actory.java:51)
at com.l2jfrozen.gameserver.datatables.GameServerTable.loadRegisteredGam
eServers(GameServerTable.java:195)
at com.l2jfrozen.gameserver.datatables.GameServerTable.<init>(GameServer
Table.java:91)
at com.l2jfrozen.gameserver.datatables.GameServerTable.load(GameServerTa
ble.java:75)
at com.l2jfrozen.gsregistering.GameServerRegister.main(GameServerRegiste
r.java:44)
Welcome to L2JFrozen GameServer Regitering
Enter The id of the server you want to register
Type 'help' to get a list of ids.
Type 'clean' to unregister all currently registered gameservers on this LoginSer
ver.
Your choice:

[ProDev]

Неверно прописан jdbc url для коннекта к СУБД. Либо вы забыли создать нужную базу "loginserver_beta" перед запуском скрипта.

[AdamasX]

а как долго надо ждать запуска startLoginServer.bat

======================================================================-[ Team ]

# ##### ##### ##### ##### ##### ##### ## #
# # # # # # # # # # # #
# ### #### ### # # # # # ### # # #
# # # ### # # # # # # #
##### ##### # # ## ##### ##### ##### # ##

==================================================================-[ Database ]
MLog clients using java 1.4+ standard logging.
Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireInc
rement -> 5, acquireRetryAttempts -> 0, acquireRetryDelay -> 500, autoCommitOnCl
ose -> true, automaticTestTable -> connection_test_table, breakAfterAcquireFailu
re -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connec
tionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSou
rceName -> q4jhee8qyt4sqmlwwea6|1517a05, debugUnreturnedConnectionStackTraces ->
false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassL
ocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> q4
jhee8qyt4sqmlwwea6|1517a05, idleConnectionTestPeriod -> 3600, initialPoolSize ->
10, jdbcUrl -> jdbc:mysql://localhost/la2db, maxAdministrativeTaskTime -> 0, ma
xConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoo
lSize -> 50, maxStatements -> 0, maxStatementsPerConnection -> 100, minPoolSize
-> 10, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, prefer
redTestQuery -> null, properties -> {user=******, password=******}, propertyCycl
e -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unr
eturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
===========================================================-[ LoginController ]
Cached 10 KeyPairs for RSA communication
Stored 20 keys for Blowfish communication
Loaded 127 server names
Loaded 1 registered Game Servers
Cached 10 RSA keys for Game Server communication.
Listening for GameServers on 127.0.0.1:9014
Login Server ready on *:2106
Loaded 2 IP Bans.

[Zubastic]

Listening for GameServers on 127.0.0.1:9014

ЛС готов. Вот и все.