By Anonymous (not verified) on

I'm using Drupal-4.1.0 and postgresql-server-7.3.2-5mdk on Mandrake Linux 9.1 but I can't connect to my database. My conf.php's important entries are:

$db_url = "pgsql://admin:password@localhost/drupal";
ini_set("include_path", '.:/usr/share/pear/');

But why is it that I can connect to my drupal database using the CLI:

$ psql -U admin drupal

What could be the problem? Drupal's site doesn't have a good documentation for PostgreSQL and I hope anyone could clarify this problem that I encountered.

Thank you in advance.

Comments

ax’s picture

ax commented

see here

Anonymous’s picture

(not verified) commented

Yes, I also installed php-pgsql-4.3.0-4mdk and I believe that's enabled. Below is the output of my phpinfo().

pgsql.allow_persistent On On
pgsql.auto_reset_persistent Off Off
pgsql.ignore_notice Off Off
pgsql.log_notice Off Off
pgsql.max_links Unlimited Unlimited
pgsql.max_persistent Unlimited Unlimited

By the way, below are the list of installed Apache, PHP and PostgreSQL related packages:

[ Apache ]
apache-modules-1.3.27-8mdk
apache-1.3.27-8mdk
apache-conf-2.0.44-11mdk
apache2-common-2.0.44-11mdk
apache-mod_perl-1.3.27_1.27-7mdk

[ PHP ]
php-rrdtool-1.0.40-2mdk
php-snmp-4.3.1-1mdk
php-pgsql-4.3.0-4mdk
libphp_common430-430-11mdk
mod_php-4.3.1-1mdk
php-manual-en-4.3.0-2mdk
php-xml-4.3.0-2mdk
php-xmlrpc-4.3.0-2mdk
php-ini-4.3.0-1mdk
php-cli-4.3.1-11mdk
php-readline-4.3.0-1mdk
php-pear-4.3.0-3mdk
php-gd-4.3.0-2mdk

[ PostgreSQL ]
postgresql-server-7.3.2-5mdk
postgresql-7.3.2-5mdk
postgresql-python-7.3.2-5mdk
postgresql-pl-7.3.2-5mdk
postgresql-contrib-7.3.2-5mdk

Thank you in advance.