Jasper installation using existing PosgreSQL on remote host

0

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: 2 years 10 months ago

3 Answers:

0

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
54510
Joined: Apr 24 2010 - 4:31pm
Last seen: 6 months 4 days ago
0

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: 2 years 10 months ago
0

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: 2 years 1 month ago
Feedback