[Frankfurt] SDNC does not connect to mariadb-galera cluster - Distribution fails


Aniello Paolo Malinconico
 

Hi all,

I have deployed the ONAP, frankfurt release in order to run the vfw cnf cds use case.

The distribution of the service fails into SDNC. Taking a look to the sdnc ueb log, it shows:

 

DEBUG 2020-08-28 07:46:29.504 +0000 HttpClient - Consuming the entity.
INFO 2020-08-28 07:46:33.689 +0000 CachedDataSource - SQL DataSource < sdnctldb01 > test failed. Cause : Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'sdnctl'@'10.42.3.20' (using pasDEBUG 2020-08-28 07:38:12.964 +0000 DistributionClientImpl - try to send status {
  "distributionID": "00ed0933-d51c-4476-8b09-b94db5407379",
  "consumerID": "sdc-COpenSource-Env11-sdnc-dockero",
  "timestamp": 1598600292963,
  "artifactURL": "/sdc/v1/catalog/services/SvcVfwCdsCnf/1.0/artifacts/service-SvcVfwCdsCnf-csar.csar",
  "status": "DOWNLOAD_OK"
}
INFO 2020-08-28 07:38:13.064 +0000 CambriaSimplerBatchPublisher - sending 1 msgs to /events/SDC-DISTR-STATUS-TOPIC-AUTO. Oldest: 100 ms
WARN 2020-08-28 07:38:13.064 +0000 HttpClient - POST http://message-router.onap:3904/events/SDC-DISTR-STATUS-TOPIC-AUTO will send credentials over a clear channel.
INFO 2020-08-28 07:38:13.064 +0000 HttpClient - POST http://message-router.onap:3904/events/SDC-DISTR-STATUS-TOPIC-AUTO (as mu5wcju4NGPPRtcY) ...
INFO 2020-08-28 07:38:13.115 +0000 HttpClient -         --> HTTP/1.1 200 OK
DEBUG 2020-08-28 07:38:13.115 +0000 HttpClient - Consuming the entity.
INFO 2020-08-28 07:38:13.115 +0000 CambriaSimplerBatchPublisher - cambria reply ok (51 ms):{"serverTimeMs":0,"count":1}
INFO 2020-08-28 07:38:13.366 +0000 CachedDataSource - SQL DataSource < sdnctldb01 > test failed. Cause : Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'sdnctl'@'10.42.3.20' (using pas
sword: YES)
Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding'> test failed. Cause : {}
INFO 2020-08-28 07:38:13.964 +0000 SdncUebCallback - Process TOSCA CSAR file: /opt/onap/sdnc/ueb-listener/spool/incoming/svc_vfw_cds_cnf/service-SvcVfwCdsCnf-csar.csar
DEBUG 2020-08-28 07:38:13.965 +0000 Reflections - going to scan these urls:
jar:file:/opt/onap/sdnc/ueb-listener/lib/jtosca-1.6.0.jar!/
INFO 2020-08-28 07:38:13.965 +0000 Reflections - Reflections took 0 ms to scan 1 urls, producing 4 keys and 4 values
DEBUG 2020-08-28 07:38:14.071 +0000 ToscaTemplate - ToscaTemplate Loading YAMEL file /tmp/JTP3937430977411328163/Definitions/service-SvcVfwCdsCnf-template.yml
DEBUG 2020-08-28 07:38:14.521 +0000 SdcCsarHelperImpl - CSAR conformance level is 11.0
WARN 2020-08-28 07:38:14.522 +0000 SdcToscaParserFactory - ####################################################################################################
WARN 2020-08-28 07:38:14.522 +0000 SdcToscaParserFactory - CSAR Warnings found! CSAR name - /opt/onap/sdnc/ueb-listener/spool/incoming/svc_vfw_cds_cnf/service-SvcVfwCdsCnf-csar.csar
WARN 2020-08-28 07:38:14.522 +0000 SdcToscaParserFactory - ToscaTemplate - verifyTemplate - 5 Parsing Warnings occurred...
WARN 2020-08-28 07:38:14.522 +0000 SdcToscaParserFactory - JTosca Exception [JE003]: MissingRequiredFieldError: properties of template "vf_vfw_cds_cnf 0" are missing field(s): [unit, type]. CSAR name - /opt/onap/sdnc/ueb-listener/spool/i
ncoming/svc_vfw_cds_cnf/service-SvcVfwCdsCnf-csar.csar
WARN 2020-08-28 07:38:14.522 +0000 SdcToscaParserFactory - JTosca Exception [JE003]: MissingRequiredFieldError: properties of template "abstract_dummy_base" are missing field(s): [unit, type]. CSAR name - /opt/onap/sdnc/ueb-listener/spoo
l/incoming/svc_vfw_cds_cnf/service-SvcVfwCdsCnf-csar.csar
WARN 2020-08-28 07:38:14.522 +0000 SdcToscaParserFactory - JTosca Exception [JE003]: MissingRequiredFieldError: properties of template "vf_vfw_cds_cnf 0" are missing field(s): [nf_function, nf_naming_code, max_instances, nf_type, nf_role
, min_instances]. CSAR name - /opt/onap/sdnc/ueb-listener/spool/incoming/svc_vfw_cds_cnf/service-SvcVfwCdsCnf-csar.csar
WARN 2020-08-28 07:38:14.522 +0000 SdcToscaParserFactory - JTosca Exception [JE003]: MissingRequiredFieldError: properties of template "abstract_dummy_base" are missing field(s): [nfc_function]. CSAR name - /opt/onap/sdnc/ueb-listener/sp
ool/incoming/svc_vfw_cds_cnf/service-SvcVfwCdsCnf-csar.csar
WARN 2020-08-28 07:38:14.522 +0000 SdcToscaParserFactory - JTosca Exception [JE003]: MissingRequiredFieldError: Data value of type "org.openecomp.datatypes.Naming" is missing required field(s) "[supplemental_data]". CSAR name - /opt/onap
/sdnc/ueb-listener/spool/incoming/svc_vfw_cds_cnf/service-SvcVfwCdsCnf-csar.csar
WARN 2020-08-28 07:38:14.522 +0000 SdcToscaParserFactory - ####################################################################################################
ERROR 2020-08-28 07:38:14.522 +0000 DBResourceManager - Generated alarm: DBResourceManager.getData - No active DB connection pools are available.
ERROR 2020-08-28 07:38:14.522 +0000 SdncUebCallback - Could not clean up existing NETWORK_MODEL and SERVICE_MODEL for service_UUID "4035ef2d-fc08-4bef-a636-daea32a820a4"
org.onap.ccsdk.sli.core.dblib.DBLibException: No active DB connection pools are available in RequestDataNoRecovery call.
        at org.onap.ccsdk.sli.core.dblib.DBResourceManager.requestDataNoRecovery(DBResourceManager.java:535) ~[dblib-provider-0.7.2.jar:?]
        at org.onap.ccsdk.sli.core.dblib.DBResourceManager.getData(DBResourceManager.java:462) ~[dblib-provider-0.7.2.jar:?]
 
 
In fact, into the sdnctl db, the VF_MODEL and SERVICE_MODEL tables do not contain any vfw cds cnf info.


However,
I have tested the db connectivity manually by running the following command inside to the ueb pod:
 
 mysql -hmariadb-galera -uroot -pXaww4^Daauauaa

and it works, I enter into the mysql db.
 
 
So, how can I solve this issue?
Thanks,

Aniello 

--

-----------------------------------------------------------------
TIM
Aniello Paolo Malinconico
Chief Innovation & Partnership Office
Technology Innovation
 
TIM S.p.A.
Via G. Reiss Romoli, 274 – 10148 TORINO
email: aniellopaolo.malinconico@...
Tim Official: Facebook - Twitter - www.tim.it

Join onap-discuss@lists.onap.org to automatically receive all group messages.