[Qgis-user] PostGIS Manager plugin issue
Joe Larson
joe at joelarson.com
Sat Jan 31 12:43:40 PST 2009
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
|
More information about the Qgis-user
mailing list