During Install: [Got a packet bigger than ‘max_allowed_packet’ bytes]

Please do not post large code or responses like that here, it doesn’t work after ~10 lines or so.

If you need share that data please use https://gist.github.com/ or https://pastebin.com/ instead and post the link to that paste.

I had WordPress installed on my Synology NAS, but was having an issue with the upload limitation of 32M. I tried making the changes under Core in the PHP 7.3 and 7.4 profile without success. I uninstalled/resintalled everything (WordPress, trying both PHP 7.3 and 7.4, Apache 2.2 and 2.4, and MariaDB10) a couple of times between making changes, with no success. Then at some point, not sure exactly what caused this, I get this just as the install finishes. At the very bottom it indicates that WordPress was installed, which it appears to have been. But I cannot login (The password you entered for the username is incorrect.). I am entering the correct username and password – it’s a direct copy/paste from the install. I’ve also confirmed that the username and password are correct through the wp-config.php file and in MariaDB10 -> phpMyAdmin.

I tried editing my.cnf (using sudo -i)
/var/packages/MariaDB10/etc
vi my.cnf

[mysqld]
max_allowed_packet = 1073741824
:wq

I changed it to 4294967296, thinking 512MB should be plenty for this value. But it did not make a difference. Can anyone decipher this mumbo-jumbo to help me get this figured out?

Please do not post large code or responses like that here, it doesn’t work after ~10 lines or so.

If you need share that data please use https://gist.github.com/ or https://pastebin.com/ instead and post the link to that paste.

I had thought about that when I actually saw how large the post was. Sorry about that. If it makes sense, please modify the original post to reflect this correction:

I had WordPress installed on my Synology NAS, but was having an issue with the upload limitation of 32M. I tried making the changes under Core in the PHP 7.3 and 7.4 profile without success. I uninstalled/resintalled everything (WordPress, trying both PHP 7.3 and 7.4, Apache 2.2 and 2.4, and MariaDB10) a couple of times between making changes, with no success. Then at some point, not sure exactly what caused this, I get this just as the install finishes. At the very bottom it indicates that WordPress was installed, which it appears to have been. But I cannot login (The password you entered for the username is incorrect.). I am entering the correct username and password – it’s a direct copy/paste from the install. I’ve also confirmed that the username and password are correct through the wp-config.php file and in MariaDB10 -> phpMyAdmin.

I tried editing my.cnf (using sudo -i)
/var/packages/MariaDB10/etc
vi my.cnf

[mysqld]
max_allowed_packet = 1073741824
:wq

I changed it to 4294967296, thinking 512MB should be plenty for this value. But it did not make a difference. Can anyone decipher this mumbo-jumbo to help me get this figured out?

• This reply was modified 3 years ago by 01time.