Thread: Can't start rhdb-admin
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. 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. I added: local all trust host all 127.0.0.1 255.255.255.255 trust to pg_hba.conf I added: tcpip_socket=true to postgresql.conf I am using Red Hat Linux 7.3. Has anyone gotten rhdb-admin to work? Any ideas what I did wrong?
On 25 Oct 2002 at 20:36, Brian K. Quade wrote: > 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. <snip> Just an idea... Is postmaster started with the "-i" option? Have a look at "man postmaster".
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
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