Installation of Jaspersoft Studio & Server – Configuration of Jasper Server

Steps to install Jaspersoft Studio

1. Download Jaspersoft Studio 7.9 version
2. Follow the installation process
3. Create a workspace
4. Switch the workspace in Jaspersoft Studio pointing to Step-3

Steps to install Jasperserver

1. Download Jasperserver 7.9 version
2. Follow the installation process
3. Jasperserver will be installed on 8080 port
4. Access jasperserver using the following link

http://localhost:8080/jasperserver-pro/

Steps to change the port number(8081) of Jasperserver

1. Open server.xml in ..\jasperreports-server-7.9.0\apache-tomcat\conf

2. In the below line update port value as needed

<Connector port="8081" URIEncoding="UTF-8" protocol="HTTP/1.1" connectionTimeout="20000" redirectPort="8443" compressibleMimeType="text/html,text/xml,text/css,text/javascript,application/json,application/javascript" compression="on" compressionMinSize="128" noCompressionUserAgents="gozilla,traviata"/>

3. In the below line update the shutdown port value as needed

<Server port="8006" shutdown="SHUTDOWN">

4. Save server.xml

5. Restart the server

Steps for jasperserver to point the jasperserver database on another server

1. Go to the jasperreportsserver/postgres/bin folder

..\Jaspersoft\jasperreports-server-7.9.0\postgresql\bin

2. Take a backup of the jasperserver database

pg_dump -U jasperdb -W -F p jasperserver ><Folder_path>\jasperserver_backup.sql

3. Copy the backup file to another server

4. Create jasperserver database in another postgres server

CREATE DATABASE jasperserver;

5. Create jasperdb user with password as “password” in another postgres server

CREATE USER jasperdb WITH PASSWORD 'password';

6. Go to bin folder of postgres in another server

..<PATH_TO_POSTGRES>\bin

7. Execute the following to restore the jasperserver database

psql -U postgres -d jasperserver -f <Folder_path>\jasperserver_backup.sql -p 5433

8. Go to buildomatic folder in jasperserver

..\Jaspersoft\jasperreports-server-7.9.0\buildomatic

9. Update the default_master.properties file with another server postgres details and save the file

# database type
dbType=postgresql

# database location and connection settings

dbHost=<HOST>
dbUsername=<USER>
dbPassword=<PASSWORD>


# additional database parameters
# (uncomment these if you want non-default settings)

dbPort=5433

10. Restart the jasperserver

Steps to test that jasperserver is pointing to another postgres server

1. Add a new role in jasperserver

2. Go to postgres on another server and execute the following query

3. The role created from jasperserver should be in the resultset of the query

Steps to update JNDI connection

1. Go to context.xml in the following location

2. Update jasperserver with the postgres details on another server

<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="jasperdb" password="password" driverClassName="org.postgresql.Driver" accessToUnderlyingConnectionAllowed="true" validationQuery="SELECT 1" testOnBorrow="true" url="jdbc:postgresql://127.0.0.1:5433/jasperserver?useUnicode=true&amp;amp;characterEncoding=UTF-8&amp;amp;autoReconnect=true&amp;amp;autoReconnectForPools=true" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory"/>

3. Save context.xml

4. Restart the server

Thanks,
Kavya.

Helical It Solutions

Configuration of Jasper Server How do I install jaspersoft iReport designer How do I install Jaspersoft Studio How do I start jaspersoft server How to download and install jasper server on windows How to Start or Stop JasperReports Server Install the Jaspersoft Studio Professional License Installation of Jaspersoft Studio & Server Installing and Configuring Jaspersoft Studio Installing JasperReports Server jasperreports server installation guide jasperserver installation guide linux What is jaspersoft server