SLES11 Installation TGZ

SLES11 Installation TGZ

This describes how to install Synthese on Suse Linux Entreprise 11, using a pre-compiled .tgz Synthese package.

Installation, part 1

• Install the package with the script:
  

  
  
  curl -s http://HOSTNAME/~build/synthese/lin/release/trunk/latest/install_synthese.py | python
  
  

• Check that a “mail” command is installed, and that sending mail works.

• configuration apache
  

• activation au boot
  chkconfig apache2 on
  

• TODO: document install of supervisor, apache, …

MySQL specific section (skip if using SQLite)

• Install mysql server
  

  
  
  zypper in mysql
  
  /etc/init.d/mysql start
  
  

• set root password
  

  
  
  /usr/bin/mysqladmin -u root password ‘root-password-here’
  
  

• Synthese needs larger packets. Edit /etc/my.cnf to raise the corresponding variable:
  

• Synthese needs large packets during data import (default was 1M)
  max_allowed_packet = 512M
  
  Restart mysql to apply this change.

• start at boot
  

  
  
  chkconfig mysql on
  
  

• Optionally, create a user and database for synthese, by running this SQL:
  

  
  
  CREATE USER ’synthese’@’localhost’ IDENTIFIED BY ‘synthese’;
  
  GRANT USAGE ON . TO ’synthese’@’localhost’ IDENTIFIED BY ‘synthese’ WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
  
  CREATE DATABASE IF NOT EXISTS `synthese` ;
  
  GRANT ALL PRIVILEGES ON `synthese`.* TO ’synthese’@’localhost’;
  
  - If using mysql server earlier than 5.1.6, user needs SUPER permission for creating the triggers:
  
  - GRANT SUPER ON . TO ’synthese’@’localhost’;
  
  

• Install the udf plugin

cp /opt/synthese/lib/mysql_udf_plugin/libsynthese_mysql_udf.so /usr/lib64/synthese_mysql_udf.so

mysql -u root -proot-password -h localhost mysql < /opt/synthese/share/synthese/mysql_udf_plugin/trigger_udf.sql

(Optional) phpMyAdmin

zypper in apache2-mod_php5 php5-mysql php5-mcrypt

cd /srv/www/htdocs

wget 'http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.5.1/phpMyAdmin-3.5.1-english.tar.bz2?r=http%3A%2F%2Fwww.phpmyadmin.net%2Fhome_page%2Fdownloads.php&ts=1339060796&use_mirror=freefr'

tar jxf phpMyAdmin-3*-english.tar.bz2
rm phpMyAdmin-3*-english.tar.bz2
mv phpMyAdmin-*-english phpmyadmin
/etc/init.d/apache2 restart