在Joomla中连接到PGSQL数据库时出错 [英] Error connecting to PGSQL database in Joomla
问题描述
我正在尝试使用Postgres安装Joomla,并且在安装程序中出现以下错误:
I am trying to install Joomla using Postgres and in the installer I have the following error:
Could not connect to the database. Connector returned number: Error connecting to PGSQL database.
这并不能告诉我很多.有什么想法吗?
This isn't telling me very much. Any ideas?
推荐答案
不幸的是,安装程序未返回真正的错误.
Unfortunately the installer does not return the real error.
以下是一些一般提示:
- 确保提供的数据库已经存在
- 检查数据库是否需要某些特定设置,例如其他端口或
sslmode=require
将连接详细信息放入普通的php文件中并运行脚本,并启用错误报告功能:
Put your connection details in a normal php file and run the script, having error reporting enabled:
<?php
$connection = 'host=127.0.0.1 port=5432 dbname=joomla3 user=postgres password=postgres';
$dbconn = pg_connect($connection);
var_dump($dbconn);
运行脚本时,您可能会得到正确的错误.获取资源后,连接成功:resource(4) of type (pgsql link)
When running the script you might get a proper error. When you get a resource, the connection is successful: resource(4) of type (pgsql link)
这篇关于在Joomla中连接到PGSQL数据库时出错的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!