# debian 8

apt-get install nano iputils-ping wget unattended-upgrades nano apache2 rsync php5 php-pear php5-gd imagemagick php5-imagick mysql-server php5-mysql tidy unzip pngnq optipng gifsicle php5-curl htop php5-curl ca-certificates libjpeg-progs subversion curl php5 libapache2-mod-php5 php5-mcrypt -y

# debian 9

apt-get install nano iputils-ping wget unattended-upgrades nano apache2 rsync php php-pear php-gd imagemagick php-imagick mysql-server php-mysql tidy unzip pngnq optipng gifsicle php-curl htop ca-certificates libjpeg-progs subversion curl libapache2-mod-php php-mcrypt php7.0-mbstring jpegoptim php7.0-sqlite -y

# debian 10

apt-get install nano iputils-ping wget unattended-upgrades nano apache2 rsync php php-pear php-gd imagemagick php-imagick mariadb-server php-mysql tidy unzip pngnq optipng gifsicle php-curl htop ca-certificates libjpeg-progs subversion curl libapache2-mod-php jpegoptim php7.3-sqlite php-zip php-mbstring curl libcurl4 libcurl3-dev git -y

#Mod pagespeed (normally not needed)
wget https://dl-ssl.google.com/dl/linux/direct/mod-pagespeed-stable_current_amd64.deb
dpkg -i mod-pagespeed-*.deb
apt-get -f install

# continue

a2enmod expires
a2enmod headers
a2enmod rewrite
a2enmod ssl
a2ensite default-ssl
service apache2 restart

 enable htaccess:

add this block to end of /etc/apache2/sites-enabled/* (both http and https) INSIDE VHOSTS SECTION.
nano /etc/apache2/sites-enabled/*
 
 <Directory /var/www/html>
 Options Indexes FollowSymLinks MultiViews
 AllowOverride All
 Order allow,deny
 allow from all
 # Uncomment this directive is you want to see apache2's
 # default start page (in /apache2-default) when you go to /
 #RedirectMatch ^/$ /apache2-default/
 </Directory>

service apache2 restart

#install mysql
#remember to change userbnane abd pw
mysql_secure_installation
mysql -u root
#create db and user
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE databasename;
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;

Spip Install Method 2

USING SPIP LOADER:

cd /var/www/html/
rm index.html 
wget http://www.spip.net/spip-dev/INSTALL/spip_loader.php
chown -R www-data:www-data /var/www/html
chmod 777 /var/www/html/

@now open website at https://ip:port/spip_loader.php

I use qemu to virtualize appliances on my servers, and I access them over SSH. Allthough SSH supports streaming X windows so it is possible to fire up a graphical install, it is not so convenient as the connection may drop and cancel the install.

A convenient workaround is to use qemu’s curses/nographic interface, where instead of a display, a terminal is attached to the virtual machine. That way you can install and use your virtual machines directly in the SSH terminal.

To install a new system from scratch, simply define the -hda, -cdrom and -boot flags, and add the -nographic option:
qemu-system-x86_64  -hda /dev/sdc1 -m 1500 --enable-kvm -nographic -cdrom images/debian-stable.iso -boot d

The Debian installer supports headless mode, but we have to add two settings at the boot prompt to make it work with curses/nographic.

1. Fire up qemu with the command above. Wait a few seconds, the screen will turn black after loading syslinux. Hit ESC, and enter:
install fb=none vga=normal

and follow the install. Voilà, you’re installing your VM in qemu directly over ssh.

Tip: To prevent losing the install if the network connection is lost, run the commands in a screen terminal.

Recently I was deploying a service that made use of Linux’s IPTABLES feature, but this time in an LXC container. LXC containers provide an extremely lightweight virtualization technology and a simple way to separate environments.

When loading IPTABLES rules in the container I encountered the following error:

ERROR: initcaps
[Errno 2] modprobe: ERROR: ../libkmod/libkmod.c:556 kmod_search_moddep() could not open moddep file '/lib/modules/3.16.0-4-amd64/modules.dep.bin'
ip6tables v1.4.21: can't initialize ip6tables table `filter': Table does not exist (do you need to insmod?)
Perhaps ip6tables or your kernel needs to be upgraded.

This was due to the fact that on the host, the ip6table_filter module was not loaded. Usually, the iptables command will by itself load the module when needed, but LXC shares the kernel of the host system and a container is restricted from loading modules into the host’s kernel.

The solution is to simply load the kernel module on the host:

# on debian jessie, as root:
modprobe ip6table_filter

After that the container will be able to make use of the new kernel module.