[Qgis-user] PostGIS Manager plugin issue

[Joe Larson]

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
|