Friday, February 1, 2019

Install Vtiger 7.1.0 in ISSABEL

Here's how VTIGER 7.1.0 can be installed in ISSABEL running Centos 7


THIS IS NOT AN UPGRADE MIGRATION TO 7.1.0.
This is a complete fresh installation document.

This documents steps to install vTiger CRM into the ISSABEL distribution ISO of Asterisk running on Centos 7.  This would probably work for most Centos 7 installs, but its only been tested in the distriburion issabel4-USB-DVD-x86_64-20181002


1> DOWNLOAD the 7.1.0 vTiger install:
cd /tmp
wget https://sourceforge.net/projects/vtigercrm/files/vtiger%20CRM%207.1.0/Core%20Product/vtigercrm7.1.0.tar.gz
2> DECOMPRESS IT

tar -xzvf vtigercrm7.1.0.tar.gz
3> set ownership

chown asterisk: -R vtigercrm
4> MOVE -or- DELETE any existing vTiger5 data
THIS WILL DELETE the CURRENT Vtiger INSTALLED ON ISSABEL!!!! 
** READ THIS SECTION CAREFULLY IF YOU HAVE vTIGER DATA YOU WANT TO KEEP! **

a> ** KEEP Vtiger5 INSTALLATION **

mv /var/www/html/tigercrm /var/www/html/tigercrmold


b> ** DELETE Vtiger5 INSTALLATION **

rm -rf /var/www/html/vtigercrm
5> Put vTiger7.1.0 in web folder for WEB access

mv vtigercrm /var/www/html/
6> LOG INTO MYSQL/MariaDB SQL service


mysql -u root -p
7> SETUP SQL database and user

CREATE DATABASE vtiger710;

CREATE USER 'vtiger_admin'@'localhost' IDENTIFIED BY 'PaSsw0rd';

GRANT ALL PRIVILEGES ON `vtiger710`.* TO 'vtiger_admin'@'localhost';

FLUSH PRIVILEGES;

ALTER DATABASE vtiger710 CHARACTER SET utf8 COLLATE utf8_general_ci;

EXIT
8> Modify vTiger "display_errors" option

sed -i -r 's/display_errors = Off/display_errors = On/' /etc/php.ini
9> Modify vTiger "log_errors" option

sed -i -r 's/log_errors = On/log_errors = Off/' /etc/php.ini
10> restart web service

service httpd restart
11> Test the install of vTiger with a web browser

https://IP-ADDRESS/vtigercrm/
http://IP-ADDRESS/vtigercrm/
You should be presented with the Vtiger setup screen like this one





Click on INSTALL

Click on "I AGREE" if you agree with the vTiger Public Licence.

"Installation Prerequisites" - select "NEXT"

(There is an error with the error_logging that haven't fixed yet.  This does not effect the installation)  If you know how to resolve this, that would be great!  I tested using a slightly older version of Tiger7.0.1 and did not have the problem.  So far i don't see it affecting anything.)


System Configuration

Hostname = localhost

Localhost should work, assuming TIGER and PBX are on the same box.
My system has a fully qualified name in DNS so you can also use something like issabel.company.com.

username = vtiger_admin
password = PaSsw0rd
database name = vtiger710

Select "CREATE NEW DATABASE"
put in your MariaDB user/password (usually root for a username)

Pick the currency of your country

User name - defaults to admin
password = password of your choice

First Name is optional
Last Name = Administrator

email = your email address for admin messages.

Select time zone

Press NEXT

Assuming you have everything configured properly you'll be presented with a summary screen of config settings.

Press NEXT

Select your type of company.
This is strictly for anonymous info for vtiger.

Click on NEXT

The system will start doing installations of the application.  you'll see a status bar moving around.  Usually only takes 30 seconds.  Depends on speed of your system.

The system will then present you some check boxes of the type of business you are running and additional modules that are custom to your environment.  Once the installation is completed, you will be at the vTiger admin window and your installation is completed.

I'm going to talk about intergrating asterisk issabel with the ticket system so if that is something that interests you, select CALL CENTER.


You'll be presented with a "ALMOST THERE" menu.  Its double checking your preferences.

Select "GET STARTED"

You should now be in the VTIGER dashboard.!


15 comments:

  1. excelente, gracias por el aporte

    ReplyDelete
  2. Gracias excelente se le agradece!!!!

    ReplyDelete
  3. Hi, Did you try to install Issabel on AWS Centos Ami?

    ReplyDelete
  4. Yep. Seems to work just fine. I used the install script to deploy it onto a Centos AWS image.

    ReplyDelete
  5. I'm interested in doing, calls, from vtiger. you have an example
    Link the user with his internal number and make calls to customers who are in database.
    Thank you.

    ReplyDelete
  6. Unfortunately, at this present time, I've not done that type of integration with Vtiger worthy of posting.

    ReplyDelete
  7. Excelente tutorial, funciona a la perfeccion. Muchas gracias !!!!!

    ReplyDelete
  8. any one config incoming pop on vtiger integration

    ReplyDelete
  9. Do you have a guide on how to proactively use vtiger if i have a customer database of 55k enteries and am half outgoing half ingoing call center (Pharmacies and we process deliviries and follow up with patiens)

    ReplyDelete
    Replies
    1. That is really a question for the vTiger forums how to manage that sort of thing.

      Delete
  10. Hola. Si están interesados, me gustaría invitarles al foro de VTiger Open Source en Telegram. Vamos creciendo cada mes con el fin de ayudar a todos los usuarios que tengan dudas o problemas en esta plataforma.

    VTiger CRM Community Support
    https://t.me/vtiger7crm

    ReplyDelete
  11. Hi there :)

    How to add ari module to asterisk 11?

    ReplyDelete

Feel free to leave a comment! If you have any information that you think should be included, please do so here and I'll get it added in.