vchinni

I'm trying to enable SSL for Jaspersoft Web Server v6.2 having tomcat 8.5.x using a Wildcard cert file (*.pfx) that is currently implemented on apache tomcat for an ITSM application. if it's possible to use the same cert file then could anyone please help me with the steps to implement SSL for Jaspersoft web server? I have tried few options so far and no luck in enabling SSL for Jaspersoft. under $CATALINA_BASE/conf/server.xml file, where $CATALINA_BASE represents the base directory for the Tomcat instanc. See below, for your reference. Option 1 <Connector SSLEnabled="true" clientAuth="false" enableLookups="false" keystoreFile="confxxx.pfx" keystorePass="xxx" keystoreType="PKCS12" maxThreads="200" port="8443" protocol="HTTP/1.1" scheme="https" secure="true" sslProtocol="TLS" sslEnabledProtocols="TLSv1,TLSv1.1,TLSv1.2" ciphers="TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384,TLS_ECDHE_ECDSA_WITH_AES_256_ CBC_SHA384,TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA,TLS_ECDHE_ECDSA_WITH_AES_256_C BC_SHA,TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256,TLS_ECDHE_ECDSA_WITH_AES_128_CB C_SHA256,TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA,TLS_ECDHE_ECDSA_WITH_AES_128_CBC _SHA,TLS_RSA_WITH_AES_256_CBC_SHA256,TLS_RSA_WITH_AES_256_CBC_SHA,TLS_RSA_WI TH_AES_128_CBC_SHA256,T0LS_RSA_WITH_AES_128_CBC_SHA"/> Option 2 - Using a self-signed cert import<Connector port="8443" protocol="org.apache.coyote.http11.Http11NioProtocol" maxThreads="150" SSLEnabled="true" scheme="https" secure="true" clientAuth="false" sslProtocol="TLS" keystoreFile="E:/keystore" keystorePass="jasper" /> Thank You!

Thanks hozawa for sharing the link. However, I do not see an issue with size limit on LDAP Soft LDAP Browser and also the search filter sAMAccountName = ${username} brings up only two accounts - catest and catest02. I'm still not sure of why we are seeing the error for this account and may have to test using other accounts as well.

Uncommenting the JSDefaultLdapAuthoritiesPopulator bean code in applicationContext-externalAuth-LDAP-mt.xml file resulted in following error, when attempted to login into Jasperserver using LDAP account. Could anyone please suggest a fix for this issue?

I currently have an issue in running an OOTB JasperReports Server 6.2 report query in Jaspersoft Studio 6.3, which I have already raised in another thread. For now, I have downgraded to Jaspersoft Studio-6.2.2 and looking to install the license file but I don't see an option in this release. Please suggest from where I can install the license file.

I'm new to JasperReports development, so I'm trying to learn through OOTB reports that is packaged within Jasperreports Server 6.2. I was able to configure the adapter in Jaspersoft Studio 6.3 to communicate with Jasperreports server 6.2. I ran an OOTB report which seems to get some results and when tried to valiate the query in dataset and query window, it failed with the below error. Please suggest a solution on how I could get rid of this error to succesfully validate the query. See below for the error output: net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query: SELECT cr.group_name, cr.ref_num, cr.open_date, cr.priority_symbol, cr.status_symbol, cr.request_area_symbol, cr.active, cr.web_url, (PdmToday() - cr.open_date)/(7*24*3600), (PdmToday() - cr.open_date)/(24*3600), (PdmToday() - cr.open_date)/3600, (case when ((PdmToday() - cr.open_date)/(7*24*3600)) <2 then '1' when ((PdmToday() - cr.open_date)/(7*24*3600)) >=2 AND ((PdmToday() - cr.open_date)/(7*24*3600)) <3 then '2' when ((PdmToday() - cr.open_date)/(7*24*3600)) >=3 AND ((PdmToday() - cr.open_date)/(7*24*3600)) <4 then '3' when ((PdmToday() - cr.open_date)/(7*24*3600)) >=4 AND ((PdmToday() - cr.open_date)/(7*24*3600)) <5 then '4' when ((PdmToday() - cr.open_date)/(7*24*3600)) >=5 AND ((PdmToday() - cr.open_date)/(7*24*3600)) <8 then '5' when ((PdmToday() - cr.open_date)/(7*24*3600)) >=8 then '6' ELSE '' end ) as WeeksOpened, case when ((PdmToday() - cr.open_date)/(7*24*3600)) < 2 THEN 1 ELSE 0 END AS "1Week", case when ((PdmToday() - cr.open_date)/(7*24*3600)) >= 2 AND ((PdmToday() - cr.open_date)/(7*24*3600)) < 3 THEN 1 ELSE 0 END AS "2Weeks", case when ((PdmToday() - cr.open_date)/(7*24*3600)) >= 3 AND ((PdmToday() - cr.open_date)/(7*24*3600)) < 4 THEN 1 ELSE 0 END AS "3Weeks", case when ((PdmToday() - cr.open_date)/(7*24*3600)) >= 4 AND ((PdmToday() - cr.open_date)/(7*24*3600)) < 5 THEN 1 ELSE 0 END AS "4Weeks", case when ((PdmToday() - cr.open_date)/(7*24*3600)) >= 5 AND ((PdmToday() - cr.open_date)/(7*24*3600)) < 8 THEN 1 ELSE 0 END AS "30-60Days", case when ((PdmToday() - cr.open_date)/(7*24*3600)) >= 8 THEN 1 ELSE 0 END AS "Over60Days" FROM cr WHERE cr.active=1 AND cr.group_name IS NOT NULL AND cr.type = 'R' AND (cr.group_name in or '*' in ) ORDER BY cr.priority_symbol ASC, cr.open_date ASC, cr.group_name ASC at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:528) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:297) at com.jaspersoft.studio.data.jdbc.JDBCFieldsProvider.getFields(JDBCFieldsProvider.java:79) at com.jaspersoft.studio.data.jdbc.JDBCDataAdapterDescriptor.getFields(JDBCDataAdapterDescriptor.java:75) at com.jaspersoft.studio.property.dataset.dialog.DataQueryAdapters.doGetFields(DataQueryAdapters.java:396) at com.jaspersoft.studio.data.designer.AQueryDesignerContainer$1.run(AQueryDesignerContainer.java:53) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119) Caused by: java.sql.SQLException: [DataDirect][OpenAccess SDK JDBC Driver][OpenAccess SDK SQL Engine]syntax error, unexpected OR, expecting '(' at group_name ... or at com.ddtek.openaccess.ssp.Diagnostic.toSQLException(Unknown Source) at com.ddtek.openaccess.ssp.Chain.cnvDiagnostics(Unknown Source) at com.ddtek.openaccess.ssp.Chain.decodeDiagnostic(Unknown Source) at com.ddtek.openaccess.ssp.Chain.decodeBody(Unknown Source) at com.ddtek.openaccess.ssp.Chain.decode(Unknown Source) at com.ddtek.openaccess.ssp.Chain.send(Unknown Source) at com.ddtek.openaccess.ctxt.stmt.StatementContext.associate(Unknown Source) at com.ddtek.jdbc.openaccess.OpenAccessImplStatement.prepare(Unknown Source) at com.ddtek.jdbc.oabase.BaseImplStatement.prepare(Unknown Source) at com.ddtek.jdbc.oabase.BasePreparedStatement.prepareSQL(Unknown Source) at com.ddtek.jdbc.oabase.BaseStatement.preProcessSQL(Unknown Source) at com.ddtek.jdbc.oabase.BasePreparedStatement.(Unknown Source) at com.ddtek.jdbc.oabase.BaseConnection.prepareStatement(Unknown Source) at (message continues in next comment)