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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

2,943 views 27 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