Softaculous

Topic : Silverstripe presents MySQL Error No : 1064 when trying to install

Posted By: cpanel_aaronh on June 23, 2014, 3:01 pm

Hey guys,

I ran across an issue that happens when you try and install Silverstripe through Softaculous. The install gets 10% through and then throws the error MySQL Error No : 1064

I was able to replicate this on a customers server as well as a test VM. When I tried to install the software manually, everything went through. I have attached some screen shots for you as well.

Posted By: Brijesh on June 24, 2014, 6:59 am | Post: 1

Hi,

It seems cptest.com does not point to your server. When you install SilverStripe via Softaculous and your server's cPanel 3rd party PHP version is less than 5.3, we create a file under our domain and access that file via CURL to generate the password hash because the password encryption method used by SilverStripe requires PHP 5.3+
Since your domain is not accessible the password was not generated properly causing the issue.

When you install SilverStripe manually you accessed the domain via User MOD dir i.e. http://YOUR_IP/~USERNAME hence you were able to install the script.

You need to login to your WHM goto Plugins -> Softaculous -> Settings and select the checkbox "Use USER MOD DIR" and click on "Edit Settings". You will now see the mod dir under the "Choose Domain" dropdown select that and then install SilverStripe and it should work fine.

Please let us know if you still face the issue.

-----------------------
Webuzo - Multi User Hosting Control Panel
AMPPS - Best WordPress/PHP/MySQL development tool

Posted By: NeillLS on June 26, 2014, 7:17 am | Post: 2

Hi,

Aaron logged the issue on my behalf as a Cpanel user - I can confirm that the fix you have suggested works.

However, I was interested that you mentioned about the 3rd party PHP - I have version 5.4.24 in use, so unsure why that didn't solve the issue - any ideas?

Regards

Neill LS

Posted By: Brijesh on June 26, 2014, 7:22 am | Post: 3

Hi,

Is your cPanel 3rd party PHP version 5.4.24 ? Or is it the frontend PHP ?
You can check the 3rd party PHP version using the following command via Terminal :

Code
/usr/local/cpanel/3rdparty/bin/php -v

Edited by Brijesh : June 26, 2014, 7:22 am

-----------------------
Webuzo - Multi User Hosting Control Panel
AMPPS - Best WordPress/PHP/MySQL development tool

Posted By: NeillLS on June 26, 2014, 7:28 am | Post: 4

Hi,

I've just checked using that command - PHP 5.4.23 as well (see attachment).....that's what is confusing is that if I create a new user on Cpanel, it will let me install Silverstripe without the mod User selection without issue - but with this single domain I have, if I install it for that, it fails on the script (but works OK with the workround) - I have deleted the user account and created it again, but some issue is repeated...

Strange...but the mod user did solve it...what do you think is going wrong with the script?

Neill LS

Posted By: NeillLS on June 26, 2014, 7:29 am | Post: 5

Attachment!

Posted By: NeillLS on June 26, 2014, 7:30 am | Post: 6

Quote From : NeillLS June 26, 2014, 7:29 am

Attachment!

- blast!....can't upload PNG or JPEG attachments to the thread... :-(

Posted By: Brijesh on June 26, 2014, 7:42 am | Post: 7

Hi,

Does the domain of the new user created point to that server ? I mean are the DNS correct ?
It does not work with the current user and works with the MOD Dir because the DNS of this user are not set.

-----------------------
Webuzo - Multi User Hosting Control Panel
AMPPS - Best WordPress/PHP/MySQL development tool

Posted By: NeillLS on June 26, 2014, 10:52 pm | Post: 8

Hi,
All checked - all the DNS records (inc A for @ and www) are going to the local host.

Mmmmm..stranger...

Neill

Posted By: Brijesh on June 28, 2014, 6:53 am | Post: 9

Hi,

Yes I am now able to ping the domain. Can you please try to install now.

If you still face the issue please open a support ticket with us we will check the issue asap.

-----------------------
Webuzo - Multi User Hosting Control Panel
AMPPS - Best WordPress/PHP/MySQL development tool