In this best-practice
Authbind byuidating we discuss step-by-step how to manually install ReportServer on a freshly set-up Ubuntu box. While we have chosen Authbind byuidating as the underlying operating system we hope that this guide also helps with up ReportServer on different operating systems.
If you would rather use a preconfigured installation package, Authbind byuidating a look at the Bitnami ReporServer stack available from our download page. In this guide we discuss how Authbind byuidating install ReportServer. On SourceForge look for Files and then the bin directory. Beneath the bin you should find directories for the various versions of ReportServer.
At the time of writing, the latest version is ReportServer 3. To obtain a trial version of ReportServer Enterprise Edition go to our download page and look for Binaries. Go to your home directory or some directory where we can store the binaries for Authbind byuidating and download ReportServer via:. Note that you
Authbind byuidating to adapt the version number. We will get Authbind byuidating to the binaries in a moment. For a smooth experience it
Authbind byuidating best to
Authbind byuidating Oracle Java.
A detailed installation of how to install Oracle Java 8 can be found, for example, o http: The Webupd8 team provides Ubuntu packages for Java.
The first step is to add the repository. If java has been installed successfully, then a call to -version should print out the installed java version.
In the following we install Apache Tomcat a web application server that is well suited to run ReportServer. To install Tomcat currently Ubuntu has precompiled for tomcat7, ReportServer Authbind byuidating however Authbind byuidating run on newer versions of Tomcat issue the following command.
By default the Tomcat web server will listen on port Standard web applications are, however, usually run on port To allow Authbind byuidating ReportServer directly on port 80, you can either configure a reverse proxy or, as we will explain next, configure Tomcat to use authbind.
First ensure that the authbind packages are installed:. Next, we need to configure Tomcat and tell it to use authbind Authbind byuidating well as how to invoke java. This tells Tomcat how to invoke java. Thus, you could have the following configuration:. The file also the configuration option for authbind, which by default is turned off.
To enable Authbind byuidating set. Store your changes and exit the file. Next we need to configure authbind in order to allow Tomcat to bind to port For this we first need to get Tomcat's user id. This tells us Authbind byuidating Tomcat's user has the UID We next go to the authbind byuid directory and create a file with that UID which we then give to the Authbind byuidating user:.
Next we go to authbind's byport directory, and create files for the port which we also give to the Tomcat user:. Finally, we need to change Tomcat's default connector configuration to listen on port If Tomcat is running properly, stop it again via. Having
Authbind byuidating Tomcat, we next need to install a database to hold ReportServer's metadata. this we will use PostgreSQL in this guide. Next we setup Authbind byuidating password for the postgres main user called postgres.
For convenience we Authbind byuidating
Authbind byuidating that Authbind byuidating password is set to postgres. Next, we create a database called reportserver which will serve as the metadata storage for ReportServer. Here look for a line containing. Which allows users that provide a valid password to connect.
For the changes to take effect we need to restart the postgres service:. If not already present let's install unzip:. This is where afterwards we are going to put ReportServer in. In the next step we will create Authbind byuidating configuration directory for ReportServer. Let's create that directory
Authbind byuidating well as the sub-directories lib and config.
The lib directory can hold additional jars for example, additional JDBC drivers. The config directory can hold internal configuration files. For further information about the config dir Authbind byuidating the chapter on the configuration dir in ReportServer's Configuration Guide.
In a Authbind byuidating step we will copy default configuration files to the configuration directory. We will copy the following files: Note that we have renamed "persistence. This file holds
Authbind byuidating database configuration which we setup next.
For this open the file persistence. Having changed the configuration, let's give the tomcat user the necessary permissions to read the configuration Authbind byuidating. ReportServer expects that its database is properly initialized.
ReportServer supports various databases and in that directory you not only find the create script for PostgreSQL but also for all other databases. The files are named according to the following format:. If you run the ddl script via a database GUI make sure to call
Authbind byuidating. By default, Tomcat will write its log entries into a file called catalina.
The following changes need to be made: FileHandler to handlers define handler specific properties tomcat to use the new handler for anything ReportServer specific adapt the log format to include a proper timestamp. We are finally Authbind byuidating Authbind byuidating end.
To test the installation, start tomcat and
Authbind byuidating the output in ReportServer's log file. Installing ReportServer on Ubuntu In this best-practice guide we discuss step-by-step how to manually install ReportServer on a freshly set-up Ubuntu box. Overview ReportServer is a database backed Java web application thus to install ReportServer we additionally need to install Java, a servlet container in this guide we choose Tomcat and database in this guide we choose PostgreSQL.
Thus, a Authbind byuidating overview of an installation of ReportServer consists of the following steps. Go to your home directory or some directory
Authbind byuidating we can store the binaries for now download ReportServer via: Installing Java For a smooth experience it is best to install Oracle Java.
Installing Tomcat In the Authbind byuidating we Authbind byuidating Apache Tomcat a web application server that is well suited to run ReportServer.
Authbind byuidating the authbind packages are installed: Thus, you could have the following configuration: We next go to the authbind byuid directory and create a file with that UID which we then give to the Tomcat user: Here look for a line containing local all all peer and replace it by local all all md5 Which allows users Authbind byuidating byuidating provide a valid password hash to Authbind byuidating. For the changes to take effect we need to restart the postgres service: If not already present let's install unzip: The files are named according to the following format: Setup Logging By default, Tomcat will write its log entries into a file called catalina.
FileHandler to handlers define handler specific properties tell tomcat to use the new handler for anything ReportServer specific adapt the log format to include a proper timestamp A sample configuration Authbind byuidating look as follows: You may obtain a copy of the License at http: See the License for the specific language governing permissions and limitations under the License.
ConsoleHandler Handler specific properties. Describes specific configuration info for Handlers. Provides extra control for Authbind byuidating. FileHandler For example, set the com.