...
Login to
vid-mariadb-galera
databaseCode Block kubectl -n onap exec -it devonap-vid-vid-mariadb-galera-0 bash
Run following command to find database password
Code Block bash-4.2$ env | grep -i password MYSQL_PASSWORD=Kp8bJ4SXszM0WXlhak3eHlcse2gAw84vaoGGmJvUy2U MYSQL_ROOT_PASSWORD=secretpassword
Login to MariaDB and connect to
vid_openecomp_epsdk
databaseCode Block bash-4.2$ mysql -uroot -psecretpassword MariaDB [(none)]> show databases; +---------------------+ | Database | +---------------------+ | information_schema | | mysql | | performance_schema | | vid_openecomp_epsdk | +---------------------+ 4 rows in set (0.02 sec) MariaDB [(none)]> connect vid_openecomp_epsdk Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Connection id: 83013 Current database: vid_openecomp_epsdk MariaDB [vid_openecomp_epsdk]>
Insert following entries in
vid_category_parameter_option
tableCode Block MariaDB [vid_openecomp_epsdk]> select * from vid_category_parameter; +-------------+------------------------------+--------------+---------------------------+---------------------+---------------------+ | CATEGORY_ID | NAME | ID_SUPPORTED | FAMILY | CREATED_DATE | MODIFIED_DATE | +-------------+------------------------------+--------------+---------------------------+---------------------+---------------------+ | 1 | platform | 0 | PARAMETER_STANDARDIZATION | 2017-09-12 17:01:13 | 2017-09-12 17:01:13 | | 2 | project | 0 | PARAMETER_STANDARDIZATION | 2017-09-12 18:23:54 | 2017-09-13 15:05:25 | | 3 | lineOfBusiness | 0 | PARAMETER_STANDARDIZATION | 2017-09-12 18:24:14 | 2017-09-12 18:24:15 | | 4 | owningEntity | 1 | PARAMETER_STANDARDIZATION | 2017-09-12 18:24:26 | 2017-09-12 18:24:28 | | 5 | operational-environment-type | 0 | TENANT_ISOLATION | 2017-11-12 18:24:26 | 2017-11-12 18:24:28 | | 6 | workload-context | 0 | TENANT_ISOLATION | 2017-11-12 18:24:26 | 2017-11-12 18:24:28 | +-------------+------------------------------+--------------+---------------------------+---------------------+---------------------+ 6 rows in set (0.01 sec) MariaDB [vid_openecomp_epsdk]> select * from vid_category_parameter_option; +--------------------+---------------------+-------+-------------+---------------------+---------------------+ | CATEGORY_OPT_DB_ID | CATEGORY_OPT_APP_ID | NAME | CATEGORY_ID | CREATED_DATE | MODIFIED_DATE | +--------------------+---------------------+-------+-------------+---------------------+---------------------+ | 25 | ECOMP | ECOMP | 6 | 2018-12-06 14:55:12 | 2018-12-06 14:55:12 | | 26 | DEV | DEV | 6 | 2018-12-06 14:55:12 | 2018-12-06 14:55:12 | | 27 | TEST | TEST | 6 | 2018-12-06 14:55:12 | 2018-12-06 14:55:12 | | 28 | VNF | VNF | 5 | 2018-12-06 14:55:12 | 2018-12-06 14:55:12 | +--------------------+---------------------+-------+-------------+---------------------+---------------------+ MariaDB [vid_openecomp_epsdk]> SHOW COLUMNS FROM vid_category_parameter_option; +---------------------+-------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+-------------+------+-----+-------------------+----------------+ | CATEGORY_OPT_DB_ID | int(11) | NO | PRI | NULL | auto_increment | | CATEGORY_OPT_APP_ID | varchar(50) | NO | | NULL | | | NAME | varchar(50) | YES | | NULL | | | CATEGORY_ID | int(11) | NO | MUL | 0 | | | CREATED_DATE | timestamp | NO | | CURRENT_TIMESTAMP | | | MODIFIED_DATE | timestamp | NO | | CURRENT_TIMESTAMP | | +---------------------+-------------+------+-----+-------------------+----------------+ INSERT INTO vid_category_parameter_option (CATEGORY_OPT_APP_ID, NAME, CATEGORY_ID) VALUES ('oe_1', 'oe_2', 4); INSERT INTO vid_category_parameter_option (CATEGORY_OPT_APP_ID, NAME, CATEGORY_ID) VALUES ('PLATFORM_APP_ID_1', 'PLATFORM_NAME_1', 1);
How to fix ALaCarte Service createInstance is not supported by GR_API.
error while instantiating VNF
Login into SO Mariadb
Code Block root@esy22-rancher:~# kubectl -n onap get pods | grep mariadb-galera dev-mariadb-galera-mariadb-galera-0 1/1 Running 0 10d dev-mariadb-galera-mariadb-galera-1 1/1 Running 0 10d dev-mariadb-galera-mariadb-galera-2 1/1 Running 0 10d dev-vid-vid-mariadb-galera-0 1/1 Running 0 2d22h root@esy22-rancher:~# kubectl -n onap exec -it dev-mariadb-galera-mariadb-galera-0 bash bash-4.2$
login to database and connect to
catalogdb
Code Block bash-4.2$ env | grep -i password MYSQL_PASSWORD=my-password MYSQL_ROOT_PASSWORD=secretpassword bash-4.2$ mysql -uroot -psecretpassword Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 188369 Server version: 10.1.24-MariaDB MariaDB Server Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> connect catalogdb; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Connection id: 188371 Current database: catalogdb MariaDB [catalogdb]>
Change SERVICE_TYPE Null value to *
Code Block MariaDB [catalogdb]> select * from northbound_request_ref_lookup; +-----+-------------------+-----------------------------------+--------------------------+-------------+-----------------+-----------------+-----------------+-------------+--------------+ | id | REQUEST_SCOPE | MACRO_ACTION | ACTION | IS_ALACARTE | MIN_API_VERSION | MAX_API_VERSION | IS_TOPLEVELFLOW | CLOUD_OWNER | SERVICE_TYPE | +-----+-------------------+-----------------------------------+--------------------------+-------------+-----------------+-----------------+-----------------+-------------+--------------+ | 86 | Service | Service-Create | createInstance | 1 | 7 | 7 | 1 | CloudOwner | NULL | | 89 | Service | Service-Delete | deleteInstance | 1 | 7 | 7 | 1 | CloudOwner | NULL | | 92 | Service | Service-Macro-Assign | assignInstance | 0 | 7 | 7 | 1 | CloudOwner | NULL | | 95 | Service | Service-Macro-Activate | activateInstance | 0 | 5 | 7 | 1 | CloudOwner | NULL | | 98 | Service | Service-Macro-Unassign | unassignInstance | 0 | 7 | 7 | 1 | CloudOwner | NULL | | 101 | Service | Service-Macro-Create | createInstance | 0 | 5 | 7 | 1 | CloudOwner | NULL | | 104 | Service | Service-Macro-Delete | deleteInstance | 0 | 5 | 7 | 1 | CloudOwner | NULL | | 107 | Network | Network-Create | createInstance | 1 | 7 | 7 | 1 | CloudOwner | NULL | | 110 | Network | Network-Delete | deleteInstance | 1 | 7 | 7 | 1 | CloudOwner | NULL | | 113 | Vnf | VNF-Macro-Recreate | recreateInstance | 0 | 7 | 7 | 1 | CloudOwner | NULL | | 116 | Vnf | VNF-Macro-Replace | replaceInstance | 0 | 7 | 7 | 1 | CloudOwner | NULL | | 119 | Vnf | VNF-Create | createInstance | 1 | 7 | 7 | 1 | CloudOwner | NULL | | 122 | Vnf | VNF-Delete | deleteInstance | 1 | 7 | 7 | 1 | CloudOwner | NULL | | 125 | VolumeGroup | VolumeGroup-Create | createInstance | 1 | 7 | 7 | 1 | CloudOwner | NULL | | 128 | VolumeGroup | VolumeGroup-Delete | deleteInstance | 1 | 7 | 7 | 1 | CloudOwner | NULL | | 131 | VfModule | VFModule-Create | createInstance | 1 | 7 | 7 | 1 | CloudOwner | NULL | | 134 | VfModule | VFModule-Delete | deleteInstance | 1 | 7 | 7 | 1 | CloudOwner | NULL | | 137 | NetworkCollection | NetworkCollection-Macro-Create | createInstance | 0 | 7 | 7 | 1 | CloudOwner | NULL | | 140 | NetworkCollection | NetworkCollection-Macro-Delete | deleteInstance | 0 | 7 | 7 | 1 | CloudOwner | NULL | | 143 | VfModule | VFModule-ScaleOut | createInstance | 1 | 7 | 7 | 1 | CloudOwner | NULL | | 146 | VfModule | VFModule-DeactivateAndCloudDelete | deactivateAndCloudDelete | 1 | 7 | 7 | 1 | CloudOwner | NULL | | 149 | Service | Service-Macro-Deactivate | deactivateInstance | 0 | 5 | 7 | 1 | CloudOwner | NULL | | 152 | Network | Network-Update | updateInstance | 1 | 7 | 7 | 1 | CloudOwner | NULL | +-----+-------------------+-----------------------------------+--------------------------+-------------+-----------------+-----------------+-----------------+-------------+--------------+ 23 rows in set (0.00 sec) MariaDB [catalogdb]> UPDATE northbound_request_ref_lookup set SERVICE_TYPE='*'; Query OK, 0 rows affected (0.00 sec) Rows matched: 23 Changed: 0 Warnings: 0