Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0000836
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] C. Securityminoralways2007-01-08 09:402008-06-12 09:43
ReporteralostaleView Statuspublic 
Assigned Tocromero 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0000836: Postgre on Win installation stalled

DescriptionWe have detected a bug installing Openbravo in Windows with PostgreSQL. In the GENERATING DATABASE STRUCTURE step it gets stalled.

This can be solved adding to pgpass.conf file the configuration for our server and user. For more information on this issue you can look at http://developer.postgresql.org/pgdocs/postgres/libpq-pgpass.html [^]
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0000622)
cromero (reporter)
2007-01-08 10:06
edited on: 2008-06-12 09:17

Logged In: YES
user_id=1500614
Originator: NO

This error occurs because Postgre is trying to read the password from console while we are trying to pass it as a parameter. So postgre prompts for a password and waits for it, stopping all the installation process.

You can obtain a more extensive explanation about how to configure the postgre password file here:
http://www.postgresql.org/docs/current/static/libpq-pgpass.html [^]

So, adding something like this at pgpass file it should work fine:
localhost:5432:*:tad:tad

Carlos Romero
Openbravo Team
(0000623)
user71
2007-02-21 16:45
edited on: 2008-06-12 09:17

Logged In: YES
user_id=1724901
Originator: NO

Hello sir,
 
I am getting an error on installing OpenbravoERP_2.22-PostgreSQL
 
The additional programs I installed are:
- postgresql-8.2.3-1
- apache-tomcat-5.5.20
- apache-ant-1.7.0
- jdk1.5.0_11
 
now when i try to install it,it will shows the error message,i fallow all the instruction that i read from
Openbravo_PostgreSQL_r2.11_quick-start_installation_guide_v1.0.1,now i send u the errors like this..
 
 
//////////////////////////////////////////////////////////////////////////////////////////
org.tp23.antinstaller.InstallException: Error running the install
at org.tp23.antinstaller.runtime.exe.AntProjectFilter.exec(Unknown Source)
at org.tp23.antinstaller.runtime.ExecInstall.exec(Unknown Source)
at org.tp23.antinstaller.selfextract.NonExtractor.main(Unknown Source)
Caused by: jar:file:/F:/ERP/openpsql/download.jar!/build.xml:55: org.postgresql.util.PSQLException: The connection attempt failed.
at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:314)
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:346)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java:369)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
... 3 more
Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:369)
at org.postgresql.Driver.connect(Driver.java:245)
at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:304)
... 12 more
Caused by: java.net.UnknownHostException: PostgreSQL Database Server 8.2
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.postgresql.core.PGStream.<init>(PGStream.java:58)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
... 19 more
--- Nested Exception ---
jar:file:/F:/ERP/openpsql/download.jar!/build.xml:55: org.postgresql.util.PSQLException: The connection attempt failed.
at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:314)
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:346)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java:369)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
at org.tp23.antinstaller.runtime.exe.AntProjectFilter.exec(Unknown Source)
at org.tp23.antinstaller.runtime.ExecInstall.exec(Unknown Source)
at org.tp23.antinstaller.selfextract.NonExtractor.main(Unknown Source)
Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:369)
at org.postgresql.Driver.connect(Driver.java:245)
at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:304)
... 12 more
Caused by: java.net.UnknownHostException: PostgreSQL Database Server 8.2
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.postgresql.core.PGStream.<init>(PGStream.java:58)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
... 19 more
--- Nested Exception ---
org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:369)
at org.postgresql.Driver.connect(Driver.java:245)
at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:304)
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:346)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java:369)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
at org.tp23.antinstaller.runtime.exe.AntProjectFilter.exec(Unknown Source)
at org.tp23.antinstaller.runtime.ExecInstall.exec(Unknown Source)
at org.tp23.antinstaller.selfextract.NonExtractor.main(Unknown Source)
Caused by: java.net.UnknownHostException: PostgreSQL Database Server 8.2
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.postgresql.core.PGStream.<init>(PGStream.java:58)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
... 19 more
 
 
now plz tell me the solution ASAP
thank you.
 
Hemendra Singh.
hemendrazone@gmail.com


(0000624)
user71
2007-02-21 16:45
edited on: 2008-06-12 09:17

Logged In: YES
user_id=1724901
Originator: NO

Hello sir,
 
I am getting an error on installing OpenbravoERP_2.22-PostgreSQL
 
The additional programs I installed are:
- postgresql-8.2.3-1
- apache-tomcat-5.5.20
- apache-ant-1.7.0
- jdk1.5.0_11
 
now when i try to install it,it will shows the error message,i fallow all the instruction that i read from
Openbravo_PostgreSQL_r2.11_quick-start_installation_guide_v1.0.1,now i send u the errors like this..
 
 
//////////////////////////////////////////////////////////////////////////////////////////
org.tp23.antinstaller.InstallException: Error running the install
at org.tp23.antinstaller.runtime.exe.AntProjectFilter.exec(Unknown Source)
at org.tp23.antinstaller.runtime.ExecInstall.exec(Unknown Source)
at org.tp23.antinstaller.selfextract.NonExtractor.main(Unknown Source)
Caused by: jar:file:/F:/ERP/openpsql/download.jar!/build.xml:55: org.postgresql.util.PSQLException: The connection attempt failed.
at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:314)
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:346)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java:369)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
... 3 more
Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:369)
at org.postgresql.Driver.connect(Driver.java:245)
at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:304)
... 12 more
Caused by: java.net.UnknownHostException: PostgreSQL Database Server 8.2
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.postgresql.core.PGStream.<init>(PGStream.java:58)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
... 19 more
--- Nested Exception ---
jar:file:/F:/ERP/openpsql/download.jar!/build.xml:55: org.postgresql.util.PSQLException: The connection attempt failed.
at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:314)
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:346)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java:369)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
at org.tp23.antinstaller.runtime.exe.AntProjectFilter.exec(Unknown Source)
at org.tp23.antinstaller.runtime.ExecInstall.exec(Unknown Source)
at org.tp23.antinstaller.selfextract.NonExtractor.main(Unknown Source)
Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:369)
at org.postgresql.Driver.connect(Driver.java:245)
at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:304)
... 12 more
Caused by: java.net.UnknownHostException: PostgreSQL Database Server 8.2
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.postgresql.core.PGStream.<init>(PGStream.java:58)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
... 19 more
--- Nested Exception ---
org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:369)
at org.postgresql.Driver.connect(Driver.java:245)
at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:304)
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:346)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java:369)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
at org.tp23.antinstaller.runtime.exe.AntProjectFilter.exec(Unknown Source)
at org.tp23.antinstaller.runtime.ExecInstall.exec(Unknown Source)
at org.tp23.antinstaller.selfextract.NonExtractor.main(Unknown Source)
Caused by: java.net.UnknownHostException: PostgreSQL Database Server 8.2
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.postgresql.core.PGStream.<init>(PGStream.java:58)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
... 19 more
 
 
now plz tell me the solution ASAP
thank you.
 
Hemendra Singh.
hemendrazone@gmail.com


(0000625)
user71
2007-02-21 21:50
edited on: 2008-06-12 09:17

Logged In: YES
user_id=1724901
Originator: NO

Hello sir,

I am getting an error on installing OpenbravoERP_2.22-PostgreSQL in this message i m going to tell u every thing
that i m doing to start my Openbravo,i add all the detail about the directory structure,classpath ,all the values that i suppy
during the installaction so pleses review it and tell me the problem ,if u think that i pass any wrong value than tell me the
rigth value for it

The additional programs I installed are:
- postgresql-8.2.3-1(In Dir"C:\Program Files\PostgreSQL\8.2")
- apache-tomcat-5.5.20(install In DIR"F:\ERP\apache-tomcat-5.5.20")
- apache-ant-1.7.0(Install In DIR"F:\ERP\apache-ant-1.7.0")
- jdk1.5.0_11(Install In DIR"C:\Program Files\Java\jdk1.5.0_11")
///////////////////////////////////////////////////////////////////////////////
 
I save Environment Variables in System Properties for all like this:-
  For Java:- Variable name:-JAVA_HOME
             Variable value:-C:\Program Files\Java\jdk1.5.0_11

  For tomcat:- Variable name:-CATALINA_HOME
                Variable value:-F:\ERP\apache-tomcat-5.5.20

  For apache ant:- Variable name:-ANT_HOME
                   Variable value:-F:\ERP\apache-ant-1.7.0

  For Postgresql:- Variable name:-PGDATA
                   Variable value:-C:\Program Files\PostgreSQL\8.2\bin



now the values that i pass during the installation of postgresql-8.2.3-1
###########################################################################################

First Screen:- welcome to the PostgreSQL Installation Wizard
   select the language to be used
English/English

///////////////////////////////////////////////////////////////////

now i set the location "C:\Program Files\PostgreSQL\8.2"

///////////////////////////////////////////////////////////////////


Next Screen :-
Service Configuration
service Name:- PostgreSQL Database Server 8.2
Account name:- postgres
Account domain:- NIIT-ECE3160D3F
Account password:- choudhary
verify Password:- choudhary

////////////////////////////////////////////////////////////////////

Next screen:-
initialise database cluster

Port number:- 5432
Address:-<i not select it>Accept connection on all address,not just localhost
Locale:- C
Encodung:- SQL_ASCII
Superuser name:- postgres(this is the internal database username,and not the service account)
Password:- 1234
password(again):- 1234

////////////////////////////////////////////////////////////////////////

next screen :-Enable procedural language
   and i select PL/pgsql

//////////////////////////////////////////////////////////////////////////

Next screen :- Enable contrib modules
      and i select admainpack

###########################################################################################

now the values that i pass during the installation of OpenbravoERP_2.22-PostgreSQL

###########################################################################################

First Screen:- Default option
 Backup Folder:- C:\AppsOpenbravo\backup

Database Option:-
  Database server:- PostgreSQL Database Server 8.2
  Database user:-tad
  Database user password:-tad
  Database name:-openbravo
  Port:-5432
  Install Option:- Database and source

////////////////////////////////////////////////////////////////

Next screen:-Specific datadase option
  Postgres password:- 1234

/////////////////////////////////////////////////////////////////

Next screen :-Specific Source options
   Application folder:- C:\AppsOpenbravo
   Attachments folder:- C:\AppsOpenbravo\attachment
   Special pdf fonts folder:- C:\AppsOpenbravo\fonts
   Tomcat context:- openbravo
   Web url:- http://localhost:8080/openbravo/web [^]
###########################################################################################

 and the errors that i face are:-
###########################################################################################
last screen :- Failed

it will show Output like this
////////////////////////////////////////////////////////////////////////////////////////////////////

Unable to locate tools.jar. Expected to find it in C:\Program Files\Java\jre1.5.0_11\lib\tools.jar
antinstaller.jarF:\ERP\openpsql\download.jar

uncompress:
    [unzip] Expanding: F:\ERP\openpsql\download.jar into C:\AppsOpenbravo\backup\DOWNLOAD

sqlImport:
     [echo]
     [echo] ******************************************************************
     [echo] * DROP OLD DATABASE openbravo *
     [echo] ******************************************************************
     [echo]

////////////////////////////////////////////////////////////////////////////////////////////////////

And it will show errors like this
////////////////////////////////////////////////////////////////////////////////////////////////////

org.tp23.antinstaller.InstallException: Error running the install
    at org.tp23.antinstaller.runtime.exe.AntProjectFilter.exec(Unknown Source)
    at org.tp23.antinstaller.runtime.ExecInstall.exec(Unknown Source)
    at org.tp23.antinstaller.selfextract.NonExtractor.main(Unknown Source)
Caused by: jar:file:/F:/ERP/openpsql/download.jar!/build.xml:55: org.postgresql.util.PSQLException: The connection attempt failed.
    at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:314)
    at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:346)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
    at org.apache.tools.ant.Task.perform(Task.java:364)
    at org.apache.tools.ant.Target.execute(Target.java:341)
    at org.apache.tools.ant.Target.performTasks(Target.java:369)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
    ... 3 more
Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
    at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
    at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
    at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
    at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
    at org.postgresql.Driver.makeConnection(Driver.java:369)
    at org.postgresql.Driver.connect(Driver.java:245)
    at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:304)
    ... 12 more
Caused by: java.net.UnknownHostException: PostgreSQL Database Server 8.2
    at java.net.PlainSocketImpl.connect(Unknown Source)
    at java.net.SocksSocketImpl.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.<init>(Unknown Source)
    at java.net.Socket.<init>(Unknown Source)
    at org.postgresql.core.PGStream.<init>(PGStream.java:58)
    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
    ... 19 more
--- Nested Exception ---
jar:file:/F:/ERP/openpsql/download.jar!/build.xml:55: org.postgresql.util.PSQLException: The connection attempt failed.
    at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:314)
    at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:346)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
    at org.apache.tools.ant.Task.perform(Task.java:364)
    at org.apache.tools.ant.Target.execute(Target.java:341)
    at org.apache.tools.ant.Target.performTasks(Target.java:369)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
    at org.tp23.antinstaller.runtime.exe.AntProjectFilter.exec(Unknown Source)
    at org.tp23.antinstaller.runtime.ExecInstall.exec(Unknown Source)
    at org.tp23.antinstaller.selfextract.NonExtractor.main(Unknown Source)
Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
    at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
    at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
    at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
    at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
    at org.postgresql.Driver.makeConnection(Driver.java:369)
    at org.postgresql.Driver.connect(Driver.java:245)
    at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:304)
    ... 12 more
Caused by: java.net.UnknownHostException: PostgreSQL Database Server 8.2
    at java.net.PlainSocketImpl.connect(Unknown Source)
    at java.net.SocksSocketImpl.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.<init>(Unknown Source)
    at java.net.Socket.<init>(Unknown Source)
    at org.postgresql.core.PGStream.<init>(PGStream.java:58)
    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
    ... 19 more
--- Nested Exception ---
org.postgresql.util.PSQLException: The connection attempt failed.
    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
    at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
    at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
    at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
    at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
    at org.postgresql.Driver.makeConnection(Driver.java:369)
    at org.postgresql.Driver.connect(Driver.java:245)
    at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:304)
    at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:346)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
    at org.apache.tools.ant.Task.perform(Task.java:364)
    at org.apache.tools.ant.Target.execute(Target.java:341)
    at org.apache.tools.ant.Target.performTasks(Target.java:369)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
    at org.tp23.antinstaller.runtime.exe.AntProjectFilter.exec(Unknown Source)
    at org.tp23.antinstaller.runtime.ExecInstall.exec(Unknown Source)
    at org.tp23.antinstaller.selfextract.NonExtractor.main(Unknown Source)
Caused by: java.net.UnknownHostException: PostgreSQL Database Server 8.2
    at java.net.PlainSocketImpl.connect(Unknown Source)
    at java.net.SocksSocketImpl.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.<init>(Unknown Source)
    at java.net.Socket.<init>(Unknown Source)
    at org.postgresql.core.PGStream.<init>(PGStream.java:58)
    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
    ... 19 more
###########################################################################################


this is the complet detail about that i m doing to run this Project now please reviev all the details abt tell me the complet solution i m highly thank full to u sir for this act of kindness and the time that u spand to solve my problem

Thank You.
Hemendra Singh.
hemendrazone@gmail.com




(0000626)
user71
2007-02-21 22:45
edited on: 2008-06-12 09:17

Logged In: YES
user_id=1724901
Originator: NO

every one tell me that put a line like this
localhost:5432:*:tad:tad

in pgpass.info file but the problem is that,from where i get pgpass.info file and at which place i put this line please tell the the location for this file
(0000627)
user71
2007-02-21 22:51
edited on: 2008-06-12 09:17

Logged In: YES
user_id=1724901
Originator: NO

how i create pgpass.info file
(0000628)
cromero (reporter)
2007-02-21 23:38
edited on: 2008-06-12 09:17

Logged In: YES
user_id=1500614
Originator: NO

Try with your postgres database password: choudhary

Then, you should find your pgpass.conf file into %APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile).

Carlos Romero
Openbravo Team
(0000629)
user71
2007-02-22 06:57
edited on: 2008-06-12 09:17

Logged In: YES
user_id=1724901
Originator: NO

i m enable to find pgpass.conf file please tell me the complet path dir location for my postgreQSL is "C:\Program Files\PostgreSQL\8.2" , tell me the complet path
(0000630)
user71
2007-02-22 15:18
edited on: 2008-06-12 09:17

Logged In: YES
user_id=1724901
Originator: NO

during the installaction of OpenbravoERP_2.22-PostgreSQL i face this problem tell me thr right solution

Unable to locate tools.jar. Expected to find it in C:\Program Files\Java\jre1.5.0_11\lib\tools.jar
antinstaller.jarF:\ERP\openpsql\download.jar

uncompress:
    [unzip] Expanding: F:\ERP\openpsql\download.jar into C:\AppsOpenbravo\backup\DOWNLOAD

sqlImport:
     [echo]
     [echo] ******************************************************************
     [echo] * DROP OLD DATABASE openbravo *
     [echo] ******************************************************************
     [echo]




Hemendra Singh
hemendrazone@gmail.com
(0000631)
user71
2007-02-22 15:19
edited on: 2008-06-12 09:17

Logged In: YES
user_id=1724901
Originator: NO

during the installaction of OpenbravoERP_2.22-PostgreSQL i face this problem tell me thr right solution

Unable to locate tools.jar. Expected to find it in C:\Program Files\Java\jre1.5.0_11\lib\tools.jar
antinstaller.jarF:\ERP\openpsql\download.jar

uncompress:
    [unzip] Expanding: F:\ERP\openpsql\download.jar into C:\AppsOpenbravo\backup\DOWNLOAD

sqlImport:
     [echo]
     [echo] ******************************************************************
     [echo] * DROP OLD DATABASE openbravo *
     [echo] ******************************************************************
     [echo]




Hemendra Singh
hemendrazone@gmail.com
(0000632)
user71
2007-02-22 21:14
edited on: 2008-06-12 09:17

Logged In: YES
user_id=1724901
Originator: NO

Hello sir,

I am getting an error on installing OpenbravoERP_2.22-PostgreSQL in this message i m going to tell u every thing
that i m doing to start my Openbravo,i add all the detail about the directory structure,classpath ,all the values that i suppy
during the installaction so pleses review it and tell me the problem ,if u think that i pass any wrong value than tell me the
rigth value for it

The additional programs I installed are:
- postgresql-8.2.3-1(In Dir"C:\Program Files\PostgreSQL\8.2")
- apache-tomcat-5.5.20(install In DIR"F:\ERP\apache-tomcat-5.5.20")
- apache-ant-1.7.0(Install In DIR"F:\ERP\apache-ant-1.7.0")
- jdk1.5.0_11(Install In DIR"C:\Program Files\Java\jdk1.5.0_11")
///////////////////////////////////////////////////////////////////////////////
 
I save Environment Variables in System Properties for all like this:-
  For Java:- Variable name:-JAVA_HOME
             Variable value:-C:\Program Files\Java\jdk1.5.0_11

  For tomcat:- Variable name:-CATALINA_HOME
                Variable value:-F:\ERP\apache-tomcat-5.5.20

  For apache ant:- Variable name:-ANT_HOME
                   Variable value:-F:\ERP\apache-ant-1.7.0

  For Postgresql:- Variable name:-PGDATA
                   Variable value:-C:\Program Files\PostgreSQL\8.2\bin



now the values that i pass during the installation of postgresql-8.2.3-1
###########################################################################################

First Screen:- welcome to the PostgreSQL Installation Wizard
   select the language to be used
English/English

///////////////////////////////////////////////////////////////////

now i set the location "C:\Program Files\PostgreSQL\8.2"

///////////////////////////////////////////////////////////////////


Next Screen :-
Service Configuration
service Name:- PostgreSQL Database Server 8.2
Account name:- postgres
Account domain:- NIIT-ECE3160D3F
Account password:- 1234
verify Password:- 1234

////////////////////////////////////////////////////////////////////

Next screen:-
initialise database cluster

Port number:- 5432
Address:-<i not select it>Accept connection on all address,not just localhost
Locale:- C
Encodung:- SQL_ASCII
Superuser name:- postgres(this is the internal database username,and not the service account)
Password:- 12345
password(again):- 12345

////////////////////////////////////////////////////////////////////////

next screen :-Enable procedural language
   and i select PL/pgsql

//////////////////////////////////////////////////////////////////////////

Next screen :- Enable contrib modules
      and i select admainpack

###########################################################################################

now the values that i pass during the installation of OpenbravoERP_2.22-PostgreSQL

###########################################################################################

First Screen:- Default option
 Backup Folder:- C:\AppsOpenbravo\backup

Database Option:-
  Database server:- PostgreSQL Database Server 8.2
  Database user:-tad
  Database user password:-tad
  Database name:-openbravo
  Port:-5432
  Install Option:- Database and source

////////////////////////////////////////////////////////////////

Next screen:-Specific datadase option
  Postgres password:- 12345

/////////////////////////////////////////////////////////////////

Next screen :-Specific Source options
   Application folder:- C:\AppsOpenbravo
   Attachments folder:- C:\AppsOpenbravo\attachment
   Special pdf fonts folder:- C:\AppsOpenbravo\fonts
   Tomcat context:- openbravo
   Web url:- http://localhost:8080/openbravo/web [^]
###########################################################################################

 and the errors that i face are:-
###########################################################################################
last screen :- Failed

it will show Output like this
///////////////////////////////////////////////////////////////////////////////////////////

Unable to locate tools.jar. Expected to find it in C:\Program Files\Java\jre1.5.0_11\lib\tools.jar
antinstaller.jarF:\ERP\openpsql\download.jar

uncompress:
    [unzip] Expanding: F:\ERP\openpsql\download.jar into C:\AppsOpenbravo\backup\DOWNLOAD

sqlImport:
     [echo]
     [echo] ******************************************************************
     [echo] * DROP OLD DATABASE openbravo *
     [echo] ******************************************************************
     [echo]
      [sql] Executing commands
      [sql] 1 of 1 SQL statements executed successfully
     [echo]
     [echo] ******************************************************************
     [echo] * DROP OLD USER tad *
     [echo] ******************************************************************
     [echo]
      [sql] Executing commands
      [sql] 1 of 1 SQL statements executed successfully
     [echo]
     [echo] ******************************************************************
     [echo] * CREATE USER tad *
     [echo] ******************************************************************
     [echo]
      [sql] Executing commands
      [sql] 2 of 2 SQL statements executed successfully
     [echo]
     [echo] ******************************************************************
     [echo] * CREATE DATABASE openbravo *
     [echo] ******************************************************************
     [echo]
      [sql] Executing commands
      [sql] 1 of 1 SQL statements executed successfully
     [echo]
     [echo] ******************************************************************
     [echo] * GENERATING DATABASE STRUCTURE *
     [echo] ******************************************************************
     [echo]
   

///////////////////////////////////////////////////////////////////////////////////////////

And it will show errors like this
///////////////////////////////////////////////////////////////////////////////////////////

org.tp23.antinstaller.InstallException: Error running the install
    at org.tp23.antinstaller.runtime.exe.AntProjectFilter.exec(Unknown Source)
    at org.tp23.antinstaller.runtime.ExecInstall.exec(Unknown Source)
    at org.tp23.antinstaller.selfextract.NonExtractor.main(Unknown Source)
Caused by: jar:file:/F:/ERP/openpsql/download.jar!/build.xml:112: Execute failed: java.io.IOException: CreateProcess: pg_restore -i -h localhost -p 5432 -U tad -d openbravo -v -O C:\AppsOpenbravo\backup/DOWNLOAD/TAD.DMP error=2
    at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:620)
    at org.apache.tools.ant.taskdefs.ExecTask.execute(ExecTask.java:452)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
    at org.apache.tools.ant.Task.perform(Task.java:364)
    at org.apache.tools.ant.Target.execute(Target.java:341)
    at org.apache.tools.ant.Target.performTasks(Target.java:369)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
    ... 3 more
Caused by: java.io.IOException: CreateProcess: pg_restore -i -h localhost -p 5432 -U tad -d openbravo -v -O C:\AppsOpenbravo\backup/DOWNLOAD/TAD.DMP error=2
    at java.lang.ProcessImpl.create(Native Method)
    at java.lang.ProcessImpl.<init>(Unknown Source)
    at java.lang.ProcessImpl.start(Unknown Source)
    at java.lang.ProcessBuilder.start(Unknown Source)
    at java.lang.Runtime.exec(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.apache.tools.ant.taskdefs.Execute$Java13CommandLauncher.exec(Execute.java:834)
    at org.apache.tools.ant.taskdefs.Execute.launch(Execute.java:435)
    at org.apache.tools.ant.taskdefs.Execute.execute(Execute.java:449)
    at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.java:576)
    at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:617)
    ... 12 more
--- Nested Exception ---
jar:file:/F:/ERP/openpsql/download.jar!/build.xml:112: Execute failed: java.io.IOException: CreateProcess: pg_restore -i -h localhost -p 5432 -U tad -d openbravo -v -O C:\AppsOpenbravo\backup/DOWNLOAD/TAD.DMP error=2
    at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:620)
    at org.apache.tools.ant.taskdefs.ExecTask.execute(ExecTask.java:452)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
    at org.apache.tools.ant.Task.perform(Task.java:364)
    at org.apache.tools.ant.Target.execute(Target.java:341)
    at org.apache.tools.ant.Target.performTasks(Target.java:369)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
    at org.tp23.antinstaller.runtime.exe.AntProjectFilter.exec(Unknown Source)
    at org.tp23.antinstaller.runtime.ExecInstall.exec(Unknown Source)
    at org.tp23.antinstaller.selfextract.NonExtractor.main(Unknown Source)
Caused by: java.io.IOException: CreateProcess: pg_restore -i -h localhost -p 5432 -U tad -d openbravo -v -O C:\AppsOpenbravo\backup/DOWNLOAD/TAD.DMP error=2
    at java.lang.ProcessImpl.create(Native Method)
    at java.lang.ProcessImpl.<init>(Unknown Source)
    at java.lang.ProcessImpl.start(Unknown Source)
    at java.lang.ProcessBuilder.start(Unknown Source)
    at java.lang.Runtime.exec(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.apache.tools.ant.taskdefs.Execute$Java13CommandLauncher.exec(Execute.java:834)
    at org.apache.tools.ant.taskdefs.Execute.launch(Execute.java:435)
    at org.apache.tools.ant.taskdefs.Execute.execute(Execute.java:449)
    at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.java:576)
    at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:617)
    ... 12 more
--- Nested Exception ---
java.io.IOException: CreateProcess: pg_restore -i -h localhost -p 5432 -U tad -d openbravo -v -O C:\AppsOpenbravo\backup/DOWNLOAD/TAD.DMP error=2
    at java.lang.ProcessImpl.create(Native Method)
    at java.lang.ProcessImpl.<init>(Unknown Source)
    at java.lang.ProcessImpl.start(Unknown Source)
    at java.lang.ProcessBuilder.start(Unknown Source)
    at java.lang.Runtime.exec(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.apache.tools.ant.taskdefs.Execute$Java13CommandLauncher.exec(Execute.java:834)
    at org.apache.tools.ant.taskdefs.Execute.launch(Execute.java:435)
    at org.apache.tools.ant.taskdefs.Execute.execute(Execute.java:449)
    at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.java:576)
    at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:617)
    at org.apache.tools.ant.taskdefs.ExecTask.execute(ExecTask.java:452)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
    at org.apache.tools.ant.Task.perform(Task.java:364)
    at org.apache.tools.ant.Target.execute(Target.java:341)
    at org.apache.tools.ant.Target.performTasks(Target.java:369)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
    at org.tp23.antinstaller.runtime.exe.AntProjectFilter.exec(Unknown Source)
    at org.tp23.antinstaller.runtime.ExecInstall.exec(Unknown Source)
    at org.tp23.antinstaller.selfextract.NonExtractor.main(Unknown Source)
###########################################################################################


this is the complet detail about that i m doing to run this Project now please reviev all the details abt tell me the complet solution i m highly thank full to u sir for this act of kindness and the time that u spand to solve my problem

Thank You.
Hemendra Singh.
hemendrazone@gmail.com




(0000633)
user71
2007-02-22 21:17
edited on: 2008-06-12 09:17

Logged In: YES
user_id=1724901
Originator: NO

Hello sir,

I am getting an error on installing OpenbravoERP_2.22-PostgreSQL in this message i m going to tell u every thing
that i m doing to start my Openbravo,i add all the detail about the directory structure,classpath ,all the values that i suppy
during the installaction so pleses review it and tell me the problem ,if u think that i pass any wrong value than tell me the
rigth value for it

The additional programs I installed are:
- postgresql-8.2.3-1(In Dir"C:\Program Files\PostgreSQL\8.2")
- apache-tomcat-5.5.20(install In DIR"F:\ERP\apache-tomcat-5.5.20")
- apache-ant-1.7.0(Install In DIR"F:\ERP\apache-ant-1.7.0")
- jdk1.5.0_11(Install In DIR"C:\Program Files\Java\jdk1.5.0_11")
///////////////////////////////////////////////////////////////////////////////
 
I save Environment Variables in System Properties for all like this:-
  For Java:- Variable name:-JAVA_HOME
             Variable value:-C:\Program Files\Java\jdk1.5.0_11

  For tomcat:- Variable name:-CATALINA_HOME
                Variable value:-F:\ERP\apache-tomcat-5.5.20

  For apache ant:- Variable name:-ANT_HOME
                   Variable value:-F:\ERP\apache-ant-1.7.0

  For Postgresql:- Variable name:-PGDATA
                   Variable value:-C:\Program Files\PostgreSQL\8.2\bin



now the values that i pass during the installation of postgresql-8.2.3-1
###########################################################################################

First Screen:- welcome to the PostgreSQL Installation Wizard
   select the language to be used
English/English

///////////////////////////////////////////////////////////////////

now i set the location "C:\Program Files\PostgreSQL\8.2"

///////////////////////////////////////////////////////////////////


Next Screen :-
Service Configuration
service Name:- PostgreSQL Database Server 8.2
Account name:- postgres
Account domain:- NIIT-ECE3160D3F
Account password:- 1234
verify Password:- 1234

////////////////////////////////////////////////////////////////////

Next screen:-
initialise database cluster

Port number:- 5432
Address:-<i not select it>Accept connection on all address,not just localhost
Locale:- C
Encodung:- SQL_ASCII
Superuser name:- postgres(this is the internal database username,and not the service account)
Password:- 12345
password(again):- 12345

////////////////////////////////////////////////////////////////////////

next screen :-Enable procedural language
   and i select PL/pgsql

//////////////////////////////////////////////////////////////////////////

Next screen :- Enable contrib modules
      and i select admainpack

###########################################################################################

now the values that i pass during the installation of OpenbravoERP_2.22-PostgreSQL

###########################################################################################

First Screen:- Default option
 Backup Folder:- C:\AppsOpenbravo\backup

Database Option:-
  Database server:- PostgreSQL Database Server 8.2
  Database user:-tad
  Database user password:-tad
  Database name:-openbravo
  Port:-5432
  Install Option:- Database and source

////////////////////////////////////////////////////////////////

Next screen:-Specific datadase option
  Postgres password:- 12345

/////////////////////////////////////////////////////////////////

Next screen :-Specific Source options
   Application folder:- C:\AppsOpenbravo
   Attachments folder:- C:\AppsOpenbravo\attachment
   Special pdf fonts folder:- C:\AppsOpenbravo\fonts
   Tomcat context:- openbravo
   Web url:- http://localhost:8080/openbravo/web [^]
###########################################################################################

 and the errors that i face are:-
###########################################################################################
last screen :- Failed

it will show Output like this
///////////////////////////////////////////////////////////////////////////////////////////

Unable to locate tools.jar. Expected to find it in C:\Program Files\Java\jre1.5.0_11\lib\tools.jar
antinstaller.jarF:\ERP\openpsql\download.jar

uncompress:
    [unzip] Expanding: F:\ERP\openpsql\download.jar into C:\AppsOpenbravo\backup\DOWNLOAD

sqlImport:
     [echo]
     [echo] ******************************************************************
     [echo] * DROP OLD DATABASE openbravo *
     [echo] ******************************************************************
     [echo]
      [sql] Executing commands
      [sql] 1 of 1 SQL statements executed successfully
     [echo]
     [echo] ******************************************************************
     [echo] * DROP OLD USER tad *
     [echo] ******************************************************************
     [echo]
      [sql] Executing commands
      [sql] 1 of 1 SQL statements executed successfully
     [echo]
     [echo] ******************************************************************
     [echo] * CREATE USER tad *
     [echo] ******************************************************************
     [echo]
      [sql] Executing commands
      [sql] 2 of 2 SQL statements executed successfully
     [echo]
     [echo] ******************************************************************
     [echo] * CREATE DATABASE openbravo *
     [echo] ******************************************************************
     [echo]
      [sql] Executing commands
      [sql] 1 of 1 SQL statements executed successfully
     [echo]
     [echo] ******************************************************************
     [echo] * GENERATING DATABASE STRUCTURE *
     [echo] ******************************************************************
     [echo]
   

///////////////////////////////////////////////////////////////////////////////////////////

And it will show errors like this
///////////////////////////////////////////////////////////////////////////////////////////

org.tp23.antinstaller.InstallException: Error running the install
    at org.tp23.antinstaller.runtime.exe.AntProjectFilter.exec(Unknown Source)
    at org.tp23.antinstaller.runtime.ExecInstall.exec(Unknown Source)
    at org.tp23.antinstaller.selfextract.NonExtractor.main(Unknown Source)
Caused by: jar:file:/F:/ERP/openpsql/download.jar!/build.xml:112: Execute failed: java.io.IOException: CreateProcess: pg_restore -i -h localhost -p 5432 -U tad -d openbravo -v -O C:\AppsOpenbravo\backup/DOWNLOAD/TAD.DMP error=2
    at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:620)
    at org.apache.tools.ant.taskdefs.ExecTask.execute(ExecTask.java:452)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
    at org.apache.tools.ant.Task.perform(Task.java:364)
    at org.apache.tools.ant.Target.execute(Target.java:341)
    at org.apache.tools.ant.Target.performTasks(Target.java:369)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
    ... 3 more
Caused by: java.io.IOException: CreateProcess: pg_restore -i -h localhost -p 5432 -U tad -d openbravo -v -O C:\AppsOpenbravo\backup/DOWNLOAD/TAD.DMP error=2
    at java.lang.ProcessImpl.create(Native Method)
    at java.lang.ProcessImpl.<init>(Unknown Source)
    at java.lang.ProcessImpl.start(Unknown Source)
    at java.lang.ProcessBuilder.start(Unknown Source)
    at java.lang.Runtime.exec(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.apache.tools.ant.taskdefs.Execute$Java13CommandLauncher.exec(Execute.java:834)
    at org.apache.tools.ant.taskdefs.Execute.launch(Execute.java:435)
    at org.apache.tools.ant.taskdefs.Execute.execute(Execute.java:449)
    at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.java:576)
    at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:617)
    ... 12 more
--- Nested Exception ---
jar:file:/F:/ERP/openpsql/download.jar!/build.xml:112: Execute failed: java.io.IOException: CreateProcess: pg_restore -i -h localhost -p 5432 -U tad -d openbravo -v -O C:\AppsOpenbravo\backup/DOWNLOAD/TAD.DMP error=2
    at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:620)
    at org.apache.tools.ant.taskdefs.ExecTask.execute(ExecTask.java:452)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
    at org.apache.tools.ant.Task.perform(Task.java:364)
    at org.apache.tools.ant.Target.execute(Target.java:341)
    at org.apache.tools.ant.Target.performTasks(Target.java:369)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
    at org.tp23.antinstaller.runtime.exe.AntProjectFilter.exec(Unknown Source)
    at org.tp23.antinstaller.runtime.ExecInstall.exec(Unknown Source)
    at org.tp23.antinstaller.selfextract.NonExtractor.main(Unknown Source)
Caused by: java.io.IOException: CreateProcess: pg_restore -i -h localhost -p 5432 -U tad -d openbravo -v -O C:\AppsOpenbravo\backup/DOWNLOAD/TAD.DMP error=2
    at java.lang.ProcessImpl.create(Native Method)
    at java.lang.ProcessImpl.<init>(Unknown Source)
    at java.lang.ProcessImpl.start(Unknown Source)
    at java.lang.ProcessBuilder.start(Unknown Source)
    at java.lang.Runtime.exec(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.apache.tools.ant.taskdefs.Execute$Java13CommandLauncher.exec(Execute.java:834)
    at org.apache.tools.ant.taskdefs.Execute.launch(Execute.java:435)
    at org.apache.tools.ant.taskdefs.Execute.execute(Execute.java:449)
    at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.java:576)
    at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:617)
    ... 12 more
--- Nested Exception ---
java.io.IOException: CreateProcess: pg_restore -i -h localhost -p 5432 -U tad -d openbravo -v -O C:\AppsOpenbravo\backup/DOWNLOAD/TAD.DMP error=2
    at java.lang.ProcessImpl.create(Native Method)
    at java.lang.ProcessImpl.<init>(Unknown Source)
    at java.lang.ProcessImpl.start(Unknown Source)
    at java.lang.ProcessBuilder.start(Unknown Source)
    at java.lang.Runtime.exec(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.apache.tools.ant.taskdefs.Execute$Java13CommandLauncher.exec(Execute.java:834)
    at org.apache.tools.ant.taskdefs.Execute.launch(Execute.java:435)
    at org.apache.tools.ant.taskdefs.Execute.execute(Execute.java:449)
    at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.java:576)
    at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:617)
    at org.apache.tools.ant.taskdefs.ExecTask.execute(ExecTask.java:452)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
    at org.apache.tools.ant.Task.perform(Task.java:364)
    at org.apache.tools.ant.Target.execute(Target.java:341)
    at org.apache.tools.ant.Target.performTasks(Target.java:369)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
    at org.tp23.antinstaller.runtime.exe.AntProjectFilter.exec(Unknown Source)
    at org.tp23.antinstaller.runtime.ExecInstall.exec(Unknown Source)
    at org.tp23.antinstaller.selfextract.NonExtractor.main(Unknown Source)
###########################################################################################


this is the complet detail about that i m doing to run this Project now please reviev all the details abt tell me the complet solution i m highly thank full to u sir for this act of kindness and the time that u spand to solve my problem

Thank You.
Hemendra Singh.
hemendrazone@gmail.com




(0004425)
user71
2005-06-01 00:00
edited on: 2008-06-12 09:43

This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1630353 [^]

- Issue History
Date Modified Username Field Change


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker