PHP Debug Info";
echo "PHP Version: " . phpversion() . "
";
echo "Loaded INI File: " . php_ini_loaded_file() . "
";
echo "Active PDO Drivers: " . implode(', ', pdo_drivers()) . "
";
echo "
";
echo "Connection Test
";
try {
// Attempt standard connection
$dsn = "pgsql:host=10.10.30.3;port=5432;dbname=nihonbuzz_academy";
$user = "nihonbuzz_user";
$pass = "password_to_be_changed"; // Using the default we set earlier
$pdo = new PDO($dsn, $user, $pass);
echo "✅ Connection SUCCESS!
";
echo "Connected to PostgreSQL database successfully.";
} catch (PDOException $e) {
echo "❌ Connection FAILED
";
echo "Error Message: " . $e->getMessage() . "
";
if (strpos($e->getMessage(), 'could not find driver') !== false) {
echo "
Troubleshooting: The PostgreSQL driver is missing. Verify php.ini settings and restart the web server.";
}
}