"Fantastico is unable to connect to your MySQL server at this time. Please contact your host for assistance." .....Was the message I received when logging in to a clients cpanel to check if Fantatico was functioning. All items in Fantastico Root settings are the same as before... It has just stopped working, we have: Restarted SQL Restarted apache Reatarted cpanel Uninstalled fantastico Reinstalled fantastico REBOOTED server even! (All through SSH) Nothing! It still shows the following message on ANY cpanel account and WHM options do not appear for any reseller through WHM except ROOT. Dont know why it should connect to SQL as there doesn't seem to be a database pertaining to Fantastico! It updates fine and seems fine from the ROOT when setting up but from cpanel it just says: "Fantastico is unable to connect to your MySQL server at this time. Please contact your host for assistance." Any advice? cpanel team are good with any problems but netenberg seem reluctant to offer support? Please Help, its driving us nuts!
All - All cpanel accounts show this error and all reseller accounts show this error in their cpanel and clicking on the option at the bottom of their whm does nothing! Am at a loss at what to do! Even uninstalling and reinstalling has not helped?
1) Restart MySQL on your server. Watch for errors. If MySQL doesn't restart successfully, skip to #5 and try that next. (Note that in some rare instances, clients report the need to restart their server to get MySQL working properly.) 2) The cPanel account is out of disk space or out of available mysql slots. Increase one or both of these and try again. 3) The cPanel account account reports plenty of available disk space and mysql slots, but the user data/plan assignment is corrupt. Try assigning the account to a new featureset/hosting plan and see if that resolves it. If so, you may need to recreate or reassign the original plan to get things working again. 4) The server itself is out of disk space on one or more partitions. Clean out unneeded files or accounts in this case. 5) MySQL is malfunctioning on the server or the Perl DBD module is corrupt or missing. Run /scripts/mysqlup --force via SSH as root and watch for errors if any. 6) The backend version of PHP is corrupt. Check the items here for a resolution: http://netenberg.com/forum/viewtopic.php?t=1960.0 7) If this only affects a single account, the account data may be corrupt. Do a full backup of the account, terminate it and then use the full backup to restore the account. 8) Ensure your server is running Perl 5.8.8 (or whatever the latest approved version from cPanel Inc. happens to be -- see http://layer1.cpanel.net/ ). Fantastico does not use Perl, but cPanel uses it extensively and if Perl isn't a recent version, cPanel and thus Fantastico will have problems. 9) Ensure you're using the latest version of cPanel for your preferred build track. Run /scripts/upcp --force (or force the cPanel update from WHM) to make sure all files are installed and are the latest versions. If you run EDGE, try backing down to Current, Release or Stable and see if that helps. 10) If all else fails, try removing Fantastico: http://www.netenberg.com/forum/index.php?topic=3164.0 and reinstalling it: http://www.netenberg.com/forum/index.php?topic=950.0
Ok - on investigation this appears to only effect the resellers?? In their WHM and cPanel. Users that are ONLY cpanel customers WITHOUT access to WHM are not effected and fantasico de luxe works fine for them... The Fantastico is unable to connect to your MySQL server at this time. Please contact your host for assistance. message only appears in the cpanel of the reseller account??
I have done all this. I dont know why it is playing up - I have now isolated the problem to ONE account. whether it is a basic cpanel account or reseller account this message comes up in its cpanel. I have tried changing the package, owner and featureset all to no avail! I am doing a FULL backup, am going to terminate the account then restore it. Hopefully that will work.
If its just one account, then odds are its the password for that account. It may contain characters that MySQL cannot recognize, I would suggest changing the password for that account, then trying again.
Done that! I have been in too much haste. I backed up the site using a full cpbackup then terminated the account and recreated it checking fantastico was working - woo woo it was. I then went to restore the cpmove file and found that stupidly cpanel had placed it in the folder within /home/user therefore when I terminated it, I wiped the backup file also. Grrrr I am having to restore the files to a time when I took a remote backup and reupdate the changes I have made since Jan 2nd! Still, valuable lesson learned I guess! Will get it all working well again then make regular REMOTE cpmove backups!