I have searched the query all over internet but till have not come up to the solution for this issue. No connector for [mysql]
I have 2 Mysql Connections mysql
and mysql2
. mysql
is to store data and mysql2
to store QUEUE JOBS
.
Here below is the .ENV file details.
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_DATABASE=laravel_5_1
DB_USERNAME=root
DB_PASSWORD=
CACHE_DRIVER=file
SESSION_DRIVER=file
QUEUE_DRIVER=mysql_queue
As you can see the about connection is DB_CONNECTION=mysql
and my Queue driver QUEUE_DRIVER=mysql_queue
I have assigned and new queue driver named mysql_queue
in queue.php
below is the queue.php code
'default' => env('QUEUE_DRIVER', 'mysql_queue'),
'connections' => [
'mysql_queue' => [
'connection' => 'mysql2',
'driver' => 'mysql',
'table' => 'jobs',
'queue' => 'default',
'expire' => 60,
],
]
'failed' => [
'database' => env('DB_CONNECTION', 'mysql_queue'),
'table' => 'failed_jobs',
],
As you can see the mysql_queue
has 'connection' => 'mysql2',
were i would like to store queued jobs. mysql2
is a new connection assiged in database.php below is the code.
'mysql2' => [
'driver' => 'mysql',
'host' => env('DB_HOST', 'localhost'),
'database' => env('DB_DATABASE', 'laravel_5_1_queue'),
'username' => env('DB_USERNAME', 'root'),
'password' => env('DB_PASSWORD', ''),
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
'strict' => false,
],
Even after making these major changes as per laravel documentation i still get 'No connector for [mysql]'
Error and unable to run QUEUED JOBS
in background. kindly suggest me.
Thanks in Advance
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire