More Problems Updating

I finally worked out why the update didn’t proceed as the installation was at /var/www/gibbon instead of /var/www/gibbon

I copied the files to the correct folder but now I don’t get the gibbon welcome page, I get an error message.Composer detected issues in your platform: Your Composer dependencies require a PHP version “>= 7.3.0”.

I have installed php7.3 on my Ubuntu 18.04 server but no change. Any tips as to what to do? This is a production install and they will be back at work tomorrow in about 16 hours time!

I just tried to enable php7.3 manually but it didn’t work.

`$ sudo a2enmod php7.3
Considering dependency mpm_prefork for php7.3:
Considering conflict mpm_event for mpm_prefork:
Considering conflict mpm_worker for mpm_prefork:
Module mpm_prefork already enabled
Considering conflict php5 for php7.3:
Enabling module php7.3.
To activate the new configuration, you need to run:
  systemctl restart apache2`
```


I then ran systemctl restart apache2` but problem persists,

Sweat running down brow...

Fixed this problem using sudo a2dismod php7.2 then <code class="CodeInline">sudo a2enmod php7.3

but now I have a new error:

OH NO!
A database connection could not be established. Please try again.

If you cannot solve this problem by retyping the address, or through other means, please contact your system administrator.

I tried rebooting but problem persists…

How do I reconnect the database?
#outofmydepth

This was a working V19 install until I updated.

Database is still in the home directory and config file hasn’t been overwritten.

Does V22 require a more up to date version of mysql?

I finally worked out why the update didn't proceed as the installation was at /var/www/gibbon instead of /var/www/html

I copied the files to the correct folder but now I don’t get the gibbon welcome page, I get an error message.Composer detected issues in your platform: Your Composer dependencies require a PHP version “>= 7.3.0”.

I have installed php7.3 on my Ubuntu 18.04 server but no change. Any tips as to what to do? This is a production install and they will be back at work tomorrow in about 16 hours time!

Corrected first post.

Hi sbaldwin, this does not seem like a PHP issue, despite the Composer warning you are seeing. PHP seems to be working fine, otherwise the Oh no! page would not work in the way that it is.

So, I suspect something is going on with MySQL. If you open Gibbon’s config.php file, you should see the database server, username, password and database name for Gibbon. Can you connect to your server’s MySQL service using these? Usually this would look like:

mysql -u [username] -p

If you issue this into the server’s command prompt, it should ask for a password. Can you get into MySQL this way?

Thanks,

Ross

Thanks for answering Ross. The composer warning disappeared after I upgraded to PHP7.3. But that seems to have caused the database problem. I will try and get into the database from the server and report back.

I have logged into the server by ssh and tried to log into the database using the mysql command as advised. The database is called gibbon.sql and I documented the password when I set it up. I can’t get in but maybe I am using the wrong username. Also I can’t find the database info in config.php , where in the file should I be looking?

Thanks again

Simon

Here is the information about the database, it seems to be intact…

`stat gibbon.sql
  File: gibbon.sql
  Size: 430014    	Blocks: 840        IO Block: 4096   regular file
Device: 802h/2050d	Inode: 6294894     Links: 1
Access: (0644/-rw-r--r--)  Uid: ( 1000/administrator)   Gid: ( 1000/administrator)
Access: 2021-09-03 05:48:05.000000000 +0000
Modify: 2021-09-03 05:47:29.000000000 +0000
Change: 2021-12-31 00:08:57.360813236 +0000
 Birth: -`
```

I found a combination of user and password that got me into the database!

`mysql -u gibbonuser -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \\g.
Your MariaDB connection id is 43
Server version: 10.1.48-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| gibbon             |
| information_schema |
+--------------------+`
```

2 rows in set (0.02 sec)

I have now found the config.php and it does have the correct login information.

config.php is in the /var/www/gibbon folder and gibbon.sql is in the home folder for the user (where I start off after logging in by SSH)

Could the connection process by affected by the change from php7.2 to php7.3?

There is also a copy of gibbon.sql in /var/www/gibbon:

`$:/var/www/gibbon$ stat gibbon.sql
  File: gibbon.sql
  Size: 430014    	Blocks: 840        IO Block: 4096   regular file
Device: 802h/2050d	Inode: 1451819     Links: 1
Access: (0755/-rwxr-xr-x)  Uid: (   33/www-data)   Gid: (   33/www-data)
Access: 2020-02-28 12:48:39.511993218 +0000
Modify: 2022-03-06 15:54:23.634296908 +0000
Change: 2022-03-06 15:54:23.634296908 +0000
 Birth: -
`
```
There is also a copy of gibbon.sql in /var/www/gibbon:
`$:/var/www/gibbon$ stat gibbon.sql
  File: gibbon.sql
  Size: 430014    	Blocks: 840        IO Block: 4096   regular file
Device: 802h/2050d	Inode: 1451819     Links: 1
Access: (0755/-rwxr-xr-x)  Uid: (   33/www-data)   Gid: (   33/www-data)
Access: 2020-02-28 12:48:39.511993218 +0000
Modify: 2022-03-06 15:54:23.634296908 +0000
Change: 2022-03-06 15:54:23.634296908 +0000
 Birth: -
`
```
This is clearly the working database.

Are there any tests I can do or logs I can interrogate about this?