Changed db password for user "postgres" - What configs need to be updated to get JasperReports to work again?
Posted on August 18, 2016 at 10:21am
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?
Joined: Jul 23 2016 - 12:19pm
Last seen: 1 year 1 week ago
Posted on August 22, 2016 at 9:36am
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"
/>
Joined: Sep 13 2011 - 8:04am
Last seen: 4 years 5 months ago
Posted on August 18, 2016 at 10:34am
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.
Joined: Oct 12 2015 - 12:05pm
Last seen: 9 months 1 week ago
Posted on August 18, 2016 at 1:29pm
Lol.
user = postgres
original password = postgres
Joined: Jul 23 2016 - 12:19pm
Last seen: 1 year 1 week ago
Lol.
user = postgres
original password = postgres
But anyone else facing this problem should look at marianol's answer.