ServBay

https://support.servbay.com/
Admin
ServBay is a local development environment platform for web developers, integrating essential tools...
Tokens:959,750
Snippets:9,151
Trust Score:8.8
Update:1 year ago
Show doc for...
Tokens:
Raw
### Manage MySQL Databases with ServBay

Source: https://context7.com/context7/support_servbay/llms.txt

This guide covers installing, starting, and connecting to MySQL databases using ServBay. It includes commands for connecting via TCP/IP and Unix sockets, retrieving the root password, creating databases and users, granting privileges, backing up, and restoring databases. Performance optimization examples are also provided.

```bash
# Start MySQL service
servbayctl start mysql 8.0
servbayctl status mysql 8.0

# Connect using TCP/IP
mysql -u root -p -h localhost -P 3306

# Connect using Unix socket (faster for local connections)
mysql -u root -p -S /Applications/ServBay/tmp/mysql.sock

# Example: Complete database setup
mysql -u root -p << 'EOF'
-- Create database
CREATE DATABASE myapp_db;

-- Create user with strong password
CREATE USER 'myapp_user'@'localhost' IDENTIFIED BY 'Str0ng!P@ssw0rd';

-- Grant privileges
GRANT ALL PRIVILEGES ON myapp_db.* TO 'myapp_user'@'localhost';

-- Apply changes
FLUSH PRIVILEGES;

-- Verify grants
SHOW GRANTS FOR 'myapp_user'@'localhost';
EOF

# Backup database
mysqldump -u root -p myapp_db > /Applications/ServBay/backup/mysql/myapp_db_backup_$(date +"%Y%m%d_%H%M%S").sql

# Restore database
mysql -u root -p myapp_db < /Applications/ServBay/backup/mysql/myapp_db_backup_20251013_143000.sql

# Optimize database performance
mysql -u root -p << 'EOF'
-- Create index for frequently queried columns
CREATE INDEX idx_user_email ON users(email);

-- Analyze query performance
EXPLAIN SELECT * FROM users WHERE email = 'user@example.com';
EOF
```

--------------------------------

### Create a Basic Static HTML Website

Source: https://support.servbay.com/hi/basic-usage/websites/adding-first-website

This snippet demonstrates the fundamental HTML structure for a simple webpage. It includes a title, a heading, and a paragraph, which is the content served by the `index.html` file in the example.

```html
<!DOCTYPE html>
<html>
<head>
    <title>ServBay Static Test</title>
</head>
<body>
    <h1>बधाई हो! आपका पहला ServBay वेबसाइट सफलतापूर्वक चल रहा है!</h1>
    <p>यदि आप यह पेज देख पा रहे हैं, तो इसका अर्थ है कि आपका लोकल स्टैटिक वेबसाइट ServBay में सफलतापूर्वक सेटअप हो गया है।</p>
</body>
</html>
```

--------------------------------

### Project Setup with .servbay.config and Dependency Installation

Source: https://support.servbay.com/zh-TW/ruby/using-ruby

This example guides through setting up a Ruby project with a specific Ruby version using .servbay.config. It includes creating a project directory, configuring the .servbay.config file, writing a Ruby script, verifying the Ruby version, executing the script, and installing project dependencies using Bundler.

```bash
mkdir my-ruby-project
cd my-ruby-project
```

```ini
RUBY_VERSION=2.7 # Assuming you have Ruby 2.7.x installed

```

```ruby
#!/usr/bin/env ruby
puts "Project is using Ruby version: #{RUBY_VERSION}"
```

```bash
ruby -v
```

```bash
ruby app.rb
```

```bash
# If bundler is not yet installed
# gem install bundler
bundle install
```

--------------------------------

### Start Specific or All PHP Versions with servbayctl

Source: https://support.servbay.com/fr/basic-usage/command-line-tool-servbayctl

Provides examples of using the 'start' command with servbayctl to initiate PHP services. It shows how to start a particular PHP version (e.g., 8.1) or all installed PHP versions using the '-all' flag.

```bash
servbayctl start php 8.1
```

```bash
servbayctl start php -all
```

--------------------------------

### Check Go Installation and Version

Source: https://support.servbay.com/es/go/using-go

This command verifies if Go has been successfully installed and shows the currently activated version managed by ServBay. It's a fundamental step after installation to confirm the environment setup.

```bash
go version
```

--------------------------------

### Start ServBay Service with servbayctl

Source: https://support.servbay.com/pl/basic-usage/command-line-tool-servbayctl

Examples of using the 'start' command with servbayctl to initiate services. It covers starting a specific version of a service (e.g., PHP 8.1), starting all installed versions of a service (e.g., PHP -all), and starting a default service configuration (e.g., MySQL).

```bash
servbayctl start <usługa> [-all|wersja]
```

```bash
servbayctl start php 8.1
```

```bash
servbayctl start php -all
```

```bash
servbayctl start mysql
```

--------------------------------

### Start a ServBay Service (e.g., PHP, MySQL)

Source: https://support.servbay.com/hi/basic-usage/command-line-tool-servbayctl

Demonstrates how to start a specific ServBay service using the `servbayctl start` command. It shows examples for starting a particular version of a service (like PHP 8.1), all versions of a service (like PHP -all), or a default service (like MySQL).

```bash
servbayctl start <service> [-all|version]

# Example: Start PHP 8.1 service
servbayctl start php 8.1

# Example: Start all installed PHP versions
servbayctl start php -all

# Example: Start default MySQL service
servbayctl start mysql
```

--------------------------------

### Start Service with servbayctl

Source: https://support.servbay.com/nl/basic-usage/command-line-tool-servbayctl

Demonstrates how to start a specific service using `servbayctl`. You can start a particular version of a service, all installed versions using the `-all` parameter, or the default version of a service.

```bash
servbayctl start <service> [-all|version]

# Example: Start PHP 8.1 service
servbayctl start php 8.1

# Example: Start all installed PHP versions
servbayctl start php -all

# Example: Start MySQL service with default configuration
servbayctl start mysql
```

--------------------------------

### Start Servbayctl Service

Source: https://support.servbay.com/id/basic-usage/command-line-tool-servbayctl

Demonstrates how to start a specific ServBay service using the 'servbayctl start' command. You can specify a particular version of the service or use the '-all' flag to start all installed versions. This command is essential for enabling services required for your development environment.

```bash
servbayctl start <service> [-all|version]
```

```bash
servbayctl start php 8.1
```

```bash
servbayctl start php -all
```

```bash
servbayctl start mysql
```

--------------------------------

### Node.js Project Scripts Configuration (JSON)

Source: https://context7.com/context7/support_servbay/llms.txt

Example `package.json` snippet showing how to define scripts for starting the application (`start`), running in development mode with auto-reload (`dev`), and executing tests (`test`).

```json
{
  "scripts": {
    "start": "node index.js",
    "dev": "nodemon index.js",
    "test": "mocha test/**/*.js"
  },
  "dependencies": {
    "express": "^4.18.2"
  },
  "devDependencies": {
    "nodemon": "^3.0.1",
    "mocha": "^10.2.0"
  }
}
```

--------------------------------

### Install Gem Package (Jekyll Example)

Source: https://support.servbay.com/ja/ruby/using-ruby

This command installs a specified Ruby gem package using the `gem install` command. The example shows how to install the Jekyll static site generator. Ensure you have the correct Ruby version active.

```bash
gem install jekyll
```

--------------------------------

### Install VitePress and Initialize Configuration (npm)

Source: https://support.servbay.com/fr/nodejs/frontend-frameworks/create-and-run-vitepress-project

These npm commands install VitePress as a development dependency and initialize its configuration within the project directory.

```bash
npm add -D vitepress
npx vitepress init
```

--------------------------------

### Install VitePress and Initialize Configuration (Yarn)

Source: https://support.servbay.com/fr/nodejs/frontend-frameworks/create-and-run-vitepress-project

These Yarn commands install VitePress as a development dependency and initialize its configuration within the project directory.

```bash
yarn add -D vitepress
yarn vitepress init
```

--------------------------------

### Install Project Dependencies with Bundler (Bash)

Source: https://support.servbay.com/ruby/using-ruby

This example shows how to install project dependencies using Bundler, which respects the active Ruby version defined in .servbay.config. It includes steps to install Bundler if it's not already present.

```bash
# If bundler is not installed
# gem install bundler
bundle install
```

--------------------------------

### Navigate to Webroot and Create Project Directory

Source: https://support.servbay.com/de/php/frameworks/create-and-run-phalcon-project

This Bash command navigates to the ServBay webroot directory and creates a new folder for the Phalcon project. It then changes into the newly created project directory.

```bash
cd /Applications/ServBay/www
mkdir servbay-phalcon-app
cd servbay-phalcon-app
```

--------------------------------

### Install ServBay on macOS

Source: https://context7.com/context7/support_servbay/llms.txt

Steps to download, install, and initialize ServBay on macOS. It details the creation of default directories and access to the demo site.

```bash
# Download installer (typically 20MB)
# Double-click ServBayInstaller-vX.Y.Z.dmg
# Drag ServBay.app to Applications folder
# Launch ServBay from Applications

# On first launch, ServBay will prompt for administrator privileges
# to install the ServBay Helper tool
# This is required for managing services, permissions, and port bindings

# After initialization, ServBay creates default directory structure:
# /Applications/ServBay/www         - Website root directory
# /Applications/ServBay/data        - Database and service data
# /Applications/ServBay/backup      - Backup storage
# /Applications/ServBay/tmp         - Temporary files and sockets

# Access demo site at https://servbay.host
# Includes phpMyAdmin, Adminer, and PHP info page
```

--------------------------------

### Install MongoDB Client for Hapi.js

Source: https://support.servbay.com/nodejs/backend-frameworks/create-and-run-hapijs-project

Installs the npm package required for connecting to MongoDB databases from a Hapi.js application. This is a prerequisite for the MongoDB connection example.

```bash
npm install mongoose # or mongodb
```

--------------------------------

### Example: Enable pg_trgm Extension in PostgreSQL

Source: https://support.servbay.com/ja/database-management/postgresql-extensions/official-extensions

A comprehensive example demonstrating the process of connecting to the `postgres` database, installing the `pg_trgm` extension, and verifying its successful installation by listing all extensions.

```sql
# ターミナルでDBへ接続
psql -U postgres -d postgres

# 接続成功時のpsqlプロンプト
psql (16.3 (ServBay))
Type "help" for help.

postgres=# -- インストール済み拡張一覧の表示（初期状態ではplpgsql・pgcryptoなどのみ）
postgres=# \dx
                  List of installed extensions
   Name   | Version |   Schema   |         Description          
----------+---------+------------+------------------------------
 pgcrypto | 1.3     | public     | cryptographic functions
 plpgsql  | 1.0     | pg_catalog | PL/pgSQL procedural language
(2 rows)

postgres=# -- pg_trgm拡張のインストール
postgres=# CREATE EXTENSION pg_trgm;
CREATE EXTENSION

postgres=# -- 再度拡張一覧を確認し、pg_trgm導入を確認
postgres=# \dx
                                    List of installed extensions
   Name   | Version |   Schema   |                            Description                            
----------+---------+------------+-------------------------------------------------------------------
 pg_trgm  | 1.6     | public     | text similarity measurement and index searching based on trigrams
 pgcrypto | 1.3     | public     | cryptographic functions
 plpgsql  | 1.0     | pg_catalog | PL/pgSQL procedural language
(3 rows)

postgres=# -- インストール成功。このDBでpg_trgmの各種関数や演算子が利用可能になりました
```

--------------------------------

### Install ServBay on Windows

Source: https://context7.com/context7/support_servbay/llms.txt

Instructions for installing ServBay on Windows using the provided `.exe` installer. It outlines the recommended installation path and pre-configured features.

```bash
# Download ServBayInstaller-vX.Y.Z.exe
# Run installer and follow prompts
# Recommended path: C:\ServBay

# Windows version features:
# - Built on .NET 9 framework
# - No initialization required
# - Nginx and PHP pre-installed
# - Most macOS features implemented

# Default directories:
# C:\ServBay\www        - Website root
# C:\ServBay\data       - Service data
# C:\ServBay\backup     - Backups

# Launch from Start menu or desktop shortcut
```

--------------------------------

### Vérifier l'utilisation des ports (Windows)

Source: https://support.servbay.com/fr/getting-started/installation

Commande pour vérifier quel processus utilise un port spécifique sur Windows. Utile pour résoudre les conflits de ports avant d'installer ServBay.

```batch
netstat -ano | findstr :[numéro-de-port]
```

--------------------------------

### ServBay frps Server Configuration Example (TOML)

Source: https://support.servbay.com/uk/advanced-settings/how-to-use-frp

An example TOML configuration file for the frps (Fast Reverse Proxy Server) as generated by ServBay. This configuration specifies bind ports, authentication methods, vhost ports for web traffic, and logging settings. It's intended as a starting point and requires adjustment for specific needs.

```toml
# The frps configuration file automatically generated by ServBay
# is intended for direct use on the server.
# Please adjust the configuration parameters according
# to your specific needs.
bindPort = 12345
auth.method = "token"
auth.token = "myserverpassword"

vhostHTTPPort = 80
vhostHTTPSPort = 443

log.to = "/tmp/frps.log"
log.level = "info"
log.maxDays = 3
log.disablePrintColor = true

# Для нових версій frps (наприклад, 0.52.0+), використовуйте webServer.port, webServer.addr, webServer.user, webServer.password для налаштування Dashboard
# webServer.port = 7500
# webServer.addr = "0.0.0.0"
# webServer.user = "admin"

```

--------------------------------

### Install and Connect to PostgreSQL with Node.js

Source: https://support.servbay.com/nl/nodejs/backend-frameworks/create-and-run-hapijs-project

This example shows how to install the `pg` package for PostgreSQL and connect using a connection pool. It outlines the necessary connection parameters and includes a query to verify the connection. Ensure your PostgreSQL server is active in ServBay and update credentials as needed.

```bash
npm install pg
```

```javascript
const { Pool } = require('pg');
const pool = new Pool({
  user: 'user', // Standaard gebruikersnaam ServBay
  host: 'localhost',
  database: 'servbay_hapi_app', // Vervang dit door je eigen databasenaam
  password: 'password', // Standaard wachtwoord ServBay
  port: 5432, // Standaardpoort PostgreSQL
});

pool.connect((err, client, done) => {
  if (err) {
    console.error('Error connecting to PostgreSQL: ', err);
    return;
  }
  console.log('Connected to PostgreSQL');
  client.query('SELECT NOW()', (err, res) => {
    done(); // Vrijgeven clientverbinding
    if (err) {
      console.error('Error executing query', err.stack);
    } else {
      console.log('PostgreSQL current time:', res.rows[0].now);
    }
  });
});

// De pool sluit automatisch bij het afsluiten van de app
// pool.end();
```

--------------------------------

### Verifica utilizzo porte su Windows

Source: https://support.servbay.com/it/getting-started/installation

Comando per verificare quale processo sta utilizzando una porta specifica su Windows. Aiuta a identificare conflitti di porta prima dell'installazione di ServBay.

```batch
netstat -ano | findstr :[numero porta]
```

--------------------------------

### Install WordPress Plugin via Composer

Source: https://support.servbay.com/hi/php/cms/bedrock

This command installs a WordPress plugin as a Composer package into the Bedrock project. Ensure you are in the root directory of your Bedrock project and have Composer installed. The plugin will be installed in the `web/app/plugins` directory.

```bash
composer require wpackagist-plugin/your-plugin-name
```

--------------------------------

### VitePress Initialization Prompts

Source: https://support.servbay.com/fr/nodejs/frontend-frameworks/create-and-run-vitepress-project

This represents the interactive prompts encountered during VitePress initialization, guiding the user through setting up site title, description, theme, and configuration options.

```text
 ┌  Welcome to VitePress! 
 │ 
 ◇  Where should VitePress initialize the config? 
 │  ./docs  # Dossier par défaut, validez par Entrée 
 │ 
 ◇  Site title: 
 │  ServBay VitePress Demo # Saisissez le titre de votre site, par exemple ServBay VitePress Demo 
 │ 
 ◇  Site description: 
 │  A VitePress site running on ServBay # Saisissez la description du site 
 │ 
 ◇  Theme: 
 │  Default Theme # Choisissez le thème, laissez par défaut 
 │ 
 ◇  Use TypeScript for config and theme files? 
 │  Yes # Utiliser TypeScript pour la config, au choix 
 │ 
 ◇  Add VitePress npm scripts to package.json? 
 │  Yes # Ajouter les scripts à package.json, recommandé 
 │ 
 └  Done! Now run npm run docs:dev and start writing.
```

--------------------------------

### Install Gem Package (Rails Example)

Source: https://support.servbay.com/ja/ruby/using-ruby

This command installs the Ruby on Rails framework, a popular web development framework. This operation requires an active Ruby environment and may take some time due to the number of dependencies.

```bash
gem install rails
```

--------------------------------

### Install Ruby Gems (Jekyll and Rails)

Source: https://support.servbay.com/es/ruby/using-ruby

These commands demonstrate how to install Ruby gems using the `gem install` command. The examples show the installation of Jekyll, a static site generator, and Rails, a popular web application framework. Ensure your Ruby environment is active before running these commands.

```bash
gem install jekyll
```

```bash
gem install rails
```

--------------------------------

### Install WordPress Theme via Composer

Source: https://support.servbay.com/hi/php/cms/bedrock

This command installs a WordPress theme as a Composer package into the Bedrock project. It assumes you have Composer installed and are in the root directory of your Bedrock project. The theme will be placed in the `web/app/themes` directory.

```bash
composer require wpackagist-theme/your-theme-name
```

--------------------------------

### Install Phalcon DevTools for PHP 5.6-7.1

Source: https://support.servbay.com/de/php/frameworks/create-and-run-phalcon-project

Installs Phalcon DevTools version 3.4 using Composer, suitable for PHP versions 5.6, 7.0, and 7.1. This command requires Composer to be installed.

```bash
composer require phalcon/devtools:"^3.4"
```

--------------------------------

### ตรวจสอบการใช้พอร์ตบน Windows

Source: https://support.servbay.com/th/getting-started/installation

คำสั่งนี้ใช้สำหรับตรวจสอบว่ามีโปรเซสใดกำลังใช้งานพอร์ตที่ระบุบนระบบปฏิบัติการ Windows หรือไม่ โดยใช้คำสั่ง `netstat` เพื่อแสดงการเชื่อมต่อเครือข่ายและพอร์ตที่ใช้งานอยู่ ร่วมกับ `findstr` เพื่อกรองหาหมายเลขพอร์ตที่ต้องการ.

```batch
netstat -ano | findstr :[หมายเลขพอร์ต]
```

--------------------------------

### Install Phalcon DevTools for PHP 7.2-7.4

Source: https://support.servbay.com/de/php/frameworks/create-and-run-phalcon-project

Installs Phalcon DevTools version 4.1 using Composer, compatible with PHP versions 7.2, 7.3, and 7.4. Composer must be installed to run this command.

```bash
composer require phalcon/devtools:"~4.1"
```

--------------------------------

### Start PostgreSQL Service

Source: https://support.servbay.com/ja/database-management/getting-started/reset-database-password

Starts the PostgreSQL service after configuration changes have been made, allowing for passwordless connections. Ensure the version number matches your PostgreSQL installation.

```bash
servbayctl start postgresql 16

```

--------------------------------

### Verifica utilizzo porte su macOS/Linux

Source: https://support.servbay.com/it/getting-started/installation

Comando per verificare quale processo sta utilizzando una porta specifica su sistemi macOS e Linux. Utile per identificare conflitti di porta prima dell'installazione di ServBay.

```bash
lsof -i :[numero porta]
```

--------------------------------

### Phinx Configuration Example (YAML)

Source: https://support.servbay.com/zh-CN/php/frameworks/create-and-run-slim-project

An example `phinx.yml` configuration file demonstrating how to set up database connection details for different environments. It includes paths for migrations and seeds, and environment-specific settings like adapter, host, database name, user, password, and port.

```yaml
paths:
    migrations: '%%PHINX_CONFIG_DIR%%/db/migrations'
    seeds: '%%PHINX_CONFIG_DIR%%/db/seeds'

environments:
    default_migration_table: phinxlog
    default_environment: development

    development:
        adapter: mysql
        host: 127.0.0.1
        name: servbay_slim_app
        user: root
        pass: password
        port: 3306
        charset: utf8mb4
        collation: utf8mb4_unicode_ci

version_order: creation

```

--------------------------------

### Automate Development Environment Setup

Source: https://support.servbay.com/ar/basic-usage/command-line-tool-servbayctl

This bash script automates the process of starting essential development services using `servbayctl`. It stops all current services, then starts specific versions of PHP, MySQL, Caddy, and Redis.

```bash
#!/bin/bash

echo "Stopping all ServBay services..."
servbayctl stop-all

echo "Starting required services..."
servbayctl start php 8.1
servbayctl start mysql
servbayctl start caddy
servbayctl start redis

echo "ServBay services started."
```

--------------------------------

### Auflisten installierter .NET SDK-Versionen

Source: https://support.servbay.com/de/dotnet/using-dotnet

Zeigt alle von ServBay verwalteten und installierten .NET SDK-Versionen sowie deren Installationspfade an. Dies ist nützlich, um einen Überblick über verfügbare SDKs zu erhalten.

```bash
dotnet --list-sdks

```

--------------------------------

### Memeriksa Penggunaan Port di Windows

Source: https://support.servbay.com/id/getting-started/installation

Perintah ini digunakan untuk memeriksa apakah sebuah port sedang digunakan oleh proses lain di sistem operasi Windows. Ini berguna untuk mengidentifikasi konflik port sebelum menginstal ServBay.

```batch
netstat -ano | findstr :[nomor_port]
```

--------------------------------

### Install PostgreSQL Extension Module

Source: https://support.servbay.com/ja/database-management/postgresql-extensions/official-extensions

Install a PostgreSQL extension module within the connected database using the CREATE EXTENSION command. Replace `module_name` with the desired extension. For example, `CREATE EXTENSION pg_trgm;` installs the `pg_trgm` extension.

```sql
CREATE EXTENSION module_name;
```

```sql
CREATE EXTENSION pg_trgm;
```

--------------------------------

### Install AWS SDK for PHP

Source: https://support.servbay.com/es/storage/using-minio

This snippet shows the command to install the AWS SDK for PHP using Composer. This SDK is a dependency for the subsequent PHP code example that interacts with MinIO.

```bash
composer require aws/aws-sdk-php
```

--------------------------------

### Basic Slim Application Setup

Source: https://support.servbay.com/php/frameworks/create-and-run-slim-project

Initializes a minimal Slim Framework application. It loads Composer's autoloader, sets up a GET route for the root path ('/'), and defines a callback function to return a 'Hello ServBay!' response. The application is then run.

```php
<?php
// Load Composer's autoloader
require __DIR__ . '/../vendor/autoload.php';

// Import necessary PSR-7 interfaces and Slim factory class
use Psr\Http\Message\ResponseInterface as Response;
use Psr\Http\Message\ServerRequestInterface as Request;
use Slim\Factory\AppFactory;

// Create the Slim app instance
$app = AppFactory::create();

// Add a basic route to handle GET requests to root path '/'
$app->get('/', function (Request $request, Response $response, $args) {
    // Write output to response body
    $response->getBody()->write("Hello ServBay!");
    // Return the response object
    return $response;
});

// Run the Slim app
$app->run();
```

--------------------------------

### Start All PHP Services

Source: https://support.servbay.com/ar/basic-usage/command-line-tool-servbayctl

Shows how to use servbayctl to start all installed versions of the PHP service simultaneously. This command is convenient for ensuring all PHP environments are active.

```bash
servbayctl start php -all
```

--------------------------------

### Check Port Usage on Windows

Source: https://support.servbay.com/getting-started/installation

This command helps identify which process is currently using a specific network port on Windows systems. It's crucial for resolving port conflicts before installing ServBay.

```shell
netstat -ano | findstr :[port number]
```

--------------------------------

### Servbayctl Usage Syntax and Examples

Source: https://support.servbay.com/vi/basic-usage/command-line-tool-servbayctl

Illustrates the general syntax for using the `servbayctl` command-line tool and provides specific examples for managing services. The tool follows the pattern `servbayctl <command> <service> [parameters]`, allowing operations like starting, stopping, and restarting various services including PHP, MySQL, and Nginx.

```bash
servbayctl <command> <service> [parameters]
```

```bash
Usage: /Applications/ServBay/script/servbayctl {start|stop|reload|restart|kill|status|stop-all} {php|mariadb|mysql|postgresql|redis|memcached|caddy|nginx|apache|dnsmasq|mongodb|rabbitmq|cloudflared|frpc|mailpit|web|ollama} [-all|version]
```

```bash
servbayctl start php 8.1
```

```bash
servbayctl start php -all
```

```bash
servbayctl start mysql
```

```bash
servbayctl stop php 7.4
```

```bash
servbayctl stop mariadb -all
```

```bash
servbayctl stop redis
```

```bash
servbayctl reload caddy
```

```bash
servbayctl reload php -all
```

```bash
servbayctl restart pgsql
```

```bash
servbayctl restart redis -all
```

--------------------------------

### Servbayctl - Restart a Service (Database and Cache Examples)

Source: https://support.servbay.com/zh-TW/basic-usage/command-line-tool-servbayctl

Demonstrates the 'restart' command, which performs a stop followed by a start operation. Examples include restarting the PostgreSQL database service and restarting all installed versions of Redis.

```bash
servbayctl restart pgsql
servbayctl restart redis -all
```

--------------------------------

### ตัวอย่างการติดตั้ง ServBay บน Windows

Source: https://support.servbay.com/th/getting-started/installation

ขั้นตอนการติดตั้ง ServBay บนระบบปฏิบัติการ Windows โดยเริ่มต้นจากการดับเบิลคลิกไฟล์ `.exe` ที่ดาวน์โหลดมา และดำเนินการตามคำแนะนำในโปรแกรมติดตั้ง.

```batch
1. ดับเบิลคลิกไฟล์ .exe ที่ดาวน์โหลดมา (เช่น ServBayInstaller-v1.12.0.exe)
2. ดำเนินการตามคำแนะนำในโปรแกรมติดตั้ง
3. แนะนำให้เลือกเส้นทางติดตั้งเป็น`C:\ServBay`
4. เปิด ServBay จาก Start Menu หรือทางลัดบนเดสก์ท็อป
```

--------------------------------

### Install and Connect to MongoDB with Mongoose

Source: https://support.servbay.com/nl/nodejs/backend-frameworks/create-and-run-hapijs-project

This snippet guides you through installing the `mongoose` package to connect to MongoDB. It provides a connection string and options for establishing the connection. By default, ServBay's MongoDB does not require authentication, but options are included for secure setups.

```bash
npm install mongoose # of mongodb
```

```javascript
const mongoose = require('mongoose');

mongoose.connect('mongodb://localhost/servbay-hapi-app', {
  useNewUrlParser: true,
  useUnifiedTopology: true,
  // Standaard installatie van MongoDB in ServBay vereist geen authenticatie. Indien wel, vul dan authSource, user, pass aan.
  // authSource: 'admin',
  // user: 'your_username',
  // pass: 'your_password',
})
.then(() => console.log('MongoDB connected'))
.catch(err => console.error('MongoDB connection error:', err));

// Mongoose blijft verbonden gedurende de levensduur van de app
// Verbinding sluiten: mongoose.connection.close();
```

--------------------------------

### Check Port Usage on macOS/Linux

Source: https://support.servbay.com/getting-started/installation

This command helps identify which process is currently using a specific network port on macOS and Linux systems. It's crucial for resolving port conflicts before installing ServBay.

```shell
lsof -i :[port number]
```

--------------------------------

### Kirby Starterkit mit Composer installieren (Bash)

Source: https://support.servbay.com/de/php/cms/kirby

Installiert das Kirby 4.2 Starterkit im aktuellen Verzeichnis mithilfe von Composer. Composer wird verwendet, um die Kirby-Core-Dateien und Abhängigkeiten herunterzuladen.

```bash
composer create-project getkirby/starterkit .
```

--------------------------------

### Install and Use SQLite 3 with Node.js

Source: https://support.servbay.com/id/database-management/getting-started/sqlite3-management-and-usage

This Node.js example shows how to install the 'sqlite3' npm package, connect to an SQLite 3 database, create a 'users' table, insert data, query records, and close the connection. It utilizes the 'sqlite3' module for database operations and 'path' for handling file paths.

```bash
npm install sqlite3
```

```javascript
const sqlite3 = require('sqlite3').verbose();
const path = require('path');

// Tentukan path file database, gunakan path.join untuk portabilitas
const dbPath = path.join('/Applications/ServBay/db/sqlite', 'servbay.db');

// Koneksi ke database SQLite 3
// Jika file belum ada, sqlite3.Database akan membuatnya
let db = new sqlite3.Database(dbPath, sqlite3.OPEN_READWRITE | sqlite3.OPEN_CREATE, (err) => {
  if (err) {
    console.error('Tidak dapat terhubung ke database SQLite 3:', err.message);
  } else {
    console.log('Berhasil terhubung ke database SQLite.');
  }
});

// Serialisasi eksekusi perintah agar urut
db.serialize(() => {
  // Membuat tabel (jika belum ada)
  db.run(`CREATE TABLE IF NOT EXISTS users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    email TEXT UNIQUE
  )`, (err) => {
    if (err) {
      console.error('Gagal membuat tabel:', err.message);
    } else {
      console.log('Tabel "users" berhasil dicek/atau telah dibuat.');
    }
  });

  // Menyisipkan data
  const name = 'ServBay Demo User';
  const email = 'demo@servbay.demo';
  db.run(`INSERT INTO users (name, email) VALUES (?, ?)`, [name, email], function(err) {
    if (err) {
      // SQLITE_CONSTRAINT untuk error constraint unik
      if (err.errno === 19) { // SQLITE_CONSTRAINT
         console.warn(`User '${name}' (${email}) sudah ada, skip penyisipan.`);
      } else {
         console.error('Gagal menyisipkan data:', err.message);
      }
    } else {
      console.log(`Berhasil menyisipkan satu baris data, ID: ${this.lastID}`);
    }
  });

  // Query data
  db.all(`SELECT id, name, email FROM users`, [], (err, rows) => {
    if (err) {
      throw err;
    }
    console.log('Hasil query:');
    rows.forEach((row) => {
      console.log(`ID: ${row.id}, Name: ${row.name}, Email: ${row.email}`);
    });
  });
});

// Menutup koneksi database
db.close((err) => {
  if (err) {
    console.error('Gagal menutup koneksi database:', err.message);
  } else {
    console.log('Koneksi database telah ditutup.');
  }
});

```

--------------------------------

### Start Legacy ASP.NET App with xsp (Bash)

Source: https://support.servbay.com/zh-CN/dotnet/using-dotnet

This example shows how to start the 'xsp' web server to run older ASP.NET Framework applications locally. 'xsp4' is typically used for .NET Framework 4.x applications.

```bash
# Navigate to your legacy ASP.NET application directory
# cd /Applications/ServBay/www/your_legacy_aspnet_app

# Start the xsp4 server on port 8080
xsp4 --port 8080
```

--------------------------------

### Generate Phalcon Project Scaffold

Source: https://support.servbay.com/de/php/frameworks/create-and-run-phalcon-project

Uses the installed Phalcon DevTools to generate the basic project structure for a Phalcon application. The command takes the project name as an argument.

```bash
vendor/bin/phalcon project servbay-phalcon-app
```

--------------------------------

### ตรวจสอบการใช้พอร์ตบน macOS/Linux

Source: https://support.servbay.com/th/getting-started/installation

คำสั่งนี้ใช้สำหรับตรวจสอบว่ามีโปรเซสใดกำลังใช้งานพอร์ตที่ระบุบนระบบปฏิบัติการ macOS หรือ Linux บ้าง โดยใช้คำสั่ง `lsof` ซึ่งเป็นเครื่องมืออรรถประโยชน์ในการแสดงข้อมูลเกี่ยวกับไฟล์ที่เปิดโดยโปรเซสต่าง ๆ.

```bash
lsof -i :[หมายเลขพอร์ต]
```

--------------------------------

### Update Composer Packages

Source: https://support.servbay.com/de/php/frameworks/create-and-run-phalcon-project

After configuring `composer.json`, this command updates Composer packages to install the specified DevTools version. This command should be run in the project's root directory.

```bash
composer update
```

--------------------------------

### Complete PostgreSQL Database Setup

Source: https://context7.com/context7/support_servbay/llms.txt

This script sets up a PostgreSQL database named 'myapp_db' with a user 'myapp_user', grants privileges, enables extensions like PostGIS and pgvector, and creates a table with vector support for similarity search. It's designed for initial database configuration.

```bash
psql -U postgres << 'EOF'
-- Create database
CREATE DATABASE myapp_db;

-- Create user
CREATE USER myapp_user WITH PASSWORD 'Str0ng!P@ssw0rd';

-- Grant privileges
GRANT ALL PRIVILEGES ON DATABASE myapp_db TO myapp_user;

-- Connect to database
\c myapp_db

-- Enable extensions
CREATE EXTENSION IF NOT EXISTS postgis;
CREATE EXTENSION IF NOT EXISTS pgvector;
CREATE EXTENSION IF NOT EXISTS pg_jieba;

-- Create table with vector support
CREATE TABLE documents (
    id SERIAL PRIMARY KEY,
    content TEXT,
    embedding vector(1536)
);

-- Create index for vector similarity search
CREATE INDEX ON documents USING ivfflat (embedding vector_cosine_ops);
EOF
```

--------------------------------

### Verificar Uso de Portas no Windows

Source: https://support.servbay.com/pt/getting-started/installation

Comando para verificar qual processo está utilizando uma porta específica no Windows. Essencial para solucionar conflitos de porta que podem afetar o ServBay.

```batch
netstat -ano | findstr :[número da porta]
```

--------------------------------

### Start MariaDB in Safe Mode for Password Reset

Source: https://support.servbay.com/ja/database-management/getting-started/reset-database-password

Starts the MariaDB instance in safe mode, skipping grant tables and network connections to allow passwordless login for root. This is a crucial step for resetting the root password via the command line. Adjust the path to match your MariaDB installation.

```bash
/Applications/ServBay/package/mariadb/11.3/current/bin/mysqld_safe --skip-grant-tables --skip-networking &

```

--------------------------------

### Vérifier l'utilisation des ports (macOS/Linux)

Source: https://support.servbay.com/fr/getting-started/installation

Commande pour vérifier quel processus utilise un port spécifique sur les systèmes macOS et Linux. Utile pour résoudre les conflits de ports avant d'installer ServBay.

```shell
lsof -i :[numéro-de-port]
```

--------------------------------

### Example: Project-A Go Version Configuration

Source: https://support.servbay.com/id/go/using-go

This example demonstrates how to configure the `.servbay.config` file for a project named 'project-a' that requires Go version 1.12. By committing this file to version control, the entire team will use the same Go environment for this project.

```go
GO_VERSION=1.12
```

--------------------------------

### SCWS Rule File Example

Source: https://support.servbay.com/ar/other-components/scws

This is a basic example of an SCWS rule file, typically located at `/Applications/ServBay/etc/scws/rules.ini`. It provides a structure for defining custom segmentation rules to handle complex or ambiguous Chinese text patterns. Advanced users can modify this file for fine-tuned control over the segmentation process.

```ini
[rule]
# ويمكن إضافة قواعد تقطيع مخصصة هنا
# مثال: تعريف قاعدة بسيطة
# pattern = result
```

--------------------------------

### Check Port Occupancy (Windows)

Source: https://support.servbay.com/zh-TW/getting-started/installation

This command-line utility helps identify which process is using a specific network port on Windows systems. It's essential for diagnosing port conflicts before installing or running services like ServBay.

```batch
netstat -ano | findstr :[port_number]
```

--------------------------------

### Restart ServBay Service with servbayctl

Source: https://support.servbay.com/pl/basic-usage/command-line-tool-servbayctl

Illustrates the use of the 'restart' command with servbayctl, which performs a stop and then a start operation for a service. Examples include restarting PostgreSQL and restarting all installed Redis versions.

```bash
servbayctl restart <usługa> [-all|wersja]
```

```bash
servbayctl restart pgsql
```

```bash
servbayctl restart redis -all
```

--------------------------------

### Menghubungkan ke PostgreSQL dengan 'pg' (Node.js)

Source: https://support.servbay.com/id/nodejs/backend-frameworks/create-and-run-socketio-project

Contoh ini mendemonstrasikan cara membuat pool koneksi ke database PostgreSQL menggunakan pustaka 'pg' di Node.js. Instal pustaka dengan `npm install pg`. Kode ini mengkonfigurasi detail koneksi seperti user, host, database, password, dan port, kemudian menguji koneksi.

```javascript
const { Pool } = require('pg');

// Buat pool koneksi
const pool = new Pool({
  user: 'user', // User default PostgreSQL umumnya 'user'
  host: 'localhost',
  database: 'servbay_socketio_app', // Nama database contoh
  password: 'password', // Password PostgreSQL dari ServBay
  port: 5432, // Port default PostgreSQL
});

// Test koneksi dari pool
pool.connect((err, client, done) => {
  if (err) {
    console.error('Error koneksi PostgreSQL:', err);
    return;
  }
  console.log('Berhasil konek ke PostgreSQL');
  client.release(); // Kembalikan ke pool
  // Anda kini bisa menjalankan query via pool
  // Contoh: pool.query('SELECT NOW()', (err, res) => { ... });
  // ...
});
```

--------------------------------

### Example .servbay.config File for Environment Settings

Source: https://support.servbay.com/zh-TW/advanced-settings/using-servbay-config

This example demonstrates how to configure specific versions for PHP, Node.js, Ruby, Java, Python, .NET, and Go, along with settings for Yarn and NPM registries and cache directories, and Go module proxies. Ensure specified versions are installed in ServBay.

```bash
# .servbay.config example file

# Specify PHP execution version. Ensure this version is installed in ServBay.
PHP_VERSION=8.5

# Specify Node.js execution version. Ensure this version is installed in ServBay.
NODE_VERSION=20

# Set Yarn registry mirror to speed up dependency downloads.
YARN_CONFIG_REGISTRY=https://npmreg.proxy.ustclug.org/

# Set NPM registry mirror to speed up dependency downloads.
NPM_CONFIG_REGISTRY=https://npmreg.proxy.ustclug.org/

# Specify local cache directory for NPM. Note: This path is relative to the ServBay installation directory.
NPM_CONFIG_CACHE=/Applications/ServBay/tmp/npm/cache

# Specify local cache directory for Yarn. Note: This path is relative to the ServBay installation directory.
YARN_CONFIG_CACHE=/Applications/ServBay/tmp/yarn/cache

# Specify Ruby execution version. Ensure this version is installed in ServBay.
RUBY_VERSION=2.7

# Specify Java (OpenJDK) execution version. Ensure this version is installed in ServBay.
JAVA_VERSION=21

# Specify Python execution version. Ensure this version is installed in ServBay.
PYTHON_VERSION=3.11

# Specify .NET execution version. Ensure this version is installed in ServBay.
DOTNET_VERSION=5.0

# Specify Go execution version. Ensure this version is installed in ServBay.
GO_VERSION=1.12

# Set Go module proxy server to speed up module downloads.
GOPROXY=https://goproxy.cn,direct
```

--------------------------------

### Configure Redis Connection for Symfony Cache (.env)

Source: https://support.servbay.com/hi/php/frameworks/create-and-run-symfony-project

This snippet demonstrates how to configure the CACHE_DSN environment variable in the .env file for a Redis connection. It includes examples for a default Redis setup (port 6379) and a Redis setup with a password. Ensure the Redis service is started in the ServBay control panel.

```dotenv
# .env
# ... other settings ...
CACHE_DSN=redis://127.0.0.1:6379
# Redis with password (default has no password):
# CACHE_DSN=redis://:your_password@127.0.0.1:6379
```

--------------------------------

### Node.js-Projekt initialisieren und Abhängigkeiten installieren (Bash)

Source: https://support.servbay.com/de/nodejs/backend-frameworks/create-and-run-socketio-project

Initialisiert ein neues Node.js-Projekt und installiert die notwendigen Pakete 'express' und 'socket.io' mithilfe von npm. Stellt sicher, dass die Projektdateien im empfohlenen ServBay-Verzeichnis abgelegt werden.

```bash
cd /Applications/ServBay/www
mkdir servbay-socketio-chat
cd servbay-socketio-chat
npm init -y
npm install express socket.io
```
Tokens:
Raw