Alteryx install using Powershell

[ratheesh]

Hi Team,

I am trying to install and configure Alteryx using PowerShell script and I could able to manage the same. I created a template of “C:\ProgramData\Alteryx\ RuntimeSettings.xml” by copying the same from an existing installation. And it is working fine.

I have confused the below two values in the xml file.

<ServerSecretEncrypted>VALUE</ServerSecretEncrypted>
<StorageKeysEncrypted>VALUE</StorageKeysEncrypted>

Is the above two values are machine dependent? Can I use the same Value in all the host where I install Alteryx using my script?.

Thanks in advance.

Thanks,

Ratheesh

[dataMack]

Here's the command line install guide:

http://downloads.alteryx.com/Documentation/Alteryx%20Command%20Line%20Install%20Guide.pdf

[ratheesh]

Thank you very much for the quick response. I used these options to install Alteryx by command line. However instead of the configuration Alteryx manually after the installation I have a template of “RuntimeSettings.xml” which I copy to “C: ProgramData\Alteryx\RuntimeSettings.xml”. This is the template I am planning to use.

<?xml version="1.0" encoding="UTF-8"?>
<SystemSettings>
	<Controller>
		<EmbeddedMongoDBEnabled>True</EmbeddedMongoDBEnabled>
		<EmbeddedMongoDBRootPath>D:\Apps\Alteryx\Service\Persistence\MongoDB</EmbeddedMongoDBRootPath>
		<GalleryEnabled>True</GalleryEnabled>
		<LoggingEnabled>True</LoggingEnabled>
		<LoggingPath>D:\Apps\Alteryx\Service\AlteryxServiceLog.log</LoggingPath>
		<LoggingSeverityThreshold>7</LoggingSeverityThreshold>
		<ServerSecretEncrypted>201000000D08C9DDF0115D1118C7A00C04FC297EB01000000A2E6427FF4D5DA48853E6C64AC601BC004000000080000005000570044000000106600000001000020000000936C6F30C4813E03F80C4165C9FC2837AF168649B6F57625C61AA4FCEC0DB861000000000E800000000200002000000061F2CA10B2C10989BFDB86A6960CB41381101F894566DC20CD337A201FE83B2960000000A45CB53FE2A73F8481EEFA2676542E40B9B034941E55FE696ABC99BED28A24B2BF9CD766F1FC9A4F2DB5F83B052B1E0F46A3D234D11459F90EFC9A0F57D370161BBF432FCDC66070675B13E73A01A4E1D14FECA84781419128419603E8265F7A40000000CA6456B0D1B05639D9898669C85769B929B5E26B30B7276CC544DE30AE59824B0361964ECC4C57BB340EC1D46FBE3CE1165A87988BE61D685621766E297778AB</ServerSecretEncrypted>
		<SQLitePath>D:\Apps\Alteryx\Service\Persistence</SQLitePath>
		<StorageKeysEncrypted>BwIAAACkAAB4cbUqKFZrxFwRhRgw279wSECeCwIO0vdE4nt2K5iSpJyCxGRRo6JZdHJKIK78pJxG
3MC3fwuo9h8c3P+lyo1tTfnAIsnQdng+PDAERVfPv6mN41kMRXTPzos2ILhmUzY4Dsr1X4I2FWnx
7FHeFCMFkZXyk8a/Gei49xzI9fEcALDsh7x83kd+XizBdggnAKUfm5k8oIS9/kYAEuZoEwCLfSTI
+B6sIEAG0TRnWlSNPam8Uu8XRfukKrfcKcw0tZHmeRm1JANOXN7pFvSAK/2RmQCqGgYhSlAl+wNz
QgoOuRy1MpUj4YUSMudjOb+0pqhXxj33wdvvve0fcM1tbnvWsLfxKRi+GhWh1CwqD7scXPZ4zOnd
R5rJbEOlKSesxRucYk6pUCh1sHZpqA8adlVTwcFZBpif8T76w1P35I9L+Oj6STqPAVFdHmL8IYew
8q96PVtKW9bCOVsfMCLzvkkUFmPqemEgxBM3ThbeHyttxPSthQl76wY1wtcC2deK3oMdCQRY3b8M
0uMnJpRkhBNP13/XOUoeKuQJphgjdvlgxyCf/JXDrV35dFTS/BoCCM7+joi3/wMWYWqK8rwZkNTf
bsrggj4Sp2goRoTAlzjsnn9OawR1TuAVxhmA82TtONQfwJYQenLOwg34Oez8XnFZTXibyOYEt6AT
TrBXNdvovjkGTPXbITYvKX1sHJEZrTmpTlzllL9GVp4I0Afls4YISJRVuqnvGFVVfsT2edr4RacH
mHI4wqaKjypeld5GYUW1yr2lXCB+YPLTDSAxGlK+</StorageKeysEncrypted>
		<WebInterfaceEnabled>True</WebInterfaceEnabled>
		<WebInterfaceStagingPath>D:\Apps\Alteryx\Service\Staging</WebInterfaceStagingPath>
	</Controller>
	<Engine>
		<DefaultTempFilePath>D:\Apps\Alteryx\Engine</DefaultTempFilePath>
		<LogFilePath>D:\Apps\Alteryx\Logs</LogFilePath>
		<NumThreads>3</NumThreads>
		<PackageStagingPath>D:\Apps\Alteryx\Engine\Staging</PackageStagingPath>
		<SortJoinMemory>3583</SortJoinMemory>
	</Engine>
	<Environment>
		<Configured>True</Configured>
		<SetupType>Gallery</SetupType>
		<WorkingPath>D:\Apps\Alteryx\</WorkingPath>
	</Environment>
	<Gallery>
		<DefaultGalleryAdminUserName>alteryx-admin@example.com</DefaultGalleryAdminUserName>
		<LoggingPath>D:\Apps\Alteryx\Gallery\Logs</LoggingPath>
		<SmtpEnabled>False</SmtpEnabled>
		<WorkingPath>D:\Apps\Alteryx\Gallery</WorkingPath>
	</Gallery>
	<Worker>
		<StagingPath>D:\Apps\Alteryx\Service\Staging</StagingPath>
	</Worker>
</SystemSettings>

I am not sure the values of ServerSecretEncrypted and StorageKeysEncrypted are machine dependent or not.

Thanks, Ratheesh

[KaneG · Accepted solution]

Hi @ratheesh,

Both of these are a hash generated off encrypted info that includes machine specific information. 

The <ServerSecretEncrypted> is related to the controller token and the <StorageKeysEncrypted> tag relates to the persistence. If you are installing the server on another machine, then I would expect these 2 values to be different to the ones on the last machine. You can set the Controller Token (<ServerSecretEncrypted>) from command prompt if needed after install which will generate the required hash. Take a look at the info here for more details on that: https://community.alteryx.com/t5/Engine-Works-Blog/Intro-to-the-Server-command-line/ba-p/13380

Kane

[ratheesh]

Hi Kane,

Thanks a lot for the response!!. I really appreciate your help, the URL helped to solve my problem.

Thanks,

Ratheesh

[hamlap]

Hi Kane,

If I set the Controller Token (<ServerSecretEncrypted>) from command prompt, will that set <StorageKeysEncrypted> too?

[hamlap]

Hi Ratheesh

could you provide me your script

kind regards Mike

[KaneG]

No, I don't think setting one will set the other.

Since this post, there may have been some things change due to added functionality. When we added the ability to store Data Credentials in the MongoDB, this used MachineKeys to encrypt and so there is now a fixed process for restoring an Alteryx Server on a new machine. I cannot find it at the moment (and my version may not have been current) and so best to reach out to support@alteryx.com to get the documented process.

[hamlap]

Hi Kane,

Support pointed me to commandline alteryxservice.exe, you can do a lot with it, but what about setting authentication etc?  for i.e. setting identityprovider

[KaneG]

I haven't dealt with setting the Identity Provider through cmdLine. I think it's the kind of thing that may need to be set in the RuntimeSettings.xml... there is some info in this article, but it might not deal with SAML as that was introduced after the article was written.

If you set it up and then view the RuntimeSettings.xml, then there should be the required settings under the <Gallery> tags.