--13:04:14-- ftp://ftp13.us.postgresql.org/mirror/postgresql/latest/postgresql-8.0.3.tar.bz2
=> `postgresql-8.0.3.tar.bz2'
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?
TIA
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
GeeJay
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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?
Thank you,
Robert
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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?
Take care,
Robert
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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!
-Jonah
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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 "ftp://ftp.us.postgresql.org/pub/mirrors/postgresql/latest/postgresql-8.1.3.tar.bz2"
(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.
./pg_ent_and_cl_gen.sh: line 485: cd: contrib/pg_autovacuum: No such file or directory
ERROR!
:.-)
Al
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
Cheers,
Anders
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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?
Regards,
Al (LActive)
.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
--John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
Srinivas
www.synbizsolutions.com
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
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
./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...
--13:04:14-- ftp://ftp13.us.postgresql.org/mirror/postgresql/latest/postgresql-8.0.3.tar.bz2
=> `postgresql-8.0.3.tar.bz2'
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?
TIA
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.
GeeJay
Hi,
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/127.0.0.2 [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 = /192.168.1.102 [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://192.168.1.102:5432/template1 - postgres/ [11]
===========> ConfigurationPanel$1.finished: Error JDBC Connection
(Error connecting: jdbc:postgresql://192.168.1.102:5432/template1 - postgres/) [12]
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?
Thank you,
Robert
Hi,
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?
Take care,
Robert
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!
-Jonah
Hi Jonah,
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.
Thank you.
The script must be changed to allow for the new ftp site. ftp13 could not be found. I just changed it to :
wget "ftp://ftp.us.postgresql.org/pub/mirrors/postgresql/latest/postgresql-8.1.3.tar.bz2"
(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.
./pg_ent_and_cl_gen.sh: line 485: cd: contrib/pg_autovacuum: No such file or directory
ERROR!
:.-)
Al
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.
Cheers,
Anders
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?
Regards,
Al (LActive)
.
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.
--John
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.
Srinivas
www.synbizsolutions.com
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.
http://w3.cnm.edu/~jharris/CompiereLibero/install/scripts/pg_ent_and_cl_gen.sh
Haven't tried the script yet, but it looks like the right one.
Thanks,
Paul