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

["Jason Goodridge" <jasong@xxxxxxxxxxxxx>]

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?

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?

Cheers

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


> On Thu, 13 Feb 2003 jasong@xxxxxxxxxxxxx wrote:
>
> > My questions are this:
> > 1. What am I missing here?
> > 2. Is there any problem with using the line "local all trust" long term?
Will
> > it introduce security issues? What can I do about that and is there a
batter
> > configuration?
> >
> All postgre is isntalled without using a port.
> Read about setting up postgre.
> You have to configure it to use a port.
>
> Yes, you need to create a db and a user, don't leave it as
> "local all trust"
>
> Again I don't know the details, but if as root you
> su posgres you should be able to setup a db
>
> Gerald
> --
> http://frontstreetnetworks.com | http://store.raqware.com
>      ICQ 229276628     |    Phone: +1 203 785-0699
> Front Street Networks LLC,  229 Front Street, Ste. #C,
> New Haven, CT. 06513-3203 United States of America
>
> _____________________________________
> 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