BitNami OpenERP

    OpenERP is an ERP and CRM system that helps connect business processes for sales, finance, supply chain and project management. Primary capabilities include accounting (analytic and financial), production management (MRP), stock management, sales and purchases management, task automation, marketing campaigns, help desk and POS.

    Please, take a look to the Quick Start Guide to know the basic use of this Stack.

    How to start/stop the servers?

    Graphical tool

    The Stacks include a graphical tool to manage the servers easily. You can find the "manager-windows.exe", "manager-osx" or "manager-linux" tool in your installation directory. Using this tool, you can Start, Stop or Restart the servers and check the log files. You can click on the icon to start it.

    manager-servers.png

     

    manager-osx.png

     

     

     

     

     

     

     

     

     


    win_platform.png

    On Windows: You can also start the Manager tool from shortcuts: Start -> Program Files -> BitNami Stack -> Manager tool

    Command line tool

    If you prefer, you can use the "ctlscript.sh" utility from the command line. This script is in the installation directory.

    linux_platform.png

    On Virtual Machines and Cloud images:

    $ sudo /opt/bitnami/ctlscript.sh start

    A native installer on Linux:

    $ cd ~/application-version
    $ ./ctlscript.sh start
    

    mac_platform.png

     

    On OS X: You can start the Manager tool from the installation directory or you can use the "ctlscript.sh" utility from a Terminal.

    host:~ user$ cd /Applications/application-version
    host:~ user$ ./ctlscript.sh start

    How to configure the email settings of OpenERP?

    It is possible to configure OpenERP application to send emails. You have to install any OpenERP module first, if not you can not configure the email settings. Then go to "Settings" -> "General settings" -> "Configure outgoing email server"

    The settings below configure OpenERP mail server to send emails through a GMail account:

    SMTP Host: smtp.gmail.com
    SMTP Port: 587
    SMTP Protocol: TLS
    SMTP user: your_gmail_account@gmail.com
    SMTP password: your_gmail_password
    

    How to install modules on top of OpenERP?

    You can install modules and addons from the admin panel of the application. If you want to install an addon manually take into account it is necessary to change the permissions.

    Once you download and decompress the addon into the "addons" folder "/opt/bitnami/apps/openerp/lib/openerp-*/openerp/addons/", change the permissions to the addons directory with the following command:

    sudo chown -R daemon:daemon /opt/bitnami/apps/openerp/lib/openerp-*/openerp/addons/

    Then restart the Apache server:

    sudo /opt/bitnami/ctlscript.sh restart apache

    How to add new databases? 

    OpenERP include a built-in feature to add new databases from the "Manage databases" section.

    In order to enable the OpenERP scheduler any another database different from the default one (bitnami_openerp) you have to add the new database in the file /opt/bitnami/apps/openerp/conf/openerp-server.conf like follows:

    db_name = bitnami_openerp, newdatabase

    After doing so, please restart the service openerp_no_multi_process:

    /opt/bitnami/ctlscript.sh restart openerp_no_multi_process
    
     

    How to enable SSL?

    You can see how to configure Apache to enable SSL connections at How to enable SSL to access through https?

    How to upgrade Bitnami OpenERP Stack?

    It is strongly recommended that you create a backup before starting the update process. If you have important data, it is advisable that you create and try to restore a backup to ensure that everything works properly.

    How to upgrade OpenERP and all Stack components (recommended)?

    Go to your OpenERP installation and instead of login click on "Manage Databases". From this web inferface create a backup of the bitnami_openerp database. Now you can stop this installation.

    Install a new version of BitNami OpenERP (or deploy a new server). From the "Manage Databases" interface restore the bitnami_openerp database. Now access your machine and stop all the servers except PostgreSQL. Skip the next section and continue wit the steps explained in the "How to Migrate your data to the new OpenERP installation" section (below).

    How to upgrade only OpenERP in the Bitnami OpenERP stack?

    If you already migrated your data to a new server you can skip this section.  In case you only want to upgrade the application code without modifying any other Stack components,  you can follow the steps. Please note that we don't recomend this approach because new OpenERP version may have new dependencies not included in your base stack.

    In the example we use /opt/bitnami as the installation directory and the installation was done as the root user. This is the case in the virtual appliances and the cloud images. However if you deployed OpenERP using the BitNami native installer, please use your installation directory instead.

    # Download the latest OpenERP version
    cd /tmp/
    wget http://nightly.openerp.com/7.0/nightly/src/openerp-7.0-latest.tar.gz
    
    tar zxvf openerp-7.0-latest.tar.gz
    cd openerp-7.0-<nightlyversion>
    sudo python setup.py install --prefix=/opt/bitnami/apps/openerp --install-lib=/opt/bitnami/apps/openerp/lib
    sudo chown -R daemon.daemon /opt/bitnami/apps/openerp/lib
    

    Now you should update your configuration to point to this version of OpenERP. For this edit the /opt/bitnami/apps/openerp/conf/openerp-server.conf file and the /opt/bitnami/apps/openerp/scripts/openerp.wsgi file and replace the addons path to point to the new OpenERP version.

    How to migrate your data to the new OpenERP installation?

    Once your OpenERP installation have been updated you need to follow the steps below so your data are loaded in the new installation.

    In the example we use /opt/bitnami as the installation directory and the installation was done as the root user. This is the case in the virtual appliances and the cloud images. However if you deployed OpenERP using the BitNami native installer, please use your installation directory instead.

    # In recent virtual appliances and cloud images you will need to stop monit.
    sudo monit quit 
    
    # Stop the services
    sudo /opt/bitnami/ctlscript.sh stop
    sudo /opt/bitnami/ctlscript.sh start postgresql
    

    Now start OpenERP server with the following parameters:

    sudo su daemon -c "/opt/bitnami/python/bin/python /opt/bitnami/apps/openerp/bin/openerp-server -c /opt/bitnami/apps/openerp/conf/openerp-server.conf --workers 0 -d bitnami_openerp -u all &"
    

    Wait until the server is completely started and the modules updated. Please be patient. You can check the start up status in the OpenERP log file:

    sudo tail -f /opt/bitnami/apps/openerp/log/openerp-server.log
    

    The upgrade process is finished when the message "INFO bitnami_openerp openerp.service: Hit CTRL-C again or send a second signal to force the shutdown"  or "OpenERP waiting for connections" appear in the log file. Now you can start all the servers:

    sudo /opt/bitnami/ctlscript.sh start
    

    Notice that when you are importing the data you are also importing the OpenERP users, including the admin user and its password.

    How to debug OpenERP errors?

    Once Apache starts, it will create two log files, the access_log and the error_log /installdir/apache2/logs directory or in /var/log/httpd if you are using Amazon Linux or Red Hat Enterprise cloud images.

    In Virtual Machines, Cloud Images and Ubuntu based Bitnami Cloud Hosting images installdir is /opt/bitnami.

    The access_log file is used to track client requests. When a client requests a document from the server, Apache records several parameters associated with the request in this file, such as: the IP address of the client, the document requested, the HTTP status code, and the current time.

    The error_log file is used to record important events. This file includes error messages, startup messages, and any other significant events in the life cycle of the server. This is the first place to look when you run into a problem when using Apache.

    If no error is found, you will see a message similar to:

    Syntax OK
    /installdir/ctlscript.sh : httpd started
    

     

    The main PostgreSQL log file is created at /installdir/postgresql/postgresql.log file.

     

    The OpenERP server log file is located in installdir/apps/openerp/log/openerp-server.log

    How to configure the OpenERP timezone?

    Since version 6.1, the OpenERP server is forced to be UTC. The rendering of datetime values in the user's timezone is meant to be done on the client-side exclusively. You can configure the timezone per user in the User's Settings panel.

    openerp-prefs.png

    How to install OpenERP Report Designer and configure LibreOffice?

    You can install the Report Designer module from the OpenERP admin panel. Go to "Settings" -> "Apps" and disable the "featured" apps from the search button. Then search the "OpenOffice Report Designer" module and install it.

    Once you have installed it, go to "Reporting" -> "Report Designer"

    report-designer.png

     

    Download the zip file and install in your LibreOffice installation (or OpenOffice) following the Installation and Configuration steps.

    By defaul, XML-RPC is enabled for your OpenERP server. If not, you can enabled it manually. To do so, you have to edit installdir/apps/openerp/scripts/openerp.wsgi and add the following line:

    conf['xmlrpc'] = True  
    

    Afterwards, Apache server has to be restarted:

    installdir/ctlscript.sh restart apache  
    

    If you are using a Virtual Machine or a Cloud Image, you should open the 8069 port in your firewall configuration. Check how to configure the firewall rules here.

    To configure your LibreOffice plugin, you should specify the following settings:

    Server: your_domain
    Port: 8069
    Protocol Connection: XML-RPC  
    Database: bitnami_openerp  
    User: your_application_user  
    Password: your_application_password
    Tag page (Edit tags)
    • No tags
    Page statistics
    20201 view(s), 24 edit(s) and 10261 character(s)

    Comments

    You must login to post a comment.

    Attach file

    Attachments

    FileSizeDateAttached by 
     openerp-prefs.png
    OpenERP timezone
    31.65 kB10:41, 22 Mar 2014AdminActions
     report-designer.png
    report designer
    64.47 kB11:38, 19 Mar 2014AdminActions