During the verification of remote MySQL server i got these warning message
"
PDO::query(): MySQL server has gone away pdo.php:52

PDO::query(): Error reading result set's header pdo.php:52
"
What is the solotion of this?

Please help me.

CommentFileSizeAuthor
Verify Server.png34.73 KBabhinand gokhala k

Comments

Abhinand Gokhala K created an issue. See original summary.

colan’s picture

colan
he/him
Primary language English
Location Toronto 🇨🇦
commented

Looks like a problem with your MySQL instance, which falls outside of Aegir's scope.

How did you install Aegir? With the Debian package?

abhinand gokhala k’s picture

abhinand gokhala k commented

yes, I have installed Aegir using Debian package in my master server then I tried to add Remote MySQL server.

abhinand gokhala k’s picture

abhinand gokhala k commented

Its right, its not the problem of Aegir. I have 2 remote server one has global IP. MySQL server verification 'Success' with the server which has Global IP but I got above warning message with the server which has no Global IP.

helmo’s picture

helmo commented
Status: Active » Closed (works as designed)

Please test if you can start an sql connection from the master server to the slave using the Server hostname you provided for the slave.

Feel free to re-open if there's anything more we can do.