Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0000836 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] C. Security | minor | always | 2007-01-08 09:40 | 2008-06-12 09:43 | |||
Reporter | alostale | View Status | public | |||||
Assigned To | cromero | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0000836: Postgre on Win installation stalled | |||||||
Description | We 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 [^] | |||||||
Tags | No 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 [^] |
Copyright © 2000 - 2009 MantisBT Group |