It’s an open-source Reporting tool.

Step1. Run the following command to download the RPM package

wget --no-cookies --no-check-certificate --header "Cookie:oraclelicense=accept-securebackup-cookie" http://download.oracle.com/otn-pub/java/jdk/8u131-b11/d54c1d3a095b4ff2b6607d096fa80163/jdk-8u131-linux-x64.rpm

Step2. Install package

# yum -y install wget,java

Step3. Check java version

java -version

Step4. Check if JAVA_HOME environment variable is set

echo $JAVA_HOME

Note: If you get output is blank, Set java_home using command.
vi ~/.bash_profile

export JAVA_HOME=/usr/java/jdk1.8.0_131/
export JRE_HOME=/usr/java/jdk1.8.0_131/jre
Now source the file using the following command.
source ~/.bash_profile

Step5. Verify java path

# echo $JAVA_HOME 

Step6. Create a tomcat user and group

Note:  You will need to install Tomcat server. Tomcat is an application server for JAVA applications. 
 
groupadd tomcat
useradd -M -s /bin/nologin -g tomcat -d /opt/tomcat tomcat

Step7. Download tomcat

wget http://www-us.apache.org/dist/tomcat/tomcat-8/v8.5.32/bin/apache-tomcat-8.5.32.tar.gz

Step8. Create a folder and untar the file

mkdir /opt/tomcat
tar xvf apache-tomcat-8*tar.gz -C /opt/tomcat --strip-components=1

Step9. Change permission

chown -R tomcat:tomcat /opt/tomcat

Step10. Install PostgreSQL packages

yum -y install postgresql-server postgresql-contrib

Step11. Initialize the database

# postgresql-setup initdb

Step12. Start and enable the service

systemctl start postgresql
systemctl enable postgresql

Step13. Set PostgreSQL database password

sudo -u postgres psql postgres
password postgres
Enter \q  buttons to exit Postgres shell.

Step14. Create a new database

sudo -u postgres createdb reportserver

Step15. Create a new user in the database

sudo -u postgres createuser -P -s -e reportserver

Step16. Assign the database user to the database

sudo -u postgres psql
GRANT ALL PRIVILEGES ON DATABASE reportserver TO reportserver;

Step17. Add the line in pg_hba file

vi /var/lib/pgsql/data/pg_hba.conf
Find the following lines and change peer to trust and idnet to md5.

Step18. Restart service

systemctl restart postgresql

Step19. Download software

wget https://downloads.sourceforge.net/project/dw-rs/bin/3.0/RS3.0.2-5855-2016-05-29-17-55-24-reportserver-ce.zip -O reportserver.zip
rm -rf /opt/tomcat/webapps/ROOT/*

Step20. Install package unzip

yum install unzip -y

Step21. Unzip file

unzip reportserver.zip -d /opt/tomcat/webapps/ROOT/

Step22. Copy the configuration file from the example files

cp /opt/tomcat/webapps/ROOT/WEB-INF/classes/persistence.properties.example /opt/tomcat/webapps/ROOT/WEB-INF/classes/persistence.properties

Step23. Set database configuration in below file

vi /opt/tomcat/webapps/ROOT/WEB-INF/classes/persistence.properties
 
hibernate.connection.username=reportserver
hibernate.connection.password=StrongPassword
hibernate.dialect=net.datenwerke.rs.utils.hibernate.PostgreSQLDialect
hibernate.connection.driver_class=org.postgresql.Driver
hibernate.connection.url=jdbc:postgresql://localhost/reportserver

Step24. Change ownership

chown -R tomcat:tomcat /opt/tomcat/webapps/ROOT/

Step25. Initialize the ReportServer database

psql -U reportserver -d reportserver -a -f /opt/tomcat/webapps/ROOT/ddl/reportserver-RS3.0.2-5855-schema-PostgreSQL_CREATE.sql

Note: It will ask you the password of your database user, provide the password and it will run the DDL script to initialize the database.

Step26. Create a Systemd script

vi /etc/systemd/system/tomcat.service
 
[Unit]
Description=Apache Tomcat Web Application Container
After=syslog.target network.target
 
[Service]
Type=forking

Environment=JRE_HOME=/usr/java/jdk1.8.0_131/jre
Environment=CATALINA_HOME=/opt/tomcat
Environment=CATALINA_BASE=/opt/tomcat
Environment='JAVA_OPTS="-Djava.awt.headless=true -Xmx2g  -XX:+UseConcMarkSweepGC -Dfile.encoding=UTF8 -Drs.configdir=/opt/reportserver"'
ExecStart=/opt/tomcat/bin/startup.sh
ExecStop=/opt/tomcat/bin/shutdown.sh

User=tomcat
Group=tomcat
UMask=0007
RestartSec=10
Restart=always

[Install]
WantedBy=multi-user.target

Step27. Start/Enable/Status tomcat

systemctl start tomcat
systemctl enable tomcat
systemctl status tomcat

Step28. Access via browser

http://your-server-ip:8080

Step29. Default credentials

username :: root 
password :: root

LEAVE A REPLY

Please enter your comment!
Please enter your name here