Problems with PocketQuery AddOn Database

[Richard Crowley]

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)

[Richard Crowley]

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

[Felix Grund (Scandio)]

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.

[Felix Grund (Scandio)]

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

[Felix Grund (Scandio)]

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) 

[Richard Crowley]

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

[Pavel Potcheptsov]

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