Performing configuration tasks in a command line

Use the command line utilities to perform configuration tasks in Mongoose.

These utilities are available from the command line:

Utility Description
InforDBCL.exe This utility contains all configuration tasks that involves databases. The available commands are:
  • InforDbCL.exe CreateDb
  • InforDbCL.exe PatchDb
  • InforDbCL.exe LinkMultiSite
  • InforDbCL.exe ApplyTrans
  • InforDbCL.exe ApplyPack
  • InforDbCL.exe AddSite
  • InforDbCL.exe CopySite
InforWebCL.exe This utility contains all configuration tasks associated with IIS and clients. The available commands are:
  • InforWebCL.exe WebClient
  • InforWebCL.exe SmartClient
  • InforWebCL.exe WebApp
  • InforWebCL.exe xbap
  • InforWebCL.exe EndUser
  • InforWebCL.exe PingFederate
InforServiceCL.exe This utility contains the configuration tasks dealing with Windows services and replication. The available commands are:
  • Replication
  • setserviceaccount
  • Report services
Note: The command must be the first argument. All options in brackets are optional. Values that contain spaces must be in double quotes.

InforDbCL.exe CreateDb

Use this command to create a new database, for example:

infordbcl.exe createdb -databasename:CmdApp -username:sa -password:test123 -servername:win2012 -dbtype:App -product:SL infordbcl.exe createdb -databasename:CloudApp -username:sa -password:test123 -servername:win2012 -dbtype:App -product:SL -clouddb infordbcl.exe createdb -databasename:Mongoose_Forms -username:sa -password:test123 -servername:win2012 -dbtype:Forms -product:Mongoose

The available commands with some examples are:

  • -databasename: SQL database name
  • -username: SQL server user name
  • -password: SQL server password
  • -servername: SQL server name
  • -dbtype: Database type, such as App, Objects, Forms, and Templates
  • -product: Mongoose product, which corresponds to the registry key, for example, Mongoose or SL
  • [-collation]: SQL collation to be used for the database
  • [-clouddb]: DB status, which indicates whether DB is already created or must be populated
  • [-dbsubtype]: App database subtype, for example Demo or Empty
  • [-log]: Full path to a log file to redirect to
  • [-siteid]: App database site ID
  • [-sitename]: App database site name
  • [-sitedesc]: App database site description
  • [-sitegroup]: App database site group
  • [-sitecurrency]: App database site currency
  • [-sitetype]: App database site type, such as, S and E
  • [-sqlservertimezone]: SQL Server timezone in standard name
  • [-timezone]: App database timezone in standard name

InforDbCL.exe PatchDb

Use this command to patch an existing database to the service pack level, for example:

Infordbcl.exe patchdb -databasename:CmdApp -username:sa -password:Sql2012 -servername:win2012 -dbtype:App -product:SL -config:test

The available commands with some examples are:

  • -databasename: SQL database name
  • -username: SQL server user name
  • -password: SQL server password
  • -servername: SQL server name
  • -dbtype: Database type, such as App, Objects, Forms, and Templates
    Note: The Objects type is not available when patching.

    -product: Mongoose product, which corresponds to the install subfolder, for example, Mongoose or SL

  • -config: Mongoose configuration, which contains the App database and the referenced Objects database to be patched
    Note: This command is only required when the Objects database must be patched.
  • [-siteid]: App database site ID
    Note: This command is only required when the Objects database must not be patched.
  • [-log]: Full path to a log file to redirect to

InfordDbCL.exe LinkMultiSite

Use this command to link multi-site databases, for example:

infordbcl.exe linkmultisite -databasename:"Mongoose1_App" -username:sa -password:test123 -servername:win2012 -siteid:1 -sitedesc:"This is site 1" -sitetype:S -sitename:"Alpha Site" -groupname:Test -sitecurrency:US -databasename2:"Mongoose2_App" -username2:sa -password2:test123 -siteid2:2 -sitetype2:S -sitedesc2:"This is site 2" -servername2:"win2012" -sitename2:"Beta Site" -sitecurrency2:"US"

The available commands with some examples are:

  • -databasename: SQL database A name
  • -username: SQL database A user name
  • -password: SQL database A password
  • -servername: SQL database A server name
  • -siteid: Database A site ID
  • -sitename: Database A site name
  • -sitedesc: Database A site description
  • -sitecurrency: Database A site currency
  • -sitetype: Database A site type, such as S and E
  • [-sitegroup]: Database A site group
  • [-timezone]: Database A timezone
  • -groupname: Multi-site group name
  • -databasename2: SQL database B name
  • -username2: SQL database B user name
  • -password2: SQL database B password
  • -servername2: SQL database B server name
  • -siteid2: Database B site ID
  • -sitename2: Database B site name
  • -sitedesc2: Database B site description
  • -sitecurrency2: Database B site currency
  • -sitetype2: Database B site type, such as S and E
  • [-sitegroup2]: Database B site group
  • [-timezone2]: Database B timezone
  • [-log]: Full path to a log file to redirect to

InforDbCL.exe ApplyTrans

Use this command to apply a translation to a set of databases, for example:

Infordbcl.exe applytrans -config:SL9 -trans:es-mx -product:SL

The available commands with some examples are:

  • -trans: Translation to apply, which corresponds to the locale subfolder, for example, zh-CN and es-MX
  • -product: Mongoose product, which corresponds to the install subfolder, for example, Mongoose or SL
  • -config: Mongoose configuration, which contains the App database and the referenced Objects database to be patched
    Note: This command is only required when the Objects database must be patched.
  • [-log]: Full path to a log file to redirect to
  • [-alwayson] establishes a SQL connection to a AlwaysOn Availability Group.

InforDbCL.exe ApplyPack

Use this command to apply either an Industry Pack or a Localization to a set of database, for example:

infordbcl.exe applypack -config:SL9 -product:SL -pack:automotive infordbcl.exe applypack -config:SL9 -product:SL -pack:automotive -reportserverurl:http://win2012/reportserver -reportparentfolder:SyteLineReports

The available commands with some examples are:

  • -pack: Industry Pack or Localization to apply , which corresponds to the local subfolder, for example, automotive and CN00
  • -product: Mongoose product, which corresponds to the install subfolder, for example, Mongoose or SL
  • -config: Mongoose configuration, which contains the App database and Forms database information
  • [-reportserverurl]: Full URL to report server, if empty reports will not be loaded
  • [-reportparentfolder]: Report server parent folder, if empty reports will not be loaded
  • [-reportdir]: Local reports folder to upload, which defaults to [WinStudioDir]\Report\Reports if not given
  • [-log]: Full path to a log file to redirect to

  • [-alwayson] establishes a SQL connection to a AlwaysOn Availability Group.

InforDbCL.exe AddSite

The available commands with some examples are:

  • -databasename: SQL database name
  • -username: SQL server user name
  • -password: SQL server password
  • -servername: SQL server name
  • -product: Mongoose product, which corresponds to the registry key, for example, Mongoose or SL
  • [-log]: Full path to a log file to redirect to
  • [-siteid]: App database site ID
  • [-sitename]: App database site name
  • [-sitedesc]: App database site description
  • [-sitegroup]: App database site group
  • [-sitecurrency]: App database site currency
  • [-sitetype]: App database site type, such as, S and E
  • [-timezone]: App database timezone
  • [-alwayson] establishes a SQL connection to a AlwaysOn Availability Group.
  • [-deletedata] deletes all existing data in the existing database.
    Caution: Be careful in using this command.

InforDbCL.exe CopySite

Note: Tables that do not have a primary key or any unique key will not have their data copied. These tables are skipped.

The available commands with some examples are:

  • -sourcedatabasename: SQL database name, which contains existing site to be copied
  • -sourceusername: SQL server user name
  • -sourcepassword: SQL server password
  • -sourceservername: SQL server name, which contains the source database
  • -sourcesiteid: App database site ID to be copied
  • -targetdatabasename: SQL database name, where the site will be copied
  • -targetusername: SQL server user name
  • -targetpassword: SQL server password
  • -targetservername: SQL server name containing the target database
  • -product: Mongoose product, which corresponds to the registry key, for example, Mongoose or SL
  • [-log]: Full path to a log file to redirect to
  • [-alwayson] establishes a SQL connection to a AlwaysOn Availability Group.
  • [-analyzeonly] runs through the copy site process to analyze for potential problems. No copying actually take place in this mode.
  • [-deletedata] deletes all existing data in the target database.
    Caution: Be careful in using this command.

InforWebCL.exe WebClient:

Use this command to configure the web client, for example:

Inforwebcl.exe webclient -product:SL inforwebcl.exe webclient -product:SL -timeout:20 -remoteido:true -remoteidourl:http://server2/idorequestservice/configserver.aspx inforwebcl.exe webclient -product:Mongoose -auth:1 inforwebcl.exe webclient -product:Mongoose -auth:3 -idpfile:idp.properties -appurl:http://win2012/wswebclient

The available commands with some examples are:

  • -product: Mongoose product, for example, Mongoose
  • [-apppool]: Application pool for web client in IIS, which is ASP.NET v4.0 by default
  • [-appurl]: Web.config application URL
  • [-auth]: Authentication type, which is an integer, where:
    • 0 is built-in
    • 1 is IIS
    • 2 is ADFS
    • 3 is PingFederate
  • [-dir]: Virtual directory name for IIS, which is WSWebClient by default
  • [-idpfile]: Full path to the idp.properties file, which is used for PingFederate authentication only
  • [-log]: Full path to a log file to redirect to
  • [-path]: Physical path for virtual directory, which is wwwroot\WSWebClient by default
  • [-timeout]: Web.config timeout value, which is 30 by default
  • [-remoteido]: Flag for remote IDO, which is false by default
  • [-remoteidourl]: Web.config URL for config server
  • [-fedxml]: Web.config federation metadata xml location, which is used for ADFS authentication only
  • [-ssl]: Web.config require SSL for cookie authentication, which is used for PingFederate authentication only
  • [-stscert]: Web.config federation certificate thumbprint, which is used for ADFS authentication only
  • [-trustserver]: Web.config trust server URL, which is used for ADFS authentication only

InforWebCL.exe SmartClient:

Use this command to configure the smart client, for example:

inforwebcl.exe smartclient -product:SL -appname:"CloudSuite Smart Client" -webserver:win2012 -root:SLClientDeploy -dir:SLClientDeploy -user:.\administrator -password:test123 inforwebcl.exe smartclient -product:Mongoose -appname:"Sweet Mongoose App" -webserver:win2012 -user:.\administrator -password:test123

The available commands with some examples are:

  • -appname: Windows smart name, for example, "Mongoose Smart Client"
  • -password: Password for anonymous authentication in IIS
  • -product: Mongoose product, for example, Mongoose
  • -user: User name for anonymous authentication in IIS
  • -webserver: Server name
  • [-configserver]: Server name for remote IDO
  • [-customcertpassword]: Password for custom authentication code certificate
  • [-customcertpath]: Path to a custom authentication code certificate to sign the smart client
  • [-dir]: Virtual directory name for IIS, which is ClientDeploy by default
  • [-log]: Full path to a log file to redirect to
  • [-protocol]: Communication protocol, which is http by default
  • [-remconfig]: Remember configuration group value, which is an integer
  • [-remoteido]: Flag for remote IDO, which is false by default
  • [-root]: ClickOnce physical root folder relative to the WinStudio folder, which is ClientDeploy" by default
  • [-verson]: Version number to use for the ClickOnce manifest of format x.x.x.x, for example, 9.2.0.1

InforWebCL.exe WebApp

inforwebcl.exe webapp -dir:IDORequestService inforwebcl.exe webapp -dir:IDORequestService -apppool:DefaultAppPool

Use this command to configure a web application, such as IDORequestService or InboundQueue, for example:

The available commands with some examples are:

  • -dir: Virtual directory name for IIS, for example, IDORequestService
  • [-apppool]: Application pool for web client in IIS, which is ASP.NET v4.0 by default
  • [-log]: Full path to a log file to redirect to
  • [-path]: Full physical path for virtual directory , which is wwwroot\-dir value is used by default
  • [-snapshotdelay]: FormAsImage service snapshot delay value, in seconds. Typical value is 10.
  • [-site]: IS website, which is "Default Web Site" by default
  • [-timeout]: FormAsImage service timeout value, in seconds. Typical value is 30.
  • [-webclienturl]: FormAsImage service root web client URL, for example, http://win2012r2/wswebclient/

InforWebCL.exe xbap

Use this command to configure the smart client though the web client or XBAP client, for example, using default values:

inforwebcl.exe xbap -appname:"Smart Client via Browser" -product:Mongoose -webserver:win2012 -user:win2012\administrator -password:test123 inforwebcl.exe xbap -appname:"CloudSuite via Browser" -product:SL -webserver:win2012 -user:win2012\administrator -password:test123

The available commands with some examples are:

  • -appname: Windows smart name, for example, "Mongoose Smart Client"
  • -password: Password for anonymous authentication in IIS
  • -product: Mongoose product, for example, Mongoose, which corresponds to the install subfolder
  • -user: User name for anonymous authentication in IIS
  • -webserver: Server name
  • [-configserver]: Server name for remote IDO
  • [-customcertpassword]: Password for custom Authentication code certificate
  • [-customcertpath]: Path to a custom authentication code certificate to sign the smart client
  • [-dir]: Virtual directory name for IIS, which is XBAP by default
  • [-log]: Full path to a log file to redirect to
  • [-protocol]: Communication protocol, which is http by default
  • [-remconfig]: Remember configuration group value, which is an integer
  • [-remoteido]: Flag for remote IDO, which is false by default
  • [-root]: ClickOnce physical root folder relative to the WinStudio folder, which is XBAPClientDeploy by default
  • [-verson]: Version number to use for the ClickOnce manifest of format x.x.x.x, for example, 9.2.0.1

InforWebCL.exe EndUser

Use this command to configure the end user client shortcut, for example, create a desktop shortcut to Mongoose:

inforwebcl.exe enduser -configserver:http://win2012/idorequestservice/configserver.aspx -product:Mongoose -shortcutname:"Infor Mongoose"

The available commands with some examples are:

  • -configserver: Full config server URL
  • -product: Mongoose product, for example, Mongoose
  • -shortcutname: Name for the shortcut
  • [-description]: Description for the shortcut
  • [-icon]: Icon for the shortcut, which is InforDir\Product\ERP.ico by default
  • [-log]: Full path to a log file to redirect to

InforWebCL.exe PingFederate

Example:

inforwebcl.exe pingfederate -appname:MyApp -appdesc:"A great app" -entityurl:http://win2012/wswebclient -outputpath:c:\users\administrators\desktop

The available commands with some examples are:

  • -appname: Name for your application
  • -appdesc: Short description of your application
  • -entityurl: URL to the web client, which requires https and port, for example, https://myserver:44300/WSWebClient
  • -outputpath: Local directory, where the sp.properties file will be written
  • [-log]: Full path to a log file to redirect to

Replication

Example:

inforservicecl.exe replication -server:win2012 -repuser:win2012\administrator -reppassword:test123 -listeneruser:win2012\administrator -listenerpassword:test123

The available commands with some examples are:

  • -server: Name of server to configure
  • -repuser: User name to give permission of queue to and set Replication service logon, which is LocalSystem by default
  • -reppassword: Password of user to give permission of queue to and set Replication service logon
  • -listeneruser: User name to give permission of queue to and set ReplQListener service logon, which is LocalSystem by default
  • -listenerpassword: Password of user to give permission of queue to and set ReplQListener service logon
  • [-log]: Full path to a log file to redirect to

setserviceaccount

Example:

inforservicecl.exe setserviceaccount -service:TaskMan -logonacct:networkservice inforservicecl.exe setserviceaccount -service:TaskMan -logonacct:win2012\administrator -logonpwd:test123

The available commands with some examples are:

  • -LogonAcct: Security account under which the service will be run, for example, Domain\User, LocalSystem, or NetworkService
  • -Service: Windows service to set the credentials on.
    Note: If TaskMan command is used, this is set to TaskMan.
  • [-LogonPwd]: Password for the security account
  • [-Server]: Name of the server to configure service on.
    Note: If not specified, the local machine will be used.
  • [-SkipValidation]: indicates if security account and password validation can be skipped. Default value is false.
  • [-ServerAcct]: specifies whether this configuration task should be performed by an account other than the currently logged on user. Generally, only required if being done on a remote server.
  • [-ServerPwd]: Password for server account

Report services

Use this command to configure report services and deploy reports to the report server, for example:

inforservicecl.exe reportservices -url:http://report.server.com/ReportServer -folder:SyteLineReport -dir:"C:\Program Files (x86)\Infor\SyteLine\Reports\"

inforservicecl.exe reportservices -url:http://win2012r2/ReportServer -reportsonly

The available commands with some examples are:

  • -URL: Report Server URL, for example, http://win2012r2/reportserver
  • [-folder]: Report Server Parent Folder, for example,MongooseReports
    Note: If none is given, a ProductReports string will be generated.
  • [-dir]: Full path to the reports directory.
    Note: If none given, the Report\Reports folder under the WinStudio directory will be used.
  • [-reportsonly]: imports SSRS Reports or RDLs only. No IDO-based reporting setup.