I tried giving full admin access to the mantisuser24 account used in the installation page, but no difference. Same error.

GRANT ALL PRIVILEGES ON database_name.* TO 'mantisuser24'@'localhost';
FLUSH PRIVILEGES;

Again I can log in with this user account via console/command line with no problems.

Do we have to use ADODB for connecting to MySQL? Can we not use the native PDO connection functions in php instead?

I've also tried installing when the database 'bugtracker' was not created ahead of time. Same error as above.

If the database 'bugtracker' is created ahead of time, same error as above.

I copied config_inc.php.sample to config_inc.php

Then edited the connection info as below:

# --- Database Configuration ---
$g_hostname      = 'localhost';
$g_db_username   = 'mantisuser24';
$g_db_password   = 'DontHackMeBro';
$g_database_name = 'bugtracker';
$g_db_type       = 'mysqli';

The installer opens normally, but I continue getting the "Does administrative user have access to the database? ( )" error when clicking Install.

Per forums, I updated MariadDB from 5.5 to 10.4 today:

[code]# mysql -umantisuser24 -pDontHackMeBro
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 25
Server version: 10.4.32-MariaDB MariaDB Server

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)]>
[/code]

Still have the same error on install.php

BAD
Does administrative user have access to the database? ( )

I tried to reproduce the problem following the given instructions, but couldn't.
With both MariaDB 10.11 and MySQL 8.0.35, database is initialized successfully on my box.

Do we have to use ADODB for connecting to MySQL? Can we not use the native PDO connection functions in php instead?

Yes, ADOdb is mandatory. PDO is not supported.

Does administrative user have access to the database? ( )

Between the parenthesis, I would expect to see an error message returned by the DB, it's strange that there is nothing there.

Could you execute the following low-level commands (which are equivalent to what the install script / ADOdb is doing to connect as Admin before throwing the above error message)

$c = mysqli_init();
mysqli_options($c, MYSQLI_READ_DEFAULT_GROUP, 0);
mysqli_real_connect($c, 'localhost', 'mantisuser24', 'DontHackMeBro', null, 3306, '', 0);

I Just noticed this message in your screenshot, which is actually not normal output from the install script, but an error returned by ADOdb.

Mantis 2.26.0 bundles ADOdb 5.22.6, which requires requires the MySQL Native Driver (Mysqlnd) to be installed for mysql connections.
Can you check that it is available on your system ?

image.png (34,611 bytes)   

image.png (34,611 bytes)   

@dregad as long as there is no better solution in ADOdb for that than

        // Check for a function that only exists in mysqlnd
        if (!function_exists('mysqli_stmt_get_result')) {
            // @TODO This will be treated as if the mysqli extension were not available
            // This could be misleading, so we output an additional error message.
            // We should probably throw a specific exception instead.
            $this->outp("MySQL Native Driver (msqlnd) required");
            return null;
        }

Shouldn't we introduce an own check for this in the MantisBT installer to prevent such kind of confusion?
And also in the admin checks, to find such issues the easy way if users are getting issues after an upgrade.

Yeah I must admit this check is kind of crap, as it does not let the client easily catch a meaningful error. As mentioned in the TODO note, it should be replaced with a more severe error or Exception.

Introducing an additional check on our end as a workaround was indeed my intention.

mysqlnd is installed:

yum info php72w-mysqlnd
Loaded plugins: etckeeper, product-id, search-disabled-repos, subscription-manager
Installed Packages
Name : php72w-mysqlnd
Arch : x86_64
Version : 7.2.34
Release : 1.w7
Size : 858 k
Repo : installed
From repo : webtatic
Summary : A module for PHP applications that use MySQL databases
URL : http://www.php.net/
License : PHP
Description : The php-mysqlnd package contains a dynamic shared object that will add
: MySQL database support to PHP. MySQL is an object-relational database
: management system. PHP is an HTML-embeddable scripting language. If
: you need MySQL support for PHP applications, you will need to install
: this package and the php package.
:
: This package use the MySQL Native Driver

I am able to confirm that the error went away with MariaDB 10.4. When I upgraded MariaDB last week I had a residual error that I thought was a non-issue, but wiped everything out and installed MariaDB 10.4 from scratch.

Will continue setting up Mantis. Thanks all.

OK, thanks for the feedback and good luck with the installation.

I will keep this open to track the needed improvement to the installer's check, to properly detect the missing extension.

PR https://github.com/mantisbt/mantisbt/pull/1959 fixes

• detect mysqlnd in the installer and prevent installation if missing
• Admin checks also report the problem
• the requirement has been documented in Admin Guide.