admin-58-MySQL server has gone away

[liberate]

Hi Dean

I am trying to set up Listmail on a new server. Everything has gone well, I did a backup and restore on to the new server. My website displays information from the Listmail database. Working perfectly.

The path to Listmail is set correctly. Database connect is set in config.php

The "Signup Code", both on my site's registration page and the "working preview" of Listmail, result in:

" admin-58-MySQL server has gone away "

Nothing is written in the database and no email is sent.

Do you know what this is?

Thanks
Tom

[liberate]

Hi Dean

Somewhat solved.....

My host (Bluehost.com) has something called "FastCGI for PHP".

Toggled "ON" I get the error message:
admin-58-MySQL server has gone away


Toggled "OFF" ListMailPro works just as you designed it to.


According to Bluehost any php script that that works just fine without FastCGI will work with it, except faster.

I had turned FastCGI on when I first got the hosting, before I uploaded ListMailPro, didn't know if the benefits would apply to ListMailPro but it wasn't supposted to hurt.



-------------------------------------------------------------------------------------

FastCGI for PHP copied from Bluehost.

-------------------

FastCGI for PHP

FastCGI for PHP makes all your PHP applications run through mod_fastcgi instead of mod_phpsusexec. FastCGI applications are fast because they're persistent.  There is no per-request startup and initialization overhead.  This makes possible the development of applications which would otherwise be impractical within the CGI paradigm (e.g. a huge PHP script, or an application which requires a connection to one or more databases).  

Benefits:

PHP scripts will run faster. The PHP interpreter is loaded into memory rather than calling from storage for every hit, greatly improving performance of your scripted site.
You will use less Server Resources. Since the server does not have load the PHP interpreter for each hit, you will be able to accommodate a higher traffic site without exceeding your CPU quota.
NO modifications to your existing code are required. Everything you currently run will work with FastCGI for PHP.
Potential Problems:

You will only have one php.ini file available for all subdirectories (/home/USERNAME/public_html/php.ini). This is necessary to help optimize the website code as much as possible. If you need multiple php.ini files to accommodate different scripting needs, you can disable FastCGI for PHP on any of your subdirectories while leaving the rest of the account enabled for performance. Please contact support if you need to do this.
There can be a few minute delay in any updates you make to your PHP environment (ie, php.ini changes). Since your php.ini is loaded into memory for greater speed, every hit does not re-read it from storage.

-------------------------------------------------------------------------------------
 

Do you know why ListMailPro doesn't work with FastCGI turned on?

Thanks

Tom

[DW]

Hi Tom,

In my experience the error message you reported usually indicates the MySQL server is a bit overloaded and is having trouble keeping up.  Maybe MySQL can't keep up with FastCGI because it's just too darn fast! The message can also be shown when the MySQL server is restarted for one reason or another when a script is in the middle of performing a query.  I highly recommend asking Bluehost if they have seen this before to see if they have any advice.

Regards