Website error upon logon and stats not updating.




Here is what I did as I was installing the system:

Install WebServer Apache:
sudo yum update httpd
sudo yum -y install httpd
sudo systemctl start httpd
sudo systemctl enable httpd
sudo systemctl status httpd

Enable Apache Rewrite Module:
https://devops.ionos.com/tutorials/install-and-configure-mod_rewrite-for-apache-on-centos-7/
sudo nano /etc/httpd/conf.modules.d/00-base.conf
Add or uncomment the following line:
LoadModule rewrite_module modules/mod_rewrite.so
sudo systemctl restart httpd

Install PHP 7 and utils:
sudo yum -y install http://rpms.remirepo.net/enterprise/remi-release-7.rpm 
sudo yum -y install epel-release yum-utils
sudo yum-config-manager --disable remi-php54
sudo yum-config-manager --enable remi-php73
sudo yum -y install php php-cli php-fpm php-mysqlnd php-zip php-devel php-gd php-mcrypt php-mbstring php-curl php-xml php-pear php-bcmath php-json php-ldap php-memcache

Install mpstat utility or sysstat:
yum install -y sysstat

Install Cat Doc:
yum install -y catdoc

Install PDF2Text:
yum install -y poppler*


yum install -y libevent-devel 

yum install -y unrtf

yum install -y tnef

Install xlhtml:
wget https://bitbucket.org/jsuto/piler/downloads/xlhtml-0.5.1-sj-mod.tar.gz -P /opt
tar zxvf xlhtml-0.5.1-sj-mod.tar.gz
cd /opt/xlhtml-0.5.1-sj-mod
./configure
make
make install

Install memcached:
yum install memcached

groupadd piler
useradd -g piler -m -s /bin/sh -d /var/piler piler 
usermod -L piler
chmod 755 /var/piler


yum -y install tcp_wrappers
yum -y install tcp_wrappers-devel

Add the following to /etc/sudoers:
visudo
apache ALL=NOPASSWD: /etc/init.d/rc.piler reload
Defaults:%apache !requiretty 

Install Piler:
wget https://bitbucket.org/jsuto/piler/downloads/piler-1.3.5.tar.gz -P /opt/piler/
sudo tar -zxvf /opt/piler/piler-1.3.5.tar.gz
cd piler-1.3.5
./configure  --localstatedir=/var  --with-database=mysql
make
su -c 'make install'
ldconfig

/etc/init.d/rc.piler start


#mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';


mysql>create database piler character set 'utf8';
mysql>grant all privileges on piler.* to piler@localhost identified by 'password';
mysql>flush privileges;
mysql>quit;


sudo ln -s /usr/bin/sphinx-3.1.1/bin/searchd  /usr/bin/searchd
sudo ln -s /usr/bin/sphinx-3.1.1/bin/indexer  /usr/bin/indexer
sudo ln -s /usr/bin/sphinx-3.1.1/bin/indextool  /usr/bin/indextool
sudo ln -s /usr/bin/sphinx-3.1.1/bin/wordbreaker  /usr/bin/wordbreaker

Setup Database:

mysql -u root -p
mysql -u piler -p

GRANT ALL PRIVILEGES ON *.* TO root@127.0.0.1 IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO piler@127.0.0.1 IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO root@piler.dc.pud IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO piler@piler.dc.pud IDENTIFIED BY 'password' WITH GRANT OPTION;

Import Initial Database:
mysql -u root -p piler < /opt/piler-1.3.5/util/db-mysql.sql

Run to setup indexing on the database:
indexer --all


Setup Webserver:

sudo ln -s /etc/httpd/sites-available/piler.dc.pud.conf /etc/httpd/sites-enabled/piler.dc.pud.conf

<VirtualHost *:80>
  ServerName piler.dc.pud
  DocumentRoot /var/piler/www

  <Directory /var/piler/www>
    AllowOverride All
    Order allow,deny
    Allow from all
    Require all granted
  </Directory>

  ServerAdmin root@localhost
  ErrorLog /var/log/httpd/piler.dc.pud-error_log
  CustomLog /var/log/httpd/piler.dc.pud-access_log common
</VirtualHost>



chown apache:apache /var/piler/www/tmp

rename /usr/local/etc/piler.conf.dist to /usr/local/etc/piler.conf
rename /usr/local/etc/sphinx.conf.dist to /usr/local/etc/sphinx.conf
rename /usr/local/etc/config-site.dist.php to /usr/local/etc/config-site.php
Edit all three files adding the information needed.


su - piler
crontab -e

*/5 * * * * LC_ALL=C mpstat | tail -1 | awk '{print $11}' > /var/piler/stat/cpu.stat
*/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
*/15 * * * * /usr/local/bin/indexer --quiet tag1 --rotate
*/15 * * * * /usr/local/bin/indexer --quiet note1 --rotate
# optional
30 7 * * * /usr/bin/php /usr/local/libexec/piler/daily-report.php /var/piler/www

sudo systemctl restart crond.service