SiteStudio Online Documentation

For more information contact us at info@psoft.net

How to integrate SiteStudio with PLESK^™

To integrate SiteStudio with Plesk, do the following:

1. Install SiteStudio in the standard way, using installation manual for Linux.
2. Choose the mysql DB when install script asks you about it.
3. When installation is finished, you need to install file publisher at your box. You can download it from: www.psoft.net/downloads/publisher-1.1.tar.gz
4. To extract from archive and install FilePublisher, execute:

   > tar xvfz ./publisher-1.1.tar.gz
   > cd publisher-1.1
   > ./configure
   > make
   > make install

Now the FilePublisher is installed.
5. Now you need to change the following information in

   psoft_config/masonry.properties:

   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

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

   For the last version of plesk, the USER_LOGIN_QUERY is:

   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

   FILE_PUBLISHER = /usr/local/bin/filepublisher
   USER_CLASS = psoft.user.WebsiteOwnerInitializer
   PUBLISHER_CLASS = psoft.masonry.publisher.FilePublisher 

6. In the DB configuration section, don't forget to change DB password. 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}'')

   The plesk DB for the same version of plesk is psa. So you need to check it and if necessary use

   DB_URL = jdbc:mysql://localhost/psa

   instead of

   DB_URL = jdbc:mysql://localhost/plesk

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

   You might also want to check your mySQL configuration to access plesk.*, counter.*, guestbok.*, poll.* from localhost.