Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #6451: problem while installing gridsql

BUG #6451: problem while installing gridsql

From
srinivas879@gmail.com
Date:
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

Re: BUG #6451: problem while installing gridsql

From
John R Pierce
Date:
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

Re: BUG #6451: problem while installing gridsql

From
ashu
Date:
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.

Re: BUG #6451: problem while installing gridsql

From
ashu
Date:
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.