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)
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Richard! If this resolves the case it would be nice if you accepted my answer below.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks, but we have set this setting. And e.g. from Word, we can read the data remotely.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Make sure you've granted permission to access database from remote host.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.