Differences

This shows you the differences between two versions of the page.

--- linux:centos7 [2017/05/17 15:59] – created lamboringo
+++ linux:centos7 [2017/05/22 07:18] (current) – lamboringo
@@ Line 13: / Line 13: @@
 tools
-  yum -y install net-tools wget htop glances dkms autoconf.noarch automake.noarch gtk-murrine-engine.x86_64 gtk3-devel.x86_64 pkgconfig.x86_64
+  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
@@ Line 28: / Line 28: @@
   rpm -ivh epel-release-7-9.noarch.rpm
-===== system =====
+===== desktop =====
-liveinstall enable network, set hostname
+  yum groupinstall "Server with GUI"
+  yum -y install cinnamon*
+  ln -sf /lib/systemd/system/runlevel5.target /etc/systemd/system/default.target
+===== login =====
-install minimal
+  yum install lightdm
+  systemctl disable gdm.service
+  systemctl enable lightdm.service
+===== rpm =====
-  yum update
+  yum install system-config-firewall.noarch system-config-keyboard.noarch system-config-users.noarch
-disable selinux
+===== mysql/mariadb =====
-  reboot
+  yum install mariadb mariadb-server
+  systemctl start mariadb
+  systemctl enable mariadb
+  /usr/bin/mysql_secure_installation
-tools
+==== gsisitedb ====
-  yum -y install net-tools wget htop glances
+**old site**
-===== repos ====
+export existing user rights
+<code bash backup.db.users>
+#!/bin/bash
-  wget http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-9.noarch.rpm
+mygrants() {
-  rpm -ivh epel-release-7-9.noarch.rpm
+	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;}'
+}
-===== desktop =====
+mygrants --host=localhost --user=root --password=secret
+</code>
+  ./backup.db.users > /tmp/db.users.sql
-  yum groupinstall "Server with GUI"
+**new site**
-  yum -y install cinnamon*
-  ln -sf /lib/systemd/system/runlevel5.target /etc/systemd/system/default.target
+  * 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