QMT Wiki: Difference between revisions

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


On new machine
'''On new machine'''
Download latest MediaWiki
'''''If Apache, MySQL, PHP are not installed'''''
<pre>
# yum -y update
# cd /var/www
# yum -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm
# https://releases.wikimedia.org/mediawiki/1.41/mediawiki-1.41.0.tar.gz
# yum -y install https://rpms.remirepo.net/enterprise/remi-release-8.rpm
# tar zxvf mediawiki-1.41.0.tar.gz
# yum -y install yum-utils
# tee /root/sql.cnf<<EOF
# dnf module reset php
[client]
# dnf module install php:remi-8.1
user=root
# yum -y install php php-{mysql,pdo,gd,intl,cli,fpm,mysqlnd,zip,devel,gd,mbstring,curl,xml,pear,bcmath,json,opcache,redis,memcache}\
password='mypass'
                texlive
host=localhost
# yum -y install mysql mysql-server httpd
EOF
# systemctl enable --now mysqld httpd php-fpm && systemctl status mysqld httpd php-fpm
</pre>
# mysql_secure_installation <span style="color:red">(Remember password for credential file)</span>
Create MySQL DB, restore old database (last step) if upgrading...skip restore if this is a new wiki
# credfile=/root/sql.cnf
<pre>
# tee $credfile<<EOF
# mysqladmin --defaults-extra-file=$credfile create qmtwiki
[client]
# mysql --defaults-extra-file=$credfile -e "CREATE USER qmtwikiuser@localhost IDENTIFIED BY 'qmtwikipass'"  
user=root
# mysql --defaults-extra-file=$credfile -e "GRANT ALL PRIVILEGES ON qmtwiki.* TO qmtwikiuser@localhost"
password='mypass'
# mysql -u root -p qmtwiki < qmtwiki.sql
host=localhost
</pre>
EOF<br>
Configure Apache
'''''Create MySQL DB, restore old database (last step) if upgrading...skip restore if this is a new wiki'''''<br>
<pre>
# mysqladmin --defaults-extra-file=$credfile create qmtwiki
# tee /etc/httpd/sites-available/wiki.mydomain.com.conf<<EOF
# mysql --defaults-extra-file=$credfile -e "CREATE USER qmtwikiuser@localhost IDENTIFIED BY 'qmtwikipass'"  
<VirtualHost *:80>
# mysql --defaults-extra-file=$credfile -e "GRANT ALL PRIVILEGES ON qmtwiki.* TO qmtwikiuser@localhost"
     ServerName wiki.mydomain.com
# wget --user 'user' --password 'password' https://downloads.whitehorsetc.com/qmt/qmtwiki.sql *
     DocumentRoot /var/www/mediawiki-1.41.0
# mysql -u root -p qmtwiki < qmtwiki.sql<br>
'''''Configure Apache'''''<br>
# 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 />
     <Directory />
             Options FollowSymLinks
             Options FollowSymLinks
             AllowOverride None
             AllowOverride None
     </Directory>
     </Directory>
     ErrorLog /var/log/httpd/wiki.mydomain.com-error.log
     ErrorLog /var/log/httpd/wiki.qmailtoaster.org-error.log
     LogLevel debug
     LogLevel debug
     CustomLog /var/log/httpd/wiki.mydomain.com-access.log combined
     CustomLog /var/log/httpd/wiki.qmailtoaster.org-access.log combined
</VirtualHost>
</VirtualHost>
EOF
EOF
</pre>
# ln -s /etc/httpd/sites-available/wiki.qmailtoaster.org.conf /etc/httpd/sites-enabled/wiki.qmailtoaster.org.conf
Configure new, or upgrade old, wiki, and use db parameters specified above when prompted
# systemctl reload httpd<br>
<pre>
'''''Download latest MediaWiki'''''
# http://wiki.mydomain.com/mw-config
# cd /var/www
</pre>
# 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<br>
 
'''''Go to wiki'''''<br>
Point DNS your server
# http://wiki.qmailtoaster.org/
 
* Note: Credentials provided by Eric

Latest revision as of 21: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