[Help]Paidia ena provlhma me start server l2j frozen

[yamahaZ125cc]

Paidia eno ta kanw ola swsta install navicat mysql java config ktlp otan anigw to startloginserver mou bgazei afto

 

======================================================================-[ 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: Communications link failure

 

The last packet sent successfully to the server was 0 milliseconds ago. The driv

er has not received any packets from the server.

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link fai

lure

 

The last packet sent successfully to the server was 0 milliseconds ago. The driv

er has not received any packets from the server.

        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.SQLError.createCommunicationsException(SQLError.java:1

116)

        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:346)

        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)

        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:114

)

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

Caused by: java.net.ConnectException: Connection timed out: connect

        at java.net.PlainSocketImpl.socketConnect(Native Method)

        at java.net.PlainSocketImpl.doConnect(Unknown Source)

        at java.net.PlainSocketImpl.connectToAddress(Unknown Source)

        at java.net.PlainSocketImpl.connect(Unknown Source)

        at java.net.SocksSocketImpl.connect(Unknown Source)

        at java.net.Socket.connect(Unknown Source)

        at java.net.Socket.connect(Unknown Source)

        at java.net.Socket.<init>(Unknown Source)

        at java.net.Socket.<init>(Unknown Source)

        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja

va:254)

        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:295)

        ... 24 more

 

LoginServer terminated abnormaly

 

======================================================================-[ 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]

 

 

Alaksa to pack s l2jfrozen alla kai palu ta idia edw toulaxiston boreite n me help i palu oxi ????

 

 

 

 

 

 

 

 

 

[ExCaLiBuR®]

apagoreuete to support sto L2jEqual

 

[yamahaZ125cc]

e gamhseta oti antapokrinete sta sumferonta tn admin k etc epitrepete to support......

[pirama]

lol ayto poy les den kolaei (gt ta pack poy epitrepete to support einai free)

( alla kai na isxioi ayto poy les as bgazoyn kati kai aytoi...emeis pernoyme tsapa help se oti theloyme .aytoi gt na min bgaloun kati afoy den mas epibarinoyn? )

oloi osoi eimaste edw exoyme diabasi toys oroys kai exoyme simfonisi (esy toys diabases toys kanones? )

den toys diabases (an toys eixes diabasi den tha ekanes to topic)

[iCoolStorm®]

lol ayto poy les den kolaei (gt ta pack poy epitrepete to support einai free)

( alla kai na isxioi ayto poy les as bgazoyn kati kai aytoi...emeis pernoyme tsapa help se oti theloyme .aytoi gt na min bgaloun kati afoy den mas epibarinoyn? )

oloi osoi eimaste edw exoyme diabasi toys oroys kai exoyme simfonisi (esy toys diabases toys kanones? )

den toys diabases (an toys eixes diabasi den tha ekanes to topic)

File mou exeis dikio alla elaxistoi diavazoun kanones...

[yamahaZ125cc]

Wraia exete dikeo ante n doume se afto to pack p epitrepete ama vroume kamia lish twra... en anagh 8a sas plhrwsw kiolas re alania 1tsakalaki n help plz. allaksa to pack s frozen opws 8a dite alla palu to idio.......

[pirama]

twra mporoyme :)

pio update toy Frozen exeis? to ekanes compile? h to pires etimo ?

pio java kai pio Mysql exeis ?

apo java thes Jdk6 h 7 analoga to pack.....

mysql tha protina to 5.5 poy kserw oti einai simbato...

 

Edit : apo oti blepw to error soy einai stin sindesi opote mpori na theloyn anigma ta port sta windows h sto router soy

dokimases na ton aniksis me 127.0.0.1? sto game server kai sto login server?

 

Edit 2 : sto gameserver kai login server config sigoyra exeis bali sosti diadromi tis db ,username kai pass?

[yamahaZ125cc]

username pass einai swsta gia to pack to katevasa etimo apo edw mysql exw to 5.5  java to jdk 6.0.310 a kai to exw se 127.0.0.1 giati dn exw kanei port k palu dn anigei

 

[pirama]

h diadromi tis db einai sosti pano apo to username grafi

URL = jdbc:mysql://localhost/l2jfrozen px

to idio einai kai sto loginserver kai ston game server

 

Edit : an den ftiaxti etsi perase kai to jdk7 gia sigoyria

[yamahaZ125cc]

login server

# 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 = *

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/loginserver_beta

#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 - <----------- EDW TO PASS TIS MYSQL

Password = root

# maximum number of simultaneous connecting to the database

MaximumDbConnections = 50

 

 

Game Server

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

GameserverHostname = *

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 = gameserver_beta

LoginserverDB = loginserver_beta

 

# Login - Mysql's user

Login = root

# Password - <------------- EDW TO PASS TIS MYSQL

Password = root

# Attention: lazy init connections disabled!

# Please, set only real values for your database

# Default: 100

MaximumDbConnections = 50

 

Epidei dn to epiasa kala afto p eipes prin des k pes m ti prepei n kanw an einai swsta opws ta evala..

 

Edit:Suggnwmh kiolas aderfe apla eimai kapws polu kenourgios s afta..

[pirama]

# 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 = *

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/loginserver_beta            <------ edw to name tis db toy login server soy

#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 - <----------- EDW TO PASS TIS MYSQL

Password = root                                  <------edw to pass anti gia (root)

# maximum number of simultaneous connecting to the database

MaximumDbConnections = 50

 

 

Game Server

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

GameserverHostname = *

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/                  <------kai edw thelei to name tis db toy game server

 

# Database name

GameserverDB = gameserver_beta                <-----ayta edw den nomizw na einai toy frozen :)

LoginserverDB = loginserver_beta                  <-----ayta edw den nomizw na einai toy frozen :)

 

 

# Login - Mysql's user

Login = root

# Password - <------------- EDW TO PASS TIS MYSQL

Password = root        <---------- edw to pass  (zbise to root)

# Attention: lazy init connections disabled!

# Please, set only real values for your database

# Default: 100

MaximumDbConnections = 50

 

exeis lathi miso na sta ftiaksw kai tha kanw edit se 1 min na ta dis

<-----ayta edw den nomizw na einai toy frozen :)

allakseta kai bale to name tis db soy opoy login server gia login opoy gameserver gia game server

[yamahaZ125cc]

tzifos aderfe ola opws mou ta pes alla... drama i katastash drama...

[pirama]

pes moy mia to name tis db soy toy loginserver kai toy gameserver

[yamahaZ125cc]

l2jdb

[pirama]

# 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 = *

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            <------ edw to name tis db toy login server soy

#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 -

Password = root                                  <------edw to pass anti gia (root)

# maximum number of simultaneous connecting to the database

MaximumDbConnections = 50

 

 

Game Server

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

GameserverHostname = *

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/l2jdb                  <------kai edw thelei to name tis db toy game server

 

# Database name

GameserverDB = l2jdb                <-----ayta edw den nomizw na einai toy frozen :)

LoginserverDB = l2jdb                  <-----ayta edw den nomizw na einai toy frozen :)

 

 

# Login - Mysql's user

Login = root

# Password -

Password = root        <---------- edw to pass  (zbise to root)

# Attention: lazy init connections disabled!

# Please, set only real values for your database

# Default: 100

MaximumDbConnections = 50

 

kanta etsi

[yamahaZ125cc]

etc ta exw alla distixos tpt