[GENERAL] ask for help about postgresql
hi, I'm trying to instal postgresql to support an open-source software named dspace. I have already installed sdk, tomcat5, postgresql8.0.3, but when I install dspace, I met error says [java] Exception:java.net.SocketException: Invalid argument or cannot assign requested address. I think perhaps there some porblem in the install and configure of postgresql. Would you please help me to solve this problem? Thank you. majx [EMAIL PROTECTED] dspace-1.3.1-source]# ant fresh_install Buildfile: build.xml compile: install_code: build_wars: init_configs: setup_database: [java] 2005-08-11 11:27:31,152 INFO org.dspace.storage.rdbms.InitializeDat abase @ Initializing Database [java] 2005-08-11 11:27:31,637 FATAL org.dspace.storage.rdbms.InitializeDat abase @ Caught exception: [java] org.postgresql.util.PSQLException: try to connect unsuccessed [java] Exception:java.net.SocketException: Invalid argument or cannot assi gn requested address [java] Stack Trace: [java] java.net.SocketException: Invalid argument or cannot assign requeste d address [java] at java.net.PlainSocketImpl.socketConnect(Native Method) [java] at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305) [java] at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.jav a:171) [java] at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158) [java] at java.net.Socket.connect(Socket.java:452) [java] at java.net.Socket.connect(Socket.java:402) [java] at java.net.Socket.init(Socket.java:309) [java] at java.net.Socket.init(Socket.java:124) [java] at org.postgresql.core.PGStream.init(PGStream.java:58) [java] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionIm pl(ConnectionFactoryImpl.java:77) [java] at org.postgresql.core.ConnectionFactory.openConnection(Connecti onFactory.java:65) [java] at org.postgresql.jdbc2.AbstractJdbc2Connection.init(AbstractJ dbc2Connection.java:117) [java] at org.postgresql.jdbc2.Jdbc2Connection.init(Jdbc2Connection.j ava:24) [java] at org.postgresql.Driver.connect(Driver.java:235) [java] at java.sql.DriverManager.getConnection(DriverManager.java:512) [java] at java.sql.DriverManager.getConnection(DriverManager.java:171) [java] at org.apache.commons.dbcp.DriverManagerConnectionFactory.create Connection(DriverManagerConnectionFactory.java:48) [java] at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject( PoolableConnectionFactory.java:290) [java] at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(G enericObjectPool.java:771) [java] at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.j ava:175) [java] at java.sql.DriverManager.getConnection(DriverManager.java:512) [java] at java.sql.DriverManager.getConnection(DriverManager.java:193) [java] at org.dspace.storage.rdbms.DatabaseManager.getConnection(Databa seManager.java:446) [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseMana ger.java:777) [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDa tabase.java:71) [java] End of Stack Trace [java] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionIm pl(ConnectionFactoryImpl.java:136) [java] at org.postgresql.core.ConnectionFactory.openConnection(Connecti onFactory.java:65) [java] at org.postgresql.jdbc2.AbstractJdbc2Connection.init(AbstractJ dbc2Connection.java:117) [java] at org.postgresql.jdbc2.Jdbc2Connection.init(Jdbc2Connection.j ava:24) [java] at org.postgresql.Driver.connect(Driver.java:235) [java] at java.sql.DriverManager.getConnection(DriverManager.java:512) [java] at java.sql.DriverManager.getConnection(DriverManager.java:171) [java] at org.apache.commons.dbcp.DriverManagerConnectionFactory.create Connection(DriverManagerConnectionFactory.java:48) [java] at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject( PoolableConnectionFactory.java:290) [java] at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(G enericObjectPool.java:771) [java] at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.j ava:175) [java] at java.sql.DriverManager.getConnection(DriverManager.java:512) [java] at java.sql.DriverManager.getConnection(DriverManager.java:193) [java] at org.dspace.storage.rdbms.DatabaseManager.getConnection(Databa seManager.java:446) [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseMana ger.java:777) [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDa tabase.java:71) BUILD FAILED /usr/local/dspace-1.3.1-source/build.xml:266: Java returned: 1 Total time: 7 seconds BEGIN:VCARD VERSION:2.1 N:Âí½¨Ï¼;
Re: [GENERAL] ask for help about postgresql
hi, try this in pg_hba.conf , if the db is on the same machine: local all all trust if db is on another machine in the local network hostall all ip_of_the_machine_to_connect_from 255.255.255.0 trust Afterwards you need to reload the server (SIGHUP or pg_ctl reload) More documnetation you fin in the file pg_hba.conf. You can find this file in the data_directory of your PostgreSQL-Installation, default is /us/local/pgsql/data/ Best regards Hakan Kocaman Software-Developer digame.de GmbH Richard-Byrd-Str. 4-8 50829 Köln Tel.: +49 (0) 221 59 68 88 31 Fax: +49 (0) 221 59 68 88 98 Email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, August 11, 2004 8:42 AM To: pgsql-general Subject: [GENERAL] ask for help about postgresql hi, I'm trying to instal postgresql to support an open-source software named dspace. I have already installed sdk, tomcat5, postgresql8.0.3, but when I install dspace, I met error says [java] Exception:java.net.SocketException: Invalid argument or cannot assign requested address. I think perhaps there some porblem in the install and configure of postgresql. Would you please help me to solve this problem? Thank you. majx [EMAIL PROTECTED] dspace-1.3.1-source]# ant fresh_install Buildfile: build.xml compile: install_code: build_wars: init_configs: setup_database: [java] 2005-08-11 11:27:31,152 INFO org.dspace.storage.rdbms.InitializeDat abase @ Initializing Database [java] 2005-08-11 11:27:31,637 FATAL org.dspace.storage.rdbms.InitializeDat abase @ Caught exception: [java] org.postgresql.util.PSQLException: try to connect unsuccessed [java] Exception:java.net.SocketException: Invalid argument or cannot assi gn requested address [java] Stack Trace: [java] java.net.SocketException: Invalid argument or cannot assign requeste d address [java] at java.net.PlainSocketImpl.socketConnect(Native Method) [java] at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305) [java] at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.jav a:171) [java] at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158) [java] at java.net.Socket.connect(Socket.java:452) [java] at java.net.Socket.connect(Socket.java:402) [java] at java.net.Socket.init(Socket.java:309) [java] at java.net.Socket.init(Socket.java:124) [java] at org.postgresql.core.PGStream.init(PGStream.java:58) [java] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionIm pl(ConnectionFactoryImpl.java:77) [java] at org.postgresql.core.ConnectionFactory.openConnection(Connecti onFactory.java:65) [java] at org.postgresql.jdbc2.AbstractJdbc2Connection.init(AbstractJ dbc2Connection.java:117) [java] at org.postgresql.jdbc2.Jdbc2Connection.init(Jdbc2Connection.j ava:24) [java] at org.postgresql.Driver.connect(Driver.java:235) [java] at java.sql.DriverManager.getConnection(DriverManager.java:512) [java] at java.sql.DriverManager.getConnection(DriverManager.java:171) [java] at org.apache.commons.dbcp.DriverManagerConnectionFactory.create Connection(DriverManagerConnectionFactory.java:48) [java] at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject( PoolableConnectionFactory.java:290) [java] at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(G enericObjectPool.java:771) [java] at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.j ava:175) [java] at java.sql.DriverManager.getConnection(DriverManager.java:512) [java] at java.sql.DriverManager.getConnection(DriverManager.java:193) [java] at org.dspace.storage.rdbms.DatabaseManager.getConnection(Databa seManager.java:446) [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseMana ger.java:777) [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDa tabase.java:71) [java] End of Stack Trace [java] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionIm pl(ConnectionFactoryImpl.java:136) [java] at org.postgresql.core.ConnectionFactory.openConnection(Connecti onFactory.java:65) [java] at org.postgresql.jdbc2.AbstractJdbc2Connection.init(AbstractJ dbc2Connection.java:117) [java] at org.postgresql.jdbc2.Jdbc2Connection.init(Jdbc2Connection.j ava:24) [java] at org.postgresql.Driver.connect(Driver.java:235) [java] at java.sql.DriverManager.getConnection(DriverManager.java:512) [java] at java.sql.DriverManager.getConnection(DriverManager.java:171