Installing vTiger CRM on Ubuntu 8.10

Installing vTiger CRM version 5.0.4 on Ubuntu 8.10 (intrepid) was given to me with a fight. This is how I managed to do it.
All commands are executed either as sudo or as root .

Install Apache web server:
apt-get install apache2 apache2-doc
Run Apache:
/etc/init.d/apache2 start
Check Apache to work:
In the browser at 127.0.0.1 127.0.0.1 , if everything is in order, a corresponding message will appear, for example: “It works!” .

Go to the directory with the downloaded archive vTiger:
cd /path_were_the_vtiguer_source_is
Unpack the archive with the program:
tar zxvf vtigercrm-5.0.4.tar.gz
Install MySQL (during the installation process it will be necessary to enter the MySQL administrator password):
apt-get install mysql-server mysql-client
Install PHP and other required packages:

apt-get install libapache2-mod-php5 libapache2-mod-perl2
apt-get install php5 php5-cli php5-common php5-curl php5-dev php5-gd php5-imap php5-ldap
apt-get install php5-mhash php5-mysql php5-odbc curl libwww-perl imagemagick
Change to the directory with vTiger files:
cd vtigercrm/
Copy vTiger to the root directory of the server:
cp -vr * /var/www

Change permissions by giving Apache the ability to make necessary changes:
chown www-data -vR /var/www
Delete Apache Test Page:
rm -rf /var/www/index.html
Restart Apache:
/etc/init.d/apache2 restart
Configure vTiger
In the browser at 127.0.0.1 127.0.0.1 or 127.0.0.1/install.php 127.0.0.1/install.php perform the necessary settings.
')
In addition to selecting the necessary options in the vTiger configuration process, it was necessary to make changes to the php.ini . File path: /etc/php5/apache2/php.ini . You can find / -name php.ini file with the command: find / -name php.ini . After making changes, you need to restart Apache: /etc/init.d/apache2 restart . Options to install:
Safe Mode Off
Display Errors On
File Uploads On
Register Globals Off
Max Execution Time 600
output_buffering = On
Change the memory limit = 64M
error_reporting = E_ALL & ~E_NOTICE
allow_call_time_pass_reference = On
log_errors = Off
short_open_tag = On
Also, for correct support of the UTF-8 encoding, it was necessary to configure the MySQL server by making changes to the my.cnf (or my.ini ) file. File path: /etc/mysql/my.cnf . After making the changes, you must restart the MySQL server: /etc/init.d/mysql restart . Required code:
[mysql]
default-character-set=utf8

[mysqld]
collation_server=utf8_unicode_ci
character_set_server=utf8
default-character-set=utf8
init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'

And it all worked!

PS You can change the password of the MySQL server administrator with the command:
mysqladmin -u root password new_password
PPS To configure the filter to show contacts by birthday, you need to make changes to the CustomView.php file (file path: /var/www/modules/CustomView ): Replace the code:

if($startdate != "" && $enddate != "")
{
$columns = explode(":",$filtercolumn);

$stdfiltersql = $columns[0].".".$columns[1]." between '".$startdate." 00:00:00' and '".$enddate." 23:59:00'";
}
}
return $stdfiltersql;

on code:

if($startdate != "" && $enddate != "")
{
$columns = explode(":",$filtercolumn);
if ($columns[1] != 'birthday')
$stdfiltersql = $columns[0].".".$columns[1]." between '".$startdate." 00:00:00' and '".$enddate." 23:59:00'";
else
$stdfiltersql = "DATE_FORMAT(".$columns[0].".".$columns[1].", '%m%d') between DATE_FORMAT('".$startdate."', '%m%d') and DATE_FORMAT('".$enddate."', '%m%d')";


}
}
return $stdfiltersql;