Outside Connection

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

[UnAfraid]

2106, 7777 are the ports you have to forward.

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

[UnAfraid]

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.

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

[MELERIX]

that is already fixed since: Changeset 5690

[arythea]

that is already fixed since: Changeset 5690

Thank you sir for this bit of information.

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

[MELERIX]

enable custom spawn table in configs, also enable the options to save on it too.

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

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

[MELERIX]

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.