Differences

This shows you the differences between two versions of the page.

--- jasperreports_systems_administrator_guide [2024/03/24 03:57] – [Integration with Pacific EMIS] ghachey
+++ jasperreports_systems_administrator_guide [2024/12/15 04:51] (current) – [Catalog Restoration] ghachey
@@ Line 6: / Line 6: @@
 Unless you want to not use the bundled Tomcat and PostgreSQL then the only dependency to install is the Java Development Kit (JDK). The JasperSoft Platform Support Guide is the best place to look to decide what version to install. The JDK version 8 is our preferred choice at more recent Java are still only use to runtime only and need version 8 compatibility for compiling reports.
+Here is a good time to set the JAVA_HOME environment variable. On windows you can do this permanently from start menu "Edit the system environment variables". Add the new JAVA_HOME=C:\Program Files\Java\jdk-1.8. Then add to the existing PATH list of items %JAVA_HOME%\bin. This will be handy for using Java tools from the command line specifically when using the JasperServer buildomatic tools.
 ==== Microsoft Visual C++ Redistributable ====
@@ Line 41: / Line 43: @@
 security.validation.sql.on=false
 </code>
+===== Firewall =====
+Tomcat bundled with the JasperServer is already configured to be able to listen on external interfaces. But the windows firewall would block it by default. The safest is to only open the port 8080 to those who will access the JasperServer directly. This usually means administrators and developers as all reports are made available directly in the Pacific EMIS web application.
 ===== Integration with Pacific EMIS =====
@@ Line 46: / Line 52: @@
 A powerful feature of the Pacific EMIS is its seamless integration with a high end enterprise grade reporting server called JasperReport Server (aka. JasperServer).
-<note warning>JasperServer until recently (end of 2023) been developing and release JasperServer as open source. Unforntunately, they now only release their JasperSoft Studio to design the reports and no longer release the JasperServer without the enterprise license. But all previously released versions are extremely stable and will continue working for years.</note>
+<note warning>JasperServer until recently (end of 2023) been developing and release JasperServer as open source. Unfortunately, they now only release their JasperSoft Studio to design the reports and no longer release the JasperServer without the enterprise license. But all previously released versions are extremely stable and will continue working for years.</note>
 ==== Configuration of the Web Application ====
@@ Line 88: / Line 94: @@
   * **font-extension.jar**: Used to support the new custom fonts in jasper server. Can be added directly in **<Jasper Server>\apache-tomcat\webapps\jasperserver\WEB-INF\lib**
   * **reporting-1.0.jar**: Used as a chart customizer to customize the look of exams reports among potentially others. Can be added directly in **<Jasper Server>\apache-tomcat\webapps\jasperserver\WEB-INF\lib**
-  * **sqljdbc4-VERSION.jar**: Used for JBDC connection to interact with the MS SQL Server. Often loaded directly from the UI of JasperServer when creating the data source or in JasperSoft Studio.
+  * **sqljdbc-VERSION.jar**: Used for JBDC connection to interact with the MS SQL Server. Often loaded directly from the UI of JasperServer when creating the data source or in JasperSoft Studio.
 Restart the server when adding the jars for the first time.
-You also need to install open-sans fonts in Windows and Jasper:
+==== Fonts ====
-  * Go to Window -> Preferences -> Jaspersoft Studio -> Fonts. Click on Add from path and select the zip file.
+Reports have been standardized using the Open Sans famliy of fonts so those will need to be installed on the Windows Server. Just download them from https://fonts.google.com/specimen/Open+Sans or https://www.1001fonts.com/open-sans-font.html, extract and double click each one of them to install. Maybe now is a goo time to restart the server before testing out some reports.
-  * Install in JasperSoft Studio
+Note that if you are designing reports you will also need to install them on your own workstation and you could also install them directly in the JasperSoft Studio. To do this you would go to **Window -> Preferences -> Jaspersoft Studio -> Fonts**. Click on Add from path and select the zip file. Install in JasperSoft Studio as shown below.
 {{:developer-manual:jasper-add-font.png?nolink|}}
@@ Line 180: / Line 187: @@
 </code>
-Change password of the key of interest. This password could also be made simple and convenient but then you would be best to change it in the production stored after ward for tighter security. Another approach is to make it a good password right away and as it gets imported it keeps this password.
+Change password of the key of interest (i.e. importexportencsecret). This password could also be made simple and convenient but then you would be best to change it in the production stored afterward for tighter security. Another approach is to make it a good password right away and as it gets imported it keeps this password.
+<note important>If you do keep to change to a strong password bare in mind that some characters will cause issues as you pass then as command line arguments. So if something goes wrong you may want to look at that first.</note>
 <code>