Topic: SugarCRM

[p-jones]

Has anyone come across a HOWTO for intergrating SugarCRM into 6.01 ? I have done heaps of searching but to no avail. I have noted from the post that it does appear to have been done.

Thank P

[Mjohnson]

Hi P...

I have not seen a HOW TO, but I recently installed Sugar CRM on my 6.01 server.  It went very well.  I installed it to its own Ibay of course.  

Have you tried the install yet?  The Sugar CRM directions are pretty good.

Mike

[p-jones]

I have got all the installation documentation, AND READ IT! Created the ibay and attempted to install it from the ibay. It doesnt like the /tmp location for session.save from php.ini.

I had a fiddle with the permissions of \tmp to no avail.I am only a novice so I am relectant to start playing with php.ini till I have a better handle on all it's instructions.

As I work through the install doc, I think there is probably quite a bit more info required that I dont know. Whether I will find that info through these pages remains to be seen. Whether I will trip over with the SME template system also remains to be seen.

[boss_hog]

Hey P,
the open_basedir is well documented here:

http://no.longer.valid/phpwiki/index.php/TroubleshootingFAQ#php_basedir

The following is the basic steps to get Sugar' up and running.
1) create new ibay <sugar>
2) move/copy sugar*.zip file to server
3) unzip archive
4) move files from within the newly created folder TO the /ibay/<sugar>/html dir
5) from the above dir, as root# chown -R admin:www *
6) create new database with MySQL or phpmyadmin, <sugardb>
7) create new mysql user <sugaruser> and <password>
give <sugaruser> full privileges to <sugardb>
9) reload MySQL
10) set your preferred browser to accept cookies and allow javascript
11) go to http://<server>/sugar/install.php
12) change permissions as needed by installer
13) follow intructions, enter the appropriate info for database etc.
14) start using the SugarCRM

As an FYI, the above instructions will get you up and running. Remember to change the config.php file to chmod 444.
Check the Sugar forums to harden your install!!

I don't use the SugarCRM, but I ran through the install to help answer your post.
Hope this helps get you rolling.
Joe

[p-jones]

Thanks heaps for that effor Joe. I will sit down quietly and work through those points.

Rgds
peter

[dilligaf]

Hey P,
the open_basedir is well documented here:

http://no.longer.valid/phpwiki/index.php/TroubleshootingFAQ#php_basedir

The following is the basic steps to get Sugar' up and running.
1) create new ibay <sugar>
2) move/copy sugar*.zip file to server
3) unzip archive
4) move files from within the newly created folder TO the /ibay/<sugar>/html dir
5) from the above dir, as root# chown -R admin:www *
6) create new database with MySQL or phpmyadmin, <sugardb>
7) create new mysql user <sugaruser> and <password>
give <sugaruser> full privileges to <sugardb>
9) reload MySQL
10) set your preferred browser to accept cookies and allow javascript
11) go to http://<server>/sugar/install.php
12) change permissions as needed by installer
13) follow intructions, enter the appropriate info for database etc.
14) start using the SugarCRM

As an FYI, the above instructions will get you up and running. Remember to change the config.php file to chmod 444.
Check the Sugar forums to harden your install!!

I don't use the SugarCRM, but I ran through the install to help answer your post.
Hope this helps get you rolling.
Joe

Hi Joe,
I just tried all of this, step by step, on SME 6.0.1.
No errors or anything, but the installer does not work?
http://MYREALSERVER/sugar/install.php
I get no errors, but it does not do anything either?

[boss_hog]

Hey dilligaf,
if you are trying to put it in an ibay, did you enable "execution of active content"?

Is your browser set to accept cookies and run java script?

Are you just getting a blank page?
Joe

[dilligaf]

Hey dilligaf,
if you are trying to put it in an ibay, did you enable "execution of active content"?

Is your browser set to accept cookies and run java script?

Are you just getting a blank page?
Joe

Hi,
Yes I have the "execution of active content"? enabled.
Yes on the browsers, have used same to load many others like Gallery, OneOrZero etc.

Looking at the requirements for Sugar CRM, they say you need:
Apache Web server(v1.3 or v2.0)
MySQL Server (v4.0, v4.1 or v5.0)
PHP (v4.3+)

My server is SME 6.0.1 and I have :
My Apache is 1.3.27-8 legacy
MySql is 3.23.58-1.73.6
PHP is 4.1.2-7.3.6es1

I tried to go about updating php by installing php-4.4.1-1eo.i386.rpm but it says it needs libiconv.so.2.

I searched for an rpm to satisfy that, and no go.

Stopped there, as I do not want to break the server.

[aaron]

Hey, Mjohnson and/or boss_hog:

Apparently you have gotten Sugar up & running.

Sadly, as dilligaf & I can attest, you run into issues on 601-01 with PHP & mySQL being out of date. I dont know if the mySQL is significant or not but the PHP appears to be a show-stopping requirement.

Can either of you (or preferabbly both!) elaborate on how you either got around this issue or upgraded. I trust you both were doing this on a 601 box?

It REALLY would be great to see this CRM product installable on e-smith.

Thnaks in advance!

[Mjohnson]

Hi Aaron...

I must say that joe is the master.. He helped me with a PHP configuration problem that was very puzzling, though not related to SugarCRM.

I am running SugarCRM on my 6.01 box.  I do have MySQL 4.0.22 installed, which may make a difference.  PHP is 4.3.10.  I also use phpmyadmin for setting up MySQL

Really all I did was follow the directions from SugarCRM.  

I am not sure where you are getting hung up, but if I can be of some help I would be happy to assist.

MJ

[CharlieBrady]

I have not seen a HOW TO, but I recently installed Sugar CRM on my 6.01 server.  It went very well.  I installed it to its own Ibay of course.

The "of course" is out of place. Installing applications into an i-bay is certainly easy, but it's unlikely to be the best thing to do from a security point of view, because it potentially exposes the code and configuration files for access via ftp, smb and appletalk.

Better practice would be to more closely follow the application's installation instructions, and use a custom template fragment to add the required section to httpd.conf.

[boss_hog]

Hey yall,
I am sorry for the confusion on the PHP and MySQL. The only test box avaiable at the time was an 6.5rc1. So I used that one to gather experience on the install of SugarCRM.

Hey, Mjohnson and/or boss_hog:

Apparently you have gotten Sugar up & running.

Sadly, as dilligaf & I can attest, you run into issues on 601-01 with PHP & mySQL being out of date. I dont know if the mySQL is significant or not but the PHP appears to be a show-stopping requirement.

Can either of you (or preferabbly both!) elaborate on how you either got around this issue or upgraded. I trust you both were doing this on a 601 box?

It REALLY would be great to see this CRM product installable on e-smith.

Thnaks in advance!

I will put togehter an SME 6.0 box and get back to this thread. I should be able to get some testing in by Sunday night.

I must say that joe is the master..

I only wish this were true!! The great people here in the E-smith/SME/Contribs community have taught me a lot. I share when I can.

The "of course" is out of place. Installing applications into an i-bay is certainly easy, but it's unlikely to be the best thing to do from a security point of view, because it potentially exposes the code and configuration files for access via ftp, smb and appletalk.

Better practice would be to more closely follow the application's installation instructions, and use a custom template fragment to add the required section to httpd.conf.

Thanks Charlie, all this time I have been doing this wrong. I had seen Gordon(I think) had pointed this out in another thread. Since that time I have been trying to (re)learn the proper way to install web apps.

When I put together the SME 6.0 box I will do the SugarCRM somewhere other than an ibay.

I'll be back!
Joe[/quote]

[boss_hog]

Hey yall,
as a follow up on this thread.
To no surprise at all, dilligaf is correct, both PHP and MySQL need to be upgraded.

The installer for SugarCRM wouldn't even start(blank screen) without upgrading PHP.
Then the installer would stop at the database creation.
After upgrading MySQL, the install would continue happily.

Be warned that upgrading PHP and MySQL *could* cause some issues with future upgrade paths for the SME itself.

The steps I used are as follows:
1) Fresh install of SME6.01-01
2) Install rpm-python-4.0.4-7x.18.i386.rpm
3) Install yum-1.0.7sme05.noarch.rpm
4) Install e-smith-phpmyadmin-2.6.0-12.noarch.rpm
5) Run yum update
6) Run /sbin/e-smith/signal-event post-upgrade
7) Run /sbin/e-smith/signal-event reboot
Download PHP upgrade script by Ergin Özdemir from here:
http://mirror.contribs.org/smeserver/contribs//ergozd/scripts/php4.3.11-upgrade.sh
9) Download MySQL upgrade script by Ergin Özdemir from here:
http://mirror.contribs.org/smeserver/contribs//ergozd/scripts/MySQL-4_0_25.sh
10) Run the 2 upgrade scripts
11) Run /sbin/e-smith/signal-event post-upgrade
12) Run /sbin/e-smith/signal-event reboot
Note: I am not sure that steps 10 and 11 are needed, but this is what I did
13) mkdir /home/httpd/html/sugar
14) Copy SugarSuite-3.5.1a.zip to server and unzip
15) Copy files from the SugarSuite dir to /home/httpd/html/sugar
16) cd /home/httpd/html/sugar and run the following command chown -R root:www *
17) create template fragment pico /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/95SugarCRM
18) The following is the contents of 95SugarCRM:
#----------------------#
# SugarCRM Testing
#----------------------#

Alias /sugar /home/httpd/html/sugar

<Directory /home/httpd/html/sugar>
AddType application/x-httpd-php .php .php3 .phtml
Options Indexes +Includes FollowSymLinks
order deny,allow
deny from all
allow from all
</Directory>

<Files /home/httpd/html/sugar/config.php>
order deny,allow
deny from all
</Files>

#--------------------------
# end SugarCRM fragment
#--------------------------

19) Expand the new fragment /sbin/e-smith/expand-template /etc/httpd/conf/httpd.conf
20) Restart apache /etc/rc.d/rc7.d/S85httpd-e-smith restart.
21) create new database with MySQL or phpmyadmin, <sugardb>
22) create new mysql user <sugaruser> and <password>
23) give <sugaruser> full privileges to <sugardb>
24) reload MySQL
25) set your preferred browser to accept cookies and allow javascript
26) go to http://<server>/sugar/install.php  
27) follow intructions, enter the appropriate info for database etc.
28) start using the SugarCRM

There you have it.
I used info from Ray Mitchell and Ergin Özdemir to put the above together.
If anyone else can add, subtract, or make corrections to my testing, PLEASE do!
Hope this helps.
Joe

Edited to correct php upgrade link 12/12/05.

[dilligaf]

Download PHP upgrade script by Ergin Özdemir from here:
http://mirror.contribs.org/smeserver/contribs//ergozd/scripts/php-4.4.1-upgrade.sh
If anyone else can add, subtract, or make corrections to my testing, PLEASE do!
Hope this helps.
Joe

Hi Joe, on my clean 6.0.1 server, this is what I get when I try and run the php update:
[root@merlin PHP upgrade script]# sh php4.4.1-upgrade.sh
Upgrading your PHP to version 4.4.1...
Preparing...                ########################################### [100%]
   1:php                    warning: /etc/php.ini created as /etc/php.ini.rpmnew
########################################### [ 12%]
   2:php-devel              ########################################### [ 25%]
   3:php-imap               ########################################### [ 37%]
   4:php-ldap               ########################################### [ 50%]
   5:php-mysql              ########################################### [ 62%]
   6:php-snmp               ########################################### [ 75%]
   7:unixODBC               ########################################### [ 87%]
   8:php-odbc               ########################################### [100%]
Shutting down http:                                        [   OK   ]
Starting httpd: Syntax error on line 138 of /etc/httpd/conf/httpd.conf:
Cannot load /usr/lib/apache/libphp4.so into server: libiconv.so.2: cannot open shared object file: No such file or directory
                                                           [ FAILED ]
serviceControl: Couldn't system(/etc/rc.d/rc7.d/S85httpd-e-smith, restart):
Couldn't restart httpd-e-smith at /etc/e-smith/events/actions/restart-httpd-full line 45.
 DONE........
[root@merlin PHP upgrade script]#

[boss_hog]

Hey dilligaf,
sorry about that. It should point to php4.3.11-upgrade.sh
Here is the correct link:
http://mirror.contribs.org/smeserver/contribs//ergozd/scripts/php4.3.11-upgrade.sh

To anyone else following this, my previous post will be edited to show the correct link.
Joe