@MikeJ
Can you please share you composer.json and composer.lock file.
Also, share your .env file with your setup details.
I've attached a code that will help us in debugging the database connection issues. Please copy and paste it to the ./src/Console/ directory relative to the project and then run the following command from the terminal:
php bin/console uvdesk:test:validate-database-credentials;
This command will use the currently available credentials and establish a connection with your database server. In case of issue, it will output the used credentials that you can cross-verify to ensure they are valid. In case the credentials are valid, then in order to proceed further and resolve this issue, we will need you to either provide us with temporary access to your server where the project is hosted, or share with us temporary access credentials to your database server that we can use to debug any connection related issues in the project at our end locally.
<?php
namespace App\Console;
use Doctrine\DBAL\DBALException;
use Doctrine\ORM\EntityManagerInterface;
use Symfony\Component\Dotenv\Dotenv;
use Symfony\Component\Console\Command\Command;
use Symfony\Component\Console\Input\ArrayInput;
use Symfony\Component\Console\Output\NullOutput;
use Symfony\Component\Console\Input\InputArgument;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;
use Symfony\Component\DependencyInjection\ContainerInterface;
use Symfony\Component\Console\Question\ConfirmationQuestion;
class ValidateDatabaseCredentials extends Command
{
public function __construct(ContainerInterface $container, EntityManagerInterface $entityManager)
{
$this->container = $container;
$this->entityManager = $entityManager;
parent::__construct();
}
protected function configure()
{
$this
->setName('uvdesk:test:validate-database-credentials')
->setDescription('Review database connection parameters and report and issues encountered while establishing a connection with database.')
;
}
protected function execute(InputInterface $input, OutputInterface $output)
{
if ('dev' != $this->container->get('kernel')->getEnvironment()) {
throw new \Exception("\nThis command is only allowed to be used in development environment.", 500);
}
if (false == $this->isDatabaseConfigurationValid()) {
$connection = $this->entityManager->getConnection();
$database = $connection->getDatabase();
$output->writeln("\n<comment>Unable to establish a connection with database. Please review the credentials in .env(.local) configuration files accordingly.</comment>\n");
$helper = $this->getHelper('question');
$question = new ConfirmationQuestion('Display database connection credentials?', false);
if (!$helper->ask($input, $output, $question)) {
$params = $connection->getParams();
$output
->writeln([
"",
"Connection URL:\t\t{$params['url']}",
"Database Name:\t\t{$params['dbname']}",
"Database Driver:\t{$params['driver']}",
"Host:\t\t\t{$params['host']}",
"Port:\t\t\t{$params['port']}",
"User:\t\t\t{$params['user']}",
"Password:\t\t{$params['password']}",
"Server Version:\t\t{$params['serverVersion']}",
"",
])
;
$output->writeln([
"Please review and ensure that these database credentials are valid before proceeding.",
"In case the credentials are correct, please ensure that your database is not behind a firewall that could be interfering while trying to establish a connection.",
"",
]);
}
return Command::SUCCESS;
}
$database = $this->entityManager->getConnection()->getDatabase();
$output->writeln("\nNo issues found establishing a connection with database <info>$database</info>.\n");
return Command::SUCCESS;
}
private function isDatabaseConfigurationValid()
{
$databaseConnection = $this->entityManager->getConnection();
if (false === $databaseConnection->isConnected()) {
try {
$databaseConnection->connect();
} catch (DBALException $e) {
return false;
}
}
return true;
}
}
peopleinside