====== Installation ======
===== system =====

liveinstall enable network, set hostname

install minimal

  yum update

disable selinux

  reboot

tools
  yum -y install net-tools wget htop glances dkms autoconf.noarch automake.noarch gtk-murrine-engine.x86_64 gtk3-devel.x86_64 geany geany-plugins-common geany-plugins-spellcheck pkgconfig.x86_64
  yum groupinstall "Development Tools"
   git clone https://github.com/horst3180/arc-theme --depth 1 && cd arc-theme
   ./autogen.sh --prefix=/usr
   make install

environment
/etc/profile.d/custom.sh
  alias l='ls -lh'

===== repos ====

  wget http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-9.noarch.rpm
  rpm -ivh epel-release-7-9.noarch.rpm

===== desktop =====

  yum groupinstall "Server with GUI"
  yum -y install cinnamon*
  ln -sf /lib/systemd/system/runlevel5.target /etc/systemd/system/default.target
 
===== login =====

  yum install lightdm
  systemctl disable gdm.service
  systemctl enable lightdm.service
  
===== rpm =====

  yum install system-config-firewall.noarch system-config-keyboard.noarch system-config-users.noarch 

===== mysql/mariadb =====

  yum install mariadb mariadb-server
  systemctl start mariadb
  systemctl enable mariadb
  /usr/bin/mysql_secure_installation

==== gsisitedb ==== 
**old site**

export existing user rights
<code bash backup.db.users>
#!/bin/bash

mygrants() {
	mysql -B -N $@ -e "SELECT DISTINCT CONCAT(
	'SHOW GRANTS FOR \'', user, '\'@\'', host, '\';'
	) AS query FROM mysql.user" | \
	mysql -r $@ | \
	sed 's/\(GRANT .*\)/\1;/;s/^\(Grants for .*\)/## \1 ##/;/##/{x;p;x;}'
}

mygrants --host=localhost --user=root --password=secret
</code>
  ./backup.db.users > /tmp/db.users.sql

**new site**

  * copy db export and import in mysql
  * grant gsisiteuser in phpMyAdmin
  * rsync  --archive --itemize-changes --stats -h -e ssh user@newsite:/var/www/html/site/ site/


===== httpd, PHP =====

  yum install httpd httpd-tools yum install mod_ssl
  yum install php phpMyAdmin
  systemctl enable httpd
  systemctl start httpd

====== to do ======

  * mysql migration
  * postgresql migration
  * http
  * ABCdb, silico wiki, master bioinfo, mobyle
  * MLST ?
  * subversion svn, git