r258 Passkey

[GoogleCodeExporter]

com.aionemu.commons.network.packet.BaseClientPacket:219 - Missing S for: [C] 
0xC3 CM_CHARACTER_PASSKEY
[FATAL] 2011-04-17 22:01:19 - mysql5.MySQL5PlayerPasskeyDAO:60 - Error saving 
PlayerPasskey. accountId: 3
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 
'passkey' at row 1
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3564)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at mysql5.MySQL5PlayerPasskeyDAO.insertPlayerPasskey(MySQL5PlayerPasskeyDAO.java from JavaSourceFromFile:56)
    at gameserver.network.aion.clientpackets.CM_CHARACTER_PASSKEY.runImpl(CM_CHARACTER_PASSKEY.java:68)
    at gameserver.network.aion.AionClientPacket.run(AionClientPacket.java:64)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:54)
    at gameserver.taskmanager.FIFORunnableQueue.removeAndExecuteFirst(FIFORunnableQueue.java:28)
    at gameserver.taskmanager.FIFOExecutableQueue.run(FIFOExecutableQueue.java:65)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:54)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrapper.java:39)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Original issue reported on code.google.com by laurovic...@gmail.com on 17 Apr 2011 at 7:07

[GoogleCodeExporter]

passkey has a 8 digit length.

Original comment by Aions...@gmail.com on 18 Apr 2011 at 1:29

[GoogleCodeExporter]

The passkey is a 8 digit length still same error on screen. After I set the 
passkey the game tell me to put the key and if i look on database the key is 
not saved, and also can't enter to the characters.

Original comment by laurovic...@gmail.com on 18 Apr 2011 at 4:30

[GoogleCodeExporter]

I know this problem. It happens with latest Aion client.

Original comment by wildsisop@gmail.com on 19 Apr 2011 at 5:50

[GoogleCodeExporter]

Inspect the data packet, it seems like it may have changed.

Original comment by ZeroSign...@gmail.com on 20 Apr 2011 at 11:09

• Changed state: Accepted

[GoogleCodeExporter]

The packets in CM_CHARACTER_PASSKEY have been changed. Starting some retail 
session to get the correct ones.

Original comment by pziko...@gmail.com on 23 Apr 2011 at 10:47

[GoogleCodeExporter]

Try this in your SQL:

ALTER TABLE `player_passkey` CHANGE `passkey` `passkey` VARCHAR( 255 ) 
CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL 

Original comment by pziko...@gmail.com on 24 Apr 2011 at 10:23

[GoogleCodeExporter]

Original comment by pziko...@gmail.com on 24 Apr 2011 at 10:23

• Changed state: Started

[GoogleCodeExporter]

Try this:

-- ----------------------------
-- Table structure for player_passkey
-- ----------------------------
CREATE TABLE `player_passkey` (
  `account_id` int(11) NOT NULL,
  `passkey` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`account_id`,`passkey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Original comment by apophis1...@gmail.com on 25 Apr 2011 at 3:30

[GoogleCodeExporter]

After 'passkey' varchar (255)

Look "player_passkey" table

INSERT INTO `player_passkey` VALUES ('1', 
'歐뺞涻➵ꯎ流נ씜ꡟ꡹៟ⱽ⡵脟ꎮ');

[ERROR] 2011-04-25 05:49:16 - 
com.aionemu.commons.network.packet.BaseClientPacket:219 - Missing S for: [C] 
0xC3 CM_CHARACTER_PASSKEY

[ERROR] 2011-04-25 05:49:24 - 
com.aionemu.commons.network.packet.BaseClientPacket:219 - Missing S for: [C] 
0xC3 CM_CHARACTER_PASSKEY

Original comment by apophis1...@gmail.com on 25 Apr 2011 at 3:54

[GoogleCodeExporter]

Which client version are you using? Im using the latest and did not have this 
error. When did this line appear?

Original comment by pziko...@gmail.com on 25 Apr 2011 at 11:16

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Ups sry forgot to update. This will fix the problem but only if you created a 
new account and than choose a character. But if you close the client it wont 
take the passkey anymore cause a packet is missing. Need more retail sessions 
to capture the right packets.

Original comment by pziko...@gmail.com on 1 May 2011 at 11:08

[GoogleCodeExporter]

Issue 348 has been merged into this issue.

Original comment by pziko...@gmail.com on 4 May 2011 at 5:14

[GoogleCodeExporter]

Please try this one.

Original comment by pziko...@gmail.com on 7 Jun 2011 at 11:18

Attachments:

• passkey.patch
• passkey.sql

[GoogleCodeExporter]

Still wont work >.< cause of a changing algorithm :/ have to find out some more 
about this.

Original comment by pziko...@gmail.com on 7 Jun 2011 at 12:46

[GoogleCodeExporter]

Any progress ont his?

Original comment by swoosh20...@googlemail.com on 15 May 2013 at 8:02