Re: Can't start rhdb-admin

[Fernando Nasser <fnasser@redhat.com>]

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