Howto install Vtiger CRM 7

Hi guys,
here is a quick and dirty setup for Vtiger CRM 7…

Prerequisites

Install MariaDB (MySQL) server and Web Server with all PHP modules via Software Center.

Database

Get mariadb root pw and copy it for later pasting

cat ~/.my.cnf

gives you

[client] password=YOURDBROOTPASSWORD

Go to command line and add mariadb user and database

mysql -u root CREATE DATABASE vtiger; CREATE USER 'vtiger'@'localhost' IDENTIFIED BY 'YOURVTIGERDBUSERPASSWORD'; GRANT ALL PRIVILEGES ON vtiger.* TO 'vtiger'@'localhost' IDENTIFIED BY 'YOURVTIGERDBUSERPASSWORD' WITH GRANT OPTION; FLUSH PRIVILEGES; EXIT;

or install stephdl repo (see https://wiki.nethserver.org/doku.php?id=stephdl_repository for more infos) and phpmyadmin to create user and db:

yum install http://mirror.de-labrusse.fr/NethServer/7/x86_64/nethserver-stephdl-1.0.5-1.ns7.sdl.noarch.rpm yum install nethserver-phpmyadmin
Go to phpmyadmin via applications in the web ui and create a new user vtiger and set the checkbox to create a db with same name and grant all privileges

PHP configuration

The needed php.ini settings are:

display_errors = On max_execution_time = 0 error_reporting = E_WARNING & ~E_NOTICE & ~E_DEPRECATED log_errors = Off default_charset = "utf-8"

So we change already available props and create /etc/php.d/vtiger.ini for other settings, to allow VtigerCRM to work (thanks to @lucag):

config setprop php MaxExecutionTime 0
echo -e "display_errors = On\nerror_reporting = E_WARNING & ~E_NOTICE & ~E_DEPRECATED\nlog_errors = Off\ndefault_charset = \"utf-8\"" > /etc/php.d/vtiger.ini
signal-event nethserver-php-update
systemctl restart httpd

Installing Vtiger CRM

Download Vtiger CRM from https://www.vtiger.com/open-source-crm/download-open-source, unpack and move to /var/www/html

cd ~ wget https://sourceforge.net/projects/vtigercrm/files/vtiger%20CRM%207.0.1/Core%20Product/vtigercrm7.0.1.tar.gz tar xzf vtigercrm7.0.1.tar.gz mv vtigercrm /var/www/html/

Set user for the new dir:

chown -R apache:apache /var/www/html/vtigercrm

Configuration

Go to https://yournethserverhost/vtigercrm, select next until you are asked for db creds…
Paste the database root password that you copied out of ~/.my.cnf.
Use the created db user vtiger with database vtiger…

That’s it! Enjoy your Vtiger CRM!

Applications menu

As addition you may create following file to have VtigerCRM in Applications Menu:

nano  /usr/share/nethesis/NethServer/Module/Dashboard/Applications/VtigerCRM.php

Paste the following into the php file:

namespace NethServer\Module\Dashboard\Applications;
/**
 * VTiger CRM 7 application widget
 */
class VTigerCRM extends \Nethgui\Module\AbstractModule implements \NethServer\Module\Dashboard\Interfaces\ApplicationInterface
{
    public function getName()
    {

        return "VtigerCRM";
    }

    public function getInfo()
    {
         $host = explode(':',$_SERVER['HTTP_HOST']);
         return array('url' => "https://".$host[0]."/vtigercrm");
    }
}

Now you may open VtigerCRM from the application menu.

Please feel free to give feedback to expand this howto…

8 Likes

Thank you @mrmarkuz for your Howto.

I would suggest a different way for changes to the php.ini configuration:

“max_execution_time” and “short_open_tag” are props already available in the configuration db, so:

config setprop php ShortOpenTag On
config setprop php MaxExecutionTime 0

For other changes I recommend using a separate file /etc/php.d/vtiger.ini with this content:

display_errors = On
error_reporting = E_WARNING & ~E_NOTICE & ~E_DEPRECATED
log_errors = Off
default_charset = "utf-8"

Then run:

signal-event nethserver-php-update
systemctl restart httpd.service
3 Likes

Thank you for your suggestions, I already edited the howto.
I also removed “short_tag_open” setting, as it is also not needed. Thanks again, I wouldn’t have noticed that without your input.

This setting wasn’t in my original howto and is not needed for vtiger install to work, why do you suggest this line?

I would be interested how VTiger compares to other CRM applications like Odoo, SugarCRM and Project Open.

There are some comparison webpages:
https://www.getapp.com/customer-management-software/a/sugarcrm/compare/vtiger-crm/
https://comparisons.financesonline.com/odoo-vs-vtiger

I personally tested vtiger long time ago, looks completely different now…

Hi @mrmarkuz,

I had marked it in my notes.
I do not exactly remember the reason why I had to include this default_charset.

Definitely to fix an error or issue on Vtiger CRM 7.
Perhaps it is only shown using the Italian language.

Sorry if I can not be more detailed :pensive:

I saw some discussions, in which utf-8 is suggested, so I’ll put in the howto again…

https://discussions.vtiger.com/index.php?p=/discussion/6169/using-utf-8-charset-as-default-in-vtiger-crm/p1

Hi, anyone who get functional customer portal for vtiger? I still have version 6.5 and customer portal is unable to connect to vtiger.

I tried to install customer portal, but I even don’t get the mail for login to customer portal, but I found the following, maybe it helps:

Here is the solution to ‘Could not connect to server. Please contact the administrator.’

Go to your Vtiger CRM installation Home directory. Open config.inc.php [Vtiger CRM’s main confirg file]
Add
ini_set(‘display_errors’,’Off’);
error_reporting(0);

Unless your webhost restricts php.ini directive override, This will solve your issues.

Source: