iPSK-Manager Fails to create DB

[sharker-RNIB]

Describe the bug
I am installing iPSK-Manager on ubuntu 22.04-LTS Server and cannot create the iPSK Database.

To Reproduce
Steps to reproduce the behavior:

1. Following the Install readme on Github. I got to the install.php
2. Filled in all details as per suggestions
3. Create Admin Password Click Next
4. Click Install
5. Get 500 Error
   Expected behavior
   should create a DB and continue to install iPSK-Manager
   Screenshots
   
   
   
   
   
   
   
   

Server (please complete the following information):

• OS:
  DISTRIB_ID=Ubuntu
  DISTRIB_RELEASE=22.04
  DISTRIB_CODENAME=jammy
  DISTRIB_DESCRIPTION="Ubuntu 22.04.1 LTS"

Desktop
OS: Windows 10 22H2
Browser: Edge
Additional context
Add any other context about the problem here.

[sharker-RNIB]

I've managed to get iPSK-Manager installed.
Ubuntu 22.04 comes with PHP 8.1.x the php code in the installer.php file doesn't work very well with php 8.1 I had to "downgrade" the php version back to 7.4.x and install all the 7.4 exentions:

Downgrade:
sudo apt install software-properties-common apt-transport-https -y
#install the php 7 repo
sudo add-apt-repository ppa:ondrej/php -y
sudo apt update
sudo apt upgrade
#install php7
sudo apt install php7.4 php7.4-common libapache2-mod-php7.4 php7.4-cli
#Disable php 8
sudo a2dismod php8.1
#Enable php 7
sudo a2enmod php7.4
#restart Apache2
sudo systemctl restart apache2
#Install php extentions needed for iPSK-Manager
sudo apt install php7.4-mbstring
sudo apt install php7.4-xml
sudo apt install php7.4-ldap
sudo apt install php7.4-mysqli
sudo apt install php7.4-mysqlng
sudo apt install php7.4-curl
#I do not know if all those are needed I am using my command history for this
Then restart apache2 again:
sudo systemctl restart apache2

After doing this I could then get through the full installer.

This is not ideal as php7.4 could have issues in it. Ideally iPSK-Manager needs to be updated to php 8

[htlgit00]

The exception appears from lines 358 ~ 363 of installer.php

			if($dbConnection->select_db($_SESSION['databasename'])){
				$installProgress .= "<div><span style=\"color: #ff0000\" data-feather=\"x-circle\"></span>Database Already Exists</div>";
				goto Bail;
			}else{
				$installProgress .= "<div><span style=\"color: #2d8c32\" data-feather=\"check-circle\"></span>Database is not in use</div>";
			}

Likely, this is due to this change PHP RFC: Change Default mysqli Error Mode, which reported in PHP 8.1 @ https://www.php.net/manual/en/mysqli-driver.report-mode.php

As of PHP 8.1.0, the default setting is MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT. Previously, it was MYSQLI_REPORT_OFF.

[ciesinsn]

This specific issue (lines 358-363 above) has been fixed and working on another fix or two before pushing it up to the branch.

[ciesinsn]

changes have been merged into master branch