How can we help you today?

Go ahead and ask us anything.

See the KanBo newest version.

KanBo installation with documents hosted on Egnyte

Last modified:


You can now install KanBo integrated with Egnyte. All documents will be hosted on your Egnyte account, but autentication will be performed using Azure Active Directory. Thanks to this, you can log into such KanBo environment using your Office 365 credentials.

Prerequisites

  1. Enabled integration with AAD and Egnyte
  2. Adding AAD users to your Egnyte account and assigning them permissions
  3. KanBo installation package and KanBo.app.
  4. Office 365 Enterprise E1 environment (or a higher version) and administrator access to it.
  5. Administrator access to the Azure portal.
  6. One SQL Database on Basic: 5 DTU, 2 GB pricing tier created manually for the initial installation process (will be removed after the installation).
  7. Having a custom domain and SSL certificate for your KanBo Web App.

(Important information - KanBo database will be created automatically and charged on Azure during the final steps of the installation process, however, you can change KanBo Content database pricing tier to recommended version for a certain number of KanBo users. See the details about recommended pricing tiers for databases in Configuring KanBo Content Database on Azure part of the installation).


Creating the hosting site

Creating a Web App

First of all, we need to start with creating a new Web App on your Azure. It will be used to host the application.

Go to your Azure management page, click on +New and search for Web App.

Full KanBo installation on Office 365 SharePoint Azure Microsoft



Choose a Web App.

Full KanBo installation on Office 365 SharePoint Azure Microsoft



Click on "Create button".

Full KanBo installation on Office 365 SharePoint Azure Microsoft



Provide the name URL of your site, in our case, it will be "kanboinstallation".

Choose your Subscription, Resource Group (create new and name it "Kanbo") and choose the App Service plan/location. Select OS as Windows.





Configuring a Custom Domain and SSL certificate for Web App

To attach a custom domain:
- Map an existing custom DNS name to Azure Web App
- Bind an existing custom SSL certificate to Azure Web Apps

Follow the Microsoft Technet manuals above to set a custom domain and a SSL certificate to the Web App.

Configuring the new Web App

After the page has been created, we need to change some settings. Click on

Web Apps icon on the left pane and search for your application. Click on your page to navigate to its options.





After the page has loaded, scroll the menu down and click on the "Application settings". You will see the configuration screen, find the Web Sockets option and turn it on. Save your changes.





Creating an SQL database

Enter link https://portal.azure.com/#create/Microsoft.SQLDatabase to create an SQL Database.

The new database is only temporary as it is needed only to configure DB connectivity in the further steps of the installation. In the last step of the installation procedure we will ask you to delete it - it will not be used.
You can name it "kanboinstallation_db" or use any other name. Please set the pricing tier to "Basic: 5 DTU, 2 GB", collation to SQL_Latin1_General_CP1_CI_AS and leave all other parameters as they are.

Click on Create to save your database.



Configuring the DB connectivity

Use the Azure portal to obtain the connection string necessary for your Web App to connect with Azure SQL Database:

Click on SQL Databases icon and then, search for your temporary database.



Click on your database, then click Show database connection strings.



If you are going to use ADO.NET connection library, copy the string of ADO.NET.




Go to the web.config file where we have previously entered the ClientId and ClientSecret. Search for <connectionstrings> section.

Paste the connection string there in the place of an old string. Please modify added connection string - add your user ID and password (use server admin's credentials).


Save the changes.

There are two important things:


a) Put "MultipleActiveResultSets=True" at the end of each connection string.

b) Find out a new Database name (ex. KanBoContent_db) so it is unique for the chosen database. (the name can't be the same as the name of the database we've created for the Azure site). Delete a previous name and replace it with new one.



Now you can delete the previously created temporary database (in our scenario it will be "kanboinstallation_db").

Uploading the KanBo installation package

You can do it in two different ways.

Option 1 - Use FTP

After all changes to the web.config have been made, save the file and upload the whole content of the .rar to the {yourAzureFTPRootFolder}/site/wwwroot/. ATTENTION: DO NOT DELETE EXISTING SITE STRUCTURE!

Full KanBo installation on Office 365 SharePoint Azure Microsoft



Option 2 - Use KUDU service

Navigate to your Azure website KUDU service (add .scm just before azurewebsites.net e.g https://kanbo-online-kanbo.scm.azurewebsites.net, then select Debug console -> PowerShell).

Then enter site folder -> wwwroot.

Pack all your files into a .zip file (but please don't add the folder!)

Now drag and drop your .zip archive into left upper part of KUDU service.



Make sure you copy these plugins into Extensions folder:`KanBo.Egnyte.dll` and `KanBo.Graph.dll`

Ask the KanBo support for these files - [email protected]

Configure Azure AD connectivity


Go to Office 365 admin panel, extend Admin centers and select Azure Active Directory.


Select Azure Active Directory and look for App Registrations.

Click on +New registration.

Create a name and paste the redirect URL.

Add your URL to this address: https://YOUR KANBO ADDRESS/auth/aad/return


Click on register to save the changes.

When app is registered, go to API Permissions.

Select +Add a permission and select Microsoft Graph.

    Give the following permissions under MS Graph.

    Application permissions:

    • User.Read.All


    Delegated Permissions:

    • User.Read.All


    Now, when all permissions are selected, click on Grant Permissions.

      Create a pair of certificates using this manual or purchase a pair of certificates for MS Graph authorization.





      Go to Certificates and Secrets section in App registrations to register a certificate.



      Click on Upload public key and select your .cer certificate. Now click Save.

        Your certificate should be now visible.


        Go back to Overview. Get Application ID and Directory (Tenant) ID and save it for later as this would be used in the KanBo configuration.




        Upload the certificate to KanBo

        1. Open Azure portal. Make sure your Web App is at least on the Basic plan.


        2. Go to TLS/SSL Bindings and go to Private Key Certificates (.pfx) Select Upload certificate.

        3. Provide the password and Upload it.

        4. Copy the certificate's thumbprint.

        6. Open Configuration and add a new Application Setting.

        7. The setting's name should be WEBSITE_LOAD_CERTIFICATES. The value should be the Thumbprint of the certificate. Save it.

        Generate broker entry - contact [email protected] for it.

        Add the following to the config (after ``) all the data should be inside azure ad (except generated private key, which should be on kanbo machine):

        <auth-by-login issuer="aad" />
        <auth.aad
        client-id="{Client ID}"
        tenant="{Tenant ID}"
        >
            <signer
            type="x509-store"
            key="thumbprint"
            value="{Thumbprint}"
            valid-only="false"
            store-name="my"
            store-location="localmachine"
            />
            <!--
        alternative way to apply certificate -->
        <--
            <signer
                type="x509-file"
                 file="c:\cert\my-cert.pfx"
                 key="{PassForCert}"
            />
        -->
        
        <-- Broker entry -->
        <auth.egnyte egnyte-url="https://appkanbo.qa-egnyte.com" broker-url="https://egnyte.authkanbo.com/k-egnyte" client-id="..." client-secret="..." persist-credentials="true">
        <egnyte-provision>
        <users-source.search.graph issuer="aad">
        <users-source.graph issuer="aad">
        <sso-users.egnyte id-provider="upn-graph">
        <setup-permissions.egnyte>
        <!-- Collisions in group names? Use custom name, default is: -->
        <!-- <group-sync.egnyte name="KanBo_{details}" -->
        <group-sync.egnyte name="kanbo_{details}">
            <permissions>
                <permission egnyte="owner" kanbo=""/>
                <permission egnyte="full" kanbo="owner"/>
                <permission egnyte="editor" kanbo="member"/>
                <permission egnyte="viewer" kanbo="visitor"/>
          
        </group-sync.egnyte>
        <egnyte-docsource />
        <website-search.egnyte />
        


        Go to https://{yourkanboaddress}/setup.

        Use url `https://{kanbo address}/auth/egnyte/set-service-account` with prepared service account

        Choose the Automatic Setup option.

        Full KanBo installation on Office 365 SharePoint Azure Microsoft

        After clicking on the Automatic Setup option, installation of KanBo Setup will proceed. Wait a couple of seconds until it is finished.

        Full KanBo installation on Office 365 SharePoint Azure Microsoft



        When the process succeeds you'll be presented with the following communicate (in the screen below in Obtaining the licence key part).

        Obtaining the license key

        You will get the following communicate. In order to obtain the license key, you will need to send us your KanBo.

        The selected string is essential for the license key creation process. Please send the KanBo ID to [email protected] so a license key can be generated and send to you.




        After obtaining the key you have to paste it into the web.config file. To achieve that, please follow these steps:

        Go to KUDU service (https://YOURNAME.scm.azurewebsites.net). Please navigate to: Debug console -> Powershell -> site ->wwwroot and open the web.config file.





        Enter the web.config and paste the license key in the following place.



        After updating the pasting the KanBoLicenseKey save the web.config. 

        14. Remove this line from config

        <website-search.sharepoint></website-search.sharepoint>

        15. Replace

        <package name="standard" />

        with

        <package name="kanbo" />


        Is this article helpful for you?