I'm trying to connect to an Azure SQL database from WP Data tables separate connections. I am getting the following errors. Also, I have going through the documentation and enabled the ip address of my site in the azure sql server firewall settings. Any other suggestions on things to try would be helpful.
The MySQL server has gone away (error 2006) has two main causes and solutions:
Server timed out and closed the connection. To fix, check that wait_timeout mysql variable in your my.cnf configuration file is large enough, eg wait_timeout = 28800
You may also need to increase the innodb_log_file_size mysql variable in your my.cnf configuration to for example innodb_log_file_size = 128MB or higher.
Server dropped an incorrect or too large packet. If mysqld gets a packet that is too large or incorrect, it assumes that something has gone wrong with the client and closes the connection. To fix, you can increase the maximal packet size limit max_allowed_packet in my.cnf file, eg. set max_allowed_packet = 128M, then restart your MySQL server: sudo /etc/init.d/mysql restart
Once you’ve made these changes, and restarted your MySQL or MariaDB server, the issue should be fixed and no more error triggered. If not, try increase the 128M values to 256M for example.
Can I connect to an Azure SQL server without installing the driver? WP engine doesn't allow driver installs. After spinning up a Azure MySQL Database i'm using the following parameters and getting the following error. Host: mydatabasename.mysql.database.azure.com Name: NameofMyAzureSQLDatabase
I figured out how to connect to Azure MySql. Please refer other wpTableUsers to my post if you they are using azure mysql. From the server information blade. Copy to following values into wpDataTable settings.
Hello,
I'm trying to connect to an Azure SQL database from WP Data tables separate connections. I am getting the following errors. Also, I have going through the documentation and enabled the ip address of my site in the azure sql server firewall settings. Any other suggestions on things to try would be helpful.
Hello jeffrey
Thank you for your purchase.
The MySQL server has gone away (error 2006) has two main causes and solutions:
Once you’ve made these changes, and restarted your MySQL or MariaDB server, the issue should be fixed and no more error triggered. If not, try increase the 128M values to 256M for example.
You can also check this thread.
Please let me know if that helps.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Can I connect to an Azure SQL server without installing the driver? WP engine doesn't allow driver installs. After spinning up a Azure MySQL Database i'm using the following parameters and getting the following error.
Host: mydatabasename.mysql.database.azure.com
Name: NameofMyAzureSQLDatabase
I figured out how to connect to Azure MySql. Please refer other wpTableUsers to my post if you they are using azure mysql. From the server information blade. Copy to following values into wpDataTable settings.
Hi again Jeffrey
Good news, thank you for letting us know. I will save your reply in case anyone else has issues connecting to Azure MySQL.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables