Mysql database monitoring

Elastic Observability Metrics
1

colleagues to be able to monitor a database which are the permissions that the user must have. and which table is the one that should have these permissions in my SQL

2

Hi @jonsacri,

it seems like you're asking for advice about monitoring of some unspecified RDBMS. Could you please clarify your deployment scenario and your specific question?

3

It is correct what I am looking for is to monitor different databases in my sql but when activating the component the connection is wrong by Go

4

So you're trying to monitor a MySQL database server but have trouble connecting to it, right? In order for community members to help you a few more pieces of information might be helpful:

  • What monitoring agent are you trying to use? Filebeat or Metricbeat with the MySQL module? Or some other agent?
  • What are the versions and configurations involved?
  • What error do you specifically see when trying to connect?
5

I use metricbeat 9.0 with the mssql module

  • module: mssql

    metricsets:

    • "transaction_log"

    • "performance"

    hosts: ["sqlserver://user:pass@ip host:port "]

    period: 1m

I need to declare the instance how could I do it

sqlserver://127.0.0.1:1433;databaseName=MyDatabase ?

Thank you

6

:thinking: In your posts you were talking about MySQL, but your config snippet uses the mssql module. Which one is it?

7

If you are right I am using the mssql module, would you recommend using the sql one? Could you help me how the configuration would be? I thank you so

8

to clarify the database is in a SQL server not in my sql

9

If you're trying to monitor the Microsoft SQL Server, mssql looks like the right module. I'm wondering where you're taking the version 9.0 of Metricbeat from since the latest released version is 7.12.

If you're trying to log in as a native user, a string like sqlserver://user:pass@127.0.0.1:1433;databaseName=MyDatabase should work, but for AD users you'd have to use separate username and password config keys or store them in the secrets keystore (see the module-specific notes).

Could you tell us which error Metricbeat is logging when unsuccessfully trying to connect to the SQL server?

10

Exiting: 2 errors: host parsing failed for mssql-transaction_log: error parsing URL: parse "sqlserver://User:Pass
@host:port;databaseName=pocoyo": invalid port ":####;databaseName=pocoyo" after host; host parsing fai
led for mssql-performance: error parsing URL: parse "sqlserver://user:pass@host:port;databaseNam
e=pocoyo": invalid port ":####;databaseName=pocoyo" after host

Welcome to Metricbeat 7.9.0

11

Looking at the implementation of the underlying go-mssqldb library it seems the sqlserver url-style string expects the database name as a query parameter after the ?:

sqlserver://user:pass@localhost:1234?database=mydatabase

Does that work?

12

perfect thank you. one more favor could you please if you can collaborate with this problem and apply your wise knowledge

URl

13

Would you like to clarify something for the database user what permissions he must have in addition to these
VIEW SERVER STATE and VIEW DATABASE STATE

thanks

14

Sorry, I barely know anything about MSSQL. I'd recommend reading the MSSQL documentation or asking your support contact at Microsoft.

15

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.