powered by Jive Software

Khoehn JM-523 MUC logviewer

Since Kurt has already working on the MUC logviewer and has posted on sourceforge and also working on to improve it. http://sourceforge.net/projects/iball-auditor Can the wildfire team let him contribute the code? http://www.jivesoftware.org/issues/browse/JM-523 Then the user might not need to wait very long and it will reduce the burden on the developer also. Wildfire can get more benefit from community providing the codes.

Regards,

wmhtet

No comment?

Interesting. Why am i hearing about this for the firrst time??

i am getting these errors each time a packet is logged:

2006.02.12 09:11:47 [com.etranscor.wildfire.plugin.iball.ChatAuditProvider.insert(ChatAuditProvider .java:218)

]

java.sql.SQLException: Column ‘‘message’’ cannot be null

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)

at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.ja va:1124)

at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement. java:676)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)

at com.etranscor.wildfire.plugin.iball.ChatAuditProvider.insert(ChatAuditProvider. java:214)

at com.etranscor.wildfire.plugin.iball.ChatAuditorPlugin.insertMessages(ChatAudito rPlugin.java:169)

at com.etranscor.wildfire.plugin.iball.ChatAuditorPlugin$InsertMessagesTask.run(Ch atAuditorPlugin.java:178)

at java.util.TimerThread.mainLoop(Unknown Source)

at java.util.TimerThread.run(Unknown Source)

it logs the packet into the database, so i’'m not sure why i get this error.

mysql> select * from iballchatmessage ;

*----


*–


+


+


+–



chatMessageId

toUsername

fromUsername

chatDate

message

*----


*–


+


+


+–



3

michael.brown

wildfireim

2006-02-12 09:11:47

testing

5

wildfireim

michael.brown

2006-02-12 09:11:48

ok

Message was edited by: michaelb

Hello,

Has this been happing from the first time that you installed the plugin?

-kurt

yeap, which was right before i posted

just upgrade to beta3, and it does the same:

2006.02.13 14:06:08 [com.etranscor.wildfire.plugin.iball.ChatAuditProvider.insert(ChatAuditProvider .java:227)

]

java.sql.SQLException: Column ‘‘message’’ cannot be null

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)

at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.ja va:1124)

at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement. java:676)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)

at com.etranscor.wildfire.plugin.iball.ChatAuditProvider.insert(ChatAuditProvider. java:223)

at com.etranscor.wildfire.plugin.iball.ChatAuditorPlugin.insertMessages(ChatAudito rPlugin.java:169)

at com.etranscor.wildfire.plugin.iball.ChatAuditorPlugin$InsertMessagesTask.run(Ch atAuditorPlugin.java:178)

at java.util.TimerThread.mainLoop(Unknown Source)

at java.util.TimerThread.run(Unknown Source)


i was thinking about changing the table properties to allow nulls

mysql> describe iballchatmessage;

*----


*–


+–+-+


+-----+

Field

Type

Null

Key

Default

Extra

*----


*–


+–+-+


+-----+

chatMessageId

bigint(20)

PRI

0

toUsername

varchar(100)

YES

MUL

NULL

fromUsername

varchar(100)

YES

NULL

chatDate

datetime

MUL

0000-00-00 00:00:00

message

text

*----


*–


+–+-+


+-----+

5 rows in set (0.00 sec)

Hmmm, ok - I not running against MySQL right now but I will get it installed and have a look.

You can remove the NOT NULL constraint in MySQL it will not have a negative impact on the plugin but I think it might have something to do with the TEXT field and the driver in MySQL, I will get back with you when I find out.

-kurt

Message was edited by: khoehn

Found the problem. I was able to reproduce the error by changing the subject of a Chat Group. The auditor was not looking for a chat message that contained a subject but no message. I just made the changes to the code so any message that meets the type of chat or chatgroup will be captured and null checks are in place so that should not happen again. I’'ll be uploading beta4 tonight and you should be good to go. Now, if the auditor gets something that is does not understand it will put into the message.

Thank You,

-kurt

Message was edited by: khoehn

ahh ok… this one is working

well i see in the database now, that a few entries are blank/null/empty

1470

user1

me

2006-02-14 14:12:40

1471

user1

me

2006-02-14 14:12:40

outside of that, it is routing

1472

user1

me

2006-02-14 14:12:40

1473

user1

me

2006-02-14 14:12:40

private ip being the rfc1918

1474

user2

user3

2006-02-14 14:13:10

1475

user2

user3

2006-02-14 14:13:10

hehee

1476

me

user1

2006-02-14 14:13:40

| 1477 | user2 | user3 | 2006-02-14 14:13:40 |

no errors in the logs pertaining to this, is it suppose to insert “unknown” or just a blank msg?