Article ID: 6125, created on Mar 10, 2009, last review on May 9, 2014

  • Applies to:
  • SiteStudio

Symptoms

Parallels SiteStudio (standalone installation) failed to upgrade with a standard upgrade package. 

Note:

This article describes the upgrade procedure for casual SiteStudio for Linux installation (standalone or with standard integration with Ensim, Plesk or CPanel). All customized SiteStudio installation may need additional configuration. Contact Parallels support if you need to upgrade Parallels SiteStudio with a customization.

Resolution

To upgrade Parallels SiteStudio manually you need to install a newer version, configure it and move existed users' site to new installation.
To do that:

1. Download the installation package of latest Parallels SiteStudio

http://download.sitestudio.parallels.com/latest
Your actual SiteStudio license is needed.

2. Unpack it. (It will create a separate folder, e.g. /home/SiteStudio1.8)
3. Rename the previous installation and the new one:

cd /home/
mv SiteStudio SiteStudio.old && mv SiteStudio1.8 SiteStudio

4. Go to your old SiteStudio installation folder (e.g. cd /home/SiteStudio.old)
5. Find the necessary configuration parameters from current installation:
grep -e ^SMTP -e ^DB -e ^FROM_ADDRESS psoft_config/masonry.properties
You will see lines like those:


DB_DRIVER=org.postgresql.Driver
DB_URL=jdbc:postgresql://localhost/hosting
DB_USER = sitestudio
DB_PASSWORD = TR4xc53E
FROM_ADDRESS = webmaster@localhost
SMTP_HOST = 127.0.0.1

(store the output, later you will need DB name, login and password and
email settings which this command shows)

6. Stop existing SiteStudio:
./ss.sh stop
7. Go to the new installation folder  (e.g. cd /home/SiteStudio)
8. Run the configuration script and answer prompted questions:
./ss.sh setup
Below example (or default) answers are shown. Your actual values you got
on step 4, you need to use them during setup.

#############################################
#      SiteStudio Configuration program     #
#############################################
Please enter which DBMS you will use for SiteStudio
   1: PostgreSQL
   2: MySQL Server
   3: MS SQL Server
   4: JDBC compatible
   5: Other driver based
   6: PLESK integration
   7: PLESK v5 integration
   8: PLESK v6/v7 integration
   9: Ensim integration (MySQL)
  10: CPanel integration (MySQL)
Enter your choice [2]:
You entered [2]. Is it correct? [Y/n]:

Please enter SiteStudio port [8080]:
You entered [8080]. Is it correct? [Y/n]:

Please enter database server name (or IP) [localhost]:
You entered [localhost]. Is it correct? [Y/n]:

Please enter SiteStudio database name [hosting]:
You entered [hosting]. Is it correct? [Y/n]:

Please enter Database username [studio]: sitestudio
You entered [sitestudio]. Is it correct? [Y/n]:

Please enter Database password []:TR4xc53E
You entered [TR4xc53E]. Is it correct? [Y/n]:

Please enter if to turn on-line demo off (yes/no) [no]:
You entered [no]. Is it correct? [Y/n]:

Please enter if to turn plugins off (yes/no) [no]:
You entered [no]. Is it correct? [Y/n]:

Please enter database name for poll plugin [poll]:
You entered [poll]. Is it correct? [Y/n]:

Please enter database name for counter plugin [counter]:
You entered [counter]. Is it correct? [Y/n]:

Please enter database name for guestbook plugin [guestbook]:
You entered [guestbook]. Is it correct? [Y/n]:

Please enter skin name to use for SiteStudio interface by default
(classic, grey or green) [classic]:
You entered [classic]. Is it correct? [Y/n]:

Please enter SMTP host ip [127.0.0.1]:
You entered [127.0.0.1]. Is it correct? [Y/n]:

Please enter the e-mail address to use when sending e-mails
[webmaster@localhost]:
You entered [webmaster@localhost]. Is it correct? [Y/n]:

Note: the plugins database names may differ from default values. To find the actual values run:

grep ^DB_URL /home/SiteStudio.old/psoft_config/poll.properties |awk -F/ '{print $4}'
grep ^DB_URL /home/SiteStudio.old/psoft_config/counter.properties |awk -F/ '{print $4}'
grep ^DB_URL /home/SiteStudio.old/psoft_config/guestbook.properties |awk -F/ '{print $4}'

9. Move existing users' SiteStudio sites to new installation:

mv /home/SiteStudio.old/var/websites /home/SiteStudio/var/

10. Start SiteStudio:

/home/SiteStudio/ss.sh start

11. After you check your new installation you may remove
the /home/SiteStudio.old folder.

Note: if you use Oracle database it is needed to unpack
/home/SiteStudio/studio/WEB-INF/lib/classes12_01.zip or move old SiteStudio/studio/WEB-INF/lib/classes12_01.jar file to new location (/home/SiteStudio/studio/WEB-INF/lib/classes12_01.jar) to be able to load java classes needed for connection to Oracle database.

87ad276eb1af5ea9d1c20eee598cc0be 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF