Installing SugarCRM Community Edition On Debian Lenny
Author: Falko Timme
SugarCRM is a webbased CRM solution written in PHP. SugarCRM is available in different flavours called "Editions" ("Community" (free), "Professional", and "Enterprise"). For a detailed overview of the different editions, have a look at the SugarCRM website. In this tutorial I will describe the installation of the free Community Edition on Debian Lenny. With the modules My Portal, Calendar, Activities, Contacts, Accounts, Leads, Opportunities, Cases, Bugtracker, Documents and Email, SugarCRM Community Edition offers everything that can be expected from a CRM solution.
1 Preliminary Note
In this tutorial I use the hostname server1.example.com with the IP address 192.168.0.100. These settings might differ for you, so you have to replace them where appropriate.
I will install SugarCRM in Apache's default vhost (document root /var/www) in the directory /var/www/sugarcrm. You might have to adjust this on your system.
2 Install The MySQL Database Server
Install unzip to be able to unpack the SugarCRM package later:
apt-get install unzipInstall MySQL:
apt-get install mysql-server mysql-client
You will be asked the following questions:
New password for the MySQL "root" user: <-- yourrootsqlpassword (a password of your choice)
Repeat password for the MySQL "root" user: <-- yourrootsqlpassword
3 Install The Apache Webserver And PHP
apt-get install apache2 apache2-doc apache2-mpm-prefork apache2-utils libexpat1 libapache2-mod-php5 php5-common php5-gd php5-idn php-pear php5-imap php5-mcrypt php5-mhash php5-mysql php5-sqlite php5-xmlrpc php5-xsl php5-curl
Afterwards we need to check two settings in /etc/php5/apache2/php.ini:
Make sure that the memory_limit is at least 64M and set the upload_max_filesize to 20M:
[...] memory_limit = 128M ; Maximum amount of memory a script may consume (128MB) [...] ; Maximum allowed size for uploaded files. upload_max_filesize = 20M [...]
Restart Apache afterwards:
4 Install SugarCRM
You can download SugarCRM Community Edition from http://www.sugarforge.org/frs/?group_id=6 or http://www.sugarcrm.com/crm/download/sugar-suite.html. Pick the latest .zip file (version 5.2.0a at the time of this wrinting) and install it as follows:
mv * /var/www/sugarcrm/
chown -R www-data:www-data /var/www/sugarcrm
Start the webbased SugarCRM installer by opening the URL http://server1.example.com/sugarcrm or http://192.168.0.100/sugarcrm in your browser.
The SugarCRM setup wizard comes up:
Scroll down and click on the Next button:
Accept the license (GPL) and click on Next:
Select Typical Install and click on Next:
Select the database type (MySQL):
On the Database Configuration page, fill in a name for the SugarCRM database (e.g. sugarcrm) (will be created by the installer automatically if it doesn't exist). The Host Name is localhost. Then fill in the username of the MySQL administrator (root) and his MySQL password (yourrootsqlpassword). Then scroll down...
... and select Define user to create from the drop-down menu to create a MySQL user for SugarCRM (this user will be created by the setup wizard). Fill in a name for that user (e.g. sugarcrm) and a password. If you want to have some demo data to play with, select Yes from the Populate Database with Demo Data? drop-down menu. Click on Next afterwards: