[
https://issues.apache.org/jira/browse/TC-228?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15975727#comment-15975727
]
ASF GitHub Bot commented on TC-228:
-----------------------------------
GitHub user dangogh opened a pull request:
https://github.com/apache/incubator-trafficcontrol/pull/490
[BACKPORT TC-228] collective changes to postinstall to support postgres
All changes cherry-picked from master. Supports postgres initial setup as
well as postinstall batch-mode from an input json file.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/dangogh/incubator-trafficcontrol
2.0.x-postinstall-cumulative
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafficcontrol/pull/490.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #490
----
commit 64dc3bee748984622caa56588d7ba74c1819faa3
Author: PeterRyder <[email protected]>
Date: 2017-02-06T15:51:43Z
Removed openssl file and now pass data directly to GenerateCert
(cherry picked from commit 9729d23677c3b8d2d4431d6e2e1335ff72fda7ff)
commit 8dcc72d4519c5408de2a39807e46778c8f79ab3b
Author: PeterRyder <[email protected]>
Date: 2017-02-06T22:06:13Z
Check connection to database
(cherry picked from commit 6316bb33586b7b5e240bfc86ee307c076aec5023)
commit a8c36d6444fba0c4851ce8a0202143270c4d4126
Author: PeterRyder <[email protected]>
Date: 2017-02-06T22:13:07Z
changed database driver to Pg
(cherry picked from commit bd79a22f45555bcdf37ca202b643a20b7a502c32)
commit 44401f86ae0d474b0855c1ad3e0454d7669187da
Author: PeterRyder <[email protected]>
Date: 2017-02-07T16:14:23Z
Corrected database connection and removed hardcoded getDbDriver function
(cherry picked from commit 72f5b25bf81a4f3756b3763568cd091fbec0e696)
commit 906e6e844bc26e3bc1b398a274ca9e1982800bb8
Author: PeterRyder <[email protected]>
Date: 2017-02-07T16:20:59Z
Changed default port to 5432, the postgres default
(cherry picked from commit 5fd9f4c56d0911a8f4ca12472f2ae0e0612a2e7e)
commit 5f7d02a8654f9ea03ec668dc16bf8741fabb54bb
Author: PeterRyder <[email protected]>
Date: 2017-02-07T18:44:00Z
Fixed yml file for admin.pl with correct inputs for psql
(cherry picked from commit e086d1f7613776bbe73498409f73a46f3d158ab1)
commit 610bdbfa29c6452a2dd38fc0f29312b18c829b81
Author: Jeff Martin <[email protected]>
Date: 2017-04-07T17:31:52Z
Term::ReadPassword fix: TC-185
(cherry picked from commit 290e4bc082df416a727490dfc4a8210b3ff5d778)
commit da80d75478d0651cfe30aaf87aa8dce69eae945b
Author: Jeff Martin <[email protected]>
Date: 2017-04-11T19:06:55Z
[TC-228] postinstall and INSTALL.md updates
INSTALL.md
- Changed manual installation approach for non-containered postgres
postinstall
- Set reconfigure to 1, always init database
- Set debug to 1, always output so the end user sees what is
happening
- set the goose needed driver to "postgres" instead of "Pg"
- changed question default: "Database server root (admin) user"
name from "root" to "postgres"
- set PGUSER and PGPASSWORD in env to login to the postgres
superuser account
- update traffic_ops database table with the "admin" user name
and password provided by user (after initdb)
(cherry picked from commit f08a1c2a20266d67ed1a0c778180b6da99426096)
commit bc6f130bd7b916e42736cd494d07b7b5a38ebd2e
Author: Jeff Martin <[email protected]>
Date: 2017-04-11T20:18:06Z
[TC-228] global dec fix
Global symbol "%dbconf" requires explicit package name at
/opt/traffic_ops/install/bin/postinstall line 569.
Global symbol "%dbconf" requires explicit package name at
/opt/traffic_ops/install/bin/postinstall line 570.
(cherry picked from commit 5cf6fae56e05eb467b3fb2e6be885d3975f7632e)
commit 51ea817ed8dce22be72dcc15c0833cdf40d70d8d
Author: Jeff Martin <[email protected]>
Date: 2017-04-11T20:58:39Z
[TC-228] - bin and lib file updates
- remove install/bin/build_trafficops_perl_library
- remove mysql perl deps in install/lib/BuildPerlDeps.pm
(cherry picked from commit 7180ab5884e5b42663a073dd4750f67c8f89779c)
commit 415b11c8a4a44fc2bf13a28b75f0c86c5f943ac1
Author: Dan Kirkwood <[email protected]>
Date: 2017-04-12T15:40:52Z
no symlinks, no copying local/bin files
(cherry picked from commit 8f5234d4a5e06723b915cda7086bcd565f7e9cca)
commit 77306c9452025d9d4ef168820c0904efbbfc526d
Author: Dan Kirkwood <[email protected]>
Date: 2017-04-12T15:41:24Z
set ownership of /opt/traffic_ops
(cherry picked from commit 9f537714f03d613953efebe67d683c7a67966ed9)
commit f5bdcf0a9bc16de68440ffaee90ad3d3e62b0381
Author: Dan Kirkwood <[email protected]>
Date: 2017-04-12T16:48:49Z
fix perl5lib setting
(cherry picked from commit e15ae7d2356d19be4c7c3355ab807b9f430aedfd)
commit 212706525d155c544624c8cfb2c5bae58bf3d2a5
Author: Dan Kirkwood <[email protected]>
Date: 2017-04-12T18:10:28Z
fix perl5lib; require https module at the right point
(cherry picked from commit a276c36eb88242a630a16c5d3f04ed354e69b275)
commit eddc4a9661b2c4ba98564db8253ff7c40a2998b3
Author: Dewayne Richardson <[email protected]>
Date: 2017-04-12T20:47:19Z
switched the postgres user to be the driver of the admin.pl user
(cherry picked from commit 9d91e9835c7745ddb8049e168ae3e4df7d4d9834)
commit 4723d0b515b38b782b17e64fbafbc43ac2d5534f
Author: Dan Kirkwood <[email protected]>
Date: 2017-04-12T22:21:08Z
set perl5lib for sub-processes
(cherry picked from commit 670bb30f2f982d79ba90e9e6e7e8216a27ff7f7c)
commit 19439fbb9b2b7f163a7fca6b49b7d7bec41dbbd7
Author: Dan Kirkwood <[email protected]>
Date: 2017-04-12T23:51:55Z
chdir immediately before download_web_deps
(cherry picked from commit 65d1de01c6a9a25146e88540c7bb49ffc2d2ab5b)
commit f2b4753f1bac0bb3e2bcf9d300e7f1a98a7b0691
Author: Dan Kirkwood <[email protected]>
Date: 2017-04-13T00:33:03Z
ensure permissions set on all installed parts
(cherry picked from commit f22826e88270a23f910cbcc337492f991df9b9ee)
commit 63f820d70b7f0b4810edd1d9633f03a9108eb959
Author: Dewayne Richardson <[email protected]>
Date: 2017-04-13T15:01:18Z
added the ability to do a create_super_user
(cherry picked from commit d7494adf3e697c52f12b77561ed4b9661a764dd3)
commit a2459cdb4135aab45e2f0ad6a57d447cefa22e81
Author: Dewayne Richardson <[email protected]>
Date: 2017-04-13T16:47:09Z
added better usage and removed the create_user function
(cherry picked from commit a6bf558867ef8688c453567e103e9e2f706d9e4d)
commit 8d80eedda75ec0c136c07d09676ca07c2fff28ee
Author: Dewayne Richardson <[email protected]>
Date: 2017-04-13T19:05:53Z
fixed usage and removed the update_pgpass subroutine
(cherry picked from commit 35e549b9bb031e9fee7d0ec511b54b99d4eec506)
commit 971d0a3374c76452fed5f4f738c4cff942c18a7f
Author: Dewayne Richardson <[email protected]>
Date: 2017-04-13T19:06:53Z
removed the replication user variable
(cherry picked from commit ce92d6fcdd0f4babc7dcb975a4f0e6372670b759)
commit c7368b9b0f718214bdda319fe2f4545fb021d800
Author: Dewayne Richardson <[email protected]>
Date: 2017-04-13T19:52:23Z
added existence check on the create_user
(cherry picked from commit 3b53fbfb18f0a6557e7f93aeaeedf0905bcea40d)
commit 7654a42df5c5dc91436ef955e75957cb147d6da3
Author: Dewayne Richardson <[email protected]>
Date: 2017-04-13T19:59:39Z
changed the createdb to use the newly created traffic_ops user
(cherry picked from commit 9937a384044d090f184cc9175972e4de6e04db10)
commit 8dca9f749961daa27c82a578c49577609322d147
Author: Jeremy Mitchell <[email protected]>
Date: 2017-04-13T20:28:55Z
create role because its not there to alter and also need a few more
permissions on the postgres role
(cherry picked from commit ed11e01ef7a33f48cb1b4961c79ae724ea5e6592)
commit bc22f3d988b9d04c2e64327fb42c676477746287
Author: Jeremy Mitchell <[email protected]>
Date: 2017-04-13T21:55:11Z
superuser only creates the 'db_user' and creates databases (and assigns
ownership to the db_user) and then db_user takes it from there...drop table,
loadschema, migrate, seed...
(cherry picked from commit 60e0dae5d4e4db9b497dcf90f4d1ef96dc7c2aa7)
commit c43f6aa8dfdd0858c30d1ccd5592b9b6eb7caa38
Author: Dan Kirkwood <[email protected]>
Date: 2017-04-13T19:28:46Z
add postinstall wrapper
(cherry picked from commit 9015339f91fd2a2f5976fdb9a70133e7ee29b7de)
commit d578a49a36a1b414b3b11621dcd86ba70d6b472f
Author: Dan Kirkwood <[email protected]>
Date: 2017-04-13T19:53:26Z
chown now done by wrapper
(cherry picked from commit 72d1084af027b7ed4af30729d47cd2617e9ef5c5)
commit a30c5e8abd5976294f513b4efad07d0383241935
Author: Dan Kirkwood <[email protected]>
Date: 2017-04-13T20:01:17Z
remove BuildPerlDeps -- done by carton in wrapper
(cherry picked from commit 296d3b5033ec0ca68e209f911459c88c7c0886c9)
commit a5038b59796658a3ba1a92aa5c4a606a1bcce522
Author: Dan Kirkwood <[email protected]>
Date: 2017-04-13T20:14:18Z
POSTGRES_HOME before carton
(cherry picked from commit 15052be777dbcc159bd9b4f8e0104a916ebc7487)
----
> TO: postinstall changes needed for postgres
> -------------------------------------------
>
> Key: TC-228
> URL: https://issues.apache.org/jira/browse/TC-228
> Project: Traffic Control
> Issue Type: Bug
> Components: Traffic Ops
> Affects Versions: 2.0.0
> Reporter: Dan Kirkwood
> Fix For: 2.0.0
>
>
> more changes needed to get postinstall working correctly for a postgres
> installation.
> This is needed for 2.0.x release.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
