Copy SiteSupra archive or files (if you already extracted SiteSupra archive) to your webserver's virtual directory.
If you are copying files over FTP, make sure you are using binary mode.
You should copy SiteSupra into the root of virtual directory. Otherwise, SiteSupra will not work.
However, if you cannot allocate a new virtual host name for running SiteSupra, you can assign another port number to existing host name.
Upgrading SiteSupra
If you already run SiteSupra and plan to upgrade to a newer version, please consult our support first. The normal practice is that the minor
version shifts (those within a major version, e.g. 3.0 to 3.1 shift) are just written over the existing files, and no special actions are
required. The major version shfits (e.g. 2.0 to 3.0) could require additional manual input, because of heavy feature changes. Please consult
the supplied documentation and SiteSupra Support.
Creating Database
After you have installed the required software and copied SiteSupra files,
the last step is creating a MySQL database and granting access rights to the database.
Starting from version 3.0 MySQL user should have LOCK rights to the database.
The database is repository that SiteSupra uses to store content.
Use one of sql scripts supplied with the SiteSupra archive you downloaded to create the database.
To create a database
To create a database you have to launch MySQL monitor. The monitor could be found under directory "bin" of MySQL installation.
Open shell or command prompt and type in the following line to start the monitor and hit the Enter key:
mysql -hhostname -uusername -ppassword
where username and password are login details to your MySQL server and hostname is either MySQL server IP address or hostname.
If you just installed MySQL server and it is located at the same computer you are starting the monitor from,
you may omit -hhostname, -uusername, and -ppassword. Right after monitor has been started type in the next command and hit enter:
create database demo31;
Then type in quit to leave the montior. Now it is time to load SiteSupra data into the MySQL databse you just created.
In the shell or command prompt run the following command:
mysql demo3 <demo30.sql
Troubleshooting
If you are unable to launch the monitor or load MySQL dump file into the database, please check the following:
make sure you are in "bin" directory of MySQL installation.
If you are not, then use change directory command (cd) to switch to the right location.
make sure demo30.sql is in "bin" directory of MySQL installation.
Dmitry Poltaryonok, dmitry dot poltaryonok at sitesupra dot com | 28.02.2006 21:02
Minimum access rights for SiteSupra are SELECT, INSERT, UPDATE, DELETE some blocks though may have embedded table creation script in conf file. So minimum access rights grant script is:
GRANT SELECT, INSERT, UPDATE, DELETE ON <supra_database>.* to <username>@<your_www_host> identified by <your_password>;
Where supra_database - database you created for SiteSupra, username - name of database user for SiteSupra's database, your_www_host - host where your web server which hosts SIteSupra is located (in most configurations localhost).
James Tidman, supra at tidmanfamily dot com | 23.02.2006 23:02
Site supra uses an account to access the database. What are the minimum access rights that account must have?
Would prefer more help than "See MySQL documentation". Most distributions provide some script. For example, phpMyAdmin provides the following:
GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'somepassword';
GRANT SELECT (
Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
Execute_priv, Repl_slave_priv, Repl_client_priv
) ON mysql.user TO 'pma'@'localhost';
GRANT SELECT ON mysql.db TO 'pma'@'localhost';
GRANT SELECT ON mysql.host TO 'pma'@'localhost';
GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
ON mysql.tables_priv TO 'pma'@'localhost';
Copying SiteSupra Files and Creating Database
