| From: | James Thompson <jamest(at)math(dot)ksu(dot)edu> |
|---|---|
| To: | Bob VonMoss <bvonmoss(at)bigfoot(dot)com> |
| Cc: | pgsql-interfaces(at)postgreSQL(dot)org |
| Subject: | Re: [INTERFACES] connecting: unix socket? Yes. TCPIP port? No. -i? Yes. |
| Date: | 1999-02-06 04:23:24 |
| Message-ID: | Pine.GSO.4.05.9902052216430.4380-100000@noether.math.ksu.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
On Fri, 5 Feb 1999, Bob VonMoss wrote:
> I'm just getting into PostGreSQL and would ultimately like to
> communicate from a java/JDBC applet through the web with PostGreSQL on a
> Solaris unix system. I've had a user account created for me. I'm able to
> do everything so far from the commandline through unix sockets by
> running 'psql' and 'createdb mydb'.
>
I'm new to postgresql as well but I had a similar problem. The
pg_hba.conf file by default allows connections from the localhost and unix
socks but not tcp connections from other machines. The default USERAUTH
is to trust connections from these two sources.
I switched to crypt userauth and added a third connection type to the file
host all 192.168.1.0 255.255.255.0 crypt
and it solved my problems.
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
James Thompson 138 Cardwell Hall Manhattan, Ks 66506 785-532-0561
Kansas State University Department of Mathematics
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Billy G. Allie | 1999-02-06 08:10:41 | Re: [INTERFACES] Using libpq without LD_LIBRARY_PATH |
| Previous Message | Bob VonMoss | 1999-02-06 03:44:16 | connecting: unix socket? Yes. TCPIP port? No. -i? Yes. |