Problema ao liga Login Serve e Game Serve

[eFFecTSURF]

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

• Entre
• ou
• Cadastre-se

 

Galera ta dando isso ja tirei a senha do login serve e game server , instalei os programas todos sem senhas e nao funciona .

[xxcabeloxx]

deleta esse seu navicat e reinstala vei de deixa ele igual a este !

upa suas imagens nesse site

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

• Entre
• ou
• Cadastre-se

[Just4You]

Esse print n ta pegando o erro todo...

Copia e colca aqui o que aparece no GS.

 

Clica com o botao direito dentro do GS, vai em EDITAR e depois em COPIAR

[eFFecTSURF]

======================================================================-[ 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 [ java.beans

.IntrospectionException: java.lang.reflect.InvocationTargetException [numThreads

AwaitingCheckoutDefaultUser] ]

FATAL: Failed initializing database. Reason: Unknown database 'l2jdb'

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'l2j

db'

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: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(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: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.loginserver.L2LoginServer.<init>(L2LoginServer.java:126

)

at com.l2jfrozen.loginserver.L2LoginServer.main(L2LoginServer.java:57)

LoginServer terminated abnormaly

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

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

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

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

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

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

==================================================================-[ Database ]

Deseja finalizar o arquivo em lotes (S/N)?

[Just4You]

Ele nao esta encontrando a database com o nome l2jdb

 

Verifique como esta no seu arquivo MySQL (Navicat) o nome da sua database criada, e verifique nos arquivos loginserver.properties e gameserver.properties como esta escrito la

[eFFecTSURF]

MEu Loguin

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

# Frozen Dev.Team #

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

# This is the server configuration file. Here you can set up the connection for your server.

# Usually you have to change the ExternalHostname option to

# - 127.0.0.1 (if you want to play alone / testing purpose)

# - LAN IP* (if you want to play from another computer in the network)

# - WAN IP** (if you want to play with friends over internet)

# - Questions? =>

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

• Entre
• ou
• Cadastre-se

#

# * = If you want to get your LAN IP, simply choose "Start" => "Run..." then type "cmd" => "ipconfig"

# **= If you want to get you WAN IP, visit

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

• Entre
• ou
• Cadastre-se

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

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

# General server setting !!! REQUIRED to configure to everyone !!!

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

# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname

ExternalHostname = 127.0.0.1

# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname

InternalHostname = 127.0.0.1

# Bind ip of the loginServer, use * to bind on all available IPs

LoginserverHostname = 127.0.0.1

LoginserverPort = 2106

# How many times you can provide an invalid account/pass before the IP gets banned

LoginTryBeforeBan = 20

# Time you won't be able to login back again after LoginTryBeforeBan tries to login. Provide a value in seconds. Default 10min. (600)

LoginBlockAfterBan = 600

GMMinLevel = 100

# The address on which login will listen for GameServers, use * to bind on all available IPs

LoginHostname = 127.0.0.1

# The port on which login will listen for GameServers

LoginPort = 9014

# If set to True any GameServer can register on your login's free slots

AcceptNewGameServer = False

# If False, the licence (after the login) will not be shown

# It is highly recomended for Account Seciurity to leave this option as defalut (True)

ShowLicence = True

# Database Pool Type

# Possible Values: c3p0 or BoneCP

# c3p0: more stable

# BoneCP: more performance

DatabasePoolType = c3p0

# Database info

Driver = com.mysql.jdbc.Driver

#Driver=org.hsqldb.jdbcDriver

#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

# Database Settings

URL = jdbc:mysql://localhost/l2jdb

#URL=jdbc:hsqldb:hsql://localhost/l2jdb

#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=

# Parameters Databases - MYSQL

# Login - Mysql's user

Login = root

# Password - Mysql's Password

Password =

# maximum number of simultaneous connecting to the database

MaximumDbConnections = 50

# Default: 0

MaximumDbIdleTime = 0

# The timeout before a new connection to the database (in ms)

# default 0 disabled

TimeOutConDb = 0

# Sets number of partitions to use. - BoneCP

# In order to reduce lock contention and thus improve performance,

# each incoming connection request picks off a connection from a pool that has thread-affinity,

# i.e. pool[threadId % partition_count]. The higher this number, the better your performance will be for the case

# when you have plenty of short-lived threads. Beyond a certain threshold, maintenance of these pools will start

# to have a negative effect on performance (and only for the case when connections on a partition start running out).

PartitionCount = 3

# Limit fast connections (input username / password)

FastConnectionLimit = 15

# Time of the normal connection (in ms)

NormalConnectionTime = 700

# Time fast connection (in ms)

FastConnectionTime = 350

# Maximum connections with the 1st IP

MaxConnectionPerIP = 50

# The lifetime of the session with the login server.

SessionTTL = 25000

MaxSessions = 100

# Choose the option: "true", to create an account when logging in automatically

AutoCreateAccounts = True

# Time to renew the IP address of the server in minutes (for dynamic IP)

IpUpdateTime = 0

# The configuration of the local subnet

# Example : 192.168

# Ppimer : 10.1

NetworkList = 192.168.;10.0.

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

# Test server configuration, not to switch on the game server! =

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

# Use the GG client authentication

# Login server access let the client without GameGuard

ForceGGAuth = False

# Including protection from flood

# IMPORTANT: Put True for server security.

EnableFloodProtection = True

# Enable mode "debugging"

# With debug you will see more log on console and more messages in game.

Debug = False

# Switched on "development"

Developer = False

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

# Anti Ddos protection.

# This system works with iptables

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

# iptables -A INPUT -p tcp --dport 7777 -j DROP

# IMPORTANT: Put True for server security.

# IMPORTANT: Active only with LINUX OS.

EnableDdosProSystem = False

# String deny_comms

# IMPORTANT: If you don't know what is it, leave as default

Deny_noallow_ip_ddos = /sbin/iptables -I INPUT 13 -p tcp --dport 7777 -s $IP -j ACCEPT

# Active full log on Login Server console about Ddos protection

Fulllog_mode_print = False

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

# Anti Bruteforce protection. (credits RT-Interlude)

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

#Count of trying connection to server, after which will be made checking IP addres

#for a possible BrutForce

#Reducing this value will increase the likelihood of false positives

#Increasing this value will reduce the effectiveness of security (more chance find passwords for large accounts)

BrutLogonAttempts = 15

#The average time (in seconds) between attempts to connect to the server

#Reducing this value will increase the likelihood of false positives

#Increasing this value will reduce the effectiveness of security (more chance find passwords for large accounts)

BrutAvgTime = 30

#Number of second, for ban IP address, who time BrutAvgTime less specified

#900 second = 15 minute

BrutBanIpTime = 900

Assert = False

EnableAllExceptionsLog = False

DebugPackets = False

MEu Game Serve , Ver se Estar Com Alguma diferença Eu Nao Achei Nao ? Pode Ser Mysql Com problema tbm ? Ou o navicat ?

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

# Game Server Settings #

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

# This is the server configuration file. Here you can set up the connection information for your server.

# This was written with the assumption that you are behind a router.

# Dumbed Down Definitions...

# LAN (LOCAL area network) - typically consists of computers connected to the same router as you.

# WAN (WIDE area network) - typically consists of computers OUTSIDE of your router (ie. the internet).

# x.x.x.x - Format of an IP address. Do not include the x'es into settings. Must be real numbers.

# -----------------------------------------------------------------------------------------------------------------------------------------------------------------

# Networking

# -----------------------------------------------------------------------------------------------------------------------------------------------------------------

# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname

# Common settings...

# 127.0.0.1 - If you are playing alone on a test server

# 192.168.x.x - This is if you are on a 192.168.x.x type network (behind a standard consumer router) and want other computers from JUST the internal network to be able to connect

# x.x.x.x - WAN IP obtained from

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

• Entre
• ou
• Cadastre-se

. This is if you want people outside your internal network to be able to connect to your server.

# If this IP is resolvable by the Login Server, just leave *.

# ----------------------------------------------------------------------------------------

# Enter here (ip) address of your game server, or use the symbol *

GameserverHostname = 127.0.0.1

GameserverPort = 7777

# Configure your external ip

ExternalHostname = 127.0.0.1

# Configure your internal ip

InternalHostname = 127.0.0.1

# Bunch ID and game server. It is better not to change.

LoginPort = 9014

LoginHost = 127.0.0.1

# Database Pool Type

# Possible Values: c3p0 or BoneCP

# c3p0: more stable

# BoneCP: more performance

DatabasePoolType = c3p0

# Parameters Databases - MYSQL

Driver = com.mysql.jdbc.Driver

URL = jdbc:mysql://localhost/

# Database name

GameserverDB = l2jdb

LoginserverDB = l2jdb

# Login - Mysql's user

Login = root

# Password - Mysql's Password

Password =

# Attention: lazy init connections disabled!

# Please, set only real values for your database

# Default: 100

MaximumDbConnections = 50

# Default: 0

MaximumDbIdleTime = 0

# The timeout before a new connection to the database (in ms)

# 0 - to remove restrictions

TimeOutConDb = 0

# The timeout before the single connection must be closed (in ms)

# if a connection life is more then this timeout, a Runtime Exception

# is rised up. Post the exception on forum (www.l2jfrozen.com) to solve

# it.

SingleConnectionTimeOutDb = 200000

# Sets number of partitions to use.- BoneCP

# In order to reduce lock contention and thus improve performance,

# each incoming connection request picks off a connection from a pool that has thread-affinity,

# i.e. pool[threadId % partition_count]. The higher this number, the better your performance will be for the case

# when you have plenty of short-lived threads. Beyond a certain threshold, maintenance of these pools will start

# to have a negative effect on performance (and only for the case when connections on a partition start running out).

PartitionCount = 3

# Setting emulation off the kernel (package SendStatus)

RemoteWhoLog = True

RemoteWhoSendTrash = True

RemoteWhoMaxOnline = 329

RemoteOnlineIncrement = 50

RemoteWhoForceInc = 50

RemotePrivStoreFactor = 12

# Datapack folder

# To exacute the server under debugger with eclipse use:

# DatapackRoot = ../L2jFrozen_DataPack

# or point the folder directly to your server.

DatapackRoot = .

[Just4You]

Sim amigo.. seu login ta certo.. porem a database que voce criou esta com outro nome

[eFFecTSURF]

ta nao mano Estar Com l2jdb

Voçe Tem Team Viwer

[Just4You]

tira print do seu navicat para eu ver e psota aqui

[eFFecTSURF]

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

• Entre
• ou
• Cadastre-se

Ta Aew

Editado Maio 21, 2016 por eFFecTSURF

[phantom]

Game server
URL = jdbc:mysql://localhost/
Tenta assim
URL = jdbc:mysql://localhost/l2jdb

[eFFecTSURF]

Vlw Galera Ajudaram Muito Conseguir Jah , Obrigado xxcabeloxx era isso MEsmo