Revision [746]

This is an old revision of ConfigStratoServer made by WojciechLisiewicz on 2015-02-25 18:14:54.

 

Konfiguracja nowego serwera

hosting strato


1. Instalacja poszczególnych komponentów - w szczególności "lampp"



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

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

  1. ???

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

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

read more
See about converting:

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>




redirecting domains to server

from strato
edit A-record in strato-settings of the domain

from elsewhere
edit redirection IP


There are no comments on this page.
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki