How to Install ReportServer on CentOS 7

ReportServer is a free and open source business intelligence (OSBI) platform with powerful reporting and analysis tools. It gathers data from multiple business touch points and generates different reports from the data. It provides a responsive and unified interface to display the data to the user. It provides powerful ad hoc reporting capabilities and integrates Jasper and Eclipse BIRT in one unified environment.
Homepage:- https://reportserver.net/en/
Download Link:- https://reportserver.net/en/download/
ReportServer Live Demo:- http://demo.raas.datenwerke.net/ReportServer.html
java -version && echo $JAVA_HOME && groupadd tomcat
useradd -M -s /bin/nologin -g tomcat -d /opt/tomcat tomcat
wget https://archive.apache.org/dist/tomcat/tomcat-8/v8.5.15/bin/apache-tomcat-8.5.15.tar.gz
mkdir /opt/tomcat
tar xvf apache-tomcat-8*tar.gz -C /opt/tomcat –strip-components=1
chown -R tomcat:tomcat /opt/tomcat

yum -y install postgresql-server postgresql-contrib
postgresql-setup initdb
systemctl start postgresql && systemctl enable postgresql
sudo -u postgres psql postgres
password postgres
Press:- Ctrl+d

sudo -u postgres createdb reportserver
sudo -u postgres createuser -P -s -e reportserver
sudo -u postgres psql
GRANT ALL PRIVILEGES ON DATABASE reportserver TO reportserver;
Press:- Ctrl+d

nano /var/lib/pgsql/data/pg_hba.conf
systemctl restart postgresql

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/*
unzip reportserver.zip -d /opt/tomcat/webapps/ROOT/
cp /opt/tomcat/webapps/ROOT/WEB-INF/classes/persistence.properties.example /opt/tomcat/webapps/ROOT/WEB-INF/classes/persistence.properties
nano /opt/tomcat/webapps/ROOT/WEB-INF/classes/persistence.properties
hibernate.connection.username=reportserver
hibernate.connection.password=toor
hibernate.dialect=net.datenwerke.rs.utils.hibernate.PostgreSQLDialect
hibernate.connection.driver_class=org.postgresql.Driver
hibernate.connection.url=jdbc:postgresql://localhost/reportserver
chown -R tomcat:tomcat /opt/tomcat/webapps/ROOT/
psql -U reportserver -d reportserver -a -f /opt/tomcat/webapps/ROOT/ddl/reportserver-RS3.0.2-5855-schema-PostgreSQL_CREATE.sql

nano /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
systemctl start tomcat && systemctl enable tomcat && systemctl status tomcat
http://127.0.0.1:8080
Default Username :- root
Default Password :- root
======================================================

source

centos 7