You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafficcontrol.apache.org by dangogh <gi...@git.apache.org> on 2017/03/09 23:54:14 UTC

[GitHub] incubator-trafficcontrol pull request #344: Install instructions

GitHub user dangogh opened a pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/344

    Install instructions

    Add install instructions

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/dangogh/incubator-trafficcontrol install-instructions

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafficcontrol/pull/344.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 #344
    
----
commit 4c96fe2cb56978fd85e182f2d75ec7afbdadcc47
Author: Robert Scrimo <ro...@comcast.com>
Date:   2017-03-08T22:42:14Z

    changed psql to use URI.

commit facb76bd2829f5ad8557b9333a356fe5f2247e9c
Author: Robert Scrimo <ro...@comcast.com>
Date:   2017-03-09T18:50:54Z

    updated postgres wrappers to use psql

commit 275edb6176b153af5c8bb7832abab368f5585958
Author: Dan Kirkwood <da...@gmail.com>
Date:   2017-03-09T23:51:34Z

    add INSTALL.md instructions

----


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafficcontrol pull request #344: Install instructions

Posted by rscrimojr <gi...@git.apache.org>.
Github user rscrimojr commented on a diff in the pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/344#discussion_r105805912
  
    --- Diff: INSTALL.md ---
    @@ -0,0 +1,101 @@
    +# From new CentOS 7 install:
    +
    +## Disable selinux:
    +### change `/etc/selinux/config` to `SELINUX=disabled`
    +
    +## Install Postgreql 9.6 client and libraries
    +
    +Instructions are here: https://yum.postgresql.org/
    +
    +- grab the link for CentOS 7 and install:
    +    $ sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
    +
    +- install `postgresql96` (for psql commands) and `postgresql96-devel` (for includes/libraries needed to install `DBD::Pg` perl library)
    +    $ sudo yum install postgresql96 postgresql96-devel
    +
    +## Install Postgres 9.6 server (in a container or on the host)
    +
    +### on the host:
    +   $ sudo yum install postgresql96-server
    +
    +### -or- in a container
    +
    +NOTE: you do *not* need postgresql96-server if running postgres within a `docker` container.
    +
    +Install `docker` and `docker-compose` using instructions here:
    +    https://docs.docker.com/engine/installation/linux/centos/
    +    https://docs.docker.com/compose/install/
    +
    +Add yourself to `docker` group
    +    $ sudo usermod -G docker $USER
    +
    +Remember to logout and login again..   You should see `docker` in your list of groups:
    +
    +    $ id
    +    uid=9876(myuser) gid=9876(myuser) groups=9876(myuser),990(docker) ...
    +
    +Start a docker container to run postgres
    +    $ cd incubator-trafficcontrol/traffic_ops/app/db/pg-migration
    +    $ ./start_postgres.sh
    +
    +Edit `mysql-to-postgres.yml` to suit your needs.
    +- modify `POSTGRES_*` vars to apply to new postgres container that will house
    +
    +If migrating from an existing pre-2.0 traffic_ops server (mysql):
    +- `TO_*` vars for admin access to existing mysql-based `traffic_ops` (to get a db dump)
    +- `MYSQL_*` vars to apply to temporary mysql container
    +
    +Run migration from existing mysql-based `traffic_ops`
    +    $ ./migrate.sh
    +
    +## Install `traffic_ops`
    +    $ sudo yum install traffic_ops
    +
    +## Install `go` and `gcc` (required for `goose` and some `Perl` modules)
    +    $ sudo yum install go gcc
    +    
    +## Install Perl modules
    +    $ sudo cpanm Carton
    +
    +IMPORTANT!!: We're using a later version of Postgresql,  so it's not installed in the default place.
    +We need to tell carton where it is so the `DBD::Pg` module is installed correctly.
    +
    +    $ sudo su -
    +    # cd /opt/traffic_ops/app
    +    # POSTGRES_HOME=/usr/pgsql-9.6 /usr/local/bin/carton
    +
    +
    +## Install goose
    +    $ sudo GOPATH=/tmp GOBIN=/usr/local/bin go get bitbucket.org/liamstask/goose/cmd/goose
    +
    +
    +## Modify `traffic_ops` configuration
    +
    --- End diff --
    
    @dangogh Examples of values, even if generic but following the expected convention, for common entries to update would be a useful addition for those new to the project for the following section's configuration files. 


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafficcontrol pull request #344: Install instructions

Posted by rscrimojr <gi...@git.apache.org>.
Github user rscrimojr commented on a diff in the pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/344#discussion_r105805728
  
    --- Diff: INSTALL.md ---
    @@ -0,0 +1,101 @@
    +# From new CentOS 7 install:
    +
    +## Disable selinux:
    +### change `/etc/selinux/config` to `SELINUX=disabled`
    +
    +## Install Postgreql 9.6 client and libraries
    +
    +Instructions are here: https://yum.postgresql.org/
    +
    +- grab the link for CentOS 7 and install:
    +    $ sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
    +
    +- install `postgresql96` (for psql commands) and `postgresql96-devel` (for includes/libraries needed to install `DBD::Pg` perl library)
    +    $ sudo yum install postgresql96 postgresql96-devel
    +
    +## Install Postgres 9.6 server (in a container or on the host)
    +
    +### on the host:
    +   $ sudo yum install postgresql96-server
    +
    +### -or- in a container
    +
    +NOTE: you do *not* need postgresql96-server if running postgres within a `docker` container.
    +
    +Install `docker` and `docker-compose` using instructions here:
    +    https://docs.docker.com/engine/installation/linux/centos/
    +    https://docs.docker.com/compose/install/
    +
    +Add yourself to `docker` group
    +    $ sudo usermod -G docker $USER
    +
    +Remember to logout and login again..   You should see `docker` in your list of groups:
    +
    +    $ id
    +    uid=9876(myuser) gid=9876(myuser) groups=9876(myuser),990(docker) ...
    +
    +Start a docker container to run postgres
    +    $ cd incubator-trafficcontrol/traffic_ops/app/db/pg-migration
    +    $ ./start_postgres.sh
    +
    +Edit `mysql-to-postgres.yml` to suit your needs.
    +- modify `POSTGRES_*` vars to apply to new postgres container that will house
    +
    +If migrating from an existing pre-2.0 traffic_ops server (mysql):
    +- `TO_*` vars for admin access to existing mysql-based `traffic_ops` (to get a db dump)
    +- `MYSQL_*` vars to apply to temporary mysql container
    +
    --- End diff --
    
    @dangogh Examples of values, even if generic, for common variables would be a useful addition for those new to the project. 


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafficcontrol pull request #344: Install instructions

Posted by rscrimojr <gi...@git.apache.org>.
Github user rscrimojr commented on a diff in the pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/344#discussion_r105807323
  
    --- Diff: INSTALL.md ---
    @@ -0,0 +1,101 @@
    +# From new CentOS 7 install:
    +
    +## Disable selinux:
    +### change `/etc/selinux/config` to `SELINUX=disabled`
    +
    +## Install Postgreql 9.6 client and libraries
    +
    +Instructions are here: https://yum.postgresql.org/
    +
    +- grab the link for CentOS 7 and install:
    +    $ sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
    +
    +- install `postgresql96` (for psql commands) and `postgresql96-devel` (for includes/libraries needed to install `DBD::Pg` perl library)
    +    $ sudo yum install postgresql96 postgresql96-devel
    +
    +## Install Postgres 9.6 server (in a container or on the host)
    +
    +### on the host:
    +   $ sudo yum install postgresql96-server
    +
    +### -or- in a container
    +
    +NOTE: you do *not* need postgresql96-server if running postgres within a `docker` container.
    +
    +Install `docker` and `docker-compose` using instructions here:
    +    https://docs.docker.com/engine/installation/linux/centos/
    +    https://docs.docker.com/compose/install/
    +
    +Add yourself to `docker` group
    +    $ sudo usermod -G docker $USER
    +
    +Remember to logout and login again..   You should see `docker` in your list of groups:
    +
    +    $ id
    +    uid=9876(myuser) gid=9876(myuser) groups=9876(myuser),990(docker) ...
    +
    +Start a docker container to run postgres
    --- End diff --
    
    @dangogh Should this be after editing the `mysql-to-postgres.env` file?


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafficcontrol pull request #344: Install instructions

Posted by rscrimojr <gi...@git.apache.org>.
Github user rscrimojr commented on a diff in the pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/344#discussion_r105806268
  
    --- Diff: INSTALL.md ---
    @@ -0,0 +1,101 @@
    +# From new CentOS 7 install:
    +
    +## Disable selinux:
    +### change `/etc/selinux/config` to `SELINUX=disabled`
    +
    +## Install Postgreql 9.6 client and libraries
    +
    +Instructions are here: https://yum.postgresql.org/
    +
    +- grab the link for CentOS 7 and install:
    +    $ sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
    +
    +- install `postgresql96` (for psql commands) and `postgresql96-devel` (for includes/libraries needed to install `DBD::Pg` perl library)
    +    $ sudo yum install postgresql96 postgresql96-devel
    +
    +## Install Postgres 9.6 server (in a container or on the host)
    +
    +### on the host:
    +   $ sudo yum install postgresql96-server
    +
    +### -or- in a container
    +
    +NOTE: you do *not* need postgresql96-server if running postgres within a `docker` container.
    +
    +Install `docker` and `docker-compose` using instructions here:
    +    https://docs.docker.com/engine/installation/linux/centos/
    +    https://docs.docker.com/compose/install/
    +
    +Add yourself to `docker` group
    +    $ sudo usermod -G docker $USER
    +
    +Remember to logout and login again..   You should see `docker` in your list of groups:
    +
    +    $ id
    +    uid=9876(myuser) gid=9876(myuser) groups=9876(myuser),990(docker) ...
    +
    +Start a docker container to run postgres
    +    $ cd incubator-trafficcontrol/traffic_ops/app/db/pg-migration
    +    $ ./start_postgres.sh
    +
    +Edit `mysql-to-postgres.yml` to suit your needs.
    +- modify `POSTGRES_*` vars to apply to new postgres container that will house
    +
    +If migrating from an existing pre-2.0 traffic_ops server (mysql):
    +- `TO_*` vars for admin access to existing mysql-based `traffic_ops` (to get a db dump)
    +- `MYSQL_*` vars to apply to temporary mysql container
    +
    +Run migration from existing mysql-based `traffic_ops`
    +    $ ./migrate.sh
    +
    +## Install `traffic_ops`
    +    $ sudo yum install traffic_ops
    +
    +## Install `go` and `gcc` (required for `goose` and some `Perl` modules)
    +    $ sudo yum install go gcc
    +    
    +## Install Perl modules
    +    $ sudo cpanm Carton
    +
    +IMPORTANT!!: We're using a later version of Postgresql,  so it's not installed in the default place.
    +We need to tell carton where it is so the `DBD::Pg` module is installed correctly.
    +
    +    $ sudo su -
    +    # cd /opt/traffic_ops/app
    +    # POSTGRES_HOME=/usr/pgsql-9.6 /usr/local/bin/carton
    +
    +
    +## Install goose
    +    $ sudo GOPATH=/tmp GOBIN=/usr/local/bin go get bitbucket.org/liamstask/goose/cmd/goose
    +
    +
    +## Modify `traffic_ops` configuration
    +
    +- `/opt/traffic_ops/app/db`
    +   - `dbconf.yml` 
    +      - modify "production" line to match user/pass from env file above
    +- `/opt/traffic_ops/app/conf`
    +   - `cdn.conf` 
    +      - set workers to desired value (96 is far too high for dev environment -- 15 is suggested)
    +      - change `to.base_url` to appropriate FQDN or IP address
    +   - `ldap.conf`
    +      - add ldap server credentials if needed
    +   - `production/database.conf`
    +      - modify to match user/pass from env file above
    +   - `production/riak.conf`, `production/influxdb.conf`
    +      - add appropriate user/password
    +   - `production/log4perl.conf`
    +      - if logging data needed,  change ERROR to DEBUG on first line
    +
    +## Initialize the db
    +    $ cd /opt/traffic_ops/app
    +    $ PERL5LIB=$(pwd)/lib:$(pwd)/local/lib/perl5 db/admin.pl --env=production setup
    --- End diff --
    
    This should be fine once I check in the changes for this file tomorrow.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafficcontrol pull request #344: TO Install instructions

Posted by dangogh <gi...@git.apache.org>.
Github user dangogh commented on a diff in the pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/344#discussion_r106258643
  
    --- Diff: INSTALL.md ---
    @@ -0,0 +1,101 @@
    +# From new CentOS 7 install:
    +
    +## Disable selinux:
    +### change `/etc/selinux/config` to `SELINUX=disabled`
    +
    +## Install Postgreql 9.6 client and libraries
    +
    +Instructions are here: https://yum.postgresql.org/
    +
    +- grab the link for CentOS 7 and install:
    +    $ sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
    +
    +- install `postgresql96` (for psql commands) and `postgresql96-devel` (for includes/libraries needed to install `DBD::Pg` perl library)
    +    $ sudo yum install postgresql96 postgresql96-devel
    +
    +## Install Postgres 9.6 server (in a container or on the host)
    +
    +### on the host:
    +   $ sudo yum install postgresql96-server
    +
    +### -or- in a container
    +
    +NOTE: you do *not* need postgresql96-server if running postgres within a `docker` container.
    +
    +Install `docker` and `docker-compose` using instructions here:
    +    https://docs.docker.com/engine/installation/linux/centos/
    +    https://docs.docker.com/compose/install/
    +
    +Add yourself to `docker` group
    +    $ sudo usermod -G docker $USER
    +
    +Remember to logout and login again..   You should see `docker` in your list of groups:
    +
    +    $ id
    +    uid=9876(myuser) gid=9876(myuser) groups=9876(myuser),990(docker) ...
    +
    +Start a docker container to run postgres
    --- End diff --
    
    yep..


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafficcontrol pull request #344: TO Install instructions

Posted by MattMills <gi...@git.apache.org>.
Github user MattMills commented on a diff in the pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/344#discussion_r106281138
  
    --- Diff: traffic_ops/INSTALL.md ---
    @@ -8,53 +8,71 @@
     Instructions are here: https://yum.postgresql.org/
     
     - grab the link for CentOS 7 and install:
    -    $ sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
     
    +    $ sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
    +    
    +  NOTE: get a valid link from https://yum.postgresql.org/ with the correct version number.
    +  
     - install `postgresql96` (for psql commands) and `postgresql96-devel` (for includes/libraries needed to install `DBD::Pg` perl library)
    +
         $ sudo yum install postgresql96 postgresql96-devel
     
     ## Install Postgres 9.6 server (in a container or on the host)
     
     ### on the host:
    +
        $ sudo yum install postgresql96-server
     
     ### -or- in a container
     
     NOTE: you do *not* need postgresql96-server if running postgres within a `docker` container.
     
     Install `docker` and `docker-compose` using instructions here:
    +
         https://docs.docker.com/engine/installation/linux/centos/
    +    
         https://docs.docker.com/compose/install/
     
     Add yourself to `docker` group
    +
         $ sudo usermod -G docker $USER
     
     Remember to logout and login again..   You should see `docker` in your list of groups:
     
         $ id
         uid=9876(myuser) gid=9876(myuser) groups=9876(myuser),990(docker) ...
     
    +Edit `mysql-to-postgres.env` to suit your needs.
    +* modify `POSTGRES_*` vars to apply to new postgres container that will house your database, e.g.
    +  * POSTGRES_USER=postgres
    +  * POSTGRES_PASSWORD=itSas3cre4
    +  
    +If migrating from an existing pre-2.0 traffic_ops server (mysql):
    +* `TO_*` vars for admin access to existing mysql-based `traffic_ops` (to get a db dump), e.g.
    +  * TO_SERVER=https://trafficops.example.com
    +  * TO_USER=dennisr
    +  
    +* `MYSQL_*` vars to apply to temporary mysql container -- really no need to change..
    +
     Start a docker container to run postgres
    +
         $ cd incubator-trafficcontrol/traffic_ops/app/db/pg-migration
         $ ./start_postgres.sh
     
    -Edit `mysql-to-postgres.yml` to suit your needs.
    -- modify `POSTGRES_*` vars to apply to new postgres container that will house
    -
    -If migrating from an existing pre-2.0 traffic_ops server (mysql):
    -- `TO_*` vars for admin access to existing mysql-based `traffic_ops` (to get a db dump)
    -- `MYSQL_*` vars to apply to temporary mysql container
    -
     Run migration from existing mysql-based `traffic_ops`
    +
         $ ./migrate.sh
     
     ## Install `traffic_ops`
    +
         $ sudo yum install traffic_ops
    --- End diff --
    
    This won't work outside of Comcast


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafficcontrol pull request #344: TO Install instructions

Posted by MattMills <gi...@git.apache.org>.
Github user MattMills commented on a diff in the pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/344#discussion_r106282322
  
    --- Diff: traffic_ops/INSTALL.md ---
    @@ -88,14 +107,18 @@ We need to tell carton where it is so the `DBD::Pg` module is installed correctl
           - if logging data needed,  change ERROR to DEBUG on first line
     
     ## Initialize the db
    +
         $ cd /opt/traffic_ops/app
         $ PERL5LIB=$(pwd)/lib:$(pwd)/local/lib/perl5 db/admin.pl --env=production setup
         
     ## Install any extensions needed
    +
        - install in /opt/traffic_ops_extensions
        
     ## Install `openssl` certs (or use this to generate them)
    +
        - `sudo /opt/traffic_ops/install/bin/generateCert`
        
     ## Install web dependencies
    +
        - `sudo /opt/traffic_ops/install/bin/download_web_deps`
    --- End diff --
    
    What about the additional data in https://github.com/apache/incubator-trafficcontrol/tree/master/traffic_ops/install/data/json that used to be loaded by (I think) postinstall, but now isn't loaded, which includes the default profiles and parameters?
    
    If we don't have a way to load them today, I think it's worth putting a warning in the install instructions that they won't quite be able to get to a fully functioning install yet.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafficcontrol pull request #344: TO Install instructions

Posted by dangogh <gi...@git.apache.org>.
Github user dangogh commented on a diff in the pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/344#discussion_r106258947
  
    --- Diff: INSTALL.md ---
    @@ -0,0 +1,101 @@
    +# From new CentOS 7 install:
    +
    +## Disable selinux:
    +### change `/etc/selinux/config` to `SELINUX=disabled`
    +
    +## Install Postgreql 9.6 client and libraries
    +
    +Instructions are here: https://yum.postgresql.org/
    +
    +- grab the link for CentOS 7 and install:
    +    $ sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
    +
    +- install `postgresql96` (for psql commands) and `postgresql96-devel` (for includes/libraries needed to install `DBD::Pg` perl library)
    +    $ sudo yum install postgresql96 postgresql96-devel
    +
    +## Install Postgres 9.6 server (in a container or on the host)
    +
    +### on the host:
    +   $ sudo yum install postgresql96-server
    +
    +### -or- in a container
    +
    +NOTE: you do *not* need postgresql96-server if running postgres within a `docker` container.
    +
    +Install `docker` and `docker-compose` using instructions here:
    +    https://docs.docker.com/engine/installation/linux/centos/
    +    https://docs.docker.com/compose/install/
    +
    +Add yourself to `docker` group
    +    $ sudo usermod -G docker $USER
    +
    +Remember to logout and login again..   You should see `docker` in your list of groups:
    +
    +    $ id
    +    uid=9876(myuser) gid=9876(myuser) groups=9876(myuser),990(docker) ...
    +
    +Start a docker container to run postgres
    +    $ cd incubator-trafficcontrol/traffic_ops/app/db/pg-migration
    +    $ ./start_postgres.sh
    +
    +Edit `mysql-to-postgres.yml` to suit your needs.
    +- modify `POSTGRES_*` vars to apply to new postgres container that will house
    +
    +If migrating from an existing pre-2.0 traffic_ops server (mysql):
    +- `TO_*` vars for admin access to existing mysql-based `traffic_ops` (to get a db dump)
    +- `MYSQL_*` vars to apply to temporary mysql container
    +
    +Run migration from existing mysql-based `traffic_ops`
    +    $ ./migrate.sh
    +
    +## Install `traffic_ops`
    +    $ sudo yum install traffic_ops
    +
    +## Install `go` and `gcc` (required for `goose` and some `Perl` modules)
    +    $ sudo yum install go gcc
    +    
    +## Install Perl modules
    +    $ sudo cpanm Carton
    +
    +IMPORTANT!!: We're using a later version of Postgresql,  so it's not installed in the default place.
    +We need to tell carton where it is so the `DBD::Pg` module is installed correctly.
    +
    +    $ sudo su -
    +    # cd /opt/traffic_ops/app
    +    # POSTGRES_HOME=/usr/pgsql-9.6 /usr/local/bin/carton
    +
    +
    +## Install goose
    +    $ sudo GOPATH=/tmp GOBIN=/usr/local/bin go get bitbucket.org/liamstask/goose/cmd/goose
    +
    +
    +## Modify `traffic_ops` configuration
    +
    --- End diff --
    
    good point.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafficcontrol pull request #344: TO Install instructions

Posted by MattMills <gi...@git.apache.org>.
Github user MattMills commented on a diff in the pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/344#discussion_r106280949
  
    --- Diff: traffic_ops/INSTALL.md ---
    @@ -8,53 +8,71 @@
     Instructions are here: https://yum.postgresql.org/
     
     - grab the link for CentOS 7 and install:
    -    $ sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
     
    +    $ sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
    +    
    +  NOTE: get a valid link from https://yum.postgresql.org/ with the correct version number.
    +  
    --- End diff --
    
    You'll also need a yum install epel-release, since postgres' repo depends on epel.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafficcontrol pull request #344: Install instructions

Posted by rscrimojr <gi...@git.apache.org>.
Github user rscrimojr commented on a diff in the pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/344#discussion_r105807404
  
    --- Diff: INSTALL.md ---
    @@ -0,0 +1,101 @@
    +# From new CentOS 7 install:
    +
    +## Disable selinux:
    +### change `/etc/selinux/config` to `SELINUX=disabled`
    +
    +## Install Postgreql 9.6 client and libraries
    +
    +Instructions are here: https://yum.postgresql.org/
    +
    +- grab the link for CentOS 7 and install:
    +    $ sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
    +
    +- install `postgresql96` (for psql commands) and `postgresql96-devel` (for includes/libraries needed to install `DBD::Pg` perl library)
    +    $ sudo yum install postgresql96 postgresql96-devel
    +
    +## Install Postgres 9.6 server (in a container or on the host)
    +
    +### on the host:
    +   $ sudo yum install postgresql96-server
    +
    +### -or- in a container
    +
    +NOTE: you do *not* need postgresql96-server if running postgres within a `docker` container.
    +
    +Install `docker` and `docker-compose` using instructions here:
    +    https://docs.docker.com/engine/installation/linux/centos/
    +    https://docs.docker.com/compose/install/
    +
    +Add yourself to `docker` group
    +    $ sudo usermod -G docker $USER
    +
    +Remember to logout and login again..   You should see `docker` in your list of groups:
    +
    +    $ id
    +    uid=9876(myuser) gid=9876(myuser) groups=9876(myuser),990(docker) ...
    +
    +Start a docker container to run postgres
    +    $ cd incubator-trafficcontrol/traffic_ops/app/db/pg-migration
    +    $ ./start_postgres.sh
    +
    +Edit `mysql-to-postgres.yml` to suit your needs.
    --- End diff --
    
    Should `mysql-to-postgres.yml` be `mysql-to-postgres.env`?


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafficcontrol pull request #344: TO Install instructions

Posted by asfgit <gi...@git.apache.org>.
Github user asfgit closed the pull request at:

    https://github.com/apache/incubator-trafficcontrol/pull/344


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafficcontrol pull request #344: Install instructions

Posted by rscrimojr <gi...@git.apache.org>.
Github user rscrimojr commented on a diff in the pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/344#discussion_r105805687
  
    --- Diff: INSTALL.md ---
    @@ -0,0 +1,101 @@
    +# From new CentOS 7 install:
    +
    +## Disable selinux:
    +### change `/etc/selinux/config` to `SELINUX=disabled`
    +
    +## Install Postgreql 9.6 client and libraries
    +
    +Instructions are here: https://yum.postgresql.org/
    +
    +- grab the link for CentOS 7 and install:
    +    $ sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
    +
    +- install `postgresql96` (for psql commands) and `postgresql96-devel` (for includes/libraries needed to install `DBD::Pg` perl library)
    +    $ sudo yum install postgresql96 postgresql96-devel
    +
    +## Install Postgres 9.6 server (in a container or on the host)
    +
    +### on the host:
    +   $ sudo yum install postgresql96-server
    +
    +### -or- in a container
    +
    +NOTE: you do *not* need postgresql96-server if running postgres within a `docker` container.
    +
    +Install `docker` and `docker-compose` using instructions here:
    +    https://docs.docker.com/engine/installation/linux/centos/
    +    https://docs.docker.com/compose/install/
    +
    +Add yourself to `docker` group
    +    $ sudo usermod -G docker $USER
    +
    +Remember to logout and login again..   You should see `docker` in your list of groups:
    +
    +    $ id
    +    uid=9876(myuser) gid=9876(myuser) groups=9876(myuser),990(docker) ...
    +
    +Start a docker container to run postgres
    +    $ cd incubator-trafficcontrol/traffic_ops/app/db/pg-migration
    +    $ ./start_postgres.sh
    +
    +Edit `mysql-to-postgres.yml` to suit your needs.
    +- modify `POSTGRES_*` vars to apply to new postgres container that will house
    --- End diff --
    
    @dangogh Examples of values, even if generic, for common variables would be a useful addition for those new to the project. 


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafficcontrol pull request #344: Install instructions

Posted by rscrimojr <gi...@git.apache.org>.
Github user rscrimojr commented on a diff in the pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/344#discussion_r105804726
  
    --- Diff: INSTALL.md ---
    @@ -0,0 +1,101 @@
    +# From new CentOS 7 install:
    +
    +## Disable selinux:
    +### change `/etc/selinux/config` to `SELINUX=disabled`
    +
    +## Install Postgreql 9.6 client and libraries
    +
    +Instructions are here: https://yum.postgresql.org/
    +
    +- grab the link for CentOS 7 and install:
    +    $ sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
    --- End diff --
    
    @dangogh Since the url is not valid, It may be good to add a note "where xxxx is a integer, such as, 3 or latest version" . I tried running that command at first to realize that you wanted me to supply a valid value for xxxx.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafficcontrol pull request #344: TO Install instructions

Posted by dangogh <gi...@git.apache.org>.
Github user dangogh commented on a diff in the pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/344#discussion_r106258828
  
    --- Diff: INSTALL.md ---
    @@ -0,0 +1,101 @@
    +# From new CentOS 7 install:
    +
    +## Disable selinux:
    +### change `/etc/selinux/config` to `SELINUX=disabled`
    +
    +## Install Postgreql 9.6 client and libraries
    +
    +Instructions are here: https://yum.postgresql.org/
    +
    +- grab the link for CentOS 7 and install:
    +    $ sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
    +
    +- install `postgresql96` (for psql commands) and `postgresql96-devel` (for includes/libraries needed to install `DBD::Pg` perl library)
    +    $ sudo yum install postgresql96 postgresql96-devel
    +
    +## Install Postgres 9.6 server (in a container or on the host)
    +
    +### on the host:
    +   $ sudo yum install postgresql96-server
    +
    +### -or- in a container
    +
    +NOTE: you do *not* need postgresql96-server if running postgres within a `docker` container.
    +
    +Install `docker` and `docker-compose` using instructions here:
    +    https://docs.docker.com/engine/installation/linux/centos/
    +    https://docs.docker.com/compose/install/
    +
    +Add yourself to `docker` group
    +    $ sudo usermod -G docker $USER
    +
    +Remember to logout and login again..   You should see `docker` in your list of groups:
    +
    +    $ id
    +    uid=9876(myuser) gid=9876(myuser) groups=9876(myuser),990(docker) ...
    +
    +Start a docker container to run postgres
    +    $ cd incubator-trafficcontrol/traffic_ops/app/db/pg-migration
    +    $ ./start_postgres.sh
    +
    +Edit `mysql-to-postgres.yml` to suit your needs.
    +- modify `POSTGRES_*` vars to apply to new postgres container that will house
    +
    +If migrating from an existing pre-2.0 traffic_ops server (mysql):
    +- `TO_*` vars for admin access to existing mysql-based `traffic_ops` (to get a db dump)
    +- `MYSQL_*` vars to apply to temporary mysql container
    +
    --- End diff --
    
    that's fair..


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafficcontrol pull request #344: TO Install instructions

Posted by MattMills <gi...@git.apache.org>.
Github user MattMills commented on a diff in the pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/344#discussion_r106280492
  
    --- Diff: INSTALL.md ---
    @@ -0,0 +1,101 @@
    +# From new CentOS 7 install:
    +
    +## Disable selinux:
    +### change `/etc/selinux/config` to `SELINUX=disabled`
    +
    +## Install Postgreql 9.6 client and libraries
    +
    +Instructions are here: https://yum.postgresql.org/
    +
    +- grab the link for CentOS 7 and install:
    +    $ sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
    --- End diff --
    
    Also, the postgres repos depend on the epel repo, so there should also be a yum install epel-release


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafficcontrol pull request #344: TO Install instructions

Posted by dangogh <gi...@git.apache.org>.
Github user dangogh commented on a diff in the pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/344#discussion_r106258688
  
    --- Diff: INSTALL.md ---
    @@ -0,0 +1,101 @@
    +# From new CentOS 7 install:
    +
    +## Disable selinux:
    +### change `/etc/selinux/config` to `SELINUX=disabled`
    +
    +## Install Postgreql 9.6 client and libraries
    +
    +Instructions are here: https://yum.postgresql.org/
    +
    +- grab the link for CentOS 7 and install:
    +    $ sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
    +
    +- install `postgresql96` (for psql commands) and `postgresql96-devel` (for includes/libraries needed to install `DBD::Pg` perl library)
    +    $ sudo yum install postgresql96 postgresql96-devel
    +
    +## Install Postgres 9.6 server (in a container or on the host)
    +
    +### on the host:
    +   $ sudo yum install postgresql96-server
    +
    +### -or- in a container
    +
    +NOTE: you do *not* need postgresql96-server if running postgres within a `docker` container.
    +
    +Install `docker` and `docker-compose` using instructions here:
    +    https://docs.docker.com/engine/installation/linux/centos/
    +    https://docs.docker.com/compose/install/
    +
    +Add yourself to `docker` group
    +    $ sudo usermod -G docker $USER
    +
    +Remember to logout and login again..   You should see `docker` in your list of groups:
    +
    +    $ id
    +    uid=9876(myuser) gid=9876(myuser) groups=9876(myuser),990(docker) ...
    +
    +Start a docker container to run postgres
    +    $ cd incubator-trafficcontrol/traffic_ops/app/db/pg-migration
    +    $ ./start_postgres.sh
    +
    +Edit `mysql-to-postgres.yml` to suit your needs.
    --- End diff --
    
    ahh..   yep



---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafficcontrol pull request #344: TO Install instructions

Posted by MattMills <gi...@git.apache.org>.
Github user MattMills commented on a diff in the pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/344#discussion_r106280372
  
    --- Diff: INSTALL.md ---
    @@ -0,0 +1,101 @@
    +# From new CentOS 7 install:
    +
    +## Disable selinux:
    +### change `/etc/selinux/config` to `SELINUX=disabled`
    +
    +## Install Postgreql 9.6 client and libraries
    +
    +Instructions are here: https://yum.postgresql.org/
    +
    +- grab the link for CentOS 7 and install:
    +    $ sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
    --- End diff --
    
    Would probably make more sense to link the repo packages page here: https://yum.postgresql.org/repopackages.php


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---