[imp] DB problems

Søren Schimkat schimkat@musik.auc.dk
Sun, 08 Sep 2002 20:01:12 +0200


Hi everyone

I'm having problems with getting started using IMP with postgresql as
backend. I keep getting this message:


------------------------------------
A fatal error has occurred:
DB Error: connect failed [line 102 of /var/www/horde/lib/Prefs/sql.php]
Details have been logged for the administrator.
------------------------------------


I'm running horde on Redhat 7.2 and the database seems to work fine when
I do this:


------------------------------------
[root@schimkat config]# psql -u horde
psql: Warning: The -u option is deprecated. Use -U.
Username: horde 
Password: 
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

horde=> 
------------------------------------


The configuration looks like this:


------------------------------------
$conf['prefs']['driver'] = 'sql';
$conf['prefs']['params'] = array();
$conf['prefs']['params']['phptype'] = 'pgsql';
$conf['prefs']['params']['hostspec'] = 'schimkat.dk';
$conf['prefs']['params']['username'] = 'horde';
$conf['prefs']['params']['password'] = '';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_prefs';
------------------------------------


Please help me out on this one.

Regards Søren Schimkat