Jasper installation using existing PosgreSQL on remote host
Posted on June 15, 2016 at 12:40am
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?
Joined: May 2 2016 - 12:57am
Last seen: 5 years 3 months ago
Posted on June 15, 2016 at 2:29am
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...
Joined: Apr 24 2010 - 4:31pm
Last seen: 2 years 11 months ago
Posted on June 16, 2016 at 3:29am
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
Joined: May 2 2016 - 12:57am
Last seen: 5 years 3 months ago
Posted on March 18, 2017 at 5:47am
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?
Joined: Jul 20 2016 - 10:51am
Last seen: 4 years 7 months ago