Re: BUG #6451: problem while installing gridsql

The following bug has been logged on the website:

Bug reference: 6451
Logged by: srinivas
Email address: srinivas879(at)gmail(dot)com
PostgreSQL version: 9.0.6
Operating system: redhat linux
Description:

[enterprisedb(at)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(ConnectionFactoryImpl.java:331)
at
com.edb.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:147)
at
com.edb.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at
com.edb.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:161)
at
com.edb.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
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(ConnectionFactoryImpl.java:147)
at
com.edb.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at
com.edb.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:161)
at
com.edb.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
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(at)gmail(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 6451
> Logged by: srinivas
> Email address: srinivas879(at)gmail(dot)com
> PostgreSQL version: 9.0.6
> Operating system: redhat linux
> Description:
>
> [enterprisedb(at)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.