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

["Jan van Doorn (JIRA)" <ji...@apache.org>]

Jan van Doorn created TC-346:
--------------------------------

             Summary: 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: Dan Kirkwood


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)