Problems with PocketQuery AddOn Database

We installed the PocketQuery AddOn without any problems. After that we want to configure the first Database. After entering the values and hitting "OK" nothing happens. In the logfile we have folowing entry:

016-12-29 17:05:31,323 INFO [http-nio-443-exec-7] [atlassian.confluence.status.SystemErrorInformationLogger] writeToLog
Request Unique ID : e99e2433-1738-44ce-8f23-1856e98e0cd7
--------------------------
JVM Stats
--------------------------
usedMemory = 643301392
usedMemoryInMegabytes = 613
availableHeap = 430440432
freeMemoryInMegabytes = 410
allocatedHeap = 1073741824
freeAllocatedHeap = 430440432
totalMemory = 1073741824
totalMemoryInMegabytes = 1024
availablePermGen = 0
maxPermGen = -1
maxHeap = 1073741824
usedHeap = 643301392
freeMemory = 430440432
usedPermGen = -1
--------------------------
Request Information
--------------------------
URL: https://xxx/500page.jsp
Scheme: https
Server: xxx
Port: 443
URI: /500page.jsp
Context Path:
Servlet Path: /500page.jsp
Path Info: null
Query String: null
--------------------------
Attributes
--------------------------
javax.servlet.forward.request_uri: /pocketquery/pocket-add.action
javax.servlet.forward.context_path:
javax.servlet.forward.servlet_path: /pocketquery/pocket-add.action
javax.servlet.error.status_code: 500
com.atlassian.confluence.impl.profiling.DecoratorTimings: com.atlassian.confluence.impl.profiling.DecoratorTimings@67692b76
com.opensymphony.sitemesh.APPLIED_ONCE: true
__cleanup_recursion_counter: 0
com.atlassian.confluence.web.filter.validateparam.RequestParamValidationFilter_already_filtered: true
atlassian.core.seraph.original.url: /500page.jsp
com.atlassian.labs.botkiller.BotKillerFilter: true
com.atlassian.gzipfilter.GzipFilter_already_filtered: true
Confluence-Request-Time: 1483027531309
javax.servlet.request.ssl_session_mgr: org.apache.tomcat.util.net.jsse.JSSESupport@7df1857
com.atlassian.confluence.web.ConfluenceJohnsonFilter_already_filtered: true
com.atlassian.seraph.auth.LoginReason: OK
org.apache.tomcat.util.net.secure_protocol_version: TLSv1.2
javax.servlet.request.key_size: 128
webwork.valueStack: com.opensymphony.xwork.util.OgnlValueStack@b0c3541
confluence.themecontext: com.atlassian.confluence.themes.ThemeContext@21e5695e
javax.servlet.error.message:
javax.servlet.error.servlet_name: action
javax.servlet.request.cipher_suite: TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
javax.servlet.request.ssl_session_id: 586532520543e8d212811ed9efd9d2a41361c5b6d01b4ab787b9147e853a0feb
com.atlassian.confluence.security.websudo.MessagesDecoratorFilter__already_filtered__: true
com.opensymphony.sitemesh.USINGSTREAM: false
B3-TraceId: e804c14600eddd
loginfilter.already.filtered: true
javax.servlet.jsp.jspException: com.thoughtworks.xstream.converters.ConversionException: XStream error: Class de.scandio.confluence.plugins.pocketquery.entities.Database has not been whitelisted
---- Debugging information ----
-------------------------------
javax.servlet.error.request_uri: /pocketquery/pocket-add.action
com.atlassian.core.filters.HeaderSanitisingFilter_already_filtered: true
com.atlassian.prettyurls.filter.PrettyUrlsSiteMeshFixupFilter: true
javax.servlet.error.exception: com.thoughtworks.xstream.converters.ConversionException: XStream error: Class de.scandio.confluence.plugins.pocketquery.entities.Database has not been whitelisted
---- Debugging information ----
-------------------------------
os_securityfilter_already_filtered: true
com.atlassian.prettyurls.filter.PrettyUrlsSiteMeshFilter: true
com.atlassian.confluence.util.profiling.ConfluenceProfilingStrategy.splits: []
--------------------------
Parameters
--------------------------
entityType : database
entityName :
databaseName : RMM
databaseUrl : jdbc:sqlserver://xxx:1433;databaseName=warehouse
databaseDriver : net.socom.microsoft.sqlserver.jdbc.SQLServerDriver urceforge.jtds.jdbc.Driver
databaseUser : xxx
caused by: com.thoughtworks.xstream.converters.ConversionException: XStream error: Class de.scandio.confluence.plugins.pocketquery.entities.Database has not been whitelisted
---- Debugging information ----
-------------------------------
at com.atlassian.confluence.setup.xstream.XStreamSecurityClassFilter.canConvert(XStreamSecurityClassFilter.java:90)

4 answers

Make sure you've granted permission to access database from remote host.

Thanks, but we have set this setting. And e.g. from Word, we can read the data remotely.

Hi Richard!

I'm sorry, we missed this somehow. Could it be that you are running Confluence 5.10.6? This version had a bug that caused this issue: https://jira.atlassian.com/browse/CONF-43832

Best,
Felix (Scandio) 

Yes, we have this Version. Would version 5.10.8 solve the problem?

Yes! 5.10.6 is the only one with that problem. I'd recommend to update because this issue might affect you in other situations too.

Hi Richard! If this resolves the case it would be nice if you accepted my answer below.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jul 10, 2018 in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

900 views 23 12
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you