topic Re: Error(No module named 'mysql') in Extensions

Help needed for error: no module named 'mysql'

RodrigoBiaggio — Thu, 18 May 2023 12:00:05 GMT

Could anyone help me with this error?

import mysql.connector
from mysql.connector import Error
import requests
from ruxit.api.base_plugin import RemoteBasePlugin
import logging

class PluginDBQuerySQL(RemoteBasePlugin):
    def initialize(self, **kwargs):
        logger.info("Config: %s", self.config)
        self.url = self.config["url"]

try:
    con = mysql.connector.connect(host='localhost', database='database', user='biaggio', password='')

    consulta_sql = "select * from database.tb_activegate"
    cursor = con.cursor()
    cursor.execute(consulta_sql)
    linhas = cursor.fetchall()
    totalLinhas = cursor.rowcount

    def query(self, **kwargs😞
        #Create topology
        url = self.url + "/topology"
        topology = requests.get(url).json()
        for group_t in topology:
            group_name = group_t['name']
            group = self.topology_builder.create_group(group_name, group_name)
            for device_t in group_t['devices']:
                device_name = device_t['name']
                device = group.create_device(device_name, device_name)
                logger.info("Topology: group name=%s, device name=%s", group.name, device.name)
                #Collect stats
                stats = device_t['stats']
                device.absolute(key='totalLinhas', value=stats['counter'])

except Error as e:
    print("Erro ao acessar tabela", e)
finally:
    if (con.is_connected()):
        con.close()
        cursor.close()
        print("Conexao fechada")

Re: Error(No module named 'mysql')

Mike_L — Fri, 01 Oct 2021 15:55:04 GMT

How does the install_requires look like in the plugin.json and are you building the extension with oneagent_build_plugin?

Mike

Re: Error(No module named 'mysql')

RodrigoBiaggio — Fri, 01 Oct 2021 17:14:28 GMT

Hi @Mike_L

I put the:

"install_requires": [
    "mysql-connector"
  ]

Now it's OK for mysql, but now it returns the message to the logger module.

I'm making the plugin with the activegate SDK

Re: Error(No module named 'mysql')

Mike_L — Mon, 04 Oct 2021 11:02:01 GMT

You never initiated a variable that you're using in your script. Did you mean to add

logger = logging.getLogger(__name__)

maybe?

Re: Help needed for error: no module named 'mysql'

Peter_Youssef — Tue, 17 Sep 2024 11:59:10 GMT

Hi @RodrigoBiaggio

In simple steps:

stop the activegate service.
configure the required module.
restart the activegate

Re: Help needed for error: no module named 'mysql'

Peter_Youssef — Tue, 17 Sep 2024 12:00:39 GMT

Refer to Dynatrace URL: activegate Purposes

Re: Help needed for error: no module named 'mysql'

Peter_Youssef — Tue, 17 Sep 2024 12:01:58 GMT

Hi @RodrigoBiaggio

Kindly check: configure activegate modules

Thanks

Re: Help needed for error: no module named 'mysql'

Peter_Youssef — Tue, 17 Sep 2024 12:08:02 GMT

Hello @RodrigoBiaggio

open cutom.properties file
create a section called Section: [mysql_monitoring]
configure a new property called mysql_monitoring_enabled=true
ensure extension execution controller is enabled.
don't configure it through config.properties file, it's overwritten during AG Update.