How to install Logaholic on CentOS

<div dir="ltr" style="text-align: left;" trbidi="on"> <h1 class="entry-title" style="background-color: white; box-sizing: border-box; font-family: Lato, sans-serif; line-height: 1.1; margin: 20px 0px 10px;"> <span style="color: #990000; font-size: large;"><u>Install Logaholic on CentOS</u></span></h1> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Logaholic is a Web Analytics provider with solutions for individual websites, hosting providers and agencies. Self hosted or in the cloud, you own the data.</span></span></div> <div> <div style="font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"> <b><u><span style="color: #0b5394;">Logaholic is 6.0 and it requires:</span></u></b></div> <div> <ul style="color: #222222; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: left;"> <li><a href="http://www.hackthesec.co.in/search/label/PHP">PHP</a> 5 or higher with cURL and Zip extensions enabled. The output_buffering setting should be disabled and allow_url_fopen and display_errors settings should be enabled in php.ini</li> <li><a href="http://www.hackthesec.co.in/search/label/Apache">Apache</a> or <a href="http://www.hackthesec.co.in/search/label/NGINX">Nginx</a> Web Server</li> <li><a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a> 5.0 or higher</li> </ul> <div style="font-family: verdana, geneva, sans-serif;"> <span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">Download the latest version of Logaholic available at http://www.logaholic.com/download/ to the server and extract it using the following commands:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">cd /opt/ wget -O logaholic.tar.gz http://www.logaholic.com/download.php?file=logaholic_she_600.tar.gz tar -xvzf logaholic.tar.gz </span><span style="color: lime;">mkdir -p /var/www/html/logaholic </span><span style="color: white;">mv logaholic_she_600/logaholic /var/www/html</span></span></span></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Download GeoLite Legacy Database at http://www.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz , then extract and copy this file to the '<b>/var/www/html/logaholic/components/geoip/</b>' directory on your server:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">wget http://www.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz </span><span style="color: lime;">gunzip GeoLiteCity.dat.gz </span><span style="color: white;">mv GeoLiteCity.dat /var/www/html/logaholic/components/geoip/</span></span></span></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Change the file permissions so your web server can write to the '<b>/var/www/html/logaholic</b>' directory and sub directories:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: orange; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">chown apache:apache -R /var/www/html/logaholic/</span></span></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Edit the Apache configuration file (by default ‘/etc/httpd/conf/httpd.conf’) and define the Apache log file in the following format:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">CustomLog /your_path/access_log "%h %l %u %t \"%r\" %s %b \"%{Referer}i\" \"%{User-Agent}i\""</span></span></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">In general, this seems to be enough:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">CustomLog /your_path/access_log "</span><span style="color: orange;">combined</span><span style="color: white;">"</span></span></span></pre> </div> <div style="font-family: verdana, geneva, sans-serif;"> <span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;"><div> Please note that each Apache virtual host should have it’s own log file.</div> <div> Locate the php configuration file using the following command:</div> </span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">#php -i | grep php.ini Configuration File (php.ini) Path => /etc </span><span style="color: orange;">Loaded Configuration File => /etc/php.ini</span></span></span></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Edit the '<b>php.ini</b>' file and add/modify the following lines:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">allow_url_fopen = On </span><span style="color: orange;">display_errors = On </span><span style="color: lime;">output_buffering = off</span></span></span></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Create a new virtual host directive in Apache. For example, edit your Apache configuration file ('<b>/etc/httpd/conf/httpd.conf</b>' by default) and un-comment the following line:</span></span></div> <div> <pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">#NameVirtualHost *:80</pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Then, add the following lines at the end:</span></span></div> <div> <pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><VirtualHost *:80> ServerAdmin admin@yourdomain.com DocumentRoot /var/www/html/logaholic/ ServerName yourdomain.com ServerAlias www.yourdomain.com <Directory /var/www/html/logaholic/> Options FollowSymLinks AllowOverride All </Directory> ErrorLog logs/yourdomain.com-error_log CustomLog logs/yourdomain.com-access_log combined </VirtualHost></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Restart the Apache web server for the changes to take effect:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">service </span><span style="color: orange;">httpd </span><span style="color: white;">restart</span></span></span></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Create a new MySQL database for Logaholic on your server:</span></span></div> <div> <pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">mysql -u root -p mysql> CREATE DATABASE logaholicdb; mysql> GRANT ALL PRIVILEGES ON logaholicdb.* TO 'logaholicuser'@'localhost' IDENTIFIED BY 'your-password' WITH GRANT OPTION; mysql> FLUSH PRIVILEGES; mysql> quit</pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="line-height: 26px;"><div style="font-size: 15px;"> Do not forget to replace 'your-password' with a strong password.</div> <div style="font-size: 15px;"> Set the MySQL server time zone:</div> <div> <pre style="background-color: whitesmoke; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">mysql -u root -p mysql> SET GLOBAL time_zone = '-06:00'; mysql> FLUSH PRIVILEGES; mysql> quit</pre> </div> </span></span></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Populate the time zone tables using the following command:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">mysql_tzinfo_to_sql </span><span style="color: orange;">/usr/share/zoneinfo</span><span style="color: white;"> | mysql -u root mysql</span></span></span></pre> </div> <div> <span style="font-family: verdana, geneva, sans-serif;"><div style="color: #222222; font-size: 15px; line-height: 26px;"> Open http://yourdomain.com/install.php in your popular web browser and follow the easy instructions: enter the database settings and admin login credentials, then click 'Save'. If all settings in ‘Database Settings , 'Mysql Settings' , 'File Access Check' and 'PHP Settings' sections are green, click 'Continue'.</div> <div style="color: #222222; font-size: 15px; line-height: 26px;"> <br /></div> <div style="color: #222222; font-size: 15px; line-height: 26px;"> That is it. The Logaholic installation is now complete. Log in to the Admin area at http://yourdomain.com/login.php and click the 'Global Settings' tab for more post-installation tasks like adding a password etc.</div> <div class="separator" style="clear: both; color: #222222; font-size: 15px; line-height: 26px; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIfoJ4QMvgzOGI5s8v-1FJoWxd0W8GPi8kneKc2UqEcJdT4hn4ZGPxIB_HkOysAQr9wVUow80NqV7BP2hYD1ADzD_6W7KX6ZrQSqVseyAOLO18hd2M-NLUdGZwrjg5chIFhLA7Sg2wMSt8/s1600/logaholic-back-end_hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIfoJ4QMvgzOGI5s8v-1FJoWxd0W8GPi8kneKc2UqEcJdT4hn4ZGPxIB_HkOysAQr9wVUow80NqV7BP2hYD1ADzD_6W7KX6ZrQSqVseyAOLO18hd2M-NLUdGZwrjg5chIFhLA7Sg2wMSt8/s1600/logaholic-back-end_hackthesec.co.in.png" /></a></div> <div style="color: #222222; font-size: 15px; line-height: 26px;"> <br /></div> <div style="text-align: center;"> <span style="font-size: 15px; line-height: 26px;"><b><u><span style="color: #990000;">Install Logaholic using your cPanel account</span></u></b></span></div> <div class="separator" style="clear: both; text-align: center;"> <iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/lPXYejXsx6o/0.jpg" src="https://www.youtube.com/embed/lPXYejXsx6o?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div> <div style="color: #222222; font-size: 15px; line-height: 26px;"> <br /></div> <div style="color: #222222; font-size: 15px; line-height: 26px;"> <a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></div> </span></div> </div> </div> </div>

How to install Logaholic on CentOS

Install Logaholic on CentOS Logaholic is a Web Analytics provider with solutions for individual websites, hosting providers and agencies...

Read more »