On 9 Nov, 2009, at 13:58 , Nerses wrote:
> Hi,
Hi Narses :-)
> Trying to setup agilo on Debin 5.
> Trac version is 0.11.5.
> Using postgreSQL v8.3 as db engine.
> created a user in postgre
> after running "trac-admin /var/trac/proj initenv" and on database
> connection string writing
> postgres://user:passw...@localhost/agilo_db?schema=public
> i get following error
>
> Creating and Initializing Project
> Initenv for '/var/trac/proj' failed.
> Failed to create environment.
> permission denied for database agilo_db
>
> Traceback (most recent call last):
> File "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/
> admin/console.py", line 578, in do_initenv
> options=options)
> File "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/
> env.py", line 204, in __init__
> self.create(options)
> File "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/
> env.py", line 334, in create
> DatabaseManager(self).init_db()
> File "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/db/
> api.py", line 81, in init_db
> connector.init_db(**args)
> File "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/db/
> postgres_backend.py", line 76, in init_db
> cursor.execute('CREATE SCHEMA "%s"' % cnx.schema)
> File "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/db/
> util.py", line 60, in execute
> return self.cursor.execute(sql)
> ProgrammingError: permission denied for database agilo_db
May be it is a stupid question, but did you create the User and the
DB, and is the DB owned by that user? more info here:
https://agilo.agile42.com/wiki/TracEnvironment
> my pg_hba.conf file looks like this
>
> # Database administrative login by UNIX sockets
> local all postgres ident sameuser
>
> # TYPE DATABASE USER CIDR-ADDRESS METHOD
>
> # "local" is for Unix domain socket connections only
> local all all ident sameuser
> # IPv4 local connections:
> host all all 127.0.0.1/32 md5
> # IPv6 local connections:
> host all all ::1/128 md5
This looks ok, as far as the DB is on the same machine, as you allow
only connection from localhost, or local networks 127.0.0.1/32
> What am I doing wrong?
Check that the DB is there and you can login as username, by running
psql from command line ;-)
HTH
ANdreaT
--
Follow Agilo on Twitter: http://twitter.com/agiloforscrum
-----
You received this message because you are subscribed to the Google
Groups "Agilo for Scrum" group. This group is moderated by agile42 GmbH
http://www.agile42.com and is focused in supporting Agilo for Scrum users.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/agilo?hl=en
