'Laravel with sqlserver show warning mysql has gone away
"laravel/framework": "^8.0",
I'm Using laravel and database using sqlserver, but why in my xampp error.log show warning mysql has gone away. even though I don't use mysql at all
[Wed Mar 23 08:10:27.486328 2022] [php7:warn] [pid 4772:tid 15840] [client 182.1.191.8:60458] PHP Warning: Uncaught PDOException: PDO::_construct(): MySQL server has gone away in D:\\xampp\\htdocs\\myproject\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connectors\\Connector.php:70\nStack trace:\n#0 D:\\xampp\\htdocs\\myproject\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connectors\\Connector.php(70): PDO->_construct('mysql:host=192....', 'username', 'password', Array)\n#1 D:\\xampp\\htdocs\\myproject\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connectors\\Connector.php(46): Illuminate\\Database\\Connectors\\Connector->createPdoConnection('mysql:host=192....', 'username', 'password', Array)\n#2 D:\\xampp\\htdocs\\myproject\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connectors\\MySqlConnector.php(24): Illuminate\\Database\\Connectors\\Connector->createConnection('mysql:host=192....', Array, Array)\n#3 D:\\xampp\\htdocs\\myproject\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connectors\\ConnectionFactory.php(184): Illuminate\\Database\\Connectors\\MySqlConnector->connect(Array)\n#4 [internal function]: Illuminate\\Database\\Connectors\\Con in D:\\xampp\\htdocs\\myproject\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connectors\\Connector.php on line 70
[Wed Mar 23 08:10:27.486328 2022] [php7:error] [pid 4772:tid 15840] [client 182.1.191.8:60458] PHP Fatal error: Maximum execution time of 300 seconds exceeded in D:\\xampp\\htdocs\\myproject\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connectors\\Connector.php on line 46
and in my laravel project -> config -> database.php is already remove mysql config.
database.php
'connections' => [
// 'mysql' => [
// 'driver' => 'mysql',
// 'url' => env('DATABASE_URL'),
// 'host' => env('DB_HOST', '127.0.0.1'),
// 'port' => env('DB_PORT', '3306'),
// 'database' => env('DB_DATABASE', 'forge'),
// 'username' => env('DB_USERNAME', 'forge'),
// 'password' => env('DB_PASSWORD', ''),
// 'unix_socket' => env('DB_SOCKET', ''),
// 'charset' => 'utf8mb4',
// 'collation' => 'utf8mb4_unicode_ci',
// 'prefix' => '',
// 'prefix_indexes' => true,
// 'strict' => true,
// 'engine' => null,
// 'options' => extension_loaded('pdo_mysql') ? array_filter([
// PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
// ]) : [],
// ],
'sqlsrv' => [
'driver' => 'sqlsrv',
'url' => env('DATABASE_URL'),
'host' => env('DB_HOST', 'localhost'),
'port' => env('DB_PORT', '1433'),
'database' => env('DB_DATABASE', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'charset' => 'utf8',
'prefix' => '',
'prefix_indexes' => true,
]
],
and this my env
DB_CONNECTION=sqlsrv
DB_HOST=host
DB_PORT=1433
DB_DATABASE=database
DB_USERNAME=username
DB_PASSWORD=password
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
