So I have been trying to install the jasper reports server via the WAR file on my shared server at webfaction.
But I'm getting the following error when I try installing
no pg_hba.conf entry for host "127.0.0.1", user "my_user", database "postgres", SSL off
It appears like Jasper is trying to use the default database called postgres [a database that I do not have access to on the shared host].
How can I get jasper reports server to use another database because currently the connection its trying to make looks like:
I have edited the default_master.properties like so:
You do not need to specify different database. It seems that you do not have an authority to access to the postgres database from localhost with "my_user" user. Please check your configuration of pg_hba.conf.
Yes, it looks like there is a privileges issue here. I think that with most hosting services, you will need to make a request to the administrators of the hosting service to give you additional privileges that will allow you to create a new database.
The database that you will need to create is called "jasperserver" (because the JasperReports Server web application requires a database to function).
Your buildomatic/default_master.properties looks good to me. You can take a look at the "step by step" installation in Section 5.7 "Installing the War File Manually" in the 5.5 version of the JasperReports Server Install Guide (look in <unpack-dir>/docs/JasperReports-Server-Install-Guide.pdf).
./js-ant init-js-db-ce (assuming you are using the Community version of JRS. Otherwise its "init-js-db-pro")