Re: Can't start rhdb-admin

[Fernando Nasser <fnasser at redhat dot 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