[Qgis-user] PostGIS Manager plugin issue

[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