Jasper installation using existing PosgreSQL on remote host

[nisha.saini]

Hi

I am trying to install jasperreports-server-cp-6.2.1-linux-x64-installer.run in Redhat 7.2 VM using non-root user. I am using existing Tomcat on local and existing Postgres on remote (RDS instance). Till tomcat part all is good. But while DB part,I get the following error:

 Installing

 0% ______________ 50% ______________ 100%

 ########################################Warning: Problem running post-install step. Installation may not complete

correctly

 Error running /usr/bin/createdb -U postgres -p 5432 -h

pgreportdb.prod-jiodrive.com -O jasperdb -E UTF-8 jasperserver: createdb:

database creation failed: ERROR:  must be member of role "jasperdb"

 

If i press enter and continue following error appears:

 

Press [Enter] to continue:

 

Warning: Problem running post-install step. Installation may not complete

correctly

 Error running /home/myuser/jasperreports-server-cp-6.2.1/apache-ant/bin/ant

import-minimal-ce:

BUILD FAILED

/home/myuser/jasperreports-server-cp-6.2.1/buildomatic/bin/import-export.xml:32

7: The following error occurred while executing this line:

/home/myuser/jasperreports-server-cp-6.2.1/buildomatic/bin/import-export.xml:14

5: The following error occurred while executing this line:

/home/myuser/jasperreports-server-cp-6.2.1/buildomatic/bin/validation.xml:376:

The following error occurred while executing this line:

/home/myuser/jasperreports-server-cp-6.2.1/buildomatic/conf_source/db/postgresq

l/db.xml:58: The following error occurred while executing this line:

/home/myuser/jasperreports-server-cp-6.2.1/buildomatic/bin/validation.xml:434:

The following error occurred while executing this line:

/home/myuser/jasperreports-server-cp-6.2.1/buildomatic/bin/validation.xml:470:

Database doesn't exist. Treating problem with JDBC connection as unrecoverable

 

*** Once I got this error, I have tried manually creating jasperserver DB but that is also not working. And I am not using any JDBC drivers from my side added externally so far

Please tell what can be done to resolve this? Is this remote postgres issue or something with RDS?

 

[hozawa]

I usually use the war file installation instead of using the installer because I have less problem with it. Be sure to create a user on PostgreSQL with priviledge to create database and tables.

dbUsername=postgresdbPassword=postgre[/code]

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-community-project-installation-guide/v621/installing-war-0

[nisha.saini]

Thanks Hozawa

But even while installing from the .run file I tried creating user jasperdb manually and assigned createdb and createrole. It failed. How war file makes the changes, and could you tell where to add the below commands

dbUsername<span style="color: rgb(51, 153, 51);">=</span>postgres

dbPassword<span style="color: rgb(51, 153, 51);">=</span>postgre

[Igor Zubov]

Hi all, I stuck with the same problem as Nisha.  

Error running /usr/bin/createdb -U postgres -p 5432 -h

pgreportdb.prod-jiodrive.com -O jasperdb -E UTF-8 jasperserver: createdb:

database creation failed: ERROR:  must be member of role "jasperdb"

I created a user dbUsername: postgres, dbPassword postgres into a RDS Postgresql db. I could connect to the db using this username and password.

What user should be a member of the role "jasperdb"? Do I have to create a role "jasperdb" manually and what role do I have to grant to "jasperdb" then?

Nisha, have you successfully completed the installation finally?