OroCRM Application

Welcome to OroCRM the Open Source Customer Relationship Management (CRM) application.

Requirements

OroCRM is a Symfony 2 based application with the following requirements:

  • PHP 5.5.9 or above with command line interface
  • PHP Extensions:
    • GD
    • Mcrypt
    • JSON
    • ctype
    • Tokenizer
    • SimpleXML
    • PCRE
    • ICU
  • MySQL 5.1 or above
  • PostgreSQL 9.1 or above

Installation instructions

OroCRM uses Composer to manage package dependencies, this is the a recommended way to install OroCRM.

  • If you don't have Composer yet, download it and follow the instructions on http://getcomposer.org/ or just run the following command:
curl -s https://getcomposer.org/installer | php
git clone https://github.com/orocrm/crm-application.git
  • Make sure that you have NodeJS installed

  • Install OroCRM dependencies with composer. If installation process seems too slow you can use "--prefer-dist" option. Go to crm-application folder and run composer installation:

php composer.phar install --prefer-dist --no-dev
  • Create the database with the name specified on previous step (default name is "oro_crm").

  • Install application and admin user with Installation Wizard by opening install.php in the browser or from CLI:

php app/console oro:install --env prod

Note: If the installation process times out, add the --timeout=0 argument to the command.

  • Enable WebSockets messaging
php app/console clank:server --env prod
  • Configure crontab or scheduled tasks execution to run command below every minute:
php app/console oro:cron --env prod

Note: app/console is a path from project root folder. Please make sure you are using full path for crontab configuration or if you running console command from other location.

Installation notes

Installed PHP Accelerators must be compatible with Symfony and Doctrine (support DOCBLOCKs).

Note that the port used in Websocket must be open in firewall for outgoing/incoming connections

Using MySQL 5.6 on HDD is potentially risky because of performance issues.

Recommended configuration for this case:

innodb_file_per_table = 0

And ensure that timeout has default value

wait_timeout = 28800

See Optimizing InnoDB Disk I/O for more

The default MySQL character set utf8 uses a maximum of three bytes per character and contains only BMP characters. The utf8mb4 character set uses a maximum of four bytes per character and supports supplemental characters (e.g. emojis). It is recommended to use utf8mb4 character set in your app/config.yml:

...
doctrine:
    dbal:
        connections:
            default:
                driver:       "%database_driver%"
                host:         "%database_host%"
                port:         "%database_port%"
                dbname:       "%database_name%"
                user:         "%database_user%"
                password:     "%database_password%"
                charset:      utf8mb4
                default_table_options:
                    charset: utf8mb4
                    collate: utf8mb4_unicode_ci
                    row_format: dynamic
...

Using utf8mb4 might have side effects. MySQL indexes have a default limit of 767 bytes, so any indexed fields with varchar(255) will fail when inserted, because utf8mb4 can have 4 bytes per character (255 4 = 1020 bytes), thus the longest data can be 191 (191 4 = 764 < 767). To be able to use any 4 byte charset all indexed varchars should be at most varchar(191). To overcome the index size issue the server can be configured to have large index size by enabling sysvar_innodb_large_prefix. However, innodb_large_prefix requires some additional settings to work:

  • innodb_default_row_format=DYNAMIC (you may also enable it per connection as in the config above)
  • innodb_file_format=Barracuda
  • innodb_file_per_table=1 (see above performance issues with this setting)

More details about this issue can be read here

PostgreSQL installation notes

You need to load uuid-ossp extension for proper doctrine's guid type handling. Log into database and run sql query:

CREATE EXTENSION "uuid-ossp";

Loading Demo Data using command line

To load sample data you need to run console command

php app/console oro:migration:data:load --fixtures-type=demo --env=prod

Web Server Configuration

OroCRM application is based on the Symfony standard application so web server configuration recommendations are the same.

Related Repositories

platform-application

platform-application

OroPlatform Empty Application ...

clientela-crm

clientela-crm

Clientela is full-featured open source CRM web application written in Ruby on Ra ...

gear-service

gear-service

CRM application. Java 1.8 and Spring Boot at server-side and AngularJS with Angu ...

grails-crm-core

grails-crm-core

CRM core plugin for the Grails Web Application Framework ...

pegula-crm

pegula-crm

CRM Web Application (AngularJS + Django) ...


Top Contributors

rgrebenchuk vsoroka ignat-s yshyshkin alsma x86demon bogdawa yurio oro-buildbot ishakuta alex-n-2k7 Grygir DimaSoroka kotfalya sergeyz AlexandrDmitriev pusachev alexandr-parkhomenko makasim iklymenko orocommerce-ci torchello spolischook zebimax alex-kuzmenko anyt vitaliyberdylo eu-ge-ne orocrmdeployer mkudelya

Releases

-   1.10.7 zip tar
-   1.10.6 zip tar
-   1.10.5 zip tar
-   1.10.4 zip tar
-   1.10.3 zip tar
-   1.10.2 zip tar
-   1.10.1 zip tar
-   1.10.0 zip tar
-   1.9.8 zip tar
-   1.9.7 zip tar
-   1.9.6 zip tar
-   1.9.5 zip tar
-   1.9.4 zip tar
-   1.9.3 zip tar
-   1.9.2 zip tar
-   1.9.1 zip tar
-   1.9.0 zip tar
-   1.9.0-RC2 zip tar
-   1.9.0-RC1 zip tar
-   1.8.2 zip tar
-   1.8.1 zip tar
-   1.8.0 zip tar
-   1.7.7 zip tar
-   1.7.6 zip tar
-   1.7.5 zip tar
-   1.7.4 zip tar
-   1.7.3 zip tar
-   1.7.1 zip tar
-   1.7.0 zip tar
-   1.6.4 zip tar