Part 1: Configuring Super Administrators, On Prem Server Configuration Files, and Storage Databases

Navicat On Prem Server is an internal solution for hosting cloud environments, where you can securely store Navicat objects in your location. Navicat has two products designed to facilitate team collaboration, On Prem Sever is one of them, and Navicat Cloud is the other. The main difference between these two solutions is the location of shared objects: for Navicat Cloud, they are stored in a centralized location on the Navicat server, while Navicat On Prem Server is located on your organization's infrastructure. However, you can also install Navicat On Prem Server in Amazon Linux 2 or Docker containers. Today's blog will introduce the first step in configuring Navicat On Prem Server using MySQL 8 Community Server instance on Windows 10. The next blog post will complete the remaining steps of the series.

Starting and stopping Navicat On Prem Server

After installation, Navicat On Prem Server will automatically start. You can also complete this operation through the taskbar icon:

Right clicking on the icon will open the context menu. There, you can start and stop Navicat On Prem Server, as well as enable or disable the auto start feature:

Welcome Page

After installing Navicat On Prem Server and launching it for the first time, the browser will pop up and open the welcome page of Navicat On Prem Server

Face http://<Your_ip Address>:<port_number>. The host address is the system host name where Navicat On Prem Server is installed, and the default port number is 3030. Therefore, the server URL is usually“ http://127.0.0.1:3030/ ”.

On the welcome page, we can click the "Set On Prem Server" button to complete the basic configuration of Navicat On Prem Server, or if we already have a Navicat On Prem Server, we can import the existing settings.





As this is the first installation, we will manually enter the configuration details. There are six sections that need to be filled in:

1、superuser

On Prem Server Information
Connect to the repository server
Application Server
Notification settings
confirm
The following sections will introduce the first three points mentioned above.
Create a super user account

Super user is a local user (Admin) account with unlimited access to Navicat On Prem Server features. You can provide the following personal information of the super user: username, password, full name, email, phone number, preferred language, and appearance. You can also upload personal profile photos:

After entering all the information, click "Next" to continue.

Set On Prem Server configuration file

On the next page, you can provide some detailed information about On Prem Server, such as the On Prem Server name and company name. You can also upload a server logo image:

Click 'Next' to proceed to the next section.
Connect to the repository server
The repository database stores all user information and Navicat objects. The supported databases include

MySQL

MariaDB

PostgreSQL

SQL Server

Amazon RDS

Ideally, you should allocate a separate instance as the repository database. Furthermore, it should not be located on the production server.

To enhance security, you can use SSL authentication and specify the type of encryption password to be used. Supports a variety of common password suites, including TLSRSA-WITH_AES_128_GCM_SHA256, TLS.RSA_SITH_AES_256_SCM_SHA384, TLS.AES128_SCM_SHA256, TLS.AES256_SCM_SHA384, TLS.ACHA20-POLY1305_SHA256, and so on.