Bug 1559474 - postgres support seems to be left out of this package but is included upstream
Summary: postgres support seems to be left out of this package but is included upstream
Keywords:
Status: CLOSED EOL
Alias: None
Product: Fedora
Classification: Fedora
Component: rt
Version: 29
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Ralf Corsepius
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2018-03-22 15:52 UTC by Garrett
Modified: 2019-11-27 19:22 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2019-11-27 19:22:14 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)

Description Garrett 2018-03-22 15:52:27 UTC
Description of problem:
Missing schema and acl files for postgresql.

Version-Release number of selected component (if applicable):
4.4.2-1

How reproducible:
Reviewing the file list at https://apps.fedoraproject.org/packages/rt/contents/ indicates none of the .Pg files are included where you'd expect them to be either in the /etc folder or the upgrade folders.

Steps to Reproduce:
1. Install rt
2. Configure RT_SiteConfig.pm database strings for Postgresql
3. Attempt to run /usr/sbin/rt-setup-database --dba postgres --action init --datadir /etc/rt/

Actual results:
The install fails as the schema and acl files for postgres are missing from /etc/rt

Expected results:
If you pull those files in from the github releases install runs as expected.

Additional info:
While it's easy to grab the additional files off the github releases this doesn't seem practical when using the package.

Comment 1 Emmanuel Seyman 2018-03-22 16:45:02 UTC
I suspect this bug is a dupe of bug #1288914

Comment 2 Ralf Corsepius 2018-03-22 18:39:17 UTC
(In reply to Emmanuel Seyman from comment #1)
> I suspect this bug is a dupe of bug #1288914
Correct. 

What I said there still applies. Though I've tried several times, I have not been able to get rt w/ postgres functional nor have I managed to find a viable way of packaging.

In a nutshell: patches welcome.

Comment 3 Garrett 2018-03-22 21:08:29 UTC
BestPractical has a set of instructions for postgres on Rhel 7 now that should apply: https://rt-wiki.bestpractical.com/wiki/CentOS7Install#RT_4.4.2_installation_on_CentOS_7.4.1708

I've gotten it working on centos 6 in the past, with the pg_hba.conf file being the trickiest portion of the overall setup to get right. I was looking at this due to the safer perl setup than using the os provided versions but if this isn't trivial I'll go back to that setup.

Comment 4 Jan Kurik 2018-08-14 11:07:25 UTC
This bug appears to have been reported against 'rawhide' during the Fedora 29 development cycle.
Changing version to '29'.

Comment 5 Ben Cotton 2019-10-31 20:44:57 UTC
This message is a reminder that Fedora 29 is nearing its end of life.
Fedora will stop maintaining and issuing updates for Fedora 29 on 2019-11-26.
It is Fedora's policy to close all bug reports from releases that are no longer
maintained. At that time this bug will be closed as EOL if it remains open with a
Fedora 'version' of '29'.

Package Maintainer: If you wish for this bug to remain open because you
plan to fix it in a currently maintained version, simply change the 'version' 
to a later Fedora version.

Thank you for reporting this issue and we are sorry that we were not 
able to fix it before Fedora 29 is end of life. If you would still like 
to see this bug fixed and are able to reproduce it against a later version 
of Fedora, you are encouraged  change the 'version' to a later Fedora 
version prior this bug is closed as described in the policy above.

Although we aim to fix as many bugs as possible during every release's 
lifetime, sometimes those efforts are overtaken by events. Often a 
more recent Fedora release includes newer upstream software that fixes 
bugs or makes them obsolete.

Comment 6 Ben Cotton 2019-11-27 19:22:14 UTC
Fedora 29 changed to end-of-life (EOL) status on 2019-11-26. Fedora 29 is
no longer maintained, which means that it will not receive any further
security or bug fix updates. As a result we are closing this bug.

If you can reproduce this bug against a currently maintained version of
Fedora please feel free to reopen this bug against that version. If you
are unable to reopen this bug, please file a new report against the
current release. If you experience problems, please add a comment to this
bug.

Thank you for reporting this bug and we are sorry it could not be fixed.


Note You need to log in before you can comment on or make changes to this bug.