Problem

zoltir · March 13, 2007

Im making server l2j by: http://www.maxbastards.gr/forum/index.php?topic=889.0

When i try to run RegisterGameServer i have error:

java.sql.SQLException: Incorrect information in file: '.\l2jdb\connection_test_t
able.frm'

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

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

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

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

at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:1153)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:

1266)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr

oxyPreparedStatement.java:76)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu

tomaticTestTable(C3P0PooledConnectionPoolManager.java:778)

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 net.sf.l2j.L2DatabaseFactory.<init>(L2DatabaseFactory.java:112)

at net.sf.l2j.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:183)

at net.sf.l2j.loginserver.GameServerTable.load(GameServerTable.java:127)

at net.sf.l2j.loginserver.GameServerTable.<init>(GameServerTable.java:84

)

at net.sf.l2j.gsregistering.GameServerRegister.main(GameServerRegister.j

ava:42)

Welcome to l2j GameServer Regitering

Enter The id of the server you want to register or type help to get a list of id

s:

Your choice:

What is wrong?

March 13, 2007

go to loginserver and put your root password in root=

also #AcceptNewGameServer = True

jaff · March 13, 2007

only input pass in root= dont make it to true!!!

March 13, 2007

to register the server .. to login slot you must put it TRUE believe me i am makin servers 2 years

jaff · March 13, 2007

OK Mr smarty... but i am telling ya you can register server without setting it to true... cuz i didnt do it and i am playign now!!!

zoltir · March 13, 2007

go to loginserver and put your root password in root=

also #AcceptNewGameServer = True

Hmm you talking about login\config? Cuz in my config file i have:

# 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? => http://l2jserver.com

#

# * = 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 http://www.whatismyip.com

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

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

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

LoginserverPort=2106

LoginTryBeforeBan=100

GMMinLevel=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 = True

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

ShowLicence = True

# Database info

Driver=com.mysql.jdbc.Driver

#Driver=org.hsqldb.jdbcDriver

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

URL=jdbc:mysql://localhost/l2jdb

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

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

Login=root

Password=root

MaximumDbConnections=5

root=root

# Useable values: "true" - "false", use this option to choose whether accounts will be created

# automatically or not.

AutoCreateAccounts=true

# The delay in minutes after which the login updates the gameservers IP's (usefull when their ip is dynamic)

IpUpdateTime=15

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

# Test server setting, shoudnt be touched in online game server

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

Debug = False

Assert = False

Developer = False

# Enforce GG Authorization from client

# Login server will kick client if client bypassed GameGuard authentication

ForceGGAuth=false

#FloodProtection. time in ms

EnableFloodProtection=True

FastConnectionLimit=15

NormalConnectionTime=700

FastConnectionTime=350

MaxConnectionPerIP=50

and still same shit ;/

Btw why login=root? I didnt name it root when i instaled it (just dont see option to change it)

March 14, 2007

... when i go home ... i will help you .. could u upload your login config ?

TheMentaL · March 14, 2007

go inside ur loginserver configs and open loginserver.properties go down and u will find

# Database info

Driver=com.mysql.jdbc.Driver

#Driver=org.hsqldb.jdbcDriver

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

URL=jdbc:mysql://localhost/l2jdb

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

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

Login=root <-------- AND HERE YOUR BATABASE USERNAME ....

Password= ****<------ ADD THERE YOUR DB PASSWORD IF U DONT HAVE LEAVE IT BLANK

MaximumDbConnections=10

Save and exit and run registergameserver again .... ok?

March 14, 2007

jaff.. you must read a guide

zoltir · March 14, 2007

omg next shit >.<

(but its full config file [login]):

# 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? => http://l2jserver.com
#
# * = 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 http://www.whatismyip.com
# ===================================================================================================

# ================================================================
# 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=*
LoginserverPort=2106
LoginTryBeforeBan=100
GMMinLevel=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 = True

# If false, the licence (after the login) will not be shown
ShowLicence = True

# Database info
Driver=com.mysql.jdbc.Driver
#Driver=org.hsqldb.jdbcDriver
#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
URL=jdbc:mysql://localhost/l2jdb
#URL=jdbc:hsqldb:hsql://localhost/l2jdb
#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=
Login=root
Password=root
MaximumDbConnections=10

# Useable values: "true" - "false", use this option to choose whether accounts will be created
# automatically or not.
AutoCreateAccounts=true

# The delay in minutes after which the login updates the gameservers IP's (usefull when their ip is dynamic)
IpUpdateTime=15


# ==============================================================
# Test server setting, shoudnt be touched in online game server
# ==============================================================

Debug = False
Assert = False
Developer = False

# Enforce GG Authorization from client
# Login server will kick client if client bypassed GameGuard authentication
ForceGGAuth=false

#FloodProtection. time in ms
EnableFloodProtection=True
FastConnectionLimit=15
NormalConnectionTime=700
FastConnectionTime=350
MaxConnectionPerIP=50

and problem is with create table:

java.sql.SQLException: Can't create table '.\l2jdb\connection_test_table.frm' (e
rrno: 121)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1153)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1404)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1318)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1303)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:105)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:792)
        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 net.sf.l2j.L2DatabaseFactory.<init>(L2DatabaseFactory.java:112)
        at net.sf.l2j.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:183)
        at net.sf.l2j.loginserver.GameServerTable.load(GameServerTable.java:127)

        at net.sf.l2j.loginserver.GameServerTable.<init>(GameServerTable.java:84
)
        at net.sf.l2j.gsregistering.GameServerRegister.main(GameServerRegister.j
ava:42)
Welcome to l2j GameServer Regitering
Enter The id of the server you want to register or type help to get a list of id
s:
Your choice:

i try to change login-root to login=l2jbd (name of base) but still nothing.

killer_007 · March 14, 2007

What files do you use? The files from that topic aren't c4 but c5, as silthrim upgraded his pack a looooong time ago. And, as i know, he put a nice diskw system. So that guide, is almost 100% out of date. Use start.bat, then install your db (use http://localhost/a/ and create a l2jdb and then installer.bat in tools folder), run registergameserver.bat and finally startloginserver.bat and gameserver.bat The errors show that it can't connect to l2jdb. Make sure you named your db like this. If you want c4, use panters pack (search, i posted it yesterday) or for C5 use my ready pack. (note that the c4 to c5 update of this pack was on 20 December, if you have downloaded these files before that date, let us know)

zoltir · March 14, 2007

What files do you use? The files from that topic aren't c4 but c5, as silthrim upgraded his pack a looooong time ago. And, as i know, he put a nice diskw system. So that guide, is almost 100% out of date. Use start.bat, then install your db (use http://localhost/a/ and create a l2jdb and then installer.bat in tools folder), run registergameserver.bat and finally startloginserver.bat and gameserver.bat The errors show that it can't connect to l2jdb. Make sure you named your db like this. If you want c4, use panters pack (search, i posted it yesterday) or for C5 use my ready pack. (note that the c4 to c5 update of this pack was on 20 December, if you have downloaded these files before that date, let us know)

uff thx but i have 2 more question:

what ID shoul i put in serverregister? cuz 1 = "To high"; 0 and -1,2,3 ect = "id must be positive" 0_o so ee wtf? ->>>>>>>>>>>>>>>>>>>>> Ok found it.

2. What lvl have admin and GMs (1lvl, 2lvl)

killer_007 · March 14, 2007

1) If you don't fix it, you will get this error. When you fix that, you will be able to choose between 1 and a wide range of possible IDs

2) You can control it in the config folder of gameserver, there is a document with the gm lvls... Admins have 200 access lvl.

zoltir · March 14, 2007

Hmm again somethin wrong. OMG

Login work (i can login) -> accept ruers -> and i see Server Online [Light] Ping 193? :O but when i click OK nothing heppen. why?

killer_007 · March 14, 2007

Put a screen shot of login and game server console ;)

Problem

Recommended Posts

Link to comment

Share on other sites

Guest TheVortex

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest TheVortex

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest TheVortex

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest TheVortex

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Posts

Topics