[ https://issues.apache.org/jira/browse/TC-346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16048357#comment-16048357 ]
Ryan Durfey commented on TC-346: -------------------------------- Can this be resolved or closed? > 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 > Labels: installation > > 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.4.14#64029)