On Nov 9, 5:25 pm, Andrea Tomasini <[email protected]> wrote: > 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
Hi Andrea, Yes I have created all the db and the user there, when I do psql agilo_db and then in psql console I wrote select * from pg_shadow; I got the user and md5 encrypted password so I assume the user owned the DB isn't it? > > > 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 Yes I'm connecting from local machine > > > What am I doing wrong? > > Check that the DB is there and you can login as username, by running > psql from command line ;-) > can't get connected using command line with my user only can connect to db by "sudo su postgres -c psql agilo_db". getting psql: FATAL: Ident authentication failed for user "agilo_user". Can you suggest how I must write the psql comman. I'm tring with psql -U agilo_user -W agilo_db > 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
