Installation documentation somewhat bias away from PostgreSQL

Paul Simons

31 May 2013 31 May '13

8:26 a.m.

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.

Attachments:

attachment.html (text/html — 3.2 KB)

Show replies by date

Roy Kaldung

31 May 31 May

3:20 p.m.

New subject: Installation documentation somewhat bias away from PostgreSQL

On May 31, 2013, at 10:26 AM, Paul Simons wrote:

...

Hello

...

I am trying to install OTRS over PostgreSQL, over CentOS. That's exactly what I run.

...

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.

[…]

Follow these steps: http://doc.otrs.org/3.2/en/html/manual-installation-of-otrs.html#database-co... There are not pitfalls. Just check if all Perl modules are installed and keep an eye on the Apache httpd configuration when using mod_perl, I recommend to avoid mod_perl during the setup. Did you tried it like explained int the manual? hth, Roy -- Roy Kaldung e-mail: roy@kaldung.com

Michiel Beijen

3 Jun 3 Jun

8:09 a.m.

New subject: Installation documentation somewhat bias away from PostgreSQL

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 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

Paul Simons

9:34 a.m.

New subject: Installation documentation somewhat bias away from PostgreSQL

Hi Michiel Thank you for this advice and the links. Very glad to hear installer is being updated Regards ___________________________________________ Paul Simons -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Michiel Beijen Sent: Monday, June 03, 2013 10:09 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Installation documentation somewhat bias away from PostgreSQL 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 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

Paul Simons

10:19 a.m.

New subject: Installation documentation somewhat bias away from PostgreSQL

Any chance of releasing the 'installer.pl' before the official date? I could test it for you ;-) ___________________________________________ Paul Simons -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Paul Simons Sent: Monday, June 03, 2013 11:34 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Installation documentation somewhat bias away from PostgreSQL Hi Michiel Thank you for this advice and the links. Very glad to hear installer is being updated Regards ___________________________________________ Paul Simons -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Michiel Beijen Sent: Monday, June 03, 2013 10:09 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Installation documentation somewhat bias away from PostgreSQL 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 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 ________________________________ 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 ________________________________ 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.

Michiel Beijen

10:41 a.m.

New subject: Installation documentation somewhat bias away from PostgreSQL

Hi Paul, On Mon, Jun 3, 2013 at 6:19 AM, Paul Simons wrote:

...

Any chance of releasing the 'installer.pl' before the official date? I could test it for you ;-)

We'll have beta's before the release as usual. Also, it's on github, so you could check it there if you want, you'll find it in the 'master' branch: https://github.com/OTRS/otrs/tree/master And if you want to test it out probably the easiest way is to use the beta of the Windows Installer which already contains a backport of the new Web Installer: http://www.otrs.com/en/open-source/community-news/release-notes-otrs-windows... -- Mike

4428

Age (days ago)

4431

Last active (days ago)

List overview

Download

5 comments

3 participants

participants (3)

Michiel Beijen
Paul Simons
Roy Kaldung