Thank you Henry, It works now. I was just giving otrs database user owner permissions and not
specifically: GRANT ALL ON DATABASE otrs TO otrs; which is what I needed. I will post a how to step by step on setup when I am done on my blog. http://www.solutionsfromanitgrunt.blogspot.com/ On Tue, Sep 23, 2008 at 3:28 AM, Henka <[EMAIL PROTECTED]> wrote: > Quoting "Rudi Schmitz" <[EMAIL PROTECTED]>: > >> I have tried different linux distros, different versions of postgresql and >> have even found a freebsd user with the same error. I can't get >> a regular database owner in postgresql to work with otrs it has to be >> superuser some reason. That is not good security wise. Once I give super >> user to config.pm database user it works. >> > > This has nothing to do with the distro. > > The otrs user you've created doesn't have permissions to do squat. > > Try this: > > Login as 'postgres' to create the OTRS database and user: > > % psql -Upostgres template1 > ... > template1=# CREATE DATABASE otrs; > CREATE DATABASE > > Now connect to the new DB: >>>> >>> > template1=# \c otrs > You are now connected to database "otrs". > otrs=# > > Now create the user: >>>> >>> > otrs=# CREATE USER otrs WITH PASSWORD 'abc'; > CREATE ROLE > > Now user 'otrs' can login to database 'otrs' and own everything (eg, run > the $HOME_OTRS/scripts/database/otrs-*postgresql.sql using your new user > 'otrs'). > > You could also create the user and database, then grant the user perms in > that DB: > > GRANT ALL ON DATABASE otrs TO otrs; > > You could also have created the database with the owner (already created) > being 'otrs': > > CREATE DATABASE otrs WITH OWNER otrs; > > etc. > > Don't forget to update Kernel/Config.pm with the correct details: > > $Self->{Database} = 'otrs'; > $Self->{DatabaseUser} = 'otrs'; > $Self->{DatabasePw} = 'abc'; > $Self->{DatabaseDSN} = "DBI:Pg:... > > > Cheers > Henry > _______________________________________________ > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs >
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs