vTiger on ViciBox 6.0

Support forum for the ViciBox ISO Server Install and ISO LiveCD Demo

Moderators: enjay, williamconley, Staydog, mflorell, MJCoate, mcargile, Kumba

vTiger on ViciBox 6.0

Postby edmund.uba » Thu Dec 18, 2014 4:09 am

Greetings!

I made a fresh installation of the ViciBox. Does anyone here have any idea on how to activate/install vTiger? I hope there is a step by step procedure on how to do it, cause I am pulling my hairs.......
edmund.uba
 
Posts: 21
Joined: Fri Feb 28, 2014 8:11 pm
Location: Davao City, Philippines

Re: vTiger on ViciBox 6.0

Postby mflorell » Thu Dec 18, 2014 5:59 am

Vicidial stopped supporting Vtiger several years ago due to increasing problems with maintaining integration, the inefficiency of Vtiger with large datasets and security issues with Vtiger. The last version we supported was 5.1, so I wouldn't expect vtiger 6.0 to work with Vicidial.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: vTiger on ViciBox 6.0

Postby edmund.uba » Thu Dec 18, 2014 6:39 am

@mflorell thanks for the info. But is there a step or a definitive guide I can follow on installing vTiger on the new Vicibox 6.0?
edmund.uba
 
Posts: 21
Joined: Fri Feb 28, 2014 8:11 pm
Location: Davao City, Philippines

Re: vTiger on ViciBox 6.0

Postby mflorell » Thu Dec 18, 2014 7:15 am

Not that I know of.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: vTiger on ViciBox 6.0

Postby edmund.uba » Thu Dec 18, 2014 7:47 am

@Mflorell, will sugarCRM suffice for vTiger?
edmund.uba
 
Posts: 21
Joined: Fri Feb 28, 2014 8:11 pm
Location: Davao City, Philippines

Re: vTiger on ViciBox 6.0

Postby edmund.uba » Fri Dec 19, 2014 5:42 am

if sugarCRM will suffice, is there a guide for me to follow on how to to do it?
edmund.uba
 
Posts: 21
Joined: Fri Feb 28, 2014 8:11 pm
Location: Davao City, Philippines

Re: vTiger on ViciBox 6.0

Postby mflorell » Fri Dec 19, 2014 7:05 am

I haven't touched SugarCRM in about 7 years, in our tests it was more complex and slower than Vtiger, it also had more obfuscated code. William Conley at Poundteam is the only one I know of that does custom SugarCRM and Vicidial integrations.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: vTiger on ViciBox 6.0

Postby edmund.uba » Fri Dec 19, 2014 7:38 pm

@mflorell I did notice him here in the forums and his signature regarding on the surgarCRM, but does he follow a guide or is his services paid?
edmund.uba
 
Posts: 21
Joined: Fri Feb 28, 2014 8:11 pm
Location: Davao City, Philippines

Re: vTiger on ViciBox 6.0

Postby mflorell » Sat Dec 20, 2014 7:58 am

You would have to send him a message and find out. I assume he has to do the integration by hand every time because of code changes between versions, so it's probably paid only.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: vTiger on ViciBox 6.0

Postby edmund.uba » Sun Dec 21, 2014 9:31 pm

I did researched, and tried to integrate the new version of vTiger, 6.0.1 to the ViciBox 6. Please do correct me if I have done something that shouldnt be done or any suggestions and feedbacks.

Heres my work so far.

First I have connected to the MySQL, which I have found out in a blog, and did some changes like this.

Code: Select all
#mysql -u root -p   (it will ask for root password default is vicidialnow)
mysql>GRANT ALL on vtigercrm610.* TO vtiger@'%' IDENTIFIED BY 'vtuser';
mysql>GRANT ALL on vtigercrm610.* TO vtiger@localhost IDENTIFIED BY 'vtuser';
mysql>create database vtigercrm610;
mysql>quit


then I downloaded the new version of the vTiger and executed commands below:
Code: Select all
#cd /srv/www/htdocs
#gunzip vtigercrm-6.1.0.tar.gz
#tar xvf vtigercrm-6.1.0.tar
#chmod -R 0777 vtigercrm
#cd vtigercrm


then I followed this: from a blog:
    in browser go to the following URL: http://192.168.4.8/vtigercrm/index.php
    enter contact info and click the START button at the bottom of the screen
    in system configuration set the database host to: <192.168.4.8>
    database user/pass: vtiger/vtuser
    database name: vtigercrm610
    click to install vtiger, then follow the on-screen instructions

then entered the following settings to the vicidial
Enable Vtiger Integration: 1
Vtiger DB Server IP: 192.168.4.8
Vtiger DB Name: vtigercrm610
Vtiger DB Login: vtiger
Vtiger DB Password: vtuser
Vtiger URL: 192.168.4.8/vtigercrm

then after that I done this:
Code: Select all
download VtigerAsteriskConnector.zip
unzip  VtigerAsteriskConnector.zip


then after my download and installation I did this again:
Code: Select all
vi VtigerAsteriskConnector/conf/VtigerAsteriskConnector.properties
ServerIP 192.168.4.8
ServerPort 56002
StorageDir /var/spool/asterisk/monitorDone/MP3/
AsteriskAppDBPath /var/lib/vtigerAsterisk/
AsteriskServerIP 192.168.4.8
AsteriskServerPort 5038
AsteriskUsername cron
AsteriskPassword 1234
VtigerURL http://192.168.4.8/vtigercrm/index.php
VtigerSecretKey


then I downloaded java in the vicidial, both jre and jdk
and then executed:
Code: Select all
./Start.sh

in the directory of the asterisk connector. and when i access the 192.168.4.8:56002 I can then see the directory which means its working.

and then followed this:
Code: Select all
 vi /etc/asterisk/cdr_manager.conf
enabled = yes


and then opened a port in the firewall for the vTiger port 56002:
Code: Select all
vi /etc/sysconfig/SuSEfirewall2


The problem is I got really lost and confused here. I got lost in the trunk and the extension. Ill post another reply. below for my questions why im confused.
edmund.uba
 
Posts: 21
Joined: Fri Feb 28, 2014 8:11 pm
Location: Davao City, Philippines

Re: vTiger on ViciBox 6.0

Postby edmund.uba » Sun Dec 21, 2014 11:03 pm

I got confused here, and here is the part where im definitely doing something wrong.

Code: Select all
 vi /etc/asterisk/manager.conf
;--- START ---
[vtiger]
secret=vtuser
deny=0.0.0.0/0.0.0.0
permit=127.0.0.1/255.255.255.0
permit=192.168.4.0/255.255.255.0
permit=192.168.4.8/255.255.255.0
read=system,call,log,verbose,command,agent,user,config,originate
write=system,call,log,verbose,command,agent,user,config,originate
;--- END ---


Code: Select all
vi /etc/asterisk/extensions.conf
; --- START ----
[vtiger_inbound]
exten => DID,1,Agi(agi://192.168.4.8/incoming.agi)
exten => _X.,1,Agi(agi://192.168.4.8/incoming.agi)
; --- END ---

; --- START ----
[vtiger_outbound]
exten => _X.,1,Agi(agi://192.168.4.8/incoming.agi)
; --- END ---



To be honest, I got confused with the extension, context and the trunk. I hope someone can give me a difference between the three and its uses. Cause Im a bit confused, and I might be pushing the wrong buttons.
edmund.uba
 
Posts: 21
Joined: Fri Feb 28, 2014 8:11 pm
Location: Davao City, Philippines

Re: vTiger on ViciBox 6.0

Postby mattyou1985 » Wed Aug 31, 2016 11:52 am

humm interesting i my self have been trying to find a deasent step by step yours looks good to try my self but i was wondering

how far did you get with it like whats not working and how intergrated is it ...user , user groups , out bound calling and inbound , web form post and pull data, call back intergration, ??

whats missing ?? or is it all good and dowing all of the above an mabe more
mattyou1985
 
Posts: 111
Joined: Tue Apr 19, 2016 3:30 pm

Re: vTiger on ViciBox 6.0

Postby williamconley » Sun Sep 04, 2016 7:32 pm

We've updated the interface a few times for a few clients to more recent versions of vTiger.

The integration is:
  • User Sync
  • Push Leads from Vicidial to vTiger (or link to existing lead if the lead is already there)
  • Search for lead is optional during the Push to vTiger (if I recall correctly)

Anything beyond these two simple functions requires more integration (as no one apparently ever paid for it). We've built several more intricate specialty integrations with both vTiger and SugarCRM over the years.

For instance: We have an appointement setting system designed to work with the Meeting Manager in SugarCRM to allow InHome Sales Reps in SugarCRM to have appointments set to keep them busy every day by Vicidial agents (who have NO access to Sugar, since they are merely telemarketers). All they do is fill the empty time slots for the Sales Reps. Then the Reps get a daily email and manage their appointments in Sugar as Meetings as they are expected to do without Vicidial.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: vTiger on ViciBox 6.0

Postby mattyou1985 » Wed May 10, 2017 7:14 pm

edmund.uba wrote:I got confused here, and here is the part where im definitely doing something wrong.

Code: Select all
 vi /etc/asterisk/manager.conf
;--- START ---
[vtiger]
secret=vtuser
deny=0.0.0.0/0.0.0.0
permit=127.0.0.1/255.255.255.0
permit=192.168.4.0/255.255.255.0
permit=192.168.4.8/255.255.255.0
read=system,call,log,verbose,command,agent,user,config,originate
write=system,call,log,verbose,command,agent,user,config,originate
;--- END ---


Code: Select all
vi /etc/asterisk/extensions.conf
; --- START ----
[vtiger_inbound]
exten => DID,1,Agi(agi://192.168.4.8/incoming.agi)
exten => _X.,1,Agi(agi://192.168.4.8/incoming.agi)
; --- END ---

; --- START ----
[vtiger_outbound]
exten => _X.,1,Agi(agi://192.168.4.8/incoming.agi)
; --- END ---



To be honest, I got confused with the extension, context and the trunk. I hope someone can give me a difference between the three and its uses. Cause Im a bit confused, and I might be pushing the wrong buttons.


well it took some time but i finley seen the ancer to your question

https://wiki.vtiger.com/vtiger6/index.php/PBX_Manager

c. Outbound Trunk = XYZ

It must match the trunk name added in FreePBX.


AKA a vicidial Phone Extension gs102 as defalt
mattyou1985
 
Posts: 111
Joined: Tue Apr 19, 2016 3:30 pm

Re: vTiger on ViciBox 6.0

Postby mattyou1985 » Fri May 12, 2017 3:58 pm

and if we have to install java i think this is the right one

https://github.com/asterisk-java/asteri ... /README.md

could be rong as ive still not got it working but finley ime getting closer
mattyou1985
 
Posts: 111
Joined: Tue Apr 19, 2016 3:30 pm

Re: vTiger on ViciBox 6.0

Postby mattyou1985 » Fri May 12, 2017 4:43 pm

this looks more to my liking and mabe to you to

https://sourceforge.net/projects/vtiger ... =directory
mattyou1985
 
Posts: 111
Joined: Tue Apr 19, 2016 3:30 pm


Return to ViciBox Server Install and Demo

Who is online

Users browsing this forum: No registered users and 55 guests