SiteStudio Online Documentation

For more information contact us

Integration With PLESK

IMPORTANT:

This document relates to SiteStudio versions up to 1.6RC2. For SiteStudio 1.6RC3 and higher, refer to Linux Installation Guide.

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}'')
  7. 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
  8. 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.

  9. In psoft_config/customform.properties change:

    USER_URL_QUERY = SELECT concat(''http://'', name,''/'') from domains where id={0}
  10. Check your MySQL configuration to access plesk.*, counter.*, guestbok.*, poll.* from localhost.


See also

Product Page
Online Demo
FAQ
SiteStudio Icons
SS Doc Home



Copyright 1998-2007. Positive Software Corporation.
All rights reserved.