no pg_hba.conf entry for host "", user "enterprise_demo_user", database "postgres", SSL off


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 "", 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 like so:

appServerDir =  /path/to/apache-tomcat-6.0.37
# database type
# database location and connection settings
I cant see a place where I can tell jasper which database to use instead of the default db called postgres.
Komu W.
komuw05's picture
Joined: Jan 29 2014 - 2:46am
Last seen: 9 years 7 months ago

2 Answers:

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.

yohei.onishi's picture
Joined: May 24 2013 - 8:55pm
Last seen: 8 years 12 months ago

Thanks for answering, I'm on a shared server hosting plan(webfaction) and thus I dont have access to the default postgres database. That's why I was asking if there is a way I could choose a different database rather than the deafult postres database?

komuw05 - 9 years 7 months ago

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/ 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).

You can:

cd buildomatic

./js-ant create-js-db

./js-ant init-js-db-ce  (assuming you are using the Community version of JRS. Otherwise its "init-js-db-pro")

./js-ant import-minimal-data-ce

./js-ant deploy-webapp-ce

tkavanagh's picture
Joined: Jul 7 2006 - 8:54am
Last seen: 9 years 3 weeks ago

Thanks tkavanagh,

I was able to get it working, I basically had to move from shared hosting to a dedicated server[think digitalOcean].

Anyway, I like what I see with Jasper reports server community edition and I would now like to move to the jasper WAR file pro.
I have read the install manual chapter 14 on upgrading from community to Pro and apparently I have to contact 'technical support' to get the file?
Where are these technical support guys located?

Komu W.

komuw05 - 9 years 7 months ago