Hi all,
i'm new in Pentaho world and I need an help to install server.
I use Mac OSX Snow Leopard (10.6.8).
I downloaded the biserver-ce from http://community.pentaho.com/ and I lunch start-pentaho.sh.
I don't work and I got these error from tomcat logs (catalina.out):
Code:
25-mar-2014 23.57.49 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: .:/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java
25-mar-2014 23.57.49 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8083
25-mar-2014 23.57.49 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 675 ms
25-mar-2014 23.57.49 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
25-mar-2014 23.57.49 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.36
25-mar-2014 23.57.49 org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor pentaho.xml
25-mar-2014 23.57.50 org.apache.catalina.startup.ContextConfig validateSecurityRoles
INFO: WARNING: Security role name PENTAHO_ADMIN used in an <auth-constraint> without being defined in a <security-role>
[Server@3fb6772a]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@3fb6772a]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@3fb6772a]: Initiating startup sequence...
[Server@3fb6772a]: Server socket opened successfully in 2 ms.
[Server@3fb6772a]: Database [index=0, id=0, db=file:../../data/hsqldb/sampledata, alias=sampledata] opened sucessfully in 1379 ms.
[Server@3fb6772a]: Database [index=1, id=1, db=file:../../data/hsqldb/hibernate, alias=hibernate] opened sucessfully in 38 ms.
[Server@3fb6772a]: Database [index=2, id=2, db=file:../../data/hsqldb/quartz, alias=quartz] opened sucessfully in 16 ms.
[Server@3fb6772a]: Startup sequence completed in 1439 ms.
[Server@3fb6772a]: 2014-03-25 23:57:52.941 HSQLDB server 1.8.0 is online
[Server@3fb6772a]: To close normally, connect and execute SHUTDOWN SQL
[Server@3fb6772a]: From command line, use [Ctrl]+[C] to abort abruptly
23:58:02,817 ERROR [ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.h2.tools.Server' defined in file [/Users/enfix/pentaho/biserver-ce2/pentaho-solutions/system/GettingStartedDB-spring.xml]: Invocation of init method failed; nested exception is org.h2.jdbc.JdbcSQLException: Exception opening port "9092" (port may be in use), cause: "java.net.BindException: Address already in use" [90061-131]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1338)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
    at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)
    at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
    at org.apache.catalina.core.StandardService.start(StandardService.java:525)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.h2.jdbc.JdbcSQLException: Exception opening port "9092" (port may be in use), cause: "java.net.BindException: Address already in use" [90061-131]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
    at org.h2.message.DbException.get(DbException.java:156)
    at org.h2.util.NetUtils.createServerSocketTry(NetUtils.java:175)
    at org.h2.util.NetUtils.createServerSocket(NetUtils.java:141)
    at org.h2.server.TcpServer.start(TcpServer.java:200)
    at org.h2.tools.Server.start(Server.java:330)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1414)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1375)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
    ... 39 more
Caused by: java.net.BindException: Address already in use
    at java.net.PlainSocketImpl.socketBind(Native Method)
    at java.net.PlainSocketImpl.socketBind(PlainSocketImpl.java:521)
    at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:414)
    at java.net.ServerSocket.bind(ServerSocket.java:326)
    at java.net.ServerSocket.<init>(ServerSocket.java:192)
    at java.net.ServerSocket.<init>(ServerSocket.java:104)
    at org.h2.util.NetUtils.createServerSocketTry(NetUtils.java:171)
    ... 49 more
25-mar-2014 23.58.02 org.apache.catalina.core.StandardContext start
GRAVE: Error listenerStart
25-mar-2014 23.58.02 org.apache.catalina.core.StandardContext start
GRAVE: Context [/pentaho] startup failed due to previous errors
23:58:02,946 ERROR [Logger] Error: Pentaho
23:58:02,946 ERROR [Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: PentahoSystem.ERROR_0015 - Errore nel tentativo di esecuzione della sequenza di shutdown per org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceSystemListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ICacheManager' defined in file [/Users/enfix/pentaho/biserver-ce2/pentaho-solutions/system/pentahoObjects.spring.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.pentaho.platform.plugin.services.cache.CacheManager]: Constructor threw exception; nested exception is java.lang.NullPointerException
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:883)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:826)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
    at org.pentaho.platform.engine.core.system.objfac.spring.SpringPentahoObjectReference.getObject(SpringPentahoObjectReference.java:47)
    at org.pentaho.platform.engine.core.system.objfac.AggregateObjectFactory.get(AggregateObjectFactory.java:203)
    at org.pentaho.platform.engine.core.system.objfac.AggregateObjectFactory.get(AggregateObjectFactory.java:87)
    at org.pentaho.platform.engine.core.system.PentahoSystem.getCacheManager(PentahoSystem.java:1097)
    at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceSystemListener.shutdown(PooledDatasourceSystemListener.java:68)
    at org.pentaho.platform.engine.core.system.PentahoSystem.shutdown(PentahoSystem.java:922)
    at org.pentaho.platform.web.http.context.SolutionContextListener.contextDestroyed(SolutionContextListener.java:236)
    at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4245)
    at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4886)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4750)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)
    at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
    at org.apache.catalina.core.StandardService.start(StandardService.java:525)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.pentaho.platform.plugin.services.cache.CacheManager]: Constructor threw exception; nested exception is java.lang.NullPointerException
    at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
    at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:61)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:877)
    ... 42 more
Caused by: java.lang.NullPointerException
    at org.pentaho.platform.engine.core.system.SystemSettings.getAbsolutePath(SystemSettings.java:182)
    at org.pentaho.platform.engine.core.system.PathBasedSystemSettings.getAbsolutePath(PathBasedSystemSettings.java:89)
    at org.pentaho.platform.engine.core.system.SystemSettings.getFile(SystemSettings.java:163)
    at org.pentaho.platform.engine.core.system.SystemSettings.getSystemSettingsDocument(SystemSettings.java:135)
    at org.pentaho.platform.engine.core.system.SystemSettings.getSystemSetting(SystemSettings.java:87)
    at org.pentaho.platform.engine.core.system.SystemSettings.getSystemSetting(SystemSettings.java:99)
    at org.pentaho.platform.engine.core.system.PathBasedSystemSettings.getSystemSetting(PathBasedSystemSettings.java:69)
    at org.pentaho.platform.plugin.services.cache.CacheManager.<init>(CacheManager.java:167)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:100)
    ... 44 more
23:58:02,965 ERROR [Logger] Error end:
[Server@3fb6772a]: Initiating shutdown sequence...
[Server@3fb6772a]: Shutdown sequence completed in 1 ms.
[Server@3fb6772a]: 2014-03-25 23:58:02.967 SHUTDOWN : System.exit() was not called
25-mar-2014 23.58.03 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
GRAVE: The web application [/pentaho] registered the JDBC driver [org.h2.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
25-mar-2014 23.58.03 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/pentaho] appears to have started a thread named [HSQLDB Timer @55c79dfc] but has failed to stop it. This is very likely to create a memory leak.
25-mar-2014 23.58.03 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/pentaho] appears to have started a thread named [H2 Log Writer DB] but has failed to stop it. This is very likely to create a memory leak.
25-mar-2014 23.58.03 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/pentaho] appears to have started a thread named [H2 Log Writer DB] but has failed to stop it. This is very likely to create a memory leak.
25-mar-2014 23.58.03 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/pentaho] appears to have started a thread named [DefaultQuartzScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak.
25-mar-2014 23.58.03 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/pentaho] appears to have started a thread named [DefaultQuartzScheduler_Worker-2] but has failed to stop it. This is very likely to create a memory leak.
25-mar-2014 23.58.03 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/pentaho] appears to have started a thread named [DefaultQuartzScheduler_Worker-3] but has failed to stop it. This is very likely to create a memory leak.
....
....
....
But I'm not desperate and I tried to set mysql database following this post http://pentaho-bi-suite.blogspot.it/...1-ce-with.html.
Now the errors are disappeared (or not ?) (catalina.out):
Code:
25-mar-2014 23.37.14 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: .:/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java
25-mar-2014 23.37.14 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8081
25-mar-2014 23.37.14 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 667 ms
25-mar-2014 23.37.14 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
25-mar-2014 23.37.14 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.36
25-mar-2014 23.37.14 org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor pentaho.xml
25-mar-2014 23.37.15 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory pentaho-style
25-mar-2014 23.37.15 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory ROOT
25-mar-2014 23.37.15 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory sw-style
25-mar-2014 23.37.15 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8081
25-mar-2014 23.37.15 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8010
25-mar-2014 23.37.15 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/32  config=null
25-mar-2014 23.37.15 org.apache.catalina.startup.Catalina start
INFO: Server startup in 1334 ms
25-mar-2014 23.48.32 org.apache.coyote.http11.Http11Protocol pause
INFO: Pausing Coyote HTTP/1.1 on http-8081
25-mar-2014 23.48.33 org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
25-mar-2014 23.48.33 org.apache.coyote.http11.Http11Protocol destroy
INFO: Stopping Coyote HTTP/1.1 on http-8081
Ignore the port number of both solutions, I change it in server.xml.
Help me please.