# pt-table-checksum : Cannot connect to slave

**URL:** <https://forums.percona.com/t/pt-table-checksum-cannot-connect-to-slave/2602>\
**Category:** Percona Toolkit\
**Created:** [January 15, 2013, 9:19am UTC](https://forums.percona.com/t/pt-table-checksum-cannot-connect-to-slave/2602 "2013-01-15T09:19:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![KoHead](https://avatars.discourse-cdn.com/v4/letter/k/e36b37/32.png) [@KoHead](https://forums.percona.com/u/KoHead)\
**Post date:** [January 15, 2013, 9:19am UTC](https://forums.percona.com/t/pt-table-checksum-cannot-connect-to-slave/2602/1 "2013-01-15T09:19:13Z")

</div>

Hi all,

I have a problem today with pt-table-checksum.

When i do pt-table-checksum on my master server, i see the following message :

Cannot connect to h=server\_slave\_hostname.com

So, pt-table-checksum can’t to do his job !

I use the user root for the connection (with no password)

I must create a user for pt-table-checksum ?

---

<div class="post-metadata">

**Author:** ![KoHead](https://avatars.discourse-cdn.com/v4/letter/k/e36b37/32.png) [@KoHead](https://forums.percona.com/u/KoHead)\
**Post date:** [January 15, 2013, 10:43am UTC](https://forums.percona.com/t/pt-table-checksum-cannot-connect-to-slave/2602/2 "2013-01-15T10:43:56Z")

</div>

re,

I create a specific user on the master AND the slave

Slave :  
GRANT ALL PRIVILEGES ON _._ TO ‘percona\_user’@‘master\_host\_ip’ IDENTIFIED BY ‘PASSWD’;"

Master :  
GRANT ALL PRIVILEGES ON _._ TO ‘percona\_user’@‘localhost’ IDENTIFIED BY ‘PASSWD’;"

But i have now a other error :

pt-table-checksum --databases=test\_stats\_admin\_2013 --user=percona\_user --password=MyPass  
Cannot connect to h=slave1._**.com,p=…,u=percona\_user  
Cannot connect to h=slave2.**_.com,p=…,u=percona\_user  
Cannot connect to h=slave3._**.com,p=…,u=percona\_user  
Cannot connect to h=slave4.**_.com,p=…,u=percona\_user  
Cannot connect to h=slave5.\*\*\*.com,p=…,u=percona\_user  
01-15T17:11:27 Replication filters are set on these hosts:  
slave1  
binlog\_do\_db = listing of databases name  
slave\_skip\_errors = ALL  
replicate\_ignore\_db = mysql  
replicate\_do\_db = listing databases name

Please read the --check-replication-filters documentation to learn how to solve this problem. at /usr/bin/pt-table-checksum line 8951.

---

<div class="post-metadata">

**Author:** ![KoHead](https://avatars.discourse-cdn.com/v4/letter/k/e36b37/32.png) [@KoHead](https://forums.percona.com/u/KoHead)\
**Post date:** [January 16, 2013, 2:22am UTC](https://forums.percona.com/t/pt-table-checksum-cannot-connect-to-slave/2602/3 "2013-01-16T02:22:24Z")

</div>

Re.

Ok i understand for check-replication-filter. Endeed, i have any replication filter on my databases. But it’s not a problem for me so i will to use --nocheck-replication-filters ( Of course, i filter the databases on which I applied the checksum).

Come back to the “cannot connecter to h=slaveN” problem.  
I am sure now that i must create a user for percona. But what are the rights that would specifically need ?

Thank’s

---

<div class="post-metadata">

**Author:** ![kubilay](https://avatars.discourse-cdn.com/v4/letter/k/0ea827/32.png) [@kubilay](https://forums.percona.com/u/kubilay)\
**Post date:** [February 19, 2014, 5:46am UTC](https://forums.percona.com/t/pt-table-checksum-cannot-connect-to-slave/2602/4 "2014-02-19T05:46:40Z")

</div>

I do get the same problem message saying ‘Cannot connect to h=themachine…’ but when checking the checksums table on the machine it cannot connect I see that it must have connected and run… the ‘ts’ field in the table gets updated.

Is there a way to debug this and see in verbose mode where is trying to connect whith which user?

Thanks!

Kubilay

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [February 19, 2014, 2:47pm UTC](https://forums.percona.com/t/pt-table-checksum-cannot-connect-to-slave/2602/5 "2014-02-19T14:47:44Z")

</div>

Running any of the tool from [percona-toolkit](http://www.percona.com/software/percona-toolkit) along PTDEBUG=1 generate verbose logging.  
For pt-table-checksum privileges check this [url][https://blueprints.launchpad.net/percona-toolkit/+spec/document-pt-table-checksum-privs[/url]](https://blueprints.launchpad.net/percona-toolkit/+spec/document-pt-table-checksum-privs%5B/url%5D)
