Random Database [central] not configured errors

[thevalo]

Random Database [central] not configured errors

[stancl]

Hey!

Thanks for opening the issue. This doesn't seem to be a bug in package, seems to be related to your setup.

If you need quick support, you can visit our Discord community here: https://archte.ch/discord

The issue here is likely that you are telling tenancy to use the central connection but you didn't create it in config/database.php. If you did, then make sure your config cache in production is up to date.

Thanks

[thevalo]

Hey!

Thanks for opening the issue. This doesn't seem to be a bug in package, seems to be related to your setup.

If you need quick support, you can visit our Discord community here: https://archte.ch/discord

The issue here is likely that you are telling tenancy to use the central connection but you didn't create it in config/database.php. If you did, then make sure your config cache in production is up to date.

Thanks

Hello, thanks for the quick reply.

I have nowhere defined central connection, I merely thought that it's managed by the package itself. Strange, though. It happens only acting on central domain from the tenant's context.

[stancl]

It's not. It uses DB_CONNECTION https://github.com/archtechx/tenancy/blob/3.x/assets/config.php#L42 by default and if you want to use a custom one, you can set it in this config.

The package manages the tenant connection, but it needs a central connection to work with — it has no way to create that.

[thevalo]

Hi once again,

as far as I can comprehend, I think this one has to do still with the package. I can reassure that nowhere I have a "central" connection. Please ignore this thread w/o hesitation if you feel like it's ok on the package side, you know, I have no real proof that it's coming from the package.

However, please see the following screenshot:

Sorry for any incovenience caused. I am not finding anything related in the internet about this problem. On other projects, it does not happen at all.

[stancl]

Check that the environment variable and the config key I linked are set properly.

[thevalo]

The current value of DB_CONNECTION in my .env is mysql, so it's: DB_CONNECTION=mysql.

I am not sure if I can comprehend what should I verify.

EDIT: so in the tenancy.php config file, I should modify the central value akin to .env, meaning mysql?

[stancl]

I'm asking what the config key looks like, not saying you should modify it.

[thevalo]

It is exactly the same as you've shown in the link: 'central_connection' => env('DB_CONNECTION', 'central'),

[stancl]

No idea then, something else must be misconfigured on your end.

[thevalo]

Shouldn't that be exactly as "DB_DONNECTION" of the .env? Maybe a cache miss here-and-there, and when it can't get the value from .env using env() method, it gets "central" DB even though it's not correct.

Thank you for assistance, though.