Console Commands has no .env, and no --domain option, so they can not working if needed

[MrCanan]

Hi,

First, good idea and work, it seems working except for one important thing =)

I have a problem, with three linked cases, perhaps it is a bug, or I missed something?

Problem - Case 1

• In my controller, I have a call to get information to the DB and a Cache check to save loading time
• I have also a Console Command to able to clear/reset the cache, automatically in a cron, or simply run it manually
• I change manually the data in the DB
• If I run the Console Command with "Cache::flush();" inside, it does nothing = The cache is not empty, so takes old wrong data
• If I uncomment the "Cache::flush();" line just before the "Cache::rememberForever", and refresh the page to call the controller again = The cache is empty, and be able to store and use new good data

  So, in the Console Command, as the "Cache::flush();" action needs ".env" information, and it does not, I guess ".env" information is missing

Problem - Case 2

• As I use a SQLite DB to this sample, I need to Vacuum it to save place on it
• If I run the Console Command with "DB::statement('vacuum');" inside = I get the "SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using password: NO) (Connection: mysql, SQL: vacuum)" error (so it tries to use default values as forge on mysql, instead of using SQLite)

  All actions that need ".env" in a Console Command do not work

Problem - Case 3

• I think, I have to use "--domain" option, if it is not automatically, I try it, but this option does not exist (have a look at the screenshots)

  Same missing option for Console Commands and Artisan commands (c.f.: "php artisan config:clear")

Environnement

• Laravel 11.x (lastest)
• laravel-multidomain 11.x (lastest)
• Simple example as follows (model, migration, controller, and console command) to display a field (name) in the DB SQLite

Model

app\Models\CustomPage.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

use Vite;

class CustomPage extends Model
{
    use HasFactory;

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'name',
    ];
}

Migration

database\migrations\2024_04_28_171258_create_custom_pages.php

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('custom_pages', function (Blueprint $table) {
            $table->id();
            $table->timestamps();

            $table->string('name');
        });
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::dropIfExists('custom_pages');
    }
};

Controller

app\Http\Controllers\CustomPageController.php

<?php

namespace App\Http\Controllers;

use App\Http\Controllers\Controller;

use Auth;
use Vite;
use View;
use Cache;
use Session;
use Response;

use App\Models\CustomPage;

class CustomPageController extends Controller
{
    public function showPage()
    {
        //// Work if uncomment, so to show the issue
        // Cache::flush();
        $oCustomPage = Cache::rememberForever('_oCustomPage_', function (){
            return CustomPage::first();
        });

        return view('custom_page', [
            'oCustomPage' => $oCustomPage,
        ]);
    }
}

Console Command

app\Console\Commands\RedisClearCacheTask.php

    <?php

    namespace App\Console\Commands;

    use Illuminate\Console\Command;

    use Cache;

    class RedisClearCacheTask extends Command
    {
        /**
         * The name and signature of the console command.
         *
         * @var string
         */
        protected $signature = 'app:redis-clear-cache-task';

        /**
         * The console command description.
         *
         * @var string
         */
        protected $description = 'Clear Redis cache';

        /**
         * Execute the console command.
         */
        public function handle()
        {
            $bCacheFlush = Cache::flush();

            var_dump('Cache flush '.( $bCacheFlush === true ? 'done' : 'failed' ));
        }
    }

View

resources\views\custom_page.blade.php

<!doctype html>
<head>
</head>
<body>
    <h1><strong><?php echo $oCustomPage->name; ?></strong></h1>
</body>
</html>

Thank you in advance for any help, Best regards

[gecche]

Hi,

I think that all your problems are due to the fact that the --domain option is not available in the command shell. I think that there is some error or misstep in your configuration because I just retry my package with a super fresh installation of Laravel 11.5 and I just changed the line in the bootstrap/app.php file

as described in the docs (without any other configuration step) and the option appears as expected.

Let me know

Cheers

Giacomo

[MrCanan]

Hi,

Thank you for your quick answer,

I tested also from fresh install in 11.5.0 and it works,

So perhaps a problem in my Laravel 11.2.0 installation

In my Laravel 11.2.0, I have the line but the file is not the same,

So I update to 11.5.0 to test also

composer.json

"laravel/framework": "^11.5.0",
"gecche/laravel-multidomain": "^11.0",

I have now exactly the same bootstrap\app.php as you,

After some differents Laravel errors due to this upgrade (so it confirms my previous installation had problems), everything works

Stay as you are and continue your great project =)

Best regards