RapidAnalytics Installation Problem - JBoss I think...

Analyticaltim

Dear Rapid-i Community,

I have been working for the last two days to get RapidAnalytics setup for my company to convince them this is the product they need. I decided to try and get RapidAnalytics working on a localhost first before they commit to integrating RA into their existing SQL database. I am having some persistent troubles and would appreciate any help you can lend my way. First let me give you some system information:
Mac OS: 10.7.5 -64bit system
Java Version: 1.6.0_45 (note I successfully reverted from Java 7 as per instructions)
RapidAnalytics install version: 1.3.008 (latest downloaded)
MySql version: 5.6.11 Community Version (I used Oracle's OS10.7x native install package)

I have successfully installed MySql and using Sequel Pro I setup the user 'rapidanalytics' with password and database 'rapidanalytics' per the install instructions. I also gave the user 'rapidanaltyics' all global privileges. Note: the SQL server is also running during RA install and "./run.sh -b 0.0.0.0" command.

RapidAnalytics during install connects with the SQL database successfully. It also seems to install correctly. Then following the instruction using the "./run.sh -b 0.0.0.0" I am running into a problem. Copied below is a bit of the 'run.sh -b 0.0.0.0' log:  

(The full log report can be found here: https://dl.dropboxusercontent.com/u/68635066/Tim-runSH-Log.txt)

12:25:12,572 INFO  [STDOUT] WARN: The method class org.apache.commons.logging.impl.SLF4JLogFactory#release() was invoked.
12:25:12,572 INFO  [STDOUT] WARN: Please see http://www.slf4j.org/codes.html#release for an explanation.
12:25:12,575 ERROR [AbstractKernelController] Error installing to Start: name=jboss.web.deployment:war=/RA state=Create mode=Manual requiredState=Installed: org.jboss.deployers.spi.DeploymentException: URL file:/Applications/RapidAnalytics/server/default/tmp/vfs/automount9022474512f89f2b/RapidAnalytics_War.war-1f73d78e1b00be90/ deployment failed
at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:325) [:6.0.0.Final]
at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:146) [:6.0.0.Final]
at org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:477) [:6.0.0.Final]
at org.jboss.web.deployers.WebModule.startModule(WebModule.java:118) [:6.0.0.Final]
at org.jboss.web.deployers.WebModule.start(WebModule.java:95) [:6.0.0.Final]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.6.0_45]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [:1.6.0_45]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_45]
at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_45]
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157) [:6.0.0.GA]
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96) [:6.0.0.GA]
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) [:6.0.0.GA]
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:271) [:6.0.0.GA]
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:670) [:6.0.0.GA]
at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206) [:2.2.0.GA]
at com.sun.proxy.$Proxy41.start(Unknown Source)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:53) [:2.2.0.GA]
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:41) [:2.2.0.GA]
at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:379) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:301) [:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:2044) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:1083) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.executeOrIncrementStateDirectly(AbstractController.java:1322) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1246) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1139) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:894) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:641) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataDeployer.deploy(BeanMetaDataDeployer.java:182) [:2.2.0.GA]
at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataDeployer.deploy(BeanMetaDataDeployer.java:58) [:2.2.0.GA]
at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62) [:2.2.0.GA]
at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:55) [:2.2.0.GA]
at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:179) [:2.2.0.GA]
at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1832) [:2.2.0.GA]
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1550) [:2.2.0.GA]
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1571) [:2.2.0.GA]
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1603) [:2.2.0.GA]
at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1491) [:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:379) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:2044) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:1083) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.executeOrIncrementStateDirectly(AbstractController.java:1322) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1246) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1139) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:939) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:654) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.deployers.plugins.deployers.DeployersImpl.change(DeployersImpl.java:1983) [:2.2.0.GA]
at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:1076) [:2.2.0.GA]
at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:679) [:2.2.0.GA]
at org.jboss.system.server.profileservice.deployers.MainDeployerPlugin.process(MainDeployerPlugin.java:106) [:6.0.0.Final]
at org.jboss.profileservice.dependency.ProfileControllerContext$DelegateDeployer.process(ProfileControllerContext.java:143) [:0.2.2]
at org.jboss.profileservice.dependency.ProfileDeployAction.deploy(ProfileDeployAction.java:151) [:0.2.2]
at org.jboss.profileservice.dependency.ProfileDeployAction.installActionInternal(ProfileDeployAction.java:94) [:0.2.2]
at org.jboss.kernel.plugins.dependency.InstallsAwareAction.installAction(InstallsAwareAction.java:54) [jboss-kernel.jar:2.2.0.GA]
at org.jboss.kernel.plugins.dependency.InstallsAwareAction.installAction(InstallsAwareAction.java:42) [jboss-kernel.jar:2.2.0.GA]
at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:379) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:2044) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:1083) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.executeOrIncrementStateDirectly(AbstractController.java:1322) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1246) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1139) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:939) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:654) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.profileservice.dependency.ProfileActivationWrapper$BasicProfileActivation.start(ProfileActivationWrapper.java:190) [:0.2.2]
at org.jboss.profileservice.dependency.ProfileActivationWrapper.start(ProfileActivationWrapper.java:87) [:0.2.2]
at org.jboss.profileservice.dependency.ProfileActivationService.activateProfile(ProfileActivationService.java:215) [:0.2.2]
at org.jboss.profileservice.dependency.ProfileActivationService.activate(ProfileActivationService.java:159) [:0.2.2]
at org.jboss.profileservice.bootstrap.AbstractProfileServiceBootstrap.activate(AbstractProfileServiceBootstrap.java:112) [:0.2.2]
at org.jboss.profileservice.resolver.BasicResolverFactory$ProfileResolverFacade.deploy(BasicResolverFactory.java:87) [:0.2.2]
at org.jboss.profileservice.bootstrap.AbstractProfileServiceBootstrap.start(AbstractProfileServiceBootstrap.java:91) [:0.2.2]
at org.jboss.system.server.profileservice.bootstrap.BasicProfileServiceBootstrap.start(BasicProfileServiceBootstrap.java:132) [:6.0.0.Final]
at org.jboss.system.server.profileservice.bootstrap.BasicProfileServiceBootstrap.start(BasicProfileServiceBootstrap.java:56) [:6.0.0.Final]
at org.jboss.bootstrap.impl.base.server.AbstractServer.startBootstraps(AbstractServer.java:827) [jboss-bootstrap-impl-base.jar:2.1.0-alpha-5]
at org.jboss.bootstrap.impl.base.server.AbstractServer$StartServerTask.run(AbstractServer.java:417) [jboss-bootstrap-impl-base.jar:2.1.0-alpha-5]
at java.lang.Thread.run(Thread.java:680) [:1.6.0_45]

12:25:12,633 INFO  [service] Removing bootstrap log handlers
12:25:12,745 ERROR [ProfileServiceBootstrap] Failed to load profile:: org.jboss.deployers.client.spi.IncompleteDeploymentException: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):

DEPLOYMENTS IN ERROR:
 Deployment "jboss.web.deployment:war=/RA" is in error due to the following reason(s): org.jboss.deployers.spi.DeploymentException: URL file:/Applications/RapidAnalytics/server/default/tmp/vfs/automount9022474512f89f2b/RapidAnalytics_War.war-1f73d78e1b00be90/ deployment failed

at org.jboss.deployers.plugins.deployers.DeployersImpl.checkComplete(DeployersImpl.java:1228) [:2.2.0.GA]
at org.jboss.deployers.plugins.main.MainDeployerImpl.checkComplete(MainDeployerImpl.java:905) [:2.2.0.GA]
at org.jboss.system.server.profileservice.deployers.MainDeployerPlugin.checkComplete(MainDeployerPlugin.java:87) [:6.0.0.Final]
at org.jboss.profileservice.deployment.ProfileDeployerPluginRegistry.checkAllComplete(ProfileDeployerPluginRegistry.java:107) [:0.2.2]
at org.jboss.system.server.profileservice.bootstrap.BasicProfileServiceBootstrap.start(BasicProfileServiceBootstrap.java:135) [:6.0.0.Final]
at org.jboss.system.server.profileservice.bootstrap.BasicProfileServiceBootstrap.start(BasicProfileServiceBootstrap.java:56) [:6.0.0.Final]
at org.jboss.bootstrap.impl.base.server.AbstractServer.startBootstraps(AbstractServer.java:827) [jboss-bootstrap-impl-base.jar:2.1.0-alpha-5]
at org.jboss.bootstrap.impl.base.server.AbstractServer$StartServerTask.run(AbstractServer.java:417) [jboss-bootstrap-impl-base.jar:2.1.0-alpha-5]
at java.lang.Thread.run(Thread.java:680) [:1.6.0_45]

12:25:12,767 INFO  [org.apache.coyote.http11.Http11Protocol] Starting Coyote HTTP/1.1 on http-%5C0.0.0.0%2F0.0.0.0-8080
12:25:12,771 INFO  [org.apache.coyote.ajp.AjpProtocol] Starting Coyote AJP/1.3 on ajp-0.0.0.0-8009
12:25:12,772 INFO  [org.jboss.bootstrap.impl.base.server.AbstractServer] JBossAS [6.0.0.Final "Neo"] Started in 42s:529ms

It seems to me that JBoss is not completely loading. This is supported by when I use my webrowser to visit: http://localhost:8080 I get a 404 error :

type Status report
message /RA/faces/restricted/index.xhtml
description The requested resource (/RA/faces/restricted/index.xhtml) is not available.

Thank you for any insight you can lend. I would love to get old RapdAnalytics up and running.  ;D
All the best.  
Tim

Nils_Woehler

Hi Tim,

did you install your RapidAnalytics with the provided RA 1.3.008 installer? Currently there is a problem with MySQL 5.6 and RA 1.3.008.
The JDBC driver bundled with RA 1.3.008 does not support MySQL 5.6. This has been fixed internally by replacing the driver with a newer version but
unfortunately was discovered right after releasing 1.3.008.

Nevertheless, a potential fix for your problem could be to replace the mysql-connector-java-5.1.17-bin.jar from $RA_INSTALLATION/server/default/lib with
the latest 'mysql-connector-java.5.1.24-bin.jar' from http://dev.mysql.com/downloads/connector/j/

Best regards,
Nils

Analyticaltim

Dear Nils,

Thank you for your note. Unfortunately the new mysql-connector did not work.   :-\
The process I followed was:
1. Remove old non-functioning RapidAnalytics program from my computer
2. Durring RapidAnalytics installation when asked for a JDBC driver I selected the new one I just downloaded from Oracle i.e. 5.1.17. (Note I also moved this driver to the installer's directory folder: rapidanalytics/data/jdbc though I did have to select the driver manually during the installation process.)
3. Rerun installation. From the RapidAnalytics Installer .jar file.
Mysql was found and was working during the initial setup test phase.
4. After installation, I executed "run.sh -b 0.0.0.0"
5. After much verbiage (see linked log file) the install failed again.

Here is the new log file if you have any interest: (https://dl.dropboxusercontent.com/u/68635066/runSH-log-4-44.txt)

JBoss seems to be in the same place when I goto the localhost:8080 in my web browser (chrome). Here it reports as before:

HTTP Status 404 - /RA/faces/restricted/index.xhtml

type Status report

message /RA/faces/restricted/index.xhtml

description The requested resource (/RA/faces/restricted/index.xhtml) is not available.

Thank you for your time and effort with this. I look forward to the next step I can use to get this up and running.
All the best for your afternoon.
Tim

Marco_Boeck

Hi,

the log still says "mysql-connector-java-5.1.17", which suggests the old MySQL JDBC driver .jar is still there. Could you go to the RapidAnalyticsInstallDirectory/server/default/lib folder and manually delete the old "mysql-connector-java-5.1.17-bin.jar" and make sure the new "mysql-connector-java.5.1.24-bin.jar" is there and then try again?

Regards,
Marco

Analyticaltim

Dear Marco,

Thank you for your time. You were quite right. In that directory was the old version of the JDBC driver and the new. I trashed the old driver (emptied the trash) and re-ran "./run.sh -b 0.0.0.0". Unfortunately the install failed again.  ???

Though this time it has many new lines of output. You can find the log file here: (https://dl.dropboxusercontent.com/u/68635066/runSH-log-4-25.txt)

I checked this log file to insure the correct JDBC driver was used. It was used in this install attempt. After the failed install, I tried going to http://localhost:8080 in Chrome and I received the same 404 error.

Thank you very much for your persistence. I am really looking forward to getting RapidAnalytics working as I love RapidMiner and am trying to get my company on board with the enterprise editions.

All the best.
Tim

Nils_Woehler

Hi Tim,

the error states 'Caused by: java.sql.SQLException: No database selected'. Seems as if your database configuration is malformed.
Please wipe the complete installation of RapidAnalytics and install it again with the installer we provide.
Afterwards you should not forget to exchange the jdbc mysql driver

Best,
Nils

Marco_Boeck

Hi,

just select the new JDBC driver during installation in the DB step

Regards,
Marco