Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing
L2JForge.live Interlude Premium Emulator

Problem

zoltir
 Share

Recommended Posts

zoltir Newbie

zoltir

Posted
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

Guest TheVortex

Posted
Posted

go to loginserver and put your root password in root=

 

also #AcceptNewGameServer  = True

Guest TheVortex

Guest TheVortex

Posted
Posted

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

zoltir Newbie

zoltir

Posted
  • Author
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

Guest TheVortex

Posted
Posted

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

TheMentaL Newbie

TheMentaL

Posted
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?

Guest TheVortex

Guest TheVortex

Posted
Posted

jaff.. you must read a guide

zoltir Newbie

zoltir

Posted
  • Author
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.

killer_007 Newbie

killer_007

Posted
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)

zoltir Newbie

zoltir

Posted
  • Author
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)

killer_007 Newbie

killer_007

Posted
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.

zoltir Newbie

zoltir

Posted
  • Author
Posted

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?

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing


  • Posts

    • Celestine
      Lin2Guard Antibot Guard - L2J & PTS (l2off)

      By Celestine · Posted

      I assume you're some kind of Rito Games player too, right? If so, I've got some bad news for you. We've been reversing their stuff for years, and the VGK driver collects far more information from your PC than you could imagine.   I won't leak or discuss any specifics here for obvious reasons, but if you've played on certain "serious" projects, they may also have something running on your system. Whether it's mining your GPU or doing other shady things, the point is that you can't really say you're completely safe in today's gaming world. 😄 EAC, BE, Vanguard, FACEIT, and pretty much any kernel level anticheat have extremely deep access to your system.   In the wrong hands, that level of access can become a serious privacy risk. If you have the knowledge, dump the game and take a look for yourself. You might be surprised by what's actually going on behind the scenes.   No wonder the VGK team decided to remove the driver from startup and switch to an on demand approach. I guess the exposure became too much of a risk for them to ignore, so they had to make changes to protect their reputation and keep their image clean.   So let's get to the point. Any anticheat for Lineage 2, whether it's considered good or bad, comes with the same issue: if someone wants to compromise your privacy, they can potentially do it because you don't truly know what you're launching or what kind of drivers it installs or loads. TL;DR: Without proper knowledge and analysis, you can't really know what's happening behind the scenes. Cheers.   Let me remind some people who may have forgotten about this. Many years ago, there was a project called BeyondWorld H5. I saw people complaining that their systems became extremely laggy and their GPUs were overheating after running the game for a long time. After further analysis, we found that the client was heavily using the GPU in a way that appeared to be mining related. The point is that nothing is impossible  if someone has enough access and knowledge, many things can happen.
    • aguy
      Lin2Guard Antibot Guard - L2J & PTS (l2off)

      By aguy · Posted

      I said I'd buy it for my player, I didn't say I would run it on my pc. 
    • LeoBiagiolli
      Protocol 746 Modern Interface.

      By LeoBiagiolli · Posted

      Hi there! I am starting to develop my server and I am looking for a professional interface editor. I already have a client and I would like to hire somebody to edit it for me or to offer their own interfaces. I have looked around but all the pre-made interfaces out there, so far, has not pleased me and I what I need for my server. So if you are a professional interface maker, please let me know! Thank you!
    • r2r2
      PlayCMS is a website management system for Lineage 2 gaming

      By r2r2 · Posted

      Thanks FunBasec, I recommend this developer ! He is very friendly and professional.
    • kevilicious
      Need devs for p server project

      By kevilicious · Posted

      The project is a change to original l2 with modern game mechanics that is more "western". For example every race can craft, not just dwarves. Mages can cast spells without the need of a dedicated box MP charger. MP chargers are also able to solo farm and deal decent damage on their own. Paladins are now 2h sword dedicated healers/support dps. Drop rates are normalized among all classes, no longer needing spoil to craft.   The idea of the project is keep true to the old vanilla classic experience where you are rewarded for effort. And you must put effort into achieving things. Leveling is slow, gear wont be given to you, you must work towards obtaining upgrades. etc.   These are only a small portion of changes I am making to the game. I would love help and bounce design ideas off of others for some future content update ideas. Like can we design unique raid boss encounters? How about end-game content ideas? How can we make owning castles valuable? Maybe an instanced underground mining zone? Or unique raid fights that the clan can do for extra loot?    There's tons of ideas I have and I would like some help creating them.    This is not a paid project. It is a passion project with people who have a passion for l2 and wanna see the community grow.    Currently using client 418. 

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..