QMT Wiki: Difference between revisions

From QmailToaster
Jump to navigation Jump to search
No edit summary
No edit summary
 
(12 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[Main_Page#QMT_Wiki|Back]]
  '''On old machine'''
  '''On old machine'''
  '''''Backup old QMT Wiki'''''
  '''''Backup old QMT Wiki'''''
  # mysqldump -uqmtwikiuser -pqmtwikipass -hlocalhost qmtwiki --single-transaction > qmtwiki.sql
  # mysqldump -u root -p qmtwiki  > qmtwiki.sql


  '''On new machine'''
  '''On new machine'''
Line 15: Line 16:
  # yum -y install mysql mysql-server httpd
  # yum -y install mysql mysql-server httpd
  # systemctl enable --now mysqld httpd php-fpm && systemctl status mysqld httpd php-fpm
  # systemctl enable --now mysqld httpd php-fpm && systemctl status mysqld httpd php-fpm
  # mysql_secure_installation <style "color:red">(Remember password for credential file)</style>
  # mysql_secure_installation <span style="color:red">(Remember password for credential file)</span>
  # credfile=/root/sql.cnf
  # credfile=/root/sql.cnf
  # tee $credfile<<EOF
  # tee $credfile<<EOF
Line 22: Line 23:
  password='mypass'
  password='mypass'
  host=localhost
  host=localhost
  EOF
  EOF<br>
# MYSQLPW=`cat /root/sql.cnf | grep password | sed 's/password=//'`<br>
  '''''Create MySQL DB, restore old database (last step) if upgrading...skip restore if this is a new wiki'''''<br>
  '''''Create MySQL DB, restore old database (last step) if upgrading...skip restore if this is a new wiki'''''<br>
  # mysqladmin --defaults-extra-file=$credfile create qmtwiki
  # mysqladmin --defaults-extra-file=$credfile create qmtwiki
  # mysql --defaults-extra-file=$credfile -e "CREATE USER qmtwikiuser@localhost IDENTIFIED BY 'qmtwikipass'"  
  # mysql --defaults-extra-file=$credfile -e "CREATE USER qmtwikiuser@localhost IDENTIFIED BY 'qmtwikipass'"  
  # mysql --defaults-extra-file=$credfile -e "GRANT ALL PRIVILEGES ON qmtwiki.* TO qmtwikiuser@localhost"
  # mysql --defaults-extra-file=$credfile -e "GRANT ALL PRIVILEGES ON qmtwiki.* TO qmtwikiuser@localhost"
  # wget 'url'/qmtwiki.sql (Provided by Eric)
  # wget --user 'user' --password 'password' https://downloads.whitehorsetc.com/qmt/qmtwiki.sql *
  # mysql -u root -p qmtwiki < qmtwiki.sql<br>
  # mysql -u root -p qmtwiki < qmtwiki.sql<br>
  '''''Configure Apache'''''<br>
  '''''Configure Apache'''''<br>
  # tee /etc/httpd/sites-available/wiki.mydomain.com.conf<<EOF
  # tee /etc/httpd/sites-available/wiki.qmailtoaster.org.conf<<EOF
  <VirtualHost *:80>
  <VirtualHost *:80>
     ServerName wiki.qmailtoaster.org
     ServerName wiki.qmailtoaster.org
Line 56: Line 56:
  # git -C wiki.qmailtoaster.org/extensions clone https://gerrit.wikimedia.org/r/mediawiki/extensions/Tabs
  # git -C wiki.qmailtoaster.org/extensions clone https://gerrit.wikimedia.org/r/mediawiki/extensions/Tabs
  # git -C wiki.qmailtoaster.org/extensions clone https://gerrit.wikimedia.org/r/mediawiki/extensions/HeaderTabs
  # git -C wiki.qmailtoaster.org/extensions clone https://gerrit.wikimedia.org/r/mediawiki/extensions/HeaderTabs
  # wget -P wiki.qmailtoaster.org 'url'/LocalSettings.php (Provided by Eric)
  # wget--user 'user' --password 'password' -P wiki.qmailtoaster.org 'https://downloads.whitehorsetc.com/qmt/LocalSettings.php *
  # wget -P wiki.qmailtoaster.org/resources/assets 'url'/qtwiki-old.png (Provided by Eric)
  # wget--user 'user' --password 'password' -P wiki.qmailtoaster.org/resources/assets https://downloads.whitehorsetc.com/qmt/qtwiki-old.png *
  # chown apache:apache -R mediawiki-1.41.0<br>
  # chown apache:apache -R mediawiki-1.41.0<br>


  '''''Go to wiki'''''<br>
  '''''Go to wiki'''''<br>
  Redirect DNS to point to your server
  Point DNS your server
  # http://wiki.qmailtoaster.org/
  # http://wiki.qmailtoaster.org/
* Note: Credentials provided by Eric

Latest revision as of 20:27, 24 April 2024

Back

On old machine
Backup old QMT Wiki
# mysqldump -u root -p qmtwiki  > qmtwiki.sql
On new machine
If Apache, MySQL, PHP are not installed
# yum -y update
# yum -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm
# yum -y install https://rpms.remirepo.net/enterprise/remi-release-8.rpm
# yum -y install yum-utils
# dnf module reset php
# dnf module install php:remi-8.1
# yum -y install php php-{mysql,pdo,gd,intl,cli,fpm,mysqlnd,zip,devel,gd,mbstring,curl,xml,pear,bcmath,json,opcache,redis,memcache}\
                texlive
# yum -y install mysql mysql-server httpd
# systemctl enable --now mysqld httpd php-fpm && systemctl status mysqld httpd php-fpm
# mysql_secure_installation (Remember password for credential file)
# credfile=/root/sql.cnf
# tee $credfile<<EOF
[client]
user=root
password='mypass'
host=localhost
EOF
Create MySQL DB, restore old database (last step) if upgrading...skip restore if this is a new wiki
# mysqladmin --defaults-extra-file=$credfile create qmtwiki # mysql --defaults-extra-file=$credfile -e "CREATE USER qmtwikiuser@localhost IDENTIFIED BY 'qmtwikipass'" # mysql --defaults-extra-file=$credfile -e "GRANT ALL PRIVILEGES ON qmtwiki.* TO qmtwikiuser@localhost" # wget --user 'user' --password 'password' https://downloads.whitehorsetc.com/qmt/qmtwiki.sql * # mysql -u root -p qmtwiki < qmtwiki.sql
Configure Apache
# tee /etc/httpd/sites-available/wiki.qmailtoaster.org.conf<<EOF <VirtualHost *:80> ServerName wiki.qmailtoaster.org DocumentRoot /var/www/wiki.qmailtoaster.org <IfModule dir_module> DirectoryIndex index.php </IfModule> <Directory /> Options FollowSymLinks AllowOverride None </Directory> ErrorLog /var/log/httpd/wiki.qmailtoaster.org-error.log LogLevel debug CustomLog /var/log/httpd/wiki.qmailtoaster.org-access.log combined </VirtualHost> EOF # ln -s /etc/httpd/sites-available/wiki.qmailtoaster.org.conf /etc/httpd/sites-enabled/wiki.qmailtoaster.org.conf # systemctl reload httpd
Download latest MediaWiki # cd /var/www # wget https://releases.wikimedia.org/mediawiki/1.41/mediawiki-1.41.0.tar.gz # tar zxvf mediawiki-1.41.0.tar.gz # ln -s mediawiki-1.41.0 wiki.qmailtoaster.org # git -C wiki.qmailtoaster.org/extensions clone https://gerrit.wikimedia.org/r/mediawiki/extensions/Tabs # git -C wiki.qmailtoaster.org/extensions clone https://gerrit.wikimedia.org/r/mediawiki/extensions/HeaderTabs # wget--user 'user' --password 'password' -P wiki.qmailtoaster.org 'https://downloads.whitehorsetc.com/qmt/LocalSettings.php * # wget--user 'user' --password 'password' -P wiki.qmailtoaster.org/resources/assets https://downloads.whitehorsetc.com/qmt/qtwiki-old.png * # chown apache:apache -R mediawiki-1.41.0
Go to wiki
Point DNS your server # http://wiki.qmailtoaster.org/
* Note: Credentials provided by Eric