cancel
Showing results for 
Search instead for 
Did you mean: 

CCGI Webspace PHP version

FIXED
Highlighted
Dabbler
Posts: 22
Thanks: 1
Fixes: 1
Registered: ‎30-07-2007

CCGI Webspace PHP version

I tried to change the PHP version using PHP Manager in Control Panel.
Now I get "Not Found [CFN #0005]" when I try to connect.
I can see via Filezilla that all files are intact.
Looking through previous posts, in one from 2017 a staff member provided a fix.
However another post from January suggests it would be a DIY effort.
Can anyone tell me what I need to do to fix this?

Thanks
David

19 REPLIES 19
Highlighted
Community Gaffer
Community Gaffer
Posts: 14,356
Thanks: 1,951
Fixes: 142
Registered: ‎04-04-2007

Re: CCGI Webspace PHP version

Providing the URL/web address that you're having problems with would help. My first suggestion would be to check for any hidden .htaccess files you might have. Try renaming them temporarily and see if your site springs back to life.

Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵

Highlighted
Dabbler
Posts: 22
Thanks: 1
Fixes: 1
Registered: ‎30-07-2007

Re: CCGI Webspace PHP version

Hi Bob,

thanks for the quick reply.

I had previously tried changing .htaccess files to .htaccessold but made no difference.

This time I changed to old.htaccess.

Now I get a massive text file beginning "PDOException: SQLSTATE[42000]: Syntax error or access violation: 1142 REFERENCES command denied to user 'ccgidbroad379174'@'91.136.11.87' for table 'wt_module' in /services/webpages/util/c/c/ccgi.[Removed].plus.com/public/webtrees/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117..etc"

Looks like a database poblem, but is it due to changing PHP version or a Webtrees issue?

The url is [Removed]

 

David

Moderator's note by Mike (Mav): Personal information removed from a public forum (to an area that staff can see).
Highlighted
Superuser
Superuser
Posts: 10,063
Thanks: 1,369
Fixes: 75
Registered: ‎06-04-2007

Re: CCGI Webspace PHP version

Changing PHP version using PHP manager changes apach2handler to a fastcgi version. The former understands PHP directives in .htaccess but the latter doesn’t. .php.ini has to be used instead. Some 3 years ago I’d have known how to use this but now don’t. So any advice from me is very dated and I’m stuck.
Sorry that doesn’t provide much help but best I can do now
David
Highlighted
Dabbler
Posts: 22
Thanks: 1
Fixes: 1
Registered: ‎30-07-2007

Re: CCGI Webspace PHP version

Thanks spraxyt it's given me something to look for.

Sorry for the delayed reply I've been reading up on php.ini.

I found there's a text editor in Control Panel that will create a php.ini but it's not as simple as copying text from .htaccess file.

The offending .htaccess file contains the following text:-

# Fix date error problem
php_value date.timezone 'Europe/London'
php_value display_errors 1
php_value error_reporting 32767
# for PHP-CGI
AddHandler php-cgi .php
Action php-cgi /cgi-bin/php-cgi

# for php and securewebexchange
<IfDefine SSL>
AddHandler php-cgi .php
Action php-cgi https://secure50.securewebsession.eu/ccgi.username.plus.com/cgi-bin/php-cgi
</IfDefine>

 

This was given to me many years ago and like spraxyt I can't remember the details.

Can anyone rewrite this for use in a php.ini file?

 

Thanks

David

Highlighted
Community Gaffer
Community Gaffer
Posts: 14,356
Thanks: 1,951
Fixes: 142
Registered: ‎04-04-2007

Re: CCGI Webspace PHP version

This might offer a clue...

REFERENCES command denied to user...

It seems the script requires that the database user has REFERENCES priviledges and I'm not cetain that's available in the hosting environment:-

sql.JPG

Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵

Highlighted
Superuser
Superuser
Posts: 10,063
Thanks: 1,369
Fixes: 75
Registered: ‎06-04-2007

Re: CCGI Webspace PHP version

@bobpullen Clearly this is beyond my remit to deal with but reverting to default apache2handler would be the way I’d go. But PHP Manager appears no longer to offer that option. I’ve no idea why Hostopia have done this but can you get this user reverted if he requests it?
I feel changing PHP version using PHP Manager is not helpful in our hosting environment, but have nothing to prove that.
David
Highlighted
Dabbler
Posts: 22
Thanks: 1
Fixes: 1
Registered: ‎30-07-2007

Re: CCGI Webspace PHP version

Thanks guys, I would be happy with a reset if its possible.

 

David

Highlighted
Superuser
Superuser
Posts: 10,063
Thanks: 1,369
Fixes: 75
Registered: ‎06-04-2007

Re: CCGI Webspace PHP version

@bobpullen
Not sure if this is relevant to an old installation but seems worth a mention. https://community.plus.net/t5/Everything-else/Installing-Wordpress-on-PlusNet-Revisited/td-p/1700245... This used standard PHP.
David
Highlighted
Community Gaffer
Community Gaffer
Posts: 14,356
Thanks: 1,951
Fixes: 142
Registered: ‎04-04-2007

Re: CCGI Webspace PHP version

I'm not sure I understand how that would help, but granted this isn't my area of expertise.

Unless I'm mistaken, there aren't any .htaccess files (renamed or otherwise) that are contributing to what's currently being seen.

PHP executes on the customer's webspace, there's just something with this webtrees installation that isn't playing ball.

Wouldn't we still have the priviledges issue irresepctive of PHP handler?

Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵

Highlighted
Dabbler
Posts: 22
Thanks: 1
Fixes: 1
Registered: ‎30-07-2007

Re: CCGI Webspace PHP version

@spraxyt 

That's the post that led me here. In it you ask if PHP Manager was used to change anything.

In my case the answer is yes.

If reverting means going back to standard PHP then try it, even if it means I have to re-instal Webtrees.

David

.

Highlighted
Superuser
Superuser
Posts: 10,063
Thanks: 1,369
Fixes: 75
Registered: ‎06-04-2007

Re: CCGI Webspace PHP version

Whereas a rogue .htaccess entry has been the cause of these weird errors in this case I think hosting now being on PHP 7.1 might make WordPress 5.x mandatory. I’ve no idea how to update our existing WordPress 4.x sites to a 5.x version. I think working from standard PHP and apache is the best approach but can’t quantify how to do this. But undoing the PHP-cgi change would be the first step.
I think Plusnet background support would be needed to achieve this. But it’s beyond my out of date skills. So stuck.
David
Highlighted
Dabbler
Posts: 22
Thanks: 1
Fixes: 1
Registered: ‎30-07-2007

Re: CCGI Webspace PHP version

@bobpullen I've discussed this with a Webtrees developer.

He agrees its a REFERENCES permission problem and suggests someone needs to grant permission.

e.g. by running this command.

GRANT REFERENCES ON < database name>.* TO <username>;

However I must have had this permission before the PHP change.

Could it be contained in the .htaccess file I renamed?

 

David

 

Highlighted
Dabbler
Posts: 22
Thanks: 1
Fixes: 1
Registered: ‎30-07-2007

Re: CCGI Webspace PHP version

@bobpullen and @spraxyt 

More info from Webtrees guy.

Please ignore comment about previous permission and .htaccess.

I didn't tell you I also updated webtrees from version 1.7 to 2.0.

It turns out vesion 1.7 did not use REFERENCES but version 2.0 does.

If I can't get permission for version 2.0 I'll revert to version 1.7.

 

David

Highlighted
Community Gaffer
Community Gaffer
Posts: 14,356
Thanks: 1,951
Fixes: 142
Registered: ‎04-04-2007

Re: CCGI Webspace PHP version

@spark43, I've asked the question of our hosting partner (ref: 5167292).

Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵