Menu
▾
▴
Re: [Pypgsql-users] Is there a How-To with scripting examples?
|
From: Dave S. <Dst...@em...> - 2002-06-13 21:05:45
|
Gerhard, First off, thanks for your help in this one. While I am a pretty good program, my experience is in Windows and VMS - Unix is still very new to me, and full of lots of struggles. I do like it, but its a steep learning curve... I tried the settings you had in your pg_hba.conf file, and alterted it to look like: host all 127.0.0.1 255.255.255.255 trust host all 10.0.0.120 255.255.255.0 md5 My workstation running Python (windows version for now) is on the 10.0.0.120 IP address. Should I put an entry in for root? I now the postmaster is started with an "-i" as I can connect via telnet to the port. Thanks for all your help. I hope I can return the favor some day. Dave Strickler CEO DWS - "The GroupWise Integration Experts" Boston * Austin * Belgium * Denmark http://www.emailsolutions.com (800) 999-5412 x10 ------------------------------------ Want to get rid of SPAM, Viruses, and unwanted content? MailWise Filter - "The E-Mail Firewall (tm) for Your Company" See http://www.emailsolutions.com/MailWise >>> Gerhard =?unknown-8bit?Q?H=E4ring?= <ger...@gm...> 06/13/02 04:43PM >>> * Dave Strickler < Dst...@em... > [2002-06-13 16:29 -0400]: > Hmmm.... Still getting: > DatabaseError: FATAL 1: No pg_hba.conf entry for host 10.0.0.120, user > root, database xamime > > The problem here being I don't know what I'm doing wrong. Is this a > syntax issue, a rights issue, or a bug (doubt it the latter). A rights and thus a PostgreSQL configuration issue. The pg_hba.conf file must be configured to allow you this access and the postmaster must be started with the option "-i" to listen on TCP/IP connections at all (default is not to). Gerhard -- mail: gerhard <at> bigfoot <dot> de registered Linux user #64239 web: http://www.cs.fhm.edu/~ifw00065/ OpenPGP public key id 86AB43C0 public key fingerprint: DEC1 1D02 5743 1159 CD20 A4B6 7B22 6575 86AB 43C0 reduce(lambda x,y:x+y,map(lambda x:chr(ord(x)^42),tuple('zS^BED\nX_FOY\x0b'))) _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas - http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink _______________________________________________ Pypgsql-users mailing list Pyp...@li... https://lists.sourceforge.net/lists/listinfo/pypgsql-users |
