Koozali.org: home of the SME Server

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

Offline tariqf

  • ****
  • 179
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« on: January 04, 2007, 08:36:24 PM »
--updated thanks to feedback----:

* 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 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';
* 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.

Works pefect on my sme7.1 with sugar 4.5.0h

guest22

HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #1 on: January 05, 2007, 08:07:42 PM »
Is there any specific reason you want to change the default MySQL password? Changing the MySQL root password will break other 'stock' things.

guest

Offline Amir Inbar

  • *
  • 113
  • +0/-0
    • http://www.sheroot.net
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #2 on: January 05, 2007, 09:11:29 PM »
where do you find php-json 1.1.1 ?
......

Offline tariqf

  • ****
  • 179
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #3 on: January 05, 2007, 09:59:21 PM »
php-json 1.1.1
http://www.aurore.net/projects/php-json/php-json-ext-1.1.1.tar.bz2

No specific reason for changing mysql password I just did it for security - you are totally right I get some mysql errors on boot although everthing appears to be workign fine. Maybe someone can tell me how to correctly change the mysql password in sme7? I think a blank password for root is no good if you're opening up ibays to the world like I am.

Offline Amir Inbar

  • *
  • 113
  • +0/-0
    • http://www.sheroot.net
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #4 on: January 05, 2007, 10:51:21 PM »
Thank you.

i get :

Code: [Select]
[root@shsrv07 php-json-ext-1.1.1]# ./configure
checking for gcc... gcc
checking for C compiler default output... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking whether gcc and cc understand -c and -o together... yes
checking if compiler supports -R... no
checking if compiler supports -Wl,-rpath,... yes
./configure: line 2572: php-config: command not found
configure: error: Cannot find php-config. Please use --with-php-config=PATH

......

Offline tariqf

  • ****
  • 179
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #5 on: January 06, 2007, 11:46:29 AM »
you need

yum install php-devel i think, must have missed this off the howto

Offline gordonr

  • *
  • 646
  • +0/-0
    • http://www.smeserver.com.au/
Do NOT change the MySQL root password
« Reply #6 on: January 06, 2007, 01:57:58 PM »
Quote from: "tariqf"

No specific reason for changing mysql password I just did it for security


I can pretty much guarantee that the MySQL root password you chose was less secure than the autogenerated one we install automatically on each SME Server.

It is a long string of random junk, and it is different on every server.

It is automatically configured in the appropriate places (e.g. /root/.my.cnf) so that root can create and manage MySQL databases.

You do not need to know it, and you do not need to change it.

You should never need to use it except to create databases.

You should never use it for application access. Any configuration file which accesses MySQL as root using the MySQL root password is wrong.

Create a separate user for each application and grant only the access required for that application over the tables it needs.

Changing the MySQL root password will break backups.

Please don't change it. There is no need.

Quote from: "tariqf"

I think a blank password for root is no good if you're opening up ibays to the world like I am.


It is not blank by default and a properly configured application should never use the MySQL root password.
............

Offline gordonr

  • *
  • 646
  • +0/-0
    • http://www.smeserver.com.au/
Re: HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eacceler
« Reply #7 on: January 06, 2007, 02:04:11 PM »
Quote from: "tariqf"
* set mysql root password with mysqladmin -u root password yourpassword

No. You don't neeed to change the MySQL root password on an SME Server. Ever.
Quote from: "tariqf"

* chmod 777 -R for data, cache, modules, custom and 777 for config.php

No. This makes all files writable by all users, including the web server. This is an excellent way to allow your web site to be attacked and possibly to allow further attacks on the server.
Quote from: "tariqf"

* yum install gcc gcc-c++

No. Don't include compilers on external servers.
Quote from: "tariqf"

Works pefect on my sme7.1 with sugar 4.5.0h

It may work, but it's far from perfect. I suspect you have left your system vulnerable to attack.
............

Offline tariqf

  • ****
  • 179
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #8 on: January 06, 2007, 02:13:47 PM »
thanks for your input guys I've learnt a thing or two about sme! Now that I managed to change the mysql password thereby screwing the original autogenerated one how can I regenerate the mysql password so that everything is back to normal?

Also I will take your advice and change the permissions for those dirs and also remove the compilers. I assume it's ok to install and use compilers and then yum ininstall them when no longer needed.

I will also be updating the howto extensively to include all these new revalations to me and will up this along with a handfull of others onto my website.

Thanks

Offline gordonr

  • *
  • 646
  • +0/-0
    • http://www.smeserver.com.au/
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #9 on: January 07, 2007, 12:41:00 AM »
Quote from: "tariqf"
thanks for your input guys I've learnt a thing or two about sme! Now that I managed to change the mysql password thereby screwing the original autogenerated one how can I regenerate the mysql password so that everything is back to normal?

The bug tracker has a long list of documentation bugs waiting to be moved into the FAQ. This one is documented here:

http://bugs.contribs.org/show_bug.cgi?id=778

For those interested in helping with the FAQ, please join the docteam list at lists.contribs.org/mailman and let's get it up-to-date.

Quote from: "tariqf"
I assume it's ok to install and use compilers and then yum ininstall them when no longer needed.

My apologies - I didn't see that you removed them later in your instructions.

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.
............

Offline k0r54

  • ***
  • 111
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #10 on: January 22, 2007, 10:54:56 AM »
wat version of sugar do I need to download?

How do i extract it?

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #11 on: January 22, 2007, 01:58:07 PM »
Quote from: "k0r54"
wat version of sugar do I need to download?


Look here.
Regards,
William

IF I give advise.. It's only if it was me....

Offline k0r54

  • ***
  • 111
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #12 on: January 22, 2007, 05:22:37 PM »
Hi,

Yeah I noticed that after posting but I still need to know how to extract.

Thanks
k0r54

Offline tariqf

  • ****
  • 179
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #13 on: January 22, 2007, 05:25:57 PM »
if its a .tar.gz use

tar zxvf filename

if its a tar.bz2

tar jxvf filename


use

man tar

for more info

Offline k0r54

  • ***
  • 111
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #14 on: January 22, 2007, 05:36:33 PM »
the version to download only seems to be .zip?

Offline tariqf

  • ****
  • 179
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #15 on: January 22, 2007, 05:38:00 PM »
oh right in that case

unzip filename

Offline k0r54

  • ***
  • 111
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #16 on: January 22, 2007, 05:52:29 PM »
what bit of code is it that changes the mysql password? I dont want to change mysql's root password

Offline k0r54

  • ***
  • 111
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #17 on: January 22, 2007, 07:28:23 PM »
You wrote

Quote

download latest eaccelerator


What does this mean exactly, what eccelerator and where from? Also where would i extract too?

Ok, I have continued over that issue so i dont know but when i go to servername/sugarcrm i get a 403 forbiden error.

Also when u said look at the readme i done that but there is no install instructions so how do i install it?

Cheers

duncan

HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #18 on: January 22, 2007, 10:39:29 PM »
There is a vtiger rpm available that will give you a working setup of vtiger.
http://forums.contribs.org/index.php?topic=34534.0

The above howto is not detailed enough (and has a couple of errors in it) for a step by step install.

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #19 on: January 22, 2007, 10:52:20 PM »
Quote from: "k0r54"
the version to download only seems to be .zip?


man unzip
Regards,
William

IF I give advise.. It's only if it was me....

Offline k0r54

  • ***
  • 111
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #20 on: January 23, 2007, 10:11:19 AM »
Hi,

How does vtiger size up to sugarcrm? I have only used sugar.

What errors are in this tutorial thay may be causing the error I am getting?

Thanks
k0r54

duncan

HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #21 on: January 23, 2007, 10:25:31 AM »
Quote from: "k0r54"
Hi,

How does vtiger size up to sugarcrm? I have only used sugar.

What errors are in this tutorial thay may be causing the error I am getting?

Thanks
k0r54


vtiger is a fork of sugar. Check it out > http://www.vtiger.com/

Offline k0r54

  • ***
  • 111
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #22 on: January 23, 2007, 10:54:04 AM »
Hi,

Putting them side by side I think i do prefer sugarcrm.

Thanks though, i appreciate the alternative.

So what errors are there on this tutorial? some things I should have done?

Thanks
k0r54

duncan

HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #23 on: January 23, 2007, 11:22:18 AM »
Do a search for eaccelerator  on this site - you will find a version by mastersleepy (I think) - you will not need the php.ini template for this version.

Both eaccelerator and mod_deflate are not needed for this install - but will perhaps speed things up. This install should really be done outside the ibays.

Look in /var/logs/httpd/error_log to see why you are receiving errors.

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #24 on: January 23, 2007, 11:37:59 AM »
Quote from: "k0r54"
Hi,

Putting them side by side I think i do prefer sugarcrm.

Thanks though, i appreciate the alternative.

So what errors are there on this tutorial? some things I should have done?

Thanks
k0r54


This will get you started.

Code: [Select]
mkdir -p /opt/sugar
cd /opt/sugar


Code: [Select]
wget http://www.sugarforge.org/frs/download.php/2407/SugarOS-4.5.0h.zip
unzip SugarOS-4.5.0h.zip


Code: [Select]
chown -R www:www /opt/sugar/SugarOS-Full-4.5.0h

Code: [Select]
mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf
nano -w /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/86sugar


Paste the following in with a blank line top and bottom.

Code: [Select]

# sugar
Alias /sugar /opt/sugar/SugarOS-Full-4.5.0h
<Directory /opt/sugar/SugarOS-Full-4.5.0h>
    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_flag  magic_quotes_gpc  on
    php_flag  track_vars        on
</Directory>


Code: [Select]
Control-X yes enter

Code: [Select]
expand-template /etc/httpd/conf/httpd.conf
/etc/rc.d/rc7.d/S86httpd-e-smith restart


https://your_server/sugar

See how that goes.

No php acceleration included.

You may need the phpmyadmin-multiuser contrib to help with the db.

You still need this hack
Quote
* edit install.php from your /opt/sugar/SugarOS-Full-4.5.0h directory and comment out the line $workflow[] = 'checkSystem.php';

Try without the hack first to see why you need it.
Regards,
William

IF I give advise.. It's only if it was me....

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #25 on: January 23, 2007, 01:07:57 PM »
Here is the php speed up bit...

Code: [Select]
cd /usr/lib/php4
wget http://www.magicwilly.webhostingpal.com/SME7%20How%20To%20Files/sugarcrm/json.so


Code: [Select]
mkdir -p /etc/e-smith/templates-custom/etc/php.ini
nano -w /etc/e-smith/templates-custom/etc/php.ini/70extras


Paste the following.
Code: [Select]
extension=json.so

Code: [Select]
Control-X yes enter

Code: [Select]
expand-template /etc/php.ini
/etc/rc.d/rc7.d/S86httpd-e-smith restart


You can get the other stuff here....

http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=viewdownload&cid=6
Regards,
William

IF I give advise.. It's only if it was me....

Offline k0r54

  • ***
  • 111
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #26 on: January 23, 2007, 03:57:38 PM »
Hi,

I have run through ur tut and downloaded, installed and activated mod_deflate and i have downloaded and install phpmyadmin-multiuser but dont know wat to do with it.

I had to remark the php.ini hack and im gettin to the stage on sugar but im gettin an error when creating database

Code: [Select]
Database admin user name and/or password is invalid (Error 1045: Access denied for user 'admin'@'localhost' (using password: YES))

I dont know wat the username and password is, i have tried both admin and root?

Any ideas on how to use the phpmyadmin-multiuser?

Thanks
k0r54

Offline bpivk

  • *
  • 908
  • +0/-0
    • http://www.bezigrad.com
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #27 on: January 23, 2007, 06:36:56 PM »
login as admin/admin and then change the password.
"It should just work" if it doesn't report it. Thanks!

Offline k0r54

  • ***
  • 111
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #28 on: January 23, 2007, 06:44:59 PM »
Hey,

Log into wat as admin/admin?

Edited - Sorry sorted! the database username and password

Thanks
k0r54

Offline bpivk

  • *
  • 908
  • +0/-0
    • http://www.bezigrad.com
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #29 on: January 23, 2007, 06:56:35 PM »
Quote from: "k0r54"
Any ideas on how to use the phpmyadmin-multiuser?


Go to phpmyadmin webpage. I think that it's https://server/myadmin
and then enter username admin and password admin. Then change the pass.
"It should just work" if it doesn't report it. Thanks!

Offline k0r54

  • ***
  • 111
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #30 on: January 23, 2007, 07:53:09 PM »
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

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #31 on: January 24, 2007, 05:51:59 AM »
Quote from: "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


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

IF I give advise.. It's only if it was me....

Offline k0r54

  • ***
  • 111
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #32 on: January 24, 2007, 10:00:39 AM »
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

or....
« Reply #33 on: January 28, 2007, 09:26:24 AM »
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.

Offline piran

  • ****
  • 502
  • +0/-0
Re: or....
« Reply #34 on: January 28, 2007, 07:04:50 PM »
Quote from: "batje"
...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.

Offline k0r54

  • ***
  • 111
  • +0/-0
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #35 on: February 12, 2007, 06:15:21 PM »
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

Offline sonoracomm

  • *
  • 208
  • +0/-0
    • http://www.sonoracomm.com
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #36 on: March 20, 2007, 08:58:38 PM »
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...

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #37 on: March 21, 2007, 03:54:43 AM »
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.
Regards,
William

IF I give advise.. It's only if it was me....

Offline sonoracomm

  • *
  • 208
  • +0/-0
    • http://www.sonoracomm.com
HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #38 on: March 21, 2007, 05:34:25 AM »
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

Offline tariqf

  • ****
  • 179
  • +0/-0
Re: HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #39 on: October 08, 2007, 02:51:04 PM »
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

Offline HomePlayer

  • **
  • 55
  • +0/-0
Re: HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #40 on: October 09, 2007, 09:42:02 AM »
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

Offline tariqf

  • ****
  • 179
  • +0/-0
Re: HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #41 on: October 09, 2007, 10:39:43 AM »
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

Offline tariqf

  • ****
  • 179
  • +0/-0
Re: HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #42 on: October 09, 2007, 10:48:04 AM »
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


Offline stephen noble

  • *
  • 607
  • +1/-0
    • Dungog
Re: HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #43 on: October 09, 2007, 11:13:00 AM »
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

Offline tariqf

  • ****
  • 179
  • +0/-0
Re: HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #44 on: October 09, 2007, 11:24:30 AM »
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.





Offline HomePlayer

  • **
  • 55
  • +0/-0
Re: HOWTO: SME7.1 SugarCRM + php-json, mod_deflate, eaccelerator
« Reply #45 on: October 09, 2007, 04:15:15 PM »
Oke Tariqf, lets try

thanks for your quick replay,

in your last howto, i had to install yum install php-devel before i could run ./configure, i not sure what to do whit the make and make install tho ----> edit mode  :grin:
<<<----- just after ./configure  enter
make enter
make install enter
omg it was that simple  :P
the smeserver-mod_deflate-1.0-1.noarch.rpm i found here.
but not sure were to find download latest eaccelerator ----> edit mode  :D
eaccelerator 

darn, it seems i broke my VMserver cant login to https


« Last Edit: October 09, 2007, 09:28:15 PM by HomePlayer »