Hosting Cheat Sheet

0.REAME-Hosting-Cheat-Sheet.md

A collection of notes related to hosting

apache.md

Apache

Set up a new site

1. Copy a site from /etc/apache2/sites-available/ and edit it
2. Enable it by running sudo a2ensite mynewsite
3. Add your local dns settings: sudo vim /etc/hosts
4. Restart apache: sudo service apache2 restart

Error log

tail -f /var/log/apache2/error.log

mysql.md

Mysql

Restart

sudo service mysql restart
sudo service mysqld restart
sudo /etc/init.d/mysql restart

Change root password:

mysqladmin -u root password NEWPASSWORD
or:
mysqladmin -u root -p'oldpassword' password newpass

Mysql from the command line

http://www.cyberciti.biz/faq/how-do-i-access-mysql-server-from-the-shell-prompt-command-line/

#Syntax examples
mysql -u {mysql-user} -p {mysql-password} -h {mysql-server}
mysql -u vivek -h mysql10.nixcraft.in -p

show databases;

USE MYDB;
SHOW TABLES;

permissions.md

Permissions

NOTE: Apache should NOT own files it shouldn't have write access to

Check what user apaches is running as (expecting www-data):

ps -ef | grep apache

Takeaway for SilverStripe

• assets needs to be writeable by the web user

Xeera suggests 755 (with 7 for the owner - apache)

Yes files should be 644 and directories 755 by default.

http://unix.stackexchange.com/questions/21251/why-do-directories-need-the-executable-x-permission-to-be-opened

php.md

PHP Server management

Running PHP on the command line

php -r 'echo "Hello\n";'

Configuration

Which ini is loaded?

php --ini This should say "loaded confiuration file: xxx". If no config file is loaded, you might need to create one.

...or this:

php -i | grep 'Configuration File'

from http://stackoverflow.com/questions/2750580/how-to-find-the-php-ini-file-used-by-the-command-line

rewrites.md

Rewrites

www to non-www

RewriteEngine On
#rewriting www to non-www
RewriteCond %{HTTP_HOST} ^www\.(.*)$ [NC]
RewriteRule ^(.*)$ http://%1/$1 [R=301,L]

Force https

RewriteEngine On
#force https
RewriteCond %{HTTPS} off
RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI} [R=301,L]