Revision [745]
This is an old revision of ConfigStratoServer made by WojciechLisiewicz on 2015-02-25 18:14:41.
Konfiguracja nowego serwera
hosting strato
1. Instalacja poszczególnych komponentów - w szczególności "lampp"
- apache wraz z mysql i php:
apt-get install apache2 libapache2-mod-php5 php5 php5-mysql mysql-server
więcej szczegółów na tej stronce
więcej szczegółów na tej stronce
- dodatki do apache:
apt-get install apache2-utils
- phpmyadmin
apt-get install phpmyadmin
set password on install (etrowssap)
add a line in /etc/apache2/apache2.conf:
set password on install (etrowssap)
add a line in /etc/apache2/apache2.conf:
Include /etc/phpmyadmin/apache.conf
securing: -> add module "digest" to /etc/apache2/mods-enabled/ + edit /etc/phpmyadmin/apache.conf:2. Make a simple dump of old mysql-databases
mysqldump -u USERNAME -p DBNAME > myfile.sql (on prompt - pwd!)
2. Config virtual hosts and domains
apache - all services
- standard wiki (old and new address is IP/wikka/)
- copy
- update to 1.3.6 - update script from wikka-project inkl. maintenance and DB-edit
- convert data (polish chars) - see below
- ???
install and config php-my-admin
some general actions
converting DB with polish codepage
following commands were successful:DB dump
mysqldump -u root -p --default-character-set=latin1 --skip-set-charset internalwiki > /storage/db_dumps/internalwiki_latin1.sqlconverting itself
iconv -f ISO-8859-2 -t UTF-8 internalwiki_latin1.sql | sed -e 's/latin2/utf8/g' >internalwiki_utf8.sql(wasn't good enough - probably was old text in windows codepage! this one was better:)
iconv -f Windows-1250 -t UTF-8 internalwiki_latin1.sql | sed -e 's/latin2/utf8/g' >internalwiki_utf8.sql
put converted DB - into an empty DB
mysql -u root -p --default-character-set=utf8 wikiutf8 <internalwiki_utf8.sqlread more
See about converting:- http://www.udo-telaar.de/iconv-und-zeichensatz-kodierungen/
- http://www.seleos.de/blog/zeichensalat-vermeiden-mysql-auf-utf-8-umstellen.html
- http://www.html-info.eu/php/php-als-script-sprache/item/zeichensatz-latin1-oder-unicode-utf-8.html
securing areas on apache
needed modules
add symlink to "auth_digest.load" in /etc/apache2/mods-enabled/config virtual hosts
edit /etc/apache2/sites-enabled/XXXX.conf Alias /path-in-browser /path/on/localfilesystem
<Directory /path/on/localfilesystem>
Options FollowSymLinks
DirectoryIndex index.php
<IfModule mod_authn_file.c>
AuthType Digest
AuthName "your_realm"
AuthUserFile /path/to/filewithdigestpwd
</IfModule>
Require valid-user
</Directory>
<Directory /path/on/localfilesystem>
Options FollowSymLinks
DirectoryIndex index.php
<IfModule mod_authn_file.c>
AuthType Digest
AuthName "your_realm"
AuthUserFile /path/to/filewithdigestpwd
</IfModule>
Require valid-user
</Directory>
