Topic: HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator

[k0r54]

Ok everything has loaded and is working rly sweet.

Thanks VERY much for all your help especially william!

tariqf can i suggest u modify your install for william it is must faster and simpler.

Thanks
k0r54

[william_syd]

Ok everything has loaded and is working rly sweet.

Thanks VERY much for all your help especially william!

tariqf can i suggest u modify your install for william it is must faster and simpler.

Thanks
k0r54

Thanks, but it was tariqf's how to that laid the groundwork.

[k0r54]

Hi,

Yes i am aware of that, and i appologise for it sounding like that.

I just think it would be more beneficial to modify the tut on the first page to more this one as it is easier to follow.

Thanks again
k0r54

[batje]

halfway all this work you discover there is someone who made a nice eaccelarator rpm and use that.

http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=viewsdownload&sid=53

works perfectly.

[piran]

...someone who made a nice eaccelarator rpm and use that.
http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=viewsdownload&sid=53
works perfectly.

Agreed, it certainly does.

[k0r54]

Hi

There was an updated version out and I wsn't sure how to update it so i deleted the whole folder and then downloaded the new one and went through the process.

Everything is working as it should be but is there an easier way to upgrade?

Thanks
k0r54

[sonoracomm]

Hi Folks,

I was just trying to install SugarCRM by using this thread and William's notes here:"

Code: [Select]

http://magicwilly.webhostingpal.com/SME7%20How%20To%20Files/sugarcrm/sugar.txt
Additionally, I'm using the latest SugarOS and SME 7.1.2, though I don't know if that makes a difference.

I have beat this up and I know what the problem is (I think), but I don't know how to fix it as I'm no Apache wizard.

When I open up the alias in the web browser, the install.php page appears, but the graphics on the page do not.  Further, if I click on the start button, Firefox reports "The page isn't redirecting properly".

There also appears a line in /var/log/httpd/access_log which shows the problem with a link to a graphic on the install.php page:

Code: [Select]

familycooper.org 192.168.2.50 - - [20/Mar/2007:12:26:53 -0700] "GET /crm/install.phpcrm/install.phpcrm/install.phpcrm/install.phpcrm/install.php
crm/install.phpcrm/install.phpcrm/install.phpcrm/install.phpcrm/install.phpcrm
/install.phpcrm/install.phpcrm/install.phpcrm/install.phpcrm/install.phpcrm/
install.phpcrm/install.phpcrm/install.phpcrm/install.phpcrm/install.phpcrm/
include/images/sugar_md.png HTTP/1.1" 302 559 "https://sol.familycooper.org/crm/install.php"
"Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.2) Gecko/20060601 Firefox/2.0.0.2 (Ubuntu-edgy)"
The "Alias" doesn't seem to be functioning as I expect it to.  The URL get's corrupted and the links are not found.  I know I have seen something like this before...

I suspect I need to fix the httpd.conf fragment, but my experimentation has not been successful.

Here is the fragment I have as of now:

Code: [Select]

# SugarCRM
Alias /crm /opt/sugar/SugarOS-Full-4.5.1
<Directory /opt/sugar/SugarOS-Full-4.5.1>
    SSLRequireSSL on
    Options -Indexes
    AllowOverride all
    order deny,allow
    deny from all
    allow from all
    Satisfy all
    AddType application/x-httpd-php .php .php3
    php_admin_value open_basedir /opt/sugar/SugarOS-Full-4.5.1/:/tmp
    php_flag  magic_quotes_gpc  on
    php_flag  track_vars        on
</Directory>
Anyone have any ideas for me?

Thanks,

G
p.s.  This behavior happens before and after installing the acceleration stuff...

[william_syd]

Hmm.. that was my rough text file.

Here is my rough wiki.. lol  http://magicwilly.webhostingpal.com/phpwiki/index.php?pagename=How%20to%20install%20sugarCRM

Maybe the bit about a blank line above and below the httpd.ini fragment ?

Oh.. I also use https exclusively. You may want to drop the "SSLRequireSSL on".

I've had problems before where web apps have set in their config to use http for base url which messed up images.

[sonoracomm]

Hi William,

Thanks for your assistance.

You were correct about the problem having to do with SSL.  I commented out the "SSLRequireSSL on", re-expanded the httpd.conf file and it works without SSL.

After starting the install.php procedure, the system check showed an invalid version of PHP installed.  I assume that's why I had to comment out the line in install.php?

After the installation, I then ran into my first problem...

Evidently, even though I just downloaded the latest version, a new version already came out.  Apparently, the easiest way to update is with the Upgrade Wizard in the admin control panel.  However, it performs the same (or similar) system check as the main installation and fails.

So, the question is this, how would we keep our SugarCRM installations up to date?

Are there any other known repercussions to using the PHP 4.3.9 that is on SME Server?

Thanks again,

G

[tariqf]

can't work out how to edit the original post so here's an update to make sure sugarcrm upgrades work + a few other fixes in instructions;

* download sugarcrm
* create an ibay called sugarcrm
* extract files to the ibay, remove the html dir and rename the sugar dir to html
* chmod -R 775 cache custom data modules
* chmod 664 config.php
* /sbin/e-smith/db accounts setprop sugarcrm PHPBaseDir /home/e-smith/files/ibays/sugarcrm/:/tmp
* /sbin/e-smith/signal-event ibay-modify sugarcrm
* download php-json version 1.1.1 end extract
* yum --enablerepo=* install gcc gcc-c++
* cd to php-json folder and run ./configure, make and make install
* mkdir -p /etc/e-smith/templates-custom/etc/php.ini
* edit /etc/e-smith/templates-custom/etc/php.ini/70extras and add
  extension=json.so
  extension="eaccelerator.so"
  eaccelerator.shm_size="16"
  eaccelerator.cache_dir="/tmp/eaccelerator"
  eaccelerator.enable="1"
  eaccelerator.optimizer="1"
  eaccelerator.check_mtime="1"
  eaccelerator.debug="0"
  eaccelerator.filter=""
  eaccelerator.shm_max="0"
  eaccelerator.shm_ttl="0"
  eaccelerator.shm_prune_period="0"
  eaccelerator.shm_only="0"
  eaccelerator.compress="1"
  eaccelerator.compress_level="9"
* expand-template /etc/php.ini
* edit install.php from your sugarcrm ibay and comment out the line "$workflow[] = 'checkSystem.php';" with preceding //
* edit modules/UpgradeWizard/uw_utils.php and comment out these 4 lines just below where it says "switch($check_php_version_result) {"
//case -1:
//      $ret['phpVersion'] = "<b><span class=stop>{$installer_mod_strings['ERR_CHECKSYS_PHP_INVALID_VER']} {$php_version} )</span></b>";
//      $ret['error_found'] = true;
//      break;
* install smeserver-mod_deflate-1.0-1.noarch.rpm
* download latest eaccelerator and extract go through the install instructions in the README
* yum remove gcc gcc-c++
* /etc/init.d/httpd restart
* fire up a web browser and browse to http://yourserver/sugarcrm and proceed with standard sugar install.

tested on fresh installs of sme 7.0,7.1.x,7.2

[HomePlayer]

Dear Tariqf
thanks for all the great work, i realy like the Sugar CRM.

But i am not sure if this is the best way of installing it?

The right way to do this is for someone to package up the relevant packages as RPMs. The files should not be installed in a i-bay, but should be installed outside the web server space and the required parts aliased into the web server space (see Horde/IMP for an example). Critically, the files, must not be writable by the web server. The configuration file may need write access during installs, but should be locked down after that.

You are using a i-bay, way not /opt/sugar?
FAQ: Should I trust/follow the advice I get in this forum?

I will follow this topic whit great care, cause i realy like/need sugar.

I did install Sugar 2 or 3 times now into VMserver, every time i had to create the SQL db by hand;

Code: [Select]

[root@vmsme1 ~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 607 to server version: 4.1.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE DATABASE sugarcrm;
Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON sugarcr.* TO sugar_admin-crm@localhost IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye
to get it to work

[tariqf]

Hello homeplayer yes this is not the easiest way to install sugarcrm but I prefer it this way as it means I can install it on any version of SME and also download/use  the package versions I choose e.g. latest versions at the time of install. If I made RPM's then I would have to update them each time a new version comes out or make a repository.

I will look at the DB creation part and get back to you....

Regards

[tariqf]

Hi forgot to say I like to have it in an ibay because;

* can see it in the server-manager so I can see if the server I'm on has it installed without commandline
* can use htaccess password protection for access as additional level of security
* can control access on use/group level via server-manager

[stephen noble]

We all love SME because everything just works out of the box

If more users could contribute by spending the time to create the rpms of their favourite applications we would all benefit

The developers have said over and over for years the correct way to install software is with rpms
here's how to package your application
http://wiki.contribs.org/Generic_WebApp_rpm

[tariqf]

I don't want to package it and I prefer this method as I have full control over the compilation and package versions each time I do an install. I am purely sharing the method in which I install sugarcrm. Will put my howto's on our website and not put any more info that involves compiling in the forums as I understand people may like to use rpm's for simplicity.

When I get time will update my website and add the howto section if anyone is interested it will be on www.yourproblemsolved.com in the coming weeks.