[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Install horde in unstable using postgresql



Try as I might, I cant get horde to be installed successfully with
Postgres as the database engine after upgrading to unstable.

The first problem is that it can't get a connection to the postscript
database engine. Postgres log shows

Peer authentication failed for user 'postgres'
Peer authentication failed for user 'postgres'

during configure and the postinst script gives
-----------snip-----------
pgsql extension for php3 found.
Include of /etc/horde/apache.conf found in apache config files.
index.php settings in /etc/apache-ssl/srm.conf found!
index.php3 settings in /etc/apache-ssl/srm.conf found!
Error when trying to connect to the pgsql database.
This error can occur if you have no database to connect to, or
if the password was incorrect.
use: dpkg-reconfigure -plow packagename to reconfigure.
Error when trying to connect to the pgsql database.
This error can occur if you have no database to connect to, or
if the password was incorrect.
use: dpkg-reconfigure -plow packagename to reconfigure.
-----------snip-----------

here is the output of debconf-show:
# debconf-show horde
  horde/dbadmpass: (password omitted)
* horde/database_name: horde
* horde/welcome: 
* horde/webserver_type: Apache-SSL
* horde/database_user: hordemgr
* horde/databasemgr_server: localhost
  horde/dbmyadmin: root
* horde/databasemgr_type: PostgreSQL
* horde/database_pass: (password omitted)
  horde/dbpgadmin: postgres


After adding the line

horde      root     postgres

to /etc/postgres/pg_ident.conf

and the lines

local        horde                                         peer     horde
local        template1                                     peer     horde

to /etc/postgres/pg_hba.conf

the horde postinst script ran ok but when I access the imp page I get

-----------snip-----------
Warning: Unable to connect to PostgresSQL server: IDENT authentication
failed for user 'hordemgr' in /etc/horde/db_pgsql.inc on line 40

Warning: 0 is not a PostgresSQL link index in /etc/horde/db_pgsql.inc on
line 52

Warning: 0 is not a PostgresSQL link index in /etc/horde/db_pgsql.inc on
line 55

Warning: 0 is not a PostgresSQL link index in /etc/horde/db_pgsql.inc on
line 67
-----------snip-----------
repeated three times

ok, I added

host         horde       127.0.0.1     255.255.255.255     password

to /etc/postgres/pg_hba.conf, manually entered a password to pg_shadow
and also entered it in /etc/horde/horde_phplib.inc in the $Password variable
and in /etc/imp/defaults.php3 in the db_password variable.

When I now access the imp page I get 
-----------snip-----------
Warning: PostgresSQL query failed: ERROR: active_sessions: Permission
denied. in /etc/horde/db_pgsql.inc on line 52

Warning: PostgresSQL query failed: ERROR: active_sessions: Permission
denied. in /etc/horde/db_pgsql.inc on line 52

Warning: 0 is not a PostgresSQL result index in /etc/horde/db_pgsql.inc on
line 122

Warning: PostgresSQL query failed: ERROR: active_sessions: Permission
denied. in /etc/horde/db_pgsql.inc on line 52
-----------snip-----------


Now I gave up.

Nils

--
                                     ______
                                    (Muuuhh)
Global Village Sau  ==>        ^..^ |/¯¯¯¯¯
(Kann Fremdsprache) ==>        (oo)

Attachment: pgpZZyKmaHp5j.pgp
Description: PGP signature


Reply to: