Hi Paul, You're right that most emphasis is on running OTRS on MySQL - but also most people deploy OTRS on MySQL. This could be just because the emphasis of the documentation of course...
Although for upcoming OTRS 3.3 we have improved the web installer so you can also use it for deploying OTRS on PostgreSQL, Oracle or Microsoft SQL Server. I think the best instructions for how to deploy on PostgreSQL are here: https://github.com/OTRS/otrs/blob/rel-3_2/README.database.md If you have trouble with 'otrs' user on startup, this is because the PostgreSQL server typically uses 'ident' authentication by default on a stock install. This means the linux user id is used for database permissions; but apache typically does not run under the 'otrs' user that is running the cron jobs. You can fix it by changing the authentication mode of PostgreSQL (as pointed to in the link above). Alternatively you can also change the user that runs the web server. -- Michiel Beijen Senior Developer OTRS BV Schipholweg 103 2316 XC Leiden The Netherlands T: +31 71 8200 255 I: http://www.otrs.com OTRS 3.2 - More than a Help Desk System – Process and Customer Management – Be an early bird with our special offer - http://j.mp/11TFPSr On Fri, May 31, 2013 at 10:26 AM, Paul Simons <paul.sim...@onair.aero> wrote: > Hello > > I am trying to install OTRS over PostgreSQL, over CentOS. > > The documentation (although extremely good) is not a lot of help in my case > . The emphasis is squarely on MySQL and > > the ‘installer.pl’ WEB GUI which ‘only works with MySQL’ :-( > > All other configurations are consigned to rather brief footnotes. > > Is there someone who has installed this variant and is willing to post a > step-by-step guide? > > Specifically I am have trouble with ‘otrs’ user access permissions on start > up. > > Regards > > > > ___________________________________________ > > Paul Simons > > > > > ________________________________ > > Disclaimer: This e-mail (and any attachments to it) is confidential and > intended solely for the named person/s to whom it is addressed. If you are > not an intended recipient, please notify us immediately and delete the email > from your system. Any review, dissemination or other use of it in these > circumstances is prohibited. > > --------------------------------------------------------------------- > 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
