swood_1
-
Posts
176 -
Joined
-
Last visited
swood_1's Achievements
-
Fixing Tomcat CVE-2020-1938 for TIBCO JasperReporrts® Server
swood_1 commented on swood_1's entry in Getting Started
Not for the back versions. You will need to update your existing Tomcat deployment to disable AJP as outlined in this page. Jaspersoft regularly updates platform support for every new release, and Tomcat is always on the list. -
Fixing Tomcat CVE-2020-1938 for TIBCO JasperReporrts® Server
swood_1 commented on swood_1's entry in Getting Started
No. Versions of Tomcat after the indicated supported version documented in the Platform Support Guide for your JasperReports Server version have not been tested and certified, and are therefore not officially supported. Later point release versions like Tomcat 8.5.51 are likely but not guaranteed to work. -
Good that you worked out the page breaks. The key point in the stackoverflow post is creating a new Data Source object in the dataSourceExpression. You need to do something like: dataSourceExpression><![CDATA[new JRBeanCollectionDataSource (fillList))]]></dataSourceExpression>
-
Fixing Tomcat CVE-2020-1938 for TIBCO JasperReporrts® Server
swood_1 posted an entry in Getting Started
swood_1 posted an entry in Getting Started
A high severity security vulnerabilty https://nvd.nist.gov/vuln/detail/CVE-2020-1938 was published on February 24, 2020. The CVE effects of a large number of versions of Tomcat, a Java web server that is: included in TIBCO JasperReporrts® Server bundled installers for Windows, Mac and Linuxincluded in JasperReporrts® Server AWS AMIs on the AWS Marketplace ie. https://aws.amazon.com/marketplace/pp/B01BUD6H48frequently used in JasperReporrts® Server manual deploymentsIncluded in Docker images: https://hub.docker.com/search?q=jasperreports&type=imageThe exposure is in Tomcat's Apache JServ Protocol (AJP) connector, which is turned on by default. AJP is used as a high performance integration between the Apache Web Server and Tomcat. The issue on Tomcat's JIRA: https://issues.apache.org/jira/browse/OFBIZ-11407?page=com.atlassian.jira.plugin.system.issuetabpanels%3Aall-tabpanel Simplest Solution: Disable AJPThe simplest solution is to disable the AJP connector in Tomcat. JasperReports® Server does not require AJP connections. Edit <tomcat>/conf/server.xml Comment out or delete the following line: <Connector port="8009" protocol="AJP/1.3" redirectPort="8443" /> Solution 2: Restrict AJP access. Optional Tomcat upgradeIf you require AJP because of the Apache Web Server integration, lock down the AJP connector. Apache Tomcat 9.0.31, 8.5.51 or 7.0.100 or later change the default openness of the AJP connector, but may require additional configuration. From https://tomcat.apache.org/tomcat-9.0-doc/config/ajp.html -
Have a look at the video: Get step-by-step instructions on how to set up your first JasperReports IO project in JSS on https://community.jaspersoft.com/wiki/jasperreports-io-step-2 You need to do a few things to make a Studio project = a JasperReports IO project. It is easier manage if, as Guilio says in the video, you have a subfolder in the project to be your repository root. Once you have a JasperReports IO project, the data adapter files in the "repository" (project) will be accdo the ....ess relative to the repository root you set above. You wil not need to do the "../../data-adapters/DataAdapter.xml" Sherman
-
Help Needed with a Jaspersoft job running in SMA OpCon
swood_1 replied to kevinwarren's topic in Products
Hi Kevin, I don't know how you received access to JasperReports Server commercial editions. Did your organization buy Jaspersoft: directly from TIBCO Jaspersoft => Jaspersoft Support could help with this issuiethrough software you provided by another vendor => contact the vendorFrom what I understand looking at the issue, you have set up a job with SAM OpCon that makes a REST call to the JasperReports Server. The 404 means that the job is not able to connect to the JasperReports Server. It can't find that endpoint. I can't see the actual URL you are using. That is the first thing to check. The JasperReports Server REST API to run a report is defined here: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v750/reports-service http://<host>:<port>/jasperserver[-pro]/rest_v2/reports/path/to/report.<format>?<arguments> Sherman -
This is the relevant page in the 7.2 documentation: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v720/file-data-sources To get a data source type to appear in the Data Source maintenance screen, you have to comment out elements in the list with the "customDataSourcesToHide" bean ie. ..<!-- value> jsonDataSource</value -->..[/code]Did you restart the server after changing the file?
-
What metadata do you need to add? Do you want the metadata to appear in reports?
-
Looks like luked is on it!
-
A JasperReport is based on a fixed set of fields returned by a query. If the query can return variable columns, say: make the column names abstract in the query - field1, field2define the fields in the report to be the maximum number expectedif the query does not provide a particular column, the corresponding field in the report will be nullinclude logic in the report to manage field with content or nullSherman
-
The JR library does not have a "compile as needed" feature. The JasperReports Server and JasperReports IO does. The first time after a report or subreport is published to JasperReports Server, the report is compiled and the bytecode is stored in the repository. Sherman
-
Looks like you did not select the MariaDB driver in the Studio Data Adapter dialog.
-
https://www.google.com/search?q=oracle+java.sql.SQLRecoverableException%3A+No+more+data+to+read+from+socket
-
# not doing app server management during command line work cat >> ${BUILDOMATIC_HOME}/default_master.properties <<-_EOL_ appServerType=skipAppServerCheck _EOL_
-
http://jasperreports.sourceforge.net/sample.reference/xlsfeatures/index.html#xlsfeatures See "Importing Macros Into The Generated XLSX Document"
