{"id":18862,"date":"2016-04-11T15:15:29","date_gmt":"2016-04-11T20:15:29","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=18862"},"modified":"2022-12-09T05:58:05","modified_gmt":"2022-12-09T11:58:05","slug":"how-to-install-logaholic-on-centos","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-logaholic-on-centos\/","title":{"rendered":"How to install Logaholic on CentOS"},"content":{"rendered":"
<\/p>\n
Logaholic is a web analytics software which provides reliable information about the traffic, content, keywords etc. of the web sites installed on your CentOS VPS<\/a>. This install guide assumes that Apache, MySQL and PHP are already installed and configured on your server. At the time of writing this tutorial, the latest stable version of Logaholic is 6.0 and it requires:<\/p>\n <\/p>\n Let’s start with the installation of Logaholic SHE (self hosted edition). Download the latest version of Logaholic available at ‘http:\/\/www.logaholic.com\/download\/’ to the server and extract it using the following commands:<\/p>\n Download GeoLite Legacy Database at http:\/\/www.maxmind.com\/download\/geoip\/database\/GeoLiteCity.dat.gz , then extract and copy this file to the ‘\/var\/www\/html\/logaholic\/components\/geoip\/’ directory on your server:<\/p>\n Change the file permissions so your web server can write to the ‘\/var\/www\/html\/logaholic’ directory and sub directories:<\/p>\n Edit the Apache configuration file (by default ‘\/etc\/httpd\/conf\/httpd.conf’) and define the Apache log file in the following format:<\/p>\n In general, this seems to be enough:<\/p>\n Please note that each Apache virtual host should have it’s own log file. Edit the \u2018php.ini\u2019 file and add\/modify the following lines:<\/p>\n Create a new virtual host directive in Apache. For example, edit your Apache configuration file (\u2018\/etc\/httpd\/conf\/httpd.conf\u2019 by default) and un-comment the following line:<\/p>\n Then, add the following lines at the end:<\/p>\n Restart the Apache web server for the changes to take effect:<\/p>\n Create a new MySQL database for Logaholic on your server:<\/p>\n Do not forget to replace ‘your-password’ with a strong password.<\/p>\n Set the MySQL server time zone:<\/p>\n Populate the time zone tables using the following command:<\/p>\n 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’.<\/p>\n 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. Of course you don\u2019t have to do any of this if you use one of our Blazing-Fast CentOS Hosting<\/a> services, in which case you can simply ask our expert Linux admins to install\u00a0Logaholic<\/strong> for you. They are available 24×7 and will take care of your request immediately.<\/p>\n PS.<\/strong><\/span> If you liked this post please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":" Logaholic is a web analytics software which provides reliable information about the traffic, content, keywords etc. of the web sites … <\/p>\n
\n<\/span><\/p>\n\n
cd \/opt\/\r\nwget -O logaholic.tar.gz http:\/\/www.logaholic.com\/download.php?file=logaholic_she_600.tar.gz\r\ntar -xvzf logaholic.tar.gz\r\nmkdir -p \/var\/www\/html\/logaholic\r\nmv logaholic_she_600\/logaholic \/var\/www\/html<\/pre>\n
wget http:\/\/www.maxmind.com\/download\/geoip\/database\/GeoLiteCity.dat.gz\r\ngunzip GeoLiteCity.dat.gz\r\nmv GeoLiteCity.dat \/var\/www\/html\/logaholic\/components\/geoip\/<\/pre>\n
chown apache:apache -R \/var\/www\/html\/logaholic\/<\/pre>\n
CustomLog \/your_path\/access_log \"%h %l %u %t \\\"%r\\\" %s %b \\\"%{Referer}i\\\"\r\n\\\"%{User-Agent}i\\\"\"<\/pre>\n
CustomLog \/your_path\/access_log \"combined\"<\/pre>\n
\nLocate the php configuration file using the following command:<\/p>\n#php -i | grep php.ini\r\nConfiguration File (php.ini) Path => \/etc\r\nLoaded Configuration File => \/etc\/php.ini<\/pre>\n
allow_url_fopen = On \r\ndisplay_errors = On \r\noutput_buffering = off<\/pre>\n
#NameVirtualHost *:80<\/pre>\n
<VirtualHost *:80>\r\nServerAdmin admin@yourdomain.com\r\nDocumentRoot \/var\/www\/html\/logaholic\/\r\nServerName yourdomain.com\r\nServerAlias www.yourdomain.com\r\n<Directory \/var\/www\/html\/logaholic\/>\r\n Options FollowSymLinks\r\n AllowOverride All\r\n<\/Directory>\r\n ErrorLog logs\/yourdomain.com-error_log\r\n CustomLog logs\/yourdomain.com-access_log combined\r\n<\/VirtualHost>\r\n<\/pre>\n
service httpd restart<\/pre>\n
mysql -u root -p\r\nmysql> CREATE DATABASE logaholicdb;\r\nmysql> GRANT ALL PRIVILEGES ON logaholicdb.* TO 'logaholicuser'@'localhost' IDENTIFIED BY 'your-password' WITH GRANT OPTION;\r\nmysql> FLUSH PRIVILEGES;\r\nmysql> quit<\/pre>\n
mysql -u root -p\r\nmysql> SET GLOBAL time_zone = '-06:00';\r\nmysql> FLUSH PRIVILEGES;\r\nmysql> quit<\/pre>\n
mysql_tzinfo_to_sql \/usr\/share\/zoneinfo | mysql -u root mysql<\/pre>\n
\n<\/p>\n