Difference between revisions of "User:Andr3w"

From SQLZOO
Jump to navigation Jump to search
Line 15: Line 15:
 
  #Set root password for mysql
 
  #Set root password for mysql
 
  sudo mysql_secure_installation
 
  sudo mysql_secure_installation
 +
sudo apt-get install php-fpm php-mysql
 +
sudo apt-get install php-fpm php-mysql
 +
#Uncomment the fastcgi-pass bis for php in /etc/nginx/sites-enabled/default
 +
sudo mkdir /var/www/html/sqlzoo
 +
sudo chown andrew.andrew /var/www/html/sqlzoo
 +
wget https://releases.wikimedia.org/mediawiki/1.34/mediawiki-1.34.0.tar.gz
 +
tar xvf mediawiki-1.34.0.tar.gz
 +
mv mediawiki-1.34.0 /var/www/html/sqlzoo/w
 +
cd /var/www/html/sqlzoo/w
 +
#On the existing site create mysql backup - media wiki and user attempts
 +
# mysqldump --all-databases -u root -p > sqlzoo-all.sql
 +
scp -C sqlzoo.net:sqlzoo-mediawiki/sqlzoo-all.sql .
 +
mysql -u root -p < sqlzoo-all.sql
  
 
==Notes on squid==
 
==Notes on squid==

Revision as of 17:14, 13 January 2020

Pages that control everything

Language Test Page

My Pages

Setting up a server - nginx

sudo apt-get build-essentialsudo apt-get install nginx
sudo apt-get install mysql.server
#Set root password for mysql
sudo mysql_secure_installation
sudo apt-get install php-fpm php-mysql
sudo apt-get install php-fpm php-mysql
#Uncomment the fastcgi-pass bis for php in /etc/nginx/sites-enabled/default
sudo mkdir /var/www/html/sqlzoo
sudo chown andrew.andrew /var/www/html/sqlzoo
wget https://releases.wikimedia.org/mediawiki/1.34/mediawiki-1.34.0.tar.gz
tar xvf mediawiki-1.34.0.tar.gz
mv mediawiki-1.34.0 /var/www/html/sqlzoo/w
cd /var/www/html/sqlzoo/w
#On the existing site create mysql backup - media wiki and user attempts
# mysqldump --all-databases -u root -p > sqlzoo-all.sql
scp -C sqlzoo.net:sqlzoo-mediawiki/sqlzoo-all.sql .
mysql -u root -p < sqlzoo-all.sql

Notes on squid

/etc/squid/squid.conf

acl web_ports port 80
acl manager proto cache_object
http_access allow web_ports
http_access allow manager localhost
http_access deny manager
acl purge method PURGE
http_access allow purge localhost
http_access deny purge
http_access deny all
http_port 146.176.166.2:80 accel defaultsite=sqlzoo.net vhost
cache_peer 127.0.0.1 parent 80 0 originserver no-digest
#cache_peer 146.176.166.58 parent 80 0 originserver no-digest
cache_dir ufs /var/log/squid/cache 10000 16 256

Changes to /etc/httpd/conf/httpd.conf

LogFormat "%{X-Forwarded-for}i %l %T %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %T/%D" squided
CustomLog "logs/access_log" squided
SetEnv force-no-vary