On most platforms, the default PostgreSQL installation doesn’t allow remote connections (as a security feature). You might also need to enable connections as described in the next section. Using your local PostgreSQL client tools, enter this command:
If necessary, install PostgreSQL client tools on your local, JasperReports Server machine. To verify that you can connect to the target remote PostgreSQL from the local installation machine : You can check the version of PostgreSQL instance by entering this command on the computer where it’s installed:įor instance: C:/Jaspersoft/PostgreSQL/9.0/bin/psql -version
The version of client tools should match the remote PostgreSQL version. If you are installing to a remote instance of PostgreSQL, you need the PostgreSQL client tools on your local machine. Using an Existing PostgreSQL on a Remote Host (And delete, if it exists: /apache-tomcat/conf/Catalina/localhost/jasperserver-pro.xml.) Then, make the same change in PostgreSQL using pgAdmin III or psql.
To change the jasperdb connection password in JasperReports Server, edit: /apache‑tomcat/jasperserver-pro/META-INF/context.xml. To improve system security, Jaspersoft recommends that you change the default password for jasperdb as soon as possible. Password - The installer creates this password for the jasperdb database user. Jasperdb - The installer creates this database user which is used to connect to jasperserver database. Postgres - The default administrative database user. The following table summarizes the parameters set during the installation of an existing PostgreSQL: Defaults Used If the installer displays an error message saying FATAL: password authentication failed for user postgres, try re‑entering the administrative password for your PostgreSQL database. Enter the database administrative user password and click Enter. The database administrative user account name postgres is used by default. You are also prompted for the default administrative account password of the PostgreSQL administrative user. Accept the default location for the PostgreSQL \bin directory, or click Browse to locate and select another location. If you have an instance of PostgreSQL installed locally, accept the default, which is 127.0.0.1, the localhost. If you choose the option to use an existing PostgreSQL database, you are eventually prompted for the location of PostgreSQL and the port to use. This will allow the PostgreSQL initdb to succeed with the desired UTF-8 database encoding.Ĭhoosing an Existing PostgreSQL on a Local Host If your Linux installation does not have a locale setting that supports UTF-8 encoding, your Bundled PostgreSQL instance will be initialized using a temporary locale (-locale=C).
Hard coded default: password - The installer uses this password for the jasperdb user. Hard coded default: jasperdb - The installer creates this user which is used to connect to the JasperReports Server database The installer cannot handle special characters at the end of a password string. Password of the database administrative user: postgres. The IP address or name of the machine where PostgreSQL is installed. User must choose an alternate port if 5432 is in use. The port number that PostgreSQL uses (default is 5432). The directory where the postgres and pgAdmin3 binaries are located. The following table summarizes the parameters set during installation of the bundled PostgreSQL: The installer sets the PostgreSQL administrator password to postgres and also creates a PostgreSQL database user with administrator privileges and credentials of jasperdb/password. In this case, choose an alternative port value. If the installer finds that port 5432 is already in use, you are prompted to pick an alternate port. The default PostgreSQL port 5432 will be used. If you choose the option to install the bundled PostgreSQL, the installer puts PostgreSQL 9 onto your system. I want to use an existing PostgreSQL database I want to use the bundled PostgreSQL database There are two options available for your PostgreSQL database: The installer is pre-configured to run with the PostgreSQL database. JasperReports Server requires a database in order to run.