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
