[INFO] What is publishing schema for Parallels Plesk Sitebuilder site?


2016-11-16 12:55:12 UTC


2017-04-24 12:07:37 UTC


Was this article helpful?

Have more questions?

Submit a request

[INFO] What is publishing schema for Parallels Plesk Sitebuilder site?

Applicable to:

  • Plesk Sitebuilder 4.5 for Linux


Relatively to files storage location there are two types of Sitebuilder sites:

published site

non-published site

Whole content of non-published site is stored on Parallels Plesk Sitebuilder server in site directory /usr/local/sitebuilder/htdocs/sites/90/9045a6c768e89f9fa5ca2bb8a7c5b78c , where 9045a6c768e89f9fa5ca2bb8a7c5b78c is unique site identification:

~# mysql  sitebuilder3 -e"select * from site limit 1\\G"
*************************** 1. row ***************************
id: 9
dir_name: 9045a6c768e89f9fa5ca2bb8a7c5b78c
site_id: 9045a6c768e89f9fa5ca2bb8a7c5b78c
alias: sitebuilder45.site

Text content is stored in Sitebuilder database, images are stored in file system, modules are stored in SQLite database.

During site publishing content is compiled to HTML/PHP pages and uploaded to the publishing location via FTP.

There are two types of site publishing: " Normal publish " and " Republish the entire site content ".In both types site files are uploaded to the publishing location via FTP, configuration is checked with HTTP requests.

" Normal publish " means that only changed content and images are uploaded, "Publish the entire site content" means that also files of design template are uploaded.

Before files uploading Parallels Plesk Sitebuilder 4.5 verifies site publishing location . It uploads a simple php script ( /usr/local/sitebuilder/resources/publish/check.php ) to the publishing location via FTP and execute it via URL.

Images of Sitebuilder 4.5 site may belong to a module (Image Gallery, eShop, etc), be uploaded to a page with WYSIWYG item " Insert/Edit Image " or be custom Banner/Logo. For new module the images are stored in subdirectory " /data/storage/attachments/ " on Sitebuilder host, image preferences are stored in SQLite database file sb_modules.php that is stored in subdirectory " /data/storage ". For example, here files of new module Image Gallery:

~# ls -l /usr/local/sitebuilder/htdocs/sites/90/9045a6c768e89f9fa5ca2bb8a7c5b78c/data/storage/attachments/
--rw-r--r-- 1 apache apache 50066 Aug 24 09:20 08255544c930caa2ff4bee478fa19437.jpg
--rw-r--r-- 1 apache apache 23909 Aug 24 09:21 145b7d65e03ce91d8b1c97baa61e564e.jpg

~# ls -l /usr/local/sitebuilder/htdocs/sites/90/9045a6c768e89f9fa5ca2bb8a7c5b78c/data/storage/
total 60
drwxr-xr-x 2 apache apache 4096 Aug 24 08:45 attachments
-rwxrwxrwx 1 apache apache 52224 Aug 24 08:59 sb_modules.php

When the site is published for the first time (after adding module), the images and SQLite database file are moved to the publishing host into appropriate directories:

~# ls -l  /var/www/vhosts/DOMAIN.TLD/httpdocs/data/storage/attachments/
total 340
-rwxrwxrwx 1 domain psacln 50066 Aug 24 09:39 08255544c930caa2ff4bee478fa19437.jpg
-rwxrwxrwx 1 domain psacln 23909 Aug 24 09:39 145b7d65e03ce91d8b1c97baa61e564e.jpg
~# ls -l /var/www/vhosts/DOMAIN.TLD/httpdocs/data/storage/
total 60
drwxrwxrwx 2 domain psacln 4096 Aug 24 08:45 attachments
-rwxrwxrwx 1 domain psacln 52224 Aug 24 09:39 sb_modules.php

Module files are not stored on Sitebuilder server anymore:

~# ls -l /usr/local/sitebuilder/htdocs/sites/90/9045a6c768e89f9fa5ca2bb8a7c5b78c/data/storage/
total 4
drwxr-xr-x 2 apache apache 4096 Aug 24 08:37 attachments
~# ls -l /usr/local/sitebuilder/htdocs/sites/90/9045a6c768e89f9fa5ca2bb8a7c5b78c/data/storage/attachments/
total 0

Next time you edit site module through Sitebuilder Wizard the images and content is edited on the publishing host directly. They are uploaded to the publishing host only during first publishing. If you plan to created a site with huge number of images in Image Gallery or other module it is recommended that you publish site configuration (without images) first and then uploaded images one by one .

All images uploaded to Server repository through WYSIWYG item " Insert/Edit Image " ( Browse Server > Upload a new file in this folder ) are uploaded during site publishing every time. On Sitebuilder host these images are stored in subdirectory " /attachments/Image ":

~# ls -l /usr/local/sitebuilder/htdocs/sites/90/9045a6c768e89f9fa5ca2bb8a7c5b78c/attachments/Image
total 4
-rwxrwxrwx 1 apache apache 1913 Aug 24 09:26 images5.jpeg

The image(s) is uploaded to the publishing location each time you publish the site. The image(s) is uploaded into subdirectory " /attachments/Image ":

~# ls -l /var/www/vhosts/DOMAIN.TLD/httpdocs/attachments/Image
total 4
-rw-r--r-- 1 domain psacln 1913 Aug 24 09:27 images5.jpeg

It's not recommended that you remove these images from Sitebuilder host since they will be also removed from publishing host during next site publishing.

Images uploaded to site as custom logo or banner are stored on Sitebuilder host in subdirectory " /customImages/logo " or " /customImages/header ". For example:

~# cd /usr/local/sitebuilder/htdocs/sites/90/9045a6c768e89f9fa5ca2bb8a7c5b78c/
~# ls -l customImages/header/header.jpg customImages/logo/c8a9982d81fe5a881f387c18821b822b.gif
-rw-rw-r-- 1 apache apache 8052 Aug 24 09:16 customImages/header/header.jpg
-rw-rw-r-- 1 apache apache 182 Aug 24 09:16 customImages/logo/c8a9982d81fe5a881f387c18821b822b.gif

During site publishing they are always uploaded to the publishing location. On publishing host they are stored in subdirectory " images ":

~# cd /var/www/vhosts/DOMAIN.TLD/httpdocs/
~# ls -l images/header.jpg images/logo/c8a9982d81fe5a881f387c18821b822b.gif
-rw-r--r-- 1 domain psacln 8052 Aug 24 09:27 images/header.jpg
-rw-r--r-- 1 domain psacln 182 Aug 24 09:27 images/logo/c8a9982d81fe5a881f387c18821b822b.gif

Option " Publish the entire site content " means that the site will be published with site content (text, image, modules) and configuration of design template, with directories " css ", " img ", " resources " and " include ".

Additional information

Publishing host is server with FTP and HTTP where Sitebuilder site is published to. It may be one of several physical servers.During site publishing files are uploaded via FTP, Parallels Plesk Sitebuilder queries published site via HTTP requests.

Additional information

For schema of Parallels Plesk Sitebuilder refer to article Installing Plesk Sitebuilder in Distributed Environment in Plesk Sitebuilder 4.5 for Linux/Unix Installation Guide .

Have more questions? Submit a request
Please sign in to leave a comment.