# PMM QAN - can't add mysql:queries **URL:** \ **Category:** PMM 1.x\ **Created:** [October 20, 2017, 12:26am UTC](https://forums.percona.com/t/pmm-qan-cant-add-mysql-queries/5948 "2017-10-20T00:26:46Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![golenkovm](https://avatars.discourse-cdn.com/v4/letter/g/cab0a1/32.png) [@golenkovm](https://forums.percona.com/u/golenkovm)\ **Post date:** [October 20, 2017, 12:26am UTC](https://forums.percona.com/t/pmm-qan-cant-add-mysql-queries/5948/1 "2017-10-20T00:26:46Z")
Hello, Installing pmm-client on new servers. linux:metrics and mysql:metrics have been added successfully. While adding mysql:queries I receive an error: [root@0913lbmysql01 /]# pmm-admin add mysql:queries --query-source perfschema Error adding MySQL queries: problem with agent registration on QAN API: exit status 1 Repair doesn’t help: [root@0913lbmysql01 /]# pmm-admin repair No orphaned services found. PMM list: [root@0913lbmysql01 /]# pmm-admin list pmm-admin 1.3.2 PMM Server | 10.147.x.x (password-protected) Client Name | 0913lbmysql01 Client Address | 10.149.x.x Service Manager | unix-systemv * * * SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS * * * linux:metrics 0913lbmysql01 42000 YES - mysql:metrics 0913lbmysql01 42002 YES pmm:\*\*\*@unix(/opt/mysql/mysql.sock) tablestats=OFF Network-check: [root@0913lbmysql01 /]# pmm-admin check-network PMM Network Status Server Address | 10.147.x.x Client Address | 10.149.x.x - System Time PMM Server | 2017-10-20 05:47:57 +0000 GMT PMM Client | 2017-10-20 13:48:59 +0800 IRKT PMM Client to PMM Server Time Drift | 62s Time is out of sync. Please make sure the server time is correct to see the metrics. - Connection: Client → Server * * * SERVER SERVICE STATUS * * * Consul API OK Prometheus API OK Query Analytics API DOWN Connection duration | 47.348766ms Request duration | 48.225644ms Full round trip | 95.57441ms - Connection: Client ← Server * * * SERVICE TYPE NAME REMOTE ENDPOINT STATUS HTTPS/TLS PASSWORD * * * linux:metrics 0913lbmysql01 10.149.x.x:42000 OK YES YES mysql:metrics 0913lbmysql01 10.149.x.x:42002 OK YES YES From the Prometheus side: [TABLE] [TR] [TD][URL=“[https://10.149.138.11:42000/metrics](https://10.149.138.11:42000/metrics)”][https://10.149.x.x:42000/metrics[/URL][/TD]](https://10.149.x.x:42000/metrics%5B/URL%5D%5B/TD%5D) [TD]UP[/TD] [/TR] [/TABLE] [TABLE] [TR] [TD][URL=“[https://10.149.138.11:42002/metrics-hr](https://10.149.138.11:42002/metrics-hr)”][https://10.149.x.x:42002/metrics-hr[/URL][/TD]](https://10.149.x.x:42002/metrics-hr%5B/URL%5D%5B/TD%5D) [TD]UP[/TD] [/TR] [/TABLE] [TABLE] [TR] [TD][URL=“[https://10.149.138.11:42002/metrics-mr](https://10.149.138.11:42002/metrics-mr)”][https://10.149.x.x:42002/metrics-mr[/URL][/TD]](https://10.149.x.x:42002/metrics-mr%5B/URL%5D%5B/TD%5D) [TD]UP[/TD] [/TR] [/TABLE] [TABLE] [TR] [TD][URL=“[https://10.149.138.11:42002/metrics-lr](https://10.149.138.11:42002/metrics-lr)”][https://10.149.x.x:42002/metrics-lr[/URL][/TD]](https://10.149.x.x:42002/metrics-lr%5B/URL%5D%5B/TD%5D) [TD]UP[/TD] [/TR] [/TABLE] PMM version: [root@0913lbmysql01 /]# rpm -qa | grep -i pmm pmm-client-1.3.2-1.x86\_64 Linux and mysql metrics work fine. But QAN doesn’t. How to fix this issue and add mysql:queries? Regards, Mikhail Golenkov ---
**Author:** ![golenkovm](https://avatars.discourse-cdn.com/v4/letter/g/cab0a1/32.png) [@golenkovm](https://forums.percona.com/u/golenkovm)\ **Post date:** [October 24, 2017, 10:04pm UTC](https://forums.percona.com/t/pmm-qan-cant-add-mysql-queries/5948/2 "2017-10-24T22:04:49Z")
I guess that the problem originates from PMM-Server. All my PMM-Clients have the same error - problem with agent registration on QAN API: exit status 1. Version of PMM-Server is 1.3.2. PMM-Server has been installed as a virtual appliance. OVA file downloaded from [url][https://www.percona.com/redir/downloads/TESTING/pmm/pmm-server-1.3.2.ova[/url]](https://www.percona.com/redir/downloads/TESTING/pmm/pmm-server-1.3.2.ova%5B/url%5D) In addition, I could not find login and password in order to connect to PMM-Server. Is it possible to get an OS access to PMM-Server? ---
**Author:** ![alexey.palazhchenko](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/alexey.palazhchenko/32/35_2.png) [@alexey.palazhchenko](https://forums.percona.com/u/alexey.palazhchenko)\ **Post date:** [October 25, 2017, 12:11am UTC](https://forums.percona.com/t/pmm-qan-cant-add-mysql-queries/5948/3 "2017-10-25T00:11:06Z")
> [@](#): > > PMM Client to PMM Server Time Drift | 62s > Time is out of sync. Please make sure the server time is correct to see the metrics. That can be a source of the problem.