Title: SugarCRM-HOWTO
Subject: Setup SugarCRM on Debian Sarge

# REFERENCE:  http://www.besy.co.uk/projects/debian/sugar_howto.htm

aptitude remove apache-common apache-dbg        
#     The following packages are unused and will be REMOVED:
#       apache2-utils
#     The following packages will be automatically REMOVED:
#       apache nagios-common nagios-text
#     The following packages have been kept back:
#       flex gnupg ipsec-tools libcupsys2-gnutls10 libgnutls11 libsensors3
#       lm-sensors nfs-user-server perl perl-base perl-doc perl-modules sudo tar
#     The following packages will be REMOVED:
#       apache apache-common nagios-common nagios-text
#     0 packages upgraded, 0 newly installed, 5 to remove and 14 not upgraded.
#     Need to get 0B of archives. After unpacking 9916kB will be freed.

aptitude install apache2 apache2-modules libapache2-mod-php4  php4-imagick
#     The following NEW packages will be installed:
#       apache2 apache2-common apache2-utils ssl-cert
#       apache2-mpm-prefork libapache2-mod-php4 libjasper-1.701-1 
#       liblcms1 libmagick6 libzzip-0-12 php4-common php4-imagick

aptitude install catdoc xpdf-utils
#     The following NEW packages will be installed:
#       catdoc libpaper-utils libpaper1 xpdf-common xpdf-utils

aptitude install mysql-server-4.1 php4-mysql
#     The following NEW packages will be installed:
#       libdbd-mysql-perl libdbi-perl libmysqlclient14 libmysqlclient14-dev
#       libnet-daemon-perl libplrpc-perl mysql-client-4.1 mysql-server-4.1

aptitude install curl php4-curl
#     The following NEW packages will be installed:
#       curl libcurl3 php4-curl

aptitude install php4-mysql


apt-get install nagios-common nagios-text
cd /var/www
wget http://www.sugarforge.org/frs/download.php/1157/SugarSuite-4.2.0.zip
unzip SugarSuite-4.2.0.zip
rm SugarSuite-4.2.0.zip
chown -R www-data:www-data /var/www/SugarSuite-Full-4.2.0
chmod -R 755 /var/www/SugarSuite-Full-4.2.0/
chmod -R 775 /var/www/SugarSuite-Full-4.2.0/cache
chmod -R 775 /var/www/SugarSuite-Full-4.2.0/custom
chmod -R 775 /var/www/SugarSuite-Full-4.2.0/data
chmod -R 775 /var/www/SugarSuite-Full-4.2.0/modules
chmod -R 775 /var/www/SugarSuite-Full-4.2.0/config.php

cat > /etc/apache2/conf.d/sugar_crm.conf <<EOF
 #################################################
#  -BEGIN-  Custom Config for	SugarCRM	  #
#################################################
Alias /sugar "/var/www/SugarSuite-Full-4.2.0"
<Directory /var/www/SugarSuite-Full-4.2.0>
        AllowOverride FileInfo AuthConfig Limit
        DirectoryIndex index.php
            <Limit GET POST OPTIONS PROPFIND>
        	Order allow,deny
        	Allow from all
            </Limit>
            <LimitExcept GET POST OPTIONS PROPFIND>
        	Order deny,allow
        	Deny from all
            </LimitExcept>
</Directory>
 #################################################
#  -END-  Custom Config for   SugarCRM  	  #
 #################################################
EOF

/etc/init.d/apache2 restart

sed 's/\(memory_limit\ =\ \).*/\150M/' /etc/php4/apache2/php.ini > /etc/php4/apache2/php.ini.new
cp /etc/php4/apache2/php.ini /etc/php4/apache2/php.ini.orig
mv /etc/php4/apache2/php.ini.new /etc/php4/apache2/php.ini

/etc/init.d/apache2 restart


#Brows to http://myserver.domain.com/sugar/install.php
#  Click "Start"
#  --------------------------
#  Step1:
#    Click "I Accept"
#    Click "Next" 
#  --------------------------
#  Step2:
#    All things must be green on next page.
#    Click "Next"
#  --------------------------
#  Step3:
#    Host Name            localhost 
#    Database Name        sugarcrm (check create database)
#    Database username    sugarcrm (check create user)
#    Database password    sugarcrm
#    Don't populate database with demo data
#    Database account above is a privileged user? unchecked.
#    Privileged Database User Name: root
#    Privileged Database User Password: blank
#  --------------------------
#  Step4:
  URL of Sugar instance            http://myserver.domain.com/sugar
  Sugar admin password             testadmin
  Re-enter Sugar admin password    testadmin
  Enable Sugar updates?            checked
  Advanced Site Security
    use defaults?                  checked
--------------------------
Step5:
  Conferm Settings
    Check next.
--------------------------
Step6: Permform Setup
  Check next  
--------------------------
Step7: Register
  Name:           Test
  business email: test@test.com
  Click Finish
--------------------------
At login page, login as admin.
	user=admin
	pass=testadmin
--------------------------
Save time zone as Tijuana
--------------------------