# QAN MySQL Slowlog Agent status UNKNOWN **URL:** \ **Category:** Database Monitoring and Management\ **Created:** [May 6, 2023, 10:07am UTC](https://forums.percona.com/t/qan-mysql-slowlog-agent-status-unknown/21903 "2023-05-06T10:07:15Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Fandi\_Ivon](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/fandi_ivon/32/10479_2.png) [@Fandi\_Ivon](https://forums.percona.com/u/Fandi_Ivon)\ **Post date:** [May 6, 2023, 10:07am UTC](https://forums.percona.com/t/qan-mysql-slowlog-agent-status-unknown/21903/1 "2023-05-06T10:07:15Z")
Hi, I have installed PMM Server and register client succesfully. Through the percona web UI and from command line, looks like all is running well except Slowlog Agent state is UNKNOWN. ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/a/a92c1aa4f342449e8df585131a0e694bea203bcc.png) PMM Server : Docker , version 2.36 PMM Client : Self Host Ubuntu 18.04 Database : MariaDB 10.1.48 Appreciate any suggest for troubleshoot it. ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [May 8, 2023, 2:46pm UTC](https://forums.percona.com/t/qan-mysql-slowlog-agent-status-unknown/21903/2 "2023-05-08T14:46:49Z")
@Fandi_Ivon, Please provide the exact commands you used to configure the command-line client. Also, have you enabled the slow query log in MariaDB? ---
**Author:** ![Fandi\_Ivon](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/fandi_ivon/32/10479_2.png) [@Fandi\_Ivon](https://forums.percona.com/u/Fandi_Ivon)\ **Post date:** [May 9, 2023, 7:19am UTC](https://forums.percona.com/t/qan-mysql-slowlog-agent-status-unknown/21903/3 "2023-05-09T07:19:17Z")
Hi @matthewb , Thanks for response. I have follow this guidance > **[Percona Monitoring and Management](https://docs.percona.com/percona-monitoring-and-management/setting-up/client/mysql.html#on-the-command-line)** > > Documentation 1. Slow Log ON 2. Below is my exact command to connect QAN Agent pmm-admin add mysql --query-source=slowlog --size-slow-logs=1GiB --username=user --password=password PPID 192.168.33.138:3306 Is there any step that I missed ? ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [May 9, 2023, 1:00pm UTC](https://forums.percona.com/t/qan-mysql-slowlog-agent-status-unknown/21903/4 "2023-05-09T13:00:04Z")
That looks correct. What about `long_query_time` MySQL parameter? Can you `tail -f /var/log/mysql/mariadb-slow.log` and see new queries being added? ---
**Author:** ![Fandi\_Ivon](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/fandi_ivon/32/10479_2.png) [@Fandi\_Ivon](https://forums.percona.com/u/Fandi_Ivon)\ **Post date:** [May 9, 2023, 2:07pm UTC](https://forums.percona.com/t/qan-mysql-slowlog-agent-status-unknown/21903/5 "2023-05-09T14:07:55Z")
1. Variable long\_query\_time = 0 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/7/724b20bb630c1b45562b80c1bb49df1e62b3077b.png) 2. `tail -f /var/log/mysql/mariadb-slow.log` output is empty. I try cat command also empty. ---
**Author:** ![Fandi\_Ivon](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/fandi_ivon/32/10479_2.png) [@Fandi\_Ivon](https://forums.percona.com/u/Fandi_Ivon)\ **Post date:** [May 9, 2023, 2:27pm UTC](https://forums.percona.com/t/qan-mysql-slowlog-agent-status-unknown/21903/6 "2023-05-09T14:27:53Z")
After restart mysql service, now here is output from tail command ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/c/c767ca6666c030590c85d6aceba4e096cbfd181b.png) Slowlog Agent status still UNKNOWN ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [May 9, 2023, 2:45pm UTC](https://forums.percona.com/t/qan-mysql-slowlog-agent-status-unknown/21903/7 "2023-05-09T14:45:38Z")
Are you seeing queries in PMM now? Have you looked at permissions between the user running pmm-agent vs the slow query log? ---
**Author:** ![Fandi\_Ivon](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/fandi_ivon/32/10479_2.png) [@Fandi\_Ivon](https://forums.percona.com/u/Fandi_Ivon)\ **Post date:** [May 9, 2023, 2:57pm UTC](https://forums.percona.com/t/qan-mysql-slowlog-agent-status-unknown/21903/8 "2023-05-09T14:57:53Z")
I didn’t see queries in PMM. Not even my registered node appear in QAN menu yet. What command to see permissions between the user running pmm-agent vs the slow query log? ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [May 9, 2023, 4:41pm UTC](https://forums.percona.com/t/qan-mysql-slowlog-agent-status-unknown/21903/9 "2023-05-09T16:41:24Z")
`ps` and `ls` are typically used to look at permissions of running processes and files.