Différences

Ci-dessous, les différences entre deux révisions de la page.

--- tech:install_sugarcrm [2025/11/14 08:49] – Jean-Baptiste
+++ tech:install_sugarcrm [2026/06/07 19:12] (Version actuelle) – modification externe 127.0.0.1
@@ Ligne 1: / Ligne 1: @@
+<!DOCTYPE markdown>
+{{tag>Brouillon}}
+# 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
+`/etc/nginx/sites-available/crm.acme.fr`
+~~~nginx
+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
+~~~bash
+apt-get install php5-curl php5-imap php5-mysqlnd
+~~~
+`/etc/php5/fpm/pool.d/sugar.conf`
+~~~ini
+[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
+~~~bash
+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
+~~~sql
+GRANT ALL PRIVILEGES ON sugarcrm.* TO "utilisateur"@"localhost" IDENTIFIED BY 'P@ssw0rd!';
+FLUSH PRIVILEGES;
+~~~
+`config.php`
+~~~php
+  '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
+`config_override.php`
+~~~php
+<?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' );
+?>
+~~~