[
https://issues.apache.org/jira/browse/TC-233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15969111#comment-15969111
]
ASF GitHub Bot commented on TC-233:
-----------------------------------
Github user dangogh commented on a diff in the pull request:
https://github.com/apache/incubator-trafficcontrol/pull/467#discussion_r111583751
--- Diff: traffic_ops/app/db/admin.pl ---
@@ -29,23 +29,44 @@
use YAML qw(LoadFile);
use DBIx::Class::Schema::Loader qw/make_schema_at/;
+use Env;
+use Env qw(HOME);
+
my $usage = "\n"
. "Usage: $PROGRAM_NAME [--env
(development|test|production|integration)] [arguments]\t\n\n"
. "Example: $PROGRAM_NAME --env=test reset\n\n"
. "Purpose: This script is used to manage database. The environments
are\n"
. " defined in the dbconf.yml, as well as the database
names.\n\n"
- . "arguments: \n\n"
+ . "NOTE: \n"
+ . "Postgres Superuser: The 'postgres' superuser needs to be created to
run $PROGRAM_NAME and setup databases.\n"
+ . "If the 'postgres' superuser has not been created or password has not
been set then run the following commands accordingly. \n\n"
+ . "Create the 'postgres' user as a super user (if not created):\n\n"
+ . " \$ createuser postgres --superuser --createrole --createdb
--login --pwprompt\n\n"
+ . "Postgres Password: file allows for easy command line access by
defaulting the user and password for the database\n"
+ . "without prompts.\n\n"
--- End diff --
didn't understand previous 2 lines until I saw mention of .pgpass below.
That probably should be more clear
> db/admin.pl needs updating to manage the postgres superuser
> -----------------------------------------------------------
>
> Key: TC-233
> URL: https://issues.apache.org/jira/browse/TC-233
> Project: Traffic Control
> Issue Type: Improvement
> Components: Traffic Ops
> Reporter: Dewayne Richardson
> Fix For: 2.0.0
>
>
> The admin.pl with Postgres needed to be updated to support the 'postgres'
> user and 'traffic_ops' users according to privileges. This is needed to
> support the 'postinstall' script so that the TrafficOps rpm can be installed
> properly.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
