For more information contact us

Integration With PLESK

To integrate SiteStudio with PLESK, do the following:

1. Install SiteStudio in the standard way, using SiteStudio installation manual for Linux.
2. Choose the mysql DB when asked by the install script.
3. After the installation, download FilePublisher from: www.psoft.net/downloads/publisher-1.1.tar.gz
4. Install FilePublisher by running the following commands:
   tar xvfz ./publisher-1.1.tar.gz
   cd publisher-1.1
   ./configure
   make
   make install
5. Change the following information in
   psoft_config/masonry.properties:

   the value of the USER_LOGIN_QUERY parameter depends on your PLESK version. The standard line is:

   USER_LOGIN_QUERY = SELECT dom_id, login, login, passwd, ''email'',
                      concat(''/usr/local/plesk/apache/vhosts/'',name,''/httpdocs/''),
                      concat(''http://'', name,''/'')  FROM domains,  hosting WHERE
                      hosting.dom_id = domains.id AND login = ''{0}''

   Note: this should be written in one line!

   For PLESK 5:

   USER_LOGIN_QUERY = SELECT hosting.dom_id, login, login, passwd,
                     ''email'', concat(home,''/httpdocs/''), concat(''http://'', name,''/'')
                     from sys_users, hosting, domains where login=''{0}'' and
                     hosting.sys_user_id = sys_users.id and domains.id=hosting.dom_id;

   Note: this should be written in one line!

   For PLESK 6:

   USER_LOGIN_QUERY = SELECT hosting.dom_id, login, login, password,
                     ''email'', concat(home,''/httpdocs/''), concat(''http://'', name,''/'')
                     from sys_users, hosting, domains, accounts where login=''{0}''
                     and hosting.sys_user_id = sys_users.id and domains.id=hosting.dom_id
                     and sys_users.account_id=accounts.id

   Note: this should be written in one line!

   Do not forget to change the line /usr/local/plesk/apache/vhosts/ to the path where user sites are stored in your case.

   FILE_PUBLISHER = /usr/local/bin/filepublisher
   USER_CLASS = psoft.user.WebsiteOwnerInitializer
   PUBLISHER_CLASS = psoft.masonry.publisher.FilePublisher
6. Change DB password in the DB configuration section. It is the same as the admin password to the PLESK control panel.
   DB_DRIVER = org.gjt.mm.mysql.Driver
   DB_URL = jdbc:mysql://localhost/plesk
   DB_USER = admin
   DB_PASSWORD = setup
   DB_NEWID = SELECT nextval(''{1}'')

Plesk DB for the same version of PLESK is psa. You need to check it and, if necessary, use

DB_URL = jdbc:mysql://localhost/psa
instead of
DB_URL = jdbc:mysql://localhost/plesk

7. If you want to use SiteStudio plug-ins, you need to set the USER_LOGIN_QUERY and USER_CLASS parameters in the counter_user.properties, poll_user.properties, guestbook_user.properties files according to the instruction above.

8. In psoft_config/customform.properties change:

   USER_URL_QUERY = SELECT concat(''http://'', name,''/'') from domains where id={0}

9. Check your MySQL configuration to access plesk.*, counter.*, guestbok.*, poll.* from localhost.