Setup and installation of 'NocoDB: An Opensource License free alternative to Airtable' on Azure

This section describes how to launch and connect to ‘NocoDB: An Opensource License free alternative to Airtable’ VM solution on Azure.

1. Open NocoDB: An Opensource License free alternative to Airtable VM listing on Azure Marketplace.

2. Click on Get It Now

• Login with your credentials, provide the details here. Once done click on Continue.

• It will take you to the Product details page. Click on Create.

• Select a Resource group for your virtual machine

• Select a Region where you want to launch the VM(such as East US)

• Note: If you see “This image is not compatible with selected security type. To keep trusted launch virtual machines, select a compatible image. Otherwise change your security type back to Standard” error message below the Image name as shown in the screenshot below then please change the Security type to Standard.

• Optionally change the number of cores and amount of memory.

Select the Authentication type as Password and enter Username as ubuntu and Password of your choice.

• Optionally change the OS disk size and its type.

• Optionally change the network and subnetwork names. Be sure that whichever network you specify has ports 22 (for ssh), 3389 (for RDP) and 80 (for HTTP) exposed.

• The VM needs Static IP address to work correctly. To get the Static IP, on the Networking page, click on Create New under Public IP dropdown.

• On the Create Public IP address page, select Static radio button and click Ok at the bottom of this page.

The VM comes with the preconfigured NSG rules. You can check them by clicking on Create New option available under the security group option.

• Optionally go to the Management, Advanced and Tags tabs for any advance settings you want for the VM.
• Click on Review + create and then click on Create when you are done.
  Virtual Machine will begin deploying.

3. A summary page displays when the virtual machine is successfully created. Click on Go to resource link to go to the resource page. It will open an overview page of virtual machine.

4. If you want to update your password then open up the left navigation pane, select Run command, select RunShellScript and enter following command to change the password of the vm .

sudo echo ubuntu:yourpassword | chpasswd

Now the password for ubuntu user is set, you can SSH to the VM. To do so, first note the public IP address of the VM from VM details page as highlighted below

Open putty, paste the IP address and click on Open.

login as ubuntu and provide the password for ‘ubuntu’ user.

5. You can also connect to the VM’s desktop environment from any local windows machine using RDP protocol or local linux machine using Remmina.

6. To connect using RDP via Windows Machine, first note the public IP address of the VM from VM details page as highlighted below

7. Then From your local windows machine, goto “start” menu, in the search box type and select “Remote desktop connection”.
   In the “Remote Desktop connection” wizard, copy the public IP address and click connect

8. This will connect you to the VM’s desktop environment. Provide the username (e.g “ubuntu”) and the password set in the above step to authenticate. Click OK

9. Now you are connected to the out of box NocoDB: An Opensource License free alternative to Airtable VM’s desktop environment via Windows Machine.

10. To connect using RDP via Linux machine, first note the external IP of the VM from VM details page, then from your local Linux machine, goto menu, in the search box type and select “Remmina”.

Note: If you don’t have Remmina installed on your Linux machine, firstInstall Remmina as per your linux distribution.

11. In the “Remmina Remote Desktop Client” wizard, select the RDP option from dropdown and paste the external ip and click enter.

12. This will connect you to the VM’s desktop environment. Provide “ubuntu” as the userid and the password set in above reset password step to authenticate. Click OK

13. Now you are connected to out of box NocoDB: An Opensource License free alternative to Airtable VM’s desktop environment via Linux machine.

14. To connect to NocoDB UI, copy the Public IP of the VM from VM’s overview page and paste it in the browser in the format http://public_ip/. Make sure to use HTTP and not HTTPS.

15. Provide any email id and password to signup. This will create first user with Super Admin access.

16. You can also restrict the signup only using the invite url. To do so , go to Teams and Settings option from left pane of home page, select settings under User Management. Tick the checkbox to enable signup only using invite link.

For more information on how to use NocoDB, please visit NocoDB Official Documentation