Page Comparison

Sec. A

Run the Pre-Install Checker in AGRIS to check for incomplete requirements

Sec. B

AGENT Pre-Install Requirements

Running the latest version of AGRIS 20.3 SU4 or higher on Windows Server 2012 R2 or higher.

Install Microsoft .Net framework v 4.7.2. This must be installed on the AGRIS / Component server. This will require a reboot of the server upon completion.

Meet the Recommended Hardware and Software Requirements for Installing Microsoft SQL Server 2017 Express which can be found here.

Install Microsoft SQL Server Express 2017 or higher, which is used for the agent only. 

• Allocate not more than 50% of the RAM on the machine to running Microsoft SQL Server 2017 Express. To do this, click here.

Install Microsoft SQL Server 2018 Management Studio. This will require a reboot of the server upon completion.

• Confirm SQL Server Management console works by opening the management console. 

• There is a known issue where the management console does not open or stay open. To learn how to fix it click here. 

If running AGRIS in production with the P-SQL database engine, be on P-SQL version 12 or 13.

If running AGRIS in production with the MS-SQL database engine, be on MSSQL16 or higher:

• Have the MS-SQL server on a dedicated server (best practice).

• If the SQL Server also has AGRIS installed (not a best practice): 

  • Assure that MS-SQL Server 2016 or 2017 is installed OR move AGRIS to an Application Server to support the agent.

• The agent will be installed on a server where AGRIS is installed.

Open required ports

• Ensure ports 8080, 8443, 443, 80 are open between Agent and Gateway. The Agent uses SSL/TLS1.2 over port 443 to communicate with Gateway

• Verify connectivity from the agent machine to the MYG gateway by using a web browser and going to:

  • https://mygrower.culturatech.com/Cultura/RESTSecurityWebService/Authenticate

  • This should return a small JSON message when opened in a browser.

If above fails, review with your networking team to provide details network logs/traces and check if they have any advanced security scanners/protocols enforced.

After meeting all the requirements run the Pre-Install Checker in AGRIS.

• Take a screenshot of the results and share it with Tracy Curtis at Greenstone to schedule your install.

Purpose of this Document:

Below are some of the basic setup prerequisites and system requirements that must be in place before the MyGrower AGRIS Application installation can begin. 

For customers running AGRIS on Actian (Zen) PSQL databases:

1. Be live on the current version of AGRIS, comply with the AGRIS System Requirements (20.3.0 or 21.1.0 or higher) AND apply the latest available AGRIS software update for that applicable version.  

   1. Agent will be installed on AGRIS/Component server 

2. Be live on Windows Server 2012 R2 or higher

3. Be live on Pervasive version 12 or higher

4. Install the latest version of Microsoft SQL Server Express (Free). Reboot required after download to install.

   1. Has to be on AGRIS/Component server.

   2. Allocate no more than 50% of the RAM on the machine to running Microsoft SQL Server Express. Learn how to here. 

5. Install Microsoft SQL Server 2018 Management Studio (Free). Reboot required after download to install.

   1. Has to be on AGRIS/Component server. 

   2. There is a known issue if your Management console does not open or stay open. Learn how to fix here.

6. AGRIS System license has been added and enabled for Extended option SYS > Option 21 - MyGrower

7. Ensure that the Data Path in the AGRIS.ini on the Database Server is using a UNC path. This is needed in order for PDF forms to work.

8. For MyGrower PRO Customers, provide the following to your Greenstone Services representative who helps you install, setup and learn MyGrower:

   1. Your business LOGO with a minimum size of 1024 x 1024 pixels (in the PNG or EPS file type)

   2. The NAME for your app (visually, the shorter the better)

   3. The Hex#s for the App theme COLORS

      1. App loading screen: 

      2. Login screen: 

      3. Login screen buttons: 

      4.  Inside app color: Top bar & Bottom bar

      5. Inside app color: Text - ???? (e.g., Hex#000000 for black)

   4. The "RELEASE NOTES" text for the app stores, like "Welcome to the new YOUR COMPANY'S NAME mobile app!  It's an easy and simple solution for you to view balances, bids, contracts, tickets, settlements, invoices, statements and much more!"

/wiki/spaces/SOECSA/pages/675315822

For customers running AGRIS on MS-SQL:

1. Be live on the current version of AGRIS, comply with the AGRIS System Requirements (20.3.0 or 21.1.0 or higher) AND apply the latest available AGRIS software update for that applicable version.  

   1. Agent will be installed on AGRIS/Component server

   2. Have the SQL server on a dedicated server (best practice). 

   3. If the SQL Server also has AGRIS installed (not a best practice): Assure that SQL Server 2016 or 2017 is installed, OR, Move AGRIS to an Application Server to support the agent. 

2. Be live on Windows Server 2012 R2 or higher

3. Install latest version of Microsoft SQL Server Express (Free). Reboot required after download to install. 

   1. Has to be on AGRIS/Component server.

   2. Allocate no more than 50% of the RAM on the machine to running Microsoft SQL Server Express.  Learn how to here.

4. Install Microsoft SQL Server 2018 Management Studio (Free). Reboot required after download to install

   1. Has to be on AGRIS/Component server. 

5. AGRIS System license has been added and enabled for Extended option SYS > Option 21 - MyGrower

6. Ensure that the Data Path in the AGRIS.ini on the Database Server is using a UNC path. This is needed in order for PDF forms to work.

7. For MyGrower PRO Customers, provide the following to your Greenstone Services representative who helps you install, setup and learn MyGrower:

   1. Your business LOGO with a minimum size of 1024 x 1024 pixels (in the PNG or EPS file type)

   2. The NAME for your app (visually, the shorter the better)

   3. The Hex#s for the App theme COLORS

      1. App loading screen: 

      2. Login screen: 

      3. Login screen buttons: 

      4.  Inside app color: Top bar & Bottom bar

      5. Inside app color: Text - ???? (e.g., Hex#000000 for black)

   4. The "RELEASE NOTES" text for the app stores, like "Welcome to the new YOUR COMPANY'S NAME mobile app!  It's an easy and simple solution for you to view balances, bids, contracts, tickets, settlements, invoices, statements and much more!"

/wiki/spaces/SOECSA/pages/673480756

FAQ's:

• Where does the agent get installed?

  • On the AGRIS component server

• Do we need a dedicated public IP(regarding DMZ)?

  • We will not require a dedicated public IP for the Agent.  But the agent will communicate with MyGrower. The gateway accesses the MyGrower agent via a secured port on your server, negating the need to have it in a DMZ.

• How exactly does the MyGrower app connect?

  • It connects to a server at Culturatech, talking to the MyGrower agent installed on your server, which is responsible for pulling the requested data from local datasets and sending back out to Culturatech servers. 

• Does this conflict with or replace iView, which is on component server already?

  • No, It will not conflict with iView. You can have both agents on the same server with no problem.

• As of 15 Mar 2021 TLS 1.2 is supported.   Cannot use earlier versions.