Running SugarCRM Community Edition On Nginx (LEMP) on Debian Squeeze/Ubuntu 11.04 - Page 2

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:

Next fill in a username and password for the SugarCRM admin user:

You should now see a summary of your selected options. Make a note of the cron job that is displayed at the bottom (for me it's * * * * * cd /var/www/www.example.com/web; php -f cron.php > /dev/null 2>&1) - we will have to set this up at the end. If everything else is ok, click on Install:

SugarCRM is now being installed. Click on Next afterwards:

If you want you can now register to receive newsletters - this is optional:

You should now see the SugarCRM login screen. Fill in admin as the username and the password you specified in the setup wizard:

After the first login, you are asked to fill in some basic configuration settings like your company name, system locale settings, SMTP server settings, your personal details, etc.:

After you've provided all these details, you finally get to the SugarCRM web interface - this is how it looks:

A user guide for your SugarCRM version can be found on http://www.sugarforge.org/frs/?group_id=6.

There's one thing left to do - we must set up the cron job that the installer told us about. Run

crontab -e

and fill in your SugarCRM cron job:

* * * * * cd /var/www/www.example.com/web; php -f cron.php > /dev/null 2>&1

4 Links

• SugarCRM: http://www.sugarcrm.com/
• SugarForge: http://www.sugarforge.org/
• nginx: http://nginx.org/
• nginx Wiki: http://wiki.nginx.org/
• Debian: http://www.debian.org/
• Ubuntu: http://www.ubuntu.com/

About The Author

Falko Timme is the owner of Timme Hosting (ultra-fast nginx web hosting). He is the lead maintainer of HowtoForge (since 2005) and one of the core developers of ISPConfig (since 2000). He has also contributed to the O'Reilly book "Linux System Administration".