Page 1 of 1
Outside Connection
Posted: Fri Nov 02, 2012 6:51 pm
by arythea
If you want to receive support we need this info to help you properly.
ยป Find Revision
L2J Revision
5207:
L2JDP Revision
8702:
Hello, I've recently set-up a small server for a few friends and I using the BETA l2j packs. I'm able to connect fine locally, however, when they attempt to connect with my external IP via the hosts file they cannot login. I did not change the default-ipconfig so the ips are automatically generated when the server starts and from what I can tell it seems to be set-up just fine. I've opened both ports 7777 and 2106 and checked them using a port checker tool and have tried to disable my anti-virus to no avail.
External IP: 97.100.xxx.xx
Hosts file:
97.100.xxx.xx l2authd.lineage2.com
Server.properties:
http://pastebin.com/ujCtnp3W
Edit: I've found this page
http://trac.l2jserver.com/wiki/Connecting_Info is it necessary to forward ports 80, 2009 and 53?
Re: Outside Connection
Posted: Fri Nov 02, 2012 8:22 pm
by UnAfraid
2106, 7777 are the ports you have to forward.
Re: Outside Connection
Posted: Fri Nov 02, 2012 9:42 pm
by arythea
2107, 7777 are the ports you have to forward.
I assume 2107 Is a typo as im 90% sure it defaults to 2106. As I mentioned in the op I have already opened the appropriate ports and checked them with a port checker to confirm they are open.
Re: Outside Connection
Posted: Sun Nov 04, 2012 10:59 pm
by UnAfraid
arythea wrote:2107, 7777 are the ports you have to forward.
I assume 2107 Is a typo as im 90% sure it defaults to 2106. As I mentioned in the op I have already opened the appropriate ports and checked them with a port checker to confirm they are open.
Yeah sorry its 2106.
2107 was typo.
// edited.
Re: Outside Connection
Posted: Mon Nov 05, 2012 5:09 am
by arythea
This aside, I seem to have another issue relating to creating new clans. I receive this error:
Nov 04, 2012 11:54:27 PM com.l2jserver.gameserver.model.L2Clan store
SEVERE: Error saving new clan: Parameter index out of range (12 > number of parameters, which is 11).
java.sql.SQLException: Parameter index out of range (12 > number of parameters, which is 11).
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3813)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3795)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3840)
at com.mysql.jdbc.PreparedStatement.setInt(PreparedStatement.java:3784)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setInt(NewProxyPreparedStatement.java:607)
at com.l2jserver.gameserver.model.L2Clan.store(L2Clan.java:1014)
at com.l2jserver.gameserver.datatables.ClanTable.createClan(ClanTable.java:195)
at com.l2jserver.gameserver.model.actor.instance.L2VillageMasterInstance.onBypassFeedback(L2VillageMasterInstance.java:124)
at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:158)
at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:64)
at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1088)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
any idea? i'm still using same l2j build.
Re: Outside Connection
Posted: Mon Nov 05, 2012 6:05 am
by MELERIX
that is already fixed since:
Changeset 5690
Re: Outside Connection
Posted: Mon Nov 05, 2012 5:14 pm
by arythea
that is already fixed since: Changeset 5690
Thank you sir for this bit of information.
Re: Outside Connection
Posted: Mon Nov 05, 2012 10:36 pm
by arythea
Sorry for all the trouble but I've looked around and can't find a solution for this, I seem to be getting an error in the spawnlist when trying to spawn a custom NPC...
Nov 05, 2012 5:25:52 PM com.l2jserver.gameserver.datatables.SpawnTable addNewSpawn
WARNING: SpawnTable: Could not store spawn in the DB:Data truncation: Out of range value for column 'npc_templateid' at row 1
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'npc_templateid' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4094)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:815)
at com.l2jserver.gameserver.datatables.SpawnTable.addNewSpawn(SpawnTable.java:233)
at handlers.admincommandhandlers.AdminSpawn.spawnMonster(AdminSpawn.java:378)
at handlers.admincommandhandlers.AdminSpawn.useAdminCommand(AdminSpawn.java:261)
at com.l2jserver.gameserver.network.clientpackets.SendBypassBuildCmd.runImpl(SendBypassBuildCmd.java:83)
at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:66)
at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1088)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Re: Outside Connection
Posted: Mon Nov 05, 2012 10:56 pm
by MELERIX
enable custom spawn table in configs, also enable the options to save on it too.
Re: Outside Connection
Posted: Tue Nov 06, 2012 12:22 am
by arythea
Thank you once again kind MELERIX, it seems I had the spawnlists set to true but did not have SaveGmSpawnOnCustom set to true as well.
Re: Outside Connection
Posted: Wed Nov 07, 2012 6:58 pm
by arythea
Sorry for posting here but it seems my thread on the issue was deleted and I'm still hoping to receive some support.
I'm having a problem where servitors and pets cannot attack and servitor skills are not working. Is there a table I must enable for this?
Re: Outside Connection
Posted: Wed Nov 07, 2012 7:08 pm
by MELERIX
arythea wrote:Sorry for posting here but it seems my thread on the issue was deleted and I'm still hoping to receive some support.
I'm having a problem where servitors and pets cannot attack and servitor skills are not working. Is there a table I must enable for this?
is not deleted, is here "merged":
viewtopic.php?f=77&t=26539#p156415
please use proper forum areas.