Cum sa faci server de Lineage ][ Gracia

In acest topic va voi arata cum se face un server de Lineage2 Gracia

Aveti nevoie de :

1. Mysql

2. Java

3. Navicat

4. Gracia Server Pack



Pasul 1 : Instalam Mysql ca in urmatoarele printuri

























Acum vom instala Navicat , la fel ca in urmatoarele printuri !





























Acum Configurarea Serverului :





Intrati in \Gracia_server_pack\Gracia server pack\tools si dati click
dreapta pe database installer,dati edit si scrieti ca in printu urmator





apoi deschideti database_installer si faceti ca in printul urmator

Nota: dupa ce dati reconfigure scrieti la mysql path C:\Program
Files\Mysql\Mysql Server 5.0\bin sau unde aveti voi folderul bin,am
uitat sa fac print !

















acum mergem sa configuram serverul:

intrati in \Gracia_server_pack\Gracia server pack\loginserver\config

si inlocuiti ca aici





acum intram in \Gracia_server_pack\Gracia server pack\gameserver\config si configuram asa:



intram in \Gracia_server_pack\Gracia server pack\loginserver si deschidem registergameserver.bat

si configuram asa:



redenumim hexid(server1) in hexid si il copiem in gameserver in gameserver\config



Acum porniti serverul cu StartGameserver.bat si StartLoginServer.bat

intii gameserver si apoi loginserver pt a evita unele probleme .



print screen la server gata facut :



succes!

pentru a configura serverul intrati in GameServer\config
_________________
Voi toti radeti de mine ca sunt diferit,iar eu rad de voi ca sunteti toti la fel =)))

ma frate am facut toate pasurile merge serveru imi arata la start server cum ai tu dar eu cum draq ma loghez in game ?
si 2 cum fak patchu?eu incerc sa ma loghez si imi da eroare de la game guard

THERE WAS A PROBLEM RUNNING GAME GUARD(ERROR CODE=610



CE AM EU IN HOSTS FILE:

89.41.232.131 localhost
89.41.232.131 L2authd.Lineage2.com
89.41.232.131 nProtect.lineage2.com

RASP SI U CAND POTI PLSSSSSS MS NE AUZIM

ALA E IP UL MEU NU E ALT IP...

DECI FARA SA SCHIMB NIMIK IN HOSTS MAI INTAI IMI ARATA:
THE GAME GUARD UPDATE WAS CANCELED PLEASE CHECK YOUR NETWORK CONNECTIONS STATUS OR FIREWELL
SI DUPA AIA IM ARATA CE AM SCRIS IN CELALALT POST

OK CHECK FILES AM DAT A FACUT TREABA SI TOT NIMIK ACEEASI EROAREx(

Starting L2J Login Server.

INFO : loading login config
INFO : MLog clients using log4j logging.
INFO : Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace
: 10]
INFO : Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acq
uireIncrement -> 5, acquireRetryAttempts -> 0, acquireRetryDelay -> 500, autoCom
mitOnClose -> true, automaticTestTable -> connection_test_table, breakAfterAcqui
reFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null,
connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester,
dataSourceName -> pxcdwc83sbj8hs1kvjdw0|b2002f, debugUnreturnedConnectionStackTr
aces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factor
yClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToke
n -> pxcdwc83sbj8hs1kvjdw0|b2002f, idleConnectionTestPeriod -> 60, initialPoolSi
ze -> 3, jdbcUrl -> jdbc:mysql://localhost/l2jdb, maxAdministrativeTaskTime -> 0
, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, ma
xPoolSize -> 20, maxStatements -> 0, maxStatementsPerConnection -> 100, minPoolS
ize -> 1, numHelperThreads -> 20, numThreadsAwaitingCheckoutDefaultUser -> 0, pr
eferredTestQuery -> null, properties -> {user=******, password=******}, property
Cycle -> 0, testConnectionOnCheckin -> true, testConnectionOnCheckout -> false,
unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
INFO : Loaded 127 server names
INFO : LoginManager initiating
INFO : Cached 10 KeyPairs for RSA communication
INFO : RandomIntGenerator: initialized
INFO : Stored 20 keys for Blowfish communication
INFO : GameServerManager: Loaded 2
INFO : Cached 10 RSA keys for Game Server communication.
INFO : BanManager: Loaded 3 banned ip/subnet(s).
INFO : Listening for GameServers on 127.0.0.1:9014
INFO : Telnet server is currently disabled.
INFO : Login Server ready on 127.0.0.1:2106
INFO : Updated Gameserver [2] Sieghardt IP's:
INFO : 127.0.0.1
INFO : 127.0.0.1
WARN : SQL Error: 1054, SQLState: 42S22
ERROR : Unknown column 'accounts0_.lastServerId' in 'field list'
WARN : The account [parvu_deva] was not found in account table.could not load an
entity: [net.sf.l2j.loginserver.beans.Accounts#parvu_deva]
WARN : SQL Error: 1054, SQLState: 42S22
ERROR : Unknown column 'accounts_.lastServerId' in 'field list'
Exception in thread "pool-1-thread-2" org.hibernate.exception.SQLGrammarExceptio
n: could not retrieve snapshot: [net.sf.l2j.loginserver.beans.Accounts#parvu_dev
a]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSna
pshot(AbstractEntityPersister.java:1048)
at org.hibernate.engine.StatefulPersistenceContext.getDatabaseSnapshot(S
tatefulPersistenceContext.java:233)
at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:189)
at org.hibernate.event.def.AbstractSaveEventListener.getEntityState(Abst
ractSaveEventListener.java:512)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveO
rUpdate(DefaultSaveOrUpdateEventListener.java:80)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpda
te(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)

at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:495)
at net.sf.l2j.loginserver.dao.impl.BaseRootDAOHib.saveOrUpdate(BaseRootD
AOHib.java:85)
at net.sf.l2j.loginserver.dao.impl.AccountsDAOHib.createOrUpdate(Account
sDAOHib.java:70)
at net.sf.l2j.loginserver.services.AccountsServices.addOrUpdateAccount(A
ccountsServices.java:125)
at net.sf.l2j.loginserver.services.AccountsServices$$FastClassByCGLIB$$9
a1652de.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocatio
n.invokeJoinpoint(Cglib2AopProxy.java:675)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:154)
at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:616)
at net.sf.l2j.loginserver.services.AccountsServices$$EnhancerByCGLIB$$6e
a0cb96.addOrUpdateAccount(<generated>)
at net.sf.l2j.loginserver.manager.LoginManager.handleAccountNotFound(Log
inManager.java:640)
at net.sf.l2j.loginserver.manager.LoginManager.loginValid(LoginManager.j
ava:517)
at net.sf.l2j.loginserver.manager.LoginManager.loginValid(LoginManager.j
ava:481)
at net.sf.l2j.loginserver.manager.LoginManager.tryAuthLogin(LoginManager
.java:292)
at net.sf.l2j.loginserver.clientpackets.RequestAuthLogin.run(RequestAuth
Login.java:122)
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: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown co
lumn 'accounts_.lastServerId' in 'field list'
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:1031)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1737)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1888)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:76)
at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSna
pshot(AbstractEntityPersister.java:1021)
... 27 more




ce trebuie sa fac la eroarea asta?