version 1.3 beta

Installation Notes for Spine v1.3 beta

Requirements

Spine has very few dependencies. Generating SQL statements for users

Use the on-line tool to generate the correct SQL statements for the admin user. By default, version 1.3 beta does not include a default password. Visit http://spine.sourceforge.net/createuser.html to generate a custom SQL statement to create the admin account.

Installation on Debian

On Debian, install the following packages (for Apache 1.3x): Mysql Configuration (Installation only)

Development is based on mysql and postgresql.

See Using Mysql with Spine or Using Postgresql with Spine.

Open the mysql shell again: 
  bash# mysql spine -p
In the mysql shell, insert the generated SQL statement for the user account.

Perl Modules Installation (Including Upgrade)

There is a perl makefile included. Install the modules in the default perl location with: 
  bash# perl Makefile.PL
  bash# make
and as root (superuser) 
  bash# make install
Make sure you have Apache::Request installed. If you have questions about installing this, consult the administrator.

Upgrade from 1.2 installations

Resetting the password is the only update needed in the database. See Using Postgresql with Spine for instructions on how to this in Postgresql. Generate the User SQL statement, as described above. Open the mysql shell again 
  bash# mysql spine -p
In the mysql shell, insert the following statements: 
  
   delete from users where login = "admin";
   delete from session;
Also insert the generated SQL statement for the user account.

Apache Configuration

Edit your apache config file (by default httpd.conf) as follows : 
<IfModule mod_perl.c>
 # PerlModule Apache::DBI
 # Remove the # above if you have Apache::DBI installed and you wish to use it

  <Location /spine>
           SetHandler perl-script
           PerlHandler Apache::SPINE::Index
           PerlSetVar dbd mysql
           PerlSetVar dbname spine
           PerlSetVar dbuser user
           PerlSetVar dbpwd password
           PerlSetVar main index.html
           PerlSetVar webmaster 'John Doe'
           PerlSetVar sitename 'SPINE Example site' 
           PerlSetVar chroot /home/www/html
           PerlLogHandler Apache::SPINE::Log
  </Location>

</IfModule>
If your Apache configuration is set up to allow drop in configuration files, use 
apache-conf.incl
or 
apache2-conf.incl
as a template. On Debian installations, copy the configuration files in 
/etc/apache-perl/conf.d
If your Apache configuration is set up to allow drop in configuration files, use 
apache-conf.incl
or 
apache2-conf.incl
as a template. On Debian installations, copy the configuration files in 
/etc/apache-perl/conf.d

Restart the webserver, by default by running 
apachectl restart
On Debian installations, restart Apache with 
./etc/init.d/apache-perl restart
Loading Apache::DBI will improve the access speed to the database by pooling connections. Apache::DBI is not required but recommended. Set the virtual directory you want to use in the location tag. 
<Location /directory>
Existing directories and files will still work properly. By default, SPINE will use the mysql DBD driver (You still need this installed on your system - see Requirements list). If you wish to use a different DBD, fill in the appropriate value. 
PerlSetVar dbd Pg
If you doubt, ask your system administrator. You can define which database to use for the current virtual directory. 
PerlSetVar dbname spine
If you have multiple virtual directories, this setting can prevent record overlapping. 
  <Location /bob>
           ...
           PerlSetVar dbname bobdb
           PerlSetVar dbuser bob
            ...
  </Location>

  <Location /john>
           ...
           PerlSetVar dbname johndb
           PerlSetVar dbuser john
            ...
  </Location>
Just make sure you install the default database data first in both databases. Using the main variable, you can define which content will be used by default. 
PerlSetVar main index.html
SPINE defined some hardcoded macros. One of those tags is 
<?SPINE_Webmaster?>
This tag will be swapped with the value defined in the webmaster variable. 
PerlSetVar webmaster 'John Doe'
Another hardcoded macro is the sitename. The macro defined for this value is 

<?SPINE_Sitename?>
This tag will be swapped with the value defined in the sitename variable. 
PerlSetVar sitename 'SPINE Example site'
Copy Images
Copy the images from the images subdir to your main images directory (eg. /var/www/images)

Starting using Spine

Go to 
http://SERVERNAME/LOCATION/login.html
and use the credentials you specified earlier.