AdminSysGNULinux

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

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

/etc/php5/fpm/pool.d/sugar.conf

[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;

config.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
$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' );
?>