PIAF SugarCRM CE install program

[darmock]

We decided to write an easy install program for installing the latest SugarCRM CE program onto PBX in a Flash 1.7.5.X. We have also created an install (basic) document with screen caps for the procedurally challenged

DOWNLOAD AND READ THE INSTRUCTIONS FIRST PRETTY PLEASE


Here is what it will do

1. Check for the correct version of PHP. Currently all default PIAF installs user php 5.1. SugarCRM CE requires at a minimum php 5.2. The installer will install PHP 5.3.8.x. What is the down side? You wont be able to run the freepbx commercial modules as they don't support php 5.3 yet.

2. Once the correct version of PHP is installed and configured it will install SugarCRM CE onto your PIAF server. We are currently using 6.3.0 RC2 for this. 6.4 beta1 just came out today but we will hold off on that till it is more stable.

3. As the install-sugarcrm finishes you will be prompted to write down some information you will need when you continue with the GUI setup in a browser. I recommend you follow our recommendations or the GUI based setup will NOT work.

4. Enjoy. We cannot provide you with any assistance beyond getting SugarCRM CE installed. This is not an offer for free technical support either.

5. We also don't recommend you install SugarCRM CE onto your PIAF server. Why is this????? Your PIAF server should ONLY run asterisk and not anything else that could suck processor and memory resources. Even with a super server with multiple processors and an obscene amount of ram it is still possible, in large installs, to make the quality of your simultaneous phone calls go way down. If you run SugarCRM CE on a separate server then you have minimized what to look for when your phone calls go to crap. However since people who use PIAF tend to be hearty individualists they like to do things there way and make up their own minds so have at it! Hopefully this explains in painful detail why you MAY want to run SugarCRM CE on a separate system from ASTERISK. This point is covered somewhat in the directions you download first and read.. right?



How do I get it?

1. Get the document and READ IT.

wget http://pbxinaflash.org/1755/docs/install-sugarcrm.pdf

2. Until the install-sugarcrm has been tested it is only available from the developer site so in step 1 of the written documentation you have to do a

update-program -d

instead of

update-programs

Eventually this will be available using update-programs once it has been pushed out into PIAF space.


3. Follow the written directions!

That is it.


Tom

Sorry for the rant late tonight.

 

[ou812]

I'm a little confused.
"We decided to write an easy install program for installing the latest SugarCRM CE program onto PBX in a Flash 1.7.5.X."
" We also don't recommend you install SugarCRM CE onto your PIAF server."

Gary

 

[darmock]

Why are you confused. We firmly believe you have the right to go to hell in your own way!

Some people ignore advice and do it anyway so why not give them the best chance for having a good install?

That being said simply do the following

Create a qemu or vmware client

1. Install PIAF
2. install-sugarcrm
3. edit rc.local and comment out all of the stuff that starts asterisk
4. chkconfig dahdi/zaptel off
5. Reboot

Poof sugarcrm server that is not running asterisk but has a lamp stack that works.

Want to roll your own then go ahead.

I have installed sugarcrm on a number of systems. Small companies with one or two employees seem to function OK with sugar running on the PIAF server. When they get bigger they may not work so well. It seems to me we outlined this in the document. You did download and read the doc right?

Here is the snippet out of the documentation.

SugarCRM CE has the ability to be run on a PBX in a Flash Server 175x and use the installed LAMP stack. This allows small businesses to keep costs down by utilizing their existing PBX in a Flash server. That being said if your company is larger than 3-4 people you might want to consider running SugarCRM CE on a separate server or under virtualization. Using your PBX in a Flash server for anything other than phone calls can degrade your audio quality and render the system unusable. IT IS RECOMMENDED YOU INSTALL SUGARCRM CE ONTO IT”S OWN SERVER!


Does this answer the question adequately? I also updated the first post to help others thanks....


Tom

 

[airix]

Just tried out the install. Thanks for the script!

Question though, I don't have any previous experience with sugarcrm, and looking at the this version, what is the best way to integrate this with asterisk? Seems like none of the asterisk plugins are not supported in this version? The main things I'm interested in are the click to dial and a contact popup when on incoming calls.

 

[Ramblin]

Asterisk Telephony Integration

I installed SugarCRM and PBXiaf on the same server (sorry Tom). The installation is for a start-up with only 2 employees and it has been working fine for about a year.

I am now on Asterisk 1.8 and SugarCRM 6.2.4 and it still works fine. I only went to php 5.2.10 - SugarCRM needs that as a minimum to work - and all FreePBX modules I have installed (no commercial versions, all free ones) are working fine.

To get the Asterisk integration, look at the ADAT utility from www.tttelecom.nl. Go to http://www.tttelecom.nl/index.php/en/products/adat and click on the R2 version of ADAT. The only thing not yet working is the passing of CallerID for automated screen calls but the rest is working well: Balloon pup-ups, Extension monitoring from your PC, Click-toDial from a web site (Need the Firefox plug-in to work on Firefox up to v6, no plug-in yet for FF7), ...

If you want full integration - once the CallerID passing thing is solved in ADAT, take a look at AsteriskSugarDirector at http://www.sugarforge.org/projects/sugardirector. It works like a charm. The last one I downloaded did not strip spaces out of the phone numbers so I adapted it to do that. If you want that version, let me know.

 

[darmock]

I installed SugarCRM and PBXiaf on the same server (sorry Tom)

No reason to be sorry. We run it on the lab's main piaf install and it works just fine. We have 4-5 users both local and remote with never a problem. Course the machine is kind over engineered nothing like dual/quad with obscene amount of ram. The warning is there for the newbs that don't understand what it all means. Indeed most non linux guru types have no idea what happens when you add in more and more programs onto a server and then wonder why it doesn't work or phone calls sound like they are in a vat of molasses.

Better to warn them that it will break their system as opposed to my favorite "You never told me that.....".

As for php version yup 5.2.x works but PIAF is heading to php 5.3 as a base standard instead of working up through the 5.2 and some of its problems.

Will look at your recommendation and see if it can be installed at the same time as sugar.


Tom

 

[airix]

If you want full integration - once the CallerID passing thing is solved in ADAT, take a look at AsteriskSugarDirector at http://www.sugarforge.org/projects/sugardirector. It works like a charm. The last one I downloaded did not strip spaces out of the phone numbers so I adapted it to do that. If you want that version, let me know.

I tried this and it works nicely.. too bad ADAT can't pass the callerid. I was contemplating on modifying sugardirector to do a lookup based on name but that would entail modifying all my sugarcrm records to match callerid.
I tried quite a few call notifiers that are supposed to open a web page passing the callerid but no such luck - must be a Asterisk 1.8 thing?? Unless someone here knows of one that works properly?

 

[Ramblin]

Yes,

ADAT did it all on Asterisk 1.4, partially broke on 1.6 and lost the CallerID passing completely on 1.8

They are working on it though not as a high priority

 

[rlm]

sugarcrm install has broken amportal

Hi,

I have just tried the install-sugarcrm script.

It detected that I needed to update php, which it did and then rebooted the system. However since the reboot I can no longer get amportal working. Asterisk needed to be started as well.

Has anyone seen this and how can I get amportal back?

Thanks

rlm

 

[darmock]

As usual people dont provide enough info. Output of status program. Unedited. I suspect you are using 1757 since it asked to update php.

Tom

 

[rlm]

status output

Here is a screen shot for the status and versions.

Please let me know if you need anything else.

 

[rlm]

Just in case

Asterisk = ONLINE | Dahdi = ONLINE | MySQL = ONLINE │
│ SSH = ONLINE | Apache = ONLINE | Iptables = ONLINE │
│ Fail2ban = ONLINE | Internet = ONLINE | Ip6Tables = ONLINE │
│ BlueTooth = OFFLINE | Hidd = OFFLINE | NTPD = ONLINE │
│ SendMail = ONLINE | Samba = OFFLINE | Webmin = ONLINE │
│ Ethernet0 = ONLINE | Ethernet1 = N/A | Wlan0 = N/A │
│ │
│ PBX in a Flash Version = 1.7.5.7 Running on *HARDWARE* │
│ FreePBX Version = 2.9.0.9 │
│ Running Asterisk Version = 1.8.7.2 │
│ Asterisk Source Version = 1.8.7.2 │
│ Dahdi Source Version = 2.5.0.2+2.5.0.2 │
│ Libpri Source Version = 1.4.12 │
│ IP Address = 192.168.1.199 on eth0 │
│ Operating System = CentOS release 5.7 (Final) │
│ Kernel Version = 2.6.18-274.3.1.el5 - 32 Bit

 

[darmock]

php -v

also what do you mean exactly when you say you cant get amportal?

Tom

 

[rlm]

Update

php -v


PHP 5.2.17 with Suhosin-Patch 0.9.7 (cli) (built: Jan 10 2011 15:41:34)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2010 Zend Technologies

The FreePBX web pages are no longer accessible. So I get the landing page, but when I click on FreePBX, nothing loads.

 

[darmock]

You are using an unsupported version of PHP!

You should have either 5.1.6 or 5.3.3.8-1

We DONT SUPPORT ANY OTHER VERSION OF PHP on 1757.

If you ran our install-sugarcrm program it would have installed 5.3.3.8-1. We have NOT written any version of our programs that uses 5.2.1.7. So you must have installed it by hand or by some other means.

Part of the install process of sugar is it downloads and installs php 5.3.x from our static repos via a program called update100. so I have no idea. I assume you enjoy tinkering. good luck.

I would just scrub and install 2062x which only supports php 5.3 and higher and WORKS.

Tom

 

[Ramblin]

ADAT now passes CallerID

A quick update

The current version of ADAT (v 7.12) does now pass CallerID on Asterisk 1.8 (always did on 1.4)

Use it with AsteriskSugarDir (see earlier post) and you can have the Sugar contact screen pop up when a call comes in from a number it has for the contact.

 

[TheShniz]

Just to confirm my sanity... are you able to get ADAT to work w/ Outlook 2010 x64? (I never have been able)

 

[Ramblin]

ADAT on Outlook

No, ADAT does not allow click-to-dial from within Outlook. That is a Microsoft issue. You need to implement a TAPI-based integration with Microsoft products and the last Asterisk-TAPI tool I found - that does not work for me - was for 32-bit.

I have Outlook running on a 64-bit machine with Windows 7 Pro 64-bit OS. The Outlook version I am running is 32-bit Office 10 (per Microsoft recommendations)

Too bad, I would like it too.

You can set ADAT up to pull the Outlook Contact name/number into ADAT, but I did not like that too much.