Jasper installation using existing PosgreSQL on remote host

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?
 
nisha.saini's picture
Joined: May 2 2016 - 12:57am
Last seen: 5 years 3 months ago

3 Answers:

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<span style="color: rgb(51, 153, 51);">=</span>postgres
dbPassword<span style="color: rgb(51, 153, 51);">=</span>postgre

http://community.jaspersoft.com/documentation/tibco-jasperreports-server...

hozawa's picture
125760
Joined: Apr 24 2010 - 4:31pm
Last seen: 2 years 11 months ago

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

nisha.saini's picture
Joined: May 2 2016 - 12:57am
Last seen: 5 years 3 months ago

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?

Igor Zubov's picture
Joined: Jul 20 2016 - 10:51am
Last seen: 4 years 7 months ago
Feedback
randomness