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

[hellboyw]

запускаю гейм сервер с логин сервером ( всё работает отлично ) пытаюсь создать в клиенте аккаунт ( стоит авторег ) в логах ( лог сервера ) выдаёт такое :

Код:

INFO : Account created for user: hellboyw
WARN : SQL Error: 1364, SQLState: HY000
ERROR : Field 'email' doesn't have a default value
ERROR : Could not synchronize database state with session org.hibernate.exceptio
n.GenericJDBCException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException
(SQLStateConverter.java:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
253)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
ns(AbstractFlushingEventListener.java:298)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus
hEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java
:106)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doComm
it(HibernateTransactionManager.java:606)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.processCommit(AbstractPlatformTransactionManager.java:709)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.commit(AbstractPlatformTransactionManager.java:678)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
commitTransactionAfterReturning(TransactionAspectSupport.java:321)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:116)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:635)
        at net.l2emuproject.loginserver.services.AccountsServices$$EnhancerByCGL
IB$$93342aca.addOrUpdateAccount(<generated>)
        at net.l2emuproject.loginserver.manager.LoginManager.handleAccountNotFou
nd(LoginManager.java:629)
        at net.l2emuproject.loginserver.manager.LoginManager.loginValid(LoginMan
ager.java:511)
        at net.l2emuproject.loginserver.manager.LoginManager.loginValid(LoginMan
ager.java:476)
        at net.l2emuproject.loginserver.manager.LoginManager.tryAuthLogin(LoginM
anager.java:279)
        at net.l2emuproject.loginserver.clientpackets.RequestAuthLogin.run(Reque
stAuthLogin.java:105)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.BatchUpdateException: Field 'email' doesn't have a default v
alue
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
nt.java:1693)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
1108)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
oxyPreparedStatement.java:1723)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
a:48)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
246)
        ... 23 more

Exception in thread "pool-1-thread-1" org.springframework.jdbc.UncategorizedSQLE
xception: Hibernate flushing: Could not execute JDBC batch update; uncategorized
SQLException for SQL [insert into accounts (password, lastactive, accessLevel,
lastIP, lastServerId, login) values (?, ?, ?, ?, ?, ?)]; SQL state [HY000]; erro
r code [1364]; Field 'email' doesn't have a default value; nested exception is j
ava.sql.BatchUpdateException: Field 'email' doesn't have a default value
        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.trans
late(SQLStateSQLExceptionTranslator.java:124)
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.t
ranslate(SQLErrorCodeSQLExceptionTranslator.java:322)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.conver
tJdbcAccessException(HibernateTransactionManager.java:750)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.conver
tHibernateAccessException(HibernateTransactionManager.java:736)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doComm
it(HibernateTransactionManager.java:614)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.processCommit(AbstractPlatformTransactionManager.java:709)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.commit(AbstractPlatformTransactionManager.java:678)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
commitTransactionAfterReturning(TransactionAspectSupport.java:321)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:116)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:635)
        at net.l2emuproject.loginserver.services.AccountsServices$$EnhancerByCGL
IB$$93342aca.addOrUpdateAccount(<generated>)
        at net.l2emuproject.loginserver.manager.LoginManager.handleAccountNotFou
nd(LoginManager.java:629)
        at net.l2emuproject.loginserver.manager.LoginManager.loginValid(LoginMan
ager.java:511)
        at net.l2emuproject.loginserver.manager.LoginManager.loginValid(LoginMan
ager.java:476)
        at net.l2emuproject.loginserver.manager.LoginManager.tryAuthLogin(LoginM
anager.java:279)
        at net.l2emuproject.loginserver.clientpackets.RequestAuthLogin.run(Reque
stAuthLogin.java:105)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.BatchUpdateException: Field 'email' doesn't have a default v
alue
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
nt.java:1693)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
1108)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
oxyPreparedStatement.java:1723)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
a:48)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
246)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
ns(AbstractFlushingEventListener.java:298)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus
hEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java
:106)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doComm
it(HibernateTransactionManager.java:606)
        ... 15 more

[olegfish]

я сним разговаривал....... пытался своим навиком с ним сконектится...... конект норм проходит, базу считывает, я в своей создаю акк сохраняю в файл потом пытаюсь импортировать в его базу аккаунт, у меня не заливается. выдаю ошибку. мне кажется доступ у него открыт только для чтения а не для правки, из за этого и с сайта не происходить записи в базе. Если я не прав то напишите что в навике исправить. У него не работает регистрация вообще, ни через авторег ни через сайт.

[Skyinfirecla]

Вы англ язык знаете ? Вам белым по черному пишет

Невозможно загрузить GameServerTable. Причина: Таблица 'l2jdb.gameservers' не существует
Сделайте таблицу gameservers и вперед.
В таблице 3 поля:
server_id, int
hexid, varchar
host, varchar

ВОпрос конечно идиотский, но я первый раз пытаюсь сервак свой создать, а вопрос именно по параметрам "int" и "varchar" именно они должны выводиться в данной таблице l2jdb"gameserver"?

[Alan Holt]

Код:

Starting C4 RT-Team Login Server.

loading login config
MLog clients using java 1.4+ standard logging.
Initializing c3p0-0.9.0 [built 08-└туєёЄ-2005 15:47:30 +0400; debug? false; trac
e: 5]
Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@ca0115 [ conn
ectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@14da
8f4 [ acquireIncrement -> 5, acquireRetryAttempts -> 0, acquireRetryDelay -> 500
, autoCommitOnClose -> true, automaticTestTable -> connection_test_table, breakA
fterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName ->
com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null,
forceIgnoreUnresolvedTransactions -> false, identityToken -> 14da8f4, idleConnec
tionTestPeriod -> 60, initialPoolSize -> 3, maxIdleTime -> 0, maxPoolSize -> 100
, maxStatements -> 0, maxStatementsPerConnection -> 100, minPoolSize -> 1, neste
dDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@139eeda [ description
-> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 13
9eeda, jdbcUrl -> jdbc:mysql://localhost/l2jdb, properties -> {user=******, pass
word=******} ], preferredTestQuery -> null, propertyCycle -> 300, testConnection
OnCheckin -> true, testConnectionOnCheckout -> false, usesTraditionalReflectiveP
roxies -> false ], factoryClassLocation -> null, identityToken -> ca0115, numHel
perThreads -> 3 ]
Loaded 127 server names
GameServerTable: Loaded 2 servers (max id:1)
Stored 10 Keypairs for gameserver communication
Hostname for external connections is: 192.168.66.66
Hostname for internal connections is: 192.168.66.66
LoginContoller initating
Stored 10 KeyPair for RSA communication
Ok, Listening for gameServer on port 9014
2 banned IPs defined
Stand Alone LoginServer Listening on port 2106
Telnet server is currently disabled.

Starting C4 RT-Team Game Server.

loading gameserver config
loading ./config/sayfilter.txt
[color=Red]java.io.FileNotFoundException: .\config\l2jmods.properties (═х єфрхЄё- эрщЄш єър[/color]
чрээ√щ Їрщы)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(Unknown Source)
        at net.sf.l2j.Config.load(Config.java:1689)
        at net.sf.l2j.gameserver.GameServer.main(GameServer.java:556)
[COLOR="Red"]Exception in thread "main" java.lang.Error: Failed to Load ./config/l2jmods.prop
erties File.[/COLOR]        at net.sf.l2j.Config.load(Config.java:1708)
        at net.sf.l2j.gameserver.GameServer.main(GameServer.java:556)

Server terminated abnormaly


server terminated

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

Прошу совета

УПС. Тупой вопрос, уже сам догнал

[PROGRAMMATOR]

Skyinfirecla, это не данные, а их тип.

[RavenCore]

Поставил все по мануалу, логин сервер нормально запускается и функционирует, а вот геймсервер неработает, в игре они в шауте, а консоль выдает вот это:

Лог консоли

"Starting L2J Game Server.

Loading GameServer Configuration Files...
L2Properties: Missing property for key - DatapackRoot
Loading mmo.properties
L2Properties: Missing property for key - IOSelectorThreadCount
Loaded 6 Filter Words.
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 [ java.beans
.IntrospectionException: java.lang.reflect.InvocationTargetException [numThreads
AwaitingCheckoutDefaultUser] ]
Exception in thread "main" java.sql.SQLException: Access denied for user 'root'@
'localhost' (using password: NO)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1072)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4001)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2183)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:784)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
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:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:354)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:284)
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.l2jserver.L2DatabaseFactory.<init>(L2DatabaseFactory.java:96)
at com.l2jserver.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:20
7)
at com.l2jserver.gameserver.GameServer.main(GameServer.java:499)
Server terminated abnormaly
server terminated
Для продолжения нажмите любую клавишу . . ."

Добавлю, что при переустановке, выдает вот это:

Лог при установке базы

There was some problem while executing:

""C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe" -h localhost -u root -
-password=root -D l2jcb < community_install.sql 2> NUL"

I'd suggest you to look for correct values and try this
script again later. But maybe you'd prefer to go on now.

©ontinue running the script

®econfigure

(q)uit now

Choose (default quit):

Подскажите пожалуйста в чем у меня проблема.
Заранее спс.

[PROGRAMMATOR]

В пароле к mysql проблема, судя по всему в настройках игрового сервера его вообще не указали, а при установке community, используется бд l2jcb, ее видимо не создали.

[BeTepBeTepOK]

У меня вопрос.
Я все зделал как написано в мануале НО пишит подождите и не заходит в игру...если мона сразу все возможные прричины назовите .Заранее спс

[Strangeone]

Запускаю Gameserver выдает такое

Starting L2Open Game Server.

Loading GameServer Configuration Files...
Loading mmo.properties
Loaded 6 Filter Words.
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 -> 1hge15w88crohxg1upuhir|17653ae, debugUnreturnedConnectionStackTraces
-> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClas
sLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken ->
1hge15w88crohxg1upuhir|17653ae, idleConnectionTestPeriod -> 3600, initialPoolSiz
e -> 10, jdbcUrl -> jdbc:mysql://localhost/l2jdb, maxAdministrativeTaskTime -> 0
, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, ma
xPoolSize -> 100, maxStatements -> 0, maxStatementsPerConnection -> 100, minPool
Size -> 10, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, p
referredTestQuery -> null, properties -> {user=******, password=******}, propert
yCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false
, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
L2J Server Version: 825
L2J Datapack Version: 825
BitSet ID Factory could not be initialized correctly
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jdb.characte
rs' doesn't exist
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:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1051)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2687)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2616)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1464)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyState
ment.java:35)
at ru.l2open.gameserver.idfactory.IdFactory.extractUsedObjectIDTable(IdF
actory.java:335)
at ru.l2open.gameserver.idfactory.BitSetIDFactory.initialize(BitSetIDFac
tory.java:82)
at ru.l2open.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFactory
.java:69)
at ru.l2open.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:114)

at ru.l2open.gameserver.GameServer.<init>(GameServer.java:154)
at ru.l2open.gameserver.GameServer.main(GameServer.java:481)
IDFactory: 102912 id's available.
Could not read object IDs from DB. Please Check Your Data.
Exception in thread "main" java.lang.Exception: Could not initialize the ID fact
ory
at ru.l2open.gameserver.GameServer.<init>(GameServer.java:159)
at ru.l2open.gameserver.GameServer.main(GameServer.java:481)

Когда с логинсервером все в порядке кто тыкнет меня носом в чем моя проблема
заранее благодарю

[Array]

MySQLSyntaxErrorException: Table 'l2jdb.characters' doesn't exist
Could not read object IDs from DB. Please Check Your Data.

Просто перевел бы;
В дб у тебя нету\кривая "characters".