[TC-346] 2.1 (master) Traffic Ops Installation issues.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Component/s: Traffic Ops
• Labels: installation
• Assignee: Dewayne Richardson
• Reporter: Jan van Doorn
• Created: 21/May/17 21:49
• Updated: 20/Jul/17 21:01
• Resolved: 20/Jul/17 21:01

Description

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:

 
=========== 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 ~]#

Issue Links

• links to: GitHub Pull Request #597