Koozali.org: home of the SME Server
Obsolete Releases => SME 7.x Contribs => Topic started by: tariqf 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
-
Is there any specific reason you want to change the default MySQL password? Changing the MySQL root password will break other 'stock' things.
guest
-
where do you find php-json 1.1.1 ?
-
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.
-
Thank you.
i get :
[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
-
you need
yum install php-devel i think, must have missed this off the howto
-
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.
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.
-
* 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.
* 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.
* yum install gcc gcc-c++
No. Don't include compilers on external servers.
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.
-
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
-
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.
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.
-
wat version of sugar do I need to download?
How do i extract it?
-
wat version of sugar do I need to download?
Look here. (http://forums.contribs.org/index.php?topic=35112.0.5.0h)
-
Hi,
Yeah I noticed that after posting but I still need to know how to extract.
Thanks
k0r54
-
if its a .tar.gz use
tar zxvf filename
if its a tar.bz2
tar jxvf filename
use
man tar
for more info
-
the version to download only seems to be .zip?
-
oh right in that case
unzip filename
-
what bit of code is it that changes the mysql password? I dont want to change mysql's root password
-
You wrote
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
-
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.
-
the version to download only seems to be .zip?
man unzip
-
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
-
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/
-
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
-
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.
-
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.
mkdir -p /opt/sugar
cd /opt/sugar
wget http://www.sugarforge.org/frs/download.php/2407/SugarOS-4.5.0h.zip
unzip SugarOS-4.5.0h.zip
chown -R www:www /opt/sugar/SugarOS-Full-4.5.0h
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.
# 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>
Control-X yes enter
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
* 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.
-
Here is the php speed up bit...
cd /usr/lib/php4
wget http://www.magicwilly.webhostingpal.com/SME7%20How%20To%20Files/sugarcrm/json.so
mkdir -p /etc/e-smith/templates-custom/etc/php.ini
nano -w /etc/e-smith/templates-custom/etc/php.ini/70extras
Paste the following.
extension=json.so
Control-X yes enter
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
-
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
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
-
login as admin/admin and then change the password.
-
Hey,
Log into wat as admin/admin?
Edited - Sorry sorted! the database username and password
Thanks
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.
-
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
-
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.
-
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
-
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.
-
...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.
-
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
-
Hi Folks,
I was just trying to install SugarCRM by using this thread and William's notes here:"
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:
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:
# 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...
-
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.
-
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
-
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
-
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? (http://forums.contribs.org/index.php?topic=38573.0)
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;
[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
-
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
-
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
-
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
-
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.
-
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 (http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=viewsdownload&sid=59) i found here.
but not sure were to find download latest eaccelerator ----> edit mode :D
eaccelerator (http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=getit&lid=314)
darn, it seems i broke my VMserver cant login to https