Openbravo ERP beta package for Ubuntu Karmic available for testing

December 17, 2009

We are proud to announce the immediate availability of the Openbravo ERP beta package for Ubuntu 9.10 Karmic Koala.

Earlier this year, Openbravo increased its line up of deployment options by making an Openbravo ERP server available as a package for Ubuntu 9.04 Jaunty Jackalope.

This option proved to be very popular and resulted in more than 2000 unique installations during the first month alone. Leveraging this package Ubuntu users have been able to setup a working Openbravo environment for either either evaluation or production purposes with just one command. Additionally, customers of our Professional Subscription offer have been able to acquire a fully supported Ubuntu stack at a very competitive price.

We are now in the process of making this deployment option available for the latest version of Ubuntu, 9.10 Karmic. Not only this package will support the latest Ubuntu version but it will also include several improvements based on the experience we gained with Jaunty.

Finally, this package is the first step to include Openbravo into Ubuntu’s next long term support release, Ubuntu 10.04 LTS Lucid Lynx.

We plan the production availability of Openbravo ERP for Karmic in the January 2010 time frame. Today, however, we are proud to announce its immediate availability in beta status.

This beta package will allow us to improve the quality of the final release of the package, so we encourage you to test and provide us feedback.

This is a beta package, so keep in mind these important notes:

  • Do not use it in production environments.
  • The official release of this package is scheduled for mid-January.
  • This beta package is built with Openbravo ERP 2.50MP9, but the final package will have Openbravo ERP 2.50MP10.

The instructions to test the package:

  1. You should have a running Ubuntu Karmic installation.
  2. Add the Openbravo ERP PPA’s GPG key to your apt keyring:
    sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys C2F11D81
    
  3. Add openbravo-erp launchpad repository URL’s:
    sudo sh -c 'echo "deb http://ppa.launchpad.net/openbravo-isv/ppa/ubuntu karmic main" >> /etc/apt/sources.list'
    sudo sh -c 'echo "deb-src http://ppa.launchpad.net/openbravo-isv/ppa/ubuntu karmic main" >> /etc/apt/sources.list'
    
  4. Update the apt-get cache:
    sudo apt-get update
    
  5. Install the openbravo-erp package:
    • By command line:
      sudo apt-get install openbravo-erp
      
    • Using graphical interface:
      Search in Synaptic for openbravo-erp.

Compared to the Jaunty version, these are the features included in this version of the package:

  • Don’t compile at install time, ship binaries. It reduces the installation time.
  • Add Apache and connect with Tomcat using the mod_jk connector. So that now Openbravo ERP is accessed from http://ip_address/openbravo and we can use the fine tunning of Apache (e.g. gzip compression enabled).
  • Add the BigBazaar sample data, with a lot more data to test the Openbravo ERP functionalities.
  • Use PostgreSQL 8.4.1 instead of 8.3.8. With this we’ll start our 8.4 support in Openbravo ERP.
  • Manage our PostgreSQL database cluster in the Debian/Ubuntu way: using pg_cluster. With this feature you can start/stop openbravo-erp cluster with pg_ctlcluster start/stop 8.4 openbravo-erp. To list the status of the clusters you can use pg_lsclusters. Also you can still use /etc/init.d/openbravo-erp-postgresql script.
  • Removing the package without the purge option now maintains the database and the sources. In the previous version of the package maintains the database, but for avoiding inconsistencies between the sources/binaries and database, now it is maintained the sources/binaries and the database.
  • Centralized directory to read all the logs from our stack, (PostgreSQL, Apache, Tomcat, mod_jk). You can find all this logs at /opt/OpenbravoERP-2.50/logs.
  • Clean and simplify the installation output to make it shorter and to display only the most relevant installation points.
  • Secure the Tomcat Manager to allow connections from the ERP only.
  • Ability to update every part of the package except for Openbravo ERP.   So the apt-get upgrade command will update your  Tomcat, PostgreSQL or Apache configurations for Openbravo ERP, but will not update your Openbravo ERP version. The ERP updates are managed through the Module Management Console inside Openbravo ERP.

And the fixed issues:

  • Installation hangs in localized Ubuntus (#435412, #410182, #442484)
  • Fixed JAVA_HOME issue when updating Core.
  • Global variables are correctly set if user openbravo already exits. This perform a backup of the existing /home/openbravo/.profile in /home/openbravo/.profile.bak
  • (many other minor fixes)

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

Gorka

UPDATE:  see the list of known issues

(EDIT: fixed the command to add the repository URLs to sources.list)

36 Responses to “Openbravo ERP beta package for Ubuntu Karmic available for testing”

  1. Armando Says:

    it does not have openbravo source code?
    Should I still get it from forge?

    • gorkagil Says:

      Armando,

      In order to work properly Openbravo ERP needs the source code, so the package already has it,
      you can find it at /opt/OpenbravoERP-2.50/openbravo-erp.

      Regards

  2. Olivier Says:

    Hello,

    I installed OpenBravo with this package and I was having trouble translating it into French.
    The folder where is installed Openbravo is /opt/OpenbravoERP-2.50/ ?
    I put the files AppsOpenbravo/attachments/lang/fr_FR and language files but it doesn’t work.
    I have the error “Can not read directory /opt/OpenbravoERP-2.50/attachments/lang/fr_FR/” when I tried to import.

    Thank you in advance for your help.

    Best regards,
    Olivier

    • Gorka Gil Says:

      Hi Olivier,

      I’m able to install the fr_FR language, you’ve to place the translation files in /opt/OpenbravoERP-2.50/attachments/lang/fr_FR/.

      In any case, this is not the recommended way of install languages in 2.50, the recommendation is install the language as a module from the Module Management Console:
      http://wiki.openbravo.com/wiki/Localization_Downloads

      Regards

    • krnkris Says:

      Hi Oliver,
      I try to help out.
      /UBUNTU Karmic 9.10 – Openbravo included/

      I tried a lot and finally do this on German language:

      – I put the xml german files in to /opt/OpenbravoERP-2.50/attachments/lang/de_DE/

      – Then I stoped the tomcat6 /inside tomcat6 directory usr/share/tomcat6/bin/shutdown.sh

      – Then applied as writen on
      http://wiki.openbravo.com/wiki/ERP/2.50/Ubuntu_Package_Status

      Make the database data match with the data in the xml files:

      1.- Uninstall the template in the web interface.

      2.- Execute this in a terminal:

      $ su
      (enter root pass)
      $ su -l openbravo -c “cd /opt/OpenbravoERP-2.50/openbravo-erp && ant update.database -Dforce=yes”

      3.- Install again the template in the web interface.

      Solution: This is a known issue of 2.50MP9, but the final stable package will have 2.50MP10, so this problem will not happen.

      Retrieved from “http://wiki.openbravo.com/wiki/ERP/2.50/Ubuntu_Package_Status”

      This page was last modified 09:58, 22 December 2009. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.

      – Restart tomcat6
      usr/share/tomcat6/bin/startup.sh

      – Go to openbravo and change language… It’s WORKING!

      Thank you!

      Kris

      • Gorka Gil Says:

        Hi krnkris,

        To stop the Openbravo ERP Tomcat you have to use:
        sudo /etc/init.d/openbravo-erp-tomcat stop

        If you execute the usr/share/tomcat6/bin/shutdown.sh you will stop the system tomcat context that is a different one that the Openbravo ERP Tomcat context. In Tomcat is possible to use different CATALINA_BASE and each of them are like a independent Tomcat installation with its own configuration.

        Regarding the workaround, it’s not intended for a language installation. I write it for a know issue when you update core or you install a template and you get the “Database has local changes. Update.database will not be done.” message.

        The optimal steps for install a language are these:
        – Install your language module from the Module Management Console.

        You can follow this guide to install a module: http://wiki.openbravo.com/wiki/ERP/2.50/ModularityVideos/Install_Module

        If your language is not available as a module, you can use the manual installation that consist in:
        – Put the xml german files in to /opt/OpenbravoERP-2.50/attachments/lang/de_DE/
        – Go to General Setup > Application > Language and mark German as System language. Click on Verify language.
        – Go to General Setup > Application > Import/Export translation, select entity:System and Language:German, and click on import
        – Restart the Openbravo ERP Tomcat: sudo /etc/init.d/openbravo-erp-tomcat restart

        Regards

  3. Krnkris Says:

    Hi Oliver, Gorka Gil,

    I just tried out the new OpenbravoERP-2.50-10-1
    and the export inport working just fine.

    Try out.

    /UBUNTU KARMIC + openbravo-2.50-10-1 included package/

    Thank you!

    Kris

  4. Bruno Says:

    Hi,

    I installed Openbravo successfully, and I can access it from my local network.
    Unfortunately I get a time out as I try to open the link from outside.
    The server is behind a router and I had the port 80 redirect to the server but it doesn’t seem to be sufficient.
    I’m quite a newbie regarding the use of mod_jk_connector.
    Which port is used to reach openbravo application and where can I find the information exactly ?

    Regards

    • Gorka Gil Says:

      Hi Bruno,

      The port used by Openbravo ERP is the 80.

      The mod_jk connector only redirect the access from http://ip/openbravo to http://ip:8809/openbravo, so it only change the port from 80 to 8809. In the port 8809 is listening the AJP connector of the Openbravo ERP Tomcat context.

      If you are getting a time out, probably you have configured something wrong in your router, try to do a ping to the machine. Also check that the router don’t have a firewall that is blocking the return of the packages.

      If you need it, you can found the configuration files of mod_jk in /opt/OpenbravoERP-2.50/apache/conf.d/ directory.

      For get more information about mod_jk you can visit: http://tomcat.apache.org/connectors-doc/ .

      Regards

  5. bhek263 Says:

    Add Apache and connect with Tomcat using the mod_jk connector. So that now Openbravo ERP is accessed from http://ip_address/openbravo and we can use the fine tunning of Apache (e.g. gzip compression enabled)

    How does one do this. Are there commands to written on the terminal. I would be happy to get the actual steps involved in connecting Tomcat to Apache on 9.10

    • Gorka Gil Says:

      Hi bhek263,

      In the Openbravo ERP Ubuntu package this connection is already done.

      You can see the configuration files in /opt/OpenbravoERP-2.50/apache/conf.d/ , also there is a link in /etc/apache2/conf.d/ to point to the config file.

      Regards

  6. James Says:

    Hello,

    I installed openbravo sucessfully. But it’s not showing the setup functions for sales orders (only showing analysis tools and mail template setup), warehouse management (only showing Analysis tools and Generate average costs) and procurement (only showing Analysis tools) . I am new to this application. Any help would be appreciated.

    Thanks

  7. Gary Morris Says:

    I followed your instructions on installing OpenBravo ERP but it hung before it could finish installing. Now I can not open my synaptic Package Manager. I get this error:

    E: dpkg was interrupted, you must manually run ‘sudo dpkg –configure -a’ to correct the problem.
    E: _cache->open() failed, please report.

    When I run sudo dpkg –configure -a I get this:

    gary@gary-toshiba:~$ sudo dpkg –configure -a
    [sudo] password for gary:
    Setting up openbravo-erp (2.50MP-10-2) …
    The /home/openbravo/.profile file has been overwritten. You can find copy of the original file in /home/openbravo/.profile.bak
    * Starting openbravo-erp-postgresql Error: Invalid line 1 in /etc/postgresql/8.4/openbravo-erp/postgresql.conf: »�r�p� ܟ(ȟ(��(��(��(x�(d�(P�(<�((�(�(�(��(؞(Ğ(��(��(��(t�(`�(L�(8�($�(�(��(��(ԝ(��(��(��(��(p�(\�(H�(4�( �(
    �(��(��(М(��(��(��(��(l�(X�(D�(0�(��(��(��(̛(��(��(��(|�(h�(T�(@�(,�(�(�(��(ܚ(Ț(��(��(��(x�(d�(P�(<�((�(�(�(��(ؙ(ę(��(��(��(t�(`�(L�(8�($�(�(��(��(Ԙ(��(��(��(��(p�(\�(H�(4�( �(
    �(��(��(З(��(��(��(��(l�(X�(D�(0�(��(��(��(̖(��(��(��(|�(h�(T�(@�(,�(�(�(��(ܕ(ȕ(��(��(��(x�(d�(P�(<�((�(�(�(��(ؔ(Ĕ(��(��(��(t�(`�(L�(8�($�(�(��(��(ԓ(��(��(��(��(p�(abcdefghijklmnopqrstuvwxyz{|}~��������������  �� 
    «
    [fail]
    invoke-rc.d: initscript openbravo-erp-postgresql, action "start" failed.
    Setting up Openbravo ERP …
    dpkg: error processing openbravo-erp (–configure):
    subprocess installed post-installation script returned error exit status 1
    Errors were encountered while processing:
    openbravo-erp

    It still does not work and I still can not get into Synaptic Package Manager. Can you help me fix this problem please.

    I do not have to get OpenBravo to work. I just need my computer back.

    Thanks,

    Gary Morris

    • Gorka Gil Says:

      Hi Gary,

      If you only want to recover your synaptic and you don’t mind to lost all your Openbravo ERP work, you can simply remove it running in a terminal:

      sudo apt-get remove --purge openbravo-erp

      When prompt to remove database answer ‘yes’.

      In any case is a very strange error, I think there was a problem when installing like a hardware fail, hard disk full or something like this. Can you paste the content of /etc/postgresql/8.4/openbravo-erp/postgresql.conf in dpaste.com and post it here?

      Regards

  8. Gary Morris Says:

    OK, I tried to open the conf file but it seems to be unreadable. I copied it in case you would like for me to send it to you.

    I tried to run sudo apt-get remove –purge openbravo-erp and got this message.

    Reading package lists… Done
    Building dependency tree
    Reading state information… Done
    E: Couldn’t find package –purge
    gary@gary-toshiba:~$

    So I ran gary@gary-toshiba:~$ sudo apt-get remove openbravo-erp

    and this is the result:

    Reading package lists… Done
    Building dependency tree
    Reading state information… Done
    The following packages were automatically installed and are no longer required:
    liblash2 gnustep-base-common traceroute libavahi-compat-libdnssd1
    gnustep-base-runtime libwxgtk2.6-0 gnustep-gui-common gnustep-back0.16
    libgnustep-gui0.16 ttf-tahoma-replacement caps libpopplerkit0
    gnustep-back0.16-art libgnustep-base1.19 libwxbase2.6-0 gnustep-common
    lesstif2 gnustep-gpbs ttf-symbol-replacement libfluidsynth1 stk libstk0c2a
    libmpg123-0 gnustep-back-common libgconfmm-2.6-1c2 libgnome-vfsmm-2.6-1c2a
    tap-plugins gnustep-gui-runtime python-eyed3 libbakery-2.4-1
    libbakery-2.4-common libglademm-2.4-1c2a xpdf-common
    Use ‘apt-get autoremove’ to remove them.
    The following packages will be REMOVED:
    openbravo-erp
    0 upgraded, 0 newly installed, 1 to remove and 11 not upgraded.
    1 not fully installed or removed.
    After this operation, 1,091MB disk space will be freed.
    Do you want to continue [Y/n]? y
    (Reading database … 236255 files and directories currently installed.)
    Removing openbravo-erp …
    * openbravo-erp-tomcat already stopped
    * openbravo-erp-postgresql already stopped
    rm: cannot remove `/etc/apache2/conf.d/openbravo-erp.conf’: No such file or directory
    dpkg: error processing openbravo-erp (–remove):
    subprocess installed post-removal script returned error exit status 1
    Processing triggers for ureadahead …
    ureadahead will be reprofiled on next reboot
    Errors were encountered while processing:
    openbravo-erp
    E: Sub-process /usr/bin/dpkg returned an error code (1)
    gary@gary-toshiba:~$

    What should I do now?

    Thank you,

    Gary Morris

    • Gorka Gil Says:

      Hi Gary,

      In the 2.50-10-2 version of the package, the ones that you have, there is a bug that if not exists the /etc/apache2/conf.d/openbravo-erp.conf file fails to perform the remove of the package.

      But if you you run the remove with the purge option the uninstall will be done without problems.

      In the command that I previouly post, the wordpress editor change ‘- – purge’ into ‘-purge’, the correct command is:
      sudo apt-get remove --purge openbravo-erp

      Regards

  9. Gary Morris Says:

    I think all is well now.

    Thank you,

    Gary Morris

  10. Marco Says:

    Hello,

    I installed OpenBravo for testing sucessfully. It seems to work well with this package.
    But I can’t find the products I have in my warehouse from the sales form. I tryed everything but I can’t find what I’ve missed.
    I am new to this application. Any help would be appreciated.
    Thanks in advance.

    Best regards,
    Marco

  11. Krnkris Says:

    Hi Marco!

    Try to log in as a different user not Openbravo.

    I hope it’s help…

    Best regards:

    Kris

  12. Nugi Says:

    Is there a news about OB released for ubuntu 9.10?
    when will be released for production?


  13. […] months ago we started the beta testing of this package, asking the community to test it in this post. Now, thanks to the testing made by many of you, the package is ready for production. But this does […]

  14. Kris Says:

    Hello

    on ubuntu 9.10 “install openbravo-erp” give an error, the same error as with Synaptic:
    E: Sub-process :usr/bin/dpkg returnes an error code (1)

    how to solve this problem?

    Thanks

    • Gorka Gil Says:

      Hi Kris,

      Could you please include the complete the error message, you can use dpaste.org.

      Is a clean install or is an update from the openbravo-erp package for Ubuntu 9.04 ?

      Thanks

      • Kris Says:

        1)
        Instellen van openbravo-erp (2.50MP-11-4) …
        * Initializing openbravo-erp-postgresql database Creating new cluster (configuration: /etc/postgresql/8.4/openbravo-erp, data: /opt/OpenbravoERP-2.50/postgresql)…
        Moving configuration file /opt/OpenbravoERP-2.50/postgresql/postgresql.conf to /etc/postgresql/8.4/openbravo-erp…
        Moving configuration file /opt/OpenbravoERP-2.50/postgresql/pg_hba.conf to /etc/postgresql/8.4/openbravo-erp…
        Moving configuration file /opt/OpenbravoERP-2.50/postgresql/pg_ident.conf to /etc/postgresql/8.4/openbravo-erp…
        Configuring postgresql.conf to use port 5832…
        [ OK ]
        * Starting openbravo-erp-postgresql [ OK ]
        Creating the Openbravo ERP database …
        dpkg: fout bij afhandelen van openbravo-erp (–configure):
        subproces installed post-installation script gaf een foutwaarde 1 terug
        Fouten gevonden tijdens behandelen van:
        openbravo-erp
        E: Sub-process /usr/bin/dpkg returned an error code (1)

        2) 9.10 is an upgrade from 9.4

        I get the welcomscreen but i can’t acses the program.

      • Gorka Gil Says:

        Kris,

        Could you dpaste the /var/log/openbravo-erp/installation.log ?

        Thanks

      • Kris Says:

        The installation.log

        error: no alternatives for mozilla-javaplugin.so.
        update-alternatives: error: no alternatives for xulrunner-1.9-javaplugin.so.
        update-alternatives: error: no alternatives for xulrunner-1.9-javaplugin.so.
        CREATE ROLE
        UPDATE 1
        CREATE DATABASE
        pg_restore: [archiver] unsupported version (1.11) in file header

        Kris

      • Gorka Gil Says:

        Kris,

        This is a known issue https://bugs.launchpad.net/ubuntu/+source/openbravo-erp/+bug/535215 , read the comment #12.

        You have PostgreSQL 8.3 and 8.4 and the installation script don’t specified the version to use, so it uses the 8.3 commands instead of 8.4.

        A new version of the package that fix this will be available in few days in the partner repository, I will notify here when it was available.

        By the moment there is 2 possible workarounds:

        1) If you don’t use postgressql-8.3, you can uninstall it, and uninstall/install again openbravo-erp.

        2) The new version of the package that fix this is already available in launchpad.

           Enable repo in /etc/apt/sources.list, adding:
           deb http://ppa.launchpad.net/openbravo-isv/ppa/ubuntu karmic main
        
           Install the new version:
           apt-get update; apt-get remove --purge openbravo-erp; apt-get install openbravo-erp
        
           Disable launchpad repository of Openbravo ERP.
           Remove the previously line added in /etc/apt/sources.list
        

        I recommend you to wait to the update from the partners repository, if you don’t want to wait, you can use the launchpad testing repository.

        Regards

      • Kris Says:

        A new problem:

        Login OK (using Opera)
        Heartbeat configuration successfully
        I can’t close it with “close” button.
        When i close it with “X” the login screen appears again and again ….

        What to do?

        Kris

      • Gorka Gil Says:

        Kris,

        Currently the supported browsers are Firefox 3.x and Internet Explorer 7, in other browsers can works or can happen unexpected behaviors.

        Try with Firefox and if you can reproduce the problem, please report in https://issues.openbravo.com .

        In the following versions of Openbravo ERP the plan is add compatibility with more browsers:
        * Firefox 3.x+
        * IE7, IE8
        * Chrome 5+
        * Safari 4+
        * Opera 10.0+

        Thanks

  15. Kris Says:

    Hello Gorca Gil,

    I went for solution 1.
    Using Synaptic gif several errors.
    It works fine in a terminalwindow, Openbravo-erp starts.

    Thanks

  16. Gewinnspiele Says:

    hi
    i’m so glad that i saw this article. that posting was so insightful. thanks again i added the rss on this article.
    are you planning to write similar articles?


Leave a reply to Nugi Cancel reply