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

["Jason Goodridge" <jasong@xxxxxxxxxxxxx>]

Hi Gerald

Thanks for the info but I figured that out last night. I gave it a try but
it still didn't work. I found some more info that suggested that postmaster
is not started with an option that allows TCP/IP sockets by default on Raq
based systems.

1. Do you know what file I would need to edit to make this service start
with this "-i" option (i.e. is there a file that is the equivalent of an
autoexec.bat that starts all of these services when the Raq starts up)?
2. Is it true that if you set up your ODBC connection without a server/port
setting that it uses the unix sockets instead? I tried that but it still
didn't work.

I just can't figure this out. I've been researching this for days now. Is it
possible that there is something wrong with the PostgreSQL ODBC driver on
the Raq XTR's? I've only had it a week so its not like its a non standard
config or anything.... <pulls hair out>

Thanks


Jason Goodridge
Clinical Software Division
Medtel Australia

eMail: jasong@xxxxxxxxxxxxx

----- Original Message -----
From: "Gerald Waugh" <gwaugh@xxxxxxxxxxxxxxxxxxxxxxx>
To: <cobalt-users@xxxxxxxxxxxxxxx>
Sent: Friday, February 14, 2003 8:04 AM
Subject: Re: [cobalt-users] Cannot connect DSN to PostgreSQL


> On Wednesday 12 February 2003 22:27, Jason Goodridge wrote:
> > As I mentioned the only thing in pg_hba.conf is "local all trust". I'm
not
> > sure if that means a connection using the IP/Port of the localhost or
some
> > other type of local connection. Do I need a "host .... 127.0.0.1 ...
> > 255.255.255.0 ..... trust" line in there too?
> >
> # Examples
> # --------
> #
> # TYPE       DATABASE    IP_ADDRESS    MASK                AUTHTYPE  MAP
> #
> #host         all         127.0.0.1    255.255.255.255     trust
> #
> # The above allows any user on the local system to connect to any
> # database under any username.
> #
>
> The above is from pg_hba.conf
> All you have to do is uncomment it!
> You probably want to change trust to crypt so that the user's password in

> pg_shadow is supplied.
> You should also change the DATABASE form 'all'  to an assigned database.
>
> 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