Install 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. Here's how I did it.
All commands are executed either as sudoor how root.

Install the Apache web server:
apt-get install apache2 apache2-doc
Launch Apache:
/etc/init.d/apache2 start
Check the operation of Apache:
In the browser at the address 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 vTiger archive:
cd /path_were_the_vtiguer_source_is
Unzip the archive with the program:
tar zxvf vtigercrm-5.0.4.tar.gz
Install MySQL (during the installation process you will need to enter the MySQL administrator password):
apt-get install mysql-server mysql-client
Install PHP and other necessary 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
Go to the directory with the vTiger files:
cd vtigercrm/
Copy vTiger to the root directory of the server:
cp -vr * /var/www

Change access rights, giving Apache the ability to make the necessary changes:
chown www-data -vR /var/www
Delete the Apache test page:
rm -rf /var/www/index.html
Restart Apache:
/etc/init.d/apache2 restart
Configure vTiger
in the browser at the address 127.0.0.1or 127.0.0.1/install.phpmake the necessary settings.

In addition to choosing the necessary options during the vTiger configuration process, it was necessary to make changes to the file php.ini. The path to the file: /etc/php5/apache2/php.ini. Find the file using the following command: find / -name php.ini. After making changes, you must restart the Apache: /etc/init.d/apache2 restart. Options to be set: Also, for the correct support of the UTF-8 encoding, it was required to configure the MySQL server by making changes to the file (or
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
my.cnfmy.ini) The path to the file: /etc/mysql/my.cnf. After making changes, you must restart the MySQL server: /etc/init.d/mysql restart. Required code: And it all worked! P. S. You can change the password of the MySQL server administrator with the command: PPS To configure the filter to show contacts by birthday, you need to make changes to the file (path to file:) : Replace code: with 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'




mysqladmin -u root password new_password
CustomView.php/var/www/modules/CustomView

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

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



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;