Issue on Lab 2.2

Hello. I have this in the myql yaml:

Module: mysql

Docs: MySQL module | Metricbeat Reference [7.9] | Elastic

  • module: mysql
    metricsets:

    • status

    - galera_status

    - performance

    - query

    period: 10s

    Host DSN should be defined as "user:pass@tcp(127.0.0.1:3306)/"

    or "unix(/var/lib/mysql/mysql.sock)/",

    or another DSN format supported by https://github.com/Go-SQL-Driver/MySQL/.

    The username and password can either be set in the DSN or using the username

    and password config options. Those specified in the DSN take precedence.

    #hosts: ["root:secret@tcp(127.0.0.1:3306)/"]
    hosts: ["root:petclinic@tcp(mysql:3306)/"]

    Username of hosts. Empty by default.

    username: root

    Password of hosts. Empty by default.

    #password: secret
    password: petclinic

But I get this error when testing:

[elastic@mysql metricbeat]$ ./metricbeat test modules mysql
Error getting metricbeat modules: error loading config files: invalid config: yaml: line 17: did not find expected '-' indicator

Can anyone help please?

Hi All,

Here are all the processes. Does this help?

[elastic@mysql metricbeat]$ ps -eaf
UID PID PPID C STIME TTY TIME CMD
root 1 0 0 13:43 pts/0 00:00:00 /bin/bash /root/startup.sh
root 11 1 0 13:43 ? 00:00:00 /usr/bin/python /usr/bin/supervisord -c /etc/supervisor/supervisord.conf
root 18 1 0 13:43 ? 00:00:00 /usr/bin/python /usr/bin/supervisord -c /etc/supervisor/supervisord.conf
mysql 36 1 0 13:43 pts/0 00:00:11 mysqld --init-file=/tmp/init.sql
root 38 1 0 13:43 pts/0 00:00:00 /bin/bash /root/start-scripts/99-bash.sh
root 39 38 0 13:43 pts/0 00:00:00 bash -l
root 86 1 0 13:43 ? 00:00:00 /sbin/sshd
root 330 86 0 14:05 ? 00:00:00 sshd: elastic [priv]
elastic 332 330 0 14:05 ? 00:00:00 sshd: elastic@pts/1
elastic 333 332 0 14:05 pts/1 00:00:00 -bash
elastic 1192 333 0 15:02 pts/1 00:00:00 ps -eaf