Re: Can't start rhdb-admin

Re: Can't start rhdb-admin

[Andrew Overholt]

Hi Brian,

> I have installed the entire RHDB (postgres) server and client and set it
> all up according to the manual. All I have done so far is create one
> database and put one table in it, nothing fancy. pg_dumpall shows
> everything that I have done. But when I run rhdb-admin, it doesn't show
> anything.

You're going to first need to set up the cluster that you created in RHDB
Admin (to do so, go to File->Add Cluster ... see 1. below for more info).

> I know that JRE is set up because I have been using J2SDK. So that makes me
> think that my problem is with the JDBC or the client connection. I linked
> rh-pgsql-jdbc2.jar to the JRE lib/ext directory.

Just to clarify, RHDB Admin isn't written in Java and thus does not need a
JRE (RHDB Explain, however, does).

> local all trust
> host all 127.0.0.1 255.255.255.255 trust

This seems okay for both Unix socket and TCP/IP communications from your
local machine(s).

> I am using Red Hat Linux 7.3.

This was one of the two test platforms so it should work just fine.

For more info on RHDB Admin (and the rest of the RHDB suite), please refer
to 2. below.

Also, inquiries about RHDB should probably be sent (or at least CC'd) to
rhdb@sources.redhat.com (see 3. below for more info).

Good luck,

Andrew & the rest of the RHDB team

1. http://www.redhat.com/docs/manuals/database/RHDB-2.0-Manual/guitools/x443.html#AEN471
2. http://sources.redhat.com/rhdb/
3. http://sources.redhat.com/rhdb/lists.html 

Re: Can't start rhdb-admin

[Fernando Nasser]

If you want to connect to the DBMS backend from a different machine, make sure 
you have the following line in your /var/lib/pgsql/data/postgresql.conf file:

tcpip_socket = true

otherwise it will not accept TCP/IP connection (the default is false for 
security reasons.

Regards,
Fernando


Andrew Overholt wrote:> Hi Brian,
> 
> 
>>I have installed the entire RHDB (postgres) server and client and set it
>>all up according to the manual. All I have done so far is create one
>>database and put one table in it, nothing fancy. pg_dumpall shows
>>everything that I have done. But when I run rhdb-admin, it doesn't show
>>anything.
> 
> 
> You're going to first need to set up the cluster that you created in RHDB
> Admin (to do so, go to File->Add Cluster ... see 1. below for more info).
> 
> 
>>I know that JRE is set up because I have been using J2SDK. So that makes me
>>think that my problem is with the JDBC or the client connection. I linked
>>rh-pgsql-jdbc2.jar to the JRE lib/ext directory.
> 
> 
> Just to clarify, RHDB Admin isn't written in Java and thus does not need a
> JRE (RHDB Explain, however, does).
> 
> 
>>local all trust
>>host all 127.0.0.1 255.255.255.255 trust
> 
> 
> This seems okay for both Unix socket and TCP/IP communications from your
> local machine(s).
> 
> 
>>I am using Red Hat Linux 7.3.
> 
> 
> This was one of the two test platforms so it should work just fine.
> 
> For more info on RHDB Admin (and the rest of the RHDB suite), please refer
> to 2. below.
> 
> Also, inquiries about RHDB should probably be sent (or at least CC'd) to
> rhdb@sources.redhat.com (see 3. below for more info).
> 
> Good luck,
> 
> Andrew & the rest of the RHDB team
> 
> 1. http://www.redhat.com/docs/manuals/database/RHDB-2.0-Manual/guitools/x443.html#AEN471
> 2. http://sources.redhat.com/rhdb/
> 3. http://sources.redhat.com/rhdb/lists.html 
> 



-- 
Fernando Nasser
Red Hat - Toronto                       E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9