PDO::__construct(): MySQL server has gone away

More
2 years 11 months ago #142324 by david7788
Hello,

I am trying to install LimeSurvey (2.52) on a Windows 7 desktop computer (4GB RAM) running XAMPP (Apache 2.4 / PHP 5.6.11 / 5.6.25).

I am able to get to the Pre-installation check screen, and everything checks out, but when I hit "Next", it gives me a "PDO::__construct(): MySQL server has gone away" error after a few minutes of trying to process.

Here is my settings in my.ini file. I did increase them based on other recommendations I've found on this forum.
[mysqld]
port= 3306
socket = "C:/xampp/mysql/mysql.sock"
basedir = "C:/xampp/mysql" 
tmpdir = "C:/xampp/tmp" 
datadir = "C:/xampp/mysql/data"
pid_file = "mysql.pid"
# enable-named-pipe
skip-external-locking
key_buffer = 384M
table_open_cache = 4096
sort_buffer_size = 2M
net_buffer_length = 8K
read_buffer_size = 4M
read_rnd_buffer_size = 128M
myisam_sort_buffer_size = 128M
thread_cache_size = 8
query_cache_size = 256M
net_read_timeout = 600
net_write_timeout = 600
wait_timeout = 28800

I also have increased the variable for "max_allowed_packet" at the bottom of the file:
[mysqldump]
quick
max_allowed_packet = 512M

Any help or assistance would be greatly appreciated - I am looking forward to trying out LimeSurvey!

Please Log in or Create an account to join the conversation.

LimeSurvey Partners
More
2 years 11 months ago - 2 years 11 months ago #142325 by jelo
What did you enter as servername for the database during the installation of LimeSurvey?
If it is localhost, try 127.0.0.1 instead.

In my.ini add under [mysqld]:
max_allowed_packet = 20M

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Last edit: 2 years 11 months ago by jelo.

Please Log in or Create an account to join the conversation.

More
2 years 11 months ago #142327 by david7788
Thank you, that worked!. It was the domain name. I ended up having to use the name of the computer on our network and it worked.

You're a hero for the day. :cheer:

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!