Hitachi Vantara Pentaho Community Wiki
Skip to end of metadata
Go to start of metadata

The performance of this installation will depend on many factors but it should run without a problem on almost all platforms and configurations.

Installation

Create a new directory on your hard disk. We recommend that you select a name and location that you are likely to remember.  Note:  Wherever you install Pentaho-demo, be certain that none of it's parent directories contain spaces.  This could lead to problems running certain examples.

Using your favorite unzip utility, extract the file that you downloaded into your new directory.

Extract your downloaded file to the directory of your choice. Windows XP comes with an extraction utility called "Compressed Folders" that you can access from the right-click | Open With... menu. If you are using an older version of Windows, you will need to use an extraction utility, such as WinZip.

Database Configuration

If installing the Hypersonic version of the Preconfigured Installation, the installation is complete.  If installing the MySQL version of the Preconfigured Installation, you must configure MySQL.

The Preconfigured Installation does not come with MySQL.  First, install MySQL on the local machine with the default configuration using port 3306.  As a MySQL administrator, source the file "data/SampleDataDump_MySql.sql". This file will install the appropriate users and databases in your local MySQL installation.

Example

Run the mysql command in your directory MySQL Server x.x/bin:
mysql -u root -p -e "source* Your path*\data\SampleDataDump_MySql.sql"

Keep in mind that if you have the MySQL GUI Tools installed you can use the "MySQL Browser" to execute the .sql script from a desktop client. Additional configuration such as user ids, passwords, catalogs and permission settings can be easily configured using the "MySQL Administrator".

It may be necessary to add "localhost" to the user as the "Add host to which the user can connect" option. Every MySQL installation can be configure differently. Some might even need to disable their personal firewall settings, or add an exception to the port for MySQL, if attempting to install the complete Open BI Server on their desktop.

The Preconfigured Installation expects MySQL to be running on the local machine connected to the standard MySQL port, 3306.

 

Configuration

Version Checker and Positive Feedback

The Pentaho BI Server includes a version checker that reports whether a new version of the server is available. When performing a version check, the server makes an HTTP call to a Pentaho hosted application and exchanges information. This information is used to determine if there is a suitable update available.
The information is collected and used to analyze BI Server usage in different environments. This provides us with more accurate data during the release cycle when estimating how many people are using the software and how hardened the new features are. In addition, data from the version checker helps us to plan and prioritize platform certifications, testing plans, and localization plans.
For a complete description of why feedback is important:
http://wiki.pentaho.org/display/OpenScrum/Pentaho+Version+Checker
For information on exactly how the feature is implemented, what information is sent, and how to turn it off:
http://wiki.pentaho.org/display/ServerDoc1x/BI+Platform+Version+Checker
This service may be easily turned off by setting <version-check-config>/<disable> to true in the pentaho.xml
configuration file located in /pentaho-demo/pentaho-solutions/system/pentaho.xml
The Pentaho privacy policy:
http://community.pentaho.org/privacy/








Application and Sample Data

We provide all of the application and sample data required in auto-configured databases. This is done using several provided Hypersonic databases. Hypersonic is ideal for this type of installation for several reasons:

  • The database requires no configuration.
  • The database is only started when you start the installation (see below) and not when your computer starts.
  • When you stop the server (see below) the database stops and will not leave anything running in memory.

If you want to use the Pentaho BI Platform for anything other than demos and evaluation we recommend that you use a different database system. Later releases will provide database scripts for doing this. The platform persistence API is built on Hibernate, which should simplify the addition of most any DBMS.

Running the Server

Take a look in the directory where you extracted the Pre-Configured Installation. You should see one directory, 'pentaho-demo'. Inside the pentaho-demo directory, there are several other directories, and a few files.  For more information about the contents of the Pre-Configured Installation, refer to Manual Deployment of Pentaho.

The scripts in the root directory will start and stop the platform server, as well as the database services that are necessary for the platform to operate.

To start the server on a Windows computer, navigate using Windows explorer to the 'pentaho-demo' directory, and double click the 'start-pentaho.bat' file.


To start the server on a *nix machine, open a terminal window, navigate to the 'pentaho-demo' directory, and run the 'start-pentaho.sh' file (you must have the 'execute' rights to launch it on the 'start-pentho.sh', 'data/start_hypersonic.sh' and 'jboss/bin/run.sh' files).
After the script runs, you should have two command (or terminal) windows open, and the last line of one of the windows will read 'Pentaho BI Platform server ready' after 30 seconds or so. The messages you see in the other window are from the database server.

The user account that starts the BI Platform needs to have permission to create directories and files in the pentaho-demo/pentaho-solutions/system/content directory. If JBoss is installed as a service, the user account that starts the service needs to have create permissions also.


Stopping the Server

Take a look in the directory where you extracted the Pre-Configured Installation. You should see one directory, 'pentaho-demo'. Inside the pentaho-demo directory, there are several other directories, and a set of scripts.  For a more verbose description of the contents of the Pre-Configured Installation, refer to the Advanced Installation Guide.

The scripts in the root directory will start and stop the platform server, as well as the database services that are necessary for the platform to operate.

To stop the server on a Windows computer, simply open a command prompt (or Windows Explorer), navigate to the 'pentaho-demo' directory, and run the 'stop-pentaho.bat' file.


To stop the server on a *nix machine,  open a terminal window, navigate to the 'pentaho-demo' directory, and run the 'stop-pentaho.sh' file (you must have the rights to execute it).
After the script runs, the two command (or terminal) windows should close and the system will exit.

Un-Installation

If you wish to remove this installation on your computer you can delete the directory into which you installed it. This will remove the application from your machine. If you installed a Java SDK you will have to remove that separately.

Trying the Samples

If all has gone well to this point, you should be able to point your favorite browser at your newly installed Pentaho BI Platform server, and play around with the samples. The samples show how the Pentaho BI components can be embedded into web pages, both Portal pages and customized Java Server Pages. These sample pages are by no means the only way that you can access and use the BI components.

If you have installed the application onto a local machine (i.e., the same machine you will launch the client browser from), then the URL to reach the platform samples is http://localhost:8080/.

If you are trying to reach the samples from a remote machine (any machine that the platform is not physically located on), the URL will be http://<YourHostName>:8080/, substituting <YourHostName> with the machine name, IP address or DNS name of the machine where you installed the platform.

Using your favorite browser (we test with Firefox 1.5, Firefox 2.0, Netscape 7.2, Opera 7.5, Safari, and Microsoft Internet Explorer 6.0), navigate to http://localhost:8080/.


 
With any luck, you should see a web page similar to the snapshot below. If not, see Troubleshooting   This is the top level content navigation page.
 

No web page?

The Pentaho Platform uses port 8080 as the default port to run the server on. This is a fairly common port used as default in many web applications and application servers. If the server console has error messages along the lines of "Bind - port already in use", there is a good chance that another application is using port 8080. The simplest solution is to find the application that is using port 8080, and shut that application down for the duration of your evaluation. If this is not an option see 04. Changing Server Port for information on how to change the default port.











  • No labels

17 Comments

  1. Anonymous

    I believe this documentation is now out of date for the current version. I am new to pentaho and was looking forward to using the pre-configed get it working immediately version. So I have downloaded both the hypersonic and MySQL versions and neither work. I have tried changing port and that has no effect.

    At least with the MySQL version I managed to get the first page up. However this is different to the one detailed above and asks for user id's. If i put one the ones pre-configured I get the following error:

    type Exception report

    message

    description The server encountered an internal error () that prevented it from fulfilling this request.

    exception

    javax.servlet.ServletException: Filter execution threw an exception
    org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
    org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
    org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

    root cause

    java.lang.NoClassDefFoundError
    org.pentaho.repository.runtime.RuntimeRepository.setSession(RuntimeRepository.java:75)
    org.pentaho.core.system.PentahoSystem.getRuntimeRepository(PentahoSystem.java:1144)
    org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:205)
    org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:169)
    org.pentaho.core.system.PentahoSystem.sessionStartup(PentahoSystem.java:832)

    Anyone know where to get any updated config docs? Or have any ideas?

  2. Anonymous

    I am seeing the same problem. I installed pentaho_demo_mysql5-1.6.0.GA.863.tar.gz on a Linux machine and I successfully built the MySQL sample database, but after running start-pentaho.sh, pulling up http://localhost:8080/pentaho/, and logging in as "Joe (Admin)" (or any of the other sample users) I get the following server error:

    HTTP Status 500 -


    type Exception report

    message

    description The server encountered an internal error () that prevented it from fulfilling this request.

    exception javax.servlet.ServletException: Filter execution threw an exception
    org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
    org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
    org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
    root cause java.lang.NoClassDefFoundError
    org.pentaho.repository.runtime.RuntimeRepository.setSession(RuntimeRepository.java:75)
    org.pentaho.core.system.PentahoSystem.getRuntimeRepository(PentahoSystem.java:1144)
    org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:205)
    org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:169)
    org.pentaho.core.system.PentahoSystem.sessionStartup(PentahoSystem.java:832)
    com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:70)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
    org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
    org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
    org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)

    org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
    note The full stack trace of the root cause is available in the JBossWeb/2.0.0.GA logs.

  3. Anonymous

    Don't forget you need to setup the database manually if you are using the MySQLbundle, as follows:

    Run the mysql command in your directory MySQL Server x.x/bin:
    
    mysql -u root -p -e "source* Your path*\data\SampleDataDump_MySql.sql"
    
  4. Anonymous

    Some how the mysql users are not created properly through the sql script provided. Change the grant commands in the sql, as an example change:

    grant all on hibernate.* to hibuser identified by 'password';

    to

    grant all on hibernate.* to hibuser@localhost identified by 'password';

    or

    grant all on hibernate.* to hibuser@% identified by 'password'; 

  5. Anonymous

    Hello,

    I only wanted to let you know I have a succesfull installation following this documentation using 1.6 GA. I just installed the opensource installer (after installing MySql myself) and everything works without me doing anything. I did not even insert the SQL in MySql. The installer asked me for my MySql settings (port, password, ect) so I guessed it would do it for me. In the MySQL Administration tool I see the Hibernate, Quartz, ect added.

    Going to localhost:8080 is working for me. One question. How can you get prefent the DOS-box (Pentaho JBoss server) from sight?

    Greetings,
    Jeroen

  6. Anonymous

    mysql -u root -p -e "source* Your path*\data\SampleDataDump_MySql.sql"
    

    should read:

     mysql -u root -p -e "source <path to SampleDataDump_MySql.sql>"
    

     for example:

     mysql -u root -p -e "source c:\pentaho\data\SampleDataDump_MySql.sql"
    


  7. Anonymous

    I was getting the same error and I did the following to fix it.

    Changed all the users created by the script to @localhost instead of @% and I noticed that the script in the data folder didn't grant access all rights to the newly created users. So I did a grant all for the users created by the script and now it works like a Charm

  8. I again decided to delete the entire directory c: \ pentaho which had installed the software.
     
    Run the program again pentaho-1.6.0GA-windows-opensource-installer.exe and using the installation wizard told him that installation services mysql and jboss.

    Again install jboss services and mysql using the serviceinstall install jboss serviceinstall and install mysql which is in the directory C: \ pentaho \ bin \

    Run the program c: \ pentaho \ start-pentaho.bat

    Using a tool called mysql MySQLAdministrator.exe which can be downloaded from mysqladministrator link Windows (x86) update all permits as shown by the figures.

     

    Run the program c: \ pentaho \ stop pentaho.bat

    Ready and works properly.

  9. Anonymous

    For the Linux install, I also had to grant privs to pentaho_user for the hibernate database, otherwise the install script would fail.  I also had to change the case for the database names when responding to the install script prompts (i.e. "hibernate" and "quartz", instead of "Hibernate" and "Quartz").

    grant all on hibernate.* to pentaho_user identified by 'password';

    -mlimotte

  10. Anonymous

    I'm happy to see some successful posts!  Gives me some hope.  I'm on linux, installed mysql, using the preconfiged package.  I should have nothing else running on 8080.  I get errors (listed below) when I run start-pentaho.sh.  I did this as root to avoid permission problems for now.

    Thanks in advance for any thoughts or tips you might have.  -pentaho-wannabe# ./start-pentaho.sh

    --------------------------------------------------------------------------------------------

    The Pentaho BI Platform now contains a version checker that will notify you when newer versions of the software are available. The version checker is enabled by default.

    For information on what the version checker does, why it is beneficial, and how it works see:http://wiki.pentaho.org/display/ServerDoc1x/BI+Platform+Version+CheckerPress Enter to continue, or type cancel or Ctrl-C to prevent the server from starting.

    You will only be prompted once with this question.

    --------------------------------------------------------------------------------------------

    [OK]:

    =========================================================================

    JBoss Bootstrap Environment

    JBOSS_HOME: /usr/local/pentaho/pentaho-demo/jboss

    JAVA: java

    JAVA_OPTS: -Dprogram.name=run.sh -Xms128m -Xmx512m -XX:MaxPermSize=256m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Djava.awt.headless=true -Djava.io.tmpdir=/tmp/ -Djava.net.preferIPv4Stack=true

    CLASSPATH: /usr/local/pentaho/pentaho-demo/jboss/bin/run.jar

    =========================================================================

    Warning: -Xms128m not understood. Ignoring.

    Warning: -Xmx512m not understood. Ignoring.

    Warning: -XX:MaxPermSize=256m not understood. Ignoring.

    Exception in thread "main" java.lang.NoClassDefFoundError: while resolving class: org.jboss.mx.util.ObjectNameFactory

    at java.lang.VMClassLoader.resolveClass(java.lang.Class) (/usr/lib/libgcj.so.5.0.0)

    at java.lang.Class.initializeClass() (/usr/lib/libgcj.so.5.0.0)

    at _Jv_ResolvePoolEntry(java.lang.Class, int) (/usr/lib/libgcj.so.5.0.0)

    at org.jboss.system.server.ServerImpl.<clinit>() (Unknown Source)

    at java.lang.Class.initializeClass() (/usr/lib/libgcj.so.5.0.0)

    at java.lang.Class.newInstance() (/usr/lib/libgcj.so.5.0.0)

    at org.jboss.system.server.ServerLoader.createServer(java.lang.String, java.lang.ClassLoader) (Unknown Source)

    at org.jboss.system.server.ServerLoader.load(java.lang.ClassLoader) (Unknown Source)

    at org.jboss.Main.boot(java.lang.String[]) (Unknown Source)

    at org.jboss.Main$1.run() (Unknown Source)

    at java.lang.Thread.run() (/usr/lib/libgcj.so.5.0.0)

    at _Jv_ThreadRun(java.lang.Thread) (/usr/lib/libgcj.so.5.0.0)

    at GC_start_routine (/usr/lib/libgcj.so.5.0.0)

    at __clone (/lib/tls/libc-2.3.4.so)

    Caused by: java.lang.ClassNotFoundException: java.lang.StringBuilder not found in [file:/usr/local/pentaho/pentaho-demo/jboss/lib/endorsed/serializer.jar, file:/usr/local/pentaho/pentaho-demo/jboss/lib/endorsed/xercesImpl.jar, file:/usr/local/pentaho/pentaho-demo/jboss/lib/endorsed/xalan.jar, file:/usr/local/pentaho/pentaho-demo/jboss/lib/jboss-jmx.jar, file:/usr/local/pentaho/pentaho-demo/jboss/lib/concurrent.jar, file:/usr/local/pentaho/pentaho-demo/jboss/lib/log4j-boot.jar, file:/usr/local/pentaho/pentaho-demo/jboss/lib/jboss-common.jar, file:/usr/local/pentaho/pentaho-demo/jboss/lib/jboss-system.jar, file:/usr/local/pentaho/pentaho-demo/jboss/lib/jboss-xml-binding.jar\]
    at java.net.URLClassLoader.findClass(java.lang.String) (/usr/lib/libgcj.so.5.0.0)

    at java.lang.ClassLoader.loadClass(java.lang.String, boolean) (/usr/lib/libgcj.so.5.0.0)

    at _Jv_FindClass(_Jv_Utf8Const, java.lang.ClassLoader) (/usr/lib/libgcj.so.5.0.0)

    at java.lang.Class.forName(java.lang.String, boolean, java.lang.ClassLoader) (/usr/lib/libgcj.so.5.0.0)

    at _Jv_BytecodeVerifier.verify_instructions_0() (/usr/lib/libgcj.so.5.0.0)

    at _Jv_VerifyMethod(_Jv_InterpMethod) (/usr/lib/libgcj.so.5.0.0)

    at _Jv_PrepareClass(java.lang.Class) (/usr/lib/libgcj.so.5.0.0)

    at _Jv_WaitForState(java.lang.Class, int) (/usr/lib/libgcj.so.5.0.0)

    at java.lang.VMClassLoader.linkClass0(java.lang.Class) (/usr/lib/libgcj.so.5.0.0)

    at java.lang.VMClassLoader.resolveClass(java.lang.Class) (/usr/lib/libgcj.so.5.0.0)

    ...13 more

  11. Anonymous

    Found my own problem.  I had the wrong java engine in the path - it needed 1.5.  Thanks...

  12. Anonymous

     Using the preconfigured installer on RedHat ES5.0 I get the following Java errors (it's longer than this) Complaing of

    ClassNotFOundException: javax.management.MBeanServer .

    Any ideas? 

    ----

    =========================================================================

      JBoss Bootstrap Environment

      JBOSS_HOME: /usr/local/share/httpd/ftproot/cme.pentaho/pentaho-demo/jboss

      JAVA: java

      JAVA_OPTS: -Dprogram.name=run.sh -Xms128m -Xmx512m -XX:MaxPermSize=256m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Djava.awt.headless=true -Djava.io.tmpdir=/tmp/ -Djava.net.preferIPv4Stack=true

      CLASSPATH: /usr/local/share/httpd/ftproot/cme.pentaho/pentaho-demo/jboss/bin/run.jar

    =========================================================================

    19:20:09,995 INFO  [Server] Starting JBoss (MX MicroKernel)...
    19:20:09,995 INFO  [Server] Release ID: JBoss [Trinity] 4.2.1.GA (build: SVNTag=JBoss_4_2_1_GA date=200707131605)
    19:20:09,996 INFO  [Server] Home Dir: /usr/local/share/httpd/ftproot/cme.pentaho/pentaho-demo/jboss
    19:20:09,996 INFO  [Server] Home URL: file:/usr/local/share/httpd/ftproot/cme.pentaho/pentaho-demo/jboss/
    19:20:09,996 INFO  [Server] Patch URL: null
    19:20:09,997 INFO  [Server] Server Name: default
    19:20:09,997 INFO  [Server] Server Home Dir: /usr/local/share/httpd/ftproot/cme.pentaho/pentaho-demo/jboss/server/default
    19:20:09,997 INFO  [Server] Server Home URL: file:/usr/local/share/httpd/ftproot/cme.pentaho/pentaho-demo/jboss/server/default/
    19:20:09,997 INFO  [Server] Server Log Dir: /usr/local/share/httpd/ftproot/cme.pentaho/pentaho-demo/jboss/server/default/log
    19:20:09,997 INFO  [Server] Server Temp Dir: /usr/local/share/httpd/ftproot/cme.pentaho/pentaho-demo/jboss/server/default/tmp
    19:20:09,997 INFO  [Server] Root Deployment Filename: jboss-service.xml
    19:20:10,608 INFO  [ServerInfo] Java version: 1.4.2,Free Software Foundation, Inc.
    19:20:10,608 INFO  [ServerInfo] Java VM: GNU libgcj 4.1.1 20070105 (Red Hat 4.1.1-51),Free Software Foundation, Inc.
    19:20:10,608 INFO  [ServerInfo] OS-System: Linux 2.6.20-1.2320.fc5smp,i386
    19:20:10,736 WARN  [ServiceController] Problem creating service jboss.system:service=MainDeployer
    java.lang.NoClassDefFoundError: $Proxy1
       at java.lang.Class.initializeClass(libgcj.so.7)
       at java.lang.reflect.Field.set(libgcj.so.7)
       at java.lang.reflect.Field.set(libgcj.so.7)
       at java.lang.reflect.Field.set(libgcj.so.7)
       at java.lang.reflect.Proxy$ClassFactory.generate(libgcj.so.7)
       at java.lang.reflect.Proxy.getProxyClass(libgcj.so.7)
       at java.lang.reflect.Proxy.newProxyInstance(libgcj.so.7)
       at org.jboss.mx.util.MBeanProxyExt.create(MBeanProxyExt.java:395)
       at org.jboss.mx.util.MBeanProxyExt.create(MBeanProxyExt.java:349)
       at org.jboss.mx.util.MBeanProxyExt.create(MBeanProxyExt.java:335)
       at org.jboss.system.server.ServerConfigLocator.locate(ServerConfigLocator.java:42)
       at org.jboss.deployment.MainDeployer.createService(MainDeployer.java:471)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalCreate(ServiceMBeanSupport.java:261)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:243)
       at java.lang.reflect.Method.invoke(libgcj.so.7)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
       at $Proxy0.create(Unknown Source)
       at org.jboss.system.ServiceController.create(ServiceController.java:331)
       at org.jboss.system.ServiceController.create(ServiceController.java:274)
       at java.lang.reflect.Method.invoke(libgcj.so.7)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
       at $Proxy0.create(Unknown Source)
       at org.jboss.system.ServiceController.create(ServiceController.java:331)
       at org.jboss.system.ServiceController.create(ServiceController.java:274)
       at java.lang.reflect.Method.invoke(libgcj.so.7)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.system.server.ServerImpl.startBootService(ServerImpl.java:564)
       at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:446)
       at org.jboss.system.server.ServerImpl.start(ServerImpl.java:367)
       at org.jboss.Main.boot(Main.java:201)
       at org.jboss.Main$1.run(Main.java:514)
       at java.lang.Thread.run(libgcj.so.7)
    Caused by: java.lang.ClassNotFoundException: javax.management.MBeanServer
       at java.lang.ClassLoader.findClass(libgcj.so.7)
       at java.lang.ClassLoader.loadClass(libgcj.so.7)
       at java.lang.ClassLoader.loadClass(libgcj.so.7)

    ----


  13. Anonymous

    Hi, I just tried this too, and got the following trace. Any suggestions out there?

     Exception in thread "main" java.lang.NoClassDefFoundError: while resolving class: org.jboss.mx.util.ObjectNameFactory
       at java.lang.VMClassLoader.transformException(java.lang.Class, java.lang.Throwable) (/usr/lib/libgcj.so.6.0.0)
       at java.lang.VMClassLoader.resolveClass(java.lang.Class) (/usr/lib/libgcj.so.6.0.0)
       at java.lang.Class.initializeClass() (/usr/lib/libgcj.so.6.0.0)
       at org.jboss.system.server.ServerImpl.<clinit>() (Unknown Source)
       at java.lang.Class.initializeClass() (/usr/lib/libgcj.so.6.0.0)
       at java.lang.Class.newInstance() (/usr/lib/libgcj.so.6.0.0)
       at org.jboss.system.server.ServerLoader.createServer(java.lang.String, java.lang.ClassLoader) (Unknown Source)
       at org.jboss.system.server.ServerLoader.load(java.lang.ClassLoader) (Unknown Source)
       at org.jboss.Main.boot(java.lang.String[]) (Unknown Source)
       at org.jboss.Main$1.run() (Unknown Source)
       at java.lang.Thread.run() (/usr/lib/libgcj.so.6.0.0)
    Caused by: java.lang.ClassNotFoundException: java.lang.StringBuilder not found in org.jboss.system.server.NoAnnotationURLClassLoader{urls=[], parent=gnu.gcj.runtime.SystemClassLoader{urls=[file:/home/pentaho/pentaho-demo/jboss/bin/run.jar,file:./\], parent=gnu.gcj.runtime.ExtensionClassLoader

    Unknown macro: {urls=[], parent=null}

    }}
       at java.net.URLClassLoader.findClass(java.lang.String) (/usr/lib/libgcj.so.6.0.0)
       at java.lang.ClassLoader.loadClass(java.lang.String, boolean) (/usr/lib/libgcj.so.6.0.0)
       at java.lang.ClassLoader.loadClass(java.lang.String) (/usr/lib/libgcj.so.6.0.0)
       at java.lang.Class.forName(java.lang.String, boolean, java.lang.ClassLoader) (/usr/lib/libgcj.so.6.0.0)
       ...10 more

  14. Anonymous

    HEI Amigos :

    La instalacion con pentaho_demo_mysql5-1.7.0.RC2.zip esta ok.

    The installation is ok

    We had the problem

    Tubimos el problema:

     exception javax.servlet.ServletException: Filter execution threw an exception
    org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
    org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
    org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
    root cause java.lang.NoClassDefFoundError
    org.pentaho.repository.runtime.RuntimeRepository.setSession(RuntimeRepository.java:75)
    org.pentaho.core.system.PentahoSystem.getRuntimeRepository(PentahoSystem.java:1144)
    org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:205)
    org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:169)
    org.pentaho.core.system.PentahoSystem.sessionStartup(PentahoSystem.java:832)
    com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:70)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
    org.aceg

    y mas y mas errores.

     y seguimos exactamente los pasos..

     The solution was:

    La solucion fué:

    Cuando se ejecuta el sql  data/SampleDataDump_MySql.sq  no carga el privilegio GRANT para el acceso via localhost para cada base de datos ,,por tal via phpmyadmin o via consola si lo deseas cambia :

    1.en vez de: % a  cada usuario coloca localhost /Change % by every usuer to localhost /

    2.y asigna el permiso GRANT a cada base de cada usuario.../2.Put GRANT priveleges to every user in every database/

    3.reinicia el servidor  start-pentaho.sh y te funcionaría . /restart the server start-pentaho.sh and take a cup off cofe/

     Y listoooouuuuu

    http://localhost:8080/

    juldtb@gmail.com

    alekcis27@gmail.com

    Blessings


  15. Anonymous

    I have installed the already configured package (for mysql) successfully and things are running except two things:

    1) There are some users populated like Joe etc.  How do I add new ones

    2) I have no way of modifying the existing reports as Edit button doesn't show up in sniffy

    Thanks,



  16. Failed miserably to install pentaho_demo_hsqldb.1.7.1.tar.gz.    UsingJava(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_13-b05-237)

    Atempting to start server throw hundreds (if not thousands) of warnings and error messages, ending with:

    Caused by: javax.naming.ServiceUnavailableException: Failed to connect to server localhost:1099 [Root exception is java.net.ConnectException: Connection refused]
        at org.jnp.interfaces.NamingContext.getServer(NamingContext.java:243)
        ... 5 more
    Caused by: java.net.ConnectException: Connection refused
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:432)
        at java.net.Socket.connect(Socket.java:520)
        at java.net.Socket.connect(Socket.java:470)
        at java.net.Socket.<init>(Socket.java:367)
        at java.net.Socket.<init>(Socket.java:267)
        at org.jnp.interfaces.TimedSocketFactory.createSocket(TimedSocketFactory.java:84)
        at org.jnp.interfaces.TimedSocketFactory.createSocket(TimedSocketFactory.java:77)
        at org.jnp.interfaces.NamingContext.getServer(NamingContext.java:239)
        ... 5 more
    bash-3.2# java.sql.SQLException: socket creation error
    java.sql.SQLException: socket creation error
    java.sql.SQLException: socket creation error
     

    Unless someone has a suggestion as to how to proceed from here, I'm giving up on Pentaho.