Thank you Gary. That made it all work correctly. Mathew
________________________________ From: Gary Lawrance <[email protected]> Sent: Wednesday, February 16, 2022 2:59 PM To: [email protected] <[email protected]> Subject: Re: OFBiz and mySQL You can run the command without the cleanall command. sudo ./gradlew "ofbiz --load-data readers=seed,seed-initial" loadAdminUserLogin -PuserLoginId=admin It looks like you capitalized LoadAdminUserLogin rather than loadAdminUserLogin when you created your stack trace too. Hope this helps On Mon, Feb 14, 2022 at 3:53 PM Mathew Cox <[email protected]> wrote: > I'm trying to setup OFBiz utilizing a mySQL database and I have not found > much information beyond the manual on how to marry those together. > > -Ubuntu 20.04 Server > -mySQL Server version: 8.0.28-0ubuntu0.20.04.3 > -Java openjdk version "1.8.0_292" > OpenJDK Runtime Environment (build 1.8.0_292-b10) > Eclipse OpenJ9 VM (build openj9-0.26.0, JRE 1.8.0 Linux amd64-64-Bit > Compressed References 20210421_1000 (JIT enabled, AOT enabled) > OpenJ9 - b4cc246d9 > OMR - 162e6f729 > JCL - 2a5e268814 based on jdk8u292-b10) > -OFBiz 18.12.05 > > When I've ran ./gradlew ofbiz it clearly communicates with and populates > the entire database in mysql only most (if not all) the fields are blank, > including the logins. I've tried to inject values into the login values > using mysql cli but I don't know what values to add under > security_permissions and as such am at a loss. > > I've ran ./gradlew loadAll in an effort to populate the fields and the > following is the error I receive: > > FAILURE: Build failed with an exception. > > * What went wrong: > Execution failed for task ':ofbiz --load-data'. > > Process 'command '/usr/lib/jvm/adoptopenjdk-8-openj9-amd64/bin/java'' > finished with non-zero exit value 1 > > When I've run the following: > > sudo ./gradlew loadAdminUserLogin -PuserLoginId=admin > > Execution failed for task ':executeLoadAdminUser'. > > Process 'command '/usr/lib/jvm/adoptopenjdk-8-openj9-amd64/bin/java'' > finished with non-zero exit value 1 > > ./gradlew cleanAll "ofbiz --load-data readers=seed,seed-initial" > loadAdminUserLogin -PuserLoginId=admin > > > When I've ran the following: > > sudo ./gradlew cleanAll "ofbiz --load-data readers=seed,seed-initial" > loadAdminUserLogin -PuserLoginId=admin > > The whole build succeeds without error but the cleanAll command removes > the mysql-connector.jar and it really is an error at the end of it all as > none of the information would have made it to mysql. > > A stacktrace of sudo ./gradlew LoadAdminUserLogin -PuserLoginId=admin > --stacktrace: > > FAILURE: Build failed with an exception. > > * What went wrong: > Task 'ofLoadAdminUserLogin' not found in root project 'ofbiz'. Some > candidates are: 'loadAdminUserLogin'. > > * Try: > Run gradlew tasks to get a list of available tasks. Run with --info or > --debug option to get more log output. Run with --scan to get full insights. > > * Exception is: > org.gradle.execution.TaskSelectionException: Task 'ofLoadAdminUserLogin' > not found in root project 'ofbiz'. Some candidates are: > 'loadAdminUserLogin'. > at org.gradle.execution.TaskSelector.getSelection(TaskSelector.java:116) > at org.gradle.execution.TaskSelector.getSelection(TaskSelector.java:81) > at > org.gradle.execution.commandline.CommandLineTaskParser.parseTasks(CommandLineTaskParser.java:42) > at > org.gradle.execution.TaskNameResolvingBuildConfigurationAction.configure(TaskNameResolvingBuildConfigurationAction.java:45) > at > org.gradle.execution.DefaultBuildConfigurationActionExecuter.configure(DefaultBuildConfigurationActionExecuter.java:57) > at > org.gradle.execution.DefaultBuildConfigurationActionExecuter.access$200(DefaultBuildConfigurationActionExecuter.java:26) > at > org.gradle.execution.DefaultBuildConfigurationActionExecuter$2.proceed(DefaultBuildConfigurationActionExecuter.java:63) > at > org.gradle.execution.DefaultTasksBuildExecutionAction.configure(DefaultTasksBuildExecutionAction.java:44) > at > org.gradle.execution.DefaultBuildConfigurationActionExecuter.configure(DefaultBuildConfigurationActionExecuter.java:57) > at > org.gradle.execution.DefaultBuildConfigurationActionExecuter.access$200(DefaultBuildConfigurationActionExecuter.java:26) > at > org.gradle.execution.DefaultBuildConfigurationActionExecuter$2.proceed(DefaultBuildConfigurationActionExecuter.java:63) > at > org.gradle.execution.ExcludedTaskFilteringBuildConfigurationAction.configure(ExcludedTaskFilteringBuildConfigurationAction.java:47) > at > org.gradle.execution.DefaultBuildConfigurationActionExecuter.configure(DefaultBuildConfigurationActionExecuter.java:57) > at > org.gradle.execution.DefaultBuildConfigurationActionExecuter.access$200(DefaultBuildConfigurationActionExecuter.java:26) > at > org.gradle.execution.DefaultBuildConfigurationActionExecuter$1.run(DefaultBuildConfigurationActionExecuter.java:43) > at org.gradle.internal.Factories$1.create(Factories.java:25) > at > org.gradle.api.internal.project.DefaultProjectStateRegistry.withLenientState(DefaultProjectStateRegistry.java:132) > at > org.gradle.api.internal.project.DefaultProjectStateRegistry.withLenientState(DefaultProjectStateRegistry.java:124) > at > org.gradle.execution.DefaultBuildConfigurationActionExecuter.select(DefaultBuildConfigurationActionExecuter.java:39) > at > org.gradle.initialization.DefaultGradleLauncher$CalculateTaskGraph.run(DefaultGradleLauncher.java:317) > at > org.gradle.internal.operations.DefaultBuildOperationExecutor$RunnableBuildOperationWorker.execute(DefaultBuildOperationExecutor.java:301) > at > org.gradle.internal.operations.DefaultBuildOperationExecutor$RunnableBuildOperationWorker.execute(DefaultBuildOperationExecutor.java:293) > at > org.gradle.internal.operations.DefaultBuildOperationExecutor.execute(DefaultBuildOperationExecutor.java:175) > at > org.gradle.internal.operations.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:91) > at > org.gradle.internal.operations.DelegatingBuildOperationExecutor.run(DelegatingBuildOperationExecutor.java:31) > at > org.gradle.initialization.DefaultGradleLauncher.constructTaskGraph(DefaultGradleLauncher.java:202) > at > org.gradle.initialization.DefaultGradleLauncher.doBuildStages(DefaultGradleLauncher.java:154) > at > org.gradle.initialization.DefaultGradleLauncher.executeTasks(DefaultGradleLauncher.java:133) > at > org.gradle.internal.invocation.GradleBuildController$1.execute(GradleBuildController.java:79) > at > org.gradle.internal.invocation.GradleBuildController$1.execute(GradleBuildController.java:76) > at > org.gradle.internal.invocation.GradleBuildController$3.create(GradleBuildController.java:103) > at > org.gradle.internal.invocation.GradleBuildController$3.create(GradleBuildController.java:96) > at org.gradle.internal.work > .DefaultWorkerLeaseService.withLocks(DefaultWorkerLeaseService.java:183) > at org.gradle.internal.work > .StopShieldingWorkerLeaseService.withLocks(StopShieldingWorkerLeaseService.java:40) > at > org.gradle.internal.invocation.GradleBuildController.doBuild(GradleBuildController.java:96) > at > org.gradle.internal.invocation.GradleBuildController.run(GradleBuildController.java:76) > at > org.gradle.tooling.internal.provider.ExecuteBuildActionRunner.run(ExecuteBuildActionRunner.java:28) > at > org.gradle.launcher.exec.ChainingBuildActionRunner.run(ChainingBuildActionRunner.java:35) > at > org.gradle.tooling.internal.provider.ValidatingBuildActionRunner.run(ValidatingBuildActionRunner.java:32) > at > org.gradle.launcher.exec.RunAsBuildOperationBuildActionRunner$3.run(RunAsBuildOperationBuildActionRunner.java:49) > at > org.gradle.internal.operations.DefaultBuildOperationExecutor$RunnableBuildOperationWorker.execute(DefaultBuildOperationExecutor.java:301) > at > org.gradle.internal.operations.DefaultBuildOperationExecutor$RunnableBuildOperationWorker.execute(DefaultBuildOperationExecutor.java:293) > at > org.gradle.internal.operations.DefaultBuildOperationExecutor.execute(DefaultBuildOperationExecutor.java:175) > at > org.gradle.internal.operations.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:91) > at > org.gradle.internal.operations.DelegatingBuildOperationExecutor.run(DelegatingBuildOperationExecutor.java:31) > at > org.gradle.launcher.exec.RunAsBuildOperationBuildActionRunner.run(RunAsBuildOperationBuildActionRunner.java:44) > at > org.gradle.tooling.internal.provider.SubscribableBuildActionRunner.run(SubscribableBuildActionRunner.java:51) > at > org.gradle.launcher.exec.InProcessBuildActionExecuter$1.transform(InProcessBuildActionExecuter.java:47) > at > org.gradle.launcher.exec.InProcessBuildActionExecuter$1.transform(InProcessBuildActionExecuter.java:44) > at > org.gradle.composite.internal.DefaultRootBuildState.run(DefaultRootBuildState.java:79) > at > org.gradle.launcher.exec.InProcessBuildActionExecuter.execute(InProcessBuildActionExecuter.java:44) > at > org.gradle.launcher.exec.InProcessBuildActionExecuter.execute(InProcessBuildActionExecuter.java:30) > at > org.gradle.launcher.exec.BuildTreeScopeBuildActionExecuter.execute(BuildTreeScopeBuildActionExecuter.java:39) > at > org.gradle.launcher.exec.BuildTreeScopeBuildActionExecuter.execute(BuildTreeScopeBuildActionExecuter.java:25) > at > org.gradle.tooling.internal.provider.ContinuousBuildActionExecuter.execute(ContinuousBuildActionExecuter.java:78) > at > org.gradle.tooling.internal.provider.ContinuousBuildActionExecuter.execute(ContinuousBuildActionExecuter.java:52) > at > org.gradle.tooling.internal.provider.ServicesSetupBuildActionExecuter.execute(ServicesSetupBuildActionExecuter.java:62) > at > org.gradle.tooling.internal.provider.ServicesSetupBuildActionExecuter.execute(ServicesSetupBuildActionExecuter.java:34) > at > org.gradle.tooling.internal.provider.GradleThreadBuildActionExecuter.execute(GradleThreadBuildActionExecuter.java:36) > at > org.gradle.tooling.internal.provider.GradleThreadBuildActionExecuter.execute(GradleThreadBuildActionExecuter.java:25) > at > org.gradle.tooling.internal.provider.ParallelismConfigurationBuildActionExecuter.execute(ParallelismConfigurationBuildActionExecuter.java:43) > at > org.gradle.tooling.internal.provider.ParallelismConfigurationBuildActionExecuter.execute(ParallelismConfigurationBuildActionExecuter.java:29) > at > org.gradle.tooling.internal.provider.StartParamsValidatingActionExecuter.execute(StartParamsValidatingActionExecuter.java:59) > at > org.gradle.tooling.internal.provider.StartParamsValidatingActionExecuter.execute(StartParamsValidatingActionExecuter.java:31) > at > org.gradle.tooling.internal.provider.SessionFailureReportingActionExecuter.execute(SessionFailureReportingActionExecuter.java:59) > at > org.gradle.tooling.internal.provider.SessionFailureReportingActionExecuter.execute(SessionFailureReportingActionExecuter.java:44) > at > org.gradle.tooling.internal.provider.SetupLoggingActionExecuter.execute(SetupLoggingActionExecuter.java:46) > at > org.gradle.tooling.internal.provider.SetupLoggingActionExecuter.execute(SetupLoggingActionExecuter.java:30) > at > org.gradle.launcher.daemon.server.exec.ExecuteBuild.doBuild(ExecuteBuild.java:67) > at > org.gradle.launcher.daemon.server.exec.BuildCommandOnly.execute(BuildCommandOnly.java:36) > at > org.gradle.launcher.daemon.server.api.DaemonCommandExecution.proceed(DaemonCommandExecution.java:122) > at > org.gradle.launcher.daemon.server.exec.WatchForDisconnection.execute(WatchForDisconnection.java:37) > at > org.gradle.launcher.daemon.server.api.DaemonCommandExecution.proceed(DaemonCommandExecution.java:122) > at > org.gradle.launcher.daemon.server.exec.ResetDeprecationLogger.execute(ResetDeprecationLogger.java:26) > at > org.gradle.launcher.daemon.server.api.DaemonCommandExecution.proceed(DaemonCommandExecution.java:122) > at > org.gradle.launcher.daemon.server.exec.RequestStopIfSingleUsedDaemon.execute(RequestStopIfSingleUsedDaemon.java:34) > at > org.gradle.launcher.daemon.server.api.DaemonCommandExecution.proceed(DaemonCommandExecution.java:122) > at > org.gradle.launcher.daemon.server.exec.ForwardClientInput$2.call(ForwardClientInput.java:74) > at > org.gradle.launcher.daemon.server.exec.ForwardClientInput$2.call(ForwardClientInput.java:72) > at org.gradle.util.Swapper.swap(Swapper.java:38) > at > org.gradle.launcher.daemon.server.exec.ForwardClientInput.execute(ForwardClientInput.java:72) > at > org.gradle.launcher.daemon.server.api.DaemonCommandExecution.proceed(DaemonCommandExecution.java:122) > at > org.gradle.launcher.daemon.server.exec.LogAndCheckHealth.execute(LogAndCheckHealth.java:55) > at > org.gradle.launcher.daemon.server.api.DaemonCommandExecution.proceed(DaemonCommandExecution.java:122) > at > org.gradle.launcher.daemon.server.exec.LogToClient.doBuild(LogToClient.java:62) > at > org.gradle.launcher.daemon.server.exec.BuildCommandOnly.execute(BuildCommandOnly.java:36) > at > org.gradle.launcher.daemon.server.api.DaemonCommandExecution.proceed(DaemonCommandExecution.java:122) > at > org.gradle.launcher.daemon.server.exec.EstablishBuildEnvironment.doBuild(EstablishBuildEnvironment.java:81) > at > org.gradle.launcher.daemon.server.exec.BuildCommandOnly.execute(BuildCommandOnly.java:36) > at > org.gradle.launcher.daemon.server.api.DaemonCommandExecution.proceed(DaemonCommandExecution.java:122) > at > org.gradle.launcher.daemon.server.exec.StartBuildOrRespondWithBusy$1.run(StartBuildOrRespondWithBusy.java:50) > at > org.gradle.launcher.daemon.server.DaemonStateCoordinator$1.run(DaemonStateCoordinator.java:295) > at > org.gradle.internal.concurrent.ExecutorPolicy$CatchAndRecordFailures.onExecute(ExecutorPolicy.java:63) > at > org.gradle.internal.concurrent.ManagedExecutorImpl$1.run(ManagedExecutorImpl.java:46) > at > org.gradle.internal.concurrent.ThreadFactoryImpl$ManagedThreadRunnable.run(ThreadFactoryImpl.java:55) > > > I've tried different vendors of Java8, both openjdk-8 that is apart of the > unbuntu apt repositories as well as the current version I'm running which > is from IBM, but I've also installed and ran adoptjdk java-jdk hotspot. I > have not yet tried to run it with an older version of Java 8 nor have I > tried an older version of mySQL. > > Honestly I'm at a loss as the whole thing works flawlessly with Derby. > I'm not a developer or a coder, I'm just a guy that is trying to get this > business software up off the ground. > > Thank you for your time. > > Mathew > >
