QMT Wiki: Difference between revisions

From QmailToaster
Jump to navigation Jump to search
No edit summary
No edit summary
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
<pre>
On old machine
Backup old QMT Wiki
# /usr/bin/mysqldump -uqmtwikiuser -pqmtwikipass -hlocalhost qmtwiki --single-transaction  > qmtwiki.sql
On new machine
Download latest MediaWiki
Download latest MediaWiki
<pre>
 
# cd /var/www
# cd /var/www
# https://releases.wikimedia.org/mediawiki/1.41/mediawiki-1.41.0.tar.gz
# https://releases.wikimedia.org/mediawiki/1.41/mediawiki-1.41.0.tar.gz
Line 13: Line 19:
Create MySQL DB, restore old database (last step) if upgrading...skip restore if this is a new wiki
Create MySQL DB, restore old database (last step) if upgrading...skip restore if this is a new wiki
<pre>
<pre>
# mysqladmin --defaults-extra-file=$credfile create mediawiki
# mysqladmin --defaults-extra-file=$credfile create qmtwiki
# mysql --defaults-extra-file=$credfile -e "CREATE USER mediawiki@localhost IDENTIFIED BY 'p4ssw3rd'"  
# mysql --defaults-extra-file=$credfile -e "CREATE USER qmtwikiuser@localhost IDENTIFIED BY 'qmtwikipass'"  
# mysql --defaults-extra-file=$credfile -e "GRANT ALL PRIVILEGES ON mediawiki.* TO mediawiki@localhost"
# mysql --defaults-extra-file=$credfile -e "GRANT ALL PRIVILEGES ON qmtwiki.* TO qmtwikiuser@localhost"
# mysql -u root -p mediawiki < mediawiki.sql
# mysql -u root -p qmtwiki < qmtwiki.sql
</pre>
</pre>
Configure Apache
Configure Apache

Revision as of 16:55, 26 March 2024

On old machine
Backup old QMT Wiki
# /usr/bin/mysqldump -uqmtwikiuser -pqmtwikipass -hlocalhost qmtwiki --single-transaction  > qmtwiki.sql

On new machine
Download latest MediaWiki

# cd /var/www
# https://releases.wikimedia.org/mediawiki/1.41/mediawiki-1.41.0.tar.gz
# tar zxvf mediawiki-1.41.0.tar.gz
# tee /root/sql.cnf<<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"
# mysql -u root -p qmtwiki < qmtwiki.sql

Configure Apache

# tee /etc/httpd/sites-available/wiki.mydomain.com.conf<<EOF
<VirtualHost *:80>
     ServerName wiki.mydomain.com
     DocumentRoot /var/www/mediawiki-1.41.0
     <Directory />
             Options FollowSymLinks
             AllowOverride None
     </Directory>
     ErrorLog /var/log/httpd/wiki.mydomain.com-error.log
     LogLevel debug
     CustomLog /var/log/httpd/wiki.mydomain.com-access.log combined
</VirtualHost>
EOF

Configure new, or upgrade old, wiki, and use db parameters specified above when prompted

# http://wiki.mydomain.com/mw-config