Compiere on PostgreSQL Install Script

<< < 1 2 (Page 2 of 2)
  • jason_bourne

    jason_bourne - 2005-07-24

    Im trying to do an install on a FC4 installation, and after resolving the dead postgresql mirror problem i get this error:

    Install Compiere Server

    Setup Dialog

    Exception in thread "main" java.lang.NoClassDefFoundError: COMPIERE_HOME=/home/compiereadm/product/8/0/3/Compiere2/

    Make .sh executable

    ./ line 41: utils/ No such file or directory

    Any good ideas?

  • Meh

    Meh - 2005-11-03

    I am trying this script.. but it fails...

               => `postgresql-8.0.3.tar.bz2'
    Resolving failed: Name or service not known.

    I guess that I have a problem reaching the ftp site, can I change that ftp to another?  if so, how? & where do I find the ftp addresses?


  • GeeJay

    GeeJay - 2005-11-07

    Compiere on postgreSQL is a great project and the messages regarding the ease of installation are encouraging.

    Is anyone using this combo in live production ?

    As I understand Compiere Libero does not rely only on the new database independence layer to achieve compatibility but that also some things in other Compiere parts had to be changed too. Is this correct ?

    If so this would make it harder to keep up with Compiere upgrades I presume. Are there any plans to change this ?

    Thanks for your comments.


  • Robert Jaksa

    Robert Jaksa - 2005-11-21


    I'm using SUSE LINUX 10.0 and the initial setup test  fails, apparently due to an error with pg_hba.conf file. Here's what setup dialog reported:
    Install Compiere Server
    Setup Dialog
    *** 2005-11-21 18:51:49.765 Compiere Log (CLogConsole) ***
    18:51:49.765   CLogMgt.setLevel: CONFIG
    18:51:57.027 Setup.<init>: Compiere(r) Release 2.5.2b_2005-02-26 - Smart ERP & CRM - (c) 1999-2005 Compiere (r); Implementation: e-Evolution,S.C. 20050321-1502 - Supported
    18:51:57.748 AEnv.showCenterScreen:
    18:51:58.832 ConfigurationData.load: Defaults
    20:00:07.311 Config.test: OK: JavaHome=/home/jaksarx/product/8.0.3/java [11]
    20:00:07.330 Config.test: OK: Version=1.4.2_06 [11]
    20:00:07.333 ConfigurationData.testCompiere: OK: CompiereHome = /home/jaksarx/product/8.0.3/Compiere2 [11]
    20:00:07.358 KeyStoreMgt.<init>: /home/jaksarx/product/8.0.3/Compiere2/keystore/myKeystore [11]
    20:00:07.410 KeyStoreMgt.createCertificate:  [11]
    20:00:15.127 KeyStoreMgt.keytool: keytool -genkey -keyalg rsa -alias compiere -dname "CN=malikovec.semic, OU=jaksarx, O=CompiereUser, L=MyTown, C=US" -keypass myPassword -validity 365 -keystore /home/jaksarx/product/8.0.3/Compiere2/keystore/myKeystore -storepass myPassword [11]
    20:00:17.642 KeyStoreMgt.keytool: keytool -selfcert -alias compiere -dname "CN=malikovec.semic, OU=jaksarx, O=CompiereUser, L=MyTown, C=US" -keypass myPassword -validity 180 -keystore /home/jaksarx/product/8.0.3/Compiere2/keystore/myKeystore -storepass myPassword [11]
    20:00:17.846   KeyStoreMgt.getCertificate: Alias=compiere [11]
    20:00:17.855 ConfigurationData.testCompiere: OK: KeyStore = /home/jaksarx/product/8.0.3/Compiere2/keystore/myKeystore [11]
    20:00:17.857 Config.test: OK: AppsServer = malikovec/ [11]
    20:00:17.859 Config.test: OK: Deploy Directory = /home/jaksarx/product/8.0.3/Compiere2/jboss/server/compiere/deploy [11]
    20:00:18.007 Config.test: OK: JNPPort = 1099 [11]
    20:00:18.238 Config.test: OK: Web Port = 8080 [11]
    20:00:18.763 Config.test: OK: SSL Port = 4443 [11]
    20:00:18.764 Config.test: OK: Database Server = / [11]
    20:00:18.920 Config.test: OK: Database Port = 5432 [11]
    ===========> Config.testJDBC: org.postgresql.util.PSQLException: Connection rejected: FATAL: missing or erroneous pg_hba.conf file. [11]
    ===========> ConfigurationData.test: Error connecting: jdbc:postgresql:// - postgres/ [11]
    ===========> ConfigurationPanel$1.finished: Error JDBC Connection
    (Error connecting: jdbc:postgresql:// - postgres/) [12]

    I haven't changed anything inside pg_hba.conf in my ~/product/8.0.3/pgdata directory:

    # "local" is for Unix domain socket connections only
    local   all         all                               trust
    # IPv4 local connections:
    host    all         all          trust
    # IPv6 local connections:
    host    all         all         ::1/128               trust
    host all all /32 trust

    Can anyone tell me what am I missing here?

    Thank you,

    • Robert Jaksa

      Robert Jaksa - 2005-11-24


      I'm replying to my own message. Hopefully it'll help someone else with the same problem. After some time of checking and tracing logs and all I realized that the database is set to the address So I modified my pg_hba.conf to include the line:
      host all all  trust

      Then I was able to proceed and the setup completed successfully.

      I don't know where does this address come from? Does PostgeSQL or Compiere create its database on this address?

      Take care,

  • Jonah H. Harris

    Jonah H. Harris - 2005-11-21

    Hey everyone,

    In the last few months I've switched jobs and moved across the US.  I'm now working for EnterpriseDB and have been unable to devote much time to this script.  I will provide an updated version for PostgreSQL 8.1 as-well-as EnterpriseDB.

    Look for it soon!


  • Meh

    Meh - 2005-11-22

    Hi Jonah,
    Thanks for update... will keep watching  :)

  • David

    David - 2006-01-15

    Thank you for this script, the script works like a charm, I tried to install Compiere many times before, this is the only time I was able.
    Thank you.

  • Anonymous - 2006-02-16

    The script must be changed to allow for the new ftp site. ftp13 could not be found. I just changed it to :
    wget ""
    (note ftp13 => ftp, add /pub and mirrors ipo mirror)

    "postgresql-8.0.3.tar.bz2" is not available anymore on this ftp server.

    Almost at the end, I get following error:.

    make[1]: Leaving directory `/home/clu1/product/src/bld/postgresql-8.1.3/config'
    PostgreSQL installation complete.
    ./ line 485: cd: contrib/pg_autovacuum: No such file or directory


  • Anders Fredriksson

    So, I got the script working after some changes:

    1. pg_autovacuum -- Removed it from contrib make since it now belongs to the main postgresql distro.

    2. PGSQLDIR needs to be set in order to get PL/JAVA to compile.

    3. After changing the wgets to download the latest versions of pgsql, pljava and jdbc drivers, I also needed to update the script with the new path names.


  • Anonymous - 2006-02-28

    Hi Anders,

    I am a newbie at this. Could you give more detail on POS 1., 2., and 3. please. I think I got 3. working just to get the files, but not for the latest versions of pgsql, pljava and jdbc drivers.

    Could you add a link here to your adapted script please?


    Al (LActive)


  • John huttley

    John huttley - 2006-03-07

    Hi, I've just been using the install script as a manual guide on my gentoo system.
    I'd like to use compiere 2.5.3 (current as of posting) rather than 2.5.2 from Jonah.

    I can't import the database dump format.

    Has anyone done this?

  • kaygee

    kaygee - 2006-03-07

    I'm going to be trying this soon. Please post if you're successful.

  • John huttley

    John huttley - 2006-03-07

    I spent a while looking at this.
    The DMP format is a proprietary, binary format. There is no way to import it into anything but oracle.
    So I think what Jonah did was to set up compiere with oracle and then wrote a custom program to dump the DB into pg_dump format, which is pure sql text.

    So the question is, if I loaded up Jonahs' 2.5.2 into 2.5.3, would it perform an automatic upgrade?
    That would probably involve a lot of DDL statements, so I'm not confident.

    I think we will have to repeat Jonahs' work.

  • srinivas.k

    srinivas.k - 2007-04-02

    I was just wondering, why not we make an OPEN SQL layer (hypothetical ) which can communicate with standard databases. Using this concept we can make Compiere independent of datbase platforms and it also makes coding easier.

    Did anyone start working on this concept, If yes I am ready to participate.


<< < 1 2 (Page 2 of 2)

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks