Installing Pleasanter (Web Database) on Windows 10 Pro – Notes

PC

This article documents my installation of the web database Pleasanter on Windows 10 Pro.

Installation Environment

  • Model: HP ProDesk 600 G4 SFF
  • OS: Windows 10 Pro 64-bit, Version 22H2
  • CPU: Intel Core i5-8500 @ 3.00 GHz (6 cores)
  • RAM: 32 GB (DDR4 2666 MHz, 4 × 8 GB)
  • Storage: 1 TB SSD

What Is Pleasanter?

Pleasanter is a web-based database and a free, open-source low-code development platform. It runs on both Windows and Linux-based operating systems.

For more information, visit the official website: https://pleasanter.org

Windows Prerequisites

Before installing Pleasanter, some components must be installed and configured on Windows:

.NET Framework

  1. Open Control Panel → Programs → Turn Windows features on or off.
  2. Enable the required components under Internet Information Services (IIS) (see reference image).
  3. If prompted, run Windows Update to install additional components.

IIS Configuration

  1. Open Start → Windows Administrative Tools → Internet Information Services (IIS) Manager.
  2. Navigate to Application Pools → DefaultAppPool → Advanced Settings.
  3. Under Process Model, change Idle Time-out Action from Terminate to Suspend and click OK.

SQL Server 2019 Installation and Configuration

Download and Install

  1. Go to the Microsoft SQL Server Download page and select Express Advanced, then click Download.
  2. Once downloaded, open SQLEXPRADV_x64_JPN.exe from your Downloads folder.
  3. Select “New stand-alone installation or add features to an existing installation”.
  4. When selecting instance features, check:
    • Database Engine Services
    • Full-Text and Semantic Extractions for Search
  5. Complete the installation.

Enable TCP/IP

  1. Open SQL Server 2019 Configuration Manager.
  2. Go to SQL Server Network Configuration → Protocols for MSSQLSERVER.
  3. Right-click TCP/IP and select Enable.

Install SQL Server Management Studio (SSMS)

  1. Download and install Microsoft SQL Server Management Studio (SSMS).
  2. Follow the installer instructions to complete the installation.

Installing .NET 6.0 SDK and Hosting Bundle

.NET 6.0 SDK

  1. Download the .NET 6.0 SDK for Windows x64 and install it.
  2. Open Command Prompt and run: dotnet –version
  3. If the version number appears, the installation was successful.

Hosting Bundle

  1. Download and install the .NET 6 Hosting Bundle.
  2. This completes the Windows-side setup.

Installing and Configuring Pleasanter

Download and Extract

  1. Download Pleasanter from the official download page.
  2. Extract the ZIP file.
  3. Create a folder under C:\web and place the extracted pleasanter folder inside: C:\web\pleasanter

Database Configuration

  1. Edit C:\web\pleasanter\Implem.Pleasanter\App_Data\Parameters\Rds.json to configure the database settings. (Password section is masked.)

Running CodeDefiner

  1. Open Command Prompt and navigate to the CodeDefiner folder: cd C:\web\pleasanter\Implem.CodeDefiner
  2. Run: dotnet Implem.CodeDefiner.dll _rds
  3. If a success message appears, the configuration is complete.

IIS Configuration for Pleasanter

  1. Open IIS Manager.
  2. Go to Application Pools → DefaultAppPool → Basic Settings and set .NET CLR Version to No Managed Code.
  3. Go to Sites → Default Web Site → Advanced Settings.
  4. Set Physical Path to: C:\web\pleasanter\Implem.Pleasanter
  5. Restart Default Web Site.
  6. Pleasanter installation is now complete.

Initial Login

  1. Open a web browser and go to: http://localhost
  2. If the Pleasanter login screen appears, the setup is successful.
  3. Use the following credentials for first login:
    • ID: Administrator
    • Password: pleasanter
  4. You will be prompted to change the password immediately.

Changing the Attachment Storage Location

Pleasanter supports file attachments. By default, attachments are stored on the C drive, which may eventually cause disk space issues.

  1. Edit C:\web\pleasanter\Implem.Pleasanter\App_Data\Parameters\BinaryStorage.json.
  2. Update the configuration: { “Provider”: “Local”, “Path”: “D:\\PleasanterData” } (Replace D:\\PleasanterData with your preferred storage path.)
  3. Restart Pleasanter to apply the changes.

Next Steps

Next, I plan to integrate Pleasanter with the OSS BI tool Metabase for data integration.

Copied title and URL