Konfiguracja nowego serwera:openlaw ressources

Revision [739]

This is an old revision of ConfigStratoServer made by WojciechLisiewicz on 2015-02-25 17:16:44.

Konfiguracja nowego serwera

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

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:

Include /etc/phpmyadmin/apache.conf

securing: -> add module "digest" to /etc/apache2/mods-enabled/ + edit /etc/phpmyadmin/apache.conf:

AuthType Digest ... (see there)

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

see this site: https://help.ubuntu.com/community/phpMyAdmin

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.sql

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.sql

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>

openlaw ressources : ConfigStratoServer

Revision [739]