Revision history for ConfigStratoServer


Revision [831]

Last edited on 2017-02-10 19:57:05 by WojciechLisiewicz

Deletions:
----
===== some general actions =====
1) Make a simple dump of old mysql-databases
1) Config virtual hosts and domains
==== changes from native system ====
MyWikkaModifications

Revision [830]

Edited on 2017-02-10 19:56:51 by WojciechLisiewicz
Additions:
see now http://wdb.fh-sm.de/ITWissen

Deletions:
##mysqldump -u USERNAME -p DBNAME > myfile.sql## (on prompt - pwd!)
==== 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:
- 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

==== redirecting domains to server ====
== from strato ==
edit A-record in strato-settings of the **domain**

== from elsewhere ==
edit redirection IP

Revision [829]

Edited on 2017-02-10 19:47:59 by WojciechLisiewicz

Deletions:
==== 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##
##(apache)
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>##

Revision [828]

Edited on 2017-02-10 19:44:03 by WojciechLisiewicz

Deletions:
==== 2. Installing neccessary components - specially "lampp" ====
- apache wraz z mysql i php:
## apt-get install apache2 libapache2-mod-php5 php5 php5-mysql mysql-server##
więcej szczegółów na [[https://mysudo.wordpress.com/2014/07/27/lamp-unter-ubuntu-14-04-installieren-und-einrichten/comment-page-1/ 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)
==== 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 ====
see this site: https://help.ubuntu.com/community/phpMyAdmin

Revision [827]

Edited on 2017-02-10 19:09:54 by WojciechLisiewicz

Deletions:
==== 1. Links to external sources ====
- little bit security:
* [[http://www.pc-erfahrung.de/sonstiges/webdesignwebentwicklung/mysql-injection-und-datenmanipulation-verhindern.html against sql injection]]
*

Revision [826]

Edited on 2017-02-10 19:07:27 by WojciechLisiewicz
Additions:
*

Deletions:
* [[http://www.webmasterpro.de/coding/article/php-sicherheit-include-absichern.html securing includes in PHP]]

Revision [771]

Edited on 2015-03-28 19:58:32 by WojciechLisiewicz
Additions:
MyWikkaModifications

Deletions:
- wikka.php - Line 41 - commented out (##error_reporting(ALL)## too much!)
- localization.php - Line: ALL - transform gettext -> instead of old content - new ##function T_##
-> added files with translations -> ##lang/[each language]/uitxt.php## for PL and de (en ist default)
- templates/ -> added complete new template (for openlaw.pl -> openlaw); changed:
-> ##templates/[template name]/css/[template name].css##
-> ##templates/[template name]/footer.php##
-> ##templates/[template name]/header.php##
- added my crumbs
- design
- call of tree
-> ##libs/Wakka.class.php##
- added tree-support

Revision [770]

Edited on 2015-03-28 19:57:53 by WojciechLisiewicz
Additions:
- added my crumbs
- design
- call of tree
-> ##libs/Wakka.class.php##
- added tree-support

Revision [769]

Edited on 2015-03-27 17:59:00 by WojciechLisiewicz
Additions:
- templates/ -> added complete new template (for openlaw.pl -> openlaw); changed:
-> ##templates/[template name]/css/[template name].css##
-> ##templates/[template name]/footer.php##
-> ##templates/[template name]/header.php##

Revision [768]

Edited on 2015-03-27 16:31:18 by WojciechLisiewicz
Additions:
-> added files with translations -> ##lang/[each language]/uitxt.php## for PL and de (en ist default)

Revision [767]

Edited on 2015-03-27 12:30:31 by WojciechLisiewicz
Additions:
- localization.php - Line: ALL - transform gettext -> instead of old content - new ##function T_##

Deletions:
- localization.php - transform gettext -> instead of old content - new ##function T_##

Revision [766]

Edited on 2015-03-27 12:30:04 by WojciechLisiewicz
Additions:
- wikka.php - Line 41 - commented out (##error_reporting(ALL)## too much!)

Deletions:
- wikka.php - Line 41 - commented out (##error_reporting(ALL)## too much!

Revision [765]

Edited on 2015-03-27 12:29:54 by WojciechLisiewicz
Additions:
- wikka.php - Line 41 - commented out (##error_reporting(ALL)## too much!

Revision [764]

Edited on 2015-03-27 09:55:51 by WojciechLisiewicz
Additions:
==== changes from native system ====
- localization.php - transform gettext -> instead of old content - new ##function T_##

Revision [763]

Edited on 2015-03-22 17:24:29 by WojciechLisiewicz

Deletions:
==== other little tasks ====

Revision [762]

Edited on 2015-03-22 17:23:23 by WojciechLisiewicz

No Differences

Revision [761]

Edited on 2015-03-22 17:22:54 by WojciechLisiewicz

No Differences

Revision [760]

Edited on 2015-03-22 17:22:46 by WojciechLisiewicz
Additions:
1) Make a simple dump of old mysql-databases
1) Config virtual hosts and domains

Deletions:
1) Make a simple dump of old mysql-databases
1) Config virtual hosts and domains

Revision [759]

Edited on 2015-03-22 17:22:25 by WojciechLisiewicz
Additions:
==== other little tasks ====
1) Make a simple dump of old mysql-databases
##mysqldump -u USERNAME -p DBNAME > myfile.sql## (on prompt - pwd!)
1) Config virtual hosts and domains

Deletions:
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

Revision [749]

Edited on 2015-03-03 13:37:24 by WojciechLisiewicz
Additions:
##(apache)
</Directory>##

Deletions:
%%(apache)
</Directory>%%

Revision [748]

Edited on 2015-02-25 23:08:01 by WojciechLisiewicz
Additions:
==== 1. Links to external sources ====
==== 2. Installing neccessary components - specially "lampp" ====

Deletions:
==== Links to external sources ====
==== 1. Instalacja poszczególnych komponentów - w szczególności "lampp" ====

Revision [747]

Edited on 2015-02-25 23:07:08 by WojciechLisiewicz
Additions:
==== Links to external sources ====
- little bit security:
* [[http://www.pc-erfahrung.de/sonstiges/webdesignwebentwicklung/mysql-injection-und-datenmanipulation-verhindern.html against sql injection]]
* [[http://www.webmasterpro.de/coding/article/php-sicherheit-include-absichern.html securing includes in PHP]]

Revision [746]

Edited on 2015-02-25 18:14:54 by WojciechLisiewicz
Additions:
edit A-record in strato-settings of the **domain**

Deletions:
edit A-record in strato-settings of the domain

Revision [745]

Edited on 2015-02-25 18:14:41 by WojciechLisiewicz
Additions:
==== redirecting domains to server ====
== from strato ==
edit A-record in strato-settings of the domain
== from elsewhere ==
edit redirection IP

Revision [744]

Edited on 2015-02-25 17:35:15 by WojciechLisiewicz
Additions:
== read 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

Revision [743]

Edited on 2015-02-25 17:21:37 by WojciechLisiewicz
Additions:
%%(apache)

Deletions:
%%(xml)

Revision [742]

Edited on 2015-02-25 17:21:05 by WojciechLisiewicz
Additions:
%%(xml)

Deletions:
%%(perl)

Revision [741]

Edited on 2015-02-25 17:20:53 by WojciechLisiewicz
Additions:
Require valid-user

Deletions:
Require valid-user

Revision [740]

Edited on 2015-02-25 17:20:37 by WojciechLisiewicz
Additions:
%%(perl)
</Directory>%%



Deletions:
##
</Directory>

Revision [739]

Edited on 2015-02-25 17:16:44 by WojciechLisiewicz
Additions:
##
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>

Revision [738]

Edited on 2015-02-25 17:07:18 by WojciechLisiewicz
Additions:
----
===== some general actions =====
----
==== 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##

Revision [737]

Edited on 2015-02-25 16:59:46 by WojciechLisiewicz
Additions:
securing: -> add module "digest" to ##/etc/apache2/mods-enabled/## + edit ##/etc/phpmyadmin/apache.conf##:
##AuthType Digest
... ## (see there)

Revision [736]

Edited on 2015-02-25 16:56:09 by WojciechLisiewicz
Additions:
- phpmyadmin
##apt-get install phpmyadmin##
set password on install (etrowssap)
add a line in ##/etc/apache2/apache2.conf##:
##Include /etc/phpmyadmin/apache.conf##

Revision [735]

Edited on 2015-02-25 16:40:35 by WojciechLisiewicz
Additions:
- copy
- update to 1.3.6 - update script from wikka-project inkl. maintenance and DB-edit
- convert data (polish chars) - see below

Revision [734]

Edited on 2015-02-25 16:38:56 by WojciechLisiewicz
Additions:
1) standard wiki (old and new address is ##IP/wikka/##)
1) ???

Deletions:
1. standard wiki (old and new address is ##IP/wikka/##)
1.

Revision [733]

Edited on 2015-02-25 16:38:40 by WojciechLisiewicz
Additions:
==== 1. Instalacja poszczególnych komponentów - w szczególności "lampp" ====
więcej szczegółów na [[https://mysudo.wordpress.com/2014/07/27/lamp-unter-ubuntu-14-04-installieren-und-einrichten/comment-page-1/ tej stronce]]
2. Make a simple dump of old mysql-databases
##mysqldump -u USERNAME -p DBNAME > myfile.sql## (on prompt - pwd!)
==== apache - all services ====
1. standard wiki (old and new address is ##IP/wikka/##)
1.

Deletions:
==== 1. Instalacja poszczególnych komponentów - w szczególno?ci "lampp" ====
więcej szczegó?ów na [[https://mysudo.wordpress.com/2014/07/27/lamp-unter-ubuntu-14-04-installieren-und-einrichten/comment-page-1/ tej stronce]]
2. Make a dump of old mysql-databases
##mysqldump -u NUTZERNAME -p DATENBANKNAME > myfile.sql## (nach Aufforderung das Nutzerpasswort eingeben)
==== apache - poszczególne serwisy ====

Revision [732]

Edited on 2015-02-25 16:19:07 by WojciechLisiewicz
Additions:
== put converted DB - into an empty DB ==

Deletions:
== puttin converted DB - into an empty DB ==

Revision [731]

Edited on 2015-02-25 16:18:45 by WojciechLisiewicz
Additions:
==== converting DB with polish codepage ====
following commands were successful:
== DB dump ==
== converting itself ==
(wasn't good enough - probably was old text in windows codepage! this one was better:)
== puttin converted DB - into an empty DB ==

Deletions:
następujące komendy użyłem do konwertowania:
(to jeszcze nie prowadziło do najlepszych rezultatów - najwyraźniej pierwotnie strona kodowa była spod windows, a więc lepiej:
pozostaje wczytać przekonwertowaną bazę:

Revision [729]

Edited on 2015-02-25 01:42:57 by WojciechLisiewicz
Additions:
(to jeszcze nie prowadziło do najlepszych rezultatów - najwyraźniej pierwotnie strona kodowa była spod windows, a więc lepiej:

Deletions:
(to jeszcze nie prowadziło do najlepszych rezultatów - najwyraźniej pierwotnie strona kodowa byłą windows, a więc lepiej:

Revision [728]

Edited on 2015-02-25 01:42:39 by WojciechLisiewicz
Additions:

następujące komendy użyłem do konwertowania:

## 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 ##
(to jeszcze nie prowadziło do najlepszych rezultatów - najwyraźniej pierwotnie strona kodowa byłą windows, a więc lepiej:
##iconv -f Windows-1250 -t UTF-8 internalwiki_latin1.sql | sed -e 's/latin2/utf8/g' >internalwiki_utf8.sql##

pozostaje wczytać przekonwertowaną bazę:
##mysql -u root -p --default-character-set=utf8 wikiutf8 <internalwiki_utf8.sql ##

Revision [727]

Edited on 2015-02-25 01:02:52 by WojciechLisiewicz
Additions:
==== install and config php-my-admin ====
see this site: https://help.ubuntu.com/community/phpMyAdmin

Revision [726]

Edited on 2015-02-24 23:56:01 by WojciechLisiewicz
Additions:
==== 1. Instalacja poszczególnych komponentów - w szczególno?ci "lampp" ====
więcej szczegó?ów na [[https://mysudo.wordpress.com/2014/07/27/lamp-unter-ubuntu-14-04-installieren-und-einrichten/comment-page-1/ tej stronce]]

Deletions:
==== 1. Instalacja poszczególnych komponentów - w szczególności "lampp" ====
więcej szczegółów na [[https://mysudo.wordpress.com/2014/07/27/lamp-unter-ubuntu-14-04-installieren-und-einrichten/comment-page-1/ tej stronce]]

Revision [709]

Edited on 2015-02-24 23:27:32 by WojciechLisiewicz
Additions:
===== 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 [[https://mysudo.wordpress.com/2014/07/27/lamp-unter-ubuntu-14-04-installieren-und-einrichten/comment-page-1/ tej stronce]]
- dodatki do apache:
##apt-get install apache2-utils##
==== apache - poszczególne serwisy ====

Deletions:
==== config of new start server ====
1. install "lampp"
- ## sudo apt-get install apache2 libapache2-mod-php5 php5 php5-mysql mysql-server##
- Details see [[https://mysudo.wordpress.com/2014/07/27/lamp-unter-ubuntu-14-04-installieren-und-einrichten/comment-page-1/ this page]]
???

Revision [708]

Edited on 2015-02-24 18:12:45 by WojciechLisiewicz
Additions:
2. Make a dump of old mysql-databases
##mysqldump -u NUTZERNAME -p DATENBANKNAME > myfile.sql## (nach Aufforderung das Nutzerpasswort eingeben)

Revision [707]

The oldest known version of this page was created on 2015-02-24 18:03:25 by WojciechLisiewicz
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki