I already installed this module, but the error persists.
It is installed.
I believe the problem is that the plugin is being built using a newer version. It's getting cached.
Good afternoon people!!
I have the correct version (3.6), I also have all these libraries installed.
Also, I installed oracle client on the server.
I can connect to the database if I access python directly from the prompt, making an import in cx_Oracle.
I understand that the error is in my code.
import logging
import cx_Oracle
import os
from ruxit.api.base_plugin import RemoteBasePlugin
logger = logging.getLogger(__name__)
class IntegracaoInternaCC(RemoteBasePlugin):
def query(self, **kwargs):
global con, total_lancamentos_export_jsm, state_integracao_interna_cc
state_integracao_interna_cc = 0.0
status_ok = "OK"
status_notok = "Bad"
try:
con = cx_Oracle.connect(user="", password="", dsn="")
cursor = con.cursor()
print("Successfully connected to Oracle Database")
consulta_sql = "select count(1) from cc_qcc_lanc_export_jms s where state <> 3;"
cursor.execute(consulta_sql)
resultado_query = (cursor.fetchall())
for linha in resultado_query:
total_lancamentos_export_jsm = (linha[0])
print("Total Registros", total_lancamentos_export_jsm)
if total_lancamentos_export_jsm == 0:
state_integracao_interna_cc = status_ok
print("Status:", state_integracao_interna_cc)
else:
state_integracao_interna_cc = status_notok
print("Status:", state_integracao_interna_cc)
group = self.topology_builder.create_group("Filas AQ", "Filas AQ")
device = group.create_element("Integração Conta Corrente", "Integração Conta Corrente")
group.report_property(key="Desenvolvedor", value="Rodrigo Biaggio")
group.report_property(key="Secondary technology", value="Oracle")
group.report_property(key="Integrações", value="AWS")
group.report_property(key="Descrição", value="Filas Oracle AQ - Conta e Standin")
device.report_property(key="Integrações", value="AWS")
device.report_property(key="Technology", value="Python")
device.add_endpoint(ip="", port=3306, dnsNames=[""])
device.relative(key='total_lancamentos_export_jsm', value=total_lancamentos_export_jsm)
group.absolute(key='total_lancamentos_export_jsm', value=total_lancamentos_export_jsm)
device.state_metric(key='state_integracao_interna_cc', value=state_integracao_interna_cc)
except cx_Oracle.DatabaseError as e:
print("Erro ao acessar tabela", e)
finally:
con.close()
print("Conexão ao banco encerrada")
I'm still trying to get the plugin to work.
I've already run simulate_plugin and it works. The problem occurs when deploying to Dynatrace.
At first, it was returning a message that the cx_Oracle module did not exist. I redid all the installation of gateway, SDK and Oracle client. Now, even though everything works fine inside the OS, when I deploy, it returns a message that the Oracle LIB was not found.
I put in my code to return the Oracle environment variables and also the LD_LIBRARY_PATH and the return is none, that is, it is not finding the variable.
SIMULATE_PLUGIN OK
ERROR
What is causing me confusion is the fact that my user has the variables, and dtuserag is not a user with bash, it doesn't login.
Which user does Dynatrace use, root or
the dtuserag? These variables must be defined for which users?
Thank you
@Mike_L ,
Hi, thanks for your reply.
I put all these two ways in, but it didn't work.
I also stopped / started the process
Is that correct, is it either of these two ways?
I did a test by changing the user from dtuserag to root. I restarted the Dynatrace service and it didn't reflect. In my code it still points out that the plugin is running with dtuserag.
