How to get Flogo Connector DBService logs
Article ID: KB0073789
Updated On:
| Products | Versions |
|---|---|
| TIBCO Flogo Connector DB Service | - |
Description
Flogo Connector DBService is implemented for handling the connection of Database related Flogo connectors to the target DB server.
It was a separate product that needed to be installed prior to Flogo Enterprise 2.9.0 release.
Starting from Flogo Enterprise 2.9.0, DB service is available out-of-the-box and need not be installed separately.
Installing Flogo Enterprise automatically will install DB Service component as well.
When troubleshooting any DB connection issue in the DB Flogo Connector UI, for example, Oracle MySQL Flogo Connector, it is crucial to get the DB service log files for investigation.
Below steps can be followed to locate the DB service logs,
- use docker ps to see the name of the existing container, i.e. flogo-studio, to ensure the flogo studio is running in the container.
- use the command docker exec -it <container name> /bin/bash to get a bash shell in the container, i.e. docker exec -it flogo-studio /bin/bash
- navigate to dbservice logs folder where the logs dbs.err and dbs.log are stored. For example, /usr/flogo/services/dbservice/logs
What is more, a Web API request can be invoked for checking on the status of dbservice,
i.e.
$ curl http://<FlogoStudio_Web_URL>/dbservicego/api/v2/greetings
It should return like below:
{ "greetings": "Hello from DBService", "version" : "3.0", "databases" : "PostgresSQL, AmazonRedshift, SQLServer, MySQL, MSSQLServer, Snowflake" }
It was a separate product that needed to be installed prior to Flogo Enterprise 2.9.0 release.
Starting from Flogo Enterprise 2.9.0, DB service is available out-of-the-box and need not be installed separately.
Installing Flogo Enterprise automatically will install DB Service component as well.
When troubleshooting any DB connection issue in the DB Flogo Connector UI, for example, Oracle MySQL Flogo Connector, it is crucial to get the DB service log files for investigation.
Below steps can be followed to locate the DB service logs,
- use docker ps to see the name of the existing container, i.e. flogo-studio, to ensure the flogo studio is running in the container.
- use the command docker exec -it <container name> /bin/bash to get a bash shell in the container, i.e. docker exec -it flogo-studio /bin/bash
- navigate to dbservice logs folder where the logs dbs.err and dbs.log are stored. For example, /usr/flogo/services/dbservice/logs
What is more, a Web API request can be invoked for checking on the status of dbservice,
i.e.
$ curl http://<FlogoStudio_Web_URL>/dbservicego/api/v2/greetings
It should return like below:
{ "greetings": "Hello from DBService", "version" : "3.0", "databases" : "PostgresSQL, AmazonRedshift, SQLServer, MySQL, MSSQLServer, Snowflake" }
Issue/Introduction
How to get Flogo Connector DBService logs
Environment
All supported platforms
Additional Information
Flogo DBService, Flogo connector
Feedback
Yes
No
Powered by
