Run "show slave status" with PHP PDO

Question

I am trying to get the slave status of my MySQL server using PHP's PDO implementation. Running fetchAll() returns an empty array.

// DB IP, name, username, and password are fake here. I can connect.
$db = new PDO('mysql:host=192.168.0.0;dbname=production', 'username', 'password');
$result = $db->query("SHOW SLAVE STATUS");
$result->execute();

if ($result != false)
{
    $slave = $result->fetchAll(PDO::FETCH_ASSOC);
}

I have also tried removing the ->execute() call, but it's the same result. Is there something completely obvious that I'm missing here? I've looked up and down the PDO::query documentation and it's not helping much.

Is your server's IP really `192.168.0.0`? Although, I guess you would have seen an exception when connecting if this is where the problem was. — Brad, Jul 16 '12 at 18:20

score 5 · Accepted Answer · answered Jul 16 '12 at 18:29

5

Do you have permission to execute the query?

Try:

$db = new PDO('mysql:host=192.168.0.0;dbname=production', 'username', 'password');

$result = $db->query("SHOW STATUS");

if (!$result) {
    echo $db->errorInfo()[2]; // php 5.4
} else {
    foreach($result->fetchAll() as $row) {
        var_dump($row);
    }
}

answered Jul 16 '12 at 18:29

drew010

68,777
11
134
162

Yeah, that was exactly the problem. My replication user was not setup properly. I'll accept your answer once the 3 minute limit thing is gone. Cheers! – Andrew Ellis Jul 16 '12 at 18:30
2

Ah I see you found it out about the same time I did, I tested it on my system and got the error about insufficient privileges so was figuring we had the same problem. – drew010 Jul 16 '12 at 18:33

score 1 · Answer 2 · edited Feb 15 '13 at 23:30

1

This was actually due to a permission's issue on the server. I incorrectly setup my replication user so replication itself wasn't even working.

edited Feb 15 '13 at 23:30

Brian Webster

30,033
48
152
225

answered Jul 16 '12 at 18:27

Andrew Ellis

1,175
1
12
29

Run "show slave status" with PHP PDO

2 Answers2