Thread: No DB connection in Netscape ? Please help.

No DB connection in Netscape ? Please help.

From
"Kapoor, Nishikant X"
Date:
Hello friends

I have apache-1.1.3-3 and PostgreSQL-6.3.2 running on my Linux RH4.2,
kernel 2.0.30 (genx). I have a Java Applet that tries to connect to
PostgreSQL
using JDBC, from NS-4.5b1 on an IBM RISC6000, AIX-4.1.4 (mm01).

Typing "mm01: netscape http://genx/PrfApplet.htm" brings up the applet
in the NS
but the database connection is not established. The Java console shows:

openDb(PrfDb):Connecting to Database URL = jdbc:postgresql:prfdb...
openDb(PrfDb): Could not connect. e= security.Couldn't connect to
'localhost' with origin from 'genx'.

The same problems exits when I start NS from the same machine where the
PostgreSQL
server is running i.e. the Linux box(genx).

*** But, when I use "genx: netscape http://127.0.0.1/PrfApplet.htm" on
genx, the
*** database connection gets established.

The two machines genx and mm01 are on the same network and can ping each
other
using the hostnames.

THE CLASSPATH IS *NOT* SET ON RISC MACHINE (mm01) and the postgresql.jar
is already
in mm01:$MOZILLA_HOME/java/classes. The JDBC interface is as follows:

    // Load the driver
    try {
      Class.forName(PrfConstants.DB_DRVR);
    } catch(Exception e) {
        System.out.println("openDb(PrfDb): Class.forName() failed. e= "
+ e.getMessage());
        return (false);
      }

    // Connect to database
    System.out.println("openDb(PrfDb):Connecting to Database. URL =
jdbc:postgresql:prfdb...");
    try {
      connect = DriverManager.getConnection("jdbc:postgresql:prfdb",
"postgres", "");
    } catch (SQLException e) {
        System.out.println("openDb(PrfDb): Could not connect to
database. e=" + e.getMessage() );
        connect = null;
        return (false);
      } catch (Exception e) {
          System.out.println("openDb(PrfDb): Could not connect. e= " +
e.getMessage());
          connect = null;
          return (false);
        }

Can someone please help me. This has been much more complicated than
what I'd anticipated.

I'm not sure if this is a problem at Java end or the PostgreSQL end. So,
please
excuse me if I've posted this problem to the wrong group. I'm just
desperate for help !!!

Thanks much in advance.
Nishi

--------To err is human but to really mess it up is computer--------
mailto:nishikant.x.kapoor@nspco.com   http://www.c3ipros.com/nkapoor
-----------------------------------~~~------------------------------


Re: No DB connection in Netscape ? Please help.

From
Kenny Freeman
Date:
I could be on thin ice, but applets can only make connections to the site
that they were loaded from. I noticed a security... something or other in
the java console o/p (just a quick look). Maybe that explains why you can
connect on one machine, and not the other....

On Fri, 14 Aug 1998, Kapoor, Nishikant X wrote:

> Hello friends
>
> I have apache-1.1.3-3 and PostgreSQL-6.3.2 running on my Linux RH4.2,
> kernel 2.0.30 (genx). I have a Java Applet that tries to connect to
> PostgreSQL
> using JDBC, from NS-4.5b1 on an IBM RISC6000, AIX-4.1.4 (mm01).
>
> Typing "mm01: netscape http://genx/PrfApplet.htm" brings up the applet
> in the NS
> but the database connection is not established. The Java console shows:
>
> openDb(PrfDb):Connecting to Database URL = jdbc:postgresql:prfdb...
> openDb(PrfDb): Could not connect. e= security.Couldn't connect to
> 'localhost' with origin from 'genx'.
>
> The same problems exits when I start NS from the same machine where the
> PostgreSQL
> server is running i.e. the Linux box(genx).
>
> *** But, when I use "genx: netscape http://127.0.0.1/PrfApplet.htm" on
> genx, the
> *** database connection gets established.
>
> The two machines genx and mm01 are on the same network and can ping each
> other
> using the hostnames.
>
> THE CLASSPATH IS *NOT* SET ON RISC MACHINE (mm01) and the postgresql.jar
> is already
> in mm01:$MOZILLA_HOME/java/classes. The JDBC interface is as follows:
>
>     // Load the driver
>     try {
>       Class.forName(PrfConstants.DB_DRVR);
>     } catch(Exception e) {
>         System.out.println("openDb(PrfDb): Class.forName() failed. e= "
> + e.getMessage());
>         return (false);
>       }
>
>     // Connect to database
>     System.out.println("openDb(PrfDb):Connecting to Database. URL =
> jdbc:postgresql:prfdb...");
>     try {
>       connect = DriverManager.getConnection("jdbc:postgresql:prfdb",
> "postgres", "");
>     } catch (SQLException e) {
>         System.out.println("openDb(PrfDb): Could not connect to
> database. e=" + e.getMessage() );
>         connect = null;
>         return (false);
>       } catch (Exception e) {
>           System.out.println("openDb(PrfDb): Could not connect. e= " +
> e.getMessage());
>           connect = null;
>           return (false);
>         }
>
> Can someone please help me. This has been much more complicated than
> what I'd anticipated.
>
> I'm not sure if this is a problem at Java end or the PostgreSQL end. So,
> please
> excuse me if I've posted this problem to the wrong group. I'm just
> desperate for help !!!
>
> Thanks much in advance.
> Nishi
>
> --------To err is human but to really mess it up is computer--------
> mailto:nishikant.x.kapoor@nspco.com   http://www.c3ipros.com/nkapoor
> -----------------------------------~~~------------------------------
>


Re: [INTERFACES] No DB connection in Netscape ? Please help.

From
Peter T Mount
Date:
On Fri, 14 Aug 1998, Kapoor, Nishikant X wrote:

> Hello friends
>
> I have apache-1.1.3-3 and PostgreSQL-6.3.2 running on my Linux RH4.2,
> kernel 2.0.30 (genx). I have a Java Applet that tries to connect to
> PostgreSQL
> using JDBC, from NS-4.5b1 on an IBM RISC6000, AIX-4.1.4 (mm01).
>
> Typing "mm01: netscape http://genx/PrfApplet.htm" brings up the applet
> in the NS
> but the database connection is not established. The Java console shows:
>
> openDb(PrfDb):Connecting to Database URL = jdbc:postgresql:prfdb...
> openDb(PrfDb): Could not connect. e= security.Couldn't connect to
> 'localhost' with origin from 'genx'.
>
> The same problems exits when I start NS from the same machine where the
> PostgreSQL
> server is running i.e. the Linux box(genx).
>
> *** But, when I use "genx: netscape http://127.0.0.1/PrfApplet.htm" on
> genx, the
> *** database connection gets established.

Have you configured pg_hba.conf to allow connections from mm01 to the
database?

By default, it allows connections from localhost (127.0.0.1) but for other
remote hosts, you have to add their (or a subnet's) IP address/mask before
PostgreSQL will allow a connection.

> The two machines genx and mm01 are on the same network and can ping each
> other
> using the hostnames.

This is the same reason why genx fails - the host name is using the
ethernet port,  and not localhost.

>
> THE CLASSPATH IS *NOT* SET ON RISC MACHINE (mm01) and the postgresql.jar
> is already
> in mm01:$MOZILLA_HOME/java/classes.

The fact that you are getting connections failing or succeeding rules this
out. If it was a classpath problem, you'd be getting different exceptions
being thrown.

AFAIK, browsers don't use CLASSPATH anyhow.

> Can someone please help me. This has been much more complicated than
> what I'd anticipated.
>
> I'm not sure if this is a problem at Java end or the PostgreSQL end. So,
> please
> excuse me if I've posted this problem to the wrong group. I'm just
> desperate for help !!!

It looks like postgres is not allowing the connection, so the first place
to check is pg_hba.conf

--
Peter T Mount peter@retep.org.uk or petermount@earthling.net
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres