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?