Contabo: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
| (5 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
| Zeile 31: | Zeile 31: | ||
cd /etc/mysql/conf.d/ | cd /etc/mysql/conf.d/ | ||
perl -pi -e 's/^#((default-)?character-set(-server)?\s*=\s*utf8)/$1/i;' mariadb.cnf | egrep "character-set|collation.server" /etc/mysql/conf.d/mariadb.cnf | ||
perl -pi -e 's/^#((default-)?character-set(-server)?\s*=\s*utf8)/$1/i;s/^#(collation[_-]server\s*=).*/$1 utf8_general_ci/i;' mariadb.cnf | |||
egrep "character-set|collation.server" /etc/mysql/conf.d/mariadb.cnf | |||
cd /etc/mysql | cd /etc/mysql | ||
perl -pi -e 's | grep datadir my.cnf | ||
perl -pi -e 's!^(datadir\s+=).*!$1 /home/mariadb!i;' my.cnf | |||
grep datadir my.cnf | grep datadir my.cnf | ||
test -d /home/mariadb || mkdir /home/mariadb | test -d /home/mariadb || mkdir /home/mariadb | ||
service mysql stop | |||
cp -a /var/lib/mysql /home/ | cp -a /var/lib/mysql /home/mariadb | ||
chown -R mysql.mysql /home/mariadb | |||
du /home/mariadb | |||
service mysql start | service mysql start | ||
Aktuelle Version vom 7. Januar 2014, 21:01 Uhr
Installation[Bearbeiten]
Ausgangspunkt: debian 7.2 (wheezzy)
apt-get install sudo git etckeeper sudo bzip2 zip unzip adduser hm # Eingabe Pw mkdir /home/hm/.ssh cat >/home/hm/.ssh/authorized_keys <<EOS ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQC/Z4tMh9xFVKL5XGx/9KjNt4OGzrk5MmOtUnLexAX3bjQ4yqYaj5zNvjQ1GaTbVG8bOCcstueKkvnCJ/iEYfoCwc9eeYv8QbdIH4BJPLeV0wO5D6wTAkZSqkyCAI7yFWYEr1Yy1vpKo8vZwcXtDGCQfWsG0CIZDzQCGHrSkdgNNIzjjEpsz4iAgYS5n044hDBW4YNaH7UWs/btSCyfWg00wza7FLZY5tz2sA9KB3NprFrJSPr/LyNhFv8LU+E7wi8eBZyx0rpbak27AYL1IHk7kODfhZSJo6eLacHA8RIftuZL8WkQzdNDnrEn09rg593stn/hm0blnUDBCr8AEZIj hm@ant EOS # Als User hm: ssh-keygen -t rsa # Eingabe
nginx[Bearbeiten]
apt-get install nginx
mariadb[Bearbeiten]
apt-get install python-software-properties apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db add-apt-repository 'deb http://mirror.netcologne.de/mariadb/repo/10.0/debian wheezy main' apt-get update apt-get install mariadb-server mariadb-client mariadb-common cd /etc/mysql/conf.d/ egrep "character-set|collation.server" /etc/mysql/conf.d/mariadb.cnf perl -pi -e 's/^#((default-)?character-set(-server)?\s*=\s*utf8)/$1/i;s/^#(collation[_-]server\s*=).*/$1 utf8_general_ci/i;' mariadb.cnf egrep "character-set|collation.server" /etc/mysql/conf.d/mariadb.cnf cd /etc/mysql grep datadir my.cnf perl -pi -e 's!^(datadir\s+=).*!$1 /home/mariadb!i;' my.cnf grep datadir my.cnf test -d /home/mariadb || mkdir /home/mariadb service mysql stop cp -a /var/lib/mysql /home/mariadb chown -R mysql.mysql /home/mariadb du /home/mariadb service mysql start
PHP[Bearbeiten]
apt-get install php5 php5-fpm php5-mysql php5-gd imagemagick perl -pi -e 's/#cgi.fix_pathinfo=1/cgi.fix_pathinfo=0/;' /etc/php5/fpm/php.ini grep cgi.fix /etc/php5/fpm/php.ini service php5-fpm restart
Weitere Einstellungen in/etc/php5/fpm/php.ini:
- post_max_size = 500M
- upload_max_filesize = 500M
- sendmail_path = "/usr/sbin/sendmail -t -i -f php@ip-12-220-241-80.static.contabo.net"