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

Posted on January 31, 2014 at 3:23am

Hi.

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:

jdbc:postgresql://localhost:5432}/postgres

I have edited the default_master.properties like so:

appServerDir =  /path/to/apache-tomcat-6.0.37
 
# database type
dbType=postgresql
 
# database location and connection settings
 
dbHost=localhost
dbUsername=my_user
dbPassword=my_password
 
BUT,
I cant see a place where I can tell jasper which database to use instead of the default db called postgres.
 
Thanks,
Komu W.
JasperReports® Server
komuw05's picture
komuw05
35
Joined: Jan 29 2014 - 2:46am
Last seen: 9 years 7 months ago

2 Answers:

Posted on January 31, 2014 at 10:16am

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.

http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html

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

Hi,
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
add comment
Posted on February 4, 2014 at 3:14pm

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

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
tkavanagh
16498
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?

Thanks,
Komu W.

komuw05 - 9 years 7 months ago
add comment
Feedback
randomness