Install SugarCRM

Voir :

http://doc.ubuntu-fr.org/sugarcrm

https://gist.github.com/amusarra/9455020

Voir aussi :

Crème CRM

ERP : OpenConcerto

http://sourceforge.net/projects/sugarcrm/files/latest/download?source=files

server { listen 80; server_name crm.acme.fr; return 301 https://crm.acme.fr$request_uri; } server { listen 443 ssl; server_name crm.acme.fr; ssl_certificate /etc/nginx/ssl/nginx.crt; ssl_certificate_key /etc/nginx/ssl/nginx.key; access_log /var/log/nginx/sugarcrm.acme.fr.access.log; error_log /var/log/nginx/sugarcrm.acme.fr.error.log; root /var/www/sugarcrm/sugarcrm; index index.php index.html; location /instance_amusarra/ { if (!-d $request_filename){ set $rule_0 true; } if (!-f $request_filename){ set $rule_0 true; } if ($rule_0){ rewrite ^/instance_amusarra/rest/(.*)$ /instance_amusarra/api/rest.php?__sugar_url=$1 last; rewrite ^/instance_amusarra/cache/api/metadata/lang_(.._..)_(.*)_public\.json$ /instance_amusarra/rest/v10/lang/public/$1?platform=$2 last; rewrite ^/instance_amusarra/cache/api/metadata/lang_(.._..)_([^_]*)\.json$ /instance_amusarra/rest/v10/lang/$1?platform=$2 last; rewrite ^/instance_amusarra/portal/(.*)$ /instance_amusarra/portal2/$1 last; rewrite ^/instance_amusarra/portal$ /instance_amusarra/portal/? permanent; } try_files $uri $uri/ index.php; } location /instance_shirus/ { if (!-d $request_filename){ set $rule_0 true; } if (!-f $request_filename){ set $rule_0 true; } if ($rule_0){ rewrite ^/instance_shirus/rest/(.*)$ /instance_shirus/api/rest.php?__sugar_url=$1 last; rewrite ^/instance_shirus/cache/api/metadata/lang_(.._..)_(.*)_public\.json$ /instance_shirus/rest/v10/lang/public/$1?platform=$2 last; rewrite ^/instance_shirus/cache/api/metadata/lang_(.._..)_([^_]*)\.json$ /instance_shirus/rest/v10/lang/$1?platform=$2 last; rewrite ^/instance_shirus/portal/(.*)$ /instance_shirus/portal2/$1 last; rewrite ^/instance_shirus/portal$ /instance_shirus/portal/? permanent; } try_files $uri $uri/ index.php; } location = /favicon.ico { log_not_found off; access_log off; } location = /robots.txt { allow all; log_not_found off; access_log off; } # Deny all attempts to access hidden files such as .htaccess, .htpasswd, .DS_Store (Mac). location ~ /\. { deny all; access_log off; log_not_found off; } #error_page 404 /404.html; # redirect server error pages to the static page /50x.html # error_page 500 502 503 504 /50x.html; location = /50x.html { root /usr/share/nginx/html; } # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000 # location ~ \.php$ { root /var/www/sugarcrm/sugarcrm; fastcgi_pass unix:/var/run/php5-fpm-sugar.sock; fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; include fastcgi_params; } # deny access to .htaccess files, if Apache's document root # concurs with nginx's one # location ~ /\.ht { deny all; } }

Install dépendances

apt-get install php5-curl php5-imap php5-mysqlnd
[sugarcrm] user = www-data group = www-data listen = /var/run/php5-fpm-sugar.sock listen.owner = www-data listen.group = www-data pm = dynamic pm.max_children = 5 pm.start_servers = 2 pm.min_spare_servers = 1 pm.max_spare_servers = 3 chdir = / php_admin_value[memory_limit] = 50M php_admin_value[upload_max_filesize] = 10M php_admin_value[date.timezone] = "Europe/Paris"

http://virtualhost/install.php

Ajout crontab

su - www-data -s /bin/bash export EDITOR=vim crontab -e

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

Enlever le mot de passe root de MySQL du fichier config.php

GRANT ALL PRIVILEGES ON sugarcrm.* TO "utilisateur"@"localhost" IDENTIFIED BY 'P@ssw0rd!'; FLUSH PRIVILEGES;
'dbconfig' => array ( 'db_host_name' => 'localhost', 'db_host_instance' => 'SQLEXPRESS', 'db_user_name' => 'utilisateur', 'db_password' => 'P@ssw0rd!', 'db_name' => 'sugarcrm', 'db_type' => 'mysql', 'db_port' => '', 'db_manager' => 'MysqliManager', ),

https://crm.acme.fr/index.php?module=Administration&action=repair

<?php $sugar_config['http_referer']['list'][] = 'crm.acme.fr'; $sugar_config['http_referer']['actions'] =array( 'index', 'ListView', 'DetailView', 'EditView', 'oauth', 'authorize', 'Authenticate', 'Login', 'SupportPortal', 'GoogleOauth2Redirect', 'repair' ); ?>