Bitnami OpenERP


    For security reasons the master password is randomly generated during the installation of the application. You will learn how to get this password in this section.

    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 native installers 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.














    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 "" utility from the command line. This script is in the installation directory.


    On Virtual Machines and Cloud images:

    $ sudo /opt/bitnami/ start

    A native installer on Linux:

    $ cd ~/application-version
    $ ./ start



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

    host:~ user$ cd /Applications/application-version
    host:~ user$ ./ 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 Port: 587
    SMTP Protocol: TLS
    SMTP user:
    SMTP password: your_gmail_password

    How to find the master password of OpenERP?

    For security reasons the master password is randomly generated during the installation of the application, you will use it if you want to manage the databases (create, drop, backup, ... ) using the application. You will find this line at /opt/bitnami/apps/openerp/conf/openerp-server.conf

    admin_passwd = random_password

    If you want to set another password, you have to change that line and set the password that you want. After that, you have to restart your server.

    sudo /opt/bitnami/ restart apache

    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.

    To do so, go to Settings->Users, select the Administrator user and click Edit. There, go to Access Rights and make Technical Features checkbox True. After that, re-login into the webclient and you will see all menus at the left sidebar. The Update Modules List option will be available.

    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/ restart apache


    Then, using the Update Module List option the new Modules that you want to install will be available.

    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/ 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/
    tar zxvf openerp-7.0-latest.tar.gz
    cd openerp-7.0-<nightlyversion>
    sudo python 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/ stop
    sudo /opt/bitnami/ 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/ 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/ : 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.


    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"



    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/ restart apache  

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

    Server: application_domain
    Port: 80
    Protocol Connection: XML-RPC  
    Database: bitnami_openerp  
    User: your_application_user  
    Password: your_application_password
    Tag page (Edit tags)
    • No tags
    Pages that link here
    Page statistics
    37426 view(s), 31 edit(s) and 11942 character(s)


    You must login to post a comment.

    Attach file


    FileSizeDateAttached by 
    OpenERP timezone
    31.65 kB10:41, 22 Mar 2014AdminActions
    report designer
    64.47 kB11:38, 19 Mar 2014AdminActions