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.cnfgives 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 httpdInstalling 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/vtigercrmConfiguration
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.phpPaste 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…
