Jump to content

Help with new installation of JasperServer 5.2.0 with MySQL - almost there!

Go to solution Solved by schultcd,

Recommended Posts

I had existing Tomcat and MySQL installs, so I chose to use the WAR distribution and I'm having a bit of trouble. I can login to JasperServer via the web interface, but it appears that I can't actually do anything -- like upload a new report, for instance.

Linux x86-64, Oracle Java 6, JasperServer Community Edition 5.2.0, MySQL 5.5, Tomcat 7.0.42.

I used buildomatic:

  1. Copied `sample_conf/mysql_master.properties` to `default_master.properties` and customized as appropriate
  2. Ran `./js-ant create-js-db`
  3. Ran `./js-ant init-js-db-ce`
  4. Ran `./js-ant import-minimal-ce`
  5. Ran `./js-ant deploy-webapp-ce`

There was one snag during this procedure: buildomatic really wants to have root privileges, so I used root/[password] for the create-js-db part, then changed the `dbUsername` and `dbPassword` to something else because I don't want to use root for everything -- like from the webapp. I did a `GRANT ALL PRIVILEGES` on the `jasperserver` database and then performed steps 3, 4, and 5 using the alternative credentials.

When launching Tomcat, I get this error:

2013-09-04 14:05:11,777 ERROR JNDIResourceProvider,localhost-startStop-1:75 - error closing context
javax.naming.OperationNotSupportedException: Context is read only
        at org.apache.naming.NamingContext.checkWritable(NamingContext.java:962)
        at org.apache.naming.NamingContext.close(NamingContext.java:762)
        at com.tonbeller.tbutils.res.JNDIResourceProvider.close(JNDIResourceProvider.java:72)
        at com.tonbeller.tbutils.res.CompositeResourceProvider.close(CompositeResourceProvider.java:56)
        at com.tonbeller.tbutils.res.ResourcesFactory.initialize(ResourcesFactory.java:163)
        at com.tonbeller.tbutils.res.ResourcesFactory.<init>(ResourcesFactory.java:92)
        at com.tonbeller.tbutils.res.ResourcesFactory.<clinit>(ResourcesFactory.java:89)
        at com.tonbeller.tbutils.res.ResourcesFactoryContextListener.contextInitialized(ResourcesFactoryContextListener.java:23)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1113)
        at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1671)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:724)

I am able to login to JasperServer, but everything is ... empty. The "home" link takes me to the repository which contains "System Properties" and "Themes". The "Library" is completely empty with no obvious way to add something to it -- like a report. I can't even figure out how to create a data source. About a year ago, I used the "real" installer on a Windows XP virtual machine and was up and running pretty quickly, so I must have missed something critical, here.

Any suggestions?

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

I think everything is running fine. Although you will need to keep an eye on the start up error to make sure that is not an issue. But if you can Login and then navigate around then I think everything is probably OK.

What you have is a "production style" installation regarding the default resources that are in place. When you run "js-ant import-minimal-ce", this puts the minimum resources (we also call these "core" resources) in place that are required to run JasperReports Server.

You can run an additional command to get the sample resources in place - then what you see after you login will be more normal because you will see sample reports which you can execute.

Also, the additional buildomatic command can be run while JRS is still running (don't need a re-start):

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

Hopefully, that does it for you.



Link to comment
Share on other sites

  • Solution

The problem was gross user error: I didn't realize that I had to right-click in the resource tree and "Add Resource", then upload a report.

The brief setup video I watched on the JasperSoft help site seemed to show a "home" screen with large "Get Started" buttons with things liks "Add Report", etc. on them. I don't see that kind of screen anywhere, so, being a newbie, I was a bit lost.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...