Como utilizar a L2JDream V2.0

[Douglas.]

Você vai precisar de:
MySQL 5.6:

O conteúdo está oculto, favor efetuar login ou se cadastrar!

• Entre
• ou
• Cadastre-se

Java JRE 8:

O conteúdo está oculto, favor efetuar login ou se cadastrar!

• Entre
• ou
• Cadastre-se

L2JDream V2:

O conteúdo está oculto, favor efetuar login ou se cadastrar!

• Entre
• ou
• Cadastre-se

1º - Primeiro abra seu navicat e crie uma db chamada dream.

2º - Vá na pasta onde a sua revisão compilada está e extraia a mesma.
Após a extração devera ficara assim:

3º - Então abra a pasta sql.
Clique com o botão direito sobre dbinstall.bat e clique em editar.

@echo off
title Database: Installer

REM #--------------------------------------------
REM # Settings
REM #--------------------------------------------
set mysqlBinPath=C:\Program Files\MySQL\MySQL Server 5.6\bin
set DateT=%date%
REM #--------------------------------------------
set user=root
set pass=
set db=dream
set host=localhost
set backup=backup
REM #--------------------------------------------
set mysqldumpPath="%mysqlBinPath%\mysqldump"
set mysqlPath="%mysqlBinPath%\mysql"
REM #--------------------------------------------

:Begin
@cls
echo.#--------------------------------------------
echo.# Databse Installer Dream Files
echo.#--------------------------------------------
echo.# 1 - Install database.
echo.# 2 - Install custom tables.
echo.# 3 - Make backup all tables.
echo.# 4 - Exit.
echo.#--------------------------------------------
echo.

set Beginprompt=x
set /p Beginprompt=Choice:
if /i %Beginprompt%==1 goto install
if /i %Beginprompt%==2 goto custom
if /i %Beginprompt%==3 goto backup
if /i %Beginprompt%==4 goto exit
goto Begin


:install
@cls
echo.#--------------------------------------------
echo.# Delete old Databse
echo.#--------------------------------------------
echo.
echo Old tables on %db% deleting!
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < tools/cleanup.sql
echo.
echo ..Done!
echo.
pause
goto installpart2


:installpart2
@cls
echo.#--------------------------------------------
echo.# Install new Databse
echo.#--------------------------------------------
echo.
echo ~*Database is being installed*~
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < login/accounts.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < login/gameservers.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/account_data.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/armor.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/auction.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/auction_bid.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/auction_watch.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/auto_announcements.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/castle.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/castle_door.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/castle_doorupgrade.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/castle_functions.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/castle_manor_procure.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/castle_manor_production.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/castle_siege_guards.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/characters.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_blocks.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_data.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_friends.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_hennas.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_herolist.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_macroses.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_mail.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_quests.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_quests_item.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_raid_points.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_recipebook.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_recommends.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_shortcuts.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_skills.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_skills_save.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_subclasses.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_teleports.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/character_items.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/char_creation_items.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/clanhall.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/clanhall_functions.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/clanhall_siege.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/clan_data.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/clan_notices.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/clan_privs.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/clan_skills.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/clan_subpledges.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/clan_wars.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/class_list.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/couples.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/cursed_weapons.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/droplist.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/etcitem.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/fishing_championship.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/fishing_championship_date.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/fort.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/fortsiege_clans.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/fort_doorupgrade.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/fort_functions.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/fort_siege_guards.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/fort_spawnlist.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/fort_staticobjects.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/forums.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/games.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/global_tasks.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/gm_audit.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/grandboss_intervallist.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/henna.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/henna_trees.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/heroes.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/items.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/items_on_ground.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/item_attributes.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/item_icons.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/lastimperialtomb_spawnlist.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/merchants.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/merchant_buylists.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/merchant_shopids.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/npc.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/npcskills.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/obj_restrictions.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/olympiad_nobles.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/olympiad_nobles_eom.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/petitions.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/pets.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/pets_skills.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/posts.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/quest_global_data.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/raidboss_spawnlist.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/random_spawn.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/random_spawn_loc.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/server_data.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/service_log.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/seven_signs.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/seven_signs_festival.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/seven_signs_status.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/siege_clans.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/skill_residential.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/spawnlist.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/temporaryobjecttable.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/topic.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/vanhalter_spawnlist.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < server/weapon.sql

echo.
echo Database installed successfully!

pause
goto Begin

:custom
@cls
echo Instaling custom tables...
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < custom/custom_armor.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < custom/custom_armorsets.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < custom/custom_droplist.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < custom/custom_etcitem.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < custom/custom_merchant_buylists.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < custom/custom_merchant_shopids.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < custom/custom_npc.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < custom/custom_npcskills.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < custom/custom_spawnlist.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < custom/custom_teleports.sql
%mysqlPath% -h %host% -u %user% --password=%pass% -D %db% < custom/custom_weapon.sql

echo Custom tables installed successfully.

pause
goto Begin

:backup
set cmdline=
@cls
echo Making Backup of all tables...
set cmdline="%mysqldumpPath%" --add-drop-table -h %host% -u %user% --password=%pass% %db% ^> "database_backup.sql" 2^> NUL
%cmdline%
echo Backup of all tables successfully.

pause
goto Begin

:exit

-----------------------------------------------------------------------------------------

set mysqlBinPath=C:\Program Files\MySQL\MySQL Server 5.6\bin (aqui é o caminho a onde está seu mysql, o mysql que a dream usa é o 5.1) o que muda geralmente é o local e não pode se esquecer da pasta bin do final)
set DateT=%date%

------------------------------------------------------------------------------------------

set user=root Usuário do banco de dados
set pass= Senha do banco de dados
set db=dream Nome do banco de dados não aconselhado mexer
set host=localhost

------------------------------------------------------------------------------------------

4º - Salve as configurações e abra o dbinstall.bat de forma normal.

Pressione o botão 1 para instalar o banco de dados
Alguns instantes depois ira aparecer "pressione qualquer tecla para continuar" aperte qualquer tecla e espere (é um processo um pouco lento de acordo com seu pc). E de novo ira aparecer "pressione qualquer tecla para continuar".
Também tem algumas tabelas para facilitar o manejo no banco de dados pressione 2 e enter e repita o mesmo processo

5º - Criando comunicação entre login e gameserver.
Volte a pasta raiz de sua revisão e abra a pasta login e abra register.bat
Após abrir irá aparecer isso.

Aperte o botão de número e depois enter, de acordo com a lista de nome disponíveis.
Após ser feito isso sera criado um arquivo chamado hexid(server "x")
Edite este nome para apenas hexid e copie ele para a pasta game\config

<server id="1" name="Bartz" />
<server id="2" name="Sieghardt" />
<server id="3" name="Kain" />
<server id="4" name="Lionna" />
<server id="5" name="Erica" />
<server id="6" name="Gustin" />
<server id="7" name="Devianne" />
<server id="8" name="Hindemith" />
<server id="9" name="Teon (EURO)" />
<server id="10" name="Franz (EURO)" />
<server id="11" name="Luna (EURO)" />
<server id="12" name="Sayha" />
<server id="13" name="Aria" />
<server id="14" name="Phoenix" />
<server id="15" name="Ceriel" />
<server id="16" name="Fehyshar" />
<server id="17" name="Elhwynna" />
<server id="18" name="Ellikia" />
<server id="19" name="Shikken" />
<server id="20" name="Scryde" />
<server id="21" name="Frikios" />
<server id="22" name="Ophylia" />
<server id="23" name="Shakdun" />
<server id="24" name="Tarziph" />
<server id="25" name="Aria" />
<server id="26" name="Esenn" />
<server id="27" name="Elcardia" />
<server id="28" name="Yiana" />
<server id="29" name="Seresin" />
<server id="30" name="Tarkai" />
<server id="31" name="Khadia" />
<server id="32" name="Roien" />
<server id="33" name="Kallint (Non-PvP)" />
<server id="34" name="Cedric" />
<server id="35" name="Nerufa" />
<server id="36" name="Asterios" />
<server id="37" name="Orfen" />
<server id="38" name="Mitrael" />
<server id="39" name="Thifiel" />
<server id="40" name="Lithra" />
<server id="41" name="Lockirin" />
<server id="42" name="Kakai" />
<server id="43" name="Cadmus" />
<server id="44" name="Athebaldt" />
<server id="45" name="Blackbird" />
<server id="46" name="Ramsheart" />
<server id="47" name="Esthus" />
<server id="48" name="Vasper" />
<server id="49" name="Lancer" />
<server id="50" name="Ashton" />
<server id="51" name="Waytrel" />
<server id="52" name="Waltner" />
<server id="53" name="Tahnford" />
<server id="54" name="Hunter" />
<server id="55" name="Dewell" />
<server id="56" name="Rodemaye" />
<server id="57" name="Ken Rauhel" />
<server id="58" name="Ken Abigail" />
<server id="59" name="Ken Orwen" />
<server id="60" name="Van Holter" />
<server id="61" name="Desperion" />
<server id="62" name="Einhovant" />
<server id="63" name="Schuneimann" />
<server id="64" name="Faris" />
<server id="65" name="Tor" />
<server id="66" name="Carneiar" />
<server id="67" name="Dwyllios" />
<server id="68" name="Baium" />
<server id="69" name="Hallate" />
<server id="70" name="Zaken" />
<server id="71" name="Core" />

6º - Criando contas.
Para deixar a criação de conta automática vá em: login\config\main\loginserver.properties
procure por:

# Automatically register accounts
AutoCreateAccounts = False <----- True

7º - Ligando Login.
Abra a pasta login.
E execute o arquivo login.bat

8º - Ligando Game.
Abra a pasta game.
E execute o arquivo game.bat

 

9º - Criando char admin, primeiro crie seu char e vá em "game\config\admin\access\example.cfg

 

#=======================================#

# Server Admin Settings

#=======================================#

# Number of character (charId)

# You can see it in the database

CharId = 0 (navicat abra a sql characters lá vai estar id)

# Has a Root Admin, access to all the commands

# If set to True, then the isAdmin is True

isRoot = False <---- Coloque true

Isso tem no fórum projeto decidi postar pois tem muitos membros com dificuldades!

Editado Janeiro 16, 2016 por Douglas.

[Revoltad0-]

Não conseguir baixar , tem outro link ?

[Douglas.]

Baixar o que amigo? A rev você tem que fazer cadastro no fórum do projeto.

[DemonikaBR-Marcos]

Boa Douglas, vlw eu ja estava pensando em fazer.

Não esqueça de falar que a maioria dos iniciantes usa o tuto do kelvin e por padrão não usam senha no mysql, então tem que tirar no DBInstall. abraço.

[celestiano]

porque vc não ensina como coloca um admin na l2jdream, tem muita gente com dificuldade nisso.

[SCRASH0]

BAIXEI O JAVA JRE 8

O MAYSQL 5.6

MESMO ASSIM N LIGA O SERVER TA DANDO FATAL ERROR NO JAVA

[DemonikaBR-Marcos]

porque vc não ensina como coloca um admin na l2jdream, tem muita gente com dificuldade nisso.

1º Crie um personagem

2º Deslogue com o mesmo e abra o navicat

3º abra a table characters e localize a linha do seu personagem

4º copie o CharID dele.

5º abra o caminho L2jDream\game\config\admin\access note que tem um arquivo em CFG com nome exemplo. Abra-o e edite-o.

 

 

 

#=======================================#

# Server Admin Settings

#=======================================#

# Number of character (charId)

# You can see it in the database

CharId = COLE O CharID AQUI

# Has a Root Admin, access to all the commands

# If set to True, then the isAdmin is True

isRoot = True

# Plain administrator, with disabilities

# If set to False, and does not include the isRoot, then an admin will disable

isAdmin = True

# Ability to own resurrection on place of death

# If set to True, then after the death of admin will be able to ressurrection

FixedRes = True

# Ability to call the admin menu Alt + G

# If set to True, then the admin will be able to invoke a popup menu

AllowAltG = True

# Ability to attack players in a peaceful zone

# If set to True, then the admin will be able to attack players in any zone

AllowPeaceAtk = True

# Activate access only on specified IP addresses

# If selected, the status of the GM'a is put only on the specified IP

# You can specify several IP, example: 127.0.0.1; 192.168.1.1

CheckIp = False

SecureIp = 127.0.0.1; 192.168.1.1

#=======================================#

# List of allowed commands for GMs

#=======================================#

//admin

//announce

 

 

6º salve o arquivo com o nome exato do personagem com a extensão .cfg.

 

7º restart no server e logue seu ADM.

 

8º agradeça pela ajuda.

 

 

 

BAIXEI O JAVA JRE 8

O MAYSQL 5.6

MESMO ASSIM N LIGA O SERVER TA DANDO FATAL ERROR NO JAVA

 

posta o Erro completo.

[SCRASH0]

tai o error

 

 

 

 

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv

erConnectionFactory.java:38)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable

ConnectionFactory.java:582)

at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas

icDataSource.java:1556)

at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFacto

ry(BasicDataSource.java:1545)

... 8 more

[FATAL 2016-02-06 12:13:22]: L2DatabaseFactory: Failed to retrieve database conn

ection!

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFact

ory (Unknown system variable 'language')

at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFacto

ry(BasicDataSource.java:1549)

at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou

rce.java:1388)

at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource

.java:1044)

at com.dream.L2AuthDatabaseFactory.getConnection(L2AuthDatabaseFactory.j

ava:140)

at com.dream.L2AuthDatabaseFactory.getConnection(L2AuthDatabaseFactory.j

ava:131)

at com.dream.auth.manager.GameServerManager.load(GameServerManager.java:

152)

at com.dream.auth.manager.GameServerManager.<init>(GameServerManager.jav

a:66)

at com.dream.auth.manager.GameServerManager.getInstance(GameServerManage

r.java:44)

at com.dream.gsregistering.GameServerRegister.main(GameServerRegister.ja

va:49)

Caused by: java.sql.SQLException: Unknown system variable 'language'

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)

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

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

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

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

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499)

at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1432)

at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java

:3870)

at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImp

l.java:3284)

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2

293)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079)

at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)

at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)

at sun.reflect.GeneratedConstructorAccessor2.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:400)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java

:325)

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv

erConnectionFactory.java:38)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable

ConnectionFactory.java:582)

at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas

icDataSource.java:1556)

at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFacto

ry(BasicDataSource.java:1545)

... 8 more

[FATAL 2016-02-06 12:13:22]: L2DatabaseFactory: Failed to retrieve database conn

ection!

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFact

ory (Unknown system variable 'language')

at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFacto

ry(BasicDataSource.java:1549)

at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou

rce.java:1388)

at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource

.java:1044)

at com.dream.L2AuthDatabaseFactory.getConnection(L2AuthDatabaseFactory.j

ava:140)

at com.dream.L2AuthDatabaseFactory.getConnection(L2AuthDatabaseFactory.j

ava:131)

at com.dream.auth.manager.GameServerManager.load(GameServerManager.java:

152)

at com.dream.auth.manager.GameServerManager.<init>(GameServerManager.jav

a:66)

at com.dream.auth.manager.GameServerManager.getInstance(GameServerManage

r.java:44)

at com.dream.gsregistering.GameServerRegister.main(GameServerRegister.ja

va:49)

Caused by: java.sql.SQLException: Unknown system variable 'language'

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)

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

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

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

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

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499)

at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1432)

at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java

:3870)

at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImp

l.java:3284)

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2

293)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079)

at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)

at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)

at sun.reflect.GeneratedConstructorAccessor2.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:400)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java

:325)

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv

erConnectionFactory.java:38)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable

ConnectionFactory.java:582)

at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas

icDataSource.java:1556)

at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFacto

ry(BasicDataSource.java:1545)

... 8 more

[FATAL 2016-02-06 12:13:22]: L2DatabaseFactory: Failed to retrieve database conn

ection!

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFact

ory (Unknown system variable 'language')

at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFacto

ry(BasicDataSource.java:1549)

at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou

rce.java:1388)

at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource

.java:1044)

at com.dream.L2AuthDatabaseFactory.getConnection(L2AuthDatabaseFactory.j

ava:140)

at com.dream.L2AuthDatabaseFactory.getConnection(L2AuthDatabaseFactory.j

ava:131)

at com.dream.auth.manager.GameServerManager.load(GameServerManager.java:

152)

at com.dream.auth.manager.GameServerManager.<init>(GameServerManager.jav

a:66)

at com.dream.auth.manager.GameServerManager.getInstance(GameServerManage

r.java:44)

at com.dream.gsregistering.GameServerRegister.main(GameServerRegister.ja

va:49)

Caused by: java.sql.SQLException: Unknown system variable 'language'

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)

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

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

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

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

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499)

at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1432)

at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java

:3870)

at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImp

l.java:3284)

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2

293)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079)

at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)

at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)

at sun.reflect.GeneratedConstructorAccessor2.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:400)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java

:325)

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv

erConnectionFactory.java:38)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable

ConnectionFactory.java:582)

at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas

icDataSource.java:1556)

at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFacto

ry(BasicDataSource.java:1545)

... 8 more

[FATAL 2016-02-06 12:13:22]: L2DatabaseFactory: Failed to retrieve database conn

ection!

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFact

ory (Unknown system variable 'language')

at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFacto

ry(BasicDataSource.java:1549)

at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou

rce.java:1388)

at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource

.java:1044)

at com.dream.L2AuthDatabaseFactory.getConnection(L2AuthDatabaseFactory.j

ava:140)

at com.dream.L2AuthDatabaseFactory.getConnection(L2AuthDatabaseFactory.j

ava:131)

at com.dream.auth.manager.GameServerManager.load(GameServerManager.java:

152)

at com.dream.auth.manager.GameServerManager.<init>(GameServerManager.jav

a:66)

at com.dream.auth.manager.GameServerManager.getInstance(GameServerManage

r.java:44)

at com.dream.gsregistering.GameServerRegister.main(GameServerRegister.ja

va:49)

Caused by: java.sql.SQLException: Unknown system variable 'language'

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)

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

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

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

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

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499)

at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1432)

at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java

:3870)

at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImp

l.java:3284)

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2

293)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079)

at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)

at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)

at sun.reflect.GeneratedConstructorAccessor2.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:400)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java

:325)

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv

erConnectionFactory.java:38)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable

ConnectionFactory.java:582)

at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas

icDataSource.java:1556)

at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFacto

ry(BasicDataSource.java:1545)

... 8 more

[FATAL 2016-02-06 12:13:22]: L2DatabaseFactory: Failed to retrieve database conn

ection!

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFact

ory (Unknown system variable 'language')

at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFacto

ry(BasicDataSource.java:1549)

at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou

rce.java:1388)

at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource

.java:1044)

at com.dream.L2AuthDatabaseFactory.getConnection(L2AuthDatabaseFactory.j

ava:140)

at com.dream.L2AuthDatabaseFactory.getConnection(L2AuthDatabaseFactory.j

ava:131)

at com.dream.auth.manager.GameServerManager.load(GameServerManager.java:

152)

at com.dream.auth.manager.GameServerManager.<init>(GameServerManager.jav

a:66)

at com.dream.auth.manager.GameServerManager.getInstance(GameServerManage

r.java:44)

at com.dream.gsregistering.GameServerRegister.main(GameServerRegister.ja

va:49)

Caused by: java.sql.SQLException: Unknown system variable 'language'

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)

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

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

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

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

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499)

at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1432)

at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java

:3870)

at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImp

l.java:3284)

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2

293)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079)

at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)

at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)

at sun.reflect.GeneratedConstructorAccessor2.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:400)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java

:325)

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv

erConnectionFactory.java:38)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable

ConnectionFactory.java:582)

at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas

icDataSource.java:1556)

at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFacto

ry(BasicDataSource.java:1545)

... 8 more

 

 

Editado Março 26, 2017 por Tayran.JavaDev
adicionando [spoiler]

[Lineage2Renewal]

 

tai o error

 

 

niguem resolveu ainda esse pqp :@

Editado Março 26, 2017 por Tayran.JavaDev
Removendo citação.

[SCRASH0]

Errou Resolvido.

O Problema Tava No Mysql.

use o 5.1 que da certo.

Editado Fevereiro 26, 2017 por admhoro

[edyysk8_L2j]

Boa noite gostaria de saber se nesse projeto ja tem L2Waker Protection !