Changed db password for user "postgres" - What configs need to be updated to get JasperReports to work again?

0

I changed the password for db username = postgres

It appears that JasperReports had the old password in some config(s) file and now it doesn't work.

What do I need to do here? I'm guessing I need to find the relevant config files and update them? If so, which ones? If not, what do I do?

itgroup's picture
35
Joined: Jul 23 2016 - 12:19pm
Last seen: 9 months 4 weeks ago

Lol.

user = postgres

original password = postgres

But anyone else facing this problem should look at marianol's answer.

itgroup - 3 years 7 months ago

3 Answers:

1

You need to change the JNDI connection to the repo, that is defined in <TOMCAT>/webapps/jasperserver-pro/META-INF/context.xml

There look for the JNDI connection called jdbc/jasperserver and change the password to the new one

    <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"
        maxActive="100" maxIdle="30" maxWait="10000"
        username="postgres" password="postgres"
        driverClassName="org.postgresql.Driver"
        accessToUnderlyingConnectionAllowed = "true"
        validationQuery="SELECT 1"
        testOnBorrow="true"
        url="jdbc:postgresql://localhost:5432/jasperserver"
        factory="com.jaspersoft.jasperserver.tomcat.jndi.JSBasicDataSourceFactory"
         />
marianol's picture
5018
Joined: Sep 13 2011 - 8:04am
Last seen: 1 year 6 months ago
0

We had the same problem with the WAR installation.

The WAR installation explodes with multiple config files and its not an easy thing to find the relevant files which needs to be modified. 

We had to start from scratch and explode the WAR with the required password and then it worked.

 

reportdev's picture
1242
Joined: Oct 12 2015 - 12:05pm
Last seen: 2 weeks 2 days ago
0

Lol.

 

user = postgres

original password = postgres

itgroup's picture
35
Joined: Jul 23 2016 - 12:19pm
Last seen: 9 months 4 weeks ago
Feedback
randomness