Authenticating with Kettle plugins

[perekl]

I have an HPCC cluster that requires authentication to connect, but I don't see any way to pass my login info in with the HPCC plugins. I am trying to test out spraying a file that already exists on my LandingZone, and Pentaho is showing me success across the board, but nothing is actually happening on the cluster. Do these plugins only work for clusters that don't have authentication?

Thanks!

[joe.chambers]

Hi I just pushed a new version that supports authentication. The authentication will be in the global variables entry.

[perekl]

Awesome! Thank you, I like the new look. I moved over the new files and now get 'Error Editing Job Entry' when I try to click OK after entering in the cluster credentials.

Code: Select all

java.lang.NullPointerException
   at org.hpccsystems.pentaho.job.eclglobalvariables.ECLGlobalVariablesDialog.updatePaths(ECLGlobalVariablesDialog.java:455)
   at org.hpccsystems.pentaho.job.eclglobalvariables.ECLGlobalVariablesDialog.access$500(ECLGlobalVariablesDialog.java:52)
   at org.hpccsystems.pentaho.job.eclglobalvariables.ECLGlobalVariablesDialog$6.handleEvent(ECLGlobalVariablesDialog.java:305)
   at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
   at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
   at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
   at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
   at org.hpccsystems.pentaho.job.eclglobalvariables.ECLGlobalVariablesDialog.open(ECLGlobalVariablesDialog.java:427)
   at org.pentaho.di.ui.spoon.delegates.SpoonJobDelegate.editJobEntry(SpoonJobDelegate.java:285)
   at org.pentaho.di.ui.spoon.Spoon.editJobEntry(Spoon.java:8046)
   at org.pentaho.di.ui.spoon.job.JobGraph.editEntry(JobGraph.java:2727)
   at org.pentaho.di.ui.spoon.job.JobGraph.mouseDoubleClick(JobGraph.java:607)
   at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
   at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
   at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
   at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
   at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
   at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1227)
   at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7368)
   at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8673)
   at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:625)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)


If I continue through the error and click OK again, I get a second error and then a "Continue with Spoon after fatal error?" dialogue box.

Code: Select all

java.lang.NullPointerException
   at org.hpccsystems.pentaho.job.eclglobalvariables.ECLGlobalVariablesDialog.updatePaths(ECLGlobalVariablesDialog.java:455)
   at org.hpccsystems.pentaho.job.eclglobalvariables.ECLGlobalVariablesDialog.access$500(ECLGlobalVariablesDialog.java:52)
   at org.hpccsystems.pentaho.job.eclglobalvariables.ECLGlobalVariablesDialog$6.handleEvent(ECLGlobalVariablesDialog.java:305)
   at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
   at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
   at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
   at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
   at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1227)
   at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7368)
   at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8673)
   at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:625)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)

I am operating under the assumption that if I can get to the URL and log in from my browser, my local Spoon should be able to access the same location.

[joe.chambers]

In the install go to plugins/hpcc-common/properties/libaryInclude.properties and open that file in notepad and change includeML=true (you may need to change the permissions on the file so you can change it). Then reopen spoon and see if that fixed it.

[perekl]

Fantastic, that fixed it. I also needed that Server IP override, so I was happy to see that as well. My spray to the cluster worked as expected, thanks so much for the help.