Re: [cobalt-users] Cannot connect DSN to PostgreSQL

["Jason Goodridge" <jasong@xxxxxxxxxxxxx>]

Ok, that all makes sense except for the fact that if I am hosting the
database and the ASP on the same system, why do I need remote access to
PostgreSQL? All I really need is access from the localhost. Is that
considered remote access if it is achieved through an IP/Port?

It brings me back to my original problem. Why am I getting the ODBC driver
error?

Thanks for your help.

----- Original Message -----
From: "Gerald Waugh" <gwaugh@xxxxxxxxxxxxxxxxxxxxxxx>
To: <cobalt-users@xxxxxxxxxxxxxxx>
Sent: Thursday, February 13, 2003 12:00 PM
Subject: Re: [cobalt-users] Cannot connect DSN to PostgreSQL


> On Wednesday 12 February 2003 18:04, Jason Goodridge wrote:
> > Thanks Gerald
> >
> > There is just a couple things I still do not understand:
> >
> > 1. If Postgre is not setup to use a port, how does the Raq use it to
> > generate its webpages? I had assumed that all that must be setup for
this
> > reason. Also, I ran netstat and it said that it was listening to port
5432.
> > Is there a configuration file I need to know about to get it to work on
> > that port?
>
> Someone has turned it on then. The default is to not listen on a tcp/udp
port.
> Edit the file /var/lib/pgsql/data/postgres/pg_hba.conf to permit remote
TCP/IP
> access to the database system.
> Run the program `postmaster' as user `postgres'. The `postmaster' process
is
> the database server process which has sole control over the database
system.
> To enable access the database system, run the program `psql' as Unix user
> `postgres' (for special privileges), and add access rights for any
ordinary
> Unix users who should be able to use the system.
> Run `psql' as an ordinary Unix user (as enabled via the `postgres'
process),
> and create a database, and use it.
>
> > 2. Are there any vulnerabilities you know about with PostgreSQL? While I
am
> > using my system to test on can I simply leave it set to "local all
trust"
> > and then make sure that port 5432 is blocked on my hardware firewall? I
> > understand that when I have other users using my system with shell
accounts
> > that this is not acceptable but in the interim where there is only me
> > testing on it will that be sufficient security to guard against external
> > attacks?
>
> Se above
>
> Gerald
> --
> http://frontstreetnetworks.com | http://store.raqware.com
> Front Street Networks LLC      |  Phone: 203-785-0699
> 229 Front Street, Ste #C, New Haven, CT 06513-3203
>
> _____________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users