Ubuntu 22.04 (server) - can't switch site between php versions

ZinkDifferent

Fresh install of Ubuntu 22.04 server
Fresh install of Wordops
Create new site, which is a forum (Invision) and thus created as a --php81 and --mysql site
Install forum software = only in one function, mysql 'goes away'
Try to switch to different PHP version - consistent error:

2023-08-07 07:01:07,710 (DEBUG) wo.core.logging : Command Output: , 
Command Error: 
2023-08-07 07:01:07,710 (INFO) wo : [Done]
2023-08-07 07:01:07,710 (DEBUG) wo.core.logging : 'php73'
2023-08-07 07:01:07,710 (INFO) wo : Check the log for details: `tail /var/log/wo/wordops.log` and please try again

Now, when I attempted to switch the site to PHP73, it actually did it.
When I subsequently tried to switch it back to PHP80, or php81, I get the same error.

The site I am setting up requires PHP8.0 at a minimum.

What's going on here?

ZinkDifferent

Even using phpMyAdmin, when performing various actions (like an import), it throws up "It seems connection to the server has been lost", consistently. Not sure if this is just MySQL related or there's some other connectivity issue.

Any suggestions, ideas? Is this an issue with Ubuntu 22.04, or is something else at work here?

ZinkDifferent

So, apparently current WordOps doesn't work with Ubuntu 22.04. I'm reinstalling an Ubuntu 20.04 minimal server, to see if that addresses the issue that I have been encountering.

ZinkDifferent

NOPE! Ubuntu server 20.04, latest words installation. Same errors.
Seriously, what is going on here? Is anyone still on here?

marty

Could be an issue with WordOps v3.17.0 (was released yesterday)
But what are the server requirements for Invision? (I checked their site but couldn't find anything conclusive)
Is there anything useful in wordops.log? (i.e. "Check the log for details: tail /var/log/wo/wordops.log")

ZinkDifferent

marty

tail /var/log/nginx/chicabow.com.
chicabow.com.access.log  chicabow.com.error.log   
root@chicabow:/var/lib/mysql# tail /var/log/nginx/chicabow.com.error.log 
  thrown in /var/www/chicabow.com/htdocs/system/Db/Db.php on line 638" while reading response header from upstream, client: 104.28.123.87, server: chicabow.com, request: "POST /admin/?app=core&module=members&controller=members&do=add HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php80-two-fpm.sock:", host: "chicabow.com", referrer: "https://chicabow.com/admin/?app=core&module=members&controller=members"
2023/08/07 23:56:17 [error] 58345#58345: *512 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught IPS\Db\Exception: MySQL server has gone away in /var/www/chicabow.com/htdocs/system/Db/Db.php:638
Stack trace:
#0 /var/www/chicabow.com/htdocs/system/Db/Db.php(972): IPS\_Db->preparedQuery()
#1 /var/www/chicabow.com/htdocs/system/Session/Admin.php(112): IPS\_Db->replace()
#2 [internal function]: IPS\Session\_Admin->write()
#3 /var/www/chicabow.com/htdocs/system/Redis/Redis.php(202): session_write_close()
#4 [internal function]: IPS\_Redis->IPS\{closure}()
#5 {main}
  thrown in /var/www/chicabow.com/htdocs/system/Db/Db.php on line 638" while reading response header from upstream, client: 104.28.123.87, server: chicabow.com, request: "POST /admin/?app=core&module=members&controller=members&do=add HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php80-two-fpm.sock:", host: "chicabow.com", referrer: "https://chicabow.com/admin/?app=core&module=members&controller=members"

marty

OK, so that just confirms the error you originally mentioned... :-)

What are the server requirements for Invision?
Is there anything useful in wordops.log?

ZinkDifferent

marty

marty What are the server requirements for Invision?

"php": {
        "required": "7.4.0",
        "recommended": "8.0.0"
  
"mysql": {
        "required": "5.5.3",
        "recommended": "5.6.2"

The system is running:

MySQL version 10.11.4-MariaDB-1:10.11.4+maria_ubu2004-log.

marty

I guess those versions are OK (does 'recommended' mean minimum version, so that or anything above? not really clear).
Bus as I keep saying - check wordops.log and see what errors are showing in there from when you try to switch php version.

ZinkDifferent

So, if I want an html/php website, using php 8.0 with mysql -- how would I set it up using wordops?

I usually do:

wo site create sitename.tld --php80 --mysql --le

Am I missing anything there?

marty

That sounds fine (assuming the stack is installed and php8.0).

ZinkDifferent

marty
I think I have discovered something to maybe point us in the right direction:

"The installer uses PHP sessions to store data,
however PHP sessions are currently not working
correctly on your server."

marty

So this is coming from the Invision installer?
I doubt there's a problem with sessions - but this could be a symptom of some other problem (which may reveal itself in wordops.log).
But if you want to check sessions... 1) are cookies enabled in your web browser 2) create a phpinfo() page in the same folder as the installer, load that page in your browser and check the main Sessions section.

ZinkDifferent

marty
Right, but on the Ubuntu installation, still not able to switch PHP versions on the installation.

wo site update site name.tld --php80 yields an error

2023-08-09 00:41:59,439 (DEBUG) wo.core.logging : Running command: mysqldump --single-transaction --hex-blob chicabow_com_pPQ4zge9 | zstd -c > /var/www/chicabow.com/backup/09Aug2023-00-40-36/chicabow_com_pPQ4zge9.zst
2023-08-09 00:41:59,487 (DEBUG) wo.core.logging : Command Output: ,
Command Error:
2023-08-09 00:41:59,487 (INFO) wo : [Done]
2023-08-09 00:41:59,487 (DEBUG) wo.core.logging : 'php73'
2023-08-09 00:41:59,487 (INFO) wo : Check the log for details: tail /var/log/wo/wordops.log and please try again

This is independent of Invision. I think the issue on the server is a problem with WordOps and dealing with a non-Wordpress site configuration (installing wordpress sites, and everything works just fine)

marty

Yeah, I know. That's why I keep telling you to check the content of wordops.log - as the message says. :-)