SymptomsI get the following error when I open the module page (eShop, Image Gallery, etc) in the Sitebuilder Wizard:
Sitebuilder -> Sites -> <site alias> -> Open Site In Wizard -> Edit -> eShop (Image Gallery)
Cannot connect to the database host.
Error! Cannot get module data.
What do these errors mean?
CauseFor a published site, when you open module pages,Wizard Sitebuilder works with the publishing server where the site is published.
Via HTTP requests, it queries and updates the SQLite database that contains module data.
These errors are caused by the inability to work with the database. The problem may be caused by 1) incorrect permissions for the database file or 2) Apache modules that limit communication or 3) connectivity problem between Parallels Plesk Siteubilder and publihsing host.
1) To fix the first problem, verify that the file has correct permissions. The permissions should be 777 and owned by the Apache user.
The SQLite database file is located on the publishing server in the directory <Working directory>/data/storage. Login to the FTP location where the site is published to, verify and correct permissions. The permissions should be:
ftp> ls data/storage
200 PORT command successful
150 Opening ASCII mode data connection for file list
drwxrwsrwx 3 user group 45 Mar 16 18:04 .
drwxrwsr-x 5 user group 45 Nov 29 09:51 ..
drwxrwsrwx 2 user group 6 Nov 29 09:51 attachments
-rwxrwxrwx 1 user group 8192 Feb 10 18:19 sb_modules.php
226 Transfer complete
Where user:group is the user and group of the Apache web server in this directory (Apache works in the directory with privileges of user:group). <Working directory> is the site's publishing directory.
Also, you may login, check and correct via SSH.
2) Apache modules mod_security or mod_security2 may cause the problem.
Currently, it is recommended to disable the modules. For details refer to this article: http://kb.sp.parallels.com/en/5429.
3) Verify network settings and repair connectivity between Parallels Plesk Sitebuilder and publihsing host.