Topic: SugarCRM

[dilligaf]

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

Im in trouble, now twiggi now work.

[root@merlin PHP upgrade script]# sh php4.3.11-upgrade.sh
Upgrading your PHP to version 4.3.11...
unixODBC installed skipping download
Preparing...                ########################################### [100%]
package php-4.4.1-1eo (which is newer than php-4.3.11-4eo) is already installed
package php-devel-4.4.1-1eo (which is newer than php-devel-4.3.11-4eo) is already installed
package php-imap-4.4.1-1eo (which is newer than php-imap-4.3.11-4eo) is already installed
package php-ldap-4.4.1-1eo (which is newer than php-ldap-4.3.11-4eo) is already installed
package php-mysql-4.4.1-1eo (which is newer than php-mysql-4.3.11-4eo) is already installed
package php-odbc-4.4.1-1eo (which is newer than php-odbc-4.3.11-4eo) is already installed
package php-snmp-4.4.1-1eo (which is newer than php-snmp-4.3.11-4eo) is already installed
/usr/bin/php: error while loading shared libraries: libiconv.so.2: cannot open shared object file: No such file or directory
/usr/bin/php: error while loading shared libraries: libiconv.so.2: cannot open shared object file: No such file or directory
/usr/bin/php: error while loading shared libraries: libiconv.so.2: cannot open shared object file: No such file or directory
/usr/bin/php: error while loading shared libraries: libiconv.so.2: cannot open shared object file: No such file or directory
Shutting down http:                                        [ FAILED ]
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........

[ergozd]

You seem to have latest PHP installed, fetch libiconv RPM from
http://ergin.dyndns.org/download/RPMS/contribs/PHP/libiconv-1.9.2-1.i386.rpm

and install it.

PS: I also updated the upgrade-script so it should run smoothly.

[dilligaf]

You seem to have latest PHP installed, fetch libiconv RPM from
http://ergin.dyndns.org/download/RPMS/contribs/PHP/libiconv-1.9.2-1.i386.rpm

and install it.

PS: I also updated the upgrade-script so it should run smoothly.

I just loaded that up and it worked, thanks.

[boss_hog]

Hey dilligaf,
glad you got it solved!
(Thanks to Ergin)

After seeing your results, I went back and applied the most recent php4.4.1-upgrade and the libiconv* onto the SME6.0.1-01 test box. It appears to have went fine on my machine also.
Joe

[dilligaf]

Hey dilligaf,
glad you got it solved!
(Thanks to Ergin)

After seeing your results, I went back and applied the most recent php4.4.1-upgrade and the libiconv* onto the SME6.0.1-01 test box. It appears to have went fine on my machine also.
Joe

Hi,
Have done everything step by step, but bithng happens here:(replacing server with my server of cource)
http://<server>/sugar/install.php

[Mjohnson]

Hey Joe...

I stand by my previous comments regarding your assistance.

I am going to install SugarCRM using the httpd modification and the custom template fragment technique.  I was not at all clear regarding Charlie's security concerns, but the more I look at it it does make sense (at least a bit).

Thanks for your's and all the other's efforts.

MJ

[boss_hog]

Hey dilligaf,
bummer that this app is still fighting with you!

Can you share any logs with us?.

Can you safely paste the contents of the fragment(95SugarCRM) here so we can look at it?

Did you restart apache?
Joe

[dilligaf]

Hey dilligaf,
bummer that this app is still fighting with you!

Can you share any logs with us?.

Can you safely paste the contents of the fragment(95SugarCRM) here so we can look at it?

Did you restart apache?
Joe

Here is the frag, yes I restarted.

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

When I run:
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.
and then look at the httpd conf, it is not there, I do not think the template is expanding.

[boss_hog]

Hey dilligaf,
can you verify that the fragment(95SugarCRM) is in
/etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/ directory?
Thanks
Joe

[dilligaf]

Hey dilligaf,
can you verify that the fragment(95SugarCRM) is in
/etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/ directory?
Thanks
Joe

It was not, I put it there and am rolling agin.
Once I am done I would like to offer my steps?

[boss_hog]

Hey dilligaf,

It was not, I put it there and am rolling agin.
Once I am done I would like to offer my steps?

Yes, of course! My explanation/How-To for installing SugarCRM, was crude at best. Anything you can share will help everyone else!
Joe

[dilligaf]

Hey dilligaf,

It was not, I put it there and am rolling agin.
Once I am done I would like to offer my steps?

Yes, of course! My explanation/How-To for installing SugarCRM, was crude at best. Anything you can share will help everyone else!
Joe

It works, well. Some of us are just better at "reading between the lines"
When I used you command to create the custom frag, it would not let me save to that spot. So I had to worm in creating the directories as I went. Obviously I did not end up with the frag in the right spot.
Nonetheless, it is up and working, and I have alsways liked the look, and features of the Sugar pkg.
It obviously can not talk to the webmail on the sme? The users etc are not there,

[dilligaf]

Hey dilligaf,
can you verify that the fragment(95SugarCRM) is in
/etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/ directory?
Thanks
Joe

It was not, I put it there and am rolling agin.
Once I am done I would like to offer my steps?

I finally found the problem.
Step 17, the instructions say to:
"create template fragment pico /etc/e-smith/templates-custom/etc/httpd/conf/http.conf/95SugarCRM" but it should say "create template fragment pico /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/95SugarCRM" note there was the missing "d" on httpd.conf.
Dan

[dilligaf]

Hey dilligaf,

It was not, I put it there and am rolling agin.
Once I am done I would like to offer my steps?

Yes, of course! My explanation/How-To for installing SugarCRM, was crude at best. Anything you can share will help everyone else!
Joe

Joe, here is the small revision you can review and modify your original.
This worked on my server.

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
7b) If you do not have libiconv Download and install from here:
http://ergin.dyndns.org/download/RPMS/contribs/PHP/libiconv-1.9.2-1.i386.rpm
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

[boss_hog]

Hey dilligaf,
very nice, you cleaned up the tutorial quite a bit!
One little note.
The file, libiconv-1.9.2-1.i386.rpm, is only needed if you are using the php4.4.1-upgrade script. My system worked as expected with php4.3.11-upgrade script without any additional rpm's.

If someone needs to get SugarCRM up and running, this thread should be helpful.
Good job.
Joe