siddou.tk

install SugarCRM 7.6 Ent on Debian 7 Wheezy

SugarCRM is nice CRM on linux. There is a community version but this install is about Entreprise version 7.6

About Sugar_Version 7.6 Ent:
It won’t install on Jessie without big tweaks because it use PHP 5.4. Also setup wizard couldn’t find recent version of elastisearch so i had to stick to supported version 1.44.

Sources:
http://support.sugarcrm.com/Resources/Supported_Platforms/index.html
https://support.sugarcrm.com/Documentation/Sugar_Versions/7.6/Ent/Installation_and_Upgrade_Guide/

Install

apt-get install mysql-server apache2 unzip php5 php5-mysql curl libcurl3 libcurl3-dev php5-curl chkconfig php5-gd php5-imap php5-mcrypt

Finish mySQL install

mysql_secure_installation 

Create sugar admin

mysql -u root -p
mysql> GRANT ALL PRIVILEGES ON sugarcrm.* TO admin@localhost IDENTIFIED BY 'secret_password';

Get software and unzip to apache dir

mv SugarEnt-Full-7.6.1.0 /var/www/sugar
chown -R www-data:www-data /var/www/sugar

Configure php

nano /etc/php5/apache2/php.ini
upload_max_filesize = 100M
memory_limit = 512M
post_max_size = 100M

Configure apache2+https

nano /etc/apache2/sites-enabled/000-default
a2enmod rewrite
a2enmod expires
a2enmod headers
service apache2 restart

Install java

apt-get install openjdk-7-jre-headless

Install Elasticsearch

wget -O - http://packages.elasticsearch.org/GPG-KEY-elasticsearch | apt-key add -
echo 'deb http://packages.elasticsearch.org/elasticsearch/1.4/debian stable main' | tee /etc/apt/sources.list.d/elasticsearch.list
apt-get update
apt-get install elasticsearch=1.4.4
nano /etc/default/elasticsearch
chkconfig elasticsearch on
service elasticsearch restart

Done
go to http://crm_IP_OR_Hostname

Follow Setup Wizard
db name: sugarcrm
db admin: admin
db admin password: secret_password

Setup cron

crontab -e -u www-data
* * * * * cd /var/www/sugar; php -f cron.php > /dev/null 2>&1

Fix Permission denied errors

chown -R www-data:www-data /var/www/sugar
find /var/www/sugar/ -type d -exec chmod 775 {} \;
find /var/www/sugar/ -type f -exec chmod 664 {} \;

Configure OpenLDAP backend for users

http://support.sugarcrm.com/Knowledge_Base/Administration/Password_Management/Configuring_LDAP_Authentication_Using_Active_Directory/index.html

Go to Admin -> Password Management -> tick Enable LDAP Authentication

server ldaps://ldapsrv
port number 636
user DN ou=Users,dc=siddou,dc=com
user filter
Bind Attribute dn
Login Attribute uid
Group membership on
group DN ou=Groups,dc=siddou,dc=com
Group Name cn=sugarcrm
User Attribute uid
Group Attribute memberUid
With User DN off

Authentication on
UserName cn=ldapsrv,dc=siddou,dc=com
Password ***********

Auto Create Users on
Encryption Key

Configure Active Directory backend for users

Go to Admin -> Password Management -> tick Enable LDAP Authentication
It wasn’t not working for me with server: ad.siddou.com and port:389, so i used ldaps.

Server: ldaps://ad.siddou.com
Port: 636
User DN: CN=Users,DC=siddou,DC=com
Bind Attribute: userPrincipalName
Login Attribute: sAMAccountName

Group Membership on
Group DN: CN=Users,DC=siddou,DC=com
Group Name: CN=sugarcrm
User Attribute: dn
Group Attribute: member
With User DN off

Authentication on
User Name: administrator@siddou.com

Auto Create Users on
Encryption Key

Leave a Reply

Your email address will not be published. Required fields are marked *