Re: [Qgis-user] PostGIS Manager plugin issue

2009-02-02 Thread Martin Dobias
On Sat, Jan 31, 2009 at 9:43 PM, Joe Larson j...@joelarson.com wrote:
 [...]

 /home/joe/.qgis//python/plugins/postgis_manager/postgis_utils.py, line
 113, in get_info
   self._exec_sql(c, SELECT version())
  File
 /home/joe/.qgis//python/plugins/postgis_manager/postgis_utils.py, line
 504, in _exec_sql
   raise DbError(e.message, e.cursor.query)
 DbError: MESSAGE: current transaction is aborted, commands ignored until
 end of transaction block

Check out newly uploaded version 0.4.7, maybe it will fix this problem.

Martin
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user


Re: [Qgis-user] PostGIS Manager plugin issue

2009-02-01 Thread Alex Mandel
Joe Larson wrote:
 Last night I installed/ran the PostGIS Manager plugin with no issues on
 my Ubuntu Intrepid laptop. Today (at work) I'm having an issue running
 the plugin on my Ubuntu(guest), XP(host) - VirtualBox install.
 
 I'll mention again that this worked right away on my laptop (after
 installing psycopg2) not sure what's going on now..However currently,
 when I click the plugin button, 1st I get the error msg:
 
 #Couldn't connect to database:
 #FATAL: Ident authentication failed for user joe
 
 So I CREATE USER joe in psql. Attempt to run the plugin again:
 
 #Couldn't connect to database:
 #FATAL: database joe does not exist
 
 I whip up a databased named joe and with OWNER postgres or joe I get the
 error below
 
 |###
 An error has occurred while executing Python code:
 
 Traceback (most recent call last):
  File
 /home/joe/.qgis//python/plugins/postgis_manager/ManagerWindow.py, line
 148, in dbConnect
self.dbInfo()
  File
 /home/joe/.qgis//python/plugins/postgis_manager/ManagerWindow.py, line
 177, in dbInfo
info = self.db.get_info()
  File
 /home/joe/.qgis//python/plugins/postgis_manager/postgis_utils.py, line
 113, in get_info
self._exec_sql(c, SELECT version())
  File
 /home/joe/.qgis//python/plugins/postgis_manager/postgis_utils.py, line
 504, in _exec_sql
raise DbError(e.message, e.cursor.query)
 DbError: MESSAGE: current transaction is aborted, commands ignored until
 end of transaction block
 
 QUERY: SELECT version()
 
 Python version:
 2.5.2 (r252:60911, Oct  5 2008, 19:42:18)
 [GCC 4.3.2]
 
 Python path:['/usr/share/qgis/python',
 '/home/joe/.qgis//python/plugins', '/usr/share/qgis/python/plugins',
 '/usr/lib/python2.5', '/usr/lib/python2.5/plat-linux2',
 '/usr/lib/python2.5/lib-tk', '/usr/lib/python2.5/lib-dynload',
 '/usr/local/lib/python2.5/site-packages',
 '/usr/lib/python2.5/site-packages',
 '/usr/lib/python2.5/site-packages/Numeric',
 '/usr/lib/python2.5/site-packages/PIL',
 '/usr/lib/python2.5/site-packages/gst-0.10',
 '/var/lib/python-support/python2.5',
 '/usr/lib/python2.5/site-packages/gtk-2.0',
 '/var/lib/python-support/python2.5/gtk-2.0', '~/.qgis/python',
 '/home/joe/.qgis/python/plugins/fTools/tools']
 ###
 
 Also, when I 'OK' the error msg and click on the public schema in the
 PostGIS Manager window - I get another err msg. I hope this is not just
 some User/Login issue with Ubuntu..but I would appreciate some insight*joe
 |
 

Joe,

I've had a similar issue with postgis in general. Basically it's trying
to log you into postgis using your system account and if postgis isn't
configured properly to allow the system to provide the authenticaton
(Ident) then it fails. For now I've created a user that only exists in
postgis not on my system and gave it a password. If I use that postgis
account I get no errors.

I'll let you know if I find the magic ubuntu setting to make local
accounts work right (hint play with /etc/postgresql/8.3/main/pg_hba.conf)

Alex




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user