Re: [otrs] trying to get OTRS 3 up with Postgres: bin/otrs.CheckDB.pl fails: permission denied for relation valid, SQL: 'SELECT * FROM valid'

Wow, Gerald, Aleksey, I really don't think this is a great idea. The otrs.CheckDB.pl script just connects to your database, tries to do a select statement on the OTRS table called 'valid' and if that works, assumes there is a connection. What happened in this case is that the authentication is not correctly set up; and you 'fixed' it my giving EVERYONE select permission on the table. And if you only loosen the permissions on the 'valid' table of course you immediately have permission issues on ALL the other tables the moment you start using OTRS from the web front end. This is really not the correct way to fix it, you should really fix it by loosening up permissions on the database until it works (and especially not by granting permissions to ALL) but by correctly defining access credentials in Kernel/Config.pm If you simply set the database to allow authentication using username/password (and remember, that's NOT the default on most linux distributions) and you create the database as stated in OTRS's README.Database then you get a working set up. If you don't really know PostgreSQL you might better opt for deploying on MySQL which is simply the easiest because creating the databases and so can be done from the web based installer. We still plan to add support for multiple databases to the web based installer, and it has been on our list to implement it for the 3.0 release, but it did not make it because of time constraints... maybe for 3.1. Or of course if someone would donate some code, we'd appreciate it! -- Mike On Wed, Mar 30, 2011 at 9:33 PM, Aleksey Tsalolikhin wrote:

On Tue, Mar 29, 2011 at 7:44 PM, Gerald Young wrote:

...

Message: ERROR:  permission denied for relation valid, SQL: 'SELECT * FROM valid'

... you don't have select privileges on the table named "valid" so you should grant select on valid to public;

Thanks, Gerald, that did it!

Perhaps this should be added to the README.database file in the otrs source tarball. I've opened bug 7144 about it.   http://bugs.otrs.org/show_bug.cgi?id=7144

Cheers, Aleksey --------------------------------------------------------------------- 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