Synology NAS Deployment Guide

Open DSM → Package Centre and install all three:

Enable PHP extensions in DSM:

1. Go to Package Centre → PHP 8.0 → Open
2. Click the PHP Settings tab (or open Web Station → PHP Settings)
3. Enable: pdo, pdo_mysql, mysqli
4. Click Apply

1. Open DSM → MariaDB 10 from the main menu
2. Click Enable MariaDB if not already running
3. On the first launch, you will be prompted to set a root password — write it down!
4. Note the port: Synology MariaDB 10 uses port 3307 by default (not the standard 3306)

Option A — phpMyAdmin (Easiest)

1. Install phpMyAdmin from DSM Package Centre (it's free)
2. Open phpMyAdmin, log in with root and your root password
3. Click the SQL tab at the top
4. Open db/schema.sql from this project, copy the entire contents, paste into the SQL window
5. Click Go / Execute
6. You should see: "Schema installed successfully."

Option B — SSH Command Line

1. Enable SSH on the NAS: DSM → Control Panel → Terminal & SNMP → Enable SSH
2. SSH into the NAS from your PC:
   

   ssh admin@YOUR_NAS_IP

3. Run the schema file:
   

   mysql -u root -p -P 3307 -h 127.0.0.1 < /volume1/web/centre/db/schema.sql

4. Enter your root password when prompted

Open db/config.php in a text editor and update the highlighted values:

define('DB_HOST',  'localhost');
define('DB_PORT',  3307);          // ← Synology MariaDB default
define('DB_NAME',  'centre_cms');
define('DB_USER',  'cms_user');    // ← the app-specific user
define('DB_PASS',  'YOUR_STRONG_PASSWORD'); // ← change this!

mysql -u root -p -P 3307 -h 127.0.0.1
ALTER USER 'cms_user'@'localhost' IDENTIFIED BY 'C3ntr3@NAS!2025';
FLUSH PRIVILEGES;
EXIT;

The web root for Apache on Synology is usually:

/volume1/web/

Create a centre/ subfolder and upload all project files maintaining this structure:

Upload methods:

The .htaccess file uses RewriteEngine. You need to confirm it's enabled.

Via SSH:

# Check if rewrite module is loaded
httpd -M 2>/dev/null | grep rewrite

# If not listed, enable it in Apache config:
# Edit /etc/httpd/conf/httpd.conf  (path may vary by DSM version)
# Uncomment or add:
LoadModule rewrite_module modules/mod_rewrite.so

Verify AllowOverride in Apache config:

<Directory "/volume1/web">
    Options Indexes FollowSymLinks
    AllowOverride All    ← must be "All", not "None"
    Require all granted
</Directory>

Apache config is usually at: /etc/httpd/conf/httpd.conf or via DSM → Apache → Virtual Host settings

• ✅
  Run diagnostic: http://NAS_IP/centre/api-test.php — all rows should show green ✅
• ✅
  Open the app: http://NAS_IP/centre/ — you should see the portal selector
• ✅
  Test the API directly: http://NAS_IP/centre/tables/members should return {"data":[],"total":0,"page":1,"limit":100,"table":"members"}
• ✅
  Register a test member: Go to Manager Portal → New Registration, fill in and submit. The member should appear in the list.
• ✅
  Member login test: Open member.html, enter the test member's Membership ID and their PIN.
• ✅
  Check API in browser devtools: Open F12 → Network tab in manager.html, watch for tables/members calls returning 200.

Quick API smoke-test (SSH or browser):

# Test from NAS SSH:
curl -s http://localhost/centre/tables/facilities
# Expected: {"data":[],"total":0,...}

# Test member create:
curl -s -X POST http://localhost/centre/tables/members \
  -H "Content-Type: application/json" \
  -d '{"first_name":"Test","last_name":"Member","membership_id":"T0001","membership_type":"Adult","status":"Active","pin":"1234","emergency_name":"Test Emergency","emergency_phone":"12345678","phone":"91234567"}'

Enable HTTPS (recommended for remote access):

1. Go to DSM → Control Panel → Security → Certificate
2. Add a Let's Encrypt certificate for your Synology DDNS hostname
3. Enable DDNS: Control Panel → External Access → DDNS → Add → choose Synology as provider → get yourname.synology.me
4. Enable port forwarding on your router: external 443 → NAS IP:443
5. Access remotely at https://yourname.synology.me/centre/

Useful SSH commands for debugging:

# Check Apache is running
synoservicectl --status pkgctl-Apache2.4

# Restart Apache
synoservicectl --restart pkgctl-Apache2.4

# Check MariaDB is running
synoservicectl --status pkgctl-MariaDB10

# Check Apache error log
tail -50 /var/log/apache2/error.log

# Check PHP error log
tail -50 /var/log/php8.0-fpm.log

# Test DB connection from CLI
mysql -u cms_user -p -P 3307 -h 127.0.0.1 centre_cms -e "SHOW TABLES;"