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 host all 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: hakan.kocaman@xxxxxxxxx > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of > majx@xxxxxxxxx > Sent: Wednesday, August 11, 2004 8:42 AM > To: pgsql-general > Subject: 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 > > > > [root@localhost 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 > > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
