RE: Connection problems - Mailing list pgsql-interfaces

From fud fudmore
Subject RE: Connection problems
Date
Msg-id F193Vn20lbhsKd6QR7j00007d12@hotmail.com
Whole thread Raw
In response to Connection problems  (mall <listkeeper23@hotmail.com>)
List pgsql-interfaces
Sorry everybody but i just figured out what my lame butt has done wrong.
after reading the postgresql manual further i discovered the tracing 
features of the db server so i decided to add this entry to pg_options

all=1
verbose=2
query=0
syslog=2

and i found this ...

Jan 10 13:02:06 darktower postgres[3891]: InitPostgres
Jan 10 13:02:06 darktower postgres[3891]: FATAL 1:  Database "papers " does 
not exist in the system catalog.
Jan 10 13:02:06 darktower postgres[3891]: proc_exit(0)
Jan 10 13:02:06 darktower postgres[3891]: shmem_exit(0)
Jan 10 13:02:06 darktower postgres[3891]: exit(0)


"papers " DUH! somewhere in the program a blank space had gotten
in. i fixed it and it works perfectly. Thanks to everybody that replied
to my request for help.

>From: "fud fudmore" <listkeeper23@hotmail.com>
>To: Paul-AndrePanon@SierraSystems.com
>CC: pgsql-interfaces@postgresql.org
>Subject: RE: Connection problems
>Date: Thu, 11 Jan 2001 00:11:40 -0000
>
>
>
>
>>From: "Panon, Paul-Andre" <Paul-AndrePanon@SierraSystems.com>
>>To: 'mall' <listkeeper23@hotmail.com>
>>Subject: RE: [INTERFACES] Connection problems
>>Date: Wed, 10 Jan 2001 14:01:01 -0800
>>
>>If you installed the Mandrake rpm for postgres, I believe that by default
>>it
>>only accepts connections over UNIX pipes, not TCP/IP. You need the latter
>>to
>>support jdbc.
>>
>>To check whether the postmaster backend accept connections over TCP/IP, 
>>try
>>connecting to it with the command
>>psql -p 5432 papers apprentice
>>
>>If you get a connection error on the above command, you need to modify the
>>startup script for postgres. edit /etc/rc.d/init.d and add the -i flag to
>>the postmaster command.
>>
>>P-A
>>
>>-----Original Message-----
>>From: mall [mailto:listkeeper23@hotmail.com]
>>Sent: Wednesday, January 10, 2001 12:32 PM
>>To: pgsql-list
>>Subject: [INTERFACES] Connection problems
>>
>>
>>
>>
>>Hi i've posted this message before but i'm adding new information to it.
>>Hopefully some of the JDBC driver developers
>>can help me figure out what is going wrong.
>>
>>
>>previous message :
>>
>>"
>>
>>hi, i've just installed recently installed an rpm version of postgresql
>>(postgresql-server-7.0.2-6mdk.i586.rpm) and it's client.
>>I've added just 1 user
>>
>>with the
>>
>>unix_shell>createuser -P apprentice
>>
>>and a database with
>>
>>
>>unix_shell>createdb -U apprentice papers
>>
>>i created a few tables and was able to check them out using this command
>>
>>unix_shell>psql papers apprentice
>>
>>now i need to write a small java program that can connect to the database
>>and retreive some information
>>but the jdbc driver i have (jdbc7.0-1.2.jar) keeps throwing this exception
>>when i try to connect with this URL
>>(jdbc:postgresql:papers)
>>
>>
>>Something unusual has occured to cause the driver to fail. Please report
>>this exception: java.sql.SQLException: FA
>>TAL 1:  Database "papers" does not exist in the system catalog.
>>
>>hmm, i'm sure the database and the tables all exist....  can anybody tell
>>me
>>what i'm doing wrong?
>>"
>>
>>All  users and Databases, tables were created using lower case letters.
>>I've
>>tried connecting to other databases with other
>>user names but get the same exception. Both postmaster and my java program
>>are running on the same machine. I'm using
>>JDK 1.3.0 from www.blackdown.org <http://www.blackdown.org>  with Mandrake
>>7.2. I've also tried jdbc7.0-1.1.jar but i get the same exception ... why
>>would
>>it report that the DB doesn't exist in the catalog when i can access it
>>from
>>psql???? Even the database "postgres" Doesn't exist
>>as far as the JDBC driver is concerned.
>>
>
>  I did fix the /etc/rc.d/init.d/postgres script to include the -i
>parameter to start postgres. After that i was able to connect by
>using this commandline.
>
>unix_shell>psql -p 5432 papers apprentice
>
>but when i ran my program again it threw the same exception ... I'm abit
>confused at this point. if the jdbc driver was using port 5432 as the
>default port to connect to then why didn't it throw an exception about not
>finding a socket before i added the " -i" option.
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com



pgsql-interfaces by date:

Previous
From: "Mike Cannon-Brookes"
Date:
Subject: JDBC date problem
Next
From: "Allan Huffman"
Date:
Subject: Re: Take me off of the list Now, Please !