Openbravo 3 package for Ubuntu Maverick available for testing

January 31, 2011

We are proud to announce the immediate availability of the Openbravo 3 package for Ubuntu 10.10 Maverick Meerkat for beta testing.

We want to invite you to test the new Openbravo 3 package for Ubuntu, and we will be more than happy to get your feedback !!

To test the package you have to:

  1. Have a running Ubuntu Maverick installation.
  2. Add openbravo launchpad repository URL’s:
    • Using the Ubuntu Software Center:

      Go Applications -> Ubuntu software Center, and then Edit -> Software Sources, go to Other software tab and click on Add button and insert the Openbravo ppa line: deb http://ppa.launchpad.net/openbravo-isv/ppa/ubuntu maverick main.
    • Using the command line:
      sudo add-apt-repository ppa:openbravo-isv/ppa
      
  3. Update the apt-get cache:
    • Using the Ubuntu Software Center:
      Not needed, automatically done when close the Software Sources window.
    • Using the command line:
      sudo apt-get update
      
  4. Install the openbravo-3 package:
    • Using the Ubuntu Software Center:

      Search for openbravo-3 and click Install.
    • Using the command line:
      sudo apt-get install openbravo-3
      

Important: Migration from previous 2.50 package.

  • The Openbravo package for ubuntu has two parts: the sources of Openbravo and the stack for run them. The stack (Apache, Tomcat, PostgreSQL, JDK and Ant) configuration is updated with the package update, but, the Openbravo sources are not updated within the package update and should be updated by the Module Management Console inside Openbravo
  • So, If you have previously installed openbravo-erp (2.50 series) and you install openbravo-3 package, it will uninstall the previous one and will import the sources and database from the 2.50 package. After the migration It’s possible to return to the 2.50 package by simply installing it, this will uninstall the openbravo-3 package and return to the previous version since the sources and database are not touched
  • Importat note: Currently openbravo-3 package contains Openbravo 3.0RC3, and the upgrade from 2.50 to 3.0RC3 is not supported , so if you have the 2.50 package installed and you want to test openbravo-3, please uninstall first the 2.50 package with apt-get remove --purge openbravo-erp. (WARNING: this will completely and permanently delete the database and sources of the openbravo 2.50 instance).

What is different than the previous openbravo-erp package for 2.50:

  • The init scripts now are /etc/init.d/openbravo, /etc/init.d/openbravo-tomcat and /etc/init.d/openbravo-postgresql.
  • The database is a new PostgreSQL cluster with name openbravo-3 and port 5943. To connect to it now you can use: psql -d postgres -U postgres -h localhost -p 5932
  • The package base path is /opt/OpenbravoERP-3.0
  • The package uses a different Catalina Base that resides in the new base path

And what is maintained:

  • Openbravo-3 has the same access url: http://localhost/openbravo
  • Uses the same user Openbravo and uses the same /home/openbravo/.profile
  • The logs continues in the same place /var/log/openbravo-erp

We’re very excited with this package, help us fine tuning it for the final version!

Gorka

Advertisements

36 Responses to “Openbravo 3 package for Ubuntu Maverick available for testing”

  1. Rok Says:

    Gorka, could you explain what individual scripts are used for/do?

    /etc/init.d/openbravo,
    /etc/init.d/openbravo-tomcat
    /etc/init.d/openbravo-postgresql

    • Gorka Gil Says:

      Hi Rok,

      openbravo script calls to openbravo-tomcat and openbravo-postgresql scripts,
      openbravo-tomcat start/stop openbravo Tomcat instance,
      openbravo-postgresql start/stop the openbravo PostgreSQL cluster.

      In the practice, openbravo start/stop can be use to start/stop Openbravo tomcat and postgres, for example in server start/stop. And openbravo-tomcat restart can be used after a compile.

      Regards


  2. openbravo script calls to openbravo-tomcat and openbravo-postgresql scripts,openbravo-tomcat start/stop openbravo Tomcat instance,openbravo-postgresql start/stop the openbravo PostgreSQL cluster.
    +1


  3. Hi Gorka,

    Tried to use your scripts to install Opnbravo on several different instances of Ubuntu on Amazon, the two images, ami-af7e2eea and ami-ca1f4f8f both experienced the error below.

    Is there anything we can do to fix this?

    Thanks,

    Brock

    Configuring postgresql.conf to use port 5932…
    …done.
    * Starting openbravo-postgresql
    …done.
    Creating the Openbravo ERP database …
    Setting up Openbravo ERP …
    dpkg: error processing openbravo-3 (–configure):
    subprocess installed post-installation script returned error exit status 137
    Processing triggers for libc-bin …
    ldconfig deferred processing now taking place
    Errors were encountered while processing:
    openbravo-3
    E: Sub-process /usr/bin/dpkg returned an error code (1)

  4. Brock Says:

    Yup, it works for us now too. We were trying it on the micro ebs, I gues there was not enough memory to run the scripts.

    Now we are trying to connect iReport but can not seem to get it to connect, have done the following

    port 5932 is open on TCP – tried udp too
    jdbc driver PostgreSQL
    database name: openbravo-3
    server address: xx.xx.xx.xx – elastic ip
    username: postgres
    password: postgres

    Thanks for your response Gorka

    Brock

    • Gorka Gil Says:

      Hi Brock,

      Yes the micro instances only has 600MB and Openbravo 3 currently needs 1.5GB of ram for compile. A option (not tested and not supported) for saves costs it’s compile in a c1.medium and then change the instance attribute to set it as a micro and then do a stop/start. So for compile you will use the c1.medium and for standard use the micro. As I said this is not tested but you can try it, in any case the launch of a big report o launch some big process can fail also in the micro instance for insufficient ram.

      Regarding connect to PostgreSQL database you will need to do this:
      – Open the port in the group in which the instance is started, by default EC2 has all ports closed.
      – The Postgres of the Ubuntu package only allow local connections by default, so you have to make this changes in order to allow external connections:
      – Edit the /etc/postgresql/8.4/openbravo-erp/postgresql.conf file, and uncomment the following line, assigning this new value:
      listen_addresses='*'
      – Edit the /etc/postgresql/8.4/openbravo-erp/pg_hba.conf file, and add this line at the end:
      host all all 0.0.0.0/0 md5

      Regarding the database name, user and pass, you can see them in /opt/OpenbravoERP-3.0/openbravo-erp/config/Openbravo.properties

      Regards


      • Awesome Gorka, I did vi the postgres files, but I don’t think I had the database and usernames right, now I will.

        Much appreciated.

        Brock

  5. Brock Says:

    Hi Gorka,

    Just want to make you aware of a couple of things.

    1. Installed RC5.1 on 32 bit desktop version of Ubuntu, added USA communit version of COA, all good, at least on the rebuild, not sure how it all works functionally yet

    2. Installed what I thought was RC5.1 on amazon, but it installed 5, the install script even said it was setting up 3.0.r11410.RC-5.1-1maverick1… but it didn’t do it. Checked for updates, found 19, then tried to rebuild, it blew up.

    No worries though, Iam moving forward with the desktop version, looking forward to production version in May.

    Thanks,

    Brock

    • Gorka Gil Says:

      Hi Brok,

      About your second point, Was it a clean install? or a update?

      If you have previously installed RC5 and then you install RC5.1, it will maintain RC5, the intended way of updating openbravo is using the openbravo module management console.

      The problem with the RC5 is that the rebuilds fails, this is one of the 4 critical issues that fixed RC5.1 [1]

      If you don’t have any thing important in the RC5 installation you can do an apt-get remove --purge openbravo-3 and them install openbravo-3 again, it will install RC5.1.

      Regards

      [1] http://wiki.openbravo.com/wiki/ERP/3.0/Release_Notes/3.0RC5.1

  6. Brock Says:

    Hey Gorka,

    Beautiful, mate, beautiful.

    Thanks for the quick response.

    Brock

  7. muymuynica Says:

    Hi, Openbravo friends.

    I have installed on Debian this version, and all go fine. Now I want to install it always on Debian but with an ORACLE database, what can I do? This installer uses by default postgres.

  8. Robson Pinto Says:

    Hi all
    i really new here. i i here i am.
    question i have my version of Linux ready install on my server to test Openbravo. but on my virtual test i saw a management console. that can be access form http://xxx.xxx.xxx.xxx:8003 and when i install on my server test i cant access that way. how can i do to access openbravo management console.
    thx a lot

  9. Safaa Says:

    Hi everyone here,
    I am new to openbravo erp. it is a very nice solution.
    i uses openbravo erp 3 on ubuntu 10.10 with postgres
    i have a problem in creating a client with an accounting file,
    i have this error message displayed:
    starting create accounting
    create accounting process failed could not execute JDBC batch update.

    I think this problem because accounting file contains characters in UTF-8 encoding, but i don’t know how to change the encoding of database to be utf-8 to accept these values.

    Thanks,
    Safaa

  10. madhusudhan Says:

    Hi, i get following error while installing openbravo-3 in ubuntu 10.04, i have installed postgresql 8.2 and tomcat6

    Setting up openbravo-3 (3.0.r14015.MP-4.1-1lucid1) …
    install: cannot create regular file `/home/openbravo/.profile’: No such file or directory
    dpkg: error processing openbravo-3 (–configure):
    subprocess installed post-installation script returned error exit status 1
    Errors were encountered while processing:
    openbravo-3

    – regards
    Madhusudhan

    • Gorka Gil Says:

      Hi Madhusudhan,

      Tomcat and PostgreSQL are not needed to be installed, since they are installed automatically by apt because they are dependencies of the openbravo-3 package.

      Regarding your error, it is very strange that fails that. Could be caused by any of these:

      * No space left on disk:
      Check with: “df -h”

      * Because a previous error the openbravo user and/or folder it was not created:
      Check with: “ls -la /home”
      Check the log: “/var/log/openbravo/installation.log”

      * If none of these problems, maybe it is a hardware problem (disk or memory). Do you see any other strange errors in other applications.

      In any case the package right now it is in a inconsistent status since the installation it is not completed, you can uninstall and install again:
      Note: Purge option will delete everything of openbravo-3 package including the database.

      sudo apt-get uninstall --purge openbravo-3
      sudo apt-get install openbravo-3

      Regards,
      Gorka

      • madhusudhan Says:

        Hi Gorka
        Thanks for the reply and suggestion, i reinstalled ubuntu os and was able to instal openbravo from synaptic package manager

        -regards,
        madhusudhan

  11. Luisa Says:

    Hi Gorka,
    really new here with Openbravo and having difficulties starting.
    I downloaded from Openbravo VMware® Virtual Appliance (32 bits).

    The installation was ok but I would like to open the postgres database installed and I don’t know how.
    I need to create a new window and table but it seems I have to create the table in the database first.

    Sorry if this is not the right place to ask this question.

    Thanks and regards

  12. melvin Says:

    hi all,
    I’m in trouble in installing openbravo to my localhost, when i try to sudo /etc/init.d/openbravo restart everything was runable and it says “OK” but when i lunched my localhost to my web browser it says “Service Temporarily Unavailable”

    The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

    Apache/2.2.20 (Ubuntu) Server at localhost Port 80

    what should i do to fixes this error :(? hmmm i try to restart and wait for a moment but still i encounter error.

    Thanks in advance.

    • Gorka Gil Says:

      Hi,

      Probably some error in the installation,

      Check the logs in “/var/log/openbravo-erp/” take a look into “installation.log” and in the tomcat log “catalina.out”

      The typical questions: do you have enough ram and free disk space?

      Regards,
      Gorka

  13. melvin Says:

    thanks now is running. :)) hmmm can you give me a basic totorial for using openbravo please?

  14. melvin Says:

    hmmm thanks, i run my openbravo to my virtualbox,instead of using of localhost i used the ip address of my virtualbox, 🙂 i think the issued is about spacing in memory,maybe, i’m new openbravo. 🙂 that’s why i need your help to guide me. 🙂

  15. Thirumalai Kandasami Says:

    Hi,

    I got the following error during installation,

    # sudo apt-get install openbravo-3
    Reading package lists… Done
    Building dependency tree
    Reading state information… Done
    The following NEW packages will be installed:
    openbravo-3
    0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
    Need to get 0 B/93.0 MB of archives.
    After this operation, 412 MB of additional disk space will be used.
    Selecting previously unselected package openbravo-3.
    (Reading database … 173052 files and directories currently installed.)
    Unpacking openbravo-3 (from …/openbravo-3_3.0.r13141.MP-1-0lucid1_all.deb) …
    Processing triggers for ureadahead …
    Processing triggers for desktop-file-utils …
    Processing triggers for bamfdaemon …
    Rebuilding /usr/share/applications/bamf.index…
    Processing triggers for gnome-menus …
    Setting up openbravo-3 (3.0.r13141.MP-1-0lucid1) …
    * Initializing openbravo-postgresql database Error: invalid version: 8.4
    [fail]
    invoke-rc.d: initscript openbravo-postgresql, action “start” failed.
    Creating the Openbravo ERP database …
    dpkg: error processing openbravo-3 (–configure):
    subprocess installed post-installation script returned error exit status 1
    Errors were encountered while processing:
    openbravo-3
    E: Sub-process /usr/bin/dpkg returned an error code (1)

    # uname -a
    Linux ANTERA-WEB-01 3.2.0-32-generic #51-Ubuntu SMP Wed Sep 26 21:33:09 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux

    /etc/issue
    Ubuntu 12.04.1 LTS \n \l

  16. billah Says:

    I am new bie to OB, wheni go for new organisation setup and sales process i faced one issue regarding tax rate mis-configured but my side tax rate configured properly.
    My Issue is: When creating a Sales Order from a Quotation the Taxes are recalculated based on the transaction date. A suitable Tax Rate could not be found in line/s: 10, 20, 30.
    Can any one help to come out from this.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: