Multiple database connections

FluxCapacitor2

Hi,

I'm developing a simple extension for my forum that will display some data from another database in a table at a specific route. I just have a simple question: How do I provide data through the API from another database. They are both hosted on the same server and I've tried following this guide but I can't seem to find the right config file to add my connections. Where is the database config located? Is it implemented through Laravel?

Edit: I also can't find the env file that specifies database settings

datitisev

FluxCapacitor2 Flarum only uses parts of Laravel. Eloquent is used, but the initialization is different.

The database connection is established in DatabaseServiceProvider.

FluxCapacitor2

Thanks so much for the reply! It pointed me in the right direction, but now I'm having a different issue.
I've been trying to add my database like this in my extension:

 Config::set("database.connections.myconnection", [
                "driver"    => "mysql",
                "host"      => "127.0.0.1",
                "port"      => "3306",
                "database"  => (md DB name),
                "username"  => (my BD username),
                "password"  => (my DB password),
                "charset"   => "utf8mb4",
                "collation" => "utf8mb4_unicode_ci",
            ]);

and whenever this code runs (currently it is placed in the data method in a class that extends AbstractListController) I get the following error:
Notice: Trying to access array offset on value of type null in C:\xampp\htdocs\forums\vendor\illuminate\support\Facades\Facade.php on line 175
It gives no additional details so I'm pretty stuck here. I have tried connecting to the database using the same credentials that are in my code and it works.

The code around like 175 of Facade.php looks like:

    /**
     * Resolve the facade root instance from the container.
     *
     * @param  string|object  $name
     * @return mixed
     */
    protected static function resolveFacadeInstance($name)
    {
        if (is_object($name)) {
            return $name;
        }

        if (isset(static::$resolvedInstance[$name])) {
            return static::$resolvedInstance[$name];
        }

        return static::$resolvedInstance[$name] = static::$app[$name];
    }

Line 175 is the return statement at the end of the method.

luceos

This is what I did for bokt (keeps phpbb and flarum in sync) in a custom Service Provider:

$this->app->extend(Manager::class, function (Manager $manager) {
    $manager->addConnection([
        'driver' => 'mysql',
        'host' => env('DB_SYNC_HOST', 'localhost'),
        'port' => env('DB_SYNC_PORT', '3306'),
        'database' => env('DB_SYNC_DATABASE', 'bokt_phpbb'),
        'username' => env('DB_SYNC_USERNAME', 'root'),
        'password' => env('DB_SYNC_PASSWORD', ''),
        'unix_socket' => env('DB_SYNC_SOCKET', ''),
        'charset' => 'utf8mb4',
        'collation' => 'utf8mb4_unicode_ci',
        'prefix' => env('DB_SYNC_PREFIX', ''),
        'strict' => true,
        'engine' => null,
    ], 'sync');

    return $manager;
});

luceos

marionline instead of extend AbstractCommand, extend the Illuminate Command. Then in handle inject the Iluminate Database Manager and see my snippet from luceos for inspiration.

It might still work.

FluxCapacitor2

Thank you so much! This really helped a lot

marionline

Hi to all. I am try to update an old extension (ArchLinux fluxbbimporter) for my purpose.

From my extension I want to connect to another database (the fluxbb). The configuration to connect to db server is taken from fluxbb config file.
Now I would like to use the Laravel facades DB (es. $user = DB:: connection()->... ;) to connect to it but in flarum is impossible, isn't?

So I found this discussion but I don't understand how to use the code above.
For simplicity. If I create a basic extension for cli, example:


<?php
use Flarum\Console\AbstractCommand;
use Flarum\Extension\ExtensionManager;
use Symfony\Component\Console\Input\InputArgument;

class MyClass extends AbstractCommand
{
    //...//
    protected function fire() {
        config("database.connections.fluxbb", [
                'driver' => $db_type,
                'host' => $db_host,
                'port' => '3306',
                'database' => $db_name,
                'username' => $db_username,
                'password' => $db_password,
                'prefix' => $db_prefix,
                'strict' => true,
                'engine' => null,
        ]);
        $users = DB::connection('fluxbb')->table('users')->get(); // just to explain
        //...//     
    }
}

How can I connect to the database with simplicity like with facade?

marionline

Thank you for your answer. It help me a lot!
I found another solution. I don't know if it is the best and clean solution but for me is much easier to work with.
Just to explain, I prefer to use Capsule DB Manager, example:

<?php
use Flarum\Console\AbstractCommand;
use Illuminate\Database\Capsule\Manager;
use Flarum\Extension\ExtensionManager;
use Symfony\Component\Console\Input\InputArgument;

class MyClass extends AbstractCommand
{
    //...//
    private Manager $DBmanager;

    public function __construct( Manager $DBManager ) {
        $this->DBmanager = $DBmanager;
        parent::__construct();
    }
    protected function fire() {
         $this->DBmanager->addConnection([
                'driver' => 'mysql',
                'host' => $db_host,
                'port' => '3306',
                'database' => $db_name,
                'username' => $db_username,
                'password' => $db_password,
                'prefix' => $db_prefix,
                'strict' => true,
                'engine' => null,
            ], 'fluxbb');
  
        $users = $this->DBManager->connection('fluxbb')->table('users')->get(); // just to explain
        //...//     
    }
}