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 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
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-boun...@otrs.org [mailto:otrs-boun...@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 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 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
Re: [otrs] 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-boun...@otrs.org [mailto:otrs-boun...@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-boun...@otrs.org [mailto:otrs-boun...@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 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 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. - 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
Re: [otrs] Installation documentation somewhat bias away from PostgreSQL
Hi Paul, On Mon, Jun 3, 2013 at 6:19 AM, Paul Simons paul.sim...@onair.aero 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-installer-300-beta3/ -- Mike - 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] Installation documentation somewhat bias away from PostgreSQL
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
Re: [otrs] Installation documentation somewhat bias away from PostgreSQL
On May 31, 2013, at 10:26 AM, Paul Simons paul.sim...@onair.aero wrote: Hello Hi 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-configuration 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: r...@kaldung.com - 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
