Re: [Pypgsql-users] Is there a How-To with scripting examples? - SOLVED

[Dave S. <Dst...@em...>]

I used your code:
 
from pyPgSQL import PgSQL
db =
PgSQL.connect('postgresql_IP::database_name:user_login:password_for_user_in_postgresql::')
cursor = db.cursor()
cursor.execute("select * from xamemails WHERE aclcomment = 'Virus
Detected'")
result = cursor.fetchall()
for row in result:
    print row.tstamp, row.tx, row.rx

... and it works like a champ - thanks! FAQ for newbies:
 
[1] Make sure the locate pg_hba.conf file on the server is correct for
your system/workstation.
[2] Make sure the username you use for PostgreSQL has a password
assigned to it before you use it in your code.
[3] In the Windows version, and interpreter for Python is also an
editor. Watch out for being in the wrong 'mode'.
[4] In the Windows version, you need to save your file before you press
F5 and run it.


>>> Michael Watkins <wa...@tr...> 06/13/02 07:04PM >>> 
At 04:29 PM 6/13/2002 -0400, Dave Strickler wrote: 
> > I tried to to this, and the "from" command worked, and I got a lot

> > further. But, as you can see from below, it wasn't 100% sucsessful.
Any 
> > clues as to what is going wrong? I made a pg_hba.conf in the PgSQL

> > directory, and added in my 10.0.0.120 address (that's my
workstation), 
> > but it didn't help. 

You are getting close but not quite... 

Note!! pg_hba.conf does not go in the PgSQL directory... but in your 
PostgreSQL server's **data** directory... something like 
/usr/local/pgsql/data if you have not moved it. Try at the command line


locate pg_hba.conf 

which should show you the path to some sample and the actual conf file.


In that file have: 
host all 10.0.0.120 255.255.255.0 trust 

... for now, just to be sure authentication isn't an issue.