{{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''
<code 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;
    }   
}
</code>

Install dépendances 
<code bash>
apt-get install php5-curl php5-imap php5-mysqlnd
</code>

''/etc/php5/fpm/pool.d/sugar.conf''
<code 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"
</code>

http://virtualhost/install.php

Ajout crontab
<code bash>
su - www-data -s /bin/bash
export EDITOR=vim
crontab -e
</code>

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

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

<code sql>
GRANT ALL PRIVILEGES ON sugarcrm.* TO "utilisateur"@"localhost" IDENTIFIED BY 'P@ssw0rd!';
FLUSH PRIVILEGES;
</code>

''config.php''
<code 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',
  ),
</code>

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

''config_override.php''
<code 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' );
?>
</code>