Repository is empty

rlfisherpbtgroup.com · January 3, 2013

I have clearly lost my mind. I normally run JR-S (v4.5.0) on various LInux servers. I have a backup install on a Windows laptop - it has always run fine in the past, but I have not started it in a long time. This morning, I had the need to run JR-S on the Windows machine and all of the views (repository, users, etc.) are EMPTY. The web app does not show any folders or anything else. It DID allow me to login with credentials I have previously setup. Where did everything go?

oesina · January 4, 2013

Do you have anyinformation in your webserver log? Could you login as superuser? Could you check just the database for repository elements?

Do you see nothing at all - like even no folders?

rlfisherpbtgroup.com · January 4, 2013

Thanks for your helpful ideas. I could login as jasperadmin as well as my personal admin name - so there must be something in the database. The web view shows no folders on the left and nothing on the right. I can view the users screen and see NO users.

I normally use MySQL - I found the psql client for postgres but I have no idea what the password is for that db server. I think the fastest solution for me is to uninstall JR-S and reinstall and reimport my repository. Not as satisfying as solving the mystery, but should get me back in business.

tkavanagh · January 4, 2013

Yes, I think a re-install would be good at this point. Once you have multiple JRS servers running, its easy to lose track of which one is pointing where (happens to me for sure).

Also, for future reference, a good way to find the *exact* database location and credentials will be to check the file in this location:

/apache-tomcat/webapps/jasperserver/META-INF/context.xml

This is the database connection pool configuration information used by jasperserver.

Sometimes, Tomcat copies that exact same file to this location and uses it (depends on the tomcat version):

/apache-tomcat/conf/Catalina/localhost/jasperserver.xml

rlfisherpbtgroup.com · January 4, 2013

Thanks - just to be clear, I only had one JRS installed on the Windows machine (for offline use). I have other JRs installed on a production Linux and a "sandbox" Linux machine. No idea why this one (Windows) suddenly misbehaves, but I am optimistic a reinstall and fresh repository import will work.

rlfisherpbtgroup.com · January 8, 2013

I completely uninstaled JR-S 4.5.0 (including bundled tomcat and postgresql), and reinstalled (build 20120110-1602). I started up the server, logged in as jasperadmin, and the repository view is still empty. I imported all our work product, restarted the server, and the view is still empty BUT MY LOGINS ARE PRESENT. I have no theory why the server is no longer showing any of the repository contents.

rlfisherpbtgroup.com · January 8, 2013

Here is something interesting from the log upon startup:

Jan 8, 2013 2:06:21 PM org.apache.catalina.startup.Catalina start

INFO: Server startup in 10908 ms

Jan 8, 2013 2:06:25 PM org.apache.catalina.core.StandardWrapperValve invoke

SEVERE: Servlet.service() for servlet JavaScriptServlet threw exception

java.lang.NullPointerException

at org.owasp.csrfguard.servlet.JavaScriptServlet.writeJavaScript(JavaScriptServlet.java:146)

at org.owasp.csrfguard.servlet.JavaScriptServlet.doGet(JavaScriptServlet.java:97)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399)

at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67)