#545 Unknown database type '(Ubuntu)'

[ZelCole]

I just installed mrbs 1.11 using PHP8.2, I have a few problem, after I enable SAML authentication using SimpleSAMLPHP 2.0.4. When I click login I have the following error message

E_USER_NOTICE in /var/www/html/mrbs/web/lib/MRBS/DB_mysql.php at line 403
Unknown database type '(Ubuntu)'.

Using the db$ (mysql) credential from config.inc.php through the terminal, and is working.

[Campbell Morrison]

This is a known bug and already fixed in the latest development code which you can find here. Follow the green Code button and treat it like an upgrade.

[ZelCole]

which code i needed to upgrade after i clicked that link from github?

[ZelCole]

i guess is here ?

[Campbell Morrison]

Download the complete set of files by following the green "Code" button and then treat it like a new release. Follow the instructions in the UPGRADE document.

[ZelCole]

Hi, I already downloaded the green Code and follow the UPGRADE, the problem still persist.

[Campbell Morrison]

Could you run the attached test program please in your MRBS folder (ie at the same level as config.inc.php) and post the output here? It should be something like:

MySQL Community Server - GPL
8.0.28

but obviously changed for Ubuntu.

[Anonymous]

8.0.33-0ubuntu0.20.04.2

[Campbell Morrison]

Thanks. I was expecting two lines of output. Can you post a screenshot please?

[ZelCole]

Here is the screen shot

[Campbell Morrison]

Thanks. Could you run the attached, enhanced, diagnostic program in the MRBS folder again please and post the output?

[ZelCole]

Here is the screenshot

[Campbell Morrison]

Thanks. Could you try replacing your version of lib/MRBS/DB_mysql.php with the attached file and see if it solves the problem?

[ZelCole]

Hi, I got another error from Session.php

[Campbell Morrison]

Good. It looks like the database problem is now fixed. I have committed the change in 6bf8f15.

The locale message is appearing because it looks like you don't have the 'en-US' locale installed on your server. Can you run locale -a on your server to see what locales are installed and post it here?

I have now fixed the uncaught exception in 8035319.

[ZelCole]

C.UTF-8

[Campbell Morrison]

You need to install the en-US locale on your server.

[ZelCole]

i already set the locale into en-US.UTF-8, the problem still occurs.

[Campbell Morrison]

What does locale -a give now?

[ZelCole]

C
C.UTF-8
en_US.utf8

[Campbell Morrison]

Could you run the attached test program please and post the output here? It should look something like:

en-US.UTF-8: bool(false)
en-US.utf-8: bool(false)
en-US.utf8: bool(false)
en-US: bool(false)
en_US.UTF-8: string(11) "en_US.UTF-8"
en_US.utf-8: string(11) "en_US.utf-8"
en_US.utf8: string(10) "en_US.utf8"
en_US: string(5) "en_US"

[ZelCole]

LANG=en_US.UTF-8
LANGUAGE=
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=en_US.UTF-8

[ZelCole]

Output from test_locale.php
en-US.UTF-8: bool(false)
en-US.utf-8: bool(false)
en-US.utf8: bool(false)
en-US: bool(false)
en_US.UTF-8: bool(false)
en_US.utf-8: bool(false)
en_US.utf8: bool(false)
en_US: bool(false)

[Campbell Morrison]

Could you try restarting PHP and see if that makes a difference?