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, 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 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:

    init_connect='SET collation_connection = utf8_general_ci'
    init_connect='SET NAMES utf8'

    mysqladmin -u root password new_password

    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'";
    $stdfiltersql = "DATE_FORMAT(".$columns[0].".".$columns[1].", '%m%d') between DATE_FORMAT('".$startdate."', '%m%d') and DATE_FORMAT('".$enddate."', '%m%d')";

    return $stdfiltersql;

    Also popular now: