Setup DB Connection Error (Page 1 of 2)

Which version of FA are you using? Try the latest Git Master version. It is obvious that there is no dbname given in your config_db.php file for the company chosen during login.

Line 208 of the file includes/db/connect_db_mysqli.inc is:

if (!mysqli_select_db($db, $connection["dbname"]))

A possible modification to it would be:

if (!$connection["dbname"] && !mysqli_select_db($db, $connection["dbname"]))

@joe: want to commit it?

All the later ones including PHP 5.6 with standard defaults (debs use saner ones).

In fact a separate test to check if dbname exists in the connection array with an appropriate error would be better. many just copy over the standard FA files and populate the db manually from some default chart without installing FA and find that the files like config_db.php,  installed_extensions.php (both in the webroot and in each company), lang/installed_languages.inc and the log files are not present. WHilst some get created on use, the likes of config_db.php cannot be fathomed.

We can let this pass as the error will indicate to the user that FA needs to be installed. PHP returns false on error for such common functions like db access. This is due to strict syntax checks in later versions of PHP trying to make it more rigid instead of retaining it to be loosely typed. Otherwise, each missing variable will have to be tackled making it long winded.

Using the modification gave me these errors:
mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in file: /var/www/html/includes/db/connect_db_mysqli.inc at line 206
mysqli_query() expects parameter 1 to be mysqli, boolean given in file: /var/www/html/includes/db/connect_db_mysqli.inc at line 194
Cannot connect to database. User or password is invalid or you have no permittions to create database.

Note: On the first page of installation it checks OK on the config_db.php file, but I have tried every search I know of to locate that file to check if the dbname is included or not, but I am not able to locate the file. Any ideas? (And yes, I did install the latest FA version as per the link given by @apmuthu)

So the first couple of errors are now taken care of. It had not so much to do with the dbname as it had to do with the fact that the db password was too long to be recognized. Once a shorter name was created, most errors went away. Now I'm only stuck with "Cannot connect to database. User or password is invalid or you have no permissions to create database." Any ideas on how to solve this one?

I have manually created the db as per the installation instructions, with a user that has full privileges. The DB is showing when accessed through SSH, but I am still getting the error "Cannot connect to database. User or password is invalid or you have no permittions to create database."

I've tried 127.0.0.1 and localhost as hostname, both of which should work. As the user I've even tried as root, and made sure that root does indeed have all privileges. I'm still running into the same error message.

So we figured it out. We were able to connect with the db just fine from several other methods, including the script above. The issue ended up being caused by what seems like a error in the connect_db_mysqli.inc file where it was skipping the

mysqli_select_db($db, $connection["dbname"]);

We changed it to

{
    global $db;

    $db = mysqli_connect($connection["host"], $connection["dbuser"], $connection["dbpassword"], "",
        !empty($connection["port"]) ? $connection["port"] : 3306); // default port in mysql is 3306

    //If no name is selected we will not be able to select a database nor create one just return
    if (!$connection["dbname"])
        return 0;
    
    //Try and select the specified database
    $selectedDB = mysqli_select_db($db, $connection["dbname"]);

    //If the db doesn't exist create the database
    if (!$selectedDB)
    {
        $sql = "CREATE DATABASE IF NOT EXISTS `" . $connection["dbname"] . "`"
            . " DEFAULT COLLATE '" . get_mysql_collation($connection["collation"]) . "'";

        if (!mysqli_query($db, $sql) || !mysqli_select_db($db, $connection["dbname"]))
            return 0;
    } else {
        //else just use the selected db and ensure that the collation is set correclty
         if ($selectedDB)
         {
            if (!db_set_collation($db, $connection["collation"]))
            {
                echo mysqli_error($db);
                return 0;
            }
        }
        else
            return 0;
    }
    return $db;
}

And now it works.

That part of the code was not something we changed, I just included it as it was part of the overall section. But yes, you're right.

It appears that your MySQL server is running on one collation/character set and your client connection is running on another whilst your action FA connection is trying to change the connection characteristics.

ALTER DATABASE <database_name> CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Refer article.

Your connection appears to be anonymous and not from a specific user with password.

okay, thanks to my exceptionally brilliant employee, we figured out the problem is that when you create the dbuser, you must do so with the grant option:

grant all on fa_kmm.* to fakmm@'localhost' identified by 'XXXXXXXXXXXXXXX' with grant option;

This works for me without using RedCone's changes to the function...

If this was in the documentation somewhere, I overlooked it...

Hello I having the same problem trying to install front accounting i get the errors
mysqli_connect(): (HY000/1045): Access denied for user 'fraccdbuser'@'localhost' (using password: YES) in file: /var/www/html/fracc/includes/db/connect_db_mysqli.inc at line 206
mysqli_select_db() expects parameter 1 to be mysqli, bool given in file: /var/www/html/fracc/includes/db/connect_db_mysqli.inc at line 208
mysqli_query() expects parameter 1 to be mysqli, bool given in file: /var/www/html/fracc/includes/db/connect_db_mysqli.inc at line 213
Cannot connect to database. User or password is invalid or you have no permitions to create database

I tested the connection script  apmuthu posted and i can successfully connect to the database with the credentials, also can connect with the credentials of fraccdbuse using ssh and use the database and create tables on it, also www-data have all privilege on the web root html folder.
Finally i tried to hardcode the database name  in the script as apmuthu but is the same errors occurs.

Using FrontAccounting 2.9

PHP Version 7.4.3

installed on Apache
Server version: Apache/2.4.41 (Ubuntu)
Server built:   2020-08-12T19:46:17

Using MariaDB database
Server version: 10.3.25-MariaDB-0ubuntu0.20.04.1 Ubuntu 20.04

Help appreciated