Jump to content

Recommended Posts

Posted

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?

Guest TheVortex
Posted

go to loginserver and put your root password in root=

 

also #AcceptNewGameServer  = True

Guest TheVortex
Posted

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

Posted

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)

Guest TheVortex
Posted

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

Posted

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?

Posted

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.

Posted

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)

Posted

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)

Posted

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.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Posts

    • Changeset 410 (3371)   Makers, NpcAi / Desires, Cursed Weapon rework, Bugfixes, Admincommands, Movement, Organization   Makers Fix ghost corpses. Introduce task manager for MultiSpawn spawn schedule. Introduce task managers for Npc respawn and despawn tasks. Add missing random treasurebox maker. NpcAi / Desires AttackableAttack > NpcAttack, allowing ATTACK_FINISHED event over Npc. Merge all reduceWeight from NpcAI operations. Don't broadcast MoveToPawn packet for cast hold scenarii. CH and CP managers use hold cast. Probably way more to add. Rework DesireQueue#addOrUpdate to avoid to generate a List. Drop _isInHitAnimation, avoid twice runAI calls upon attack end animation, save a ThreadPool. Implement Desire#isInvalid, used over the main loop to clean invalid Desires. All sided getDesires().removeIf are dropped, notably over AggroList/HateList. Cursed Weapon rework Fix potential task scheduling issues, reworking the whole layers. Reduce code by 1/3. Use L2OFF formulas/data for item drop rate, staging process. CW end duration now decreases when killing other Players. Bugfixes Revert schedule part from ThreadPool. Fix Pet inventory IU. Ty Denzel for the report. Fix Pet item timestamp reuse delay. Ty artemis for the fix. Disable automatic beastshots when his owner dies. Ty Root for the report. Player cannot craft while casting a skill, nor trade. Ty Root for the report. Add missing weight checks for player/summon pickup, and player craft. Ty Root for the report. Implement /graduatelist command, which displays a list of clan academy graduates for the past week. Ty RooT for the report. Fix PLAYING_FOR_LONG_TIME concept ; rest message is server related, not Player related. Ty RooT for the report. Player should stop movement when opening store. Fix Q351 occurences of itemId 4310 by 4407 one + slight fix. Fix Q365 missing memoState + poison skillId. Ty Root for the report. Fix Q417 Torai despawn over cond 11. Fix Q216 4 missing npcIds. Ty Karudin for the report. Fix the invalid comment of DeleteCharAfterDays Config. Fix NPC drop penalty level calculation. Ty Bandnentans for the report. Items are now dropped in a 30/45 donut shape around dropper. Ty Bandnentans for the report. PartyMatch fixes Don't show Party members or CW holder as available waiting members. You can't show overall List or join a PartyMatch room as CW holder. CW owner, upon acquisition, leave PartyMatch system. PartyMatch window is now automatically closed upon Player#removeMeFromPartyMatch. Remove Player from PartyMatch if Player and newly joined Party leader PartyMatch rooms differ. You can't join or be invited in a PartyMatch room if already partying/CW holding. Fix ShowLicence config when set to false. Ty artemis for the fix. Fix maximum number of macros. Ty artemis for the fix. Fix invalid IU update over //enchant. Ty artemis for the fix. Fix Castle Mass Gatekeeper HTMs. Ty kingNik0n for the fix. Drop _disabledItems implementation. Won't be used by next refactors. Ty artemis for the report. Fix loading handlers under debug. Ty Keku for the fix. Fix character_macroses table structure (commands = 12x32 chars minimum). Admincommands Merge all old spawn admincommands (//list_spawns, //spawn, //unspawnall, //respawnall, //delete) to //spawn and //unspawn (previously //delete). Generate //help. //unspawn works over all ASpawn. Merge all old fence admincommands (//spawnfence, //deletefence, //listfence) to //fence [add|remove], generate AdminFence. They now use proper Pagination. You can also teleport to it. Implementation of //show manor. Implementation of //set quest <id> [cond]. Related items must be hand-given. Implementation of //set henna [page] [add|remove symbolId]. The hennas are still bound to game logic (slots, canBeUsedBy). Movement - Ty LaRoja, Bandnentans Fix Boats IOOBE. Adapt getHeight logic from L2OFF. Introduce back WASD movement, handle boat board/unboard. Fix WATER/FLY movement logic. Avoid to pathfind diagonal cells with detected obstacle. Organization Addition of QuestVars class, holding all related variables from quests (itemIds, npcIds, questNames, sounds, etc), allowing to reduce length of each script while reusing variables. 100+ cloned variables were deleted. Refactor geometry package and Territory. Territory is now a unique 3D shape, holding any type of 2D geometry.  Remove few useless Location#clone uses. Implementation of ItemContainer#forEachItem. Clean many unused FrequentSkill. The whole enum is questionable. Drop MathUtil#checkIfInRange, implement WorldObject#isInStrictRadius (involve collision of that WorldObject, and potential WorldObject parameter). WorldObject#isIn2DRadius parameter is now a Point2D, not a Location (since a Location inherits Point2D, Location are still usable as parameter). Rework Pagination#generatePages to handle page number > 1000. Use Pagination over Tryskell SchemeBuffer. Ty CUCU23 for the share.
    • It's a custom instance used as Event not retail - like. You can re-create it easily.
    • GRAND OPENING TODAY !!! FROM - 16/05/2025, FRIDAY, 20:00 +3 GMT !
  • Topics

×
×
  • Create New...