Differences

This shows you the differences between two versions of the page.

--- debian:other-debian:usenet-indexer-debian [2017/11/15 12:45] – michael
+++ debian:other-debian:usenet-indexer-debian [2017/11/17 10:28] – michael
@@ Line 70: / Line 70: @@
 # sed -i "s/ServerTokens OS/ServerTokens Prod/" /etc/apache2/conf-available/security.conf
 # sed -i "s/ServerSignature On/ServerSignature Off/" /etc/apache2/conf-available/security.conf
+# vim /etc/apache2/apache2.conf     #->> change at "<Directory /var/www/>... AllowOverride None" to -> AllowOverride All
 </code>
@@ Line 102: / Line 104: @@
 <code>
-# sed -i "s/max_execution_time = 30/max_execution_time = 120/" /etc/php/7.0/cli/php.ini
+# sed -i "s/max_execution_time = 30/max_execution_time = 300/" /etc/php/7.0/cli/php.ini
 # sed -i "s/;date.timezone =/date.timezone = Europe\/Zurich/" /etc/php/7.0/cli/php.ini
 </code>
@@ Line 108: / Line 110: @@
 <wrap em>Now we have to do the same for our php7.0-fpm Configuration:</wrap>
 <code>
-# sed -i "s/max_execution_time = 30/max_execution_time = 120/" /etc/php/7.0/fpm/php.ini
+# sed -i "s/max_execution_time = 30/max_execution_time = 300/" /etc/php/7.0/fpm/php.ini
-# sed -i "s/memory_limit = 128M/memory_limit = 1024M/" /etc/php/7.0/fpm/php.ini
+# sed -i "s/post_max_size = 8M/post_max_size = 64M/" /etc/php/7.0/fpm/php.ini
+# sed -i "s/memory_limit = 128M/memory_limit = 2048M/" /etc/php/7.0/fpm/php.ini
 # sed -i "s/;date.timezone =/date.timezone = Europe\/Zurich/" /etc/php/7.0/fpm/php.ini
 </code>
@@ Line 135: / Line 138: @@
 # configurations by nZEDb
 innodb_file_per_table = 1
-max_allowed_packet = 16M
+max_allowed_packet = 128M
 group_concat_max_len = 8192
 </sxh>
@@ Line 174: / Line 177: @@
 MariaDB [(none)]> GRANT ALL PRIVILEGES ON nzedb.* TO 'nzedbuser'@'localhost' IDENTIFIED BY 'YOUR-PASSWORD';
 MariaDB [(none)]> GRANT FILE ON *.* TO 'nzedbuser'@'localhost';
+MariaDB [(none)]> GRANT RELOAD ON *.* TO nzedbuser@'localhost';   #  (used when optimising DB)
 MariaDB [(none)]> FLUSH PRIVILEGES;
 MariaDB [(none)]> quit</code>
@@ Line 243: / Line 247: @@
 <WRAP center box 100%>
 ==== Tmux Version 2 installieren ====
-  * https://forums.nzedb.com/index.php?topic=2464.0
+<code># apt-get install libevent-dev build-essential git autotools-dev automake pkg-config ncurses-dev
+# apt-get remove tmux
+# cd /tmp/
+# git clone https://github.com/tmux/tmux.git --branch 2.0 --single-branch
+# cd tmux
+# ll
+# ./autogen.sh
+# ./configure
+# make -j4
+# make install
+# make clean
+</code>
 </WRAP>
@@ Line 356: / Line 371: @@
+https://github.com/nZEDb/nZEDb_Misc/blob/master/Guides/Various/IRCScraper/Guide.md
+http://nzedb.readthedocs.io/en/master/ircscraper.html#ircscraper
+==== TO DO ====
+<code># useradd -c nzedb nzedb
+# usermod -a -G nzedb www-data
+***Login with nzedb***
+# /var/www/nZEDb/misc/IRCScraper
+# php scrape.php true false true
+</code>