Getting this message from Converse when I paste a picture. What more do I have to configure on Openfire, for this to work?
Ive gone through a dozen of the same threads
Ive checked the server cert. There is no issue with it. It is correct for the hostname of the openfire server.
How do we even troubleshoot this?
Checked logs and found tons of these net new errors since Converse was installed:
2025.03.15 12:56:02.156 e[1;31mERRORe[m [httpbind-worker-2]: org.jivesoftware.openfire.roster.DefaultRosterItemProvider - Internal server error
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) ~[mysql-connector-j-8.2.0.jar:8.2.0]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-j-8.2.0.jar:8.2.0]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:912) ~[mysql-connector-j-8.2.0.jar:8.2.0]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:968) ~[mysql-connector-j-8.2.0.jar:8.2.0]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) ~[commons-dbcp2-2.9.0.jar:2.9.0]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) ~[commons-dbcp2-2.9.0.jar:2.9.0]
at org.jivesoftware.openfire.roster.DefaultRosterItemProvider.getItems(DefaultRosterItemProvider.java:299) ~[xmppserver-4.8.1.jar:4.8.1]
at org.jivesoftware.openfire.roster.Roster.<init>(Roster.java:106) ~[xmppserver-4.8.1.jar:4.8.1]
at org.jivesoftware.openfire.roster.RosterManager.getRoster(RosterManager.java:167) ~[xmppserver-4.8.1.jar:4.8.1]
at org.jivesoftware.openfire.user.User.getRoster(User.java:381) ~[xmppserver-4.8.1.jar:4.8.1]
at org.jivesoftware.openfire.handler.IQRosterHandler.manageRoster(IQRosterHandler.java:189) ~[xmppserver-4.8.1.jar:4.8.1]
at org.jivesoftware.openfire.handler.IQRosterHandler.handleIQ(IQRosterHandler.java:118) ~[xmppserver-4.8.1.jar:4.8.1]
at org.jivesoftware.openfire.handler.IQHandler.process(IQHandler.java:102) ~[xmppserver-4.8.1.jar:4.8.1]
at org.jivesoftware.openfire.IQRouter.handle(IQRouter.java:403) ~[xmppserver-4.8.1.jar:4.8.1]
at org.jivesoftware.openfire.IQRouter.route(IQRouter.java:106) ~[xmppserver-4.8.1.jar:4.8.1]
at org.jivesoftware.openfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:74) ~[xmppserver-4.8.1.jar:4.8.1]
at org.jivesoftware.openfire.SessionPacketRouter.route(SessionPacketRouter.java:106) ~[xmppserver-4.8.1.jar:4.8.1]
at org.jivesoftware.openfire.SessionPacketRouter.route(SessionPacketRouter.java:65) ~[xmppserver-4.8.1.jar:4.8.1]
at org.jivesoftware.openfire.http.HttpSession.lambda$sendPendingPackets$2(HttpSession.java:560) ~[xmppserver-4.8.1.jar:4.8.1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:?]
at java.lang.Thread.run(Thread.java:833) [?:?]
SQL syntax, hmm!
I doubt they have something to do with file uploads, due to the sheer number of these, but who knows. Are you able to go back to the code and correct your SQL statements?
Which Openfire version are you using? Is everything ok with your database?
Also you need to install and configure File Upload plugin.
1 Like
4.8.1
What is your definition of “ok”?
Obviously, this is the case. I am not that dumb.
It is installed.