couldn't view DG details in DG builder web UI

-1

Hi, i couldn't view DG details in DG builder web UI

can anyone tell what could be the reason and how to debug.

sdnc

Comment

CommentAdd your comment...

4 answers

1
0
-1
yang erdan
Sep 04, 2018
In dgbuilder container,
First, "cd /opt/onap/ccsdk/dgbuilder/svclogic/lib"
Second, "delete logback-classic-1.1.3.jar"
Third, "docker restart dgbuilderContainer"
due to logback-classic-1.1.3.jar and slf4j-simple-1.7.5.jar conflicting.
Comment
CommentAdd your comment...
1
0
-1
Rizwan Qamar
Jul 06, 2017
Ramu N Please try this:
ssh into sdnc then:
docker exec -it sdnc_dgbuilder_container bash
vim /opt/openecomp/sdnc/dgbuilder/releases/sdnc1.0/conf/svclogic.properties
change from: org.openecomp.sdnc.sli.jdbc.url=jdbc:mysql://localhost:3306/sdnctl
change to: org.openecomp.sdnc.sli.jdbc.url=jdbc:mysql://dbhost:3306/sdnctl
Comment
Ramu N
Jul 08, 2017
Hello Rizwan,
Thanks for the reply! but still i am facing some problem after above change..

sdnc_dgbuilder_container logs:
2017-07-08T02:26:01.980174451Z Could not load the file /opt/openecomp/sdnc/dgbuilder/releases/sdnc1.0/selected_modules
2017-07-08T02:26:06.806355618Z error:Error: connect ECONNREFUSED

root@7161879cb77f:/opt/openecomp/sdnc/dgbuilder/releases/sdnc1.0/conf# cat svclogic.properties
org.openecomp.sdnc.sli.dbtype=jdbc
org.openecomp.sdnc.sli.jdbc.url=jdbc:mysql://dbhost:3306/sdnctl
org.openecomp.sdnc.sli.jdbc.database=sdnctl
org.openecomp.sdnc.sli.jdbc.user=sdnctl
org.openecomp.sdnc.sli.jdbc.password=gamma
root@7161879cb77f:/opt/openecomp/sdnc/dgbuilder/releases/sdnc1.0/conf#

i tried to connect to mysql manually from dg container, that also failing..
root@7161879cb77f:/opt/openecomp/sdnc/dgbuilder/releases/sdnc1.0/conf# mysql -u sdnctl -hdbhost -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'dbhost' (111)

mysql status in sdnc_db_container is running
mysql> status
--------------
mysql Ver 14.14 Distrib 5.6.36, for Linux (x86_64) using EditLine wrapper
Connection id: 83
Current database:
Current user: sdnctl@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.6.36 MySQL Community Server (GPL)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 52 days 18 hours 49 min 44 sec
Threads: 1 Questions: 1956 Slow queries: 0 Opens: 164 Flush tables: 1 Open tables: 155 Queries per second avg: 0.000
--------------
mysql>
CommentAdd your comment...
1
0
-1
Ramu N
Jun 22, 2017
Hi Daniel,
commandToExec:/opt/openecomp/sdnc/dgbuilder/svclogic/svclogic.sh print VNF-API network-topology-operation sync 1.0.0-SNAPSHOT /opt/openecomp/sdnc/dgbuilder/releases/sdnc1.0/conf/svclogic.properties |sed -e 's%label=""""%label="null"%g'| dot -Tsvg
stderr:[main] ERROR org.openecomp.sdnc.sli.SvcLogicParser - Could not get service logic store
org.openecomp.sdnc.sli.ConfigurationException: Could load service store from properties file /opt/openecomp/sdnc/dgbuilder/releases/sdnc1.0/conf/svclogic.properties
at org.openecomp.sdnc.sli.SvcLogicStoreFactory.getSvcLogicStore(SvcLogicStoreFactory.java:48)
at org.openecomp.sdnc.sli.SvcLogicParser.getStore(SvcLogicParser.java:463)
at org.openecomp.sdnc.sli.SvcLogicParser.main(SvcLogicParser.java:417)
Caused by: org.openecomp.sdnc.sli.ConfigurationException: failed to get database connection [jdbc:mysql://localhost:3306/sdnctl]
at org.openecomp.sdnc.sli.SvcLogicJdbcStore.getConnection(SvcLogicJdbcStore.java:100)
at org.openecomp.sdnc.sli.SvcLogicJdbcStore.initDbResources(SvcLogicJdbcStore.java:362)
at org.openecomp.sdnc.sli.SvcLogicJdbcStore.init(SvcLogicJdbcStore.java:399)
at org.openecomp.sdnc.sli.SvcLogicStoreFactory.getSvcLogicStore(SvcLogicStoreFactory.java:92)
at org.openecomp.sdnc.sli.SvcLogicStoreFactory.getSvcLogicStore(SvcLogicStoreFactory.java:65)
at org.openecomp.sdnc.sli.SvcLogicStoreFactory.getSvcLogicStore(SvcLogicStoreFactory.java:46)
... 2 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1137)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:356)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2504)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2541)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2323)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:187)
at org.openecomp.sdnc.sli.SvcLogicJdbcStore.getConnection(SvcLogicJdbcStore.java:96)
... 7 more
Caused by: java.net.ConnectException: Connection refused (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:576)
at java.net.Socket.connect(Socket.java:525)
at java.net.Socket.<init>(Socket.java:425)
at java.net.Socket.<init>(Socket.java:241)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:258)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:306)
... 22 more

looks to be MySql connection failed.. sdnc_db_container is up and running.. but sdnc_portal_container is down..
can you tell how to debug further ?

ubuntu@vm1-sdnc:~$ sudo docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
7161879cb77f openecomp/dgbuilder-sdnc-image:latest "/bin/bash -c 'cd ..." 5 weeks ago Up 5 weeks 0.0.0.0:3000->3100/tcp sdnc_dgbuilder_container
b4d714b65382 openecomp/admportal-sdnc-image:latest "/bin/bash -c 'cd ..." 5 weeks ago Exited (8) 5 weeks ago sdnc_portal_container
64524009dc06 openecomp/sdnc-image:latest "/opt/openecomp/sd..." 5 weeks ago Up 5 weeks 0.0.0.0:8282->8181/tcp sdnc_controller_container
2f381599d2f6 mysql/mysql-server:5.6 "/entrypoint.sh my..." 5 weeks ago Up 5 weeks 0.0.0.0:32768->3306/tcp sdnc_db_container
ubuntu@vm1-sdnc:~$
Comment
Daniel Rose
Jun 22, 2017
looks like you cant connect to the database
CommentAdd your comment...
1
0
-1
Daniel Rose
Jun 22, 2017
can you post the sdnc logs?
Comment
CommentAdd your comment...