# MySQL Query Analytics configuration not found

**URL:** <https://forums.percona.com/t/mysql-query-analytics-configuration-not-found/5007>\
**Category:** PMM 1.x\
**Created:** [July 29, 2016, 4:24am UTC](https://forums.percona.com/t/mysql-query-analytics-configuration-not-found/5007 "2016-07-29T04:24:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![permyakovsv](https://avatars.discourse-cdn.com/v4/letter/p/7bcc69/32.png) [@permyakovsv](https://forums.percona.com/u/permyakovsv)\
**Post date:** [July 29, 2016, 4:24am UTC](https://forums.percona.com/t/mysql-query-analytics-configuration-not-found/5007/1 "2016-07-29T04:24:45Z")

</div>

Hi, all.  
I’ve started queries:  
pmm-admin list  
queries host 42001 YES root:_**@unix(/var/lib/mysql/mysql.sock) query\_source=slowlog  
mysql host 42002-42004 YES root:**_@unix(/var/lib/mysql/mysql.sock)

But in QueryAnalytics I don’t see any queries, instead, I see message:

QAN API error: “MySQL Query Analytics configuration not found”.  
Check the /var/log/qan-api.log file in docker container for more information.

But:  
docker exec 1af5acecd98b cat /var/log/qan-api.log  
Percona Query Analytics API is running…  
2016/07/29 08:50:34 config.go:79: Loading /usr/local/percona/qan-api/src/github.com/percona/qan-api/conf/prod.conf  
2016/07/29 08:50:34 config.go:119: API root dir /usr/local/percona/qan-api/src/github.com/percona/qan-api  
INFO 2016/07/29 08:50:34 revel.go:206: Initialized Revel v0.12.0dev (2015-01-19) for \>= go1.3  
INFO 2016/07/29 08:50:34 main.go:31: Running revel server  
Listening on 0.0.0.0:9001…  
INFO 2016/07/29 09:30:28 ws.go:107: [Agent.Cmd] agent\_id=2 0.0.9 [http://host](http://host): connected

What did I wrong?

---

<div class="post-metadata">

**Author:** ![weber](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@weber](https://forums.percona.com/u/weber)\
**Post date:** [August 1, 2016, 7:20am UTC](https://forums.percona.com/t/mysql-query-analytics-configuration-not-found/5007/2 "2016-08-01T07:20:59Z")

</div>

Check out /var/log/pmm-queries-exporter-42001.log on the client side. And try to remove queries from monitoring and re-add.

---

<div class="post-metadata">

**Author:** ![pankaj](https://avatars.discourse-cdn.com/v4/letter/p/a9adbd/32.png) [@pankaj](https://forums.percona.com/u/pankaj)\
**Post date:** [August 2, 2016, 8:12am UTC](https://forums.percona.com/t/mysql-query-analytics-configuration-not-found/5007/3 "2016-08-02T08:12:36Z")

</div>

Hii,

I am also facing the same issue, and I checked the file “pmm-queries-exporter-42001.log” and it has following entries:

flag needs an argument: -pid-file  
Usage of /usr/local/percona/qan-agent/bin/percona-qan-agent:  
-basedir string  
Agent basedir (default “/usr/local/percona/qan-agent”)  
-listen string  
Agent interface address (default “127.0.0.1:9000”)  
-pid-file string  
PID file (default “percona-agent.pid”)  
-ping  
Ping API  
-version  
Print version

I am not sure what to make out of these errors? I used the command “sudo pmm-admin add queries --user abc --password def” . Please help me solve this.

Thanks

---

<div class="post-metadata">

**Author:** ![weber](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@weber](https://forums.percona.com/u/weber)\
**Post date:** [August 5, 2016, 6:03am UTC](https://forums.percona.com/t/mysql-query-analytics-configuration-not-found/5007/4 "2016-08-05T06:03:30Z")

</div>

There is a bug in 1.0.2 for “queries” when using unix-systemv service manager.

To fix:

- run: pmm-admin remove queries NAME
- grab [https://www.percona.com/redir/downlo](https://www.percona.com/redir/downlo)…-x86\_64.tar.gz
- copy new pmm-admin from that tarball: cp bin/pmm-admin /usr/local/percona/pmm-client/
- pmm-admin add queries …