Hi,
My Wildfire instal used to work but now nothing is working. I cannot login anymore neither in the console nor as an IM user. My usernames password are rejected. I checked in the DB, they are correct.
I am using Wildfire 3.0.1, MySQL 4.1.21, jdbc_mysql-3.1.10 on a gentoo system.
My mysql server is working, I can connect with other applications (not java).
I tried to delete and create a new database with no luck.
Here are the error in error.log when I start wildfire:
2006.09.07 16:04:44 [org.jivesoftware.database.SchemaManager.checkSchema(SchemaM
anager.java:200)]
java.sql.SQLException: Table ‘‘jiveUser’’ already exists
2006.09.07 16:04:45 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.c
reateDefaultConfiguration(PubSubPersistenceManager.java:1149)]
java.sql.SQLException: Incorrect arguments to mysql_stmt_execute
2006.09.07 16:04:45 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.c
reateDefaultConfiguration(PubSubPersistenceManager.java:1149)]
java.sql.SQLException: Incorrect arguments to mysql_stmt_execute
2006.09.07 16:04:45 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.c
reateNode(PubSubPersistenceManager.java:222)]
java.sql.SQLException: Incorrect arguments to mysql_stmt_execute
2006.09.07 16:04:45 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.s
aveAffiliation(PubSubPersistenceManager.java:769)]
java.sql.SQLException: Duplicate entry ‘’’’ for key 1
2006.09.07 16:04:45 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.s
aveSubscription(PubSubPersistenceManager.java:889)]
java.sql.SQLException: Incorrect arguments to mysql_stmt_execute
I don’'t see anything when I try to login
I don’'t have anything intersting in the debug.log.
I can see two other things that appear strang to me:
in info.log:
“Wildfire database schema is inexistante. Installation in progress…” (translated from french).
in warn.log:
2006.09.07 16:04:45 Affiliations found for a non-existent node:
Can someone help me ? I cannot use anymore my xmpp server and it’'s really missing…
Thanks.
Stephane