Course: Elastic Observability Engineer 7.9 (On-Demand)
Version: <And which particular version?>
Question: Elastic Observability Lab 2.2 Error
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 GitHub - go-sql-driver/mysql: Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package.
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?
I have looked at the processes also:
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
Seem ok to me.
Regards,
Amit