Im trying to do an install on a FC4 installation, and after resolving the dead postgresql mirror problem i get this error:
./RUN_setup.sh: line 41: utils/RUN_UnixEnv.sh: No such file or directory
Any good ideas?
I am trying this script.. but it fails...
Resolving ftp13.us.postgresql.org... 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?
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.
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
*** 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:58.832 ConfigurationData.load: Defaults
20:00:07.311 Config.test: OK: JavaHome=/home/jaksarx/product/8.0.3/java 
20:00:07.330 Config.test: OK: Version=1.4.2_06 
20:00:07.333 ConfigurationData.testCompiere: OK: CompiereHome = /home/jaksarx/product/8.0.3/Compiere2 
20:00:07.358 KeyStoreMgt.<init>: /home/jaksarx/product/8.0.3/Compiere2/keystore/myKeystore 
20:00:07.410 KeyStoreMgt.createCertificate: 
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 
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 
20:00:17.846 KeyStoreMgt.getCertificate: Alias=compiere 
20:00:17.855 ConfigurationData.testCompiere: OK: KeyStore = /home/jaksarx/product/8.0.3/Compiere2/keystore/myKeystore 
20:00:17.857 Config.test: OK: AppsServer = malikovec/127.0.0.2 
20:00:17.859 Config.test: OK: Deploy Directory = /home/jaksarx/product/8.0.3/Compiere2/jboss/server/compiere/deploy 
20:00:18.007 Config.test: OK: JNPPort = 1099 
20:00:18.238 Config.test: OK: Web Port = 8080 
20:00:18.763 Config.test: OK: SSL Port = 4443 
20:00:18.764 Config.test: OK: Database Server = /192.168.1.102 
20:00:18.920 Config.test: OK: Database Port = 5432 
===========> Config.testJDBC: org.postgresql.util.PSQLException: Connection rejected: FATAL: missing or erroneous pg_hba.conf file. 
===========> ConfigurationData.test: Error connecting: jdbc:postgresql://192.168.1.102:5432/template1 - postgres/ 
===========> ConfigurationPanel$1.finished: Error JDBC Connection
(Error connecting: jdbc:postgresql://192.168.1.102:5432/template1 - postgres/) 
I haven't changed anything inside pg_hba.conf in my ~/product/8.0.3/pgdata directory:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
host all all /32 trust
Can anyone tell me what am I missing here?
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 127.0.0.2. So I modified my pg_hba.conf to include the line:
host all all 127.0.0.2/32 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?
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!
Thanks for update... will keep watching :)
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.
The script must be changed to allow for the new ftp site. ftp13 could not be found. I just changed it to :
(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: Leaving directory `/home/clu1/product/src/bld/postgresql-8.1.3/config'
PostgreSQL installation complete.
./pg_ent_and_cl_gen.sh: line 485: cd: contrib/pg_autovacuum: No such file or directory
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.
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?
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?
I'm going to be trying this soon. Please post if you're successful.
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.
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.
It looks like the script download link is broken possibly due to a domain name change. A little searching turned up the following link that seems to work.
Haven't tried the script yet, but it looks like the right one.
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.