[ https://issues.apache.org/jira/browse/TC-346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16020092#comment-16020092 ]
ASF GitHub Bot commented on TC-346: ----------------------------------- GitHub user dewrich opened a pull request: https://github.com/apache/incubator-trafficcontrol/pull/597 [TC-346] Fixes postinstall issues with the cdn table and perl variables You can merge this pull request into a Git repository by running: $ git pull https://github.com/dewrich/incubator-trafficcontrol TC-346 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafficcontrol/pull/597.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 #597 ---- commit 610c6c22f44a221206e4e53b69e0c0c806c32793 Author: Dewayne Richardson <dewr...@apache.org> Date: 2017-05-22T13:34:38Z Fixed the Use of uninitialized value in concatenation (.) or string at commit f868cae629d9513db66713ad3d89d443bd1c927a Author: Dewayne Richardson <dewr...@apache.org> Date: 2017-05-22T19:56:54Z moved the toolname and instance name back into seeds for postinstall simplicity ---- > 2.1 (master) Traffic Ops Installation issues. > --------------------------------------------- > > Key: TC-346 > URL: https://issues.apache.org/jira/browse/TC-346 > Project: Traffic Control > Issue Type: Bug > Components: Traffic Ops > Affects Versions: 2.1.0 > Reporter: Jan van Doorn > Assignee: Dewayne Richardson > > Trying to install TO from scratch. Some notes: > 1) had to install postgres stuff even though postgres is remote: > [jvando001@ipcdn-cache-28 tmp]$ sudo yum install postgresql > [root@ipcdn-cache-28 ~]# yum install postgresql-devel > 2) Some errors on the seeds, not sure if they matter: > {code} > =========== Setting up parameters > Use of uninitialized value in concatenation (.) or string at > /opt/traffic_ops/install/bin/_postinstall line 638. > Use of uninitialized value in concatenation (.) or string at > /opt/traffic_ops/install/bin/_postinstall line 638. > -- global parameters > insert into parameter (name, config_file, value) > values ('tm.url', 'global', 'https://localhost') > ON CONFLICT (name, config_file, value) DO NOTHING; > insert into parameter (name, config_file, value) > values ('tm.instance_name', 'global', '') > ON CONFLICT (name, config_file, value) DO NOTHING; > insert into parameter (name, config_file, value) > values ('tm.toolname', 'global', '') > ON CONFLICT (name, config_file, value) DO NOTHING; > insert into parameter (name, config_file, value) > values ('tm.infourl', 'global', 'https://localhost/doc') > ON CONFLICT (name, config_file, value) DO NOTHING; > -- CRConfig.json parameters > insert into parameter (name, config_file, value) > values ('geolocation.polling.url', 'CRConfig.json', > 'https://localhost/routing/GeoLite2-City.mmdb.gz') > ON CONFLICT (name, config_file, value) DO NOTHING; > insert into parameter (name, config_file, value) > values ('geolocation6.polling.url', 'CRConfig.json', > 'https://localhost/routing/GeoLiteCityv6.dat.gz') > ON CONFLICT (name, config_file, value) DO NOTHING; > =========== Setting up profilesUse of uninitialized value in concatenation > (.) or string at /opt/traffic_ops/install/bin/_postinstall line 676. > Use of uninitialized value in concatenation (.) or string at > /opt/traffic_ops/install/bin/_postinstall line 676. > -- global parameters > insert into profile (name, description, type) > values ('GLOBAL', 'Global Traffic Ops profile, DO NOT > DELETE', 'UNK_PROFILE') > ON CONFLICT (name) DO NOTHING; > insert into profile_parameter (profile, parameter) > values ( (select id from profile where name = 'GLOBAL'), > (select id from parameter where name = 'tm.url' and config_file = 'global' > and value = 'https://localhost') ) > ON CONFLICT (profile, parameter) DO NOTHING; > insert into profile_parameter (profile, parameter) > values ( (select id from profile where name = 'GLOBAL'), > (select id from parameter where name = 'tm.instance_name' and config_file = > 'global' and value = '') ) > ON CONFLICT (profile, parameter) DO NOTHING; > insert into profile_parameter (profile, parameter) > values ( (select id from profile where name = 'GLOBAL'), > (select id from parameter where name = 'tm.toolname' and config_file = > 'global' and value = '') ) > ON CONFLICT (profile, parameter) DO NOTHING; > insert into profile_parameter (profile, parameter) > values ( (select id from profile where name = 'GLOBAL'), > (select id from parameter where name = 'tm.infourl' and config_file = > 'global' and value = 'https://localhost/doc') ) > ON CONFLICT (profile, parameter) DO NOTHING; > insert into profile_parameter (profile, parameter) > values ( (select id from profile where name = 'GLOBAL'), > (select id from parameter where name = 'geolocation.polling.url' and > config_file = 'CRConfig.json' and value = > 'https://cdn1.denver-isp.org/routing/GeoLite2-City.mmdb.gz') ) > ON CONFLICT (profile, parameter) DO NOTHING; > insert into profile_parameter (profile, parameter) > values ( (select id from profile where name = 'GLOBAL'), > (select id from parameter where name = 'geolocation6.polling.url' and > config_file = 'CRConfig.json' and value = > 'https://cdn1.denver-isp.org/routing/GeoLiteCityv6.dat.gz') ) > ON CONFLICT (profile, parameter) DO NOTHING; > DBD::Pg::st execute failed: ERROR: null value in column "parameter" violates > not-null constraint > DETAIL: Failing row contains (1, null, 2017-05-21 21:42:59.369057+00). at > /opt/traffic_ops/install/bin/_postinstall line 718. > Starting Traffic Ops > Restarting traffic_ops (via systemctl): [ OK ] > Waiting for Traffic Ops to restart > Success! Postinstall complete. > [root@ipcdn-cache-28 ~]# > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)