RapidAnalytics Installation Problem - JBoss I think...

AnalyticaltimAnalyticaltim Member Posts: 15 Contributor II
edited August 2019 in Help
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




Answers

  • Nils_WoehlerNils_Woehler Member Posts: 463 Maven
    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

  • AnalyticaltimAnalyticaltim Member Posts: 15 Contributor II
    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_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,993 RM Engineering
    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
  • AnalyticaltimAnalyticaltim Member Posts: 15 Contributor II
    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_WoehlerNils_Woehler Member Posts: 463 Maven
    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_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,993 RM Engineering
    Hi,

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

    Regards,
    Marco
Sign In or Register to comment.