Обсуждение: BUG #6451: problem while installing gridsql
The following bug has been logged on the website: Bug reference: 6451 Logged by: srinivas Email address: srinivas879@gmail.com PostgreSQL version: 9.0.6 Operating system: redhat linux Description:=20=20=20=20=20=20=20=20 [enterprisedb@DBServer2 bin]$ ./gs-server.sh Starting.... ./gs-server.sh: line 33: /usr/local/gridsql-2.0/log/server.log: Permission denied Error starting XDBServer server.log output: com.edb.gridsql.exception.XDBServerException: Exception during Agent initialization at com.edb.gridsql.communication.CoordinatorAgent.init(Unknown Source) at com.edb.gridsql.communication.CoordinatorAgent.getInstance(Unknown Source) at com.edb.gridsql.server.Server.<init>(Unknown Source) at com.edb.gridsql.util.XdbServer.main(Unknown Source) Caused by: com.edb.gridsql.exception.XDBServerException: CANNOT INITIALIZE NODE CONNECTION ( Node URL,[ User Name], [Password ] ) : ( jdbc:edb://127.0.0.1:5432/XDBSYS Password :gridsql User :gridsql ) at com.edb.gridsql.metadata.MetaData.initConnection(Unknown Source) at com.edb.gridsql.metadata.MetaData.loadMetaData(Unknown Source) at com.edb.gridsql.metadata.MetaData.getMetaData(Unknown Source) ... 4 more Caused by: com.edb.util.PSQLException: Connection rejected: FATAL: password authentication failed for user "gridsql". at com.edb.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImp= l.java:331) at com.edb.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryI= mpl.java:147) at com.edb.core.ConnectionFactory.openConnection(ConnectionFactory.java:64) at com.edb.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:1= 61) at com.edb.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:3= 0) at com.edb.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24) at com.edb.Driver.makeConnection(Driver.java:391) at com.edb.Driver.connect(Driver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) ... 7 more tail of console.log output: at com.edb.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryI= mpl.java:147) at com.edb.core.ConnectionFactory.openConnection(ConnectionFactory.java:64) at com.edb.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:1= 61) at com.edb.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:3= 0) at com.edb.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24) at com.edb.Driver.makeConnection(Driver.java:391) at com.edb.Driver.connect(Driver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) ... 7 more
On 02/08/12 10:32 PM, srinivas879@gmail.com wrote: > The following bug has been logged on the website: > > Bug reference: 6451 > Logged by: srinivas > Email address: srinivas879@gmail.com > PostgreSQL version: 9.0.6 > Operating system: redhat linux > Description: > > [enterprisedb@DBServer2 bin]$ ./gs-server.sh > Starting.... > ./gs-server.sh: line 33: /usr/local/gridsql-2.0/log/server.log: Permission > denied > Error starting XDBServer > server.log output: > com.edb.gridsql.exception.XDBServerException: Exception during Agent > initialization > ....... > what is that script? what is XDBServer (below)? none of this appears to have anything to do with PostgreSQL I see references to EnterpriseDB (com.edb, as well as the username), so perhaps you should contact them, as they support their own software. -- john r pierce N 37, W 122 santa cruz ca mid-left coast
Hi Srinivas, The error comes becoz of two reasons. 1)U didn't create XDBSYS 2) limit_connections='*' is not given in /usr/local/pgsql/data/postgres.conf to create XDBSYS createdb XDBSYS -u gridsql ./gs-createmddb.sh -u admin -p secret Ashu. -- View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-6451-problem-while-installing-gridsql-tp5469996p5727646.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
small correction in above msg its not limit_connections='*' but listen_addresses='*' -- View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-6451-problem-while-installing-gridsql-tp5469996p5727648.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.