Online demo Privacy policy GoBD notes Blog

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
current:post-install [2017/04/25 22:20]
sj
current:post-install [2020/04/21 11:35] (current)
sj
Line 27: Line 27:
 <code> <code>
 #mysql -u root -p #mysql -u root -p
-mysql>create database piler character set 'utf8';+mysql>create database piler character set 'utf8mb4';
 mysql>grant all privileges on piler.* to piler@localhost identified by 'verystrongpassword'; mysql>grant all privileges on piler.* to piler@localhost identified by 'verystrongpassword';
 mysql>flush privileges; mysql>flush privileges;
Line 42: Line 42:
  
 <code> <code>
-#cp etc/sphinx.conf.in /usr/local/etc +# cp etc/sphinx.conf.in /usr/local/etc/piler/sphinx.conf 
-#su - piler +# chmod +x /usr/local/etc/piler/sphinx.conf 
-$indexer --all+# su - piler 
 +$ indexer --all --config /usr/local/etc/piler/sphinx.conf
 </code> </code>
  
Line 65: Line 66:
 </code> </code>
  
-Set up cron jobs +**Set up cron jobs for piler user**
- +
-For piler user:+
  
 <code> <code>
-*/5 * * * * LC_ALL=C mpstat | tail -1 | awk '{print $11}' > /var/piler/stat/cpu.stat +5,35 * * * * /usr/local/libexec/piler/indexer.delta.sh 
-*/15 * * * * /usr/local/bin/indexer --quiet delta1 --rotate && sleep 2 && /usr/local/bin/indexer --quiet --merge main1 delta1 --merge-dst-range deleted 0 0 --rotate +30   2 * * * /usr/local/libexec/piler/indexer.main.sh 
-*/15 * * * * /usr/local/bin/indexer --quiet tag1 --rotate +40 3 * * * /usr/local/libexec/piler/purge.sh 
-*/15 * * * * /usr/local/bin/indexer --quiet note1 --rotate +*/15 * * * * /usr/bin/indexer --config /usr/local/etc/piler/sphinx.conf --quiet tag1 --rotate 
-# optional +*/15 * * * * /usr/bin/indexer --config /usr/local/etc/piler/sphinx.conf --quiet note1 --rotate 
-30 7 * * * /usr/bin/php /usr/local/libexec/piler/daily-report.php /var/piler/www+*/* * * *  /usr/bin/find /var/piler/www/tmp -type f -name i.\* -exec rm -f {} \; 
 +*/5 * * * * /usr/bin/find /var/piler/error -type f|wc -l > /var/piler/stat/error 
 +3 * * * * /usr/local/libexec/piler/watch_sphinx_main_index.sh 
 +2 0 * * * /usr/local/libexec/piler/pilerpurge.py
 </code> </code>
  
Line 92: Line 94:
 </code> </code>
  
-Create config-site.php (in the same directory where config.php resides), and add every site specific variables to config-site.php. Any variable that presents in config-site.php overrides the config.php default values. This way your local settings may survive a gui upgrade when the contents of config.php is changed.+Create /usr/local/etc/piler/config-site.php, and add every site specific variables to config-site.php. Any variable that presents in config-site.php overrides the config.php default values. This way your local settings may survive a gui upgrade when the contents of config.php is changed.
  
 On the demo site we use the following config-site.php file: On the demo site we use the following config-site.php file:
Line 103: Line 105:
 $config['DIR_BASE'] = '/var/piler/www/'; $config['DIR_BASE'] = '/var/piler/www/';
  
-$config['ENABLE_AUDIT'] = 0; 
-$config['MEMCACHED_ENABLED'] = 0; 
-$config['ENABLE_SYSLOG'] = 1; 
 $config['PILER_HOST'] = '1.2.3.4'; $config['PILER_HOST'] = '1.2.3.4';
 $config['SMTP_DOMAIN'] = 'demo.mailpiler.org'; $config['SMTP_DOMAIN'] = 'demo.mailpiler.org';
Line 111: Line 110:
 $config['ADMIN_EMAIL'] = 'admin@demo.mailpiler.org'; $config['ADMIN_EMAIL'] = 'admin@demo.mailpiler.org';
  
-?> 
 </code> </code>
  
 Check out the contrib/webserver directory on how to setup a virtual host for apache and nginx. Check out the contrib/webserver directory on how to setup a virtual host for apache and nginx.
Google Analytics Alternative